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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4144 | 4144 | 216652 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 329 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:15:00 AM | 3 | Width 4ft | 5994725.9247 | 2090785.7094700001 | 37.7205969659665 | -122.460295076156 | (37.7205969659665, -122.460295076156) | ||
4146 | 4146 | 216707 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:46:00 AM | 3 | Width 3ft | 5994758.05727 | 2090129.91465 | 37.7187981581945 | -122.460136518501 | (37.7187981581945, -122.460136518501) | ||
4150 | 4150 | 216749 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 26 Granada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:25:00 AM | 3 | Width 3ft | 5995639.9781599995 | 2090086.85434 | 37.7187306119189 | -122.45708497580699 | (37.7187306119189, -122.457084975807) | ||
4152 | 4152 | 216685 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.8719900001 | 37.720244788744104 | -122.46233566126101 | (37.7202447887441, -122.462335661261) | ||
4153 | 4153 | 216751 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 31 Granada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:38:00 AM | 3 | Width 3ft | 5995599.77101 | 2090122.1597400003 | 37.718825243070604 | -122.45722650749799 | (37.7188252430706, -122.457226507498) | ||
4163 | 4163 | 216683 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 129 Ashton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:06:00 AM | 3 | Width 3ft | 5994135.07503 | 2090797.4570099998 | 37.7205952167724 | -122.462338293592 | (37.7205952167724, -122.462338293592) | ||
4183 | 4183 | 180766 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | ||
4184 | 4184 | 180651 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:53:00 AM | 3 | Width 7ft | 6001223.66869 | 2087409.71788 | 37.7116988757881 | -122.43759282156601 | (37.7116988757881, -122.437592821566) | ||
4196 | 4196 | 251778 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 10:02:00 AM | 3 | Width 7ft | 6001223.66869 | 2087409.71788 | 37.7116988757881 | -122.43759282156601 | (37.7116988757881, -122.437592821566) | ||
4205 | 4205 | 251774 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 10:14:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.7886599998 | 37.711579156239296 | -122.435864336264 | (37.7115791562393, -122.435864336264) | ||
4209 | 4209 | 180663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.709116270155604 | -122.43351405884898 | (37.7091162701556, -122.433514058849) | ||
4220 | 4220 | 181020 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.9301099998 | 37.714476492181895 | -122.438602919392 | (37.7144764921819, -122.438602919392) | ||
4227 | 4227 | 181017 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 197 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:28:00 AM | 3 | Width 4ft | 6001019.31887 | 2088386.79799 | 37.7143700996689 | -122.43836906510201 | (37.7143700996689, -122.438369065102) | ||
4231 | 4231 | 180667 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 344 Chicago Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:51:00 PM | 3 | Width 6ft | 6002403.88387 | 2086502.6359 | 37.709275259527296 | -122.43344890203998 | (37.7092752595273, -122.43344890204) | ||
4244 | 4244 | 180664 | Undocumented 2 | Magnolia champaca :: Champa 170 | 339 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:55:00 PM | 3 | Width 6ft | 6002468.5653 | 2086489.08528 | 37.7092417219876 | -122.43322438540399 | (37.7092417219876, -122.433224385404) | ||
4245 | 4245 | 181019 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.714429647391896 | -122.438501549606 | (37.7144296473919, -122.438501549606) | ||
4249 | 4249 | 180650 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:41:00 AM | 3 | Width 7ft | 6001253.45718 | 2087396.1433599999 | 37.7116632967974 | -122.437488893205 | (37.7116632967974, -122.437488893205) | ||
4254 | 4254 | 180668 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:45:00 PM | 3 | Width 6ft | 6002314.90905 | 2086461.72548 | 37.709157880008 | -122.433753490754 | (37.709157880008, -122.433753490754) | ||
4257 | 4257 | 181010 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 215 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:17:00 AM | 3 | Width 4ft | 6001139.6561 | 2088316.9005900002 | 37.7141850209845 | -122.437948129327 | (37.7141850209845, -122.437948129327) | ||
4271 | 4271 | 180665 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 316 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 02:13:00 PM | 3 | Width 6ft | 6002643.65919 | 2086652.61793 | 37.7097006784091 | -122.432630907484 | (37.7097006784091, -122.432630907484) | ||
4272 | 4272 | 251777 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 178 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:57:00 AM | 3 | Width 7ft | 6001223.66869 | 2087409.71788 | 37.7116988757881 | -122.43759282156601 | (37.7116988757881, -122.437592821566) | ||
4273 | 4273 | 181018 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.0469099998 | 37.714394713229105 | -122.43841724088999 | (37.7143947132291, -122.43841724089) | ||
4284 | 4284 | 175543 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 187 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:37:00 AM | 3 | Width 6ft | 6001178.343719999 | 2087386.3168 | 37.7116320444605 | -122.43774780171302 | (37.7116320444605, -122.437747801713) | ||
4293 | 4293 | 216862 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 272 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 08:43:00 AM | 3 | Width 3ft | 5994260.82584 | 2087785.69998 | 37.7123328897311 | -122.461685361516 | (37.7123328897311, -122.461685361516) | ||
4296 | 4296 | 251775 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 10:17:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.7886599998 | 37.711579156239296 | -122.435864336264 | (37.7115791562393, -122.435864336264) | ||
4306 | 4306 | 181011 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 207 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 11:21:00 AM | 3 | Width 4ft | 6001121.315830001 | 2088326.0025400002 | 37.714208969932706 | -122.438012171843 | (37.7142089699327, -122.438012171843) | ||
4315 | 4315 | 216902 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 174 Bright St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 11:02:00 AM | 3 | Width 3ft | 5993764.72474 | 2088364.55203 | 37.7138937098892 | -122.46344200363899 | (37.7138937098892, -122.463442003639) | ||
4358 | 4358 | 180653 | Undocumented 2 | Magnolia champaca :: Champa 170 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.43193406871299 | (37.7100419513527, -122.431934068713) | ||
4400 | 4400 | 251729 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 35 Bruce Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 10:39:00 AM | 3 | Width 3ft | 5997172.50242 | 2091270.81822 | 37.7220693917577 | -122.45187305021099 | (37.7220693917577, -122.451873050211) | ||
4415 | 4415 | 216758 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 35 Bruce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 10:35:00 AM | 3 | Width 3ft | 5997172.50242 | 2091270.81822 | 37.7220693917577 | -122.45187305021099 | (37.7220693917577, -122.451873050211) | ||
4451 | 4451 | 216718 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.45912417326299 | (37.7196152839906, -122.459124173263) | ||
4467 | 4467 | 216711 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 922 Capitol Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 12:14:00 PM | 3 | Width 3ft | 5995050.42243 | 2090071.97473 | 37.7186558809545 | -122.45912174238998 | (37.7186558809545, -122.45912174239) | ||
4484 | 4484 | 251776 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 12:12:00 PM | 3 | Width 6ft | 6001722.65495 | 2087355.7886599998 | 37.711579156239296 | -122.435864336264 | (37.7115791562393, -122.435864336264) | ||
4488 | 4488 | 216714 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 934 Capitol Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:10:00 AM | 3 | Width 3ft | 5995052.942530001 | 2090158.7504099999 | 37.7188942912315 | -122.459119311509 | (37.7188942912315, -122.459119311509) | ||
4734 | 4734 | 181032 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 51 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/24/2017 12:14:00 PM | 3 | Width 4ft | 6000613.84351 | 2088248.98957 | 37.7139686369286 | -122.439760670618 | (37.7139686369286, -122.439760670618) | ||
4769 | 4769 | 194422 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 52 | Width 5ft | 6007901.53326 | 2109054.5781799997 | 37.771508291196 | -122.41604412194401 | (37.771508291196, -122.416044121944) | |||
4797 | 4797 | 214559 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1342 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | ||
4821 | 4821 | 214558 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 4 | Width 3ft | 5991564.93185 | 2106609.34919 | 37.7638622938456 | -122.472374472204 | (37.7638622938456, -122.472374472204) | ||
4903 | 4903 | 239064 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 68 12th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 10/31/2016 12:00:00 AM | 3 | Width 3ft | 6007045.28032 | 2109725.44965 | 37.77330216528821 | -122.41905354577699 | (37.7733021652882, -122.419053545777) | ||
5045 | 5045 | 123372 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 785 03rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5995014.0 | 2110353.0 | 37.7743403969856 | -122.46071658922399 | (37.7743403969856, -122.460716589224) | |||
5057 | 5057 | 123370 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 785 03rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 4ft | 5995014.0 | 2110353.0 | 37.7743403969856 | -122.46071658922399 | (37.7743403969856, -122.460716589224) | |||
5245 | 5245 | 205593 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 30 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995699.652000001 | 2100090.8564 | 37.746202601761105 | -122.45760214624201 | (37.7462026017611, -122.457602146242) | |||
9497 | 9497 | 122159 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 547 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 5991246.192840001 | 2111684.05416 | 37.7777776077222 | -122.473847129053 | (37.7777776077222, -122.473847129053) | |||
9934 | 9934 | 102961 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9935 | 9935 | 102960 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9936 | 9936 | 102965 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9937 | 9937 | 102966 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9939 | 9939 | 102963 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9940 | 9940 | 102969 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9941 | 9941 | 102968 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9943 | 9943 | 102967 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9944 | 9944 | 11821 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | ||
9945 | 9945 | 102971 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
9947 | 9947 | 11824 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | PUC 13 | 03/13/2013 12:00:00 AM | 2 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | ||
10103 | 10103 | 173844 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2X Crestline Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5999319.0 | 2101169.0 | 37.7493701671822 | -122.445164434644 | (37.7493701671822, -122.445164434644) | |||||
10991 | 10991 | 116458 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 267 | 777 Brotherhood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 10x20 | 5989819.39068 | 2088633.8654 | 37.7144050769972 | -122.477098071327 | (37.7144050769972, -122.477098071327) | |||
13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
13307 | 13307 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997267.0 | 2099886.0 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | ||||
16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
18835 | 18835 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
19238 | 19238 | 104509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 DICHIERA CT | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5998620.0 | 2088043.0 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | |||||
19268 | 19268 | 104883 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990322.1 | 2090011.1 | 37.718215776001294 | -122.475461023549 | (37.7182157760013, -122.475461023549) | |||||
22365 | 22365 | 141244 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 31 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5996487.1971 | 2114345.4775 | 37.7853873361438 | -122.455909239222 | (37.7853873361438, -122.455909239222) | |||
22816 | 22816 | 208166 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 15 Santa Rita Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993909.69845 | 2100938.88006 | 37.7484280758139 | -122.463853078355 | (37.7484280758139, -122.463853078355) | |||
22821 | 22821 | 197331 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6014124.123369999 | 2101967.77095 | 37.752397360459 | -122.39402349321199 | (37.752397360459, -122.394023493212) | ||||
22882 | 22882 | 176369 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990491.08034 | 2089186.3269 | 37.7159609464097 | -122.47481676917101 | (37.7159609464097, -122.474816769171) | ||||
22887 | 22887 | 120259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 24th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5988369.32629 | 2115004.14379 | 37.7867265878172 | -122.484042609601 | (37.7867265878172, -122.484042609601) | |||
22906 | 22906 | 240229 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 116 Crescent Ave | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 10ft | 6006267.81246 | 2095797.32513 | 37.7350149365947 | -122.42075393896299 | (37.7350149365947, -122.420753938963) | |||
22912 | 22912 | 210552 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 414 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5995155.65345 | 2100448.38141 | 37.7471530116111 | -122.459509101961 | (37.7471530116111, -122.459509101961) | |||
22986 | 22986 | 250821 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 45 Sea View Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5986295.23656 | 2114137.57517 | 37.7842262706806 | -122.49115456935 | (37.7842262706806, -122.49115456935) | |||
23367 | 23367 | 208982 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 320 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | Width 3ft | 5993096.565780001 | 2095876.3159599998 | 37.7344806601409 | -122.46629697974501 | (37.7344806601409, -122.466296979745) | |||
23375 | 23375 | 218050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 72 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991878.2117099995 | 2095609.0189900002 | 37.7336763568794 | -122.470489732417 | (37.7336763568794, -122.470489732417) | |||
23387 | 23387 | 213501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 787 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994873.7468 | 2093233.8423799998 | 37.7273274525845 | -122.459961359351 | (37.7273274525845, -122.459961359351) | |||
23396 | 23396 | 218586 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3666 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5990534.77048 | 2091965.7217599999 | 37.7235950079882 | -122.474868513494 | (37.7235950079882, -122.474868513494) | |||
23401 | 23401 | 202171 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6013157.586080001 | 2093193.49557 | 37.7282512748665 | -122.39675089323799 | (37.7282512748665, -122.396750893238) | |||
23402 | 23402 | 123384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 03rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5995024.54572 | 2110548.53973 | 37.7748779041184 | -122.460694283234 | (37.7748779041184, -122.460694283234) | |||
23409 | 23409 | 218091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 62 Eastwood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995658.864080001 | 2092992.02847 | 37.726708612908 | -122.45722974236601 | (37.726708612908, -122.457229742366) | |||
23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
23425 | 23425 | 236043 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 821 Duboce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6001824.27489 | 2108233.40905 | 37.768910001429 | -122.43700684760701 | (37.768910001429, -122.437006847607) | |||
23431 | 23431 | 213073 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994467.524230001 | 2101712.07423 | 37.7505832012692 | -122.46198020334299 | (37.7505832012692, -122.461980203343) | |||
23444 | 23444 | 201445 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6018205.83588 | 2096062.22823 | 37.7364079387746 | -122.379497902505 | (37.7364079387746, -122.379497902505) | |||
23445 | 23445 | 222731 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1435 Douglass St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6001402.34337 | 2099545.22287 | 37.7450303552734 | -122.437843913168 | (37.7450303552734, -122.437843913168) | |||
23447 | 23447 | 140934 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 120 JORDAN AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5996249.4558 | 2113606.8719 | 37.7833456744969 | -122.456678312901 | (37.7833456744969, -122.456678312901) | |||
23448 | 23448 | 121887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5990232.62779 | 2114784.35142 | 37.78623140306821 | -122.47758002792801 | (37.7862314030682, -122.477580027928) | |||
23452 | 23452 | 207071 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5993749.481269999 | 2102344.6615 | 37.752278758765605 | -122.464509159894 | (37.7522787587656, -122.464509159894) | |||
23456 | 23456 | 122922 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 2 11th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5992430.88304 | 2114907.16681 | 37.7866959384714 | -122.469983652903 | (37.7866959384714, -122.469983652903) | |||
23481 | 23481 | 218410 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 205 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994280.90702 | 2100599.38004 | 37.7475172792951 | -122.462544833698 | (37.7475172792951, -122.462544833698) | |||
23485 | 23485 | 206309 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 226 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5994744.569130001 | 2087779.6169999999 | 37.712344021541796 | -122.46001297051599 | (37.7123440215418, -122.460012970516) | |||
23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
23514 | 23514 | 190971 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | 6011272.24417 | 2104307.20268 | 37.7586620081736 | -122.40405043579099 | (37.7586620081736, -122.404050435791) | ||||
23523 | 23523 | 208876 | Undocumented 2 | Malus :: Crab Apple 235 | 24 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993960.680430001 | 2101012.29566 | 37.7486325942246 | -122.463682112736 | (37.7486325942246, -122.463682112736) | |||
23530 | 23530 | 222049 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Treat Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6008976.23011 | 2107818.47181 | 37.768174596097104 | -122.41223929451401 | (37.7681745960971, -122.412239294514) | |||
23531 | 23531 | 212068 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 6ft | 5994349.34377 | 2097659.88165 | 37.7394500943456 | -122.46209504585501 | (37.7394500943456, -122.462095045855) | |||
23538 | 23538 | 213933 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | |||
23539 | 23539 | 122063 | Undocumented 2 | Ilex spp :: Holly Species 163 | 5 17th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5990505.08019 | 2115005.32961 | 37.786853953760705 | -122.476653573827 | (37.7868539537607, -122.476653573827) | |||
23557 | 23557 | 213451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5993177.52134 | 2099659.6696900004 | 37.7448734694269 | -122.466291957027 | (37.7448734694269, -122.466291957027) | |||
23577 | 23577 | 118033 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 89 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5984120.82492 | 2112822.3596099997 | 37.780487786596204 | -122.498579960483 | (37.7804877865962, -122.498579960483) | |||
23592 | 23592 | 218660 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 70 Eastwood Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5995653.32428 | 2093064.51564 | 37.726907327111 | -122.45725413468901 | (37.726907327111, -122.457254134689) | |||
23600 | 23600 | 135193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 35 Bay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 6010885.4927900005 | 2121705.9799599997 | 37.806413341469 | -122.40661408636801 | (37.806413341469, -122.406614086368) | |||
23638 | 23638 | 179012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001860.73543 | 2090148.2767900003 | 37.719254552441704 | -122.435586742551 | (37.7192545524417, -122.435586742551) |
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");