Street_Tree_List

Data source: data.sfgov.org

5,183 rows where qSiteInfo = 4 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
62380 62380 176134 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 2 : 4 Tree 1 Private 1     16 Width 0ft   5987222.73644 2086464.9299599999 37.7082987351809 -122.48591391940901 (37.7082987351809, -122.485913919409)
48038 48038 176133 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 1 : 4 Tree 1 Private 1     10 Width 0ft   5987205.94604 2086467.2590400001 37.708304151783295 -122.48597211903099 (37.7083041517833, -122.485972119031)
160483 160483 176136 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 4 : 4 Tree 1 Private 1     11 Width 0ft   5987247.74108 2086476.2363 37.7083312366754 -122.48582833093599 (37.7083312366754, -122.485828330936)
59353 59353 176135 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 3 : 4 Tree 1 Private 1     13 Width 0ft   5987227.516530001 2086480.11804 37.7083407164149 -122.485898513129 (37.7083407164149, -122.485898513129)
161785 161785 176137 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800 John Muir Dr 5 : 4 Tree 1 Private 1     11 Width 0ft   5987255.345 2086484.45942 37.708354258405 -122.485802654386 (37.708354258405, -122.485802654386)
72189 72189 178591 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 67 Belle Ave 1 : 4 Tree 1 Private 1     9 Width 3ft   5991713.92465 2086485.44715 37.70861577046671 -122.470393502266 (37.7086157704667, -122.470393502266)
137765 137765 178592 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 67 Belle Ave 2 : 4 Tree 1 Private 1     9 Width 3ft   5991724.32675 2086485.2281099998 37.7086157704725 -122.470357535671 (37.7086157704725, -122.470357535671)
39571 39571 175574 Undocumented 2 Brugmansia spp :: Angel trumpet 137 262 Taber Pl 1 : 4 Tree 1 Private 1     16 Width 3ft   6009969.129269999 2086111.4112900002 37.708627351035794 -122.407274531388 (37.7086273510358, -122.407274531388)
51116 51116 179953 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 240 Peabody St 1 : 4 Tree 1 Private 1     17 Width 3ft   6009701.772480001 2086128.1297 37.708658289510204 -122.408199733244 (37.7086582895102, -122.408199733244)
157417 157417 175573 Undocumented 2 Brugmansia spp :: Angel trumpet 137 256 Taber Pl 1 : 4 Tree 1 Private 1     17 Width 3ft   6009978.06824 2086136.62452 37.7086970817661 -122.40724541316901 (37.7086970817661, -122.407245413169)
151378 151378 177164 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 30 Kelloch Ave 2 : 4 Tree 1 Private 1     1 Width 3ft   6008391.56884 2086208.1675200001 37.708804605615896 -122.41273363745701 (37.7088046056159, -122.412733637457)
176962 176962 175882 Undocumented 2 Cordyline australis :: Dracena Palm 141 140 Kelloch Ave 5 : 4 Tree 1 Private 1     6 Width 3ft   6008037.77895 2086218.44055 37.708812949517394 -122.413957113834 (37.7088129495174, -122.413957113834)
179124 179124 175881 Undocumented 2 Cordyline australis :: Dracena Palm 141 140 Kelloch Ave 4 : 4 Tree 1 Private 1     12 Width 3ft   6008040.46364 2086219.1455 37.7088150359462 -122.413947884982 (37.7088150359462, -122.413947884982)
171717 171717 176170 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 42 Kelloch Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   6008360.10661 2086217.92738 37.7088296382394 -122.41284306515499 (37.7088296382394, -122.412843065155)
55394 55394 175880 Undocumented 2 Cordyline australis :: Dracena Palm 141 140 Kelloch Ave 3 : 4 Tree 1 Private 1     11 Width 3ft   6008040.572369999 2086224.4613400002 37.7088296382554 -122.413947884988 (37.7088296382554, -122.413947884988)
154303 154303 175879 Undocumented 2 Cordyline australis :: Dracena Palm 141 140 Kelloch Ave 2 : 4 Tree 1 Private 1     9 Width 3ft   6008041.81725 2086229.374 37.708843197325 -122.41394392978701 (37.708843197325, -122.413943929787)
156719 156719 178517 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 328 Schwerin St 1 : 4 Tree 1 Private 1     19 Width 4ft   6008541.04755 2086224.10569 37.708856757315395 -122.41221814244801 (37.7088567573154, -122.412218142448)
57129 57129 175878 Undocumented 2 Cordyline australis :: Dracena Palm 141 140 Kelloch Ave 1 : 4 Tree 1 Private 1     9 Width 3ft   6008044.64173 2086236.91355 37.7088640580086 -122.413934700952 (37.7088640580086, -122.413934700952)
30302 30302 175150 Undocumented 2 Aesculus x carnea :: Red Horse Chestnut 194 141 Goethe St 1 : 4 Tree 1 Private 1     6 Width 3ft   5994849.69598 2086516.03158 37.708880557851 -122.45955816357299 (37.708880557851, -122.459558163573)
76451 76451 178516 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 322 Schwerin St 1 : 4 Tree 1 Private 1     17 Width 4ft   6008552.66413 2086251.2184400002 37.70893185520271 -122.41217990870001 (37.7089318552027, -122.4121799087)
62440 62440 178519 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 74 Kelloch Ave 1 : 4 Tree 1 Private 1     11 Width 3ft   6008207.90106 2086273.84024 37.7089746188665 -122.413373061735 (37.7089746188665, -122.413373061735)
64171 64171 180218 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 241 Flournoy St 1 : 4 Tree 1 Private 1     1 Width 3ft   5994016.46026 2086567.8312400002 37.70897484008071 -122.462441676038 (37.7089748400807, -122.462441676038)
34606 34606 178520 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 74 Kelloch Ave 2 : 4 Tree 1 Private 1     10 Width 3ft   6008160.20585 2086291.9091900003 37.7090215544595 -122.413539180899 (37.7090215544595, -122.413539180899)
150256 150256 178521 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 90 Kelloch Ave 1 : 4 Tree 1 Private 1     10 Width 3ft   6008137.560430001 2086303.76828 37.7090528454867 -122.413618285264 (37.7090528454867, -122.413618285264)
168228 168228 178515 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 304 Schwerin St 1 : 4 Tree 1 Private 1     22 Width 5ft   6008576.98547 2086321.37555 37.709125856931706 -122.41210080521601 (37.7091258569317, -122.412100805216)
68231 68231 177711 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 41 Rhine St 1 : 4 Tree 1 Private 1     18 Width 3ft   5994431.51774 2086616.4840900002 37.7091323221755 -122.461010711685 (37.7091323221755, -122.461010711685)
177259 177259 175096 Undocumented 2 Acer palmatum :: Japanese Maple 175 56 Tomaso Ct 1 : 4 Tree 1 Private 1     1 Width 2ft   6009154.581590001 2086320.62957 37.7091562000666 -122.410104484734 (37.7091562000666, -122.410104484734)
172180 172180 177710 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 41 Rhine St 2 : 4 Tree 1 Private 1     7 Width 3ft   5994442.40126 2086628.41328 37.709165703209294 -122.460973960888 (37.7091657032093, -122.460973960888)
159671 159671 175338 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 248 Wilson St 1 : 4 Tree 1 Private 1     10 Width 3ft   5994374.45478 2086640.5688599998 37.709195169503005 -122.461209673184 (37.709195169503, -122.461209673184)
172772 172772 177709 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 41 Rhine St 3 : 4 Tree 1 Private 1     5 Width 3ft   5994451.68551 2086639.1998299998 37.7091958547847 -122.460942654584 (37.7091958547847, -122.460942654584)
40286 40286 178844 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 52 Tomaso Ct 1 : 4 Tree 1 Private 1     16 Width 2ft   6009171.05644 2086338.49099 37.7092061672978 -122.410048805012 (37.7092061672978, -122.410048805012)
64681 64681 177708 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 41 Rhine St 4 : 4 Tree 1 Private 1     5 Width 3ft   5994462.16701 2086650.7454 37.7092281593337 -122.460907265375 (37.7092281593337, -122.460907265375)
130669 130669 180221 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 248 Wilson St 2 : 4 Tree 1 Private 1     7 Width 3ft   5994358.2246 2086656.8417599997 37.70923891700821 -122.461266945616 (37.7092389170082, -122.461266945616)
26224 26224 177707 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 41 Rhine St 5 : 4 Tree 1 Private 1     4 Width 3ft   5994471.04103 2086660.75611 37.709256157011794 -122.46087732063499 (37.7092561570118, -122.460877320635)
152452 152452 175339 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 248 Wilson St 3 : 4 Tree 1 Private 1     8 Width 3ft   5994341.375580001 2086670.8513099998 37.709276414241295 -122.46132619294399 (37.7092764142413, -122.461326192944)
67879 67879 177706 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 41 Rhine St 6 : 4 Tree 1 Private 1     6 Width 3ft   5994482.436290001 2086673.39058 37.709291503981795 -122.46083885215499 (37.7092915039818, -122.460838852155)
30518 30518 179954 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 40 Tomaso Ct 1 : 4 Tree 1 Private 1     23 Width 2ft   6009197.20014 2086405.9588 37.709392885454 -122.409963207553 (37.709392885454, -122.409963207553)
154404 154404 175342 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 18 Rhine St 3 : 4 Tree 1 Private 1     11 Width 3ft   5994489.11096 2086733.7148099998 37.7094575242209 -122.46082015254801 (37.7094575242209, -122.460820152548)
162187 162187 180219 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 254 Wilson St 1 : 4 Tree 1 Private 1     6 Width 3ft   5994266.2336800005 2086739.00195 37.7094592149324 -122.46159083107901 (37.7094592149324, -122.461590831079)
115843 115843 180220 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 254 Wilson St 2 : 4 Tree 1 Private 1     6 Width 3ft   5994253.3591 2086751.7904 37.7094935879269 -122.46163625403601 (37.7094935879269, -122.461636254036)
187533 187533 175341 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 18 Rhine St 2 : 4 Tree 1 Private 1     7 Width 3ft   5994500.0272699995 2086747.2122099998 37.709495213017 -122.460783401753 (37.709495213017, -122.460783401753)
187124 187124 175340 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 18 Rhine St 1 : 4 Tree 1 Private 1     4 Width 3ft   5994510.0494800005 2086755.6303299998 37.7095189038466 -122.460749373209 (37.7095189038466, -122.460749373209)
148678 148678 180562 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 4101 Alemany Blvd 1 : 4 Tree 1 Private 1     12 Width 3ft   5991620.890430001 2086817.0358099998 37.70952085356139 -122.470739173794 (37.7095208535614, -122.470739173794)
154089 154089 179456 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 39 Melra Ct 1 : 4 Tree 1 Private 1     18 Width 4ft   6008986.48136 2086460.78308 37.7095316094729 -122.41069535821501 (37.7095316094729, -122.410695358215)
68529 68529 176622 Undocumented 2 Juniperus chinensis :: Juniper 19 28 Tomaso Ct 1 : 4 Tree 1 Private 1     5 Width 2ft   6009222.269090001 2086479.6741900002 37.7095966978914 -122.409881764928 (37.7095966978914, -122.409881764928)
37576 37576 175870 Undocumented 2 Citrus spp :: Lemon: Orange: Lime 278 24 Tomaso Ct 2 : 4 Tree 1 Private 1     4 Width 2ft   6009222.043409999 2086480.3970700002 37.7095986701246 -122.409882595915 (37.7095986701246, -122.409882595915)
178554 178554 177808 Undocumented 2 Myoporum laetum :: Myoporum 1 35 Melra Ct 1 : 4 Tree 1 Private 1     22 Width 4ft   6008994.91617 2086485.2732900002 37.709599327506794 -122.410667934296 (37.7095993275068, -122.410667934296)
161043 161043 176544 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 100 Panama St 7 : 4 Tree 1 Private 1     1 Width 3ft   5992259.97775 2086836.1982 37.7096104062721 -122.46853179230499 (37.7096104062721, -122.468531792305)
46896 46896 175829 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 71 De Long St 1 : 4 Tree 1 Private 1     4 Width 3ft   5994644.581040001 2086786.22758 37.709610656266996 -122.460286627948 (37.709610656267, -122.460286627948)
172727 172727 175831 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 71 De Long St 3 : 4 Tree 1 Private 1     5 Width 3ft   5994675.09306 2086785.5883900002 37.7096106562906 -122.460181127555 (37.7096106562906, -122.460181127555)
174401 174401 175830 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 71 De Long St 2 : 4 Tree 1 Private 1     5 Width 3ft   5994659.60487 2086786.3953 37.7096119809882 -122.460234715484 (37.7096119809882, -122.460234715484)
61421 61421 175833 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 71 De Long St 5 : 4 Tree 1 Private 1     5 Width 3ft   5994704.65642 2086785.9340000001 37.709613305686 -122.46007897716999 (37.709613305686, -122.46007897717)
34939 34939 175832 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 71 De Long St 4 : 4 Tree 1 Private 1     5 Width 3ft   5994691.10568 2086786.7003099998 37.709614630390604 -122.460125866041 (37.7096146303906, -122.460125866041)
55877 55877 175834 Undocumented 2 Celtis sinensis :: Chinese Hackberry 111 71 De Long St 6 : 4 Tree 1 Private 1     6 Width 3ft   5994720.17465 2086786.5738400002 37.7096159550821 -122.460025390159 (37.7096159550821, -122.460025390159)
51729 51729 176543 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 100 Panama St 6 : 4 Tree 1 Private 1     1 Width 3ft   5992283.95996 2086838.07777 37.709616952417704 -122.468449043003 (37.7096169524177, -122.468449043003)
60465 60465 176542 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 100 Panama St 5 : 4 Tree 1 Private 1     1 Width 3ft   5992312.69836 2086838.42699 37.7096195712459 -122.468349744347 (37.7096195712459, -122.468349744347)
152300 152300 175869 Undocumented 2 Citrus spp :: Lemon: Orange: Lime 278 24 Tomaso Ct 1 : 4 Tree 1 Private 1     4 Width 2ft   6009229.76902 2086501.99732 37.7096584129814 -122.409857418496 (37.7096584129814, -122.409857418496)
137459 137459 177705 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 84 De Long St 2 : 4 Tree 1 Private 1     11 Width 3ft   5994659.32331 2086819.21058 37.7097020678628 -122.46023806453199 (37.7097020678628, -122.460238064532)
166302 166302 175335 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 114 De Long St 2 : 4 Tree 1 Private 1     10 Width 3ft   5994496.623790001 2086824.0668400002 37.7097060419715 -122.46080073078699 (37.7097060419715, -122.460800730787)
186035 186035 175334 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 114 De Long St 1 : 4 Tree 1 Private 1     12 Width 3ft   5994510.66891 2086823.77253 37.709706041981704 -122.460752167376 (37.7097060419817, -122.460752167376)
31818 31818 175337 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 114 De Long St 4 : 4 Tree 1 Private 1     14 Width 3ft   5994455.45704 2086824.9295299998 37.7097060419823 -122.46094307188801 (37.7097060419823, -122.460943071888)
39699 39699 175336 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 114 De Long St 3 : 4 Tree 1 Private 1     9 Width 3ft   5994472.9026 2086825.04671 37.709707367568996 -122.460882785837 (37.709707367569, -122.460882785837)
136796 136796 176621 Undocumented 2 Juniperus chinensis :: Juniper 19 20 Tomaso Ct 1 : 4 Tree 1 Private 1     6 Width 2ft   6009241.33314 2086520.9311099998 37.7097110493951 -122.40981878630801 (37.7097110493951, -122.409818786308)
40107 40107 175639 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 28 De Long St 1 : 4 Tree 1 Private 1     9 Width 3ft   5995095.5192 2086815.4100099998 37.709716713323495 -122.458730228841 (37.7097167133235, -122.458730228841)
61917 61917 175640 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 28 De Long St 2 : 4 Tree 1 Private 1     7 Width 3ft   5995084.70237 2086816.61805 37.7097194085931 -122.458767700893 (37.7097194085931, -122.458767700893)
162646 162646 187512 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1888 Geneva Ave 12 : 4 Tree 1 Private 1     4 Width 3ft   6004972.0075900005 2086680.68467 37.7099095126929 -122.424585708258 (37.7099095126929, -122.424585708258)
170289 170289 187511 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1888 Geneva Ave 11 : 4 Tree 1 Private 1     5 Width 3ft   6004958.741090001 2086695.30162 37.7099488984891 -122.42463259891599 (37.7099488984891, -122.424632598916)
164843 164843 187510 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1888 Geneva Ave 10 : 4 Tree 1 Private 1     5 Width 3ft   6004948.81965 2086709.68307 37.709987826555704 -122.424667911703 (37.7099878265557, -122.424667911703)
153430 153430 187509 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1888 Geneva Ave 9 : 4 Tree 1 Private 1     5 Width 3ft   6004937.85944 2086722.41778 37.7100221743453 -122.424706697651 (37.7100221743453, -122.424706697651)
157438 157438 177007 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 216 Saint Charles Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5992028.26989 2086999.54978 37.710045543251205 -122.469344489883 (37.7100455432512, -122.469344489883)
162385 162385 187507 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1888 Geneva Ave 7 : 4 Tree 1 Private 1     4 Width 3ft   6004913.95724 2086749.2623400001 37.7100945337938 -122.424791216847 (37.7100945337938, -122.424791216847)
163565 163565 187550 Undocumented 2 Prunus blireiana :: Flowering Plum 102 15 Chicago Way 2 : 4 Tree 1 Private 1     6 Width 3ft   6003854.31887 2086791.04585 37.7101493555763 -122.428456511776 (37.7101493555763, -122.428456511776)
169545 169545 187506 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1888 Geneva Ave 6 : 4 Tree 1 Private 1     9 Width 3ft   6004893.16086 2086772.3737400002 37.7101568181467 -122.424864736445 (37.7101568181467, -122.424864736445)
156689 156689 180510 Undocumented 2 Ulmus americana :: American Elm 119 4035 Alemany Blvd 2 : 4 Tree 1 Private 1     9 Width 3ft   5991869.02362 2087044.7321400002 37.7101603992515 -122.46989815837401 (37.7101603992515, -122.469898158374)
150929 150929 187505 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1888 Geneva Ave 5 : 4 Tree 1 Private 1     9 Width 3ft   6004874.161669999 2086793.27995 37.710213148986504 -122.42493188792 (37.7102131489865, -122.42493188792)
132784 132784 176541 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 213 Saint Charles Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   5992061.3412 2087065.5070200001 37.7102285570869 -122.46923498750601 (37.7102285570869, -122.469234987506)
167069 167069 187480 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1888 Geneva Ave 3 : 4 Tree 1 Private 1     1 Width 3ft   6004820.44605 2086842.7727 37.710346011228104 -122.42512105938299 (37.7103460112281, -122.425121059383)
131919 131919 187479 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1888 Geneva Ave 2 : 4 Tree 1 Private 1     1 Width 3ft   6004800.91134 2086858.76625 37.7103888225503 -122.42518971275601 (37.7103888225503, -122.425189712756)
36521 36521 187478 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1888 Geneva Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   6004785.02328 2086870.2631599999 37.710419493035104 -122.425245442839 (37.7104194930351, -122.425245442839)
56337 56337 219078 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 23 Bright St 1 : 4 Tree 1 Private 1     1 Width 3ft   5993714.36027 2087390.3486099998 37.7112158768855 -122.463545422096 (37.7112158768855, -122.463545422096)
45422 45422 187710 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 1 : 4 Tree 1 Private 1     2 Width 8ft   6013683.2298 2086994.4586200002 37.7112591963142 -122.39449981823 (37.7112591963142, -122.39449981823)
156272 156272 188733 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 1 : 4 Tree 1 Private 1     8 Width 8ft   6014289.08954 2086985.67825 37.7112687498269 -122.392405184751 (37.7112687498269, -122.392405184751)
131023 131023 177712 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 3597 Alemany Blvd 2 : 4 Tree 1 Private 1     18 Width 3ft   5993573.43523 2087465.7354099997 37.7114147502636 -122.464037959205 (37.7114147502636, -122.464037959205)
54815 54815 180511 Undocumented 2 Ulmus americana :: American Elm 119 3597 Alemany Blvd 1 : 4 Tree 1 Private 1     18 Width 3ft   5993538.56271 2087481.65959 37.711456464415996 -122.464159641976 (37.711456464416, -122.464159641976)
187957 187957 180224 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3599 Alemany Blvd 1 : 4 Tree 1 Private 1     8 Width 3ft   5993480.96313 2087505.0727 37.7115174312511 -122.46436041830799 (37.7115174312511, -122.464360418308)
169004 169004 210729 Undocumented 2 Olea europaea :: Olive Tree 41 2950 San Jose Ave 3 : 4 Tree 1 Private 1     3 Width 3ft   5996042.96304 2087509.5172700002 37.711676981779 -122.455505847225 (37.711676981779, -122.455505847225)
39745 39745 213248 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2950 San Jose Ave 2 : 4 Tree 1 Private 1     6 Width 3ft   5996050.31606 2087518.48106 37.7117020161965 -122.455481080804 (37.7117020161965, -122.455481080804)
156086 156086 206846 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Brotherhood Way 1 : 4 Tree 1 Private 1     25 Width 0ft   5993694.0595 2087568.4676400002 37.7117037797802 -122.463628505047 (37.7117037797802, -122.463628505047)
136019 136019 206848 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Brotherhood Way 3 : 4 Tree 1 Private 1     11 Width 0ft   5993673.9414 2087579.0167599998 37.7117315859181 -122.46369880328001 (37.7117315859181, -122.46369880328)
159965 159965 176962 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 121 Saint Charles Ave 1 : 4 Tree 1 Private 1     12 Width 2ft   5992069.06615 2087619.0428799998 37.71174887986621 -122.46924855110301 (37.7117488798662, -122.469248551103)
137802 137802 206847 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Brotherhood Way 2 : 4 Tree 1 Private 1     16 Width 0ft   5993688.70591 2087590.2808700001 37.711763365253894 -122.463648590504 (37.7117633652539, -122.463648590504)
33515 33515 213247 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 2950 San Jose Ave 1 : 4 Tree 1 Private 1     16 Width 3ft   5996077.12469 2087544.08394 37.711773854049895 -122.455390272656 (37.7117738540499, -122.455390272656)
45580 45580 175089 Undocumented 2 Acer buergeranum :: Trident Maple 120 3602 Alemany Blvd 2 : 4 Tree 1 Private 1     2 Width 3ft   5993467.05206 2087598.8302799999 37.711774065400895 -122.46441530123501 (37.7117740654009, -122.464415301235)
169292 169292 177215 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 3602 Alemany Blvd 3 : 4 Tree 1 Private 1     7 Width 3ft   5993434.694569999 2087605.54338 37.7117906327114 -122.46452762384399 (37.7117906327114, -122.464527623844)
45080 45080 177216 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 3602 Alemany Blvd 4 : 4 Tree 1 Private 1     9 Width 3ft   5993403.40349 2087610.58828 37.7118026809134 -122.464636139668 (37.7118026809134, -122.464636139668)
65332 65332 180222 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3602 Alemany Blvd 5 : 4 Tree 1 Private 1     4 Width 3ft   5993369.41698 2087618.4325700002 37.7118222600726 -122.464754174762 (37.7118222600726, -122.464754174762)
128115 128115 177217 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 3602 Alemany Blvd 6 : 4 Tree 1 Private 1     8 Width 3ft   5993336.53195 2087626.2537599998 37.711841839194605 -122.464868401251 (37.7118418391946, -122.464868401251)
57692 57692 177218 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 3602 Alemany Blvd 7 : 4 Tree 1 Private 1     10 Width 3ft   5993301.35241 2087629.7349200002 37.7118493692142 -122.46499024319799 (37.7118493692142, -122.464990243198)
31853 31853 180223 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 3602 Alemany Blvd 8 : 4 Tree 1 Private 1     6 Width 3ft   5993236.04296 2087638.25257 37.7118689906411 -122.46521658728099 (37.7118689906411, -122.465216587281)
40640 40640 178151 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 10 Brotherhood Way 4 : 4 Tree 1 Private 1     3 Width 0ft   5993597.52442 2087641.3827799999 37.7118984245322 -122.46396744335199 (37.7118984245322, -122.463967443352)

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