Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 27599 | 27599 | 232417 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 173 Everson St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6002718.41885 | 2097663.27226 | 37.7399377058635 | -122.433158722322 | (37.7399377058635, -122.433158722322) | ||||
| 29851 | 29851 | 210532 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 5992170.38695 | 2088246.7586700001 | 37.7134782905637 | -122.46894401367099 | (37.7134782905637, -122.468944013671) | ||||
| 38627 | 38627 | 210531 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992169.14182 | 2088256.46113 | 37.7135048592377 | -122.46894902289 | (37.7135048592377, -122.46894902289) | ||||
| 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) | ||||
| 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) | ||||
| 1384 | 1384 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 1409 | 1409 | 251514 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 1598 | 1598 | 251612 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 60R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999394.0 | 2100048.0 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | |||||
| 1603 | 1603 | 251636 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 22R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999148.0 | 2100052.0 | 37.74629339412971 | -122.44567543770901 | (37.7462933941297, -122.445675437709) | |||||
| 1615 | 1615 | 251604 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 48R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999482.0 | 2100041.0 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | |||||
| 1616 | 1616 | 251607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 52R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1648 | 1648 | 251606 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 52R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1772 | 1772 | 173895 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 326x Dellbrook Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 3x3 | 5997295.0 | 2102064.0 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | |||
| 2502 | 2502 | 253119 | Private 5 | Pinus radiata :: Monterey Pine 3 | 185 Belgrave Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 780239 | 5997636.85301 | 2104869.74588 | 37.759435335978296 | -122.45124816933 | (37.7594353359783, -122.45124816933) | ||||
| 8592 | 8592 | 121500 | Private 5 | Pinus radiata :: Monterey Pine 3 | 251X Pennsylvania Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | ||||||||||
| 10146 | 10146 | 173882 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 201x Howth St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997459.0 | 2090748.0 | 37.7206502603184 | -122.450845024895 | (37.7206502603184, -122.450845024895) | |||||
| 10199 | 10199 | 173896 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 326x Dellbrook Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997295.0 | 2102064.0 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | ||||
| 10223 | 10223 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 240 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 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) | ||||
| 76843 | 76843 | 249887 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 230 Greenwich St | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011491.952269999 | 2120439.55706 | 37.802969965942104 | -122.40442611408399 | (37.8029699659421, -122.404426114084) | |||
| 79011 | 79011 | 108637 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 15 TUCKER AVE | Back Yard : Yard 13 | Tree 1 | Private 1 | 6011049.2 | 2088423.2 | 37.715035447895396 | -122.403704200211 | (37.7150354478954, -122.403704200211) | ||||||
| 79705 | 79705 | 108816 | Private 5 | Pinus radiata :: Monterey Pine 3 | 348 Gold Mine Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001084.0 | 2097744.0 | 37.740066514789 | -122.43881563429301 | (37.740066514789, -122.438815634293) | ||||
| 79839 | 79839 | 69895 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 51x PRENTISS ST | 2 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 03/29/2003 12:00:00 AM | 12 | 6008906.8 | 2098323.8 | 37.742100473688396 | -122.41180845469201 | (37.7421004736884, -122.411808454692) | |||
| 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) | |||||
| 82794 | 82794 | 110929 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 445 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002243.0 | 2098437.0 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | |||||
| 85387 | 85387 | 107149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 612 WISCONSIN ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6012651.9 | 2104553.6 | 37.7594155491308 | -122.39929622330901 | (37.7594155491308, -122.399296223309) | |||||
| 88847 | 88847 | 103457 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Bosworth St | 3 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 26 | Located on DPW property next to 84 Lippard Ave | 6001796.5 | 2095573.7 | 37.7341478843848 | -122.436196831648 | (37.7341478843848, -122.436196831648) | |||
| 88950 | 88950 | 86946 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 495 Pacheco St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11/20/2007 12:00:00 AM | 3x3 | Permit Number 51051 | 5993544.7 | 2101797.8 | 37.750765410178 | -122.465177603148 | (37.750765410178, -122.465177603148) | ||
| 90297 | 90297 | 107819 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 75X RALSTON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 45 | Permit Number 775492 | 5992193.0 | 2088303.0 | 37.7136340221674 | -122.46886994586599 | (37.7136340221674, -122.468869945866) | ||||
| 91893 | 91893 | 107542 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 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) | ||||
| 93109 | 93109 | 107611 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 470x Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 774041 | 6011286.02608 | 2118707.45024 | 37.7982025127238 | -122.40501669828998 | (37.7982025127238, -122.40501669829) | ||||
| 96669 | 96669 | 112123 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 771 WALLER ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 3x3 | 6002060.0 | 2108730.0 | 37.770286913106204 | -122.43622703445601 | (37.7702869131062, -122.436227034456) | ||||
| 97281 | 97281 | 107619 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 51X Prentiss St | 3 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 12 | 6008906.75623 | 2098323.8391 | 37.7421005785929 | -122.41180860879801 | (37.7421005785929, -122.411808608798) | ||||
| 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) | ||||
| 101345 | 101345 | 104689 | Private 5 | Pinus radiata :: Monterey Pine 3 | 657 PALMETTO AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 5991786.0 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | ||||
| 101483 | 101483 | 113482 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2839 Pierce St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001345.0 | 2118077.0 | 37.7959107386074 | -122.43937030854799 | (37.7959107386074, -122.439370308548) | ||||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 107492 | 107492 | 98715 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 26 Vernon St | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992459.0 | 2088068.0 | 37.713004133171 | -122.46793347935301 | (37.713004133171, -122.467933479353) | ||||||
| 110289 | 110289 | 103566 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 51X Prentiss St | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 12 | DPW property; below Bernal Heights Blvd near this address | 6008906.8 | 2098323.8 | 37.742100473688396 | -122.41180845469201 | (37.7421004736884, -122.411808454692) | |||
| 111683 | 111683 | 114761 | Private 5 | Pinus radiata :: Monterey Pine 3 | 2155 10TH AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993160.0 | 2101036.0 | 37.7486515109126 | -122.466452556212 | (37.7486515109126, -122.466452556212) | ||||
| 112733 | 112733 | 107503 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4140 19th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992157.71887 | 2088336.37745 | 37.7137236301705 | -122.46899431666 | (37.7137236301705, -122.46899431666) | ||||||
| 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) | |||||
| 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) | ||||
| 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) | |||
| 119700 | 119700 | 100472 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 70 Stanford Heights Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997872.4 | 2096006.9 | 37.735113616296 | -122.44979482672899 | (37.735113616296, -122.449794826729) | ||||||
| 119975 | 119975 | 112668 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 129 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002668.0 | 2107340.8 | 37.766507036069605 | -122.434024647923 | (37.7665070360696, -122.434024647923) | ||||||
| 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) | ||||
| 122510 | 122510 | 116619 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 120x KNOLLVIEW WAY | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 3x3 | 5997764.0 | 2102030.0 | 37.7516453806516 | -122.45060370088001 | (37.7516453806516, -122.45060370088) | |||
| 122667 | 122667 | 100169 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 180X Manchester St | Back Yard : Yard 13 | Tree 1 | DPW 2 | Adjacent to rear of property - DPW parcel | 6008242.0 | 2099158.0 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | |||||
| 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) | |||||
| 124990 | 124990 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 125219 | 125219 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 7X CASTRO ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002014.1 | 2108690.0 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | ||||
| 126828 | 126828 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5999865.0 | 2112093.0 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | ||||
| 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) | |||
| 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) | |||||
| 141038 | 141038 | 102381 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 258 Molimo Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997615.0 | 2096604.0 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | ||||||
| 141303 | 141303 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 700X Panorama Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | |||||
| 141746 | 141746 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 520X Oak Park Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.756074592877496 | -122.46025354267599 | (37.7560745928775, -122.460253542676) | |||
| 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) | |||||
| 144713 | 144713 | 103084 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 30X Zircon Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002309.6 | 2098789.5 | 37.7430068656447 | -122.43465275743601 | (37.7430068656447, -122.434652757436) | |||||
| 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) | |||||
| 146046 | 146046 | 117273 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 17 PEREGO TER | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999542.0 | 2101494.0 | 37.7502752643571 | -122.444416651791 | (37.7502752643571, -122.444416651791) | |||||
| 147254 | 147254 | 211258 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 426 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5997445.84853 | 2095752.3652400002 | 37.734390310651605 | -122.451251210378 | (37.7343903106516, -122.451251210378) | |||
| 30471 | 30471 | 188564 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Vermont St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 6011131.87643 | 2106822.77201 | 37.7655613532939 | -122.404712987912 | (37.7655613532939, -122.404712987912) | ||||
| 34603 | 34603 | 249714 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 5999388.9274 | 2116973.5904200003 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | ||||
| 35242 | 35242 | 249713 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5999382.51554 | 2116973.87968 | 37.792769985700296 | -122.446081467494 | (37.7927699857003, -122.446081467494) | ||||
| 35303 | 35303 | 249715 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5999395.51836 | 2116974.38878 | 37.7927721260745 | -122.44603651397 | (37.7927721260745, -122.44603651397) | ||||
| 133552 | 133552 | 249874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 0ft | 6011664.0982800005 | 2120483.35155 | 37.803099833442296 | -122.403833479743 | (37.8030998334423, -122.403833479743) | |||
| 155707 | 155707 | 203875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992168.26739 | 2088231.33888 | 37.7134358290799 | -122.468950218092 | (37.7134358290799, -122.468950218092) | ||||
| 157520 | 157520 | 203877 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992177.10886 | 2088222.03993 | 37.7134108072361 | -122.468918982843 | (37.7134108072361, -122.468918982843) | ||||
| 160942 | 160942 | 249712 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 5999372.04623 | 2116967.23886 | 37.792751153907204 | -122.44611721373998 | (37.7927511539072, -122.44611721374) | ||||
| 161892 | 161892 | 203876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992169.18145 | 2088225.46502 | 37.7134197536892 | -122.468946631609 | (37.7134197536892, -122.468946631609) | ||||
| 188029 | 188029 | 249872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | |||
| 68047 | 68047 | 218985 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 735 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5998106.15759 | 2095768.84675 | 37.7344733504624 | -122.448969503563 | (37.7344733504624, -122.448969503563) | |||
| 25385 | 25385 | 228907 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 7ft | 6002320.43591 | 2108252.4902 | 37.7689905824786 | -122.435292027503 | (37.7689905824786, -122.435292027503) | |||
| 26526 | 26526 | 228904 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6002231.23378 | 2108246.83249 | 37.7689699817064 | -122.435600166732 | (37.7689699817064, -122.435600166732) | ||||
| 74783 | 74783 | 228905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6002259.19878 | 2108248.90212 | 37.768977252715295 | -122.43550358581801 | (37.7689772527153, -122.435503585818) | ||||
| 160452 | 160452 | 228906 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 6002292.02781 | 2108250.42967 | 37.768983311465 | -122.435390141758 | (37.768983311465, -122.435390141758) | ||||
| 50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
| 100392 | 100392 | 96279 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 55@ Alemany Trumbull St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||||
| 126031 | 126031 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3700 Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715.0 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | |
| 28538 | 28538 | 212784 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5998105.0801800005 | 2095806.61255 | 37.734576984727795 | -122.448975948078 | (37.7345769847278, -122.448975948078) | |||
| 68601 | 68601 | 212785 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5998104.46417 | 2095821.7845 | 37.734618608054795 | -122.448979170379 | (37.7346186080548, -122.448979170379) | |||
| 27714 | 27714 | 237848 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 21 Addison St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003593.08721 | 2096850.61715 | 37.7377559191042 | -122.430076526206 | (37.7377559191042, -122.430076526206) | |||
| 28833 | 28833 | 249969 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.802012151107704 | -122.403574702535 | (37.8020121511077, -122.403574702535) | |||
| 37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
| 51583 | 51583 | 249891 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 0ft | 6011455.072819999 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | |||
| 52205 | 52205 | 249810 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.804517058874396 | -122.407221117962 | (37.8045170588744, -122.407221117962) | |||
| 53839 | 53839 | 249807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010752.11734 | 2121021.55825 | 37.8045266258517 | -122.407027386026 | (37.8045266258517, -122.407027386026) | |||
| 54919 | 54919 | 237847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 21 Addison St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003573.70242 | 2096850.7481 | 37.7377551807635 | -122.430143558104 | (37.7377551807635, -122.430143558104) | |||
| 131807 | 131807 | 249873 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | |||
| 156801 | 156801 | 249808 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6010714.23144 | 2121016.75548 | 37.80451131849129 | -122.40715815553101 | (37.8045113184913, -122.407158155531) | |||
| 159363 | 159363 | 249970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011737.037830001 | 2120086.51138 | 37.802014281606205 | -122.403553132272 | (37.8020142816062, -122.403553132272) |
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");