Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 669 | 669 | 251343 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 934 Brannan St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 1996 | 1996 | 252848 | Property Tree 7 | Pinus halepensis :: Allepo Pine 164 | 99 Reposa Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5998022.0 | 2098104.0 | 37.7408803073177 | -122.44942865965 | (37.7408803073177, -122.44942865965) | ||||
| 2595 | 2595 | 253142 | Property Tree 7 | Juniperus silicicola :: Southern red cedar 186 | 735 29th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5986898.0 | 2110914.0 | 37.7754104499772 | -122.48883220977301 | (37.7754104499772, -122.488832209773) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 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) | ||||
| 11978 | 11978 | 112948 | Property Tree 7 | Ligustrum japonicum :: Japanese Privet 4 | 400 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x15 | 6005670.66964 | 2093276.94718 | 37.7280608613968 | -122.42263943148599 | (37.7280608613968, -122.422639431486) | |||
| 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) | ||||
| 13321 | 13321 | 187670 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 230 Victoria St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5993274.0 | 2088748.0 | 37.7149182807441 | -122.465165952001 | (37.7149182807441, -122.465165952001) | ||||
| 18793 | 18793 | 114373 | Property Tree 7 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5988302.0 | 2089566.0 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | ||||
| 19656 | 19656 | 101900 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1100 Ocean Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 22300 | 22300 | 248974 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 716 Goettingen St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010713.0 | 2091306.0 | 37.7229322393396 | -122.405069122237 | (37.7229322393396, -122.405069122237) | ||||
| 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) | |||||
| 76017 | 76017 | 106971 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3479X San Bruno Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6011510.60551 | 2091910.0343099998 | 37.7246353494236 | -122.402354399294 | (37.7246353494236, -122.402354399294) | ||||
| 77987 | 77987 | 100070 | Property Tree 7 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 777990 | 5990400.0 | 2090718.0 | 37.7201612636948 | -122.47524333880699 | (37.7201612636948, -122.475243338807) | ||||
| 78509 | 78509 | 102745 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Moncada Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992354.0 | 2093377.4 | 37.727576385896604 | -122.468682482409 | (37.7275763858966, -122.468682482409) | |||||
| 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) | |||||
| 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) | |||
| 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) | ||||
| 81246 | 81246 | 109097 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774331 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) |
| 84088 | 84088 | 103516 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 980 Green St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6008298.0 | 2118971.0 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | |||||
| 87429 | 87429 | 108624 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 101 GENEBERN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005050.2 | 2095237.8 | 37.733409902631 | -122.42492386614401 | (37.733409902631, -122.424923866144) | |||||
| 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) | |||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 94698 | 94698 | 104538 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 1101 Van Ness Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006375.5 | 2114401.9 | 37.786104821458295 | -122.42170263122401 | (37.7861048214583, -122.421702631224) | |||||
| 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) |
| 95069 | 95069 | 115635 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 1 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 20 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 97530 | 97530 | 99275 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 98180 | 98180 | 120995 | Property Tree 7 | Private shrub :: Private Shrub 64 | 231 Delano Ave | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 3x3 | 6000066.0 | 2092260.0 | 37.72495076112679 | -122.44194193563999 | (37.7249507611268, -122.44194193564) | ||||
| 98218 | 98218 | 122480 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 596X Buckingham Way | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 5990152.0 | 2094375.0 | 37.7301880902761 | -122.476367577616 | (37.7301880902761, -122.476367577616) | ||||
| 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) | ||||
| 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) | ||||
| 100052 | 100052 | 97238 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) |
| 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) | ||||
| 101635 | 101635 | 121104 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 477 Myra Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997298.0 | 2097021.0 | 37.7378652095891 | -122.45185385938998 | (37.7378652095891, -122.45185385939) | ||||
| 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) |
| 103103 | 103103 | 91108 | Property Tree 7 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 104184 | 104184 | 104318 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 22 Beaver St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6002763.0 | 2106816.0 | 37.765071454107996 | -122.433658549479 | (37.765071454108, -122.433658549479) | ||||
| 104754 | 104754 | 102248 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
| 104891 | 104891 | 102101 | Property Tree 7 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.718492301183204 | -122.468164197766 | (37.7184923011832, -122.468164197766) |
| 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) | ||||
| 105590 | 105590 | 121144 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 400 Franconia St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 3x3 | 6010016.0 | 2098808.0 | 37.743492145498294 | -122.40800731166901 | (37.7434921454983, -122.408007311669) | |||
| 105598 | 105598 | 106227 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 38 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997884.0 | 2095808.5 | 37.7345695210024 | -122.44974042873999 | (37.7345695210024, -122.44974042874) | |||||
| 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) | ||||
| 107936 | 107936 | 118318 | Property Tree 7 | Maytenus boaria :: Mayten 22 | 20 Norton St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | 6002015.686319999 | 2092167.12899 | 37.724806667280895 | -122.435195459751 | (37.7248066672809, -122.435195459751) | |||||
| 108742 | 108742 | 110939 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 38 SAINT CHARLES AVE | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 30 | 3x3 | 5992046.0 | 2088201.0 | 37.7133454608488 | -122.46937060641001 | (37.7133454608488, -122.46937060641) | |||
| 109029 | 109029 | 108973 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 3485X SAN BRUNO AVE | 1 | Median : Yard 3 | Tree 1 | DPW for City Agency 10 | 6011510.0 | 2091910.0 | 37.724635221414 | -122.402356490066 | (37.724635221414, -122.402356490066) | |||||
| 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) | ||||
| 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) | |||||
| 110958 | 110958 | 108680 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 240 SANTA ANA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992606.9 | 2095181.7 | 37.73254515275271 | -122.46793939448999 | (37.7325451527527, -122.46793939449) | |||||
| 111345 | 111345 | 114949 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 1 | unknown : Yard 19 | Tree 1 | DPW 2 | 30 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | |||
| 111891 | 111891 | 105167 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 1 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 8 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 113071 | 113071 | 108574 | Property Tree 7 | Tree(s) :: 17 | 1891 15th St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7x8 | 6004884.86016 | 2107160.4412599998 | 37.7661373754728 | -122.426344078904 | (37.7661373754728, -122.426344078904) | ||||
| 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) | |||||
| 115179 | 115179 | 106275 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 42 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | |||||
| 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) | ||||
| 118325 | 118325 | 109374 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 118579 | 118579 | 108625 | Property Tree 7 | Persea americana :: Avocado 113 | 100 GENEBERN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004991.8 | 2095242.4 | 37.7334192343039 | -122.42512609869301 | (37.7334192343039, -122.425126098693) | ||||
| 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) | |||
| 120579 | 120579 | 114365 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2546 28th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | 5987735.7 | 2097954.4 | 37.739875761389605 | -122.48498344199601 | (37.7398757613896, -122.484983441996) | ||||
| 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) | |
| 124085 | 124085 | 116154 | Property Tree 7 | Pinus Spp :: Pine Spp 105 | 324 POPE ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6000502.0 | 2087202.0 | 37.711087470467795 | -122.440072212787 | (37.7110874704678, -122.440072212787) | ||||
| 124150 | 124150 | 121198 | Property Tree 7 | Cordyline australis :: Dracena Palm 141 | 2521 18th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | 5990743.0 | 2098231.0 | 37.740809941753 | -122.47460574514 | (37.740809941753, -122.47460574514) | |||
| 124987 | 124987 | 98548 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 132 Hamerton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001332.8 | 2095440.7 | 37.7337563407686 | -122.437790462907 | (37.7337563407686, -122.437790462907) | |||||
| 125761 | 125761 | 108576 | Property Tree 7 | :: 54 | 2479 Diamond St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6002240.0 | 2097369.0 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | |||||
| 126368 | 126368 | 105684 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 128175 | 128175 | 33776 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 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) | |||||
| 129259 | 129259 | 122558 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1760 Diamond St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 6001927.0 | 2098732.0 | 37.7428272563398 | -122.43597156823799 | (37.7428272563398, -122.435971568238) | |||
| 139657 | 139657 | 117644 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1111X SANSOME ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x30 | 6011937.0 | 2119613.0 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | ||||
| 140030 | 140030 | 103504 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 148 Huntington Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5984515.0 | 2095210.0 | 37.732152252278794 | -122.49591670504999 | (37.7321522522788, -122.49591670505) | |||||
| 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) | |||||
| 140943 | 140943 | 120977 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 794x Gates St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3030 | 3x3 | 6008103.0 | 2095407.0 | 37.7340464539486 | -122.414381414226 | (37.7340464539486, -122.414381414226) | |||
| 141354 | 141354 | 120533 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 22 | 3x3 | 6010745.0 | 2108673.0 | 37.7706200263658 | -122.40618148078501 | (37.7706200263658, -122.406181480785) | |||
| 144179 | 144179 | 102639 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 251 Dorado Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994312.1 | 2092840.7 | 37.726215661035106 | -122.461874461465 | (37.7262156610351, -122.461874461465) | |||||
| 145060 | 145060 | 102056 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 332 19th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5990007.7 | 2113121.3 | 37.781652074321705 | -122.47823656971501 | (37.7816520743217, -122.478236569715) | |||||
| 145393 | 145393 | 98880 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Lansdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5994747.9 | 2097283.1 | 37.738438484278895 | -122.460689725403 | (37.7384384842789, -122.460689725403) | ||||
| 146266 | 146266 | 109076 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 772744 | 6001554.7 | 2087011.6 | 37.7106245477128 | -122.43642021389401 | (37.7106245477128, -122.436420213894) | ||
| 154560 | 154560 | 110181 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 2620 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 1.5x4 | 5999902.8272 | 2114053.62 | 37.784781414472704 | -122.444071244627 | (37.7847814144727, -122.444071244627) |
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");