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