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
201 3 59 2060 SUTTER ST 1 1 2    
202 3 22 2355 PINE ST 1 1 2    
203 1 15 99 Grove St 1 1 5    
204 1 17   1 1 1   Permit Number 21392
205 1 15 99 Grove St 1 1 5    
206 1 32 1201 Columbus Ave 1 1 1    
207 3 46 2355 PINE ST 1 1 2    
208 2 61 3701 Buchanan St 1 1 1    
209 1 15 99 Grove St 1 1 5    
210 3 15 2X Market St 1 1 2    
211 3 59 2060 SUTTER ST 1 1 2    
212 3 22 2375 PINE ST 1 1 2    
213 3 35 1300 Webster St 11 1 2    
214 1 15 99 Grove St 1 1 5    
215 3 21 2235X Octavia St 11 1 2    
216 3 59 2060 SUTTER ST 1 1 2    
217 3 59 2060 SUTTER ST 1 1 2    
218 3 2 722X Mendell St 1 1 2    
219 3 46 2375 PINE ST 1 1 2    
220 3 59 2060 SUTTER ST 1 1 2    
221 3 59 2060 SUTTER ST 1 1 2    
222 3 2 722X Mendell St 1 1 2    
223 3 62 1100X Webster St 11 1 2    
224 4 2 168 Hyde St 1 1 1   Permit Number 777550
225 3 46 2355 PINE ST 1 1 2    
226 1 6 217 Douglass St 1 1 1   Permit Number 11470
227 3 15 562 Market St 1 1 2    
228 3 59 2125 Mission St 1 1 2    
229 1 46 2375 PINE ST 1 1 1    
230 3 59 2060 SUTTER ST 1 1 2    
231 3 59 2060 SUTTER ST 1 1 2    
232 1 28 2211 Bush St 1 1 1    
233 2 16 91 Commonwealth Ave 1 1 1   Permit Number 778926
234 3 26 1570 Golden Gate Ave 1 1 2    
235 1 17   1 1 1   Permit Number 44451
236 1 6 841 Fulton St 1 1 1    
237 3 22 1988 Bush St 1 1 2    
238 3 63 321X Corbett Ave 7 1 2    
239 3 63 321X Corbett Ave 7 1 2    
240 5 64 161 Lundys Ln 7 2 1    
241 2 65 1748x Eucalyptus Dr 9 1 1    
242 3 2 717 Mendell St 1 1 2    
243 3 15 1834 California St 1 1 2    
244 3 2 1809 Gough St 1 1 2    
245 2 17 4089x Alemany Blvd 1 1 1    
246 3 21 1350 Howard St 1 1 2    
247 3 63 321X Corbett Ave 7 1 2    
248 3 15 800X Webster St 11 1 2    
249 2 66 330 09th Ave 12 1 6    
250 3 9 507 Divisadero St 1 1 2    
251 2 65 1748x Eucalyptus Dr 9 1 1    
252 3 17 1674 27th Ave 1 1 2    
253 2 67 4091x Alemany Blvd 1 1 1    
254 2 21 1813 Baker St 1 1 1   Permit Number 777656
255 3 24 100 STAIRWAY24 1 1 2    
256 2 68 3164 25th St 1 1 1    
257 2 9 1163 South Van Ness Ave 1 1 1    
258 2 69 1050x Sacramento St 1 1 1    
259 2 55 1499X Hayes St 1 1 1    
260 2 68 3164 25th St 1 1 1    
261 2 41 1499X Hayes St 1 1 1    
262 2 55 1499X Hayes St 1 1 1    
263 2 1 1499X Hayes St 1 1 1    
264 3 26 1300X Steiner St 1 1 2    
265 2 19 900x Chestnut St 5 1 1    
266 2 17 1200 04th St 1 1 1   Permit Number 779409
267 2 70 285 Santa Rosa Ave 1 1 1   Permit Number 779495
268 1 11 35 San Juan Ave 1 1 1 1 Permit Number 779460
269 3 32 2101 Van Ness Ave 1 1 2    
270 1 16 639 Divisadero St 1 1 1    
271 2 70 285 Santa Rosa Ave 1 1 1   Permit Number 779495
272 6 47 3630x 19th Ave 9 1 1   Permit Number 779147
273 3 59 1155X Steiner St 1 1 2    
274 2 17 1200 04th St 1 1 1   Permit Number 779409
275 3 2 1385 45th Ave 1 1 2    
276 2 17 1201 04th St 1 1 1   Permit Number 779410
277 6 47 3630x 19th Ave 9 1 1   Permit Number 779147
278 3 22 1350 Golden Gate Ave 1 1 2    
279 1 17   1 1 1   Permit Number 45761
280 2 71 905 Minna St 1 1 1    
281 3 11 300X Gough St 1 1 2    
282 2 17 1200 04th St 1 1 1   Permit Number 779409
283 2 17 1200 04th St 1 1 1   Permit Number 779409
284 1 59 1125 Steiner St 1 1 1    
285 2 72 1904 Filbert St 1 1 1    
286 3 55 995 Guerrero St 1 1 2    
287 2 17 1200 04th St 1 1 1   Permit Number 779409
288 3 32 320 Dolores St 1 1 2    
289 2 17 1200 04th St 1 1 1   Permit Number 779409
290 2 17 1201 04th St 1 1 1   Permit Number 779410
291 3 55 2101 Van Ness Ave 1 1 2    
292 3 11 701X Golden Gate Ave 1 1 2   Permit Number 767203
293 6 47 3630x 19th Ave 9 1 1   Permit Number 779147
294 5 12 10x Paloma Ave 1 1 1    
295 3 73 310 Dolores St 1 1 2    
296 3 59 2725 Pine St 1 1 2    
297 1 17 1683 Hayes St 1 1 1   Permit Number 779644
298 2 17 1200 04th St 1 1 1   Permit Number 779409
299 2 18 25 McLea Ct 1 1 1    
300 6 47 3630x 19th Ave 9 1 1   Permit Number 779147

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