Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus | qSpecies ▲ | qAddress | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 186005 | 186005 | 2 | 562 | 35 Yukon St | 1 | 1 | 1 | ||
| 185862 | 185862 | 2 | 561 | 38 Nebraska St | 1 | 1 | 1 | ||
| 185138 | 185138 | 2 | 560 | 139 Duncan St | 1 | 1 | 1 | ||
| 184767 | 184767 | 2 | 559 | 483 Valley St | 2 | 1 | 1 | ||
| 184389 | 184389 | 2 | 558 | 1735 Mission St | 1 | 1 | 1 | ||
| 179168 | 179168 | 2 | 557 | 401 Valley St | 17 | 1 | 1 | ||
| 178973 | 178973 | 2 | 556 | 131 Albion St | 1 | 1 | 1 | ||
| 177621 | 177621 | 1 | 555 | 1440 24th Ave | 1 | 1 | 1 | 1 | Permit Number 38306 |
| 170666 | 170666 | 2 | 554 | 550 Missouri St | 7 | 1 | 1 | ||
| 170201 | 170201 | 2 | 553 | 1374 Hampshire St | 1 | 1 | 1 | ||
| 168425 | 168425 | 1 | 552 | 559 Vermont St | 1 | 1 | 1 | Permit Number 46289 | |
| 166103 | 166103 | 2 | 551 | 701 Shrader St | 1 | 1 | 1 | ||
| 173140 | 173140 | 2 | 551 | 156 Belvedere St | 1 | 1 | 1 | ||
| 162882 | 162882 | 2 | 550 | 1200 York St | 1 | 1 | 1 | ||
| 180948 | 180948 | 2 | 550 | 1201 20th St | 9 | 1 | 1 | ||
| 162156 | 162156 | 2 | 549 | 1310 Indiana St | 23 | 1 | 1 | ||
| 161504 | 161504 | 2 | 548 | 1101 San Jose Ave | 7 | 1 | 1 | ||
| 160417 | 160417 | 1 | 547 | 90 Rotteck St | 1 | 1 | 1 | Permit Number 769383 | |
| 160329 | 160329 | 2 | 546 | 806 34th Ave | 1 | 1 | 1 | ||
| 155559 | 155559 | 2 | 545 | 1754 Revere Ave | 4 | 1 | 1 | ||
| 168155 | 168155 | 2 | 545 | 1639 Kirkwood Ave | 4 | 1 | 1 | ||
| 154172 | 154172 | 2 | 544 | 136 Alpha St | 9 | 1 | 1 | ||
| 167381 | 167381 | 2 | 544 | 136 Alpha St | 9 | 1 | 1 | ||
| 186930 | 186930 | 2 | 544 | 2211 25th St | 9 | 1 | 1 | ||
| 153481 | 153481 | 2 | 543 | 331 Walnut St | 1 | 1 | 1 | ||
| 150767 | 150767 | 2 | 542 | 2770 Green St | 9 | 1 | 1 | ||
| 161876 | 161876 | 2 | 542 | 601x Wisconsin St | 1 | 1 | 1 | ||
| 147432 | 147432 | 2 | 541 | 730 Ashbury St | 1 | 1 | 1 | ||
| 144144 | 144144 | 6 | 540 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 142384 | 142384 | 6 | 539 | 2101 42ND AVE | 7 | 1 | 1 | ||
| 138584 | 138584 | 1 | 538 | 4072 24th St | 1 | 1 | 1 | Permit Number 53764 | |
| 136860 | 136860 | 1 | 537 | 1801X Anza St | 1 | 1 | 1 | ||
| 136308 | 136308 | 2 | 536 | 476 Noe St | 1 | 1 | 1 | ||
| 136054 | 136054 | 2 | 535 | 601 Wisconsin St | 9 | 1 | 1 | ||
| 133988 | 133988 | 2 | 534 | 1101 San Jose Ave | 2 | 1 | 1 | ||
| 163433 | 163433 | 2 | 534 | 1484 16th Ave | 2 | 1 | 1 | ||
| 180475 | 180475 | 2 | 534 | 1498 25th St | 1 | 1 | 1 | ||
| 133932 | 133932 | 2 | 533 | 601 Wisconsin St | 9 | 1 | 1 | ||
| 128879 | 128879 | 1 | 532 | 394 Elizabeth St | 1 | 1 | 1 | 1 | Permit Number 41407 |
| 128807 | 128807 | 2 | 531 | 536 Alvarado St | 1 | 1 | 1 | ||
| 124878 | 124878 | 6 | 530 | 2 Mendosa Ave | 7 | 1 | 1 | Permit Number 768165 | |
| 122921 | 122921 | 2 | 529 | 50 FANNING WAY | 7 | 1 | 1 | ||
| 122731 | 122731 | 2 | 528 | 736 CASTRO ST | 1 | 1 | 1 | ||
| 133909 | 133909 | 1 | 528 | 756 Kansas St | 1 | 1 | 1 | Permit Number 52383 | |
| 142788 | 142788 | 1 | 528 | 3721 23rd St | 1 | 1 | 1 | Permit Number 14371 | |
| 118076 | 118076 | 1 | 527 | 1647 Bay Shore Blvd | 1 | 1 | 1 | ||
| 165189 | 165189 | 2 | 527 | 637 Detroit St | 9 | 1 | 1 | ||
| 117945 | 117945 | 1 | 526 | 26 Allston Way | 8 | 1 | 1 | Permit Number 770732 | |
| 128374 | 128374 | 1 | 526 | 26 Allston Way | 8 | 1 | 1 | Permit Number 770732 | |
| 131449 | 131449 | 2 | 526 | 288 24th Ave | 1 | 1 | 1 | ||
| 155426 | 155426 | 2 | 526 | 594 Arkansas St | 4 | 1 | 1 | ||
| 161922 | 161922 | 2 | 526 | 1357 Natoma St | 1 | 1 | 1 | ||
| 115182 | 115182 | 1 | 525 | 1498@ KEITH Underwood Ave | 1 | 1 | 1 | 1 | Permit Number 49074 |
| 162265 | 162265 | 2 | 525 | 644 South Van Ness Ave | 1 | 1 | 1 | ||
| 113666 | 113666 | 3 | 524 | 3700X Cesar Chavez St | 7 | 1 | 2 | ||
| 112390 | 112390 | 1 | 523 | 1442 Sanchez St | 1 | 1 | 1 | 1 | Permit Number 767418 |
| 112157 | 112157 | 2 | 522 | 2500X Pierce St | 1 | 1 | 1 | ||
| 109820 | 109820 | 1 | 521 | 1410X Sutter St | 1 | 1 | 1 | ||
| 109005 | 109005 | 2 | 520 | 4120-4124 24th St | 1 | 1 | 1 | ||
| 122132 | 122132 | 2 | 520 | 4120-4124 24th St | 1 | 1 | 1 | ||
| 108919 | 108919 | 1 | 519 | 262 17th Ave | 1 | 1 | 1 | Permit Number 776532 | |
| 122707 | 122707 | 1 | 519 | 266 17th Ave | 1 | 1 | 1 | Permit Number 776410 | |
| 125233 | 125233 | 1 | 519 | 426 03rd Ave | 1 | 1 | 1 | 1 | Permit Number 777484 |
| 108754 | 108754 | 6 | 518 | 2109 Steiner St | 5 | 1 | 1 | Permit Number 767176 | |
| 121702 | 121702 | 6 | 518 | 30 Onondaga Ave | 7 | 1 | 1 | Permit Number 767524 | |
| 107483 | 107483 | 1 | 517 | 4275 24th St | 1 | 1 | 1 | Permit Number 50421 | |
| 105760 | 105760 | 1 | 516 | 2600@ PIERCE Pacific Ave | 1 | 1 | 1 | Permit Number 48859 | |
| 121318 | 121318 | 1 | 516 | 1840 Scott St | 1 | 1 | 1 | Permit Number 46012 | |
| 123428 | 123428 | 1 | 516 | 160 Harrison St | 1 | 1 | 1 | Permit Number 44599 | |
| 144647 | 144647 | 1 | 516 | 1400 Portola Dr | 1 | 1 | 1 | Permit Number 46885 | |
| 104446 | 104446 | 1 | 515 | 311 San Benito Way | 9 | 1 | 1 | Permit Number 769253 | |
| 103902 | 103902 | 2 | 514 | 299x SHOTWELL ST | 1 | 1 | 3 | ||
| 105186 | 105186 | 2 | 514 | 1188 SHOTWELL ST | 1 | 1 | 1 | ||
| 140878 | 140878 | 2 | 514 | 814 Potrero Ave | 1 | 1 | 1 | ||
| 101864 | 101864 | 2 | 513 | 310 Sanchez St | 1 | 1 | 1 | ||
| 115983 | 115983 | 1 | 513 | 123 Park St | 1 | 1 | 1 | 1 | Permit Number 39126 |
| 101656 | 101656 | 3 | 512 | 1356X Van Ness Ave | 11 | 1 | 2 | ||
| 113613 | 113613 | 3 | 512 | 1356X Van Ness Ave | 11 | 1 | 2 | ||
| 100778 | 100778 | 6 | 511 | 273 Magellan Ave | 7 | 1 | 1 | ||
| 100332 | 100332 | 3 | 510 | 2692X Sunset Blvd | 1 | 1 | 2 | ||
| 99928 | 99928 | 3 | 509 | 774X Market St | 1 | 1 | 2 | ||
| 129280 | 129280 | 3 | 509 | 776 Market St | 1 | 1 | 2 | ||
| 96007 | 96007 | 2 | 508 | 577 Castro St | 1 | 1 | 1 | ||
| 121943 | 121943 | 3 | 508 | 99X Castro St | 1 | 1 | 2 | ||
| 141616 | 141616 | 1 | 508 | 99X Castro St | 1 | 1 | 1 | ||
| 95817 | 95817 | 3 | 507 | 2100X Van Ness Ave | 11 | 1 | 2 | ||
| 141601 | 141601 | 1 | 507 | 10 ARBOR ST | 7 | 1 | 1 | Permit Number 774690 | |
| 94793 | 94793 | 3 | 506 | 801X Clipper St | 14 | 1 | 2 | ||
| 94322 | 94322 | 1 | 505 | 15 Bessie St | 1 | 1 | 1 | 1 | Permit Number 23859 |
| 102112 | 102112 | 1 | 505 | 101 BUENA VISTA AVE EAST | 1 | 1 | 1 | ||
| 120962 | 120962 | 2 | 505 | 101 BUENA VISTA AVE EAST | 1 | 1 | 1 | ||
| 92918 | 92918 | 2 | 504 | 1798x 22ND ST | 14 | 1 | 1 | ||
| 92792 | 92792 | 3 | 503 | 1501X 42nd Ave | 1 | 1 | 10 | 6 | |
| 108295 | 108295 | 3 | 503 | 1700X Van Ness Ave | 11 | 1 | 2 | ||
| 143095 | 143095 | 2 | 503 | 418 Clipper St | 1 | 1 | 1 | ||
| 145968 | 145968 | 3 | 503 | 1501X 42nd Ave | 1 | 1 | 10 | 6 | |
| 91632 | 91632 | 6 | 502 | 500 Cortland Ave | 13 | 1 | 1 | Permit Number 50224 | |
| 101276 | 101276 | 6 | 502 | 500 Cortland Ave | 13 | 1 | 1 | Permit Number 50224 | |
| 90478 | 90478 | 1 | 501 | 1210 Sanchez St | 1 | 1 | 1 | Permit Number 49019 | |
| 118068 | 118068 | 1 | 501 | 58 Walter St | 1 | 1 | 1 | Permit Number 53177 |
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");