Street_Tree_List_fts

Data source: data.sfgov.org

189,144 rows sorted by qCaretaker

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
4 2 4 920 Kirkham St 1 1 1    
6 1 1 501X Baker St 1 1 1    
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
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    
30 4 9 43 Lafayette St 4 1 1   Permit Number 772992
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
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    
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    
70 4 26 1388x Minna St 1 1 1    
71 2 18 270 Trumbull St 1 1 1    
73 1 18 1051 Bush St 1 1 1 1 Permit Number 28361
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
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
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    
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
101 2 11 1399X Mission St 1 1 1    
102 5 26 1384X Grove St 1 1 1   Permit Number 767782
103 1 38   1 1 1   Permit Number 776915
107 2 26 1384X GROVE ST 1 1 1    
108 2 11 1399X Mission St 1 1 1    
110 2 2 1824 Noriega St 1 1 1    
111 1 15 400X Franklin St 1 1 1    
113 1 41 1341 42nd Ave 1 1 1    
114 6 1 399X Townsend St 5 1 1    
115 1 26 700 Fell St 1 1 1    
116 1 32 220 Richardson Ave 1 1 1    
118 6 1 399X Townsend St 5 1 1    
120 1 44 2123 Pierce St 1 1 1   Permit Number 774924
121 1 2 1201 Palou Ave 1 1 1 1 Permit Number 19293
122 1 45 1341 42nd Ave 1 1 1    
125 2 22 151X Octavia St Frontage West 1 1 1    
128 2 16 115 Beverly St 9 1 1    
130 1 22 2041 Hayes St 1 1 1 1 Permit Number 30161

Next page

Advanced export

JSON shape: default, array, newline-delimited

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 1542.005ms · Data source: data.sfgov.org