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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79469 | 79469 | 88223 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2442 Fulton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51219 | 5996404.0 | 2110432.0 | 37.7746371856421 | -122.455914062335 | (37.7746371856421, -122.455914062335) | |||
| 79533 | 79533 | 87262 | Permitted Site 1 | Brahea aramata :: Mexican Blue Palm 313 | 2360 Pacific Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2009 12:00:00 AM | 3x3 | Permit Number 52082 | 6002863.7 | 2117183.6 | 37.79354400237779 | -122.434051428216 | (37.7935440023778, -122.434051428216) | |||
| 79618 | 79618 | 86844 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 79735 | 79735 | 88396 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51375 | 5988132.3051849995 | 2111648.444046 | 37.777498983924204 | -122.484616395841 | (37.7774989839242, -122.484616395841) | |||
| 79787 | 79787 | 96460 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 79846 | 79846 | 117347 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1149 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | ||||||
| 79919 | 79919 | 94871 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1578 Innes Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53941 | 6015653.4 | 2097175.2 | 37.7393228299093 | -122.38840048148701 | (37.7393228299093, -122.388400481487) | ||
| 80037 | 80037 | 86731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Pico Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.724367252780496 | -122.462549157922 | (37.7243672527805, -122.462549157922) | |||||
| 80131 | 80131 | 107758 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 126 HIGHLAND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005605.1 | 2096623.0 | 37.7372446808015 | -122.42310384359101 | (37.7372446808015, -122.423103843591) | |||||
| 80163 | 80163 | 88235 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 329 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51224 | 6000219.0 | 2110006.0 | 37.773685716624705 | -122.44268666247 | (37.7736857166247, -122.44268666247) | |||
| 80300 | 80300 | 86765 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 80408 | 80408 | 86825 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1741 08th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2007 12:00:00 AM | 3x3 | Permit Number 49767 | 5993680.6 | 2103635.0 | 37.7558177255225 | -122.464841058216 | (37.7558177255225, -122.464841058216) | |||
| 80412 | 80412 | 99239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | ||||
| 80502 | 80502 | 108638 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 414 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.2163900002 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | |
| 80534 | 80534 | 96292 | Permitted Site 1 | Tree(s) :: 17 | 1294 Union St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 03/21/2011 12:00:00 AM | 6006773.0 | 2119090.0 | 37.7989995844362 | -122.420660308797 | (37.7989995844362, -122.420660308797) | |||||
| 80634 | 80634 | 89346 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51930 | 6000570.6 | 2102426.2 | 37.75289349552 | -122.440926561392 | (37.75289349552, -122.440926561392) | ||||
| 80715 | 80715 | 88184 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 489 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767583 | 6010914.9 | 2111745.1 | 37.7790648045054 | -122.40581022426599 | (37.7790648045054, -122.405810224266) | ||
| 80806 | 80806 | 86711 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 3714 Cesar Chavez St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | 6 | Permit Number 49697 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||
| 80926 | 80926 | 87297 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4227 Lincoln Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773956 | 5982573.0 | 2106897.6 | 37.764129220397294 | -122.50349567213001 | (37.7641292203973, -122.50349567213) | ||
| 80946 | 80946 | 88494 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51436 | 6011452.0 | 2093927.0 | 37.7301702475564 | -122.402698769845 | (37.7301702475564, -122.402698769845) | |||
| 81002 | 81002 | 86871 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2160 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49804 | 6002705.0 | 2118187.0 | 37.796290071465 | -122.43467232535102 | (37.796290071465, -122.434672325351) | ||||
| 81042 | 81042 | 112562 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 81200 | 81200 | 88338 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Paris St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541.0 | 2091742.0 | 37.723669175153205 | -122.43334915015801 | (37.7236691751532, -122.433349150158) | |||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 81435 | 81435 | 94362 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 507 11th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | 3x3 | Permit Number 53636 | 5992474.9 | 2111972.9 | 37.7786417900192 | -122.469617677573 | (37.7786417900192, -122.469617677573) | |||
| 81443 | 81443 | 100355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Waller St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.770656382716396 | -122.43333123962 | (37.7706563827164, -122.43333123962) | ||
| 81555 | 81555 | 108736 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1351 Minna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | 6006994.99302 | 2107616.27188 | 37.76750803134 | -122.419077863332 | (37.76750803134, -122.419077863332) | ||
| 81636 | 81636 | 87743 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 335 Wilde Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50406 | 6011180.9 | 2088940.4 | 37.7164629306199 | -122.403285348147 | (37.7164629306199, -122.403285348147) | |||
| 81641 | 81641 | 89366 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340 Benton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51946 | 6006673.6 | 2095420.1 | 37.7340020224619 | -122.419324232824 | (37.7340020224619, -122.419324232824) | |||
| 81789 | 81789 | 86872 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 2160 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2007 12:00:00 AM | 3x3 | Permit Number 49804 | 6002705.0 | 2118187.0 | 37.796290071465 | -122.43467232535102 | (37.796290071465, -122.434672325351) | |||
| 81908 | 81908 | 89201 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1627 McAllister St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51818 | 6001371.0 | 2111438.0 | 37.7776832317385 | -122.43880436100599 | (37.7776832317385, -122.438804361006) | |||
| 81963 | 81963 | 88252 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 1025 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131.0 | 2106547.0 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | |||
| 82045 | 82045 | 86740 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | |||||
| 82071 | 82071 | 92681 | Permitted Site 1 | Brahea aramata :: Mexican Blue Palm 313 | 2660 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2009 12:00:00 AM | Permit Number 52944 | 6008902.0 | 2102968.0 | 37.754852144595795 | -122.41215320319701 | (37.7548521445958, -122.412153203197) | ||||
| 82375 | 82375 | 88393 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.785370404226796 | -122.48281165726401 | (37.7853704042268, -122.482811657264) | |||
| 82435 | 82435 | 88162 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 365 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51185 | 6011732.3 | 2112447.5 | 37.7810391100489 | -122.40303190844999 | (37.7810391100489, -122.40303190845) | |||
| 82487 | 82487 | 104995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2220 Castro St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2013 12:00:00 AM | 3X3 | Permit Number 771144 | 6002644.3 | 2099031.5 | 37.7436903366208 | -122.433512747881 | (37.7436903366208, -122.433512747881) | |||
| 82526 | 82526 | 88406 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1716 Larkin St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51383 | 6007055.0 | 2117126.0 | 37.7936228211286 | -122.41954507638901 | (37.7936228211286, -122.419545076389) | |||
| 82574 | 82574 | 107467 | Permitted Site 1 | Prunus sargentii 'Columnaris' :: Sargent Cherry Tree 'Columnaris' 473 | 1643 35th Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773410 | 5985268.14341 | 2104019.02784 | 37.7563835411873 | -122.493961929435 | (37.7563835411873, -122.493961929435) | |||
| 82793 | 82793 | 95708 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 277 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767467 | 6004392.0 | 2091652.0 | 37.7235268927559 | -122.42694415274201 | (37.7235268927559, -122.426944152742) | ||
| 82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 82853 | 82853 | 88479 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1751 Newcomb Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51431 | 6014386.0 | 2096253.8 | 37.7367225430205 | -122.392718181551 | (37.7367225430205, -122.392718181551) | ||
| 82865 | 82865 | 93743 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53322 | 6011367.4 | 2112778.7 | 37.7819281242694 | -122.40431760427 | (37.7819281242694, -122.40431760427) | |||
| 82954 | 82954 | 88643 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2285 Jerrold Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51616 | 6011739.6 | 2099623.0 | 37.745826311758705 | -122.40210478451701 | (37.7458263117587, -122.402104784517) | |||
| 82966 | 82966 | 88341 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51327 | 6004823.0 | 2090807.0 | 37.721231068747294 | -122.425394157088 | (37.7212310687473, -122.425394157088) | |||
| 82980 | 82980 | 87788 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 114 Theresa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50526 | 6002199.1 | 2093679.9 | 37.7289708079503 | -122.43466954464199 | (37.7289708079503, -122.434669544642) | |||
| 83056 | 83056 | 108808 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 542 Moscow St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774650 | 6003656.47159 | 2090041.31767 | 37.7190626969286 | -122.42937193832199 | (37.7190626969286, -122.429371938322) | |
| 83315 | 83315 | 88823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51710 | 5998275.0 | 2110294.0 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | ||||
| 83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 83455 | 83455 | 89234 | Permitted Site 1 | Tree(s) :: 17 | 239 08th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2008 12:00:00 AM | 3x3 | Permit Number 51868 | 6009415.9 | 2110603.1 | 37.7758451977468 | -122.41091521392 | (37.7758451977468, -122.41091521392) | |||
| 83486 | 83486 | 108472 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 462 09th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | |||
| 83538 | 83538 | 92871 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 3600 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53088 | 5997031.0 | 2116025.0 | 37.790030052590105 | -122.454149203806 | (37.7900300525901, -122.454149203806) | ||||
| 83545 | 83545 | 107135 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 83608 | 83608 | 89008 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 707 Carolina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52629 | 6012436.0 | 2104662.0 | 37.7597011565358 | -122.40005052882499 | (37.7597011565358, -122.400050528825) | |||
| 83657 | 83657 | 107775 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | |||||
| 83723 | 83723 | 88533 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 55 Cervantes Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2008 12:00:00 AM | 3x3 | Permit Number 51490 | 6001717.8 | 2120796.9 | 37.8034000766729 | -122.438275302167 | (37.8034000766729, -122.438275302167) | |||
| 83761 | 83761 | 97253 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 364 Banks St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | Permit Number 768268 | 6008584.5 | 2096981.4 | 37.7383964511341 | -122.412827985209 | (37.7383964511341, -122.412827985209) | |||
| 83825 | 83825 | 96459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 84328 | 84328 | 94953 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 763 Brannan St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909.0 | 2109793.0 | 37.773760330517796 | -122.402233924084 | (37.7737603305178, -122.402233924084) | ||
| 84583 | 84583 | 107865 | Permitted Site 1 | Tree(s) :: 17 | 570 BEALE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015852.9 | 2114012.6 | 37.7855657638563 | -122.388885877785 | (37.7855657638563, -122.388885877785) | |||||
| 84731 | 84731 | 93487 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 643 San Jose Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | |||
| 84888 | 84888 | 88277 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Aptos Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062.0 | 2093861.6 | 37.7289467548913 | -122.46627011422899 | (37.7289467548913, -122.466270114229) | |||
| 84983 | 84983 | 96991 | Permitted Site 1 | Acer circinatum :: Vine Maple 379 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 85065 | 85065 | 86741 | Permitted Site 1 | Tree(s) :: 17 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2007 12:00:00 AM | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | ||||
| 85137 | 85137 | 88093 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1726 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51097 | 5984135.0 | 2103400.2 | 37.7546180463975 | -122.497834981734 | (37.7546180463975, -122.497834981734) | |||
| 85190 | 85190 | 94875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 44 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53944 | 6011618.0 | 2095077.0 | 37.7333371742049 | -122.40220570440799 | (37.7333371742049, -122.402205704408) | ||
| 85363 | 85363 | 86733 | Permitted Site 1 | Acacia spp :: Acacia Spp 176 | 345 Santiago St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49707 | 5991856.0 | 2099765.0 | 37.7450863408288 | -122.47086916045001 | (37.7450863408288, -122.47086916045) | |||||
| 85391 | 85391 | 108840 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 171 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774672 | 6004535.74354 | 2092399.5717799999 | 37.7255876870469 | -122.426500461978 | (37.7255876870469, -122.426500461978) | |
| 85422 | 85422 | 88095 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51099 | 5983752.7 | 2102993.7 | 37.7534794912156 | -122.49912702260201 | (37.7534794912156, -122.499127022602) | |||
| 85658 | 85658 | 96467 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 85704 | 85704 | 88536 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367021999 | (37.7511299031436, -122.40816367022) | |||
| 85738 | 85738 | 89356 | Permitted Site 1 | Tree(s) :: 17 | 3 Peralta Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2008 12:00:00 AM | 3x3 | Permit Number 51937 | 6010899.0 | 2100465.1 | 37.74809158087729 | -122.40507075934099 | (37.7480915808773, -122.405070759341) | |||
| 85883 | 85883 | 88089 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1870 38th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51092 | 5984476.8 | 2102440.2 | 37.752002183643704 | -122.49658212531601 | (37.7520021836437, -122.496582125316) | |||
| 85916 | 85916 | 88249 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 4758 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51235 | 5998426.0 | 2105687.0 | 37.7617244639768 | -122.448577782387 | (37.7617244639768, -122.448577782387) | |||
| 85966 | 85966 | 106373 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 189 College Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/23/2014 12:00:00 AM | 3X3 | Permit Number 771157 | 6004972.1 | 2095958.7 | 37.7353849208155 | -122.425245160296 | (37.7353849208155, -122.425245160296) | |||
| 85969 | 85969 | 86887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 56 Casa Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.43896362504499 | (37.8057359986938, -122.438963625045) | ||||
| 85981 | 85981 | 86840 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49780 | 6008706.2 | 2095448.4 | 37.734193996145 | -122.41229888228001 | (37.734193996145, -122.41229888228) | |||
| 86053 | 86053 | 88254 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 107 Belvedere St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51239 | 5998213.0 | 2108192.0 | 37.768590378969 | -122.449494963351 | (37.768590378969, -122.449494963351) | |||
| 86127 | 86127 | 92761 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 86139 | 86139 | 89139 | Permitted Site 1 | Tree(s) :: 17 | 3170 23rd St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/06/2008 12:00:00 AM | Permit Number 770875 | 6007866.1 | 2102749.5 | 37.7541940143569 | -122.41572017373001 | (37.7541940143569, -122.41572017373) | ||||
| 86334 | 86334 | 108517 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1474 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773664 | 5990869.49269 | 2105368.92693 | 37.7604161511877 | -122.474689222748 | (37.7604161511877, -122.474689222748) | |
| 86387 | 86387 | 87768 | Permitted Site 1 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 200 Beacon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50472 | 6003134.0 | 2097619.0 | 37.739839710176895 | -122.431718656253 | (37.7398397101769, -122.431718656253) | |||
| 86418 | 86418 | 96362 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1432 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2011 12:00:00 AM | Permit Number 767816 | 5989066.4 | 2105558.5 | 37.760832022681896 | -122.480939093689 | (37.7608320226819, -122.480939093689) | ||||
| 86552 | 86552 | 94514 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 476 27th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53699 | 6003420.0 | 2100114.0 | 37.746706610489 | -122.430907804941 | (37.746706610489, -122.430907804941) | ||||
| 86663 | 86663 | 88313 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 638 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51304 | 6003091.0 | 2089648.0 | 37.7179507025626 | -122.43129849323799 | (37.7179507025626, -122.431298493238) | |||
| 86666 | 86666 | 88224 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1821 Hayes St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51220 | 5999142.0 | 2110084.0 | 37.7738384306008 | -122.446417770519 | (37.7738384306008, -122.446417770519) | |||
| 86739 | 86739 | 86757 | Permitted Site 1 | Prunus spp :: Cherry 84 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 86784 | 86784 | 105038 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 46 Atalaya Ter | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2015 12:00:00 AM | 3 | 3X4 | Permit Number 771123 | 5998888.1 | 2110865.6 | 37.7759699989755 | -122.44735231528401 | (37.7759699989755, -122.447352315284) | ||
| 86823 | 86823 | 86773 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4259 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49745 | 6000836.0 | 2102862.0 | 37.754105209101894 | -122.44004000726002 | (37.7541052091019, -122.44004000726) | |||
| 86876 | 86876 | 88243 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2745 Turk Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51229 | 5997744.2 | 2111601.2 | 37.7779243335514 | -122.451362410862 | (37.7779243335514, -122.451362410862) | |||
| 86927 | 86927 | 108735 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1514 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774640 | 5989640.683680001 | 2105037.22287 | 37.759434101142 | -122.478914795236 | (37.759434101142, -122.478914795236) | |
| 87031 | 87031 | 86839 | Permitted Site 1 | Tree(s) :: 17 | 2238 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001026.6 | 2113503.7 | 37.7833355182269 | -122.440143921372 | (37.7833355182269, -122.440143921372) | |||||
| 87103 | 87103 | 94856 | Permitted Site 1 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 2595 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52715 | 5991705.5 | 2097813.3 | 37.739718766740395 | -122.47124738715901 | (37.7397187667404, -122.471247387159) | ||
| 87143 | 87143 | 94697 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53831 | 5987960.0 | 2113267.0 | 37.7819330460656 | -122.485331246452 | (37.7819330460656, -122.485331246452) | ||
| 87250 | 87250 | 93936 | Permitted Site 1 | Tree(s) :: 17 | 230 Seacliff Ave | Sidewalk: Curb side : 21 | Landscaping 2 | Private 1 | 04/26/2010 12:00:00 AM | 37x6 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | ||||
| 87301 | 87301 | 108891 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 434 Hearst Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773352 | 5998535.11764 | 2094404.2240000002 | 37.7307509423916 | -122.44738826472201 | (37.7307509423916, -122.447388264722) | |
| 87360 | 87360 | 88834 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 156 Collins St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51716 | 5998112.0 | 2113497.0 | 37.78315075925521 | -122.45022675387301 | (37.7831507592552, -122.450226753873) | |||
| 87384 | 87384 | 86799 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 71 Miguel St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 49752 | 6003860.0 | 2097292.0 | 37.738982969029706 | -122.429185143196 | (37.7389829690297, -122.429185143196) | ||
| 87434 | 87434 | 86698 | Permitted Site 1 | Azara microphylla :: Little-Leaf Azara 295 | 306 Mullen Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741002 | (37.7462578450491, -122.40611723741) | |||||
| 87455 | 87455 | 94559 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1652 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53733 | 5992517.8 | 2104198.3 | 37.7572972894341 | -122.468903351171 | (37.7572972894341, -122.468903351171) |
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");