Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 4747 | 4747 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 5x10 | |||||||||
| 7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7809 | 7809 | 119599 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 7834 | 7834 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x Avalon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 9148 | 9148 | 85030 | Significant Tree 6 | Tree(s) :: 17 | 411 Panama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49384 | ||||||||
| 22866 | 22866 | 251139 | Significant Tree 6 | Tree(s) :: 17 | 621X Gough St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | Permit Number 779685 | |||||||
| 99448 | 99448 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000586.0 | 2086414.0 | 37.70892857908329 | -122.439725431133 | (37.7089285790833, -122.439725431133) | ||||
| 106195 | 106195 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | |||
| 78769 | 78769 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 22897 | 22897 | 215094 | Significant Tree 6 | Tree(s) :: 17 | 218 Sadowa St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.2030900002 | 37.7123610457095 | -122.45974695827199 | (37.7123610457095, -122.459746958272) | |
| 107838 | 107838 | 104193 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 122 Arch St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992720.4 | 2088013.1 | 37.712868482575104 | -122.467026013031 | (37.7128684825751, -122.467026013031) | |||||
| 91767 | 91767 | 104749 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Junipero Serra Blvd Off Ramp | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719553998 | (37.7132507161795, -122.47185719554) | ||||
| 10019 | 10019 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 260 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | |
| 125954 | 125954 | 114239 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1300x JUNIPERO SERRA BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | ||||
| 93028 | 93028 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |
| 145474 | 145474 | 114257 | Significant Tree 6 | Leptospermum quinquenervia :: Tea Tree 151 | 50x CHUMASERO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |||||
| 11071 | 11071 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Raymond Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.879509999 | 2088473.9314700002 | 37.715017072864796 | -122.413438766187 | (37.7150170728648, -122.413438766187) | ||
| 88169 | 88169 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
| 10991 | 10991 | 116458 | Significant Tree 6 | Eucalyptus lehmanni :: Bushy Yate 267 | 777 Brotherhood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 10x20 | 5989819.39068 | 2088633.8654 | 37.7144050769972 | -122.477098071327 | (37.7144050769972, -122.477098071327) | |||
| 105245 | 105245 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 4673 | 4673 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 123839 | 123839 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 113606 | 113606 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | |
| 94747 | 94747 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5990818.0 | 2089012.0 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | |||
| 3843 | 3843 | 253568 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 301X Sargent St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5993018.0 | 2089140.0 | 37.7159798527116 | -122.46607925705901 | (37.7159798527116, -122.466079257059) | ||||
| 123361 | 123361 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5990450.0 | 2089482.0 | 37.7167704112637 | -122.47498033116501 | (37.7167704112637, -122.474980331165) | ||||
| 89097 | 89097 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 112205 | 112205 | 114404 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 500X ARBALLO DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | |||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 108075 | 108075 | 116951 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 24 | 299 Tara St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997754.0 | 2090179.6 | 37.7191064490611 | -122.44978436622101 | (37.7191064490611, -122.449784366221) | |||||
| 119334 | 119334 | 114073 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 18x HIGUERA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988029.0 | 2090212.0 | 37.718634203797706 | -122.483401916227 | (37.7186342037977, -122.483401916227) | ||||
| 108375 | 108375 | 111357 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 600x MANSELL ST | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 3x3 | 6010142.0 | 2090267.0 | 37.720047423695505 | -122.40696976451099 | (37.7200474236955, -122.406969764511) | |||
| 89406 | 89406 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 443X ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988110.0 | 2090275.0 | 37.718811899837206 | -122.483126550771 | (37.7188118998372, -122.483126550771) | ||||
| 9948 | 9948 | 114067 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 Higuera Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 84582 | 84582 | 114072 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 454 ARBALLO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 103750 | 103750 | 114102 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 7 ACEVEDO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 113595 | 113595 | 114068 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 8 HIGUERA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 88441 | 88441 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 239x VIDAL DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5987668.0 | 2090475.0 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | ||||
| 83253 | 83253 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878001 | (37.7199132334677, -122.45865940878) | |||||
| 94574 | 94574 | 114097 | Significant Tree 6 | Pinus thunbergii :: Japanese Black Pine 306 | 221x VIDAL DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5987664.0 | 2090556.0 | 37.7195574904968 | -122.484688777519 | (37.7195574904968, -122.484688777519) | ||||
| 96627 | 96627 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 317 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 99835 | 99835 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 608 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 102326 | 102326 | 104898 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 310 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 118620 | 118620 | 104908 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 500 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 140531 | 140531 | 104916 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 700 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 142126 | 142126 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 606 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 143237 | 143237 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 146 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 127835 | 127835 | 114387 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 417x ARBALLO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5988152.0 | 2090574.0 | 37.7196353223366 | -122.483003277928 | (37.7196353223366, -122.483003277928) | ||||
| 80921 | 80921 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 417 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 124358 | 124358 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 533 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 104018 | 104018 | 104932 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 717 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 104403 | 104403 | 114100 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 21x ACEVEDO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5988027.0 | 2090598.0 | 37.7196939458216 | -122.48343711113998 | (37.7196939458216, -122.48343711114) | ||||
| 142616 | 142616 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 755 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 72156 | 72156 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 835 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 99811 | 99811 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 837 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 114209 | 114209 | 104934 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 82402 | 82402 | 114388 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 361x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 99779 | 99779 | 114394 | Significant Tree 6 | Ficus Spp. :: 253 | 134x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 110346 | 110346 | 114383 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 418X SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 144120 | 144120 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 400x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5988116.0 | 2090625.0 | 37.7197732605649 | -122.48313145165001 | (37.7197732605649, -122.48313145165) | |||
| 125203 | 125203 | 114389 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 345x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5988176.0 | 2090635.0 | 37.7198042094326 | -122.48292478788 | (37.7198042094326, -122.48292478788) | ||||
| 90926 | 90926 | 114099 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 201x VIDAL DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5987665.0 | 2090646.0 | 37.719804665893605 | -122.484691919383 | (37.7198046658936, -122.484691919383) | ||||
| 98711 | 98711 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | |||||
| 115524 | 115524 | 117309 | Significant Tree 6 | Tree(s) :: 17 | 3711 19th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 777997 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | |
| 93217 | 93217 | 114390 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 144388 | 144388 | 114393 | Significant Tree 6 | Ficus Spp. :: 253 | 118x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988638.0 | 2090878.0 | 37.72049829773871 | -122.48134562114099 | (37.7204982977387, -122.481345621141) | ||||
| 84041 | 84041 | 114392 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 104x TAPIA DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10 | 5988688.0 | 2090939.0 | 37.72066869526729 | -122.481177253578 | (37.7206686952673, -122.481177253578) | ||||
| 53190 | 53190 | 94850 | Significant Tree 6 | Tree(s) :: 17 | 1107 Bowdoin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | Permit Number 53929 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | |||
| 111731 | 111731 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990586.0 | 2091171.0 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | ||||
| 89464 | 89464 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1201 Holloway Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992431.5 | 2091178.1 | 37.721542125529396 | -122.46825464021099 | (37.7215421255294, -122.468254640211) | |||||
| 88445 | 88445 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592.0 | 2091224.0 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) | |
| 88391 | 88391 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 3803 | 3803 | 178335 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 33 | Width 8ft | 5998656.04486 | 2091523.1214700001 | 37.72284701755029 | -122.44676297552601 | (37.7228470175503, -122.446762975526) | |||
| 107866 | 107866 | 112769 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 103031 | 103031 | 120596 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 499x Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
| 122520 | 122520 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 84808 | 84808 | 100529 | Significant Tree 6 | Tree(s) :: 17 | 720 Victoria St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/24/2012 12:00:00 AM | Permit Number 769203 | 5993611.6 | 2091925.6 | 37.723662667106 | -122.464229627127 | (37.723662667106, -122.464229627127) | |||
| 84949 | 84949 | 86910 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49875 | 5993901.0 | 2092133.0 | 37.7242488135215 | -122.463244271267 | (37.7242488135215, -122.463244271267) | |||
| 98850 | 98850 | 108305 | Significant Tree 6 | Tree(s) :: 17 | 360 GAMBIER ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | Permit Number 774454 | 6006059.9 | 2092154.5 | 37.725000818070995 | -122.42121417648599 | (37.725000818071, -122.421214176486) | ||
| 171221 | 171221 | 112905 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Keith St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6014331.87009 | 2092225.76664 | 37.725659374776605 | -122.39262364628901 | (37.7256593747766, -122.392623646289) | ||||
| 128360 | 128360 | 106364 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 155 BORICA ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992696.0 | 2092292.5 | 37.724617268406604 | -122.467421338179 | (37.7246172684066, -122.467421338179) | |||||
| 108351 | 108351 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 URBANO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | ||||
| 81076 | 81076 | 88608 | Significant Tree 6 | Tree(s) :: 17 | 350 Urbano Dr | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | Permit Number 51562 | 5991996.0 | 2092560.0 | 37.72531132011171 | -122.46986059313801 | (37.7253113201117, -122.469860593138) | |||
| 4923 | 4923 | 253718 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 227 Madison St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005690.0 | 2092595.0 | 37.726189474375204 | -122.422524168298 | (37.7261894743752, -122.422524168298) | ||||
| 101621 | 101621 | 104406 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 290 Stonecrest Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Permit Number 770927 | 5990725.0 | 2092655.0 | 37.7254986161427 | -122.474261202586 | (37.7254986161427, -122.474261202586) | |||
| 144561 | 144561 | 118359 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 8 Keystone Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 5994105.0 | 2092664.0 | 37.72571856099329 | -122.46257757783 | (37.7257185609933, -122.46257757783) | |||
| 126830 | 126830 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 431 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995635.0 | 2092781.0 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | |||||
| 3283 | 3283 | 253384 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 55 Cerritos Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5992588.0 | 2092941.0 | 37.7263916542788 | -122.46784182223999 | (37.7263916542788, -122.46784182224) | ||||
| 114083 | 114083 | 100431 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 95855 | 95855 | 112250 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 243 WINSTON DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990059.0 | 2093141.0 | 37.726794444209396 | -122.47659897114599 | (37.7267944442094, -122.476598971146) | ||||
| 129429 | 129429 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 38 | 155 Winston Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990788.0 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | |||||
| 89763 | 89763 | 87191 | Significant Tree 6 | Tree(s) :: 17 | 640 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | Permit Number 50212 | 5995439.0 | 2093622.0 | 37.7284257331327 | -122.458035371987 | (37.7284257331327, -122.458035371987) | |||
| 142099 | 142099 | 102583 | Significant Tree 6 | Tree(s) :: 17 | 22 Gennessee St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/27/2013 12:00:00 AM | Permit Number 769949 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | |||
| 142197 | 142197 | 112354 | Significant Tree 6 | Tree(s) :: 17 | 300 Moncada Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 10x10 | Permit Number 775546 | 5992209.2 | 2093928.1 | 37.729080105492 | -122.469223117768 | (37.729080105492, -122.469223117768) | ||
| 67557 | 67557 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 690 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 143568 | 143568 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||||
| 3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) |
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");