Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17841 | 17841 | 28011 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014191.95801 | 2117739.78401 | 37.795707543335 | -122.394893427962 | (37.795707543335, -122.394893427962) | ||
| 19743 | 19743 | 28006 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014086.70601 | 2117927.50101 | 37.7962171170916 | -122.395270777766 | (37.7962171170916, -122.395270777766) | ||
| 87186 | 87186 | 28016 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014245.12601 | 2117603.06501 | 37.7953351012525 | -122.39469987660699 | (37.7953351012525, -122.394699876607) | ||
| 90823 | 90823 | 28017 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014258.1470099995 | 2117577.0230099997 | 37.7952643199629 | -122.394652996927 | (37.7952643199629, -122.394652996927) | ||
| 93769 | 93769 | 28013 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014214.74401 | 2117682.27501 | 37.7955509040886 | -122.394810554146 | (37.7955509040886, -122.394810554146) | ||
| 98050 | 98050 | 28010 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014178.9370099995 | 2117764.74001 | 37.795775342622704 | -122.39494023205098 | (37.7957753426227, -122.394940232051) | ||
| 102195 | 102195 | 28019 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014278.76301 | 2117533.6200099997 | 37.7951462916621 | -122.39457862095301 | (37.7951462916621, -122.394578620953) | ||
| 108483 | 108483 | 28012 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014204.97801 | 2117711.57201 | 37.7956308037617 | -122.39484639927299 | (37.7956308037617, -122.394846399273) | ||
| 109454 | 109454 | 28004 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014041.13301 | 2117989.3500099997 | 37.7963844052449 | -122.39543280592 | (37.7963844052449, -122.39543280592) | ||
| 115291 | 115291 | 28020 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014303.72001 | 2117502.15301 | 37.795061278092 | -122.394490060779 | (37.795061278092, -122.394490060779) | ||
| 116371 | 116371 | 28008 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3x3 | 6014135.53401 | 2117846.1200099997 | 37.7959963794451 | -122.39509611853599 | (37.7959963794451, -122.395096118536) | ||
| 120923 | 120923 | 28005 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014065.00401 | 2117953.54201 | 37.796287412573 | -122.395347696851 | (37.796287412573, -122.395347696851) | ||
| 121699 | 121699 | 28018 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014268.99801 | 2117554.23701 | 37.795202358224394 | -122.394613854051 | (37.7952023582244, -122.394613854051) | ||
| 128885 | 128885 | 28014 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014226.68001 | 2117656.2330099996 | 37.795480062520205 | -122.394767428538 | (37.7954800625202, -122.394767428538) | ||
| 139337 | 139337 | 28015 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014236.44501 | 2117630.19201 | 37.795409102976606 | -122.39473181516001 | (37.7954091029766, -122.39473181516) | ||
| 140583 | 140583 | 28007 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014117.08801 | 2117880.84301 | 37.7960906948417 | -122.395162379187 | (37.7960906948417, -122.395162379187) | ||
| 142720 | 142720 | 28009 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014164.83101 | 2117791.8670099997 | 37.795849042613604 | -122.394990942689 | (37.7958490426136, -122.394990942689) | ||
| 90869 | 90869 | 13870 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1000 Market St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2007 12:00:00 AM | 8 | 4x4 | 6009621.357596201 | 2112944.5572428 | 37.7822858053101 | -122.410369845025 | (37.7822858053101, -122.410369845025) | ||
| 89981 | 89981 | 5221 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1009X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2005 12:00:00 AM | 5 | 3X3 | 6001407.0548 | 2111843.67263 | 37.7787991574032 | -122.438708711528 | (37.7787991574032, -122.438708711528) | ||
| 82636 | 82636 | 28160 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 82661 | 82661 | 28156 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 82731 | 82731 | 28158 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 83531 | 83531 | 28163 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 84046 | 84046 | 28153 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 87427 | 87427 | 28161 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 89751 | 89751 | 28155 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 99719 | 99719 | 28148 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 101051 | 101051 | 28162 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 101820 | 101820 | 28164 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 106434 | 106434 | 28149 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 107406 | 107406 | 28159 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 112058 | 112058 | 28150 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 114140 | 114140 | 28152 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 126469 | 126469 | 28154 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 127075 | 127075 | 28151 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 139994 | 139994 | 28157 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100X King St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6015580.653172099 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | |||
| 92896 | 92896 | 13471 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 101 Market St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.39554333902399 | (37.79368951828, -122.395543339024) | ||
| 103184 | 103184 | 13466 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 101 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.39554333902399 | (37.79368951828, -122.395543339024) | ||
| 108849 | 108849 | 13469 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 101 Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.39554333902399 | (37.79368951828, -122.395543339024) | ||
| 120682 | 120682 | 13463 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 101 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.39554333902399 | (37.79368951828, -122.395543339024) | ||
| 138672 | 138672 | 13468 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 101 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.39554333902399 | (37.79368951828, -122.395543339024) | ||
| 118341 | 118341 | 91785 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1020 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011200.069593 | 2110914.857315 | 37.7768010945018 | -122.40476523573601 | (37.7768010945018, -122.404765235736) | |||
| 100910 | 100910 | 16721 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1040 O'Farrell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1999 12:00:00 AM | 3 | 4X4 | 6006312.05395 | 2113904.5769700003 | 37.784735716896 | -122.421886798179 | (37.784735716896, -122.421886798179) | ||
| 89865 | 89865 | 5231 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1053 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 6 | 3X3 | 6001315.02339 | 2112044.91566 | 37.7793464837663 | -122.43904151019899 | (37.7793464837663, -122.439041510199) | ||
| 16178 | 16178 | 13906 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1063 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2016 11:38:00 AM | 3 | 4x4 | 6009266.7492 | 2112493.5891 | 37.7810276692866 | -122.411564765047 | (37.7810276692866, -122.411564765047) | ||
| 95814 | 95814 | 16723 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1075 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2012 12:00:00 AM | 3 | 4X4 | 6006252.84558 | 2113856.0640000002 | 37.7845991729485 | -122.42208819225701 | (37.7845991729485, -122.422088192257) | ||
| 79605 | 79605 | 13918 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1077 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2015 08:31:00 AM | 3 | 4X4 | 6009171.934008099 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | ||
| 84209 | 84209 | 13919 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1077 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 6009171.934008099 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | |||
| 111967 | 111967 | 13923 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1081 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/1997 12:00:00 AM | 20 | 4X4 | 6009147.081616299 | 2112396.0791116003 | 37.7807532168626 | -122.41197186337601 | (37.7807532168626, -122.411971863376) | ||
| 104295 | 104295 | 13924 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1083 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2004 12:00:00 AM | 16 | 4X4 | 6009134.0341107 | 2112383.6460599 | 37.7807183466268 | -122.41201612228998 | (37.7807183466268, -122.41201612229) | ||
| 144480 | 144480 | 13925 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1083 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/15/2006 12:00:00 AM | 6 | 4X4 | 6009134.0341107 | 2112383.6460599 | 37.7807183466268 | -122.41201612228998 | (37.7807183466268, -122.41201612229) | ||
| 100512 | 100512 | 102122 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 104237 | 104237 | 102123 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 122650 | 122650 | 102121 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 114521 | 114521 | 13927 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1091 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2015 07:43:00 AM | 3 | 4x4 | 6009083.7080174005 | 2112335.6900033 | 37.7805838469879 | -122.412186834853 | (37.7805838469879, -122.412186834853) | ||
| 125397 | 125397 | 13928 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1091 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2000 12:00:00 AM | 20 | 4X4 | 6009083.7080174005 | 2112335.6900033 | 37.7805838469879 | -122.412186834853 | (37.7805838469879, -122.412186834853) | ||
| 93262 | 93262 | 84561 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1095X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) |
| 99904 | 99904 | 84560 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1095X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) |
| 85022 | 85022 | 91784 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1098 HARRISON ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 40 | 3x3 | 6010813.0 | 2110645.0 | 37.7760384868277 | -122.40608521626999 | (37.7760384868277, -122.40608521627) | ||
| 6189 | 6189 | 95165 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100 Divisadero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2014 12:00:00 AM | 3 | 3x3 | 6001410.7267 | 2112361.1413 | 37.7802202041401 | -122.438733098992 | (37.7802202041401, -122.438733098992) | ||
| 108683 | 108683 | 5235 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 5x5 | 6001436.83253 | 2112303.93811 | 37.78006462380971 | -122.438638687165 | (37.7800646238097, -122.438638687165) | |||
| 108654 | 108654 | 91780 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010733.753804 | 2110469.199819 | 37.7755513476177 | -122.40634696148899 | (37.7755513476177, -122.406346961489) | ||
| 121342 | 121342 | 91781 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010733.0 | 2110469.0 | 37.775550756793606 | -122.40634955501001 | (37.7755507567936, -122.40634955501) | ||
| 84123 | 84123 | 84564 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.751495629752704 | -122.429718442511 | (37.7514956297527, -122.429718442511) |
| 91903 | 91903 | 84562 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.751495629752704 | -122.429718442511 | (37.7514956297527, -122.429718442511) |
| 118956 | 118956 | 84563 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.751495629752704 | -122.429718442511 | (37.7514956297527, -122.429718442511) |
| 95120 | 95120 | 121027 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1101X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6007689.0 | 2103175.0 | 37.7553523831166 | -122.41636276728902 | (37.7553523831166, -122.416362767289) | |||
| 101968 | 101968 | 121026 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1101X South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6007689.0 | 2103175.0 | 37.7553523831166 | -122.41636276728902 | (37.7553523831166, -122.416362767289) | |||
| 142251 | 142251 | 121025 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1101X South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6007689.0 | 2103175.0 | 37.7553523831166 | -122.41636276728902 | (37.7553523831166, -122.416362767289) | |||
| 142941 | 142941 | 121028 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1101X South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6007689.0 | 2103175.0 | 37.7553523831166 | -122.41636276728902 | (37.7553523831166, -122.416362767289) | |||
| 95263 | 95263 | 13946 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1108 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/08/1999 12:00:00 AM | 12 | 4x4 | 6008893.402467401 | 2112262.9816205003 | 37.7803735270406 | -122.412840052753 | (37.7803735270406, -122.412840052753) | ||
| 115045 | 115045 | 84557 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1111X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.75150164846921 | -122.42961857746599 | (37.7515016484692, -122.429618577466) |
| 142483 | 142483 | 84558 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1111X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.75150164846921 | -122.42961857746599 | (37.7515016484692, -122.429618577466) |
| 84533 | 84533 | 13948 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1112X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/1994 12:00:00 AM | 12 | 4x4 | 6008868.4803222995 | 2112239.1730786 | 37.780306755543606 | -122.412924586563 | (37.7803067555436, -122.412924586563) | ||
| 108158 | 108158 | 13954 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1117 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/23/2015 07:44:00 AM | 3 | 4X4 | 6008897.3784125 | 2112157.6718266 | 37.780084594590896 | -122.412818850612 | (37.7800845945909, -122.412818850612) | ||
| 84917 | 84917 | 13940 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1140X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6008690.286984299 | 2112068.9420038 | 37.779829337550105 | -122.41352899888099 | (37.7798293375501, -122.413528998881) | |||
| 19174 | 19174 | 91779 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1184 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010158.993686 | 2109919.902048 | 37.7740109351691 | -122.408296453122 | (37.7740109351691, -122.408296453122) | ||
| 98784 | 98784 | 95178 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3 | 3x3 | 6001286.14287 | 2112595.80793 | 37.7808574507306 | -122.439180914838 | (37.7808574507306, -122.439180914838) | ||
| 124499 | 124499 | 5259 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1221 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X3 | 6001282.65173 | 2112621.17829 | 37.780926912629496 | -122.439194811296 | (37.7809269126295, -122.439194811296) | |||
| 118989 | 118989 | 14031 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1244 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2005 12:00:00 AM | 3 | 4x4 | 6008141.7716697 | 2111544.9362715 | 37.778359728545496 | -122.41538945409401 | (37.7783597285455, -122.415389454094) | ||
| 18160 | 18160 | 14032 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1245 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2012 12:00:00 AM | 3 | 4X4 | 6008153.561444099 | 2111445.1787375 | 37.7780864807987 | -122.415341604846 | (37.7780864807987, -122.415341604846) | ||
| 103232 | 103232 | 95167 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1300 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3 | 3x3 | 6001355.0 | 2112906.0 | 37.781713077167396 | -122.43896494142 | (37.7817130771674, -122.43896494142) | ||
| 84933 | 84933 | 95166 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1300X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001355.20441 | 2112906.07306 | 37.7817132894018 | -122.438964239497 | (37.7817132894018, -122.438964239497) | |||
| 92128 | 92128 | 95181 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1301X Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001253.460519999 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | |||
| 105849 | 105849 | 95180 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1301X Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001253.460519999 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | |||
| 115090 | 115090 | 95179 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1301X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2008 12:00:00 AM | 3 | 3x3 | 6001253.460519999 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | ||
| 91975 | 91975 | 8375 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1301X Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005507.71189 | 2114109.8093 | 37.7852538400076 | -122.42468416339199 | (37.7852538400076, -122.424684163392) | |||
| 108459 | 108459 | 5275 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1325 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001243.83619 | 2112984.00007 | 37.781920920014294 | -122.439355107677 | (37.7819209200143, -122.439355107677) | |||
| 9105 | 9105 | 41297 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 135 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2000 12:00:00 AM | 18 | Permit Number 41974 | 6006066.97178257 | 2108901.70025465 | 37.770985207585 | -122.42237911350401 | (37.770985207585, -122.422379113504) | ||
| 5457 | 5457 | 5284 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1351 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2016 12:00:00 AM | 3 | 3X4 | 6001249.4687 | 2113069.2889 | 37.7821554219249 | -122.43934173715701 | (37.7821554219249, -122.439341737157) | ||
| 114967 | 114967 | 91839 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1351 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009423.082164 | 2109161.631862 | 37.77188766599679 | -122.410788543549 | (37.7718876659968, -122.410788543549) | ||
| 93260 | 93260 | 86693 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1355 Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2007 12:00:00 AM | Permit Number 49693 | 6007704.191622 | 2111021.854521 | 37.776898867368395 | -122.416866141309 | (37.7768988673684, -122.416866141309) | |||
| 4305 | 4305 | 104530 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1367 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 10:11:00 AM | 3 | 3x3 | 6001181.1 | 2113098.8 | 37.7822325609387 | -122.439580377754 | (37.7822325609387, -122.439580377754) | ||
| 115319 | 115319 | 101923 | Section 143 8 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1401X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007402.7 | 2116063.9 | 37.790726135860204 | -122.418266664095 | (37.7907261358602, -122.418266664095) | ||
| 127467 | 127467 | 2872 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1408 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 6007572.07583 | 2116196.8804599997 | 37.791100800013204 | -122.417690060515 | (37.7911008000132, -122.417690060515) | ||
| 88902 | 88902 | 14084 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1411 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | 4X4 | Permit Number 775519 | 6007340.8551319 | 2110667.3761307 | 37.775905110846296 | -122.418097899429 | (37.7759051108463, -122.418097899429) | |
| 116826 | 116826 | 14083 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1411 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2004 12:00:00 AM | 3 | 4X4 | 6007365.6919502 | 2110691.1561735 | 37.775971803050496 | -122.418013668426 | (37.7759718030505, -122.418013668426) | ||
| 77318 | 77318 | 5288 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1450 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 01/01/2010 12:00:00 AM | 3 | 3X3 | 6001279.390109099 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | ||
| 87019 | 87019 | 116702 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1450 Divisadero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 3X3 | 6001279.390109099 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | ||||
| 124398 | 124398 | 116701 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1450 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 3X3 | 6001279.390109099 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) |
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");