Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) |
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");