Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189144 | 189144 | 121399 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | ||||||||||
| 189094 | 189094 | 221424 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 900x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005689.534530001 | 2103630.03961 | 37.7564891759384 | -122.423309876046 | (37.7564891759384, -122.423309876046) | |||
| 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) | ||||
| 188905 | 188905 | 200550 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6016212.9331 | 2095623.1152 | 37.7350921083386 | -122.386357662249 | (37.7350921083386, -122.386357662249) | |||
| 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) | |||
| 188835 | 188835 | 200601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016439.2859 | 2094833.5580000002 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | |||
| 188789 | 188789 | 1301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 4000X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | 10 | 5991772.09471 | 2087046.42932 | 37.7101594558675 | -122.470233284447 | (37.7101594558675, -122.470233284447) | |||
| 188631 | 188631 | 204531 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 3ft | 5999192.435380001 | 2097025.16393 | 37.7379849647319 | -122.44530419514999 | (37.7379849647319, -122.44530419515) | |||
| 188554 | 188554 | 221300 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6010513.720919999 | 2100755.88609 | 37.748868470213104 | -122.406423533516 | (37.7488684702131, -122.406423533516) | |||
| 188458 | 188458 | 188191 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 860x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014720.49682 | 2089157.49571 | 37.7172560852665 | -122.39106582262501 | (37.7172560852665, -122.391065822625) | |||
| 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) | |||
| 188264 | 188264 | 206032 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601x Monterey Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5997524.38886 | 2094711.3028099998 | 37.7315362986421 | -122.450904629644 | (37.7315362986421, -122.450904629644) | |||
| 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) | |||
| 188243 | 188243 | 180043 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000932.74205 | 2090913.3851700001 | 37.721302615409705 | -122.438849257207 | (37.7213026154097, -122.438849257207) | |||
| 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) | ||||
| 188083 | 188083 | 221533 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005767.42939 | 2102227.70946 | 37.75264309841 | -122.422940823082 | (37.75264309841, -122.422940823082) | |||
| 188070 | 188070 | 184620 | DPW Maintained 3 | :: 54 | 3000x Noriega St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984460.1938 | 2102931.6946 | 37.753350719104795 | -122.496675818993 | (37.7533507191048, -122.496675818993) | |||
| 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) | ||||
| 187999 | 187999 | 140339 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1300x WEBSTER ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | |||
| 187997 | 187997 | 49658 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 3630 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 04/18/2011 12:00:00 AM | 1 | Permit Number 46510 | 6000258.18089 | 2120685.13581 | 37.8030100766084 | -122.44331832298401 | (37.8030100766084, -122.443318322984) | ||
| 187959 | 187959 | 88452 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | ||
| 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) | ||||
| 187731 | 187731 | 231187 | DPW Maintained 3 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2850x Bryant St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 6009843.90305 | 2100697.4884 | 37.748670629262904 | -122.408735654529 | (37.7486706292629, -122.408735654529) | |||
| 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) | |||
| 187646 | 187646 | 200535 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6016168.4829 | 2095664.0064 | 37.735201926775396 | -122.386514194261 | (37.7352019267754, -122.386514194261) | |||
| 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) | ||||
| 187581 | 187581 | 180063 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000614.24594 | 2090358.9478799999 | 37.7197621306905 | -122.439910472497 | (37.7197621306905, -122.439910472497) | |||
| 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) | ||||
| 187415 | 187415 | 244374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.42401292788901 | (37.7735554657504, -122.424012927889) | |||
| 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) | |||
| 187220 | 187220 | 29952 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 139 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 2 | 3x3 | 5995468.7175 | 2088041.2261 | 37.7131039615411 | -122.457529027577 | (37.7131039615411, -122.457529027577) | ||
| 187201 | 187201 | 112596 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001324.7675 | 2112728.8365 | 37.7812249111251 | -122.439056830439 | (37.7812249111251, -122.439056830439) | |||
| 187159 | 187159 | 208135 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 15x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993326.71612 | 2100337.0457 | 37.7467419791719 | -122.465825280839 | (37.7467419791719, -122.465825280839) | |||
| 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) | ||||
| 187000 | 187000 | 211365 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1x Minerva St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5996056.33729 | 2089003.23942 | 37.715779161955396 | -122.45556751823601 | (37.7157791619554, -122.455567518236) | |||
| 186972 | 186972 | 244255 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005643.2766 | 2110040.2561 | 37.7740874977816 | -122.423925664351 | (37.7740874977816, -122.423925664351) | |||
| 186887 | 186887 | 141089 | DPW Maintained 3 | Tristania conferta :: 79 | 100x JORDAN AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996248.2713 | 2112978.5918 | 37.7816205163369 | -122.456636959709 | (37.7816205163369, -122.456636959709) | |||
| 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) | ||||
| 186690 | 186690 | 212295 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5991170.53267 | 2089939.6813400001 | 37.7180688232854 | -122.472523177809 | (37.7180688232854, -122.472523177809) | |||
| 186679 | 186679 | 179670 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 300x Winding Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6001487.80324 | 2086473.7350700002 | 37.7091438874604 | -122.436612949055 | (37.7091438874604, -122.436612949055) | |||
| 186623 | 186623 | 175620 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009477.4678 | 2090042.2500200002 | 37.719393098398704 | -122.40925098404499 | (37.7193930983987, -122.409250984045) | |||
| 186596 | 186596 | 2255 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 5990660.02895 | 2088282.4204099998 | 37.713488829713796 | -122.474166893001 | (37.7134888297138, -122.474166893001) | ||||
| 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) | |||
| 186533 | 186533 | 103207 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987194.6566 | 2103923.6817 | 37.756234279341896 | -122.487292457342 | (37.7562342793419, -122.487292457342) | |||
| 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) | ||||
| 186484 | 186484 | 244409 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6005580.6462 | 2110260.99 | 37.7746900436181 | -122.424158015373 | (37.7746900436181, -122.424158015373) | |||
| 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) | |||
| 186381 | 186381 | 206462 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 100x Casitas Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5995528.33875 | 2096982.8424099998 | 37.7376589218079 | -122.457969641597 | (37.7376589218079, -122.457969641597) | |||
| 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) | |||
| 186357 | 186357 | 211055 | DPW Maintained 3 | Pinus muricata :: Bishop Pine 302 | 300x Marietta Dr | 72 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999722.47175 | 2097250.7906299997 | 37.7386347240172 | -122.443487806529 | (37.7386347240172, -122.443487806529) | |||
| 186302 | 186302 | 175614 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6011421.832780001 | 2090628.0448200002 | 37.7211103133815 | -122.402571168832 | (37.7211103133815, -122.402571168832) | |||
| 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) | |||
| 186164 | 186164 | 5105 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2638 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/2002 12:00:00 AM | 3 | 3X3 | 6002275.8937 | 2096498.7145900002 | 37.7367149871144 | -122.43460553902399 | (37.7367149871144, -122.434605539024) | ||
| 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) | ||||
| 186128 | 186128 | 204546 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 69 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999726.305480001 | 2097318.0909700003 | 37.738819733438504 | -122.443479384359 | (37.7388197334385, -122.443479384359) | |||
| 186073 | 186073 | 233637 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 758x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005642.24056 | 2098618.09907 | 37.74272486946911 | -122.423117200821 | (37.7427248694691, -122.423117200821) | |||
| 185941 | 185941 | 12641 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 934 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3PL | 5992552.1163800005 | 2114856.32512 | 37.786563348548604 | -122.469560515868 | (37.7865633485486, -122.469560515868) | |||
| 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) | |||
| 185855 | 185855 | 180082 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000152.851 | 2089912.6147900003 | 37.7185103256827 | -122.441473335931 | (37.7185103256827, -122.441473335931) | |||
| 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) | ||||
| 185759 | 185759 | 211336 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 501x Ortega St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5992533.484209999 | 2103100.12483 | 37.7542828925471 | -122.46876920076201 | (37.7542828925471, -122.468769200762) | |||
| 185709 | 185709 | 222799 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 6ft | 6010384.90884 | 2100709.18955 | 37.7487330449049 | -122.40686567713499 | (37.7487330449049, -122.406865677135) | |||
| 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) | |||
| 185585 | 185585 | 180028 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001180.14199 | 2091386.50132 | 37.7226157577852 | -122.438027939654 | (37.7226157577852, -122.438027939654) | |||
| 185520 | 185520 | 206438 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Marietta Dr | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5999556.5851300005 | 2097486.39574 | 37.73927217785771 | -122.44407828610001 | (37.7392721778577, -122.4440782861) | |||
| 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) | |||
| 185443 | 185443 | 142131 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2200x GEARY BLVD | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6000333.6993 | 2113366.7616 | 37.7829200486713 | -122.442531241518 | (37.7829200486713, -122.442531241518) | |||
| 185409 | 185409 | 180035 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001087.26718 | 2091207.92549 | 37.722120146807896 | -122.43833619936399 | (37.7221201468079, -122.438336199364) | |||
| 185396 | 185396 | 180066 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000525.601009999 | 2090267.6783099999 | 37.7195064786158 | -122.440210344258 | (37.7195064786158, -122.440210344258) | |||
| 185379 | 185379 | 113500 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 3x3 | 6011183.30408 | 2090581.60768 | 37.7209694867258 | -122.403392432416 | (37.7209694867258, -122.403392432416) | |||
| 185370 | 185370 | 16141 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 370 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | CUT | 5999730.64272 | 2094724.12039 | 37.7316975479964 | -122.44327812778099 | (37.7316975479964, -122.443278127781) | |||
| 185266 | 185266 | 213775 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5999015.12983 | 2094689.3935 | 37.731561369058795 | -122.44574929389799 | (37.7315613690588, -122.445749293898) | |||
| 185218 | 185218 | 221536 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 6005762.1987 | 2102333.32685 | 37.75293280420979 | -122.422966417762 | (37.7529328042098, -122.422966417762) | |||
| 185211 | 185211 | 244333 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6005640.1134 | 2109813.1769999997 | 37.773463814863 | -122.42392045570699 | (37.773463814863, -122.423920455707) | |||
| 185178 | 185178 | 221511 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005835.54562 | 2100976.57743 | 37.749211620932606 | -122.422616365666 | (37.7492116209326, -122.422616365666) | |||
| 185126 | 185126 | 97377 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006713.66086 | 2118020.1658099997 | 37.7960587443728 | -122.420789650134 | (37.7960587443728, -122.420789650134) |
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");