Data source: data.sfgov.org
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189122 | 189122 | 204102 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2690 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5990691.67687 | 2095162.7954 | 37.7323824608655 | -122.474559334655 | (37.7323824608655, -122.474559334655) | |||
| 189101 | 189101 | 208366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 54 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991248.72719 | 2092445.9094099998 | 37.7249548323756 | -122.472435504713 | (37.7249548323756, -122.472435504713) | |||
| 189080 | 189080 | 188626 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 24 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6016050.39554 | 2099032.09801 | 37.7444434828812 | -122.38715732045799 | (37.7444434828812, -122.387157320458) | |||
| 189077 | 189077 | 192894 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 345 04th St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012507.03144 | 2112612.14811 | 37.781534427998295 | -122.400363278337 | (37.7815344279983, -122.400363278337) | |||
| 189025 | 189025 | 246736 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 110 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6008636.33373 | 2099057.51181 | 37.744099907697 | -122.412795505415 | (37.744099907697, -122.412795505415) | |||
| 189018 | 189018 | 247049 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 527 Valley St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002466.92979 | 2099138.14647 | 37.7439730978735 | -122.434133672824 | (37.7439730978735, -122.434133672824) | |||
| 189004 | 189004 | 201909 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.39459380727101 | (37.728396715017, -122.394593807271) | |||
| 188863 | 188863 | 234852 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009778.46002 | 2105547.1996400002 | 37.7619831846864 | -122.40930414927799 | (37.7619831846864, -122.409304149278) | |||
| 188852 | 188852 | 241247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1330 Stevenson St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6006254.50183 | 2108932.02318 | 37.77107904388 | -122.421732594687 | (37.77107904388, -122.421732594687) | |||
| 188763 | 188763 | 213318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 347 Howth St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997130.27848 | 2090199.39045 | 37.7191250833297 | -122.45194174763 | (37.7191250833297, -122.45194174763) | |||
| 188747 | 188747 | 188045 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 649 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013032.41115 | 2104053.24106 | 37.7580628726303 | -122.39794512008301 | (37.7580628726303, -122.397945120083) | |||
| 188683 | 188683 | 195062 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1176 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010220.876209999 | 2109998.84251 | 37.7742311523704 | -122.4080879583 | (37.7742311523704, -122.4080879583) | |||
| 188538 | 188538 | 204729 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Junipero Serra Blvd | 16 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991368.5463 | 2094108.06034 | 37.729525618690204 | -122.47214240847 | (37.7295256186902, -122.47214240847) | |||
| 188530 | 188530 | 126099 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1639 Beach St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 6002384.275669999 | 2121216.1923599998 | 37.8045892267643 | -122.435998961207 | (37.8045892267643, -122.435998961207) | |||
| 188516 | 188516 | 188959 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1712 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6014904.41664 | 2096665.80836 | 37.737882612900705 | -122.390954562096 | (37.7378826129007, -122.390954562096) | |||
| 188513 | 188513 | 195243 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1638 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014980.6206 | 2096956.55885 | 37.7386851822676 | -122.39071139803801 | (37.7386851822676, -122.390711398038) | |||
| 188494 | 188494 | 191820 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2150 24th St | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 3ft | 6012030.386940001 | 2102364.15145 | 37.753369146286 | -122.401291873339 | (37.753369146286, -122.401291873339) | |||
| 188493 | 188493 | 191514 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 392 04th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012567.22578 | 2112551.0938 | 37.7813701434666 | -122.40015074427099 | (37.7813701434666, -122.400150744271) | |||
| 188457 | 188457 | 204057 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 60 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991692.74622 | 2089138.75635 | 37.7158998914375 | -122.47065982389299 | (37.7158998914375, -122.470659823893) | |||
| 188452 | 188452 | 230911 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 468 Dellbrook Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5996742.41539 | 2103027.81097 | 37.7543265933203 | -122.454208515815 | (37.7543265933203, -122.454208515815) | |||
| 188437 | 188437 | 249364 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650 Leavenworth St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6008364.20652 | 2114704.18195 | 37.7870467568593 | -122.41484361694201 | (37.7870467568593, -122.414843616942) | |||
| 188417 | 188417 | 201276 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 20 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012895.06831 | 2092813.90558 | 37.7271943834984 | -122.397631821453 | (37.7271943834984, -122.397631821453) | |||
| 188403 | 188403 | 239243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010651.8200900005 | 2101663.18223 | 37.751367430767395 | -122.40600989216101 | (37.7513674307674, -122.406009892161) | |||
| 188378 | 188378 | 204066 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5991927.82266 | 2089696.89032 | 37.7174459825143 | -122.469887910592 | (37.7174459825143, -122.469887910592) | |||
| 188370 | 188370 | 198036 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 333 11th St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008686.77489 | 2109006.56148 | 37.7714205668302 | -122.413324523514 | (37.7714205668302, -122.413324523514) | |||
| 188365 | 188365 | 246426 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 448 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003617.56416 | 2099843.55926 | 37.745975235172295 | -122.43020535771299 | (37.7459752351723, -122.430205357713) | |||
| 188351 | 188351 | 247804 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 488 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003501.316380001 | 2098369.19661 | 37.7419203917212 | -122.430502145662 | (37.7419203917212, -122.430502145662) | |||
| 188304 | 188304 | 197241 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 201 Mendell St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016985.47526 | 2098058.3462799997 | 37.7418214959701 | -122.383856188014 | (37.7418214959701, -122.383856188014) | |||
| 188274 | 188274 | 194767 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1150 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6014887.36343 | 2096387.9974 | 37.737118854647996 | -122.390994112483 | (37.737118854648, -122.390994112483) | |||
| 188245 | 188245 | 204128 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700 Junipero Serra Blvd | 93 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991254.18034 | 2092103.55707 | 37.72401513347929 | -122.472391707724 | (37.7240151334793, -122.472391707724) | |||
| 188240 | 188240 | 178599 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Winston Dr | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5989481.37307 | 2093611.3212099997 | 37.7280523070507 | -122.47863016983999 | (37.7280523070507, -122.47863016984) | |||
| 188232 | 188232 | 204068 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991927.09954 | 2089662.54158 | 37.7173516274427 | -122.46988791059499 | (37.7173516274427, -122.469887910595) | |||
| 188205 | 188205 | 195055 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 403 06th St | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 3ft | 6011430.17139 | 2111003.8876099996 | 37.7770584095405 | -122.403975506976 | (37.7770584095405, -122.403975506976) | |||
| 188187 | 188187 | 250125 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1730 Pine St | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 4ft | 6005649.1110000005 | 2115549.12657 | 37.7892138324921 | -122.424297370338 | (37.7892138324921, -122.424297370338) | |||
| 188181 | 188181 | 222860 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 2 Webster St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004313.25978 | 2108595.11318 | 37.7700443109166 | -122.42842339963998 | (37.7700443109166, -122.42842339964) | |||
| 188164 | 188164 | 189603 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 514 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013664.01939 | 2112409.94185 | 37.7810436661816 | -122.39634644924801 | (37.7810436661816, -122.396346449248) | |||
| 188152 | 188152 | 247189 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1071 Haight St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 6ft | 6001018.37543 | 2108954.4053700003 | 37.770843837890794 | -122.439846093626 | (37.7708438378908, -122.439846093626) | |||
| 188146 | 188146 | 194411 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 98 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 1ft | 6013808.40909 | 2093727.99468 | 37.729755103205 | -122.39453836675301 | (37.729755103205, -122.394538366753) | |||
| 188139 | 188139 | 197360 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 854 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6011832.54279 | 2104397.74705 | 37.7589419122575 | -122.402119022102 | (37.7589419122575, -122.402119022102) | |||
| 188130 | 188130 | 228457 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009423.8763 | 2106376.9257400003 | 37.7642415505399 | -122.410589115888 | (37.7642415505399, -122.410589115888) | |||
| 188112 | 188112 | 246855 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1263 Fell St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001410.29469 | 2110050.1079599997 | 37.7738746647302 | -122.43856895919501 | (37.7738746647302, -122.438568959195) | |||
| 188100 | 188100 | 215642 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 85 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991146.327190001 | 2090562.0053700001 | 37.7197761709066 | -122.47265219363999 | (37.7197761709066, -122.47265219364) | |||
| 188099 | 188099 | 246836 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1377 Fell St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6001045.691790001 | 2109998.49138 | 37.7737121913922 | -122.439826475826 | (37.7737121913922, -122.439826475826) | |||
| 188040 | 188040 | 197520 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 98 Lafayette St | 5 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6007717.2402800005 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) | |||
| 188016 | 188016 | 192869 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Bonifacio St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012653.96554 | 2112821.67449 | 37.782117931539204 | -122.399869671075 | (37.7821179315392, -122.399869671075) | |||
| 188015 | 188015 | 189780 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 20th St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6013032.11681 | 2104710.31542 | 37.7598670385488 | -122.397992231954 | (37.7598670385488, -122.397992231954) | |||
| 187993 | 187993 | 190944 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1701 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6014004.94796 | 2095137.5370200002 | 37.7336363433234 | -122.39395753692101 | (37.7336363433234, -122.393957536921) | |||
| 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) | |||
| 187902 | 187902 | 199415 | Undocumented 2 | Ficus Spp. :: 253 | 431 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6014097.52278 | 2105089.09032 | 37.7609663518261 | -122.39433400571501 | (37.7609663518261, -122.394334005715) | |||
| 187887 | 187887 | 250037 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 Daniel Burnham Ct | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6006314.34591 | 2114758.99752 | 37.7870818744731 | -122.42193958446998 | (37.7870818744731, -122.42193958447) | |||
| 187780 | 187780 | 198137 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 118 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6013432.85539 | 2095621.93817 | 37.734934597439704 | -122.395969375192 | (37.7349345974397, -122.395969375192) | |||
| 187777 | 187777 | 250076 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005407.46076 | 2115305.4621099997 | 37.788531142735295 | -122.425116106829 | (37.7885311427353, -122.425116106829) | |||
| 187772 | 187772 | 192822 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 674 Harrison St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6013416.27051 | 2113057.4659700003 | 37.7828078293482 | -122.397248962085 | (37.7828078293482, -122.397248962085) | |||
| 187761 | 187761 | 226875 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2799 18th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009589.19178 | 2105442.78683 | 37.7616858850104 | -122.409951385948 | (37.7616858850104, -122.409951385948) | |||
| 187755 | 187755 | 199379 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 200 Jennings St | 17 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6018388.0029 | 2096644.9074400002 | 37.738017905995896 | -122.378908520106 | (37.7380179059959, -122.378908520106) | |||
| 187725 | 187725 | 211384 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2555 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5991108.5892 | 2094839.96583 | 37.731520199892294 | -122.473094451455 | (37.7315201998923, -122.473094451455) | |||
| 187655 | 187655 | 132695 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501 Webster St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6004047.336680001 | 2110514.9536 | 37.775300672009394 | -122.42948015697901 | (37.7753006720094, -122.429480156979) | |||
| 187644 | 187644 | 202304 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 152 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012919.13392 | 2092996.02429 | 37.727695784333704 | -122.397561393738 | (37.7276957843337, -122.397561393738) | |||
| 187625 | 187625 | 218526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 424 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992849.69775 | 2090512.21172 | 37.7197379029691 | -122.46676067557199 | (37.7197379029691, -122.466760675572) | |||
| 187609 | 187609 | 215640 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 83 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991139.98278 | 2090571.01197 | 37.71980053355961 | -122.472674780143 | (37.7198005335596, -122.472674780143) | |||
| 187595 | 187595 | 195199 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Rankin St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6014703.6451 | 2099406.06072 | 37.745395635597795 | -122.39184028732402 | (37.7453956355978, -122.391840287324) | |||
| 187594 | 187594 | 211506 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 900 Junipero Serra Blvd | 43 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991151.65625 | 2090702.0862 | 37.720161106816896 | -122.472643981031 | (37.7201611068169, -122.472643981031) | |||
| 187589 | 187589 | 201974 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 17 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013727.10603 | 2092236.0738 | 37.725654070573704 | -122.39471500442 | (37.7256540705737, -122.39471500442) | |||
| 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) | |||
| 187523 | 187523 | 241639 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6005424.1713 | 2107755.7253799997 | 37.7678023541299 | -122.424521053307 | (37.7678023541299, -122.424521053307) | |||
| 187511 | 187511 | 226663 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 109 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004754.99125 | 2108900.4446099997 | 37.77090766370029 | -122.426917205171 | (37.7709076637003, -122.426917205171) | |||
| 187506 | 187506 | 212614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 511 Mount Vernon Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997779.607340001 | 2090076.68387 | 37.7188253303138 | -122.449688439586 | (37.7188253303138, -122.449688439586) | |||
| 187483 | 187483 | 194179 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 198 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013413.98851 | 2106222.8030000003 | 37.7640412580141 | -122.39677755096201 | (37.7640412580141, -122.396777550962) | |||
| 187477 | 187477 | 234036 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 143 Scott St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6002306.01138 | 2109052.49296 | 37.7711863734766 | -122.435399155653 | (37.7711863734766, -122.435399155653) | |||
| 187471 | 187471 | 189892 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6016806.72009 | 2098324.8999099997 | 37.74254351487679 | -122.384492832481 | (37.7425435148768, -122.384492832481) | |||
| 187468 | 187468 | 241054 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 877 Treat Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6008599.28066 | 2103440.0769700003 | 37.7561313707826 | -122.41323347526699 | (37.7561313707826, -122.413233475267) | |||
| 187462 | 187462 | 246482 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 334 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004129.100269999 | 2099867.2658599997 | 37.7460692880854 | -122.42843822405399 | (37.7460692880854, -122.428438224054) | |||
| 187460 | 187460 | 224279 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2501 17th St | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 6ft | 6009600.88418 | 2106385.57449 | 37.7642752202394 | -122.409977504072 | (37.7642752202394, -122.409977504072) | |||
| 187424 | 187424 | 197362 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2250 Revere Ave | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011553.01117 | 2097063.53685 | 37.738788157356296 | -122.40257003569799 | (37.7387881573563, -122.402570035698) | |||
| 187423 | 187423 | 197356 | Undocumented 2 | Rhamnus californica :: Coffeeberry Tree 232 | 39 Latona St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6014424.19857 | 2094456.12331 | 37.7317886115532 | -122.39246040762698 | (37.7317886115532, -122.392460407627) | |||
| 187422 | 187422 | 193117 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1789 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014368.11598 | 2096649.52963 | 37.737808141841 | -122.39280769161999 | (37.737808141841, -122.39280769162) | |||
| 187413 | 187413 | 204048 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 Geneva Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997298.98464 | 2091430.55111 | 37.7225152243894 | -122.451447349841 | (37.7225152243894, -122.451447349841) | |||
| 187399 | 187399 | 205334 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 73 Margaret Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997009.746259999 | 2089680.74953 | 37.7176941117806 | -122.452320974643 | (37.7176941117806, -122.452320974643) | |||
| 187389 | 187389 | 192940 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1531 Howard St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007930.12579 | 2109464.25147 | 37.772634764912205 | -122.415974234728 | (37.7726347649122, -122.415974234728) | |||
| 187365 | 187365 | 203897 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3804 19th Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5990591.46397 | 2090484.77315 | 37.7195319761952 | -122.474564506644 | (37.7195319761952, -122.474564506644) | |||
| 187297 | 187297 | 198039 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 157 12th St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6007591.24481 | 2109206.34028 | 37.771907543438395 | -122.417128184534 | (37.7719075434384, -122.417128184534) | |||
| 187271 | 187271 | 249543 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1031 Franklin St | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6006034.95999 | 2113672.91543 | 37.7840840006086 | -122.42282898338699 | (37.7840840006086, -122.422828983387) | |||
| 187215 | 187215 | 189310 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1763 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6014232.27573 | 2095006.1382799998 | 37.7332881806876 | -122.393162401334 | (37.7332881806876, -122.393162401334) | |||
| 187176 | 187176 | 213277 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 9 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991091.244530001 | 2091195.3843599998 | 37.7215120845989 | -122.472888754009 | (37.7215120845989, -122.472888754009) | |||
| 187168 | 187168 | 196993 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6013912.096059999 | 2100139.0238799998 | 37.7473642236913 | -122.39462867398501 | (37.7473642236913, -122.394628673985) | |||
| 187167 | 187167 | 188369 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 467 Texas St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013826.93076 | 2104919.88069 | 37.76048669391479 | -122.39525801864599 | (37.7604866939148, -122.395258018646) | |||
| 187147 | 187147 | 204072 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 216 Arch St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992726.8230099995 | 2088588.5716900001 | 37.714448960336206 | -122.46704562576299 | (37.7144489603362, -122.467045625763) | |||
| 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) | |||
| 187114 | 187114 | 225993 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 47 Octavia St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6005632.01245 | 2109568.33209 | 37.77279107248339 | -122.423931063861 | (37.7727910724834, -122.423931063861) | |||
| 187101 | 187101 | 196396 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011313.59863 | 2111303.12635 | 37.7778735361758 | -122.404399838608 | (37.7778735361758, -122.404399838608) | |||
| 187081 | 187081 | 247767 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 845 Waller St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6001661.0774 | 2108697.38351 | 37.7701746829316 | -122.43760456761801 | (37.7701746829316, -122.437604567618) | |||
| 187080 | 187080 | 192864 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Tandang Sora St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012596.11924 | 2112706.04983 | 37.781797227899396 | -122.40006167180701 | (37.7817972278994, -122.400061671807) | |||
| 187054 | 187054 | 207246 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992206.82998 | 2091154.32928 | 37.7214638782474 | -122.469029527495 | (37.7214638782474, -122.469029527495) | |||
| 187037 | 187037 | 222230 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 8 Aquavista Way | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5998088.24008 | 2101938.03895 | 37.751411431901104 | -122.44947581647499 | (37.7514114319011, -122.449475816475) | |||
| 187020 | 187020 | 204105 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 Junipero Serra Blvd | 40 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991399.0300199995 | 2094388.9297200001 | 37.7302985797068 | -122.47205748816499 | (37.7302985797068, -122.472057488165) | |||
| 186986 | 186986 | 187899 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015181.09261 | 2100903.60273 | 37.7495340665546 | -122.39029394621201 | (37.7495340665546, -122.390293946212) | |||
| 186985 | 186985 | 194785 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1733 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014577.08037 | 2096493.16973 | 37.73739041392879 | -122.392074263026 | (37.7373904139288, -122.392074263026) | |||
| 186983 | 186983 | 206877 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Junipero Serra Blvd | 112 | : 4 | Tree 1 | Private 1 | 24 | Width 0ft | 5991127.9538900005 | 2090310.3975099998 | 37.7190842541173 | -122.472697367507 | (37.7190842541173, -122.472697367507) | |||
| 186952 | 186952 | 207258 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 532 Arch St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992753.93277 | 2090721.89417 | 37.7203081126976 | -122.46710693523998 | (37.7203081126976, -122.46710693524) | |||
| 186947 | 186947 | 212672 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 609 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992414.13264 | 2090471.45088 | 37.719600836394704 | -122.468263292533 | (37.7196008363947, -122.468263292533) |
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");