trees
142,615 rows where qLegalStatus_id = 1 sorted by qCareAssistant
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189 | 178694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 184 Mount Vernon Ave | 7 | Side Yard : Yard | Tree | Private 2 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.445565994978 | (37.7169892861082, -122.445565994978) | 9 | 7 | 6 | 28861 | 25 | ||||
190 | 21328 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
191 | 244985 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000147.9035 | 2108881.2284 | 37.7705933244615 | -122.442851810939 | (37.7705933244615, -122.442851810939) | 15 | 5 | 11 | 29492 | 9 | |||
192 | 137920 | DPW Maintained 1 | :: 45 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.7883909617368 | -122.433650548643 | (37.7883909617368, -122.433650548643) | 13 | 9 | 1 | 29490 | 27 | |||
199 | 237529 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1197 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003874.24561 | 2101347.66783 | 37.7501197023675 | -122.429425031242 | (37.7501197023675, -122.429425031242) | 2 | 4 | 5 | 28862 | 22 | |||
200 | 10663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.7756317694487 | -122.432267067771 | (37.7756317694487, -122.432267067771) | 15 | 9 | 11 | 29492 | 10 | ||
201 | 229505 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 950 Church St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004360.58946 | 2103177.16015 | 37.7551705836636 | -122.427873571204 | (37.7551705836636, -122.427873571204) | 2 | 4 | 5 | 28862 | 22 | |||
202 | 190636 | DPW Maintained 1 | Hakea suaveolens :: Sweet Hakea Tree 73 | 1 01st St | 30 | : Yard | Tree | Private 2 | 8 | 6014391.99798 | 2105898.86804 | 37.7632061898228 | -122.393372206868 | (37.7632061898228, -122.393372206868) | 14 | 3 | 8 | 28856 | 29 | ||||
204 | 209769 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100x Pacheco St | 2 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5994792.885 | 2099741.94773 | 37.7451924562767 | -122.460712331024 | (37.7451924562767, -122.460712331024) | 1 | 8 | 4 | 59 | 40 | |||
206 | 119799 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
207 | 251656 | DPW Maintained 1 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5999423 | 2096089 | 37.7354276387403 | -122.44443976141 | (37.7354276387403, -122.44443976141) | 9 | 7 | 4 | 63 | 40 | ||||
209 | 138219 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5998675.4325 | 2112652.6916 | 37.7808647356786 | -122.448216697429 | (37.7808647356786, -122.448216697429) | 15 | 6 | 2 | 54 | 16 | |||
210 | 1023 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 1925 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000937.4135 | 2090832.4174 | 37.7210805620079 | -122.438827310136 | (37.7210805620079, -122.438827310136) | 9 | 7 | 6 | 28861 | 25 | |||
211 | 196303 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011469.59111 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | 14 | 2 | 9 | 28856 | 34 | |||
212 | 138278 | DPW Maintained 1 | :: 45 | 2181 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001737.3169 | 2113910.2795 | 37.7844923181381 | -122.437714255164 | (37.7844923181381, -122.437714255164) | 13 | 6 | 11 | 29490 | 13 | |||
213 | 3891 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 23 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002162.16871 | 2108402.44463 | 37.7693933312702 | -122.435850193556 | (37.7693933312702, -122.435850193556) | 15 | 5 | 5 | 29492 | 9 | |||
214 | 138888 | DPW Maintained 1 | :: 45 | 675 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004166.2354 | 2110619.5066 | 37.7755944800015 | -122.429076315191 | (37.7755944800015, -122.429076315191) | 7 | 9 | 11 | 28852 | 10 | |||
215 | 119692 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
216 | 114440 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2961 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011605 | 2091859 | 37.724500488626 | -122.402024501601 | (37.724500488626, -122.402024501601) | 10 | 3 | 7 | 309 | 28 | ||||
218 | 181787 | DPW Maintained 1 | :: 45 | 2915 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986983.636 | 2098224.4165 | 37.740573320949 | -122.487603561386 | (37.740573320949, -122.487603561386) | 1 | 8 | 3 | 29491 | 35 | |||
219 | 131064 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1877 Greenwich St | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6003926.06281 | 2119346.70194 | 37.7995435588443 | -122.430529985984 | (37.7995435588443, -122.430529985984) | 13 | 9 | 1 | 57 | 17 | |||
221 | 182334 | DPW Maintained 1 | :: 45 | 1507 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985257.4301 | 2104914.9526 | 37.758842875608 | -122.494065007935 | (37.758842875608, -122.494065007935) | 1 | 8 | 3 | 56 | 35 | |||
224 | 183657 | DPW Maintained 1 | :: 45 | 1490 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981573.7378 | 2104946.7308 | 37.7587138957913 | -122.506807059304 | (37.7587138957913, -122.506807059304) | 1 | 8 | 3 | 56 | 35 | |||
225 | 119839 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
232 | 228435 | DPW Maintained 1 | :: 45 | 178 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004070 | 2107898 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | 7 | 9 | 5 | 28862 | 3 | |||
234 | 183167 | DPW Maintained 1 | :: 45 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.7413295619026 | -122.503441142831 | (37.7413295619026, -122.503441142831) | 1 | 8 | 3 | 29491 | 35 | |||
235 | 184469 | DPW Maintained 1 | :: 45 | 2182 48th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981423.7042 | 2100234.3036 | 37.7457660664858 | -122.506976375045 | (37.7457660664858, -122.506976375045) | 1 | 8 | 3 | 29491 | 35 | |||
237 | 15807 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4959 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1995 12:00:00 AM | 6 | 3X3 | 6000887.014 | 2090089.1979 | 37.7190369816005 | -122.438948290663 | (37.7190369816005, -122.438948290663) | 9 | 7 | 6 | 28861 | 5 | ||
238 | 119796 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
239 | 205987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | 1 | 8 | 4 | 56 | 12 | |||
240 | 26863 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004510.83387 | 2110645.31056 | 37.7756848318303 | -122.427886103845 | (37.7756848318303, -122.427886103845) | 7 | 9 | 11 | 28852 | 10 | |||
242 | 184584 | DPW Maintained 1 | :: 45 | 1750 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984424.998 | 2103256.5795 | 37.7542407008981 | -122.496821507327 | (37.7542407008981, -122.496821507327) | 1 | 8 | 3 | 56 | 35 | |||
243 | 21365 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2592X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
244 | 200570 | DPW Maintained 1 | :: 45 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.385889477594 | (37.7342110910182, -122.385889477594) | 10 | 3 | 8 | 58 | 1 | |||
245 | 251484 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 7 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
246 | 136052 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1114 Greenwich St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | 6007569.13805 | 2119905.68389 | 37.801284085155 | -122.417963252702 | (37.801284085155, -122.417963252702) | 5 | 1 | 1 | 28858 | 32 | ||||
247 | 240348 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 1 | 6004340.86769 | 2095971.00866 | 37.7353830362869 | -122.427428442788 | (37.7353830362869, -122.427428442788) | 2 | 7 | 5 | 28861 | 2 | ||||
248 | 119766 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
249 | 222839 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 5 | Width 10ft | 6008877.38377 | 2100577.11513 | 37.7482859289696 | -122.412069375694 | (37.7482859289696, -122.412069375694) | 2 | 4 | 7 | 28859 | 2 | |||
250 | 248390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998825.2199 | 2108039.7272 | 37.7682072798204 | -122.447366392326 | (37.7682072798204, -122.447366392326) | 15 | 5 | 11 | 29492 | 9 | |||
251 | 187669 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 554 Valley St | 1 | Median : Yard | Tree | Private 2 | 6002324 | 2099197 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | 2 | 7 | 5 | 63 | 22 | |||||
252 | 204152 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900 Junipero Serra Blvd | 37 | : | Tree | Private 2 | 1 | Width 0ft | 5991169.92245 | 2090751.38969 | 37.7202975393725 | -122.472584434247 | (37.7202975393725, -122.472584434247) | 9 | 8 | 4 | 64 | 40 | |||
253 | 200884 | DPW Maintained 1 | :: 45 | 1200 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6012817.0471 | 2107089.1245 | 37.7663867409086 | -122.39890301604 | (37.7663867409086, -122.39890301604) | 14 | 3 | 8 | 28856 | 20 | |||
254 | 130309 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 95 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013009.60555 | 2119229.44522 | 37.7997319839043 | -122.399089221411 | (37.7997319839043, -122.399089221411) | 3 | 1 | 10 | 28860 | 6 | |||
255 | 118456 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 490 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5981010.56733 | 2112424.984 | 37.7792138173967 | -122.509310094921 | (37.7792138173967, -122.509310094921) | 11 | 6 | 2 | 55 | 26 | |||
258 | 139105 | DPW Maintained 1 | :: 45 | 1310 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999792.0294 | 2113376.32 | 37.7829154028675 | -122.444405875371 | (37.7829154028675, -122.444405875371) | 15 | 6 | 1 | 29490 | 31 | |||
259 | 196282 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 13 | : Yard | Tree | Private 2 | 12 | 6015015.25562 | 2102205.64875 | 37.7531000097757 | -122.390958410295 | (37.7531000097757, -122.390958410295) | 10 | 3 | 8 | 28856 | 29 | ||||
262 | 141330 | DPW Maintained 1 | :: 45 | 1314 HAYES ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 0 | Width 0ft | 6001510.5734 | 2110463.2514 | 37.7750147569158 | -122.438251682494 | (37.7750147569158, -122.438251682494) | 15 | 5 | 11 | 29492 | 10 | |||
263 | 17585 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003724.8526 | 2090366.56287 | 37.71995962001 | -122.429158750084 | (37.71995962001, -122.429158750084) | 9 | 7 | 6 | 28861 | 5 | |||
265 | 18017 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2713 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000875.2767 | 2114835.3915 | 37.7869833841555 | -122.440762994582 | (37.7869833841555, -122.440762994582) | 13 | 6 | 1 | 29490 | 27 | |||
266 | 219228 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 200x Terrace Dr | 4 | Median : Yard | Tree | DPW 1 | 10 | 5993785.97496 | 2096493.89011 | 37.736216119669 | -122.463958297244 | (37.736216119669, -122.463958297244) | 1 | 8 | 4 | 59 | 40 | ||||
267 | 178174 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988358.3694 | 2089791.63303 | 37.717499145949 | -122.482232652541 | (37.717499145949, -122.482232652541) | 1 | 8 | 4 | 64 | 14 | ||||
268 | 247892 | DPW Maintained 1 | :: 45 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.7715514711219 | -122.441841814274 | (37.7715514711219, -122.441841814274) | 15 | 5 | 11 | 29492 | 9 | |||
269 | 194187 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014241.14855 | 2105287.11165 | 37.7615180580268 | -122.393851124637 | (37.7615180580268, -122.393851124637) | 10 | 3 | 8 | 28856 | 29 | |||
270 | 182815 | DPW Maintained 1 | :: 45 | 2111 Noriega St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987460.7639 | 2102999.1421 | 37.7537112584365 | -122.486304306666 | (37.7537112584365, -122.486304306666) | 1 | 8 | 3 | 56 | 35 | |||
271 | 107116 | DPW Maintained 1 | Tree(s) :: 17 | 300X LIBERTY ST | 18 | Median : Cutout | Tree | DPW 1 | 12 | 6004270.1 | 2103982.4 | 37.7573764628527 | -122.428243896062 | (37.7573764628527, -122.428243896062) | 2 | 4 | 5 | 28862 | 3 | ||||
272 | 232035 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 39 Scott St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002379.25876 | 2108512.04182 | 37.769706587622 | -122.435107129612 | (37.769706587622, -122.435107129612) | 15 | 5 | 5 | 29492 | 9 | |||
274 | 232433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004078.25972 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | 7 | 9 | 5 | 28862 | 3 | |||
275 | 193456 | DPW Maintained 1 | Malus :: Crab Apple 82 | 185 Hampshire St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 5ft | 6010023.67884 | 2107445.71101 | 37.76720979983 | -122.40858996078 | (37.76720979983, -122.40858996078) | 8 | 4 | 8 | 28853 | 19 | |||
276 | 182945 | DPW Maintained 1 | :: 45 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | 1 | 8 | 3 | 29491 | 35 | |||
278 | 247719 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 12 Broderick St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6001402.47389 | 2108783.95066 | 37.770397668046 | -122.438505276404 | (37.770397668046, -122.438505276404) | 15 | 5 | 11 | 29492 | 9 | |||
279 | 182423 | DPW Maintained 1 | :: 45 | 1539 25th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988365.4024 | 2104835.4768 | 37.7588060244513 | -122.483310502266 | (37.7588060244513, -122.483310502266) | 1 | 8 | 3 | 56 | 35 | |||
280 | 8072 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.7784066780298 | -122.425067563729 | (37.7784066780298, -122.425067563729) | 7 | 9 | 11 | 28852 | 10 | |||
281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
282 | 119806 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
284 | 142846 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1249 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006785.3377 | 2115265.4346 | 37.7884989771715 | -122.420346012985 | (37.7884989771715, -122.420346012985) | 13 | 9 | 10 | 28858 | 21 | |||
286 | 18512 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 626 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6010135.39241 | 2115955.1821 | 37.7905810646201 | -122.408803973339 | (37.7905810646201, -122.408803973339) | 5 | 1 | 10 | 28857 | 21 | |||
288 | 125298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010056.95509 | 2118170.07703 | 37.7966582351325 | -122.409231726859 | (37.7966582351325, -122.409231726859) | 3 | 1 | 10 | 308 | 4 | |||
289 | 211158 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Marietta Dr | 38 | Median : Cutout | Tree | DPW 1 | 21 | Width 5ft | 5999457.51761 | 2097516.55077 | 37.7393493243992 | -122.444422982731 | (37.7393493243992, -122.444422982731) | 9 | 7 | 4 | 59 | 40 | |||
291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
292 | 141019 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 400 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997825.3169 | 2112597.8673 | 37.7806655664219 | -122.451153693978 | (37.7806655664219, -122.451153693978) | 15 | 6 | 2 | 54 | 16 | |||
295 | 200164 | DPW Maintained 1 | :: 45 | 1027 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | 10 | 3 | 8 | 58 | 1 | |||
296 | 185842 | DPW Maintained 1 | :: 45 | 2000 35th Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985421.3197 | 2101412.6246 | 37.7492360339251 | -122.493240190301 | (37.7492360339251, -122.493240190301) | 1 | 8 | 3 | 29491 | 35 | |||
297 | 113036 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
300 | 234411 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 10x Benton Ave | 4 | Median : Yard | Tree | DPW 1 | 32 | 6004755.33467 | 2095032.93123 | 37.7328307189427 | -122.425928720736 | (37.7328307189427, -122.425928720736) | 2 | 7 | 7 | 28861 | 2 | ||||
302 | 184152 | DPW Maintained 1 | :: 45 | 1585 44th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982483.9557 | 2104316.7349 | 37.7570376635662 | -122.503612507973 | (37.7570376635662, -122.503612507973) | 1 | 8 | 3 | 56 | 35 | |||
303 | 87474 | DPW Maintained 1 | Tristania conferta :: 61 | 6290 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x5 | 6013182.5276 | 2090518.895 | 37.7209087510834 | -122.39647726989 | (37.7209087510834, -122.39647726989) | 10 | 3 | 8 | 58 | 1 | |||
304 | 132028 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 33x Battery St | 1 | Median : Yard | Tree | DPW 1 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.399447311639 | (37.7911327033699, -122.399447311639) | 4 | 1 | 10 | 28854 | 6 | ||||
306 | 20543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1303X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
310 | 218546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | : | Tree | Private 2 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | 9 | 8 | 4 | 64 | 40 | |||
311 | 138787 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2714 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000799 | 2114887 | 37.7871207435599 | -122.441030597921 | (37.7871207435599, -122.441030597921) | 13 | 6 | 1 | 29490 | 27 | |||
312 | 201949 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 18 | : | Tree | Private 2 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | 10 | 3 | 8 | 58 | 1 | |||
313 | 119729 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
314 | 184219 | DPW Maintained 1 | :: 45 | 3439 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984114.8945 | 2104934.4274 | 37.7588294281219 | -122.498017803137 | (37.7588294281219, -122.498017803137) | 1 | 8 | 3 | 56 | 35 | |||
316 | 245380 | DPW Maintained 1 | :: 45 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005334.5439 | 2097112.3285 | 37.7385729952273 | -122.424074069598 | (37.7385729952273, -122.424074069598) | 2 | 7 | 5 | 28859 | 2 | |||
317 | 189161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.415210253457 | (37.7724477670719, -122.415210253457) | 8 | 2 | 9 | 28853 | 19 | |||
318 | 190050 | DPW Maintained 1 | Cinnamomum camphora :: Camphor Tree 90 | 601 Amador St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6016946.57228 | 2099501.56467 | 37.7457821291547 | -122.384091181786 | (37.7457821291547, -122.384091181786) | 10 | 3 | 8 | 58 | 1 | |||
320 | 228444 | DPW Maintained 1 | :: 45 | 399 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004268.91864 | 2109406.82097 | 37.7722705538615 | -122.428634644993 | (37.7722705538615, -122.428634644993) | 7 | 9 | 11 | 28852 | 10 | |||
321 | 219060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000072.85251 | 2094491.10418 | 37.731077247812 | -122.442078323383 | (37.731077247812, -122.442078323383) | 9 | 7 | 4 | 63 | 40 | |||
322 | 131741 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2901 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000273.04756 | 2116436.32711 | 37.7913448210684 | -122.44296157632 | (37.7913448210684, -122.44296157632) | 13 | 6 | 1 | 29490 | 27 | |||
324 | 97786 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 810 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012446.82878 | 2118928.41788 | 37.7988740576432 | -122.401015485586 | (37.7988740576432, -122.401015485586) | 3 | 1 | 10 | 28860 | 6 | |||
325 | 248307 | DPW Maintained 1 | :: 45 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.445507509409 | (37.7691713129844, -122.445507509409) | 15 | 5 | 11 | 29492 | 9 | |||
326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
327 | 182422 | DPW Maintained 1 | :: 45 | 1534 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987477.4649 | 2104817.3887 | 37.7587046434176 | -122.486380033207 | (37.7587046434176, -122.486380033207) | 1 | 8 | 3 | 56 | 35 | |||
328 | 197129 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 11 | : | Tree | Private 2 | 5 | Width 3ft | 6015974.4503 | 2097856.83037 | 37.7412122331485 | -122.387337958305 | (37.7412122331485, -122.387337958305) | 10 | 3 | 8 | 58 | 1 | |||
330 | 250773 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 259 32nd Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | 11 | 6 | 1 | 55 | 33 | |||
331 | 194117 | DPW Maintained 1 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 2 13th St | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6009035.07102 | 2108345.44011 | 37.7696248302591 | -122.412073015253 | (37.7696248302591, -122.412073015253) | 8 | 4 | 9 | 28853 | 19 | |||
332 | 182987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1975 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989890.895 | 2098325.8493 | 37.7410209633467 | -122.477558903564 | (37.7410209633467, -122.477558903564) | 1 | 8 | 3 | 29491 | 35 | |||
334 | 162296 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010920.41592 | 2090984.45712 | 37.7220609417541 | -122.40432950351 | (37.7220609417541, -122.40432950351) | 10 | 3 | 7 | 309 | 28 | ||
336 | 189035 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010091.10409 | 2111787.20644 | 37.7791343146469 | -122.408663052281 | (37.7791343146469, -122.408663052281) | 14 | 2 | 9 | 28853 | 34 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );