Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97160 | 97160 | 115639 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 5 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 6 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 99755 | 99755 | 115644 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 10 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 102527 | 102527 | 115648 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 14 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 102675 | 102675 | 115649 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 15 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 108009 | 108009 | 115652 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 18 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 111875 | 111875 | 115636 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 2 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 16 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 113407 | 113407 | 115650 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 16 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 118558 | 118558 | 115640 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 6 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 122253 | 122253 | 115643 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 9 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 124724 | 124724 | 115642 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 8 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 125004 | 125004 | 115653 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 19 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 127152 | 127152 | 115647 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 13 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 139401 | 139401 | 115654 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 20 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 139921 | 139921 | 115637 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 3 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 14 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 142076 | 142076 | 115655 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 21 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 144101 | 144101 | 115651 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 17 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 87654 | 87654 | 99961 | Property Tree 7 | Callistemon citrinus :: Lemon Bottlebrush 28 | 537 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459.0 | 2099152.0 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | |||
| 90103 | 90103 | 100046 | Property Tree 7 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262.0 | 2099459.0 | 37.7448424535299 | -122.43486521318898 | (37.7448424535299, -122.434865213189) | |||
| 108286 | 108286 | 100045 | Property Tree 7 | Acacia decurrens :: Acacia: Silver Wattle 181 | 556 28th St | Front Yard : Yard 7 | Tree 1 | Private 1 | Not sure which property tree is located on. | 6002301.0 | 2099461.0 | 37.7448501592716 | -122.434730501666 | (37.7448501592716, -122.434730501666) | |||||
| 102061 | 102061 | 109092 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) |
| 22826 | 22826 | 251117 | Property Tree 7 | Sequoiadendron giganteum :: Sierra Redwood 212 | 2024 Castro St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002622.0 | 2099601.0 | 37.7452527853239 | -122.43363054854099 | (37.7452527853239, -122.433630548541) | |||||
| 122755 | 122755 | 102079 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 76 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769729 | 6008162.3 | 2099676.4 | 37.7457726186307 | -122.414478397936 | (37.7457726186307, -122.414478397936) | |
| 90230 | 90230 | 98140 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 315 San Marcos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992920.8 | 2100212.1 | 37.746375486546704 | -122.467219803339 | (37.7463754865467, -122.467219803339) | ||||||
| 92228 | 92228 | 122453 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 217 San Marcos Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993325.07095 | 2100296.14299 | 37.7466295758311 | -122.465827998209 | (37.7466295758311, -122.465827998209) | ||||
| 145716 | 145716 | 98878 | Property Tree 7 | Tree(s) :: 17 | 11 Panorama Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998029.0 | 2100213.0 | 37.7466715093679 | -122.449556386849 | (37.7466715093679, -122.449556386849) | ||||||
| 124250 | 124250 | 99374 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 21 Panorama Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 5998009.0 | 2100230.0 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | |||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 103600 | 103600 | 98436 | Property Tree 7 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999035.0 | 2100736.0 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | ||||||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 115357 | 115357 | 98501 | Property Tree 7 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998998.0 | 2100740.0 | 37.748173910048706 | -122.446243600021 | (37.7481739100487, -122.446243600021) | ||||||
| 1273 | 1273 | 251481 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 32 Peralta Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 3x3 | 6010779.0 | 2100499.0 | 37.7481779538542 | -122.40548810426901 | (37.7481779538542, -122.405488104269) | ||||
| 99802 | 99802 | 98890 | Property Tree 7 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999134.0 | 2100748.0 | 37.748203642185395 | -122.44577389345 | (37.7482036421854, -122.44577389345) | ||||||
| 98291 | 98291 | 98892 | Property Tree 7 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998935.0 | 2100753.0 | 37.7482060067302 | -122.44646238623999 | (37.7482060067302, -122.44646238624) | ||||||
| 94734 | 94734 | 98893 | Property Tree 7 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2100761.0 | 37.7482265448319 | -122.44654941060699 | (37.7482265448319, -122.446549410607) | ||||||
| 128066 | 128066 | 98503 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 208 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998871.0 | 2100779.0 | 37.74827374071911 | -122.44668556582701 | (37.7482737407191, -122.446685565827) | ||||||
| 99953 | 99953 | 117254 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2067 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5985987.0 | 2101171.0 | 37.7486056682842 | -122.49126630479601 | (37.7486056682842, -122.491266304796) | ||||
| 102307 | 102307 | 99256 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1466 York St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010099.0 | 2100741.0 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | ||||||
| 97037 | 97037 | 97024 | Property Tree 7 | Jacaranda mimosifolia :: Jacaranda 52 | 1455 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768189 | 6009349.0 | 2100759.5 | 37.748813167460106 | -122.410451409671 | (37.7488131674601, -122.410451409671) | ||||
| 99642 | 99642 | 113379 | Property Tree 7 | Fagus sylvatica :: European Beech 250 | 140 CASTENADA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 5994437.0 | 2101097.0 | 37.7488926059174 | -122.462041158848 | (37.7488926059174, -122.462041158848) | ||||
| 107998 | 107998 | 97023 | Property Tree 7 | Jacaranda mimosifolia :: Jacaranda 52 | 1443 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768190 | 6009347.4 | 2100788.9 | 37.748893803646105 | -122.410459018192 | (37.7488938036461, -122.410459018192) | ||||
| 92371 | 92371 | 118371 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999981.0 | 2101110.0 | 37.7492459313263 | -122.44287099416799 | (37.7492459313263, -122.442870994168) | ||||
| 88993 | 88993 | 121199 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 72 Fountain St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000322.0 | 2101283.0 | 37.7497403826665 | -122.441704227556 | (37.7497403826665, -122.441704227556) | |||||
| 3132 | 3132 | 253339 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | PUC 13 | 3x3 | 5988853.0 | 2101569.0 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | ||||
| 81073 | 81073 | 101977 | Property Tree 7 | Cedrus deodara :: Deodar Cedar 129 | 601 Grand View Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000076.2 | 2101609.9 | 37.750623962991796 | -122.44257767940901 | (37.7506239629918, -122.442577679409) | ||||||
| 901 | 901 | 224716 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 13 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 903 | 903 | 225889 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 7 | Back Yard : Cutout 16 | Tree 1 | MTA 6 | 18 | Width 8ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 905 | 905 | 224715 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 12 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 909 | 909 | 234895 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3255x 24th St | 6 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 40 | Width 10ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 914 | 914 | 225888 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 32 | 6x6 | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 916 | 916 | 224714 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 11 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 928 | 928 | 224422 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 16 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 125346 | 125346 | 100148 | Property Tree 7 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004141.0 | 2102142.0 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | ||||||
| 13296 | 13296 | 187658 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600X Clarendon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5995637.0 | 2102382.0 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | ||||
| 95068 | 95068 | 109091 | Property Tree 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876002 | (37.7525900037408, -122.43731782876) |
| 79534 | 79534 | 121404 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1900 08th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 10x10 | 5993817.0 | 2102486.0 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | |||
| 9474 | 9474 | 173600 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Clarendon Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996184.0 | 2102497.0 | 37.7528370823128 | -122.45610127186899 | (37.7528370823128, -122.456101271869) | ||||
| 116003 | 116003 | 114410 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 10 GARDENSIDE DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999306.0 | 2102458.0 | 37.752908704913395 | -122.445302055175 | (37.7529087049134, -122.445302055175) | ||||||
| 118024 | 118024 | 94228 | Property Tree 7 | Acer palmatum :: Japanese Maple 175 | 1097 Church St | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | Permit Number 53567 | 6004455.0 | 2102510.0 | 37.753344058808395 | -122.427499544702 | (37.7533440588084, -122.427499544702) | ||||
| 129485 | 129485 | 97033 | Property Tree 7 | Afrocarpus gracilior :: Fern Pine 70 | 61 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | Possible significant tree; Nellie RoW; rear yard | 6004120.0 | 2102703.0 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | |||||
| 105687 | 105687 | 122518 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 772X Panorama Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996713.0 | 2102901.0 | 37.753976715350106 | -122.45430108189 | (37.7539767153501, -122.45430108189) | ||||
| 100275 | 100275 | 96676 | Property Tree 7 | Prunus spp :: Cherry 84 | 1701 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | ||||
| 2764 | 2764 | 253207 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 89 Woodhaven Ct | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996069.0 | 2103645.0 | 37.75598259914371 | -122.45658197288401 | (37.7559825991437, -122.456581972884) | ||||
| 117738 | 117738 | 104008 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 357 Collingwood St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 6002124.0 | 2103789.0 | 37.7567237682266 | -122.435652112093 | (37.7567237682266, -122.435652112093) | ||||
| 109233 | 109233 | 104397 | Property Tree 7 | Pseudotsuga menziesii :: Douglas Fir 231 | 350 Collingwood St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002086.0 | 2103822.0 | 37.756812219827296 | -122.43578589078301 | (37.7568122198273, -122.435785890783) | |||||
| 4447 | 4447 | 253626 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1671 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5992125.0 | 2104081.0 | 37.756952512450205 | -122.47025325330601 | (37.7569525124502, -122.470253253306) | ||||
| 78510 | 78510 | 114817 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 100 RACCOON DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5998725.0 | 2104028.0 | 37.757186355085004 | -122.447424250084 | (37.757186355085, -122.447424250084) | |||||
| 88934 | 88934 | 107130 | Property Tree 7 | Phoenix dactylifera :: Date Palm 65 | 751 DOLORES ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005081.8 | 2103948.4 | 37.7573290011944 | -122.42543429450701 | (37.7573290011944, -122.425434294507) | |||||
| 79404 | 79404 | 97051 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 80849 | 80849 | 97052 | Property Tree 7 | Pyrus spp :: Pear Tree 291 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 5096 | 5096 | 253768 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
| 119332 | 119332 | 120526 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1439 47th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 5981489.0 | 2105275.0 | 37.759610238830206 | -122.50712446853998 | (37.7596102388302, -122.50712446854) | |||
| 82732 | 82732 | 102470 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1021 Kirkham St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5991773.0 | 2105198.0 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | |||||
| 113649 | 113649 | 102469 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1021 Kirkham St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5991773.0 | 2105198.0 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | |||||
| 129004 | 129004 | 108871 | Property Tree 7 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005305.0 | 2104962.0 | 37.760124716943295 | -122.424734485609 | (37.7601247169433, -122.424734485609) | |||||
| 112498 | 112498 | 106458 | Property Tree 7 | Tree(s) :: 17 | 71 HANCOCK ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003861.6 | 2105050.0 | 37.7602847161222 | -122.429732794413 | (37.7602847161222, -122.429732794413) | ||||||
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 86057 | 86057 | 94469 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 103566 | 103566 | 94487 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 126549 | 126549 | 94468 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 120804 | 120804 | 96938 | Property Tree 7 | Tree(s) :: 17 | 1306 Cole St | Back Yard : Yard 13 | Tree 1 | Private 1 | Backyard tree on private property | 5998246.0 | 2105961.0 | 37.7624665052811 | -122.449220068104 | (37.7624665052811, -122.449220068104) | |||||
| 1928 | 1928 | 252837 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1929 | 1929 | 252833 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1945 | 1945 | 252839 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 99 Pond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1948 | 1948 | 252834 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1955 | 1955 | 252835 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 140844 | 140844 | 102706 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1342 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | |||||
| 105403 | 105403 | 105236 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 235X STATES ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | ||||
| 116035 | 116035 | 105232 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 460X ROOSEVELT WAY | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5999944.0 | 2106286.0 | 37.7634558498539 | -122.443370673769 | (37.7634558498539, -122.443370673769) | ||||
| 78101 | 78101 | 96597 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 110024 | 110024 | 96606 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 111128 | 111128 | 96599 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 113186 | 113186 | 96604 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 113756 | 113756 | 96600 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 123910 | 123910 | 96598 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | tree 3 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 126860 | 126860 | 96602 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 128034 | 128034 | 96601 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 142264 | 142264 | 96605 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 144514 | 144514 | 96603 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 79751 | 79751 | 105231 | Property Tree 7 | Pinus Spp :: Pine Spp 105 | 460X ROOSEVELT WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6000051.0 | 2106345.0 | 37.7636239504047 | -122.44300483360901 | (37.7636239504047, -122.443004833609) | ||||
| 109200 | 109200 | 101625 | Property Tree 7 | Fagus sylvatica :: European Beech 250 | 64 Levant St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769362 | 6000275.9 | 2106473.5 | 37.76398959970761 | -122.442236202383 | (37.7639895997076, -122.442236202383) |
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");