Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 215 | 215 | 17196 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004629.787409999 | 2116932.39582 | 37.792954330542 | -122.42792271466601 | (37.792954330542, -122.427922714666) | |||
| 223 | 223 | 23789 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.43051925893299 | (37.7812424081927, -122.430519258933) | |||
| 248 | 248 | 23733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6003923.026000001 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | |||
| 497 | 497 | 14419 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | ||||
| 503 | 503 | 8533 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001504.6387 | 2113566.4305 | 37.783534963845 | -122.43849459602801 | (37.783534963845, -122.438494596028) | |||
| 605 | 605 | 23903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | |||
| 656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
| 828 | 828 | 8634 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999136.363 | 2113194.1665 | 37.7823778250539 | -122.44666108993299 | (37.7823778250539, -122.446661089933) | |||
| 1116 | 1116 | 8576 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | |||
| 1149 | 1149 | 19194 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150 Sanchez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003510.8594 | 2107438.4604 | 37.7668229855288 | -122.43111632094801 | (37.7668229855288, -122.431116320948) | |||
| 1183 | 1183 | 119797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1185 | 1185 | 119832 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1187 | 1187 | 119794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1189 | 1189 | 119798 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1191 | 1191 | 119838 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1192 | 1192 | 119753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1194 | 1194 | 119795 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1196 | 1196 | 119750 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1199 | 1199 | 119799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1201 | 1201 | 119839 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1202 | 1202 | 119754 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1203 | 1203 | 119796 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1204 | 1204 | 119749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1206 | 1206 | 119801 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1208 | 1208 | 119803 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1209 | 1209 | 119800 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1211 | 1211 | 119836 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1213 | 1213 | 119747 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1219 | 1219 | 119829 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1222 | 1222 | 119837 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1223 | 1223 | 119752 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1226 | 1226 | 119830 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1228 | 1228 | 119831 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1230 | 1230 | 119834 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1231 | 1231 | 119833 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1233 | 1233 | 119757 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1234 | 1234 | 119748 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1235 | 1235 | 119756 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1347 | 1347 | 251504 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 620x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5992030.0 | 2103590.0 | 37.7555988620986 | -122.470546036282 | (37.7555988620986, -122.470546036282) | ||||
| 1355 | 1355 | 29680 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006072.343230001 | 2117086.04016 | 37.7934577026643 | -122.422942314134 | (37.7934577026643, -122.422942314134) | ||||
| 1361 | 1361 | 16698 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 950X Noriega St | 2 | Median : Cutout 11 | Landscaping 2 | DPW 2 | 12 | 8 | 5991017.9677099995 | 2103156.31666 | 37.7543495107367 | -122.47401428523999 | (37.7543495107367, -122.47401428524) | |||
| 1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
| 1535 | 1535 | 28642 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1300 Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003705.0759 | 2113297.4854 | 37.782921429068395 | -122.430862736641 | (37.7829214290684, -122.430862736641) | |||
| 1548 | 1548 | 8472 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6002074.2026 | 2113678.2789 | 37.7838744530021 | -122.436532136471 | (37.7838744530021, -122.436532136471) | |||
| 1594 | 1594 | 4731 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1175X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | 3x3 | 6007886.219880001 | 2121257.05551 | 37.8050124513131 | -122.416961809043 | (37.8050124513131, -122.416961809043) | |||
| 1653 | 1653 | 14428 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 12 | 5998837.5365 | 2113112.2684 | 37.782135879985205 | -122.447688996293 | (37.7821358799852, -122.447688996293) | |||
| 1703 | 1703 | 29682 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006057.50051 | 2117137.8264200003 | 37.7935990572132 | -122.422997353566 | (37.7935990572132, -122.422997353566) | ||||
| 1760 | 1760 | 14433 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998837.1981 | 2113100.4237 | 37.7821033381799 | -122.447689314061 | (37.7821033381799, -122.447689314061) | |||
| 1851 | 1851 | 4718 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008205.1504 | 2120957.4944 | 37.804207866952204 | -122.415836885075 | (37.8042078669522, -122.415836885075) | |||
| 1901 | 1901 | 23857 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6003664.511 | 2113605.5032 | 37.7837648703142 | -122.431025065183 | (37.7837648703142, -122.431025065183) | |||
| 1958 | 1958 | 23757 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003900.3372 | 2111922.0621 | 37.7791559204238 | -122.43008906318701 | (37.7791559204238, -122.430089063187) | |||
| 2009 | 2009 | 16358 | DPW Maintained 3 | Populus tremuloides :: Quaking aspen 166 | 1306X Montgomery St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 8 | 6011461.03473 | 2119844.77729 | 37.8013351180737 | -122.40449121329901 | (37.8013351180737, -122.404491213299) | |||
| 2125 | 2125 | 117673 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7600x Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 6ft | 5983555.0 | 2112529.0 | 37.779649107322506 | -122.50051568716002 | (37.7796491073225, -122.50051568716) | |||
| 2139 | 2139 | 23790 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003786.8931 | 2112715.8268 | 37.7813289751352 | -122.43053816621901 | (37.7813289751352, -122.430538166219) | |||
| 2263 | 2263 | 22364 | Landmark tree 9 | Schinus terebinthifolius :: Brazilian Pepper 25 | 5490X 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | |||
| 2284 | 2284 | 23758 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 900X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 20 | 6003894.1493 | 2111953.6889 | 37.7792424093118 | -122.43011272647199 | (37.7792424093118, -122.430112726472) | |||
| 2297 | 2297 | 23709 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 700X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 20 | 6003970.4427 | 2111382.6873 | 37.7776789009548 | -122.429808057223 | (37.7776789009548, -122.429808057223) | |||
| 2531 | 2531 | 8603 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6 | 5999987.1554 | 2113318.7057 | 37.782768340075606 | -122.443726682203 | (37.7827683400756, -122.443726682203) | |||
| 2581 | 2581 | 107490 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1306x Montgomery St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6011447.18476 | 2119974.7633599997 | 37.8016912541172 | -122.404548295963 | (37.8016912541172, -122.404548295963) | ||||
| 2620 | 2620 | 23170 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006871.78386 | 2111296.65749 | 37.7776065535391 | -122.41976520271601 | (37.7776065535391, -122.419765202716) | |||
| 3104 | 3104 | 23477 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2400X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 9 | 6005826.46835 | 2118791.49543 | 37.7981265753418 | -122.423914390454 | (37.7981265753418, -122.423914390454) | |||
| 3232 | 3232 | 253369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 449X Trumbull St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Width 10ft | 6005840.0 | 2094317.0 | 37.730926169648 | -122.42212790794599 | (37.730926169648, -122.422127907946) | ||||
| 3445 | 3445 | 16362 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1306X Montgomery St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011452.97865 | 2119928.00722 | 37.801563196957204 | -122.40452495315901 | (37.8015631969572, -122.404524953159) | |||
| 3463 | 3463 | 25005 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004909.6221900005 | 2105744.1135299997 | 37.7622498768445 | -122.426157591005 | (37.7622498768445, -122.426157591005) | |||
| 3794 | 3794 | 29684 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 2000X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6006028.673359999 | 2117355.72849 | 37.7941957348865 | -122.42311259358699 | (37.7941957348865, -122.423112593587) | ||||
| 3859 | 3859 | 23825 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6003756.6414 | 2112968.1539 | 37.782020088596504 | -122.43066083333599 | (37.7820200885965, -122.430660833336) | |||
| 3910 | 3910 | 14420 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998841.5976 | 2113071.3194 | 37.7820236767836 | -122.44767199806299 | (37.7820236767836, -122.447671998063) | ||||
| 4063 | 4063 | 253608 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 5998814.0 | 2100235.0 | 37.746776792757004 | -122.44684353081101 | (37.746776792757, -122.446843530811) | ||||
| 4098 | 4098 | 8400 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003921.0381 | 2113941.5724 | 37.7847021645415 | -122.430161561145 | (37.7847021645415, -122.430161561145) | |||
| 4214 | 4214 | 8397 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6004036.9348 | 2113953.0096 | 37.7847401317276 | -122.42976141314301 | (37.7847401317276, -122.429761413143) | |||
| 4399 | 4399 | 8467 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002321.2505 | 2113708.7369 | 37.783972118374 | -122.435679623339 | (37.783972118374, -122.435679623339) | |||
| 4472 | 4472 | 8393 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004320.9581 | 2113985.4149 | 37.7848451877241 | -122.428781097193 | (37.7848451877241, -122.428781097193) | |||
| 4512 | 4512 | 8466 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6002359.1538 | 2113715.5053 | 37.7839928555225 | -122.435548976348 | (37.7839928555225, -122.435548976348) | |||
| 4516 | 4516 | 28647 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.785885930849204 | -122.431484021877 | (37.7858859308492, -122.431484021877) | |||
| 4712 | 4712 | 29681 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006062.7062 | 2117112.9687900003 | 37.79353109814161 | -122.42297757386001 | (37.7935310981416, -122.42297757386) | ||||
| 4979 | 4979 | 8629 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999229.0905 | 2113208.3802 | 37.78242214856029 | -122.44634131765899 | (37.7824221485603, -122.446341317659) | |||
| 5019 | 5019 | 23410 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006148.01248 | 2116523.4539799998 | 37.7919172512266 | -122.422640495371 | (37.7919172512266, -122.422640495371) | |||
| 5083 | 5083 | 253786 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5090 | 5090 | 253789 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 5094 | 5094 | 253788 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1663X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991413.0 | 2103963.0 | 37.756587325686105 | -122.472706989611 | (37.7565873256861, -122.472706989611) | ||||
| 5101 | 5101 | 253790 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 5102 | 5102 | 253784 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1709X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991403.0 | 2103783.0 | 37.756092514171904 | -122.472728448949 | (37.7560925141719, -122.472728448949) | ||||
| 5104 | 5104 | 253785 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5106 | 5106 | 253787 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5110 | 5110 | 152413 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005625.074080001 | 2104777.98262 | 37.7596375207611 | -122.42361441706899 | (37.7596375207611, -122.423614417069) | |||
| 5111 | 5111 | 152416 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005631.99539 | 2104658.5890900004 | 37.7593100848133 | -122.423581991114 | (37.7593100848133, -122.423581991114) | |||
| 5113 | 5113 | 152421 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005642.99765 | 2104457.73967 | 37.7587592203909 | -122.42352966049 | (37.7587592203909, -122.42352966049) | |||
| 5114 | 5114 | 152414 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005626.99355 | 2104746.96336 | 37.7595524574982 | -122.423605573157 | (37.7595524574982, -122.423605573157) | |||
| 5115 | 5115 | 14434 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998899.8061 | 2113051.3525 | 37.781972179426205 | -122.447469186406 | (37.7819721794262, -122.447469186406) | |||
| 5117 | 5117 | 23827 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1200X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003747.0158 | 2113043.0957 | 37.7822253147353 | -122.430699482992 | (37.7822253147353, -122.430699482992) | |||
| 5118 | 5118 | 152420 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005641.8915099995 | 2104501.69931 | 37.7588798608311 | -122.42353661133998 | (37.7588798608311, -122.42353661134) | |||
| 5122 | 5122 | 152419 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005637.900330001 | 2104551.94757 | 37.7590176055009 | -122.423553987148 | (37.7590176055009, -122.423553987148) | |||
| 5127 | 5127 | 152423 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005645.11359 | 2104396.78205 | 37.758591964470895 | -122.423518008854 | (37.7585919644709, -122.423518008854) | |||
| 5131 | 5131 | 152418 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005636.4507 | 2104585.0792400003 | 37.759108495478394 | -122.42356135618999 | (37.7591084954784, -122.42356135619) | |||
| 5135 | 5135 | 152417 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005634.27087 | 2104624.16733 | 37.7592156991708 | -122.423571674116 | (37.7592156991708, -122.423571674116) | |||
| 5137 | 5137 | 152415 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005628.48676 | 2104715.95286 | 37.7594673942256 | -122.423598204106 | (37.7594673942256, -122.423598204106) | |||
| 5138 | 5138 | 152412 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005623.17605 | 2104812.38517 | 37.7597318749526 | -122.4236234274 | (37.7597318749526, -122.4236234274) |
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");