Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188848 | 188848 | 127426 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1870 Sacramento St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005819.50643 | 2116272.06707 | 37.79120846673779 | -122.423759246615 | (37.7912084667378, -122.423759246615) | |||
188779 | 188779 | 222521 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 791 27th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6001435.72019 | 2099957.2234099996 | 37.746163509146 | -122.437758004524 | (37.746163509146, -122.437758004524) | |||
188680 | 188680 | 234494 | Undocumented 2 | Pinus muricata :: Bishop Pine 302 | 101 Prospect Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | 6006984.21795 | 2098930.06522 | 37.7436570977129 | -122.41849913263799 | (37.7436570977129, -122.418499132638) | ||||
188664 | 188664 | 220354 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 428 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6002107.14118 | 2103331.7121 | 37.7554672079467 | -122.43567770085899 | (37.7554672079467, -122.435677700859) | |||
188653 | 188653 | 246020 | Undocumented 2 | :: 54 | 1629 Haight St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5998306.6251 | 2108576.7946 | 37.7696522823625 | -122.449198848796 | (37.7696522823625, -122.449198848796) | |||
188635 | 188635 | 128413 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 48 Campton Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6010829.24578 | 2115389.17061 | 37.7890657717061 | -122.406363370683 | (37.7890657717061, -122.406363370683) | |||
188549 | 188549 | 138262 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 30 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999046.0043 | 2113182.6602 | 37.7823410698302 | -122.44697286174801 | (37.7823410698302, -122.446972861748) | |||
188481 | 188481 | 126021 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009038.2153900005 | 2114627.76765 | 37.7868747902962 | -122.412506284359 | (37.7868747902962, -122.412506284359) | |||
188473 | 188473 | 215418 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 5994025.68496 | 2088506.9373700002 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) | ||||
188464 | 188464 | 250235 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 0ft | 6012481.472999999 | 2117350.27619 | 37.7945427904834 | -122.40078467369601 | (37.7945427904834, -122.400784673696) | |||
188415 | 188415 | 177476 | Undocumented 2 | Malus :: Crab Apple 235 | 87 Cora St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6009578.57754 | 2087278.8009400002 | 37.7118108998241 | -122.40870663432399 | (37.7118108998241, -122.408706634324) | |||
188409 | 188409 | 126023 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 560 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009008.4198 | 2114630.0994700002 | 37.7868795207321 | -122.412609535497 | (37.7868795207321, -122.412609535497) | |||
188316 | 188316 | 239691 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 4ft | 6004486.515980001 | 2103644.80101 | 37.756461738522 | -122.427471393514 | (37.756461738522, -122.427471393514) | |||
188283 | 188283 | 220341 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 2108 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6002638.72392 | 2099313.54816 | 37.7444644586719 | -122.433552181088 | (37.7444644586719, -122.433552181088) | |||
188216 | 188216 | 182185 | Undocumented 2 | :: 54 | 1638 25th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5988431.9652 | 2104143.1815 | 37.756909042216 | -122.483029559375 | (37.756909042216, -122.483029559375) | |||
188186 | 188186 | 218852 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1346 16th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 5991155.44082 | 2106257.8165599997 | 37.7628733705378 | -122.473765117276 | (37.7628733705378, -122.473765117276) | |||
188025 | 188025 | 233083 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 10ft | 6001990.940119999 | 2099392.0216200002 | 37.7446431530538 | -122.435797694723 | (37.7446431530538, -122.435797694723) | |||
187991 | 187991 | 215375 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 450 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5994049.9247 | 2089421.0969200002 | 37.716811158290206 | -122.462532844839 | (37.7168111582902, -122.462532844839) | |||
187989 | 187989 | 236401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 620 Belvedere St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5998688.86487 | 2105557.55466 | 37.7613840662398 | -122.44765932353701 | (37.7613840662398, -122.447659323537) | |||
187929 | 187929 | 245723 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2423 Market St | 16 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002221.88018 | 2105851.05746 | 37.762391238590205 | -122.435461113537 | (37.7623912385902, -122.435461113537) | |||
187918 | 187918 | 225234 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 923 Alabama St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6009156.14091 | 2103778.6804 | 37.7570923467526 | -122.41133157638599 | (37.7570923467526, -122.411331576386) | |||
187912 | 187912 | 231243 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 870 Treat Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6008548.77023 | 2103484.7360799997 | 37.7562511586886 | -122.413411316203 | (37.7562511586886, -122.413411316203) | |||
187910 | 187910 | 237431 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001926.93451 | 2100562.26984 | 37.747852742609204 | -122.43610273936899 | (37.7478527426092, -122.436102739369) | ||||
187868 | 187868 | 177360 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 229 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6003864.95037 | 2092317.2930400001 | 37.7253238242224 | -122.428813475161 | (37.7253238242224, -122.428813475161) | |||
187861 | 187861 | 206442 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 488 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 6ft | 5992758.93765 | 2090436.99405 | 37.719526135091 | -122.467068932605 | (37.719526135091, -122.467068932605) | |||
187846 | 187846 | 126487 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 740 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010914.3312099995 | 2117201.57703 | 37.79404696456071 | -122.40619672810301 | (37.7940469645607, -122.406196728103) | |||
187810 | 187810 | 138265 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 33 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 5999027.3911 | 2113166.4159 | 37.7822954037862 | -122.447036085573 | (37.7822954037862, -122.447036085573) | |||
187809 | 187809 | 128526 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6012563.28952 | 2116872.1643 | 37.7932345718721 | -122.40046797652701 | (37.7932345718721, -122.400467976527) | |||
187792 | 187792 | 210906 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.47239375186301 | (37.7599277068135, -122.472393751863) | |||
187750 | 187750 | 193859 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Stevenson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6012502.23298 | 2115355.06002 | 37.789065556785495 | -122.400572617131 | (37.7890655567855, -122.400572617131) | |||
187674 | 187674 | 245578 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | 6002722.030809999 | 2099065.57444 | 37.7437883069939 | -122.433246407993 | (37.7437883069939, -122.433246407993) | ||||
187367 | 187367 | 221970 | Undocumented 2 | Ailanthus altissima :: Tree Of Heaven 401 | 3900 22nd St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6002405.12131 | 2102995.45063 | 37.7545608352344 | -122.43462315224701 | (37.7545608352344, -122.434623152247) | |||
187192 | 187192 | 246314 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) | |||
187138 | 187138 | 126262 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1540 Larkin St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 3ft | 6007118.63275 | 2116680.9805400004 | 37.7924044922289 | -122.419293317642 | (37.7924044922289, -122.419293317642) | |||
186905 | 186905 | 236386 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 138 Carl St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 5997744.87985 | 2107159.8634 | 37.7657296047634 | -122.451039706011 | (37.7657296047634, -122.451039706011) | |||
186590 | 186590 | 142889 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006903.047 | 2114753.8909 | 37.7871010363106 | -122.419902442274 | (37.7871010363106, -122.419902442274) | |||
186559 | 186559 | 197486 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1112 Tennessee St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 6015516.35006 | 2103817.5314599997 | 37.757553689956104 | -122.389338063096 | (37.7575536899561, -122.389338063096) | |||
186557 | 186557 | 207266 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 450 Bright St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5993794.13591 | 2090181.7036599999 | 37.7188848681307 | -122.463472140835 | (37.7188848681307, -122.463472140835) | |||
186518 | 186518 | 128444 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 251 Leidesdorff St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012134.73383 | 2116669.40171 | 37.7926539254842 | -122.401936555937 | (37.7926539254842, -122.401936555937) | |||
186497 | 186497 | 131936 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1654 Hyde St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007422.60958 | 2118093.1296900003 | 37.796299018046206 | -122.41834171801099 | (37.7962990180462, -122.418341718011) | |||
186459 | 186459 | 250234 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 520 Commercial St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6012500.45193 | 2117354.10926 | 37.79455437373571 | -122.400719273201 | (37.7945543737357, -122.400719273201) | |||
186228 | 186228 | 190340 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014805.5019 | 2116039.63688 | 37.791073430855796 | -122.392651447929 | (37.7910734308558, -122.392651447929) | |||
186209 | 186209 | 245576 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6002722.8359199995 | 2099050.09706 | 37.7437458553887 | -122.433242518424 | (37.7437458553887, -122.433242518424) | ||||
186167 | 186167 | 195445 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 The Embarcadero | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014671.32996 | 2117148.01113 | 37.79410931633421 | -122.393193272358 | (37.7941093163342, -122.393193272358) | |||
186143 | 186143 | 177480 | Undocumented 2 | Malus :: Crab Apple 235 | 289 Flournoy St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 5993810.32054 | 2086750.1830099998 | 37.7094636621006 | -122.46316734172501 | (37.7094636621006, -122.463167341725) | ||||
185975 | 185975 | 210672 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 992 Waithman Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5996018.88182 | 2098492.62213 | 37.7418325783074 | -122.456382749179 | (37.7418325783074, -122.456382749179) | |||
185690 | 185690 | 136955 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Grant Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6010930.30149 | 2117074.44992 | 37.793698797424796 | -122.406132508429 | (37.7936987974248, -122.406132508429) | |||
185617 | 185617 | 128440 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 465 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012079.88655 | 2116745.39114 | 37.792859513197996 | -122.402131675541 | (37.792859513198, -122.402131675541) | |||
185564 | 185564 | 128457 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6012262.10233 | 2116770.3895400004 | 37.7929383216875 | -122.4015029541 | (37.7929383216875, -122.4015029541) | |||
185547 | 185547 | 176629 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1111 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 1ft | 6000425.60449 | 2090663.4815 | 37.7205875707281 | -122.440584368684 | (37.7205875707281, -122.440584368684) | |||
185437 | 185437 | 233548 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 630 Alvarado St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 6002336.17454 | 2102683.27276 | 37.7536997550592 | -122.43483926473499 | (37.7536997550592, -122.434839264735) | |||
185343 | 185343 | 128367 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 843 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6010390.86501 | 2116505.29195 | 37.7921058399542 | -122.40795885883301 | (37.7921058399542, -122.407958858833) | |||
185265 | 185265 | 142850 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006796.1662 | 2115183.2186 | 37.7882738424955 | -122.42030271033501 | (37.7882738424955, -122.420302710335) | |||
185093 | 185093 | 220033 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 502 28th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6002622.25428 | 2099488.24408 | 37.7449431983695 | -122.433621612357 | (37.7449431983695, -122.433621612357) | ||||
184932 | 184932 | 142820 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1754 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006598.3556 | 2116937.7026 | 37.793080071640894 | -122.42111173056101 | (37.7930800716409, -122.421111730561) | |||
184894 | 184894 | 127513 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 335 Powell St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6010233.96645 | 2114918.19092 | 37.7877392564025 | -122.408389735705 | (37.7877392564025, -122.408389735705) | |||
184783 | 184783 | 188803 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 370 De Haro St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6011986.97083 | 2106581.47042 | 37.7649465488559 | -122.401738427204 | (37.7649465488559, -122.401738427204) | |||
184579 | 184579 | 131309 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5996544.3680300005 | 2115871.17754 | 37.7895797810398 | -122.45582177545401 | (37.7895797810398, -122.455821775454) | |||
184574 | 184574 | 227074 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 22 Whitney St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6004252.810959999 | 2098130.67002 | 37.741307994779206 | -122.42788672741301 | (37.7413079947792, -122.427886727413) | |||
184459 | 184459 | 130870 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6006791.4679 | 2115188.9429 | 37.7882892952665 | -122.42031937215499 | (37.7882892952665, -122.420319372155) | |||
184430 | 184430 | 136380 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1023 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6008680.39017 | 2118276.96424 | 37.7968745041214 | -122.414002532311 | (37.7968745041214, -122.414002532311) | |||
184358 | 184358 | 131179 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 505 Commercial St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 5ft | 6012381.19757 | 2117316.40905 | 37.7944442058913 | -122.40112926060101 | (37.7944442058913, -122.401129260601) | |||
184351 | 184351 | 210509 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 6ft | 5997270.91609 | 2098557.47378 | 37.7420824423506 | -122.452058324935 | (37.7420824423506, -122.452058324935) | |||
184289 | 184289 | 128376 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 737 Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6010409.072509999 | 2116157.67498 | 37.791152386824606 | -122.407871336803 | (37.7911523868246, -122.407871336803) | |||
184274 | 184274 | 133108 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2165 Larkin St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6006794.50098 | 2118664.81919 | 37.7978333567673 | -122.420555710387 | (37.7978333567673, -122.420555710387) | |||
184259 | 184259 | 136719 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 1074 Vallejo St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004612.94283 | 2118113.6441200003 | 37.796196784912404 | -122.42806521496401 | (37.7961967849124, -122.428065214964) | |||
184232 | 184232 | 129802 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6010252.4995 | 2116845.85776 | 37.79303320378 | -122.40846164098801 | (37.79303320378, -122.408461640988) | |||
184216 | 184216 | 233143 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6000860.583219999 | 2102930.76024 | 37.7542954075331 | -122.43995992263099 | (37.7542954075331, -122.439959922631) | |||
184126 | 184126 | 127510 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 233 Geary St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6010663.62591 | 2114810.0943 | 37.787466500137896 | -122.406895566999 | (37.7874665001379, -122.406895566999) | |||
184122 | 184122 | 127461 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 640 Sutter St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009485.618530001 | 2115389.16428 | 37.7889905002694 | -122.41101216597299 | (37.7889905002694, -122.411012165973) | |||
184110 | 184110 | 227208 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 3ft | 6007523.932469999 | 2098207.4852299998 | 37.741703423083294 | -122.416581750143 | (37.7417034230833, -122.416581750143) | |||
184048 | 184048 | 128269 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Lombard St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6011883.8831 | 2120859.46134 | 37.804144815101104 | -122.40309937573 | (37.8041448151011, -122.40309937573) | |||
184007 | 184007 | 130975 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6002956.23707 | 2118277.75105 | 37.796553509993 | -122.43380948344101 | (37.796553509993, -122.433809483441) | |||
183976 | 183976 | 142246 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 525 Laguna St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 0ft | 6004972.6437 | 2110863.998 | 37.7763114086194 | -122.426304161599 | (37.7763114086194, -122.426304161599) | |||
183958 | 183958 | 205682 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 5991412.37682 | 2104411.58455 | 37.757818984582705 | -122.47274185157801 | (37.7578189845827, -122.472741851578) | ||||
183936 | 183936 | 244866 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 140 Highland Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6005707.387519999 | 2096634.20508 | 37.737281219162504 | -122.422750984277 | (37.7372812191625, -122.422750984277) | |||
183895 | 183895 | 197512 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6009788.18393 | 2109495.5877 | 37.7728250956205 | -122.40954919922899 | (37.7728250956205, -122.409549199229) | ||||
183889 | 183889 | 188396 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 760 De Haro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 9ft | 6012087.53124 | 2104906.41164 | 37.760352821738 | -122.401272892241 | (37.760352821738, -122.401272892241) | |||
183859 | 183859 | 220608 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 385 Nevada St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 2ft | 6008946.36134 | 2096525.7454799998 | 37.7371656274845 | -122.41154465636801 | (37.7371656274845, -122.411544656368) | |||
183814 | 183814 | 224803 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1450 Sanchez St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 2ft | 6003908.62031 | 2099778.1992599997 | 37.7458122528375 | -122.429194265228 | (37.7458122528375, -122.429194265228) | |||
183633 | 183633 | 219215 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 446 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 5994049.54462 | 2089400.1465099999 | 37.7167536115793 | -122.462532639778 | (37.7167536115793, -122.462532639778) | |||
183558 | 183558 | 126474 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 614 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010981.69424 | 2116687.73797 | 37.7926398538057 | -122.40592742973301 | (37.7926398538057, -122.405927429733) | |||
183464 | 183464 | 226910 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 755 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 10ft | 6001658.76556 | 2099678.71822 | 37.745411479858 | -122.436966807986 | (37.745411479858, -122.436966807986) | |||
183431 | 183431 | 207461 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 305 Foerster St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998080.39557 | 2094433.7139599998 | 37.7308059196407 | -122.44896242678101 | (37.7308059196407, -122.448962426781) | |||
183307 | 183307 | 129678 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012048.39516 | 2116793.1627 | 37.7929889247624 | -122.402243998167 | (37.7929889247624, -122.402243998167) | |||
183248 | 183248 | 136920 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 207 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996591.90102 | 2115549.28793 | 37.788698686447894 | -122.45563404108499 | (37.7886986864479, -122.455634041085) | |||
183213 | 183213 | 225256 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 4490 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6000086.96186 | 2101693.3582599997 | 37.7508537326323 | -122.44254645556101 | (37.7508537326323, -122.442546455561) | |||
183211 | 183211 | 222520 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 793 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6001413.31101 | 2099956.87619 | 37.7461612815178 | -122.437835467626 | (37.7461612815178, -122.437835467626) | ||||
183200 | 183200 | 227303 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002724.72616 | 2099043.5598 | 37.7437280128274 | -122.43323551541701 | (37.7437280128274, -122.433235515417) | ||||
183128 | 183128 | 233318 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 8ft | 6001505.99922 | 2098909.6493900004 | 37.7432911141078 | -122.43743998627501 | (37.7432911141078, -122.437439986275) | |||
183033 | 183033 | 127521 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 441 Mason St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6009736.66534 | 2114990.47481 | 37.7879098694816 | -122.410115415104 | (37.7879098694816, -122.410115415104) | |||
183015 | 183015 | 124651 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5995459.76206 | 2115756.0288299997 | 37.7892013075378 | -122.459566029798 | (37.7892013075378, -122.459566029798) | |||
182907 | 182907 | 128266 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Lombard St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 6011989.9615400005 | 2120874.35211 | 37.804191624796 | -122.40273332918501 | (37.804191624796, -122.402733329185) | |||
182815 | 182815 | 246018 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 603 Clayton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5998473.1811 | 2108575.8861 | 37.769659312933896 | -122.448622674121 | (37.7696593129339, -122.448622674121) | |||
182679 | 182679 | 234479 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 73 Elgin Park | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005835.003269999 | 2108667.27292 | 37.770328438229704 | -122.42316483429701 | (37.7703284382297, -122.423164834297) | |||
182579 | 182579 | 189230 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1919 22nd St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6012335.96177 | 2103730.27512 | 37.7571372669841 | -122.400331070924 | (37.7571372669841, -122.400331070924) | |||
182559 | 182559 | 142847 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1247 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006787.7441 | 2115244.9809 | 37.7884429519581 | -122.42033623488301 | (37.7884429519581, -122.420336234883) | |||
182550 | 182550 | 207460 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 305 Foerster St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998080.25164 | 2094437.83173 | 37.730817217831 | -122.44896322087799 | (37.730817217831, -122.448963220878) | |||
182549 | 182549 | 134900 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 Union St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6011410.78161 | 2119701.10617 | 37.8009378236702 | -122.404654992453 | (37.8009378236702, -122.404654992453) | |||
182544 | 182544 | 200450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 8ft | 6014955.45065 | 2103853.5745099997 | 37.7576215438129 | -122.391280415259 | (37.7576215438129, -122.391280415259) |
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");