Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus | qSpecies | qAddress | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 77542 | 77542 | 1 | 144 | 1000X McAllister St | 1 | 1 | 21 | ||
| 77557 | 77557 | 1 | 128 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 77576 | 77576 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 78822 | 78822 | 1 | 11 | 1000X McAllister St | 1 | 1 | 21 | ||
| 80298 | 80298 | 1 | 150 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 83117 | 83117 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
| 85143 | 85143 | 5 | 16 | 1050 MCALLISTER ST | 8 | 1 | 21 | 4 | |
| 86826 | 86826 | 1 | 6 | 1000X McAllister St | 1 | 1 | 21 | ||
| 99583 | 99583 | 1 | 82 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 104137 | 104137 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 106272 | 106272 | 5 | 80 | 1050 MCALLISTER ST | 8 | 1 | 21 | 4 | |
| 108008 | 108008 | 1 | 82 | 1000X McAllister St | 1 | 1 | 21 | ||
| 110180 | 110180 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
| 111085 | 111085 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 112538 | 112538 | 1 | 82 | 1000X McAllister St | 1 | 1 | 21 | ||
| 122469 | 122469 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
| 123500 | 123500 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
| 123863 | 123863 | 1 | 128 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 124348 | 124348 | 1 | 11 | 1000X McAllister St | 1 | 1 | 21 | ||
| 126868 | 126868 | 1 | 25 | 1000X McAllister St | 1 | 1 | 21 | ||
| 140317 | 140317 | 1 | 82 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 141722 | 141722 | 1 | 82 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 143620 | 143620 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 145179 | 145179 | 1 | 6 | 1000X McAllister St | 1 | 1 | 21 | ||
| 145804 | 145804 | 1 | 26 | 1195X Golden Gate Ave | 1 | 1 | 21 | ||
| 6478 | 6478 | 2 | 5 | 1150 Scott St | 1 | 1 | 20 | 2 | |
| 19054 | 19054 | 6 | 311 | 2451X Griffith St | 5 | 1 | 20 | 1 | |
| 50102 | 50102 | 6 | 417 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 76012 | 76012 | 7 | 88 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 78805 | 78805 | 7 | 180 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 81078 | 81078 | 6 | 469 | 2451X Griffith St | 5 | 1 | 20 | 1 | |
| 81165 | 81165 | 7 | 353 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 81341 | 81341 | 7 | 195 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 81359 | 81359 | 2 | 43 | 135X TRENTON ST | 1 | 1 | 20 | 3 | |
| 82893 | 82893 | 7 | 322 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 84182 | 84182 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 85013 | 85013 | 7 | 353 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 86272 | 86272 | 6 | 17 | 137X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 86815 | 86815 | 2 | 21 | 135X TRENTON ST | 1 | 1 | 20 | 3 | |
| 87276 | 87276 | 2 | 11 | 699x WILLOW ST | 1 | 1 | 20 | 4 | |
| 87538 | 87538 | 7 | 1 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 88058 | 88058 | 6 | 498 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 88802 | 88802 | 7 | 232 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 90248 | 90248 | 7 | 14 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 90953 | 90953 | 6 | 17 | 11X Hare St | 7 | 1 | 20 | Permit Number 770341 | |
| 92954 | 92954 | 7 | 54 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 94845 | 94845 | 7 | 353 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 94993 | 94993 | 2 | 11 | 699x WILLOW ST | 1 | 1 | 20 | 4 | |
| 96189 | 96189 | 6 | 112 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 99914 | 99914 | 7 | 112 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 101441 | 101441 | 2 | 43 | 135X TRENTON ST | 1 | 1 | 20 | 3 | |
| 102473 | 102473 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
| 104476 | 104476 | 7 | 322 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 104783 | 104783 | 7 | 20 | 195A Kiska Rd | 5 | 1 | 20 | 1 | |
| 107391 | 107391 | 6 | 17 | 10X Hare St | 7 | 1 | 20 | Permit Number 770341 | |
| 107550 | 107550 | 7 | 477 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 108419 | 108419 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 111421 | 111421 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
| 111442 | 111442 | 6 | 17 | 200X West Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 111560 | 111560 | 6 | 112 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 111884 | 111884 | 6 | 112 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 112944 | 112944 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
| 112975 | 112975 | 6 | 498 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 114297 | 114297 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
| 114699 | 114699 | 2 | 5 | 1150 Scott St | 1 | 1 | 20 | 2 | |
| 118079 | 118079 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | Permit Number 778058 |
| 118120 | 118120 | 2 | 40 | 200x MIDDLE POINT RD | 1 | 1 | 20 | 3 | |
| 119692 | 119692 | 6 | 17 | 45X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 120473 | 120473 | 2 | 11 | 699x WILLOW ST | 1 | 1 | 20 | 4 | |
| 120602 | 120602 | 2 | 9 | 1514 SUNNYDALE AVE | 9 | 1 | 20 | 3 | |
| 125137 | 125137 | 6 | 17 | 71X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 125485 | 125485 | 7 | 14 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 125835 | 125835 | 7 | 20 | 195A Kiska Rd | 5 | 1 | 20 | 1 | |
| 126442 | 126442 | 3 | 5 | 775X Broadway | 1 | 1 | 20 | 2 | |
| 126702 | 126702 | 2 | 5 | 1150 Scott St | 1 | 1 | 20 | 2 | |
| 127056 | 127056 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 127473 | 127473 | 7 | 207 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 128761 | 128761 | 2 | 5 | 1150 Scott St | 1 | 1 | 20 | 2 | |
| 128784 | 128784 | 7 | 14 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 129300 | 129300 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 138572 | 138572 | 2 | 21 | 135X TRENTON ST | 1 | 1 | 20 | 3 | |
| 139320 | 139320 | 6 | 498 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 140389 | 140389 | 7 | 477 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 140586 | 140586 | 7 | 322 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 140629 | 140629 | 7 | 14 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 140648 | 140648 | 6 | 17 | 150X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 141507 | 141507 | 6 | 17 | 119X Middle Point Rd | 7 | 1 | 20 | Permit Number 770341 | |
| 141804 | 141804 | 6 | 235 | 2451X Griffith St | 5 | 1 | 20 | 1 | |
| 142369 | 142369 | 7 | 309 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 143629 | 143629 | 6 | 84 | 2451X Griffith St | 5 | 1 | 20 | 1 | |
| 144144 | 144144 | 6 | 540 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 144482 | 144482 | 2 | 51 | 1150 Scott St | 1 | 1 | 20 | 2 | |
| 144883 | 144883 | 6 | 417 | 2525 Griffith St | 5 | 1 | 20 | 1 | |
| 145213 | 145213 | 7 | 208 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 145522 | 145522 | 7 | 477 | 195B Kiska Rd | 5 | 1 | 20 | 1 | |
| 145720 | 145720 | 2 | 51 | 1150 Scott St | 1 | 1 | 20 | 2 | |
| 181574 | 181574 | 1 | 37 | 400 Beale St | 1 | 1 | 20 | 3 | Permit Number 769373 |
| 4504 | 4504 | 1 | 35 | 762 Fulton St | 1 | 1 | 19 | ||
| 5269 | 5269 | 1 | 35 | 762 Fulton St | 1 | 1 | 19 | ||
| 5536 | 5536 | 1 | 35 | 762 Fulton St | 1 | 1 | 19 |
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");