Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
343 | 343 | 244298 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005605.7628 | 2110511.5277 | 37.7753793775331 | -122.42408895277501 | (37.7753793775331, -122.424088952775) | |||
368 | 368 | 18096 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 3008 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1997 12:00:00 AM | 6 | 3X3 | 5999424.6928 | 2114682.6521 | 37.786481285230295 | -122.44577068023099 | (37.7864812852303, -122.445770680231) | ||
426 | 426 | 21683 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1999 12:00:00 AM | 6 | 2x2 | 6003770.0848 | 2114594.6383 | 37.786486768354294 | -122.430730428794 | (37.7864867683543, -122.430730428794) | ||
7481 | 7481 | 21730 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1955 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1990 12:00:00 AM | 6 | 3X3 | 6003249.1628 | 2114463.8768 | 37.786098203806205 | -122.43252334451599 | (37.7860982038062, -122.432523344516) | ||
8037 | 8037 | 12253 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 528 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2003 12:00:00 AM | 6 | 3x3 | 6005030.2517 | 2110722.9994 | 37.7759275170107 | -122.426094839447 | (37.7759275170107, -122.426094839447) | ||
9027 | 9027 | 21627 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1615 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/14/2010 12:00:00 AM | 6 | 4X4 | Permit Number 53778 | 6004639.3671 | 2114660.2794 | 37.7867162131248 | -122.42772760613701 | (37.7867162131248, -122.427727606137) |
10379 | 10379 | 86560 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.48501883929899 | (37.7522790893532, -122.485018839299) | ||
15620 | 15620 | 44090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013747.9947 | 2112490.5876700003 | 37.7812697737139 | -122.39606158808701 | (37.7812697737139, -122.396061588087) | |
18656 | 18656 | 25472 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/1999 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.714208763487896 | -122.46459914058599 | (37.7142087634879, -122.464599140586) | ||
19795 | 19795 | 9378 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 320 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001091.814301901 | 2097867.0769738997 | 37.740404899832896 | -122.438797433034 | (37.7404048998329, -122.438797433034) | |||
20466 | 20466 | 18597 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 415 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1999 12:00:00 AM | 6 | 3X3 | 5992871.5273 | 2088492.4561 | 37.7141934014371 | -122.466538492306 | (37.7141934014371, -122.466538492306) | ||
32121 | 32121 | 66333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1291 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 6 | Permit Number 29454 | 5986445.8362 | 2106470.4022 | 37.763183176794705 | -122.490069413492 | (37.7631831767947, -122.490069413492) | |
40005 | 40005 | 32827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4107 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | 3x3 | Permit Number 37185 | 6002480.53446063 | 2101776.94850735 | 37.751219399221604 | -122.434275246016 | (37.7512193992216, -122.434275246016) |
45910 | 45910 | 245066 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000396.341 | 2109035.0297 | 37.771029784663206 | -122.44200350656999 | (37.7710297846632, -122.44200350657) | |||
47397 | 47397 | 135909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011530.70294 | 2119058.88107 | 37.79918113116 | -122.40419478595501 | (37.79918113116, -122.404194785955) | ||||
48023 | 48023 | 196403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 140 Langton St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010340.69149 | 2110544.62696 | 37.7757364574022 | -122.40771198501899 | (37.7757364574022, -122.407711985019) | |||
50138 | 50138 | 245099 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1116 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001200.4602 | 2109374.4683 | 37.7720075888162 | -122.43924637279899 | (37.7720075888162, -122.439246372799) | |||
52984 | 52984 | 69922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | ||
53715 | 53715 | 72507 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2135 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1996 12:00:00 AM | 6 | 5988189.7462 | 2100767.6803 | 37.747626723008295 | -122.48361976345801 | (37.7476267230083, -122.483619763458) | ||
56036 | 56036 | 42854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2471 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42783 | 5987340.671 | 2098461.3118 | 37.74124459004229 | -122.486386476099 | (37.7412445900423, -122.486386476099) | |
56855 | 56855 | 238020 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 Ashbury Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5999596.30607 | 2106935.78713 | 37.7652201693967 | -122.44461993696501 | (37.7652201693967, -122.444619936965) | |||
57598 | 57598 | 43283 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.3857900002 | 37.72114734204379 | -122.404247572584 | (37.7211473420438, -122.404247572584) | |
58999 | 58999 | 214461 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 463 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998361.155040001 | 2095223.72648 | 37.732991159806396 | -122.448048660719 | (37.7329911598064, -122.448048660719) | |||
62412 | 62412 | 71226 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2267 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987603.3648 | 2099853.8795 | 37.745083520509894 | -122.485580358953 | (37.7450835205099, -122.485580358953) | ||
63241 | 63241 | 73536 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099831.4757 | 37.7450244421871 | -122.485434109471 | (37.7450244421871, -122.485434109471) | ||
69325 | 69325 | 65957 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2451 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 6 | Permit Number 28979 | 5987645.5214 | 2098612.1125 | 37.741676413437794 | -122.48534348790501 | (37.7416764134378, -122.485343487905) | ||
75567 | 75567 | 138982 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 429 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005468.9296 | 2110741.6621 | 37.7760035441121 | -122.42457866517599 | (37.7760035441121, -122.424578665176) | |||
81184 | 81184 | 37591 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 662 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40019 | 6003651.61608784 | 2104418.27327771 | 37.7585382525557 | -122.430413956054 | (37.7585382525557, -122.430413956054) | |
83203 | 83203 | 178962 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 217 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007226.63785 | 2092632.02114 | 37.7263776956646 | -122.417214704709 | (37.7263776956646, -122.417214704709) | |||
91205 | 91205 | 117302 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2265 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6002502.0 | 2106990.0 | 37.7655344027956 | -122.434573725675 | (37.7655344027956, -122.434573725675) | |||
116623 | 116623 | 109155 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2016 12:00:00 AM | 6 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||
118507 | 118507 | 73592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586.0 | 2116213.0 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | |
127780 | 127780 | 16687 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 500 Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 2 | 5992496.9362665005 | 2103468.0481268 | 37.755291002769496 | -122.468922364571 | (37.7552910027695, -122.468922364571) | |||
143293 | 143293 | 43850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2674 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43472 | 5985253.1482 | 2097047.7977 | 37.7372415601551 | -122.493500160872 | (37.7372415601551, -122.493500160872) | |
146100 | 146100 | 43905 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
147043 | 147043 | 245121 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1226 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000650.5369 | 2109296.0266 | 37.7717608989394 | -122.441142965804 | (37.7717608989394, -122.441142965804) | |||
148757 | 148757 | 196402 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 136 Langton St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010324.85595 | 2110562.99084 | 37.775785993859294 | -122.407768059545 | (37.7757859938593, -122.407768059545) | |||
151418 | 151418 | 47893 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 745 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 6 | Permit Number 48331 | 6000477.4696 | 2111570.4889 | 37.7779961374161 | -122.44190489030899 | (37.7779961374161, -122.441904890309) | |
152446 | 152446 | 138932 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 724 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004510.895 | 2110993.3253 | 37.7766403984333 | -122.427910696353 | (37.7766403984333, -122.427910696353) | |||
156525 | 156525 | 238033 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 708 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002389.010430001 | 2104002.35409 | 37.7573246362385 | -122.434750866762 | (37.7573246362385, -122.434750866762) | |||
157114 | 157114 | 138067 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2170 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003141.8822 | 2114856.8511 | 37.787171127463296 | -122.432922591539 | (37.7871711274633, -122.432922591539) | |||
160866 | 160866 | 44713 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1923 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 6 | Permit Number 43836 | 5990003.0613 | 2102262.9361 | 37.7518376831776 | -122.477458761132 | (37.7518376831776, -122.477458761132) | |
162372 | 162372 | 141250 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 42 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996544.0519 | 2114280.1621 | 37.7852112604093 | -122.455707816901 | (37.7852112604093, -122.455707816901) | |||
162426 | 162426 | 178957 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007486.28826 | 2091855.13775 | 37.7242591447243 | -122.41626210321002 | (37.7242591447243, -122.41626210321) | |||
165331 | 165331 | 214413 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999222.20019 | 2094063.41947 | 37.729854411747105 | -122.444988430586 | (37.7298544117471, -122.444988430586) | |||
169020 | 169020 | 30735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 281 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34629 | 6005244.0655 | 2109725.8172 | 37.773201579085004 | -122.42528422609699 | (37.773201579085, -122.425284226097) | |
169464 | 169464 | 244238 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 255 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005544.2422 | 2110192.8239 | 37.7745008205043 | -122.424279095113 | (37.7745008205043, -122.424279095113) | |||
172601 | 172601 | 117182 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000152.35367 | 2086600.7137400003 | 37.709416560993 | -122.441237557982 | (37.709416560993, -122.441237557982) | |||
176542 | 176542 | 135906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007265.472680001 | 2119876.0558700003 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | |||
181390 | 181390 | 46205 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1852 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2005 12:00:00 AM | 6 | Permit Number 44521 | 5988484.6348 | 2102686.0448 | 37.7529112010076 | -122.482740630037 | (37.7529112010076, -122.482740630037) | |
182510 | 182510 | 43851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 6 | Permit Number 43473 | 5985253.1482 | 2097007.4687 | 37.737130827494504 | -122.49349719028 | (37.7371308274945, -122.49349719028) | |
187927 | 187927 | 246220 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1375 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999535.8083 | 2107910.8735 | 37.767894059626606 | -122.444899283084 | (37.7678940596266, -122.444899283084) | |||
189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) |
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");