Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | qLegalStatus | qSpecies | qAddress ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes |
|---|---|---|---|---|---|---|---|---|---|
| 92394 | 92394 | 6 | 6 | 9x Yerba Buena Ave | 1 | 1 | 1 | Permit Number 776557 | |
| 85354 | 85354 | 2 | 37 | 9x BLANKEN AVE | 1 | 1 | 1 | ||
| 88764 | 88764 | 2 | 37 | 9x BLANKEN AVE | 1 | 1 | 1 | ||
| 108617 | 108617 | 2 | 37 | 9x BLANKEN AVE | 1 | 1 | 1 | ||
| 120023 | 120023 | 2 | 37 | 9x BLANKEN AVE | 1 | 1 | 1 | ||
| 72210 | 72210 | 3 | 114 | 9X Newhall St | 1 | 1 | 2 | ||
| 90238 | 90238 | 1 | 114 | 9X Newhall St | 1 | 1 | 1 | ||
| 96388 | 96388 | 1 | 114 | 9X Newhall St | 1 | 1 | 1 | ||
| 115131 | 115131 | 3 | 114 | 9X Newhall St | 1 | 1 | 2 | ||
| 118199 | 118199 | 3 | 36 | 9X Newhall St | 1 | 1 | 2 | ||
| 140227 | 140227 | 3 | 114 | 9X Newhall St | 1 | 1 | 2 | ||
| 142877 | 142877 | 3 | 155 | 9X Newhall St | 1 | 1 | 2 | ||
| 96198 | 96198 | 3 | 60 | 9X Lyell St | 11 | 1 | 2 | ||
| 138487 | 138487 | 3 | 60 | 9X Lyell St | 11 | 1 | 2 | ||
| 141679 | 141679 | 3 | 60 | 9X Lyell St | 11 | 1 | 2 | ||
| 142098 | 142098 | 3 | 60 | 9X Lyell St | 11 | 1 | 2 | ||
| 97285 | 97285 | 1 | 18 | 9X Hattie St | 1 | 1 | 1 | 1 | Permit Number 769765 |
| 143029 | 143029 | 1 | 18 | 9X Hattie St | 1 | 1 | 1 | 1 | Permit Number 769765 |
| 23018 | 23018 | 3 | 22 | 9X Castro St | 1 | 1 | 2 | ||
| 139866 | 139866 | 2 | 103 | 9M CAIRE TER | 7 | 1 | 1 | ||
| 81662 | 81662 | 2 | 5 | 99x Vandewater St | 1 | 1 | 1 | ||
| 97297 | 97297 | 2 | 5 | 99x Vandewater St | 1 | 1 | 1 | ||
| 112326 | 112326 | 2 | 5 | 99x Vandewater St | 1 | 1 | 1 | ||
| 113661 | 113661 | 2 | 5 | 99x Vandewater St | 1 | 1 | 1 | ||
| 115493 | 115493 | 2 | 5 | 99x Vandewater St | 1 | 1 | 1 | ||
| 2733 | 2733 | 2 | 15 | 99x The Embarcadero | 1 | 1 | 1 | ||
| 2735 | 2735 | 2 | 15 | 99x The Embarcadero | 1 | 1 | 1 | ||
| 2737 | 2737 | 2 | 15 | 99x The Embarcadero | 1 | 1 | 1 | ||
| 2738 | 2738 | 2 | 15 | 99x The Embarcadero | 1 | 1 | 1 | ||
| 2739 | 2739 | 2 | 15 | 99x The Embarcadero | 1 | 1 | 1 | ||
| 2741 | 2741 | 2 | 15 | 99x The Embarcadero | 1 | 1 | 1 | ||
| 2744 | 2744 | 2 | 15 | 99x The Embarcadero | 1 | 1 | 1 | ||
| 77511 | 77511 | 2 | 161 | 99x Santa Marina St | 1 | 1 | 1 | ||
| 98900 | 98900 | 2 | 161 | 99x Santa Marina St | 1 | 1 | 1 | ||
| 109131 | 109131 | 2 | 161 | 99x Santa Marina St | 1 | 1 | 1 | ||
| 120908 | 120908 | 2 | 161 | 99x Santa Marina St | 1 | 1 | 1 | ||
| 41263 | 41263 | 3 | 37 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 42882 | 42882 | 3 | 3 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 43117 | 43117 | 3 | 14 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 44102 | 44102 | 3 | 22 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 47921 | 47921 | 3 | 3 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 56613 | 56613 | 3 | 3 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 60137 | 60137 | 3 | 22 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 60262 | 60262 | 3 | 14 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 61181 | 61181 | 3 | 3 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 74481 | 74481 | 3 | 37 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 75541 | 75541 | 3 | 22 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 76824 | 76824 | 3 | 14 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 123719 | 123719 | 3 | 22 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 134757 | 134757 | 3 | 22 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 147824 | 147824 | 3 | 37 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 153512 | 153512 | 3 | 14 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 154163 | 154163 | 3 | 14 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 156535 | 156535 | 3 | 14 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 157795 | 157795 | 3 | 22 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 160858 | 160858 | 3 | 3 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 178018 | 178018 | 3 | 22 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 184665 | 184665 | 3 | 3 | 99x San Marcos Ave | 11 | 1 | 2 | ||
| 144546 | 144546 | 1 | 37 | 99x SAN JOSE AVE | 1 | 1 | 1 | Permit Number 37802 | |
| 166 | 166 | 2 | 55 | 99x Ogden Ave | 1 | 1 | 1 | ||
| 167 | 167 | 2 | 55 | 99x Ogden Ave | 1 | 1 | 1 | ||
| 3258 | 3258 | 2 | 55 | 99x Ogden Ave | 1 | 1 | 1 | ||
| 129004 | 129004 | 7 | 17 | 99x OAKWOOD ST | 13 | 1 | 1 | ||
| 1384 | 1384 | 6 | 3 | 99x Mountview Ct | 13 | 1 | 1 | ||
| 1409 | 1409 | 6 | 3 | 99x Mountview Ct | 13 | 1 | 1 | ||
| 13137 | 13137 | 3 | 2 | 99x Mansell St | 1 | 1 | 2 | ||
| 93628 | 93628 | 3 | 11 | 99x Mansell St | 1 | 1 | 2 | ||
| 9827 | 9827 | 1 | 11 | 99x Majestic Ave | 1 | 1 | 1 | 1 | |
| 9830 | 9830 | 1 | 11 | 99x Majestic Ave | 1 | 1 | 1 | 1 | Permit Number 20066 |
| 65538 | 65538 | 2 | 44 | 99x JULIAN AVE | 1 | 1 | 1 | ||
| 95125 | 95125 | 2 | 44 | 99x JULIAN AVE | 1 | 1 | 1 | ||
| 113014 | 113014 | 2 | 44 | 99x JULIAN AVE | 1 | 1 | 1 | ||
| 114259 | 114259 | 2 | 44 | 99x JULIAN AVE | 1 | 1 | 1 | ||
| 114942 | 114942 | 2 | 44 | 99x JULIAN AVE | 1 | 1 | 1 | ||
| 115187 | 115187 | 2 | 44 | 99x JULIAN AVE | 1 | 1 | 1 | ||
| 53479 | 53479 | 2 | 2 | 99x Hyde St | 1 | 1 | 1 | Permit Number 773269 | |
| 135927 | 135927 | 2 | 2 | 99x Hyde St | 1 | 1 | 1 | Permit Number 773269 | |
| 151164 | 151164 | 2 | 2 | 99x Hyde St | 1 | 1 | 1 | Permit Number 773269 | |
| 170033 | 170033 | 2 | 2 | 99x Hyde St | 1 | 1 | 1 | Permit Number 773269 | |
| 182575 | 182575 | 2 | 2 | 99x Hyde St | 1 | 1 | 1 | Permit Number 773269 | |
| 184627 | 184627 | 2 | 2 | 99x Hyde St | 1 | 1 | 1 | Permit Number 773269 | |
| 88315 | 88315 | 2 | 134 | 99x HYDE ST | 1 | 1 | 1 | Permit Number 773269 | |
| 92393 | 92393 | 2 | 134 | 99x HYDE ST | 1 | 1 | 1 | Permit Number 773269 | |
| 107281 | 107281 | 2 | 134 | 99x HYDE ST | 1 | 1 | 1 | Permit Number 773269 | |
| 112409 | 112409 | 2 | 134 | 99x HYDE ST | 1 | 1 | 1 | Permit Number 773269 | |
| 91188 | 91188 | 2 | 176 | 99x GILROY ST | 14 | 1 | 1 | ||
| 96975 | 96975 | 2 | 176 | 99x GILROY ST | 14 | 1 | 1 | ||
| 123880 | 123880 | 2 | 176 | 99x GILROY ST | 14 | 1 | 1 | ||
| 49231 | 49231 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 79797 | 79797 | 6 | 60 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 80545 | 80545 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 86013 | 86013 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 105010 | 105010 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 105245 | 105245 | 6 | 60 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 105541 | 105541 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 112189 | 112189 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 117729 | 117729 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 125709 | 125709 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 128194 | 128194 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 | ||
| 128290 | 128290 | 6 | 140 | 99x FONT BLVD | 2 | 1 | 1 |
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");