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");