Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508 | 508 | 6667 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1550 Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:21:00 PM | 3 | 3X3 | 6015906.32098 | 2098408.37334 | 37.7427228837554 | -122.387611997891 | (37.7427228837554, -122.387611997891) | ||
| 842 | 842 | 175381 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | Width 3ft | 5991335.841440001 | 2089011.6054200002 | 37.715530120800295 | -122.47188417981 | (37.7155301208003, -122.47188417981) | ||
| 1047 | 1047 | 200448 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2585 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6015917.22039 | 2103323.37431 | 37.7562190555923 | -122.387917198143 | (37.7562190555923, -122.387917198143) | |||
| 1320 | 1320 | 251503 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800X Bosworth St | 15 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
| 1981 | 1981 | 35702 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 2274 | 2274 | 253006 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1201 Tennessee St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2522 | 2522 | 141925 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900 MCALLISTER ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2013 12:00:00 AM | 2 | Width 0ft | 6004344.9249 | 2111897.598 | 37.7791139177501 | -122.42854930773399 | (37.7791139177501, -122.428549307734) | ||
| 2660 | 2660 | 37827 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003888.33038 | 2090432.03853 | 37.7201486548235 | -122.428598328547 | (37.7201486548235, -122.428598328547) |
| 2709 | 2709 | 175364 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993263.021319999 | 2087797.41727 | 37.7123075747038 | -122.465134896479 | (37.7123075747038, -122.465134896479) | |||
| 3129 | 3129 | 253317 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3459 | 3459 | 13447 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6013978.34397 | 2117135.9015599997 | 37.7940375441385 | -122.395590246219 | (37.7940375441385, -122.395590246219) | |||
| 3808 | 3808 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369563999 | (37.7228504376851, -122.44574369564) | |||
| 3842 | 3842 | 253547 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 15 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3970 | 3970 | 160072 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:34:00 AM | 3 | Width 0ft | 6000153.57644 | 2090420.2975400002 | 37.7199043485999 | -122.441507239468 | (37.7199043485999, -122.441507239468) | ||
| 4187 | 4187 | 20426 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 4493 | 4493 | 253082 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2849X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:25:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4565 | 4565 | 142525 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 301 FRANCISCO ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 23 | Width 0ft | 6009759.5801 | 2121214.59 | 37.8050010513122 | -122.410475804946 | (37.8050010513122, -122.410475804946) | |||
| 5043 | 5043 | 189151 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 351 Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017468.01148 | 2098526.96006 | 37.7431348775871 | -122.38222031223499 | (37.7431348775871, -122.382220312235) | |||
| 5054 | 5054 | 83037 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 5 | 6018575.81097 | 2097793.86484 | 37.74118306815279 | -122.378338911137 | (37.7411830681528, -122.378338911137) | |||
| 5431 | 5431 | 36639 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 5975 | 5975 | 19717 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY13 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 6160 | 6160 | 13487 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6013515.130369999 | 2116692.22603 | 37.792793538939904 | -122.397161898723 | (37.7927935389399, -122.397161898723) | |||
| 6198 | 6198 | 45895 | Permitted Site 1 | Tree(s) :: 17 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 6387 | 6387 | 19592 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 6514 | 6514 | 20450 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 6980 | 6980 | 98636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002249.0569400005 | 2120273.69699 | 37.8019937006086 | -122.436399401415 | (37.8019937006086, -122.436399401415) | ||
| 7352 | 7352 | 48471 | Permitted Site 1 | Tree(s) :: 17 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 7500 | 7500 | 1752 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 5 | 6010681.2119 | 2121680.6552 | 37.806332374912294 | -122.40731925401899 | (37.8063323749123, -122.407319254019) | |||
| 7785 | 7785 | 19757 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY15 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 8217 | 8217 | 109559 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006829.62004 | 2111990.07195 | 37.7795081268284 | -122.419960280951 | (37.7795081268284, -122.419960280951) | |||
| 8739 | 8739 | 20365 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 262X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 9451 | 9451 | 3858 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cashmere St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1996 12:00:00 AM | 6 | 3x3 | 6016272.1162427 | 2096165.2075516998 | 37.73658386065979 | -122.386190822782 | (37.7365838606598, -122.386190822782) | ||
| 9536 | 9536 | 19616 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 9621 | 9621 | 19831 | DPW Maintained 3 | Ilex spp :: Holly Species 163 | 100 STAIRWAY25 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60X | ||||||||
| 9679 | 9679 | 114122 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9902 | 9902 | 44560 | Permitted Site 1 | Tree(s) :: 17 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10291 | 10291 | 19793 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20ST | ||||||||
| 10580 | 10580 | 1280 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992520.10718 | 2087379.1823 | 37.71111633361279 | -122.467672210425 | (37.7111163336128, -122.467672210425) | |||
| 10946 | 10946 | 19995 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY46 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 11135 | 11135 | 173950 | DPW Maintained 3 | Syzygium australe :: Eugenia 178 | 236 Moncada Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | ||||
| 11812 | 11812 | 20044 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100 STAIRWAY51 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | ST | ||||||||
| 11894 | 11894 | 27208 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003655.1292 | 2093468.31467 | 37.7284723947828 | -122.429620860416 | (37.7284723947828, -122.429620860416) | ||
| 11942 | 11942 | 77664 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006642.942430001 | 2093520.0050400002 | 37.728783051183 | -122.419295481395 | (37.728783051183, -122.419295481395) | |
| 11996 | 11996 | 17591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 30 | 3x3 | 6003659.63671 | 2090407.2266799998 | 37.7200675818369 | -122.42938707716299 | (37.7200675818369, -122.429387077163) | |||
| 12210 | 12210 | 27073 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Silver Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/07/2012 12:00:00 AM | 3 | 4x14 | 6006831.62878 | 2093642.9283099999 | 37.7291311967449 | -122.418651892387 | (37.7291311967449, -122.418651892387) | ||
| 12225 | 12225 | 24277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 350X Winding Way | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000814.16949 | 2086790.4577099998 | 37.709975233345496 | -122.43896380743999 | (37.7099752333455, -122.43896380744) | |||
| 12373 | 12373 | 19737 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY14 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 12674 | 12674 | 20327 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 12874 | 12874 | 26296 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900X San Jose Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 3 | 3X3 | 5999765.91643 | 2092360.7952599998 | 37.72521041702 | -122.44298652263299 | (37.72521041702, -122.442986522633) | ||
| 13016 | 13016 | 35189 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 13115 | 13115 | 46288 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 13360 | 13360 | 44841 | Permitted Site 1 | Tree(s) :: 17 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 14049 | 14049 | 18560 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014546.06488 | 2095149.2171099999 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | |||
| 14116 | 14116 | 24108 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016610.88324 | 2095264.1891400001 | 37.7341285890533 | -122.384956794538 | (37.7341285890533, -122.384956794538) | |||
| 14126 | 14126 | 51109 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 14278 | 14278 | 6523 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017441.22819 | 2097205.1052900003 | 37.739503851329495 | -122.382220983128 | (37.7395038513295, -122.382220983128) | |||
| 14575 | 14575 | 35206 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14617 | 14617 | 11525 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018584.76615 | 2096814.86638 | 37.7384954262103 | -122.37824000008499 | (37.7384954262103, -122.378240000085) | |||
| 14716 | 14716 | 102958 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 303X 02nd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013733.67891 | 2113947.0451700003 | 37.7852680750133 | -122.396213220987 | (37.7852680750133, -122.396213220987) | |||
| 14867 | 14867 | 3710 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 12 | 3X3 | 6016627.8913900005 | 2099188.4950200003 | 37.7449048800496 | -122.385171335 | (37.7449048800496, -122.385171335) | ||
| 15036 | 15036 | 21873 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015642.92121 | 2106680.0028 | 37.765420437641 | -122.38910018611999 | (37.765420437641, -122.38910018612) | ||
| 15339 | 15339 | 48231 | Permitted Site 1 | Tree(s) :: 17 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 15877 | 15877 | 12135 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 6 | 3X3 | 6016406.76292 | 2095317.8529299998 | 37.7342646465796 | -122.385666248106 | (37.7342646465796, -122.385666248106) | ||
| 16221 | 16221 | 35459 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 16408 | 16408 | 78332 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52305 | 6014106.86245 | 2094390.7581099998 | 37.73159150443121 | -122.393552939125 | (37.7315915044312, -122.393552939125) |
| 16454 | 16454 | 20294 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 16593 | 16593 | 13617 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 555 Market St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6012680.03457 | 2115788.38553 | 37.7902652811559 | -122.399987885148 | (37.7902652811559, -122.399987885148) | |||
| 16849 | 16849 | 22416 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6013664.2375 | 2091773.8949 | 37.724381524856206 | -122.39489998248001 | (37.7243815248562, -122.39489998248) | ||||
| 17515 | 17515 | 29294 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997840.39461 | 2099954.53533 | 37.7459510371212 | -122.45018993482799 | (37.7459510371212, -122.450189934828) | ||
| 17703 | 17703 | 96 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002409.38596 | 2107682.72677 | 37.7674312030188 | -122.434943602286 | (37.7674312030188, -122.434943602286) | |||
| 18303 | 18303 | 122659 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 19341 | 19341 | 11783 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991294.00766 | 2091883.13578 | 37.7234122162896 | -122.472237972213 | (37.7234122162896, -122.472237972213) | ||
| 19475 | 19475 | 35527 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 20180 | 20180 | 11683 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991304.64081 | 2092852.6411099997 | 37.7260748525524 | -122.47227185508301 | (37.7260748525524, -122.472271855083) | ||
| 20548 | 20548 | 16117 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999494.77273 | 2094682.2963900003 | 37.7315692561142 | -122.444090570848 | (37.7315692561142, -122.444090570848) | |||
| 21553 | 21553 | 29606 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991168.88017 | 2091040.07708 | 37.721090143382796 | -122.472609073864 | (37.7210901433828, -122.472609073864) | ||
| 21870 | 21870 | 29326 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5993865.91856 | 2097870.0872 | 37.7399994209273 | -122.463781758534 | (37.7399994209273, -122.463781758534) | ||
| 21952 | 21952 | 5447 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004926.667780001 | 2104747.1594700003 | 37.7595134404185 | -122.42602766326401 | (37.7595134404185, -122.426027663264) | |||
| 22110 | 22110 | 29271 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998854.47778 | 2100210.30441 | 37.7467112969914 | -122.446701786562 | (37.7467112969914, -122.446701786562) | ||
| 22286 | 22286 | 188618 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 15 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015989.5781 | 2098825.23782 | 37.7438721192948 | -122.387353189223 | (37.7438721192948, -122.387353189223) | |||
| 22728 | 22728 | 26768 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006153.01253 | 2115563.9826599997 | 37.7892830640976 | -122.42255498601999 | (37.7892830640976, -122.42255498602) | |||
| 22833 | 22833 | 251113 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 23052 | 23052 | 14947 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6016779.8000300005 | 2097854.44087 | 37.741250241204604 | -122.384553152708 | (37.7412502412046, -122.384553152708) | |||
| 23612 | 23612 | 177049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998733.2334 | 2090880.1248400002 | 37.721085906663106 | -122.44644991615299 | (37.7210859066631, -122.446449916153) | |||
| 23615 | 23615 | 180300 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001840.8677900005 | 2092960.9802599999 | 37.7269764741671 | -122.43585655983 | (37.7269764741671, -122.43585655983) | |||
| 23647 | 23647 | 137617 | Undocumented 2 | Fraxinus americana :: American Ash 23 | 2000 TURK BLVD | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999974.0415 | 2112006.8982 | 37.779165706043 | -122.44367778095 | (37.779165706043, -122.44367778095) | |||
| 24209 | 24209 | 98762 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 3x3 | 6003216.22786 | 2121048.1502900003 | 37.8041750548072 | -122.433107900734 | (37.8041750548072, -122.433107900734) | |||
| 24241 | 24241 | 193574 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1101 Illinois St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016138.78787 | 2103882.6002 | 37.7577668436722 | -122.38718994068701 | (37.7577668436722, -122.387189940687) | |||
| 24790 | 24790 | 199437 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013340.81155 | 2107445.60575 | 37.7673947300992 | -122.397116397514 | (37.7673947300992, -122.397116397514) | |||
| 25051 | 25051 | 204106 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Junipero Serra Blvd | 15 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991380.91771 | 2094122.22642 | 37.7295652311304 | -122.47210067183399 | (37.7295652311304, -122.472100671834) | |||
| 25410 | 25410 | 46998 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 25485 | 25485 | 198641 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015975.52657 | 2108754.29642 | 37.7711344286414 | -122.388094538146 | (37.7711344286414, -122.388094538146) | ||||
| 25613 | 25613 | 240953 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1101 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004805.95854 | 2096424.9931 | 37.7366558692687 | -122.42585275411601 | (37.7366558692687, -122.425852754116) | ||||
| 26205 | 26205 | 195969 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015417.97335 | 2100326.09336 | 37.7479614832509 | -122.389434473133 | (37.7479614832509, -122.389434473133) | ||||
| 26944 | 26944 | 224225 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1100 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004862.254919999 | 2096710.90423 | 37.737444098063 | -122.42567845649201 | (37.737444098063, -122.425678456492) | ||||
| 27012 | 27012 | 186514 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980897.7615 | 2105153.3803 | 37.759241466452295 | -122.509160198369 | (37.7592414664523, -122.509160198369) | |||
| 27143 | 27143 | 197825 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1600 Bay Shore Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011965.06287 | 2091392.40975 | 37.7232394169387 | -122.40074704065701 | (37.7232394169387, -122.400747040657) | |||
| 28078 | 28078 | 129229 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2711 Vallejo St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6000617.83995 | 2117501.7173200003 | 37.794289755430796 | -122.44184510397 | (37.7942897554308, -122.44184510397) | |||
| 29150 | 29150 | 221508 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1201 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004291.813569999 | 2095940.5809 | 37.73529671397821 | -122.427595874056 | (37.7352967139782, -122.427595874056) |
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");