home / sf-trees

Street_Tree_List_fts

Data source: data.sfgov.org

189,144 rows

View and edit SQL

Link rowid qLegalStatus qSpecies qAddress qSiteInfo PlantType qCaretaker qCareAssistant PermitNotes
1 1 1 501X Baker St 1 1 1   Permit Number 25401
2 2 2 940 Elizabeth St 2 1 1   Permit Number 779625
3 3 3 495X Lakeshore Dr 3 1 2    
4 2 4 920 Kirkham St 1 1 1    
5 3 5 1501 Evans Ave 4 1 2    
6 1 1 501X Baker St 1 1 1    
7 3 5 1301 Evans Ave 4 1 2    
8 1 6 300x Hickory St 1 1 1    
9 2 7 920 Kirkham St 1 1 1    
10 1 8 301x Hickory St 1 1 1    
11 1 6 300x Hickory St 1 1 1    
12 1 6 300x Hickory St 1 1 1    
13 1 6 300x Hickory St 1 1 1    
14 4 9 43 Lafayette St 4 1 1   Permit Number 772992
15 4 9 43 Lafayette St 4 1 1   Permit Number 772992
16 1 6 300x Hickory St 1 1 1    
17 2 10 730 11th Ave 1 1 1   Permit Number 779614
18 2 11 168 Cervantes Blvd 1 1 1   Permit Number 767919
19 2 12 1471 28th Ave 1 1 1    
20 4 13 1043 Minna St 5 1 1    
21 4 13 1043 Minna St 5 1 1    
22 2 7 910 Kirkham St 1 1 1    
23 1 14 1555 40th Ave 1 1 1   Permit Number 777142
24 3 11 5280 03rd St 1 1 2    
25 3 15 2975 Van Ness Ave 1 1 2    
26 1 16 4200 23rd St 1 1 1   Permit Number 43111
27 5 17 342 Scott St 2 1 1   Permit Number 779666
28 1 15 2741 Taylor St 1 1 1    
29 3 5 1300 Evans Ave 4 1 2    
30 4 9 43 Lafayette St 4 1 1   Permit Number 772992
31 1 5 1001 Turk St 1 1 3    
32 3 11 1359 Hudson Ave 1 1 2    
33 1 15 1545 California St 1 1 1    
34 2 18 20 Lily St 1 1 1    
35 2 1 2562 26th Ave 2 1 1   Permit Number 779639
36 3 15 2X Market St 1 1 2    
37 2 19 1 Newburg St 6 1 1    
38 2 11 1390 Mission St 1 1 1    
39 1 11 101 Cargo Way 1 1 1    
40 2 20 1 Newburg St 1 1 1    
41 2 11 1390 Mission St 1 1 1    
42 3 21 3014 Sacramento St 1 1 1   Permit Number 54020
43 2 20 1 Newburg St 1 1 1    
44 2 19 1 Newburg St 6 1 1    
45 1 2 3201 California St 1 1 1    
46 3 22 1737-1795 Post St 1 1 2    
47 3 23 150 Otis St 1 1 2    
48 3 11 201X Cargo Way 1 1 2    
49 2 19 3042 Steiner St 5 1 1    
50 5 17 632 HAYES ST 2 1 1   Permit Number 779650
51 1 17   1 1 1   Permit Number 20649
52 2 24 1021 Noe St 1 1 1    
53 2 25 1 Baker St 1 1 1    
54 4 26 1388x Minna St 1 1 1    
55 1 15 1700 California St 1 1 1    
56 1 26 988 Fulton St 1 1 1    
57 1 17   1 1 1   Permit Number 43835
58 1 5 1255 Columbus Ave 1 1 1    
59 1 17   1 1 1   Permit Number 43922
60 4 26 1388x Minna St 1 1 1    
61 2 27 1 Newburg St 6 1 1    
62 2 9 10 12th St 1 1 1    
63 2 28 1 Newburg St 1 1 1   Permit Number 779491
64 2 11 1614 Broderick St 1 1 1    
65 2 19 1 Newburg St 6 1 1    
66 2 20 1 Newburg St 1 1 1    
67 1 29 520 Jersey St 1 1 1   Permit Number 18521
68 2 25 1 Baker St 1 1 1    
69 3 30 630 Sansome St 1 1 2    
70 4 26 1388x Minna St 1 1 1    
71 2 18 270 Trumbull St 1 1 1    
72 3 15 729 Grove St 1 1 2    
73 1 18 1051 Bush St 1 1 1 1 Permit Number 28361
74 3 5 2175X Palou Ave 1 1 2    
75 1 15 729 GROVE ST 1 1 1    
76 1 31 300 Duboce Ave 7 1 1   Permit Number 43693
77 1 17 145 Missouri St 1 1 1 1 Permit Number 779552
78 6 3 900X 14th St 7 1 1    
79 2 2 2000X Market St 5 1 1    
80 1 32 4425 18th St 1 1 1   Permit Number 47310
81 2 28 55 Homestead St 1 1 1   Permit Number 778991
82 1 31 300 Duboce Ave 7 1 1   Permit Number 43693
83 2 21 3660 Jackson St 1 1 1   Permit Number 779583
84 1 33   1 1 1   Permit Number 39461
85 1 5 1001 Turk St 1 1 3    
86 6 34 4357x Mission St 7 1 1   Permit Number 774415
87 1 32 1500 Hyde St 1 1 1    
88 2 2 4115 Kirkham St 1 1 1    
89 1 17 1493 Hudson Ave 1 1 1    
90 1 31 300 Duboce Ave 7 1 1   Permit Number 43693
91 1 31 300 Duboce Ave 7 1 1   Permit Number 43693
92 3 35 2X Frank Norris St 1 1 4 2  
93 6 3 900X 14th St 7 1 1    
94 2 36 1051 Ingalls St 1 1 1    
95 6 3 900X 14th St 7 1 1   Permit Number 779570
96 6 3 900X 14th St 8 1 1    
97 3 26 1245 Divisadero St 1 1 2    
98 2 26 1384X GROVE ST 1 1 1    
99 1 9 2247 Franklin St 1 1 1    
100 1 37 2200 Lyon St 1 1 1   Permit Number 773028

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE VIRTUAL TABLE "Street_Tree_List_fts" USING FTS4 ("qLegalStatus", "qSpecies", "qAddress", "qSiteInfo", "PlantType", "qCaretaker", "qCareAssistant", "PermitNotes", content="Street_Tree_List")
Powered by Datasette · Query took 399.766ms · Data source: data.sfgov.org