Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantType
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97454 | 97454 | 105000 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 280X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 65 | Tree tag no. 416 | 5993063.2 | 2100277.9 | 37.7465643757171 | -122.466732187112 | (37.7465643757171, -122.466732187112) | |||
| 10234 | 10234 | 122682 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/03/2017 12:00:00 AM | 3 | 6x10 | Permit Number 778226 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | |
| 13462 | 13462 | 15276 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1563X Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | Permit Number 777705 | 6007259.7778199995 | 2109715.95764 | 37.7732881790271 | -122.41831089463699 | (37.7732881790271, -122.418310894637) | ||
| 16543 | 16543 | 15277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1563X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.560819999 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | |
| 10388 | 10388 | 2288 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989397.47374 | 2088680.9253 | 37.714509804868605 | -122.47855980688699 | (37.7145098048686, -122.478559806887) | |
| 10549 | 10549 | 2290 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989540.89128 | 2088682.16282 | 37.714521528411495 | -122.478064194121 | (37.7145215284115, -122.478064194121) | |
| 10721 | 10721 | 2286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989102.32398 | 2088689.12288 | 37.714515172905294 | -122.4795805509 | (37.7145151729053, -122.4795805509) | |
| 11963 | 11963 | 2289 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989454.26944 | 2088678.0808599999 | 37.7145052920719 | -122.478363292437 | (37.7145052920719, -122.478363292437) | |
| 12203 | 12203 | 2287 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 800X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989126.18342 | 2088688.6181299998 | 37.7145151729252 | -122.47949804711 | (37.7145151729252, -122.47949804711) | |
| 114243 | 114243 | 115834 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 900X LAKE MERCED BLVD | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x100 | Permit Number 777492 | 5987646.0 | 2090104.0 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | |
| 92233 | 92233 | 111089 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 10x HIGUERA AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777485 | 5988057.0 | 2090190.0 | 37.7185754269376 | -122.483303520979 | (37.7185754269376, -122.483303520979) | |
| 19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
| 113986 | 113986 | 115182 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 315 Lakeshore Dr | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | Permit Number 775158 | 5983956.6 | 2095109.9 | 37.7318446842931 | -122.497839799214 | (37.7318446842931, -122.497839799214) | |||
| 91320 | 91320 | 107140 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 250X Roosevelt Way | Median : Cutout 11 | Tree 1 | Private 1 | 08/01/2014 12:00:00 AM | 5x5 | Permit Number 773751 | 6000794.71275 | 2107196.95489 | 37.766005582708395 | -122.440493678393 | (37.7660055827084, -122.440493678393) | |||
| 38336 | 38336 | 29373 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | Permit Number 772999 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |
| 125785 | 125785 | 29374 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | Permit Number 772999 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |
| 138844 | 138844 | 29372 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | Permit Number 772999 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |
| 86969 | 86969 | 99459 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 550X Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |
| 100862 | 100862 | 99476 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 10/28/2014 12:00:00 AM | 3 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
| 128765 | 128765 | 99475 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2014 12:00:00 AM | 44 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
| 118805 | 118805 | 2266 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X Brotherhood Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2014 12:00:00 AM | 22 | 14M | Permit Number 772491 | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |
| 86095 | 86095 | 103414 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 1490X Plymouth Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2013 12:00:00 AM | Permit Number 770026 | 5995919.3 | 2094026.5 | 37.7295639775589 | -122.456404198854 | (37.7295639775589, -122.456404198854) | |||
| 82803 | 82803 | 102580 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 90513 | 90513 | 102577 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 98816 | 98816 | 102575 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 102665 | 102665 | 102582 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 103293 | 103293 | 102578 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 120593 | 120593 | 102581 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 121576 | 121576 | 102579 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2013 12:00:00 AM | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | |||
| 145206 | 145206 | 102576 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Drumm St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | Permit Number 769964 | 6013786.1 | 2116863.1 | 37.7932777999137 | -122.396236306259 | (37.7932777999137, -122.396236306259) | ||||
| 1597 | 1597 | 4669 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/25/2014 12:00:00 AM | 8 | 3 | Permit Number 769286 | 6009537.0943 | 2119751.1708 | 37.8009703907309 | -122.411142309711 | (37.8009703907309, -122.411142309711) | |
| 6589 | 6589 | 4667 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 12 | 3 | Permit Number 769286 | 6009690.8519 | 2119608.7257 | 37.80058789320879 | -122.410600176031 | (37.8005878932088, -122.410600176031) | |
| 7649 | 7649 | 4666 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 600X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/03/2012 12:00:00 AM | 60 | 3 | Permit Number 769286 | 6009738.4106 | 2119565.7843 | 37.8004726529456 | -122.41043256902 | (37.8004726529456, -122.41043256902) | |
| 98538 | 98538 | 98820 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 28 | Median : Cutout 11 | Tree 1 | Private 1 | 05/09/2010 12:00:00 AM | Permit Number 768820 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | |||
| 139369 | 139369 | 97491 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 30 | 15x280 | Permit Number 768370 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |
| 116269 | 116269 | 96365 | Undocumented 2 | Tree(s) :: 17 | 2017 Grant Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767883 | 6010284.4 | 2121422.5 | 37.805601328212795 | -122.408674274121 | (37.8056013282128, -122.408674274121) | |
| 139081 | 139081 | 92211 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 99750 | 99750 | 92208 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 100266 | 100266 | 92210 | Permitted Site 1 | Pinus pinea :: Italian Stone Pine 143 | 300x Miramar Ave | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 112226 | 112226 | 92209 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 112766 | 112766 | 92207 | Permitted Site 1 | Pinus pinea :: Italian Stone Pine 143 | 300X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 128923 | 128923 | 92212 | Permitted Site 1 | Tree(s) :: 17 | 300x Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
| 127755 | 127755 | 83007 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 1058 De Haro St | 1 | Median : Cutout 11 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52381 | 6012170.46860809 | 2103464.70975517 | 37.7563988530014 | -122.40088475581499 | (37.7563988530014, -122.400884755815) | ||
| 72222 | 72222 | 87818 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 85 Mendosa Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | Permit Number 50680 | 5993356.0 | 2100787.0 | 37.747979128324 | -122.46575670711701 | (37.747979128324, -122.465756707117) | |||
| 125989 | 125989 | 87027 | Permitted Site 1 | Pinus muricata :: Bishop Pine 302 | 23 Magellan Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | Permit Number 49971 | 5994623.4 | 2101166.9 | 37.74909526366879 | -122.461401658799 | (37.7490952636688, -122.461401658799) | |||
| 84835 | 84835 | 86968 | Permitted Site 1 | Tree(s) :: 17 | 3250 Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.42523827370701 | (37.8055578865418, -122.425238273707) | |||
| 140517 | 140517 | 86969 | Permitted Site 1 | Tree(s) :: 17 | 3250 Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.42523827370701 | (37.8055578865418, -122.425238273707) | |||
| 14379 | 14379 | 48480 | Permitted Site 1 | Tree(s) :: 17 | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
| 9904 | 9904 | 61559 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1096 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/25/1984 12:00:00 AM | 16 | Permit Number 21519 | 6012461.11053783 | 2102868.78681941 | 37.75477878641421 | -122.399837764002 | (37.7547787864142, -122.399837764002) | ||
| 213 | 213 | 28640 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003714.7015 | 2113244.5448 | 37.782776612799296 | -122.430825656777 | (37.7827766127993, -122.430825656777) | ||
| 215 | 215 | 17196 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004629.787409999 | 2116932.39582 | 37.792954330542 | -122.42792271466601 | (37.792954330542, -122.427922714666) | |||
| 223 | 223 | 23789 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.43051925893299 | (37.7812424081927, -122.430519258933) | |||
| 248 | 248 | 23733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6003923.026000001 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | |||
| 497 | 497 | 14419 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | ||||
| 503 | 503 | 8533 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001504.6387 | 2113566.4305 | 37.783534963845 | -122.43849459602801 | (37.783534963845, -122.438494596028) | |||
| 605 | 605 | 23903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | |||
| 656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
| 724 | 724 | 25734 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.1858599996 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | ||
| 727 | 727 | 221435 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 1 | Width 3ft | 6005438.10251 | 2108158.21074 | 37.768908269319795 | -122.424501499347 | (37.7689082693198, -122.424501499347) | ||
| 733 | 733 | 221433 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:32:00 AM | 1 | Width 3ft | 6005435.4614 | 2108218.9893400003 | 37.7690750036386 | -122.42451495861201 | (37.7690750036386, -122.424514958612) | ||
| 737 | 737 | 221436 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 1 | Width 3ft | 6005440.21619 | 2108132.10005 | 37.768836694985396 | -122.424492330751 | (37.7688366949854, -122.424492330751) | ||
| 745 | 745 | 221429 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:39:00 AM | 1 | Width 3ft | 6005428.96653 | 2108339.30361 | 37.76940499098671 | -122.424545983407 | (37.7694049909867, -122.424545983407) | ||
| 754 | 754 | 221432 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 1 | Width 3ft | 6005434.00046 | 2108253.10785 | 37.769168602384205 | -122.42452243915301 | (37.7691686023842, -122.424522439153) | ||
| 759 | 759 | 221434 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:56:00 AM | 1 | Width 3ft | 6005437.11129 | 2108190.56795 | 37.7689970584876 | -122.42450722982001 | (37.7689970584876, -122.42450722982) | ||
| 766 | 766 | 221431 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 1 | Width 3ft | 6005433.2519 | 2108280.1340799998 | 37.769242767658 | -122.424526951068 | (37.769242767658, -122.424526951068) | ||
| 772 | 772 | 221430 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | ||
| 773 | 773 | 221437 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 1 | Width 3ft | 6005441.98545 | 2108105.3361400003 | 37.7687633076137 | -122.424484307027 | (37.7687633076137, -122.424484307027) | ||
| 787 | 787 | 221428 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 1 | Width 3ft | 6005427.7802 | 2108362.05998 | 37.769467407522896 | -122.424551705821 | (37.7694674075229, -122.424551705821) | ||
| 815 | 815 | 8534 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001381.7916 | 2113512.2830000003 | 37.78337929999999 | -122.43891571692801 | (37.7833793, -122.438915716928) | ||
| 828 | 828 | 8634 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999136.363 | 2113194.1665 | 37.7823778250539 | -122.44666108993299 | (37.7823778250539, -122.446661089933) | |||
| 890 | 890 | 23729 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003943.6522 | 2111620.2321 | 37.7783296231018 | -122.42991768322901 | (37.7783296231018, -122.429917683229) | ||
| 1116 | 1116 | 8576 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | |||
| 1149 | 1149 | 19194 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150 Sanchez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003510.8594 | 2107438.4604 | 37.7668229855288 | -122.43111632094801 | (37.7668229855288, -122.431116320948) | |||
| 1183 | 1183 | 119797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1185 | 1185 | 119832 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1187 | 1187 | 119794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1189 | 1189 | 119798 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1191 | 1191 | 119838 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1192 | 1192 | 119753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1194 | 1194 | 119795 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1196 | 1196 | 119750 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1199 | 1199 | 119799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1201 | 1201 | 119839 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1202 | 1202 | 119754 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1203 | 1203 | 119796 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1204 | 1204 | 119749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1206 | 1206 | 119801 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1208 | 1208 | 119803 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1209 | 1209 | 119800 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1211 | 1211 | 119836 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1213 | 1213 | 119747 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1219 | 1219 | 119829 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1222 | 1222 | 119837 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1223 | 1223 | 119752 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1226 | 1226 | 119830 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1228 | 1228 | 119831 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1230 | 1230 | 119834 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) |
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");