Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5254 | 5254 | 253839 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006239.0 | 2097690.0 | 37.740210176126794 | -122.42098789234 | (37.7402101761268, -122.42098789234) | ||||
5190 | 5190 | 253817 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001018.0 | 2098627.0 | 37.742487269754704 | -122.43910710368601 | (37.7424872697547, -122.439107103686) | ||||
5085 | 5085 | 253795 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5099 | 5099 | 253794 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5097 | 5097 | 253793 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5081 | 5081 | 253792 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5092 | 5092 | 253791 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
5101 | 5101 | 253790 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
5090 | 5090 | 253789 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
5094 | 5094 | 253788 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1663X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991413.0 | 2103963.0 | 37.756587325686105 | -122.472706989611 | (37.7565873256861, -122.472706989611) | ||||
5106 | 5106 | 253787 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
5083 | 5083 | 253786 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
5104 | 5104 | 253785 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
5102 | 5102 | 253784 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1709X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991403.0 | 2103783.0 | 37.756092514171904 | -122.472728448949 | (37.7560925141719, -122.472728448949) | ||||
5100 | 5100 | 253781 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5107 | 5107 | 253780 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5095 | 5095 | 253779 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5089 | 5089 | 253778 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5105 | 5105 | 253777 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
5008 | 5008 | 253723 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 1X Glenview Dr | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 5998487.0 | 2100314.0 | 37.746975021233204 | -122.447979947083 | (37.7469750212332, -122.447979947083) | |||||
4716 | 4716 | 253674 | DPW Maintained 3 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 600 x Sanchez St | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 6003598.0 | 2104743.0 | 37.75942683738779 | -122.43062255590701 | (37.7594268373878, -122.430622555907) | ||||
4727 | 4727 | 253673 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 600 x Sanchez St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 6003598.0 | 2104743.0 | 37.75942683738779 | -122.43062255590701 | (37.7594268373878, -122.430622555907) | ||||
4719 | 4719 | 253672 | DPW Maintained 3 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
4669 | 4669 | 253646 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/09/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
4684 | 4684 | 253645 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
4668 | 4668 | 253644 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/05/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
4562 | 4562 | 253642 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.40823488063499 | (37.7988770104459, -122.408234880635) | ||||
4620 | 4620 | 253639 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4405 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 5993893.0 | 2114132.0 | 37.784651953064206 | -122.46486880251801 | (37.7846519530642, -122.464868802518) | |||
4538 | 4538 | 253635 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 830 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | ||||
4548 | 4548 | 253634 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 830 Oak St | 1 | Sidewalk: Property side : Cutout 5 | tree 3 | DPW 2 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | |||||
4506 | 4506 | 253629 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
4520 | 4520 | 253628 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
4446 | 4446 | 253627 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 5991061.0 | 2093828.0 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | ||||
4063 | 4063 | 253608 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 5998814.0 | 2100235.0 | 37.746776792757004 | -122.44684353081101 | (37.746776792757, -122.446843530811) | ||||
3917 | 3917 | 253597 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010453.0 | 2107072.0 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | ||||
3750 | 3750 | 253551 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 19 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3837 | 3837 | 253550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 18 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3841 | 3841 | 253549 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 17 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3758 | 3758 | 253548 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 16 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3842 | 3842 | 253547 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 15 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3840 | 3840 | 253546 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 14 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3832 | 3832 | 253545 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 13 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:58:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3902 | 3902 | 253544 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 12 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:38:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3900 | 3900 | 253543 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 11 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:35:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3896 | 3896 | 253542 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 10 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 02:42:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3899 | 3899 | 253541 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 9 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 03:59:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3906 | 3906 | 253540 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 8 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 04:11:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
4040 | 4040 | 253539 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 7 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:07:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3754 | 3754 | 253538 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 6 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:43:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
4116 | 4116 | 253537 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 5 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:02:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
4033 | 4033 | 253536 | DPW Maintained 3 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 1000 Cayuga Ave | 4 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:10:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3755 | 3755 | 253535 | DPW Maintained 3 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 1000 Cayuga Ave | 3 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3761 | 3761 | 253534 | DPW Maintained 3 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 1000 Cayuga Ave | 2 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:08:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
3760 | 3760 | 253533 | DPW Maintained 3 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 1000 Cayuga Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 01:57:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
4690 | 4690 | 253527 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | ||
3586 | 3586 | 253468 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 801X Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | ||||||||||
4745 | 4745 | 253432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:09:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
4805 | 4805 | 253431 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:07:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
4788 | 4788 | 253430 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:04:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
3390 | 3390 | 253422 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 2X Miraloma Dr | 1 | Side Yard : Cutout 18 | Tree 1 | DPW 2 | 10x10 | 5994995.0 | 2097925.0 | 37.740215196600396 | -122.459881864698 | (37.7402151966004, -122.459881864698) | ||||
3208 | 3208 | 253368 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x10 | 5992398.0 | 2093455.0 | 37.7277919980392 | -122.468536018982 | (37.7277919980392, -122.468536018982) | ||||
3007 | 3007 | 253279 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 201X Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 10x10 | ROW IS 10' tree is street tree | ||||||||
2896 | 2896 | 253266 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2411 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992016.868969999 | 2094311.4593 | 37.730121598969205 | -122.469915916098 | (37.7301215989692, -122.469915916098) | |||
2754 | 2754 | 253208 | DPW Maintained 3 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 201x Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011752.0 | 2111938.0 | 37.7796412414558 | -122.402927910408 | (37.7796412414558, -122.402927910408) | ||||
4536 | 4536 | 253202 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
4532 | 4532 | 253201 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
4545 | 4545 | 253200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
4541 | 4541 | 253199 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
3723 | 3723 | 253167 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
2573 | 2573 | 253125 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 1 Oak Park Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5996419.0 | 2103319.0 | 37.7551075738744 | -122.455348004876 | (37.7551075738744, -122.455348004876) | ||||
3147 | 3147 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | ||
4489 | 4489 | 253086 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2849X Alemany Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:29:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4500 | 4500 | 253085 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2849X Alemany Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:40:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4498 | 4498 | 253084 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:31:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4453 | 4453 | 253083 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2849X Alemany Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:53:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4493 | 4493 | 253082 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2849X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:25:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4465 | 4465 | 253081 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4458 | 4458 | 253080 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2849X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:00:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4483 | 4483 | 253079 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:57:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4527 | 4527 | 253078 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:44:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4508 | 4508 | 253077 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:16:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4524 | 4524 | 253076 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:52:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4511 | 4511 | 253075 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:04:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4455 | 4455 | 253074 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:14:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
4529 | 4529 | 253073 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:54:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
2333 | 2333 | 253025 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2017 12:00:00 AM | 3 | 5993444.58369 | 2103545.63859 | 37.7555587516047 | -122.465650780273 | (37.7555587516047, -122.465650780273) | |||
2208 | 2208 | 252955 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
2206 | 2206 | 252954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
2179 | 2179 | 252925 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700 Sanchez St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
2186 | 2186 | 252924 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
2156 | 2156 | 252915 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1924 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/2012 12:00:00 AM | 3x3 | 6007321.0 | 2118975.0 | 37.79871469295279 | -122.418755881393 | (37.7987146929528, -122.418755881393) | |||
2144 | 2144 | 252907 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Point Lobos Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10x10 | 5982783.76519 | 2112486.06679 | 37.7794859217892 | -122.50318049806101 | (37.7794859217892, -122.503180498061) | ||||
2087 | 2087 | 252878 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6014268.0 | 2110701.0 | 37.776384889187796 | -122.394137287636 | (37.7763848891878, -122.394137287636) | |||
2075 | 2075 | 252867 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
2067 | 2067 | 252866 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
2083 | 2083 | 252865 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
2050 | 2050 | 252861 | DPW Maintained 3 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | |
2061 | 2061 | 252860 | DPW Maintained 3 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 167 | 1800X Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002556.0 | 2114541.0 | 37.7862706325854 | -122.434927017215 | (37.7862706325854, -122.434927017215) | ||||
2058 | 2058 | 252859 | DPW Maintained 3 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 167 | 1800X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002556.0 | 2114541.0 | 37.7862706325854 | -122.434927017215 | (37.7862706325854, -122.434927017215) | ||||
2049 | 2049 | 252858 | DPW Maintained 3 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 167 | 1800X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002556.0 | 2114541.0 | 37.7862706325854 | -122.434927017215 | (37.7862706325854, -122.434927017215) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");