Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189069 | 189069 | 195235 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200x Evans Ave | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6017260.82922 | 2097339.16357 | 37.7398619829554 | -122.382854057268 | (37.7398619829554, -122.382854057268) | ||||
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) | |||
188991 | 188991 | 218259 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5992809.1507 | 2097219.8287299997 | 37.7381530219397 | -122.46738832232 | (37.7381530219397, -122.46738832232) | ||||
188939 | 188939 | 212143 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995395.28868 | 2093711.39383 | 37.7286686754144 | -122.45819295046199 | (37.7286686754144, -122.458192950462) | ||||
188895 | 188895 | 212106 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 10ft | 5993007.603759999 | 2095365.5409099997 | 37.733073065562 | -122.466567434662 | (37.733073065562, -122.466567434662) | |||
188426 | 188426 | 248776 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6002998.16884 | 2095083.8511700002 | 37.73287107152721 | -122.43200731937999 | (37.7328710715272, -122.43200731938) | |||
188330 | 188330 | 243923 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Bartlett St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6006672.06961 | 2103729.13284 | 37.7568166658685 | -122.419918946309 | (37.7568166658685, -122.419918946309) | |||
188268 | 188268 | 211116 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 5994179.36475 | 2101243.69399 | 37.749280553969605 | -122.46294269644501 | (37.7492805539696, -122.462942696445) | |||
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) | |||
188176 | 188176 | 178034 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6002495.00651 | 2087816.3446 | 37.7128875861582 | -122.433227774048 | (37.7128875861582, -122.433227774048) | ||||
188023 | 188023 | 234407 | DPW Maintained 3 | Phoenix dactylifera :: Date Palm 65 | 100x Dolores St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6004812.29017 | 2107562.9589 | 37.7672384899902 | -122.426623750084 | (37.7672384899902, -122.426623750084) | ||||
188008 | 188008 | 187747 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016140.5122 | 2096271.0286 | 37.7368671389145 | -122.38665321539801 | (37.7368671389145, -122.386653215398) | ||||
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) | ||||
187874 | 187874 | 194313 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6015116.8381 | 2116756.98357 | 37.793060384871 | -122.391624402345 | (37.793060384871, -122.391624402345) | |||
187741 | 187741 | 248647 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6002988.020959999 | 2095088.4577900001 | 37.73288314494071 | -122.432042732011 | (37.7328831449407, -122.432042732011) | ||||
187703 | 187703 | 187521 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 100x Mary Teresa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 6012597.41848 | 2087914.4030799998 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | |||
187642 | 187642 | 206837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 63 | Width 9ft | 5995840.17489 | 2099294.03492 | 37.7440227989188 | -122.45705861128401 | (37.7440227989188, -122.457058611284) | |||
187602 | 187602 | 212146 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995392.59413 | 2093841.41892 | 37.7290255380777 | -122.458211672548 | (37.7290255380777, -122.458211672548) | ||||
187577 | 187577 | 205961 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 600x Wildwood Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5995381.06521 | 2093316.38835 | 37.7275832683311 | -122.458213544042 | (37.7275832683311, -122.458213544042) | ||||
187551 | 187551 | 188647 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6018073.116719999 | 2098111.74487 | 37.7420281826481 | -122.38009915058001 | (37.7420281826481, -122.38009915058) | ||||
187536 | 187536 | 209135 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6001010.142969999 | 2095737.8079 | 37.7345537777227 | -122.438927266197 | (37.7345537777227, -122.438927266197) | ||||
187319 | 187319 | 221285 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005941.9303 | 2109128.61885 | 37.771601217256396 | -122.422827765695 | (37.7716012172564, -122.422827765695) | |||
187052 | 187052 | 251050 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 5800x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 10ft | 5988878.2157 | 2112618.8979 | 37.780206989324796 | -122.48210718666901 | (37.7802069893248, -122.482107186669) | |||
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) | ||||
186864 | 186864 | 197885 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6015684.0853699995 | 2101943.48621 | 37.7524172561691 | -122.388627146329 | (37.7524172561691, -122.388627146329) | |||
186834 | 186834 | 246885 | DPW Maintained 3 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 3090x Market St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5999879.22099 | 2105284.18163 | 37.760701410669206 | -122.44352275418899 | (37.7607014106692, -122.443522754189) | ||||
186747 | 186747 | 194316 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 7ft | 6014969.23068 | 2116866.2603700003 | 37.793352239169295 | -122.392142782374 | (37.7933522391693, -122.392142782374) | |||
186731 | 186731 | 188739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 8ft | 6014439.36233 | 2086971.4204900002 | 37.7112379444543 | -122.39188480373801 | (37.7112379444543, -122.391884803738) | |||
186713 | 186713 | 199575 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1300x De Haro St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012270.74731 | 2102100.8941599997 | 37.752659706198294 | -122.400442161487 | (37.7526597061983, -122.400442161487) | ||||
186566 | 186566 | 132093 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012902.31977 | 2119848.32419 | 37.8014252975988 | -122.39950394556699 | (37.8014252975988, -122.399503945567) | |||
186558 | 186558 | 187746 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2x Dukes Ct | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6016141.394640001 | 2096265.75957 | 37.7368527200761 | -122.38664979707501 | (37.7368527200761, -122.386649797075) | ||||
186536 | 186536 | 132183 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1306x Montgomery St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 6011446.11989 | 2119998.19994 | 37.801755545737294 | -122.404553631656 | (37.8017555457373, -122.404553631656) | |||
186488 | 186488 | 249476 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6006383.25331 | 2114827.68427 | 37.78727435725771 | -122.421706060208 | (37.7872743572577, -122.421706060208) | ||||
186446 | 186446 | 231478 | DPW Maintained 3 | Malus :: Crab Apple 235 | 600x San Jose Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005969.94367 | 2099650.47553 | 37.745578028916995 | -122.422057419928 | (37.745578028917, -122.422057419928) | |||
186445 | 186445 | 222811 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3400x Cesar Chavez St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 10ft | 6006785.0700900005 | 2100560.48159 | 37.748122639944704 | -122.419303374748 | (37.7481226399447, -122.419303374748) | |||
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) | |||
186368 | 186368 | 234408 | DPW Maintained 3 | Phoenix dactylifera :: Date Palm 65 | 1700x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6005328.71951 | 2098210.15562 | 37.7415870517023 | -122.424172262039 | (37.7415870517023, -122.424172262039) | ||||
186361 | 186361 | 195681 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 10ft | 6015351.95562 | 2111719.9418200003 | 37.779242863700794 | -122.390458762259 | (37.7792428637008, -122.390458762259) | |||
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) | |||
186279 | 186279 | 126369 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1306x Montgomery St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6011435.17205 | 2120070.79941 | 37.801954274322206 | -122.404596630044 | (37.8019542743222, -122.404596630044) | |||
186146 | 186146 | 212139 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5995385.05875 | 2093507.2159099998 | 37.728107464286204 | -122.45821354403999 | (37.7281074642862, -122.45821354404) | ||||
185898 | 185898 | 188406 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 6012288.20028 | 2102185.92507 | 37.75289415586 | -122.400387777694 | (37.75289415586, -122.400387777694) | |||
185868 | 185868 | 132133 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 10ft | 6013516.34459 | 2118862.0699 | 37.7987514845508 | -122.39730992891 | (37.7987514845508, -122.39730992891) | |||
185837 | 185837 | 189989 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1427x Innes Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6016321.76004 | 2096621.1016 | 37.737838401311706 | -122.386050952014 | (37.7378384013117, -122.386050952014) | ||||
185691 | 185691 | 217802 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5991046.80022 | 2095992.48375 | 37.734681145124505 | -122.47339209648001 | (37.7346811451245, -122.47339209648) | ||||
185624 | 185624 | 212116 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2001x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 5992083.71687 | 2095423.23256 | 37.7331781144806 | -122.469765726035 | (37.7331781144806, -122.469765726035) | |||
185473 | 185473 | 242779 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006556.42632 | 2109149.52189 | 37.77169326466979 | -122.420703668659 | (37.7716932646698, -122.420703668659) | |||
184948 | 184948 | 190916 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 61 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012503.648130001 | 2102901.04205 | 37.754869723572895 | -122.39969292101601 | (37.7548697235729, -122.399692921016) | ||||
184668 | 184668 | 135610 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014284.458430001 | 2117732.9706900003 | 37.7956939784573 | -122.39457288004499 | (37.7956939784573, -122.394572880045) | ||||
184580 | 184580 | 206812 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993679.09704 | 2097560.53952 | 37.739138713068 | -122.464405236026 | (37.739138713068, -122.464405236026) | ||||
184455 | 184455 | 220705 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3300x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6007530.958190001 | 2100569.16609 | 37.748188465819794 | -122.416724727984 | (37.7481884658198, -122.416724727984) | |||
184341 | 184341 | 222760 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 10x Benton Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6004726.81144 | 2094996.18589 | 37.73272821244 | -122.426024717968 | (37.73272821244, -122.426024717968) | ||||
184299 | 184299 | 189334 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016143.045059999 | 2096752.0834599999 | 37.73818815846639 | -122.386677993501 | (37.7381881584664, -122.386677993501) | ||||
184281 | 184281 | 199402 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016663.61896 | 2095979.5906099998 | 37.736095855134394 | -122.384824290234 | (37.7360958551344, -122.384824290234) | ||||
184176 | 184176 | 131158 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1237x Robert C Levy Tunl | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6007691.70139 | 2118146.70965 | 37.79646127913271 | -122.417414400977 | (37.7964612791327, -122.417414400977) | ||||
183989 | 183989 | 223863 | DPW Maintained 3 | Cussonia spicata :: Cabbage tree 325 | 3700x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6005802.979169999 | 2100534.20381 | 37.7479951268836 | -122.422697548374 | (37.7479951268836, -122.422697548374) | |||
183939 | 183939 | 246883 | DPW Maintained 3 | Pittosporum tobira :: Japanese Mockorange 243 | 3090x Market St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5999870.066869999 | 2105328.2836599997 | 37.76082198187 | -122.443557582215 | (37.76082198187, -122.443557582215) | ||||
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) | |||
183866 | 183866 | 136293 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6006248.16207 | 2115803.32411 | 37.789945603663604 | -122.42224279089899 | (37.7899456036636, -122.422242790899) | ||||
183804 | 183804 | 198502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012462.6007 | 2103568.62023 | 37.75670045906929 | -122.399881750743 | (37.7567004590693, -122.399881750743) | ||||
183718 | 183718 | 246549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6005737.248 | 2109452.9268900002 | 37.77248013816789 | -122.423558835368 | (37.7724801381679, -122.423558835368) | |||
183715 | 183715 | 211471 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 200x Terrace Dr | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993818.60983 | 2096510.8522700001 | 37.736264574250995 | -122.463846696775 | (37.736264574251, -122.463846696775) | ||||
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) | ||||
183462 | 183462 | 206813 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 198x San Anselmo Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5993675.924 | 2096312.14772 | 37.7357107573442 | -122.464325594759 | (37.7357107573442, -122.464325594759) | ||||
183458 | 183458 | 194358 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6016102.75205 | 2114084.3299 | 37.7857765633769 | -122.388026462162 | (37.7857765633769, -122.388026462162) | |||
183025 | 183025 | 212126 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5995367.13793 | 2092485.42648 | 37.725300846538 | -122.458201574057 | (37.725300846538, -122.458201574057) | ||||
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) | ||||
182967 | 182967 | 213725 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x San Lorenzo Way | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993679.6596 | 2097491.88512 | 37.7389502376721 | -122.46439830763201 | (37.7389502376721, -122.464398307632) | ||||
182808 | 182808 | 194353 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 6016057.99648 | 2113605.1395799997 | 37.7844583353237 | -122.388147851742 | (37.7844583353237, -122.388147851742) | |||
182720 | 182720 | 247577 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 300x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | 6008700.9232 | 2095336.3735 | 37.7338860994661 | -122.41230921050501 | (37.7338860994661, -122.412309210505) | ||||
182641 | 182641 | 233932 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004814.58298 | 2107439.6885599997 | 37.7669001488458 | -122.426607040704 | (37.7669001488458, -122.426607040704) | ||||
182585 | 182585 | 194343 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016001.634319999 | 2112937.23784 | 37.7826213045779 | -122.38829621649799 | (37.7826213045779, -122.388296216498) | |||
182508 | 182508 | 222827 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3300x Cesar Chavez St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6007469.113419999 | 2100569.02723 | 37.748184605929204 | -122.41693857595399 | (37.7481846059292, -122.416938575954) | |||
182470 | 182470 | 132107 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6011604.73213 | 2121437.1460700002 | 37.805715402812204 | -122.40410608402901 | (37.8057154028122, -122.404106084029) | |||
182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
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) | |||
182277 | 182277 | 194342 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 418x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 8ft | 6016043.56926 | 2112825.74631 | 37.7823174973895 | -122.38814335514999 | (37.7823174973895, -122.38814335515) | |||
182257 | 182257 | 212115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1902x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 5992194.67664 | 2095416.97281 | 37.7331673397011 | -122.46938165614401 | (37.7331673397011, -122.469381656144) | |||
182169 | 182169 | 212152 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5995399.05929 | 2094305.60657 | 37.730300456589106 | -122.458222905079 | (37.7303004565891, -122.458222905079) | ||||
182110 | 182110 | 194322 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014773.3420400005 | 2117151.64182 | 37.7941249519603 | -122.392840551058 | (37.7941249519603, -122.392840551058) | |||
182038 | 182038 | 234353 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004972.999969999 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | ||||
182030 | 182030 | 195476 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014549.96512 | 2117428.46755 | 37.7948726411219 | -122.39363284927299 | (37.7948726411219, -122.393632849273) | ||||
181994 | 181994 | 132108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011532.668269999 | 2121506.48507 | 37.8059017639302 | -122.404360356561 | (37.8059017639302, -122.404360356561) | |||
181805 | 181805 | 217819 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x Junipero Serra Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 5991622.365809999 | 2095679.35409 | 37.733854682528204 | -122.471379381376 | (37.7338546825282, -122.471379381376) | ||||
181686 | 181686 | 246870 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3090x Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5999943.44665 | 2105326.58667 | 37.7608215070397 | -122.443303673043 | (37.7608215070397, -122.443303673043) | ||||
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) | |||
181589 | 181589 | 250137 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2550x Lyon St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5999214.14671 | 2117588.9485299997 | 37.7944491854404 | -122.44670830396002 | (37.7944491854404, -122.44670830396) | ||||
181577 | 181577 | 195680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015377.63395 | 2111744.49968 | 37.779311718508 | -122.390371645854 | (37.779311718508, -122.390371645854) | |||
181413 | 181413 | 195720 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 10ft | 6014817.65208 | 2111211.59026 | 37.7778173905846 | -122.39227159046001 | (37.7778173905846, -122.39227159046) | |||
181397 | 181397 | 197883 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6015671.68668 | 2101942.82757 | 37.752414760540105 | -122.388669977447 | (37.7524147605401, -122.388669977447) | |||
181312 | 181312 | 246539 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6005686.56992 | 2109401.16217 | 37.7723351440794 | -122.423730454802 | (37.7723351440794, -122.423730454802) | |||
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) | ||||
181048 | 181048 | 196779 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6013679.35435 | 2108527.95824 | 37.7703854696435 | -122.396021274189 | (37.7703854696435, -122.396021274189) | ||||
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) | ||||
180863 | 180863 | 218285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5991436.68421 | 2095414.89925 | 37.7331178131424 | -122.47200206387 | (37.7331178131424, -122.47200206387) | ||||
180749 | 180749 | 206822 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5994175.83574 | 2101201.51334 | 37.7491645333344 | -122.462951839858 | (37.7491645333344, -122.462951839858) | |||
180628 | 180628 | 249479 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6006342.53317 | 2115134.23147 | 37.7881137637835 | -122.42186872687799 | (37.7881137637835, -122.421868726878) | ||||
180599 | 180599 | 191725 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 46 | 6011608.2265 | 2103816.01851 | 37.75733209161471 | -122.40285390399201 | (37.7573320916147, -122.402853903992) | ||||
180529 | 180529 | 190135 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2160x Palou Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6011839.17334 | 2097531.5367900003 | 37.7400891579846 | -122.40161349967899 | (37.7400891579846, -122.401613499679) | ||||
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) |
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");