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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189044 | 189044 | 181896 | Undocumented 2 | Tree(s) :: 17 | 2343 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986379.7223 | 2099305.8434 | 37.7435073893325 | -122.489771144773 | (37.7435073893325, -122.489771144773) | |||
| 189043 | 189043 | 210132 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 360 Flood Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5998258.462669999 | 2094123.67501 | 37.7299648080121 | -122.44832450527299 | (37.7299648080121, -122.448324505273) | |||
| 189042 | 189042 | 178219 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 49 Santos St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 6ft | 6006726.5178 | 2087416.33462 | 37.712028383779895 | -122.41857390945499 | (37.7120283837799, -122.418573909455) | |||
| 189041 | 189041 | 130818 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2205 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6003521.30137 | 2117210.30876 | 37.79365463619661 | -122.431777984168 | (37.7936546361966, -122.431777984168) | |||
| 189040 | 189040 | 127212 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2332 Baker St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999771.60185 | 2117008.74774 | 37.7928879353713 | -122.444737723873 | (37.7928879353713, -122.444737723873) | |||
| 189039 | 189039 | 117389 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1650 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6006295.544430001 | 2117317.5523599996 | 37.7941059690696 | -122.42218647533998 | (37.7941059690696, -122.42218647534) | |||
| 189038 | 189038 | 131471 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 280 Redwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6006315.87363 | 2112335.20118 | 37.7804268103756 | -122.421762072675 | (37.7804268103756, -122.421762072675) | |||
| 189037 | 189037 | 206564 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.46650288401399 | (37.7501303674196, -122.466502884014) | |||
| 189036 | 189036 | 197848 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6012012.98096 | 2091233.72895 | 37.722806384392 | -122.400570254626 | (37.722806384392, -122.400570254626) | |||
| 189035 | 189035 | 195706 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 King St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014489.99692 | 2110956.01492 | 37.777097439219204 | -122.39338718236601 | (37.7770974392192, -122.393387182366) | |||
| 189034 | 189034 | 122230 | Undocumented 2 | Prunus spp :: Cherry 84 | 700 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991662.29598 | 2110580.8797299997 | 37.774772683199394 | -122.472327258665 | (37.7747726831994, -122.472327258665) | |||
| 189033 | 189033 | 249723 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6000201.87433 | 2117349.10426 | 37.7938470092862 | -122.443273421624 | (37.7938470092862, -122.443273421624) | ||||
| 189032 | 189032 | 30841 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2586 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1995 12:00:00 AM | 22 | Permit Number 34689 | 6002395.11591 | 2116122.86039 | 37.790604880464294 | -122.43559684281799 | (37.7906048804643, -122.435596842818) | ||
| 189031 | 189031 | 134365 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 920 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006003.89735 | 2113165.73066 | 37.782689643164396 | -122.422900390454 | (37.7826896431644, -122.422900390454) | |||
| 189030 | 189030 | 128980 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 199 McAllister St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6008492.62721 | 2112417.9062099997 | 37.7807764092316 | -122.414237490093 | (37.7807764092316, -122.414237490093) | |||
| 189029 | 189029 | 140863 | Undocumented 2 | :: 54 | 106 JORDAN AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5996246.41 | 2113718.2127 | 37.7836512118011 | -122.45669690496901 | (37.7836512118011, -122.456696904969) | |||
| 189028 | 189028 | 79350 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1946 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767118 | 5983237.8759 | 2101878.6369 | 37.750387624519796 | -122.500824911735 | (37.7503876245198, -122.500824911735) |
| 189027 | 189027 | 177145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 646 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001109.079969999 | 2090060.7156599998 | 37.718971408083796 | -122.438178657041 | (37.7189714080838, -122.438178657041) | |||
| 189026 | 189026 | 248177 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007380.96811 | 2098703.14115 | 37.743056342490796 | -122.417111187331 | (37.7430563424908, -122.417111187331) | ||||
| 189025 | 189025 | 246736 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 110 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6008636.33373 | 2099057.51181 | 37.744099907697 | -122.412795505415 | (37.744099907697, -122.412795505415) | |||
| 189024 | 189024 | 209189 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994812.38667 | 2098544.02713 | 37.7419043873887 | -122.460558108972 | (37.7419043873887, -122.460558108972) | |||
| 189023 | 189023 | 238388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 80 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6001986.47657 | 2105431.50433 | 37.7612258754818 | -122.436245259426 | (37.7612258754818, -122.436245259426) | |||
| 189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | |
| 189021 | 189021 | 182962 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2050 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5989686.5492 | 2098375.4265 | 37.741145229321496 | -122.47826907299999 | (37.7411452293215, -122.478269073) | |||
| 189020 | 189020 | 237480 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 508 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002957.32404 | 2103311.17002 | 37.755459058298605 | -122.43273604273399 | (37.7554590582986, -122.432736042734) | |||
| 189019 | 189019 | 248579 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 794 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998642.0083 | 2107670.5786 | 37.7671832202752 | -122.44797351892599 | (37.7671832202752, -122.447973518926) | |||
| 189018 | 189018 | 247049 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 527 Valley St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002466.92979 | 2099138.14647 | 37.7439730978735 | -122.434133672824 | (37.7439730978735, -122.434133672824) | |||
| 189017 | 189017 | 131199 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1847 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008657.5896 | 2119259.89568 | 37.7995721096252 | -122.414151004059 | (37.7995721096252, -122.414151004059) | |||
| 189016 | 189016 | 182660 | Undocumented 2 | :: 54 | 1890 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986007.8679 | 2102386.3122 | 37.75194380463171 | -122.49128357776199 | (37.7519438046317, -122.491283577762) | |||
| 189015 | 189015 | 132607 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 300 Laurel St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5998069.1356 | 2115417.33363 | 37.7884210360372 | -122.450513532469 | (37.7884210360372, -122.450513532469) | |||
| 189014 | 189014 | 209015 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6000779.78636 | 2095479.1538 | 37.73383046469421 | -122.439705146498 | (37.7338304646942, -122.439705146498) | ||||
| 189013 | 189013 | 183208 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4208 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5982977.5431 | 2098144.6836 | 37.74011993093129 | -122.501448961428 | (37.7401199309313, -122.501448961428) | |||
| 189012 | 189012 | 126364 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 Filbert St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6007584.0296 | 2119571.97409 | 37.8003686400458 | -122.41788805230699 | (37.8003686400458, -122.417888052307) | |||
| 189011 | 189011 | 80586 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1919 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985971.2412 | 2102145.8827 | 37.7512815105045 | -122.49139254176599 | (37.7512815105045, -122.491392541766) | |||
| 189010 | 189010 | 235790 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 19 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006490.31542 | 2108352.63521 | 37.7695014774321 | -122.420875764729 | (37.7695014774321, -122.420875764729) | |||
| 189009 | 189009 | 210872 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 371 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5997627.30354 | 2093781.8331900002 | 37.72899008680061 | -122.450481853864 | (37.7289900868006, -122.450481853864) | |||
| 189008 | 189008 | 197555 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Kansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6011386.38473 | 2107363.2099 | 37.7670594952368 | -122.403870728771 | (37.7670594952368, -122.403870728771) | |||
| 189007 | 189007 | 214828 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996730.05288 | 2091219.63097 | 37.7219034920315 | -122.453398786937 | (37.7219034920315, -122.453398786937) | |||
| 189006 | 189006 | 137842 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800X Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
| 189005 | 189005 | 105881 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5997617.52659 | 2115483.20836 | 37.788576052199396 | -122.452080774722 | (37.7885760521994, -122.452080774722) | ||||
| 189004 | 189004 | 201909 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.39459380727101 | (37.728396715017, -122.394593807271) | |||
| 189003 | 189003 | 198354 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 529 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010061.1102599995 | 2112105.44077 | 37.7800064312917 | -122.408789271213 | (37.7800064312917, -122.408789271213) | |||
| 189002 | 189002 | 186741 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984866.449 | 2106632.432 | 37.7635357085517 | -122.495543856208 | (37.7635357085517, -122.495543856208) | |||
| 189001 | 189001 | 234324 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 115 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006201.08295 | 2102382.1354900002 | 37.753091576833796 | -122.421452136626 | (37.7530915768338, -122.421452136626) | |||
| 189000 | 189000 | 123975 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 59 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993615.75025 | 2115111.34494 | 37.7873249775569 | -122.4658991705 | (37.7873249775569, -122.4658991705) | |||
| 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) | |||
| 188998 | 188998 | 183023 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2550 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983685.1086 | 2097771.6711 | 37.739137270019 | -122.49897497427901 | (37.739137270019, -122.498974974279) | |||
| 188997 | 188997 | 142210 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 419 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999721.1207 | 2110069.3739 | 37.7738313306649 | -122.444413453632 | (37.7738313306649, -122.444413453632) | |||
| 188996 | 188996 | 181266 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6009541.56007 | 2087669.1100400002 | 37.712880535479 | -122.40886209741001 | (37.712880535479, -122.40886209741) | |||
| 188995 | 188995 | 192310 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011946.18566 | 2107352.67758 | 37.76706183436821 | -122.40193371137501 | (37.7670618343682, -122.401933711375) | |||
| 188994 | 188994 | 245076 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1387 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000344.2484 | 2109550.1314 | 37.7724411555945 | -122.442220678844 | (37.7724411555945, -122.442220678844) | |||
| 188993 | 188993 | 221754 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3879 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003935.10667 | 2102444.58543 | 37.753135026677604 | -122.42929277965099 | (37.7531350266776, -122.429292779651) | |||
| 188992 | 188992 | 224334 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005384.8818 | 2103641.26634 | 37.756502803379 | -122.42436427271099 | (37.756502803379, -122.424364272711) | |||
| 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) | ||||
| 188990 | 188990 | 237330 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007590.604590001 | 2099741.7313 | 37.745919870209605 | -122.416459870422 | (37.7459198702096, -122.416459870422) | |||
| 188989 | 188989 | 110597 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 624 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x2 | 6009274.88021 | 2115156.652 | 37.7883402580439 | -122.411724859841 | (37.7883402580439, -122.411724859841) | |||
| 188988 | 188988 | 209466 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1878 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991597.36257 | 2102597.82029 | 37.752849570170206 | -122.47196990591101 | (37.7528495701702, -122.471969905911) | |||
| 188987 | 188987 | 207327 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 48 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998437.39477 | 2097397.71392 | 37.7389647688951 | -122.44794154698401 | (37.7389647688951, -122.447941546984) | |||
| 188986 | 188986 | 120093 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 655 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5987822.4003099995 | 2111507.4982 | 37.7770939337825 | -122.485678099475 | (37.7770939337825, -122.485678099475) | |||
| 188985 | 188985 | 34804 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 122 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 4 | Permit Number 38440 | 5999160.28006 | 2089153.53909 | 37.716369479631204 | -122.444849697578 | (37.7163694796312, -122.444849697578) | |
| 188984 | 188984 | 132403 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 93 MacOndray Ln | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6008160.59399 | 2119098.20458 | 37.799100218256704 | -122.415859337341 | (37.7991002182567, -122.415859337341) | ||||
| 188983 | 188983 | 141704 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 154 STANYAN BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5996607.8351 | 2111918.4266 | 37.778730220256 | -122.455316406199 | (37.778730220256, -122.455316406199) | |||
| 188982 | 188982 | 220022 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001965.3710900005 | 2100066.86744 | 37.746494668288996 | -122.435934385359 | (37.746494668289, -122.435934385359) | |||
| 188981 | 188981 | 131186 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 2501 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6001413.74236 | 2116589.85963 | 37.7918313506904 | -122.439025814797 | (37.7918313506904, -122.439025814797) | |||
| 188980 | 188980 | 220555 | Undocumented 2 | Aesculus hippocastanum :: White Horsechestnut 364 | 3145 23rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008162.12941 | 2102678.11582 | 37.7540146463708 | -122.41469137612101 | (37.7540146463708, -122.414691376121) | |||
| 188979 | 188979 | 208590 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1640 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 6ft | 5993420.78428 | 2104324.2280599996 | 37.757695183915104 | -122.465789652393 | (37.7576951839151, -122.465789652393) | |||
| 188978 | 188978 | 245223 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 321 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005094.6874 | 2109989.2967 | 37.7739165895729 | -122.425819703011 | (37.7739165895729, -122.425819703011) | |||
| 188977 | 188977 | 233505 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 303 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004187.87714 | 2109045.00996 | 37.7712725222301 | -122.42888917559799 | (37.7712725222301, -122.428889175598) | |||
| 188976 | 188976 | 219246 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 628 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5999461.66823 | 2095170.54845 | 37.732907993207604 | -122.44424009212 | (37.7329079932076, -122.44424009212) | |||
| 188975 | 188975 | 143021 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 685 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008591.686000001 | 2120703.4993 | 37.8035321827214 | -122.414481260898 | (37.8035321827214, -122.414481260898) | |||
| 188974 | 188974 | 250864 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 170 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986515.92946 | 2114612.51535 | 37.7855432117965 | -122.49042601236 | (37.7855432117965, -122.49042601236) | |||
| 188973 | 188973 | 200161 | Undocumented 2 | :: 54 | 1083 Hollister Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014425.6299 | 2089982.8806 | 37.7195060625081 | -122.392142737787 | (37.7195060625081, -122.392142737787) | |||
| 188972 | 188972 | 187326 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2200 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985094.7578 | 2099652.5203 | 37.7443841605942 | -122.494239713708 | (37.7443841605942, -122.494239713708) | |||
| 188971 | 188971 | 55570 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 81 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1973 12:00:00 AM | 5 | Permit Number 49713 | 5996815.9739 | 2114044.1129 | 37.7845787332894 | -122.45474999571998 | (37.7845787332894, -122.45474999572) | ||
| 188970 | 188970 | 134111 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2716 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001138.54268 | 2117794.6215 | 37.7951236499858 | -122.44006443013599 | (37.7951236499858, -122.440064430136) | |||
| 188969 | 188969 | 202343 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 230 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014615.41959 | 2115067.39464 | 37.7883933198478 | -122.393241068635 | (37.7883933198478, -122.393241068635) | |||
| 188968 | 188968 | 180471 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008133.97671 | 2092747.70208 | 37.7267463349569 | -122.414086246606 | (37.7267463349569, -122.414086246606) | |||
| 188967 | 188967 | 186602 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984723.2519 | 2104439.4316 | 37.7575059562709 | -122.495877337913 | (37.7575059562709, -122.495877337913) | |||
| 188966 | 188966 | 226346 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008464.57897 | 2101524.14473 | 37.7508630900604 | -122.41356381871599 | (37.7508630900604, -122.413563818716) | |||
| 188965 | 188965 | 182974 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2501 19th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5990445.6911 | 2097993.6128 | 37.7401409062913 | -122.475616387366 | (37.7401409062913, -122.475616387366) | |||
| 188964 | 188964 | 132579 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 115 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998468.5423099995 | 2116022.0814 | 37.790104365469105 | -122.44917523966998 | (37.7901043654691, -122.44917523967) | |||
| 188963 | 188963 | 121868 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 382 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 5990304.700669999 | 2112806.5202900004 | 37.7808050127417 | -122.477186088815 | (37.7808050127417, -122.477186088815) | |||
| 188962 | 188962 | 182197 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1584 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 0ft | 5985008.2078 | 2104414.5267 | 37.7574542590905 | -122.494890024235 | (37.7574542590905, -122.494890024235) | |||
| 188961 | 188961 | 203619 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 624 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6000138.382019999 | 2095835.3347200002 | 37.7347719253748 | -122.441948223841 | (37.7347719253748, -122.441948223841) | |||
| 188960 | 188960 | 241552 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2825 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002458.1519 | 2095543.34833 | 37.734102115717 | -122.43390712642599 | (37.734102115717, -122.433907126426) | |||
| 188959 | 188959 | 217849 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | 5991387.06493 | 2095679.62189 | 37.7338418033391 | -122.47219289908001 | (37.7338418033391, -122.47219289908) | ||||
| 188958 | 188958 | 179892 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 101 Dartmouth St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008521.95318 | 2093544.0453599999 | 37.728954707483 | -122.41280129434799 | (37.728954707483, -122.412801294348) | |||
| 188957 | 188957 | 186755 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984869.1172 | 2106699.1363 | 37.763719016073104 | -122.495539548031 | (37.7637190160731, -122.495539548031) | |||
| 188956 | 188956 | 45565 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3561 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 6 | Permit Number 44309 | 5997197.65372 | 2116007.3067900003 | 37.789991026609705 | -122.45357132096001 | (37.7899910266097, -122.45357132096) | |
| 188955 | 188955 | 138211 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 41 Nido Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999227.06 | 2112067.7296 | 37.7792901011034 | -122.446266263591 | (37.7792901011034, -122.446266263591) | |||
| 188954 | 188954 | 138288 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2605 CALIFORNIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001853.9989 | 2115318.2614 | 37.7883649098379 | -122.43741143323999 | (37.7883649098379, -122.43741143324) | |||
| 188953 | 188953 | 133198 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 556 Pine St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 5ft | 6011234.26177 | 2116330.1506 | 37.7916721266196 | -122.40502834240101 | (37.7916721266196, -122.405028342401) | |||
| 188952 | 188952 | 192296 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010697.50187 | 2105678.84279 | 37.762396094938104 | -122.406134800806 | (37.7623960949381, -122.406134800806) | |||
| 188951 | 188951 | 177670 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 946 Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008872.57604 | 2090401.61835 | 37.7203459408834 | -122.411367252501 | (37.7203459408834, -122.411367252501) | |||
| 188950 | 188950 | 240511 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 301 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009219.87224 | 2106727.2151200003 | 37.765191925295795 | -122.411319458036 | (37.7651919252958, -122.411319458036) | |||
| 188949 | 188949 | 141072 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 197 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996921.8999 | 2113055.5828 | 37.7818705666664 | -122.454312101068 | (37.7818705666664, -122.454312101068) | |||
| 188948 | 188948 | 84503 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 357 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50134 | 6011610.65584 | 2112713.99225 | 37.7817640420151 | -122.403471492712 | (37.7817640420151, -122.403471492712) | |
| 188947 | 188947 | 140139 | Undocumented 2 | Tristania conferta :: 79 | 1744 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999035.8387 | 2109765.9757 | 37.7729591530651 | -122.44676211071501 | (37.7729591530651, -122.446762110715) | |||
| 188946 | 188946 | 210372 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 195 Kensington Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994217.10914 | 2099094.32927 | 37.7433811146583 | -122.46265628039 | (37.7433811146583, -122.46265628039) | |||
| 188945 | 188945 | 69003 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2063 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 5 | Permit Number 33004 | 5982592.2747 | 2101083.7423 | 37.7481671399171 | -122.502998568536 | (37.7481671399171, -122.502998568536) |
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");