Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83067 | 83067 | 208306 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6002214.21615 | 2095390.4279 | 37.733668385273205 | -122.434739555986 | (37.7336683852732, -122.434739555986) | |||
133833 | 133833 | 188653 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017421.68385 | 2098629.86939 | 37.7434148869 | -122.382387660761 | (37.7434148869, -122.382387660761) | ||||
135340 | 135340 | 208309 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6002006.71588 | 2095443.8659400002 | 37.7338033312475 | -122.43546076552799 | (37.7338033312475, -122.435460765528) | |||
137930 | 137930 | 116541 | DPW Maintained 3 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1041x Naples St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001548.78537 | 2088145.26253 | 37.7137369985308 | -122.436521745206 | (37.7137369985308, -122.436521745206) | |||
147232 | 147232 | 190067 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 1150x Tennessee St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6015567.2875 | 2103497.11447 | 37.7566767169834 | -122.389139526978 | (37.7566767169834, -122.389139526978) | |||
149319 | 149319 | 197491 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 900x Carolina St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012477.42612 | 2103497.4714900004 | 37.756505926715604 | -122.39982548288499 | (37.7565059267156, -122.399825482885) | ||||
151880 | 151880 | 251078 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5100x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991099.7276 | 2112702.723 | 37.7805661077577 | -122.474428154783 | (37.7805661077577, -122.474428154783) | |||
152127 | 152127 | 251023 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991490.4549 | 2112712.2313 | 37.780614844759995 | -122.473077150172 | (37.78061484476, -122.473077150172) | |||
153227 | 153227 | 250144 | DPW Maintained 3 | Magnolia x soulangiana :: Saucer Magnolia 92 | 2550x Lyon St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5999230.56416 | 2117643.35138 | 37.794599499022105 | -122.446655413925 | (37.7945994990221, -122.446655413925) | ||||
153800 | 153800 | 222815 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3500x Cesar Chavez St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6006246.77566 | 2100563.7677 | 37.7481013314143 | -122.42116501457 | (37.7481013314143, -122.42116501457) | |||
154652 | 154652 | 129351 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.67929 | 2120161.57643 | 37.8022029953207 | -122.404635873741 | (37.8022029953207, -122.404635873741) | |||
157626 | 157626 | 251106 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987426.0529 | 2112570.9396 | 37.779990741259 | -122.48712729528201 | (37.779990741259, -122.487127295282) | |||
158355 | 158355 | 188005 | DPW Maintained 3 | Araucaria columnaris :: Coral reef araucaria 185 | 1700x Quesada Ave | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6014418.79198 | 2095243.03437 | 37.733949008825896 | -122.39253412326799 | (37.7339490088259, -122.392534123268) | ||||
158594 | 158594 | 251036 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990401.2433 | 2112674.4808 | 37.780448069653296 | -122.47684245414699 | (37.7804480696533, -122.476842454147) | |||
159827 | 159827 | 193548 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1300x De Haro St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012271.58863 | 2102171.1791 | 37.7528527402726 | -122.400444188549 | (37.7528527402726, -122.400444188549) | ||||
160097 | 160097 | 190072 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 1700x Quesada Ave | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6014428.21738 | 2095237.1411700002 | 37.7339333507341 | -122.392501124441 | (37.7339333507341, -122.392501124441) | ||||
164863 | 164863 | 129537 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1306x Montgomery St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011446.5417 | 2119990.51434 | 37.801734466528 | -122.404551630663 | (37.801734466528, -122.404551630663) | |||
166322 | 166322 | 251051 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5900x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988530.6021 | 2112606.8245 | 37.780153615018705 | -122.48330884168699 | (37.7801536150187, -122.483308841687) | |||
172638 | 172638 | 251071 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990727.8797 | 2112689.8051 | 37.7805090880033 | -122.47571359647101 | (37.7805090880033, -122.475713596471) | |||
173206 | 173206 | 251070 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990754.7634 | 2112689.2674 | 37.7805091701663 | -122.47562055473499 | (37.7805091701663, -122.475620554735) | |||
173829 | 173829 | 197180 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012255.350880001 | 2102175.8421 | 37.752864638318 | -122.40050066956499 | (37.752864638318, -122.400500669565) | ||||
175283 | 175283 | 251074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991352.6942 | 2112710.2412 | 37.7806014035471 | -122.473553580301 | (37.7806014035471, -122.473553580301) | |||
175369 | 175369 | 188654 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | ||||
176711 | 176711 | 251042 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5500x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989852.8157 | 2112655.9311 | 37.7803653089721 | -122.47873834484899 | (37.7803653089721, -122.478738344849) | |||
177329 | 177329 | 251092 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988013.9609 | 2112592.2358 | 37.780083477756705 | -122.485095046206 | (37.7800834777567, -122.485095046206) | |||
178472 | 178472 | 251037 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990398.0172 | 2112670.1794 | 37.780436072061896 | -122.476853300249 | (37.7804360720619, -122.476853300249) | |||
180303 | 180303 | 180413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003786.93346 | 2094435.4492400002 | 37.731135391684 | -122.42923414026001 | (37.731135391684, -122.42923414026) | |||
181676 | 181676 | 186658 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1401 Sunset Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 0ft | 5984710.2715 | 2105562.1346 | 37.7605878254343 | -122.49600505239401 | (37.7605878254343, -122.496005052394) | |||
182339 | 182339 | 208308 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6002022.61443 | 2095440.5497 | 37.733795128547 | -122.435405562425 | (37.733795128547, -122.435405562425) | |||
183680 | 183680 | 189166 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012257.93832 | 2102144.48011 | 37.752778669414 | -122.40048951886999 | (37.752778669414, -122.40048951887) | ||||
183887 | 183887 | 180412 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003814.30975 | 2094445.54262 | 37.7311646556118 | -122.42914021505501 | (37.7311646556118, -122.429140215055) | |||
187917 | 187917 | 250143 | DPW Maintained 3 | Magnolia x soulangiana :: Saucer Magnolia 92 | 2550x Lyon St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5999225.81293 | 2117634.10371 | 37.7945738359766 | -122.446671188041 | (37.7945738359766, -122.446671188041) | ||||
1039 | 1039 | 186954 | DPW Maintained 3 | Tree(s) :: 17 | 2800 Sunset Blvd | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 0ft | 5985211.8854 | 2096092.27 | 37.734615522028896 | -122.493572437422 | (37.7346155220289, -122.493572437422) | |||
27490 | 27490 | 129348 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011427.80927 | 2120135.82348 | 37.802132403051 | -122.404626688974 | (37.802132403051, -122.404626688974) | |||
28285 | 28285 | 206831 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994089.87141 | 2101545.69318 | 37.7501046117408 | -122.463274075037 | (37.7501046117408, -122.463274075037) | |||
32653 | 32653 | 194410 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1700x Quesada Ave | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6014359.990180001 | 2095279.52622 | 37.7340459422739 | -122.39273997266899 | (37.7340459422739, -122.392739972669) | ||||
32868 | 32868 | 251069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5990794.5513 | 2112690.3427 | 37.7805144291466 | -122.47548298954099 | (37.7805144291466, -122.475482989541) | |||
36478 | 36478 | 133192 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1306x Montgomery St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011420.83782 | 2120184.50099 | 37.8022656699768 | -122.404654242423 | (37.8022656699768, -122.404654242423) | |||
37982 | 37982 | 237111 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Coso Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007125.29232 | 2099860.06971 | 37.7462186223039 | -122.418077248072 | (37.7462186223039, -122.418077248072) | ||||
41450 | 41450 | 189322 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 299x Cashmere St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6016409.152290001 | 2096168.4415799999 | 37.736600324449 | -122.385717251362 | (37.736600324449, -122.385717251362) | ||||
41518 | 41518 | 203592 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1485x Northwood Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995892.33391 | 2093907.44512 | 37.729235533389705 | -122.45648881700899 | (37.7292355333897, -122.456488817009) | ||||
43116 | 43116 | 212147 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995390.97132 | 2094022.6530799998 | 37.729523070026104 | -122.458230394627 | (37.7295230700261, -122.458230394627) | ||||
47168 | 47168 | 251029 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991370.3842 | 2112709.3567 | 37.7805999993895 | -122.473492318223 | (37.7805999993895, -122.473492318223) | |||
48340 | 48340 | 222814 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3500x Cesar Chavez St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006266.09505 | 2100563.37105 | 37.748101331408 | -122.42109818053801 | (37.748101331408, -122.421098180538) | |||
48845 | 48845 | 206816 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993579.5371900005 | 2100911.34414 | 37.7483334374322 | -122.46499276043001 | (37.7483334374322, -122.46499276043) | ||||
49060 | 49060 | 212149 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995397.3757 | 2094149.6680599998 | 37.7298721904459 | -122.45821744347602 | (37.7298721904459, -122.458217443476) | ||||
50547 | 50547 | 211162 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995762.15632 | 2099312.39681 | 37.744068735376295 | -122.457329708294 | (37.7440687353763, -122.457329708294) | |||
50688 | 50688 | 206828 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994181.13078 | 2101275.53768 | 37.749368090385104 | -122.462938899523 | (37.7493680903851, -122.462938899523) | |||
52167 | 52167 | 214406 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993802.78615 | 2096495.7432 | 37.736222176613104 | -122.463900308969 | (37.7362221766131, -122.463900308969) | ||||
52412 | 52412 | 211125 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994142.00989 | 2101462.2847 | 37.7498785968185 | -122.463087727432 | (37.7498785968185, -122.463087727432) | |||
53516 | 53516 | 135600 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013623.6813 | 2117874.05106 | 37.7960445944406 | -122.39686919997 | (37.7960445944406, -122.39686919997) | |||
53667 | 53667 | 124132 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3500x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5996095.590340001 | 2112883.06277 | 37.7813494516321 | -122.457158247488 | (37.7813494516321, -122.457158247488) | ||||
55150 | 55150 | 208267 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5996171.153059999 | 2098570.8040400003 | 37.742055987003496 | -122.455861898701 | (37.7420559870035, -122.455861898701) | |||
56033 | 56033 | 222845 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3100x Cesar Chavez St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6008656.93174 | 2100575.27687 | 37.7482685099843 | -122.41283156553699 | (37.7482685099843, -122.412831565537) | |||
57780 | 57780 | 246553 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6005726.464930001 | 2109532.06592 | 37.7726968262309 | -122.42360176272699 | (37.7726968262309, -122.423601762727) | |||
57952 | 57952 | 211135 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5993997.61305 | 2101611.2464400004 | 37.750279288862295 | -122.463597864272 | (37.7502792888623, -122.463597864272) | |||
66160 | 66160 | 214405 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993807.85396 | 2096495.9519200001 | 37.73622304175571 | -122.46388280274701 | (37.7362230417557, -122.463882802747) | ||||
67780 | 67780 | 191690 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 900x Carolina St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012468.62754 | 2103498.74867 | 37.756508943061206 | -122.39985600137399 | (37.7565089430612, -122.399856001374) | ||||
69103 | 69103 | 197179 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012255.14184 | 2102164.55152 | 37.7528336251844 | -122.40050059944099 | (37.7528336251844, -122.400500599441) | ||||
69767 | 69767 | 251022 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991511.6828 | 2112712.2313 | 37.7806160737768 | -122.473003713445 | (37.7806160737768, -122.473003713445) | |||
70677 | 70677 | 187788 | DPW Maintained 3 | Acacia vestita :: Hairy wattle 398 | 1300x De Haro St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012267.84735 | 2102159.07234 | 37.7528192891044 | -122.400456276334 | (37.7528192891044, -122.400456276334) | ||||
71153 | 71153 | 222777 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2950x Cesar Chavez St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6009523.38261 | 2100580.00732 | 37.748330094656296 | -122.409835724135 | (37.7483300946563, -122.409835724135) | ||||
75225 | 75225 | 204717 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1485x Northwood Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995876.20042 | 2094034.0159599998 | 37.7295821401899 | -122.456553740875 | (37.7295821401899, -122.456553740875) | ||||
75559 | 75559 | 119930 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5987085.6039 | 2112558.1946400004 | 37.779935889891895 | -122.48830410860799 | (37.7799358898919, -122.488304108608) | ||||
77799 | 77799 | 105836 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2100X SLOAT BLVD | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5984309.0 | 2095832.0 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | ||||
91704 | 91704 | 188404 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012258.41015 | 2102196.39231 | 37.7529212353325 | -122.40049153337401 | (37.7529212353325, -122.400491533374) | ||||
119608 | 119608 | 188659 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400x Cargo Way | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6017103.6349 | 2098887.87453 | 37.744105743386 | -122.383505361577 | (37.744105743386, -122.383505361577) | ||||
129785 | 129785 | 135594 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013641.29963 | 2117738.5675 | 37.7956735692465 | -122.396798733574 | (37.7956735692465, -122.396798733574) | |||
131922 | 131922 | 213728 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x San Lorenzo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993678.600330001 | 2097499.69771 | 37.7389716280322 | -122.464402537152 | (37.7389716280322, -122.464402537152) | ||||
132912 | 132912 | 222776 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2950x Cesar Chavez St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6009504.41429 | 2100580.51468 | 37.7483304247098 | -122.40990135219 | (37.7483304247098, -122.40990135219) | ||||
134170 | 134170 | 212144 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995391.35311 | 2093756.23728 | 37.7287915785573 | -122.458209800162 | (37.7287915785573, -122.458209800162) | ||||
148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) | |||
149750 | 149750 | 251044 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5989568.3861 | 2112643.8334 | 37.7803155729867 | -122.47972142279801 | (37.7803155729867, -122.479721422798) | |||
150043 | 150043 | 135601 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013619.0965 | 2117904.14877 | 37.7961269804374 | -122.396887175602 | (37.7961269804374, -122.396887175602) | |||
150266 | 150266 | 135599 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013626.9255 | 2117849.56722 | 37.7959775481806 | -122.39685625692499 | (37.7959775481806, -122.396856256925) | |||
150851 | 150851 | 251082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5989477.5192 | 2112643.2957 | 37.7803088175248 | -122.480035730601 | (37.7803088175248, -122.480035730601) | |||
153591 | 153591 | 135582 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013728.8853 | 2117108.6329200002 | 37.7939487918665 | -122.396451492763 | (37.7939487918665, -122.396451492763) | |||
157582 | 157582 | 222822 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3500x Cesar Chavez St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006028.774680001 | 2100543.7206599996 | 37.7480339946844 | -122.42191743145399 | (37.7480339946844, -122.421917431454) | |||
157761 | 157761 | 116545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 3x3 | 6001537.057630001 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | |||
158644 | 158644 | 224101 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2x Gough St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006607.58912 | 2109275.93798 | 37.7720432565284 | -122.42053566810101 | (37.7720432565284, -122.420535668101) | |||
161567 | 161567 | 211126 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994133.74344 | 2101463.42927 | 37.7498812633278 | -122.46311639602301 | (37.7498812633278, -122.463116396023) | |||
165397 | 165397 | 222821 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3500x Cesar Chavez St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006053.42295 | 2100544.76657 | 37.748038256564705 | -122.421832272848 | (37.7480382565647, -122.421832272848) | |||
168848 | 168848 | 135596 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013635.89834 | 2117779.6494400003 | 37.7957860699142 | -122.396820304724 | (37.7957860699142, -122.396820304724) | |||
169173 | 169173 | 212153 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995398.99771 | 2094330.69415 | 37.730369337469504 | -122.458224933031 | (37.7303693374695, -122.458224933031) | ||||
174181 | 174181 | 242061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10x Benton Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6004744.49443 | 2095004.6976299998 | 37.732752583154394 | -122.42596418912301 | (37.7327525831544, -122.425964189123) | ||||
174532 | 174532 | 214331 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995540.56521 | 2099364.9270200003 | 37.7442002405496 | -122.458099716827 | (37.7442002405496, -122.458099716827) | |||
178416 | 178416 | 129103 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1306x Montgomery St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011435.37643 | 2120050.37627 | 37.8018982087863 | -122.40459448426901 | (37.8018982087863, -122.404594484269) | |||
178654 | 178654 | 222819 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3500x Cesar Chavez St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006102.45265 | 2100549.0367799997 | 37.7480527464562 | -122.42166303303001 | (37.7480527464562, -122.42166303303) | |||
179786 | 179786 | 212148 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995395.17866 | 2094120.1752900002 | 37.7297910841891 | -122.45822290508801 | (37.7297910841891, -122.458222905088) | ||||
180517 | 180517 | 135598 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013629.78784 | 2117826.7467900002 | 37.7959150479945 | -122.396844751899 | (37.7959150479945, -122.396844751899) | |||
180940 | 180940 | 197472 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 1700x Quesada Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6014448.1116 | 2095227.50583 | 37.7339079988375 | -122.39243166978599 | (37.7339079988375, -122.392431669786) | ||||
181114 | 181114 | 124134 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3500x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5996034.43033 | 2112879.7174 | 37.7813367535062 | -122.457369587843 | (37.7813367535062, -122.457369587843) | ||||
182998 | 182998 | 128875 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1237x Robert C Levy Tunl | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007636.05536 | 2118136.6748900004 | 37.7964305951503 | -122.417606237154 | (37.7964305951503, -122.417606237154) | ||||
186293 | 186293 | 208310 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6001987.84098 | 2095447.80908 | 37.733813086200705 | -122.43552630359301 | (37.7338130862007, -122.435526303593) | |||
186406 | 186406 | 211123 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5994165.13571 | 2101402.3094200003 | 37.7497152520618 | -122.46300340698099 | (37.7497152520618, -122.463003406981) | |||
187030 | 187030 | 240286 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 5200x Diamond Heights Blvd | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6001709.51148 | 2098788.78469 | 37.742970816043204 | -122.436727644972 | (37.7429708160432, -122.436727644972) | ||||
188244 | 188244 | 224100 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2x Gough St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006621.45587 | 2109260.75005 | 37.772002335561794 | -122.42048662356899 | (37.7720023355618, -122.420486623569) | |||
188999 | 188999 | 129349 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011426.64663 | 2120143.89656 | 37.8021545047788 | -122.40463128093398 | (37.8021545047788, -122.404631280934) | |||
1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
3898 | 3898 | 212122 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995365.2918 | 2092257.6675200001 | 37.724675368963105 | -122.45819147914699 | (37.7246753689631, -122.458191479147) |
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");