Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2 sorted by PlantDate descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate ▲ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
98992 98992 114476 Significant Tree 6 Pittosporum spp :: Pittosporum spp 128 299x UNION ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   12/29/2015 12:00:00 AM       6011527.0 2119680.0 37.8008863659875 -122.40425133897 (37.8008863659875, -122.40425133897)
80961 80961 104879 Permitted Site 1 Melaleuca quinquenervia :: Cajeput 50 234 28th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   11/25/2013 12:00:00 AM     Permit Number 771117 5987170.1 2114381.0 37.784945722992504 -122.488145785283 (37.7849457229925, -122.488145785283)
115865 115865 104878 Permitted Site 1 Melaleuca quinquenervia :: Cajeput 50 234 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   11/25/2013 12:00:00 AM     Permit Number 771117 5987170.1 2114381.0 37.784945722992504 -122.488145785283 (37.7849457229925, -122.488145785283)
107212 107212 104811 Permitted Site 1 Tree(s) :: 17 1900 08th Ave   Sidewalk: Curb side : Yard 2 Tree 1 Private 1   11/18/2013 12:00:00 AM     Permit Number 770426 5993817.2 2102486.9 37.7526732127641 -122.46428530535499 (37.7526732127641, -122.464285305355)
10370 10370 107580 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 100 Panama St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992406.39157 2086830.73395 37.709603859212706 -122.468025367885 (37.7096038592127, -122.468025367885)
10524 10524 107581 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 100 Panama St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992393.946819999 2086830.9956900002 37.7096038591978 -122.46806839775299 (37.7096038591978, -122.468068397753)
11907 11907 107582 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 100 Panama St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992337.55751 2086836.4734200002 37.7096156430274 -122.46826368552 (37.7096156430274, -122.46826368552)
12169 12169 107579 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 100 Panama St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992416.91174 2086830.03613 37.7096025506984 -122.467988957943 (37.7096025506984, -122.467988957943)
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)
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)
3678 3678 208759 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 300 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993126.46853 2099702.60224 37.7449884054972 -122.466471606489 (37.7449884054972, -122.466471606489)
3683 3683 213464 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993110.29995 2099700.9644 37.7449829754007 -122.46652739502701 (37.7449829754007, -122.466527395027)
2934 2934 250407 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 25 Seacliff Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/16/1997 12:00:00 AM 12 Width 4ft Permit Number 38521 5987994.17396 2115794.4903599997 37.78887480516529 -122.485398549405 (37.7888748051653, -122.485398549405)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
4129 4129 216706 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 231 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/06/2017 08:40:00 AM 3 Width 3ft   5994712.86869 2090137.86358 37.718817384787606 -122.460293291921 (37.7188173847876, -122.460293291921)
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)
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)
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)
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)
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)
4061 4061 252970 Private 5 Pyrus kawakamii :: Evergreen Pear 82 101X Whipple Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 12:21:00 PM 3              
4006 4006 216739 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 11 Brighton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 08:12:00 AM 3 Width 3ft   5996185.57101 2089978.26988 37.7184637821573 -122.4551912491 (37.7184637821573, -122.4551912491)
4071 4071 251734 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 856 Prague St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 08:08:00 AM 3 Width 6ft   6002039.2106099995 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839)
4096 4096 181028 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Rolph St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.4676599998 37.715132307492794 -122.44007027934201 (37.7151323074928, -122.440070279342)
4113 4113 181027 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 95 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.2481099998 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188)
3999 3999 181035 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 170 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:20:00 PM 3 Width 4ft   6000927.8060099995 2088408.3131900001 37.7144239699579 -122.438686909772 (37.7144239699579, -122.438686909772)
4083 4083 181036 Undocumented 2 Podocarpus gracilor :: Fern Pine 13 170 Rolph St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 04:16:00 PM 3 Width 4ft   6000944.46471 2088397.62402 37.7143955675655 -122.438628565353 (37.7143955675655, -122.438628565353)
4014 4014 216033 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 4 Lobos St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:13:00 PM 3     5996833.19651 2088697.5304900003 37.7149843051513 -122.452860296276 (37.7149843051513, -122.452860296276)
4026 4026 216034 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 8 Lobos St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:11:00 PM 3     5996778.28459 2088695.06883 37.714974399131705 -122.45304991653099 (37.7149743991317, -122.453049916531)
4004 4004 251722 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 18 Lobos St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:08:00 PM 3     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)
4092 4092 216045 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 36 Lobos St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:04:00 PM 3     5996513.0629 2088696.2251900001 37.7149623706927 -122.45396671331999 (37.7149623706927, -122.45396671332)
4103 4103 216046 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 38 Lobos St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 03:02:00 PM 3     5996487.74032 2088710.41168 37.7149998715299 -122.454055262356 (37.7149998715299, -122.454055262356)
4117 4117 216048 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 40 Lobos St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 02:58:00 PM 3     5996463.1782599995 2088711.43982 37.7150012861457 -122.45414023299999 (37.7150012861457, -122.454140233)
4008 4008 216051 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 48 Lobos St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 02:54:00 PM 3     5996419.4156599995 2088710.03455 37.7149949180514 -122.454291392827 (37.7149949180514, -122.454291392827)
4030 4030 216055 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 52 Lobos St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 02:49:00 PM 3     5996381.618969999 2088696.9088599999 37.714956710372 -122.454421085891 (37.714956710372, -122.454421085891)
4097 4097 216058 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 58 Lobos St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/05/2017 02:35:00 PM 3     5996320.31527 2088710.5585599998 37.7149906732676 -122.45463396169599 (37.7149906732676, -122.454633961696)
3943 3943 216737 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 11 Lee Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/04/2017 02:31:00 PM 3 Width 2ft   5996481.70655 2089974.5093900003 37.7184704425356 -122.45416736555799 (37.7184704425356, -122.454167365558)
3959 3959 216642 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 50 Lee Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/04/2017 01:57:00 PM 3 Width 2ft   5996528.83108 2090217.4765599999 37.7191402755735 -122.45402201441999 (37.7191402755735, -122.45402201442)
3920 3920 216755 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 115 Harold Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/04/2017 01:38:00 PM 3 Width 3ft   5996789.877280001 2090654.02957 37.720353912480995 -122.453151180205 (37.720353912481, -122.453151180205)
3850 3850 207785 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 290 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
105728 105728 104942 Undocumented 2 Tree(s) :: 17 840X Gonzalez Dr   Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/11/2014 12:00:00 AM 3   Permit Number 770723 5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
138617 138617 104911 Undocumented 2 Tree(s) :: 17 605 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/11/2014 12:00:00 AM 3   Permit Number 770292 5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
107759 107759 120952 Significant Tree 6 Tree(s) :: 17 100X 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 10x10 Permit Number 778529 5985781.0 2114962.0 37.7864598433405 -122.492994369609 (37.7864598433405, -122.492994369609)
3033 3033 253285 Undocumented 2 Cordyline australis :: Dracena Palm 141 8245 Geary Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   08/15/2017 12:00:00 AM 3     5981372.0 2112274.0 37.7788205636315 -122.50804856364901 (37.7788205636315, -122.508048563649)
2760 2760 251575 Significant Tree 6 Pinus radiata :: Monterey Pine 3 300 Sussex St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194.0 2096647.0 37.737060666835205 -122.438356728037 (37.7370606668352, -122.438356728037)
2567 2567 252819 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 407 Miguel St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/19/2017 12:00:00 AM 3   Permit Number 780051 6004479.0 2096413.0 37.736604456337105 -122.426982337456 (37.7366044563371, -122.426982337456)
80442 80442 94324 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501@ 28th Ave El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)
98037 98037 94322 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)
105503 105503 94325 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501@ 28th Ave El Camino Del Mar 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)
108814 108814 94323 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501@ 28th Ave El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)
126914 126914 94321 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 501 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/15/2010 12:00:00 AM     Permit Number 53625 5987118.0 2115378.0 37.7876801589176 -122.488399329426 (37.7876801589176, -122.488399329426)
2983 2983 250419 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 49 Seacliff Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/14/1997 12:00:00 AM 8 Width 4ft Permit Number 38081 5987849.1846199995 2115791.00757 37.7888567944531 -122.48589993045601 (37.7888567944531, -122.485899930456)
2383 2383 201821 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021045.51426 2093266.4470799998 37.7288874606638 -122.369486691782 (37.7288874606638, -122.369486691782)
2387 2387 201822 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021035.49669 2093250.0299200001 37.72884183267921 -122.36952018972299 (37.7288418326792, -122.369520189723)
2402 2402 201606 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 598 Innes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020954.32481 2093200.4635700001 37.7287012794353 -122.36979738594101 (37.7287012794353, -122.369797385941)
2408 2408 201820 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021056.53291 2093279.09213 37.728922786051506 -122.369449472416 (37.7289227860515, -122.369449472416)
2417 2417 201819 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Friedell St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 3 Width 4ft   6021071.50009 2093300.7706900002 37.7289831323462 -122.369399226393 (37.7289831323462, -122.369399226393)
2465 2465 201607 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 598 Innes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/12/2017 12:00:00 AM 1 Width 3ft   6020934.32673 2093214.8340900003 37.7287396409072 -122.36986751418699 (37.7287396409072, -122.369867514187)
83540 83540 111656 Undocumented 2 Myoporum laetum :: Myoporum 1 1740 CESAR CHAVEZ ST 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
96677 96677 111660 Undocumented 2 Myoporum laetum :: Myoporum 1 1740 CESAR CHAVEZ ST 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
106585 106585 111654 Undocumented 2 Myoporum laetum :: Myoporum 1 1740 CESAR CHAVEZ ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
112222 112222 111655 Undocumented 2 Myoporum laetum :: Myoporum 1 1740 CESAR CHAVEZ ST 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
122826 122826 111659 Undocumented 2 Myoporum laetum :: Myoporum 1 1740 CESAR CHAVEZ ST 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
126012 126012 111657 Undocumented 2 Myoporum laetum :: Myoporum 1 1740 CESAR CHAVEZ ST 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
127871 127871 111658 Undocumented 2 Myoporum laetum :: Myoporum 1 1740 CESAR CHAVEZ ST 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
2211 2211 188595 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Rhode Island St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
11147 11147 83378 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 586 Athens St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52310 6003277.11077 2089949.83191 37.718790012118795 -122.430676716663 (37.7187900121188, -122.430676716663)
2180 2180 251495 Significant Tree 6 Tree(s) :: 17 2448 Clay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026.0 2116224.0 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488)
116050 116050 111759 Permitted Site 1 :: 54 1235 47th Ave 2 Sidewalk: Curb side : Yard 2 Landscaping 2 Private 1   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
11417 11417 117425 Permitted Site 1 Magnolia champaca :: Champa 170 218 Athens St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 775470 6004576.76699 2091985.7103900001 37.724453633907 -122.426329194258 (37.724453633907, -122.426329194258)
12904 12904 117426 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 395 Athens St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 775297 6003998.920059999 2091015.17385 37.7217560742586 -122.428257595231 (37.7217560742586, -122.428257595231)
111271 111271 111095 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 841x GONZALEZ DR 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/04/2015 12:00:00 AM 3   Permit Number 775593 5988358.0 2089771.0 37.7174424713469 -122.48223241855301 (37.7174424713469, -122.482232418553)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 2555.908ms · Data source: data.sfgov.org