Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | qLegalStatus | qSpecies | qAddress | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PermitNotes |
---|---|---|---|---|---|---|---|---|---|
101 | 101 | 2 | 11 | 1399X Mission St | 1 | 1 | 1 | ||
102 | 102 | 5 | 26 | 1384X Grove St | 1 | 1 | 1 | Permit Number 767782 | |
103 | 103 | 1 | 38 | 1 | 1 | 1 | Permit Number 776915 | ||
104 | 104 | 3 | 39 | 1170 Ingalls St | 1 | 1 | 2 | ||
105 | 105 | 3 | 5 | 1315 Ellis St | 1 | 1 | 2 | ||
106 | 106 | 3 | 36 | 906 Hayes St | 1 | 1 | 2 | ||
107 | 107 | 2 | 26 | 1384X GROVE ST | 1 | 1 | 1 | ||
108 | 108 | 2 | 11 | 1399X Mission St | 1 | 1 | 1 | ||
109 | 109 | 3 | 40 | 1800X Pine St | 1 | 1 | 2 | ||
110 | 110 | 2 | 2 | 1824 Noriega St | 1 | 1 | 1 | ||
111 | 111 | 1 | 15 | 400X Franklin St | 1 | 1 | 1 | ||
112 | 112 | 3 | 11 | 1800X Pine St | 1 | 1 | 2 | ||
113 | 113 | 1 | 41 | 1341 42nd Ave | 1 | 1 | 1 | ||
114 | 114 | 6 | 1 | 399X Townsend St | 5 | 1 | 1 | ||
115 | 115 | 1 | 26 | 700 Fell St | 1 | 1 | 1 | ||
116 | 116 | 1 | 32 | 220 Richardson Ave | 1 | 1 | 1 | ||
117 | 117 | 3 | 42 | 929 Valencia St | 1 | 1 | 2 | Permit Number 24134 | |
118 | 118 | 6 | 1 | 399X Townsend St | 5 | 1 | 1 | ||
119 | 119 | 3 | 43 | 175X Otis St | 1 | 1 | 2 | ||
120 | 120 | 1 | 44 | 2123 Pierce St | 1 | 1 | 1 | Permit Number 774924 | |
121 | 121 | 1 | 2 | 1201 Palou Ave | 1 | 1 | 1 | 1 | Permit Number 19293 |
122 | 122 | 1 | 45 | 1341 42nd Ave | 1 | 1 | 1 | ||
123 | 123 | 3 | 41 | 2621 Sacramento St | 1 | 1 | 2 | ||
124 | 124 | 3 | 2 | 20X Sunset Blvd | 1 | 1 | 2 | ||
125 | 125 | 2 | 22 | 151X Octavia St Frontage West | 1 | 1 | 1 | ||
126 | 126 | 3 | 11 | 700 Valencia St | 1 | 1 | 2 | ||
127 | 127 | 3 | 46 | 2840 Pine St | 1 | 1 | 2 | ||
128 | 128 | 2 | 16 | 115 Beverly St | 9 | 1 | 1 | ||
129 | 129 | 3 | 47 | 262X Sunset Blvd | 1 | 1 | 2 | ||
130 | 130 | 1 | 22 | 2041 Hayes St | 1 | 1 | 1 | 1 | Permit Number 30161 |
131 | 131 | 3 | 18 | 100 Octavia St | 4 | 1 | 2 | ||
132 | 132 | 1 | 44 | 270 Brannan St | 5 | 1 | 1 | ||
133 | 133 | 2 | 23 | 742 Myra Way | 1 | 1 | 1 | Permit Number 779535 | |
134 | 134 | 1 | 12 | 54X Cayuga Ave | 1 | 1 | 1 | Permit Number 45390 | |
135 | 135 | 3 | 18 | 100 Octavia St | 4 | 1 | 2 | ||
136 | 136 | 2 | 17 | 120 Ortega St | 1 | 1 | 1 | Permit Number 779661 | |
137 | 137 | 3 | 11 | 700 Valencia St | 1 | 1 | 2 | ||
138 | 138 | 4 | 44 | 270 Brannan St | 5 | 1 | 1 | Permit Number 770847 | |
139 | 139 | 4 | 44 | 270 Brannan St | 5 | 1 | 1 | ||
140 | 140 | 3 | 2 | 1916 Ellis St | 1 | 1 | 2 | ||
141 | 141 | 3 | 48 | 1396 47th Ave | 1 | 1 | 2 | ||
142 | 142 | 2 | 34 | 2305 Golden Gate Ave | 1 | 1 | 1 | ||
143 | 143 | 3 | 32 | 2055 Sacramento St | 1 | 1 | 2 | ||
144 | 144 | 1 | 48 | 4134 Judah St | 1 | 1 | 1 | ||
145 | 145 | 2 | 49 | 1498x Kansas St | 1 | 1 | 1 | Permit Number 779654 | |
146 | 146 | 1 | 48 | 1038 Taraval St | 1 | 1 | 1 | ||
147 | 147 | 1 | 48 | 4026 Irving St | 1 | 1 | 1 | Permit Number 16988 | |
148 | 148 | 3 | 2 | 80X Junipero Serra Blvd | 1 | 1 | 2 | ||
149 | 149 | 3 | 50 | 247 Orizaba Ave | 1 | 1 | 2 | ||
150 | 150 | 3 | 48 | 4200x Judah St | 1 | 1 | 2 | ||
151 | 151 | 1 | 33 | 1 | 1 | 1 | Permit Number 39461 | ||
152 | 152 | 3 | 48 | 1395 47th Ave | 1 | 1 | 2 | ||
153 | 153 | 3 | 26 | 1550 Eddy St | 1 | 1 | 2 | ||
154 | 154 | 3 | 51 | 1384 47th Ave | 1 | 1 | 2 | ||
155 | 155 | 2 | 52 | 1 Yukon St | 1 | 1 | 1 | ||
156 | 156 | 1 | 48 | 4508 Irving St | 1 | 1 | 1 | Permit Number 10547 | |
157 | 157 | 1 | 15 | 3698 California St | 1 | 1 | 1 | ||
158 | 158 | 3 | 35 | 1830 Sutter St | 1 | 1 | 2 | ||
159 | 159 | 1 | 48 | 1055 Taraval St | 1 | 1 | 1 | ||
160 | 160 | 3 | 53 | 80X Junipero Serra Blvd | 1 | 1 | 1 | ||
161 | 161 | 2 | 54 | 1170 COLUMBUS AVE | 1 | 1 | 1 | ||
162 | 162 | 2 | 3 | 164 Serrano Dr | 1 | 1 | 1 | ||
163 | 163 | 3 | 51 | 242 Broad St | 1 | 1 | 2 | ||
164 | 164 | 1 | 48 | 1011 Taraval St | 1 | 1 | 1 | ||
165 | 165 | 3 | 48 | 4000 Judah St | 1 | 1 | 2 | ||
166 | 166 | 2 | 55 | 99x Ogden Ave | 1 | 1 | 1 | ||
167 | 167 | 2 | 55 | 99x Ogden Ave | 1 | 1 | 1 | ||
168 | 168 | 2 | 25 | 100 Serrano Dr | 2 | 1 | 1 | ||
169 | 169 | 1 | 17 | 2401X Washington St | 1 | 1 | 1 | Permit Number 778039 | |
170 | 170 | 1 | 11 | 435 Pacific Ave | 1 | 1 | 1 | Permit Number 46051 | |
171 | 171 | 2 | 34 | 2449 Golden Gate Ave | 5 | 1 | 1 | ||
172 | 172 | 1 | 17 | 1 | 1 | 1 | Permit Number 45761 | ||
173 | 173 | 3 | 2 | 80x Junipero Serra Blvd | 1 | 1 | 2 | ||
174 | 174 | 2 | 56 | 1 Yukon St | 1 | 1 | 1 | ||
175 | 175 | 3 | 41 | 2205 Pine St | 1 | 1 | 2 | ||
176 | 176 | 3 | 11 | 2030 Fell St | 1 | 1 | 2 | ||
177 | 177 | 1 | 48 | 1000 Taraval St | 1 | 1 | 1 | ||
178 | 178 | 3 | 15 | 2253 California St | 1 | 1 | 2 | ||
179 | 179 | 3 | 48 | 1101 Taraval St | 1 | 1 | 2 | ||
180 | 180 | 1 | 15 | 100X Richardson Ave | 1 | 1 | 1 | ||
181 | 181 | 3 | 32 | 1900 Gough St | 1 | 1 | 2 | ||
182 | 182 | 3 | 57 | 1739 Taraval St | 1 | 1 | 2 | ||
183 | 183 | 3 | 32 | 2125 Mission St | 1 | 1 | 2 | ||
184 | 184 | 1 | 22 | 2375 PINE ST | 1 | 1 | 1 | ||
185 | 185 | 2 | 58 | 299x Chapman St | 1 | 1 | 2 | ||
186 | 186 | 3 | 59 | 2060 SUTTER ST | 1 | 1 | 2 | ||
187 | 187 | 3 | 60 | 829 Chenery St | 1 | 1 | 2 | ||
188 | 188 | 3 | 59 | 2060 SUTTER ST | 1 | 1 | 2 | ||
189 | 189 | 3 | 46 | 2355 PINE ST | 1 | 1 | 2 | ||
190 | 190 | 1 | 21 | 2898 Clay St | 1 | 1 | 1 | Permit Number 773671 | |
191 | 191 | 2 | 1 | 365 San Leandro Way | 1 | 1 | 1 | Permit Number 779799 | |
192 | 192 | 3 | 59 | 2060 SUTTER ST | 1 | 1 | 2 | ||
193 | 193 | 1 | 2 | 1930 Eddy St | 1 | 1 | 1 | ||
194 | 194 | 1 | 46 | 2375 PINE ST | 1 | 1 | 1 | ||
195 | 195 | 3 | 59 | 2060 SUTTER ST | 1 | 1 | 2 | ||
196 | 196 | 3 | 2 | 722X Mendell St | 1 | 1 | 2 | ||
197 | 197 | 3 | 60 | 701 Chenery St | 1 | 1 | 2 | ||
198 | 198 | 3 | 21 | 1221 Polk St | 10 | 1 | 2 | ||
199 | 199 | 3 | 59 | 2060 SUTTER ST | 1 | 1 | 2 | ||
200 | 200 | 1 | 15 | 99 Grove St | 1 | 1 | 5 |
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");