Street_Tree_List_fts

Data source: data.sfgov.org

189,144 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ qLegalStatus qSpecies qAddress qSiteInfo PlantType qCaretaker qCareAssistant PermitNotes
101 101 2 11 1399X Mission St 1 1 1    
102 102 5 26 1384X Grove St 1 1 1   Permit Number 767782
103 103 1 38   1 1 1   Permit Number 776915
104 104 3 39 1170 Ingalls St 1 1 2    
105 105 3 5 1315 Ellis St 1 1 2    
106 106 3 36 906 Hayes St 1 1 2    
107 107 2 26 1384X GROVE ST 1 1 1    
108 108 2 11 1399X Mission St 1 1 1    
109 109 3 40 1800X Pine St 1 1 2    
110 110 2 2 1824 Noriega St 1 1 1    
111 111 1 15 400X Franklin St 1 1 1    
112 112 3 11 1800X Pine St 1 1 2    
113 113 1 41 1341 42nd Ave 1 1 1    
114 114 6 1 399X Townsend St 5 1 1    
115 115 1 26 700 Fell St 1 1 1    
116 116 1 32 220 Richardson Ave 1 1 1    
117 117 3 42 929 Valencia St 1 1 2   Permit Number 24134
118 118 6 1 399X Townsend St 5 1 1    
119 119 3 43 175X Otis St 1 1 2    
120 120 1 44 2123 Pierce St 1 1 1   Permit Number 774924
121 121 1 2 1201 Palou Ave 1 1 1 1 Permit Number 19293
122 122 1 45 1341 42nd Ave 1 1 1    
123 123 3 41 2621 Sacramento St 1 1 2    
124 124 3 2 20X Sunset Blvd 1 1 2    
125 125 2 22 151X Octavia St Frontage West 1 1 1    
126 126 3 11 700 Valencia St 1 1 2    
127 127 3 46 2840 Pine St 1 1 2    
128 128 2 16 115 Beverly St 9 1 1    
129 129 3 47 262X Sunset Blvd 1 1 2    
130 130 1 22 2041 Hayes St 1 1 1 1 Permit Number 30161
131 131 3 18 100 Octavia St 4 1 2    
132 132 1 44 270 Brannan St 5 1 1    
133 133 2 23 742 Myra Way 1 1 1   Permit Number 779535
134 134 1 12 54X Cayuga Ave 1 1 1   Permit Number 45390
135 135 3 18 100 Octavia St 4 1 2    
136 136 2 17 120 Ortega St 1 1 1   Permit Number 779661
137 137 3 11 700 Valencia St 1 1 2    
138 138 4 44 270 Brannan St 5 1 1   Permit Number 770847
139 139 4 44 270 Brannan St 5 1 1    
140 140 3 2 1916 Ellis St 1 1 2    
141 141 3 48 1396 47th Ave 1 1 2    
142 142 2 34 2305 Golden Gate Ave 1 1 1    
143 143 3 32 2055 Sacramento St 1 1 2    
144 144 1 48 4134 Judah St 1 1 1    
145 145 2 49 1498x Kansas St 1 1 1   Permit Number 779654
146 146 1 48 1038 Taraval St 1 1 1    
147 147 1 48 4026 Irving St 1 1 1   Permit Number 16988
148 148 3 2 80X Junipero Serra Blvd 1 1 2    
149 149 3 50 247 Orizaba Ave 1 1 2    
150 150 3 48 4200x Judah St 1 1 2    
151 151 1 33   1 1 1   Permit Number 39461
152 152 3 48 1395 47th Ave 1 1 2    
153 153 3 26 1550 Eddy St 1 1 2    
154 154 3 51 1384 47th Ave 1 1 2    
155 155 2 52 1 Yukon St 1 1 1    
156 156 1 48 4508 Irving St 1 1 1   Permit Number 10547
157 157 1 15 3698 California St 1 1 1    
158 158 3 35 1830 Sutter St 1 1 2    
159 159 1 48 1055 Taraval St 1 1 1    
160 160 3 53 80X Junipero Serra Blvd 1 1 1    
161 161 2 54 1170 COLUMBUS AVE 1 1 1    
162 162 2 3 164 Serrano Dr 1 1 1    
163 163 3 51 242 Broad St 1 1 2    
164 164 1 48 1011 Taraval St 1 1 1    
165 165 3 48 4000 Judah St 1 1 2    
166 166 2 55 99x Ogden Ave 1 1 1    
167 167 2 55 99x Ogden Ave 1 1 1    
168 168 2 25 100 Serrano Dr 2 1 1    
169 169 1 17 2401X Washington St 1 1 1   Permit Number 778039
170 170 1 11 435 Pacific Ave 1 1 1   Permit Number 46051
171 171 2 34 2449 Golden Gate Ave 5 1 1    
172 172 1 17   1 1 1   Permit Number 45761
173 173 3 2 80x Junipero Serra Blvd 1 1 2    
174 174 2 56 1 Yukon St 1 1 1    
175 175 3 41 2205 Pine St 1 1 2    
176 176 3 11 2030 Fell St 1 1 2    
177 177 1 48 1000 Taraval St 1 1 1    
178 178 3 15 2253 California St 1 1 2    
179 179 3 48 1101 Taraval St 1 1 2    
180 180 1 15 100X Richardson Ave 1 1 1    
181 181 3 32 1900 Gough St 1 1 2    
182 182 3 57 1739 Taraval St 1 1 2    
183 183 3 32 2125 Mission St 1 1 2    
184 184 1 22 2375 PINE ST 1 1 1    
185 185 2 58 299x Chapman St 1 1 2    
186 186 3 59 2060 SUTTER ST 1 1 2    
187 187 3 60 829 Chenery St 1 1 2    
188 188 3 59 2060 SUTTER ST 1 1 2    
189 189 3 46 2355 PINE ST 1 1 2    
190 190 1 21 2898 Clay St 1 1 1   Permit Number 773671
191 191 2 1 365 San Leandro Way 1 1 1   Permit Number 779799
192 192 3 59 2060 SUTTER ST 1 1 2    
193 193 1 2 1930 Eddy St 1 1 1    
194 194 1 46 2375 PINE ST 1 1 1    
195 195 3 59 2060 SUTTER ST 1 1 2    
196 196 3 2 722X Mendell St 1 1 2    
197 197 3 60 701 Chenery St 1 1 2    
198 198 3 21 1221 Polk St 10 1 2    
199 199 3 59 2060 SUTTER ST 1 1 2    
200 200 1 15 99 Grove St 1 1 5    

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