Street_Tree_List

Data source: data.sfgov.org

1,700 rows where qSiteInfo = 10 sorted by rowid descending

✎ View and edit SQL

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)

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 884.358ms · Data source: data.sfgov.org