Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) |
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");