Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 188944 | 188944 | 184944 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1990 41st Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5983563.2069 | 2101275.9659 | 37.748751952115505 | -122.49965537495702 | (37.7487519521155, -122.499655374957) | |||
| 188943 | 188943 | 240914 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006391.17124 | 2105833.44907 | 37.762578798502204 | -122.421039806442 | (37.7625787985022, -122.421039806442) | |||
| 188942 | 188942 | 227580 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 23 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003811.04552 | 2108200.21185 | 37.7689315761679 | -122.430132375016 | (37.7689315761679, -122.430132375016) | |||
| 188941 | 188941 | 196738 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 700 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6013717.49862 | 2109926.74166 | 37.7742283375105 | -122.395987369746 | (37.7742283375105, -122.395987369746) | |||
| 188940 | 188940 | 202612 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 560 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6011424.9228300005 | 2109694.3187 | 37.773462341755796 | -122.40390148738899 | (37.7734623417558, -122.403901487389) | |||
| 188938 | 188938 | 104756 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 50 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5998478.129930001 | 2116269.10777 | 37.7907831827466 | -122.449159871157 | (37.7907831827466, -122.449159871157) | |||
| 188937 | 188937 | 234188 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Day St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003193.94569 | 2098602.90337 | 37.7425446794999 | -122.431581614504 | (37.7425446794999, -122.431581614504) | |||
| 188936 | 188936 | 241351 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6009671.132730001 | 2105926.35263 | 37.7630182387282 | -122.409702117253 | (37.7630182387282, -122.409702117253) | |||
| 188935 | 188935 | 133649 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003131.50337 | 2120909.28227 | 37.8037889533516 | -122.433391166484 | (37.8037889533516, -122.433391166484) | |||
| 188934 | 188934 | 110474 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 745 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 6x9 | 6004444.60179 | 2111147.58704 | 37.77706021269321 | -122.42815102017799 | (37.7770602126932, -122.428151020178) | |||
| 188933 | 188933 | 219023 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1700 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993391.46248 | 2103845.40057 | 37.7563787563006 | -122.465856267847 | (37.7563787563006, -122.465856267847) | |||
| 188932 | 188932 | 246287 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2312 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002715.3396 | 2106368.9627 | 37.763841293949206 | -122.433791440708 | (37.7638412939492, -122.433791440708) | |||
| 188931 | 188931 | 195333 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 109 Steuart St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014551.003930001 | 2116991.43348 | 37.793672705393 | -122.393598652577 | (37.793672705393, -122.393598652577) | |||
| 188930 | 188930 | 250562 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 445 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5987191.81534 | 2115294.08526 | 37.7874540598079 | -122.488137777348 | (37.7874540598079, -122.488137777348) | |||
| 188929 | 188929 | 203816 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1625 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5993083.51125 | 2095334.29452 | 37.7329916508262 | -122.466302734486 | (37.7329916508262, -122.466302734486) | |||
| 188928 | 188928 | 248190 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 216 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6007395.06383 | 2098734.36623 | 37.7431428725527 | -122.41706466002701 | (37.7431428725527, -122.417064660027) | ||||
| 188926 | 188926 | 235831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1960 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009499.060269999 | 2105650.63341 | 37.7622515325076 | -122.41027779129801 | (37.7622515325076, -122.410277791298) | |||
| 188925 | 188925 | 238649 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003254.383880001 | 2096371.53066 | 37.736421268524296 | -122.431213399685 | (37.7364212685243, -122.431213399685) | |||
| 188924 | 188924 | 218143 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 72 Ridge Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5997148.20318 | 2090029.45832 | 37.718659516001 | -122.451867536453 | (37.718659516001, -122.451867536453) | |||
| 188923 | 188923 | 179577 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 700 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001127.46159 | 2089574.9646 | 37.7176386901633 | -122.438080342229 | (37.7176386901633, -122.438080342229) | |||
| 188922 | 188922 | 178091 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 327 Maynard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 8ft | 6005482.9740699995 | 2093860.26389 | 37.7296519293885 | -122.42332975108101 | (37.7296519293885, -122.423329751081) | |||
| 188921 | 188921 | 138402 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002032.4913 | 2114879.2037 | 37.7871695157566 | -122.43676243751001 | (37.7871695157566, -122.43676243751) | |||
| 188920 | 188920 | 186056 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 1901 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984841.3927 | 2102202.6369 | 37.7513712544474 | -122.495303811437 | (37.7513712544474, -122.495303811437) |
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");