Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus | qSpecies | qAddress | qSiteInfo | PlantType ▲ | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 4548 | 4548 | 3 | 43 | 830 Oak St | 5 | 3 | 2 | ||
| 5154 | 5154 | 1 | 17 | 15 Liberty St | 18 | 3 | 1 | Permit Number 780777 | |
| 123910 | 123910 | 7 | 458 | 325 Sanchez St | 5 | 3 | 4 | 1 | |
| 240 | 240 | 5 | 64 | 161 Lundys Ln | 7 | 2 | 1 | ||
| 443 | 443 | 2 | 54 | 3789 Market St | 5 | 2 | 1 | ||
| 452 | 452 | 2 | 26 | 275 Grattan St | 1 | 2 | 1 | ||
| 458 | 458 | 2 | 26 | 275 Grattan St | 1 | 2 | 1 | ||
| 496 | 496 | 2 | 26 | 275 Grattan St | 1 | 2 | 1 | ||
| 963 | 963 | 2 | 50 | 39 Jones St | 1 | 2 | 1 | ||
| 970 | 970 | 2 | 50 | 39 Jones St | 1 | 2 | 1 | ||
| 1361 | 1361 | 3 | 26 | 950X Noriega St | 11 | 2 | 2 | ||
| 1389 | 1389 | 1 | 54 | 2100X 20th St | 1 | 2 | 1 | ||
| 1391 | 1391 | 1 | 54 | 2100X 20th St | 1 | 2 | 1 | ||
| 1666 | 1666 | 2 | 98 | 2253 Broderick St | 1 | 2 | 1 | ||
| 1800 | 1800 | 1 | 54 | 1560 Sanchez St | 1 | 2 | 1 | Permit Number 780193 | |
| 2270 | 2270 | 1 | 54 | 1201 Tennessee St | 1 | 2 | 1 | ||
| 3170 | 3170 | 1 | 141 | 1175 Kirkham St | 1 | 2 | 1 | Permit Number 780657 | |
| 3287 | 3287 | 1 | 11 | 1321 Mission St | 1 | 2 | 1 | Permit Number 775218 | |
| 3292 | 3292 | 1 | 11 | 1321 Mission St | 1 | 2 | 1 | Permit Number 775218 | |
| 3295 | 3295 | 1 | 11 | 1321 Mission St | 1 | 2 | 1 | Permit Number 775218 | |
| 3305 | 3305 | 1 | 11 | 1321 Mission St | 1 | 2 | 1 | Permit Number 775218 | |
| 3598 | 3598 | 2 | 108 | 101 Rivoli St | 1 | 2 | 1 | ||
| 3639 | 3639 | 1 | 54 | 559 24th Ave | 5 | 2 | 1 | ||
| 3643 | 3643 | 1 | 54 | 559 24th Ave | 1 | 2 | 1 | ||
| 3650 | 3650 | 1 | 54 | 559 24th Ave | 5 | 2 | 1 | ||
| 3660 | 3660 | 1 | 54 | 559 24th Ave | 5 | 2 | 1 | ||
| 4723 | 4723 | 1 | 54 | 2975 Van Ness Ave | 5 | 2 | 1 | ||
| 4726 | 4726 | 1 | 54 | 2975 Van Ness Ave | 5 | 2 | 1 | ||
| 10092 | 10092 | 1 | 54 | 450 Toland St | 1 | 2 | 1 | ||
| 10093 | 10093 | 1 | 54 | 450 Toland St | 1 | 2 | 1 | ||
| 10096 | 10096 | 1 | 54 | 450 Toland St | 1 | 2 | 1 | ||
| 10097 | 10097 | 1 | 54 | 450 Toland St | 1 | 2 | 1 | ||
| 10098 | 10098 | 1 | 54 | 450 Toland St | 1 | 2 | 1 | ||
| 10101 | 10101 | 1 | 54 | 450 Toland St | 1 | 2 | 1 | ||
| 10104 | 10104 | 1 | 54 | 450 Toland St | 1 | 2 | 1 | ||
| 10106 | 10106 | 1 | 54 | 450 Toland St | 1 | 2 | 1 | ||
| 10638 | 10638 | 1 | 17 | 1 | 2 | 1 | Permit Number 767856 | ||
| 11641 | 11641 | 1 | 17 | 1 | 2 | 1 | |||
| 13970 | 13970 | 3 | 284 | 1967 Palou Ave | 1 | 2 | 2 | ||
| 16044 | 16044 | 1 | 17 | 1 | 2 | 1 | |||
| 20483 | 20483 | 1 | 54 | 2502X Bush St | 5 | 2 | 1 | ||
| 24006 | 24006 | 2 | 284 | 725 18th St | 9 | 2 | 1 | ||
| 25407 | 25407 | 17 | 211 Maynard St | 8 | 2 | 1 | |||
| 34525 | 34525 | 2 | 284 | 725 18th St | 9 | 2 | 1 | ||
| 41228 | 41228 | 2 | 284 | 727 41st Ave | 1 | 2 | 1 | ||
| 42994 | 42994 | 1 | 54 | 3211 Baker St | 9 | 2 | 1 | ||
| 46600 | 46600 | 3 | 19 | 131 LAKESHORE DR | 3 | 2 | 2 | ||
| 49594 | 49594 | 1 | 54 | 1534 Hayes St | 1 | 2 | 1 | ||
| 50491 | 50491 | 2 | 17 | 2400X 25th Ave | 1 | 2 | 1 | 11 | Permit Number 773973 |
| 52224 | 52224 | 2 | 284 | 16 Tiffany Ave | 4 | 2 | 1 | ||
| 79071 | 79071 | 17 | 27 Hartford St | 8 | 2 | 1 | |||
| 79103 | 79103 | 5 | 64 | 385 Nevada St | 5 | 2 | 1 | ||
| 79393 | 79393 | 1 | 17 | 366 Hill St | 1 | 2 | 1 | Permit Number 772751 | |
| 79432 | 79432 | 5 | 64 | 507 STEINER ST | 7 | 2 | 1 | ||
| 79753 | 79753 | 2 | 98 | 125 VILLA TER | 1 | 2 | 1 | ||
| 80289 | 80289 | 1 | 11 | 606 Webster St | 1 | 2 | 1 | Permit Number 52423 | |
| 80534 | 80534 | 1 | 17 | 1294 Union St | 6 | 2 | 1 | ||
| 80672 | 80672 | 7 | 17 | 244 Glenview Dr | 13 | 2 | 1 | ||
| 80680 | 80680 | 2 | 64 | 400 PERALTA AVE | 7 | 2 | 1 | ||
| 81163 | 81163 | 1 | 54 | 525X Church St | 5 | 2 | 4 | 4 | |
| 81298 | 81298 | 1 | 54 | 739 27th St | 1 | 2 | 1 | ||
| 81307 | 81307 | 1 | 82 | 898 Steiner St | 1 | 2 | 1 | Permit Number 54088 | |
| 81443 | 81443 | 1 | 18 | 591 Waller St | 1 | 2 | 1 | Permit Number 769031 | |
| 81722 | 81722 | 1 | 54 | 525X Church St | 1 | 2 | 4 | 4 | |
| 82393 | 82393 | 1 | 7 | 129 Ellert St | 1 | 2 | 1 | 1 | Permit Number 773054 |
| 82677 | 82677 | 1 | 17 | 188 Spear St | 1 | 2 | 1 | ||
| 82720 | 82720 | 7 | 17 | 190 Portola Dr | 13 | 2 | 1 | ||
| 83041 | 83041 | 1 | 54 | 1205 Filbert St | 5 | 2 | 1 | 1 | |
| 83840 | 83840 | 2 | 54 | 360 Spear St | 1 | 2 | 1 | ||
| 84066 | 84066 | 1 | 51 | 2233 28th Ave | 1 | 2 | 1 | Permit Number 52332 | |
| 84402 | 84402 | 5 | 253 | 2505 Pacific Ave | 5 | 2 | 1 | ||
| 84751 | 84751 | 1 | 18 | 1363 Francisco St | 1 | 2 | 1 | Permit Number 52338 | |
| 85124 | 85124 | 1 | 19 | 1403 11th Ave | 5 | 2 | 1 | Tree 2. Permit Number 49495. | |
| 85310 | 85310 | 1 | 54 | 2660 Harrison St | 5 | 2 | 1 | ||
| 85779 | 85779 | 1 | 134 | 200 McAllister St | 1 | 2 | 1 | Permit Number 773269 | |
| 85839 | 85839 | 1 | 54 | 2660 Harrison St | 5 | 2 | 1 | ||
| 86139 | 86139 | 1 | 17 | 3170 23rd St | 5 | 2 | 1 | Permit Number 770875 | |
| 86307 | 86307 | 1 | 17 | 201 Upper Ter | 5 | 2 | 1 | ||
| 86544 | 86544 | 1 | 17 | 120 Howard St | 1 | 2 | 1 | ||
| 87250 | 87250 | 1 | 17 | 230 Seacliff Ave | 21 | 2 | 1 | ||
| 87791 | 87791 | 1 | 17 | 120 Howard St | 1 | 2 | 1 | ||
| 87925 | 87925 | 1 | 54 | 45 Hoffman Ave | 1 | 2 | 1 | ||
| 88689 | 88689 | 1 | 54 | 1801 Scott St | 5 | 2 | 1 | ||
| 88984 | 88984 | 1 | 54 | 601 Steiner St | 5 | 2 | 1 | ||
| 89166 | 89166 | 7 | 17 | 267 Topaz Way | 13 | 2 | 1 | ||
| 89308 | 89308 | 1 | 241 | 333 El Camino Del Mar | 5 | 2 | 1 | Permit Number 770205 | |
| 90472 | 90472 | 2 | 98 | 1387 08th Ave | 10 | 2 | 1 | ||
| 91008 | 91008 | 6 | 43 | 758 10th Ave | 1 | 2 | 1 | ||
| 91154 | 91154 | 1 | 54 | 1205 Filbert St | 1 | 2 | 1 | 1 | |
| 91444 | 91444 | 2 | 17 | 92 Homestead St | 5 | 2 | 1 | Permit Number 773562 | |
| 92261 | 92261 | 3 | 98 | 2634 37TH AVE | 3 | 2 | 2 | ||
| 92510 | 92510 | 1 | 461 | 94 Danton St | 5 | 2 | 1 | Permit Number 51634 | |
| 92559 | 92559 | 1 | 4 | 2701 Pacific Ave | 5 | 2 | 1 | Permit Number 52996 | |
| 92708 | 92708 | 1 | 19 | 1403 11th Ave | 5 | 2 | 1 | Tree 1 | |
| 92935 | 92935 | 1 | 54 | 525X Church St | 1 | 2 | 4 | 4 | |
| 94304 | 94304 | 1 | 17 | 3098 PACIFIC AVE | 5 | 2 | 1 | ||
| 94709 | 94709 | 2 | 98 | 391 NEVADA ST | 14 | 2 | 1 | ||
| 94734 | 94734 | 7 | 17 | 216 Glenview Dr | 13 | 2 | 1 | ||
| 94853 | 94853 | 1 | 54 | 217 Montcalm St | 7 | 2 | 1 | ||
| 95495 | 95495 | 1 | 54 | 525X Church St | 5 | 2 | 4 | 4 |
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");