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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1004 | 1004 | 14128 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1621 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2017 09:15:00 AM | 3 | 4X4 | 6006600.23891 | 2109952.2807299998 | 37.7738999176888 | -122.42060911302201 | (37.7738999176888, -122.420609113022) | ||
| 1014 | 1014 | 14130 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1629 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2017 09:35:00 AM | 3 | 4X4 | 6006499.222 | 2109855.3433 | 37.7736280571205 | -122.420951663899 | (37.7736280571205, -122.420951663899) | ||
| 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) | ||
| 4575 | 4575 | 234736 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 200 Henry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2017 08:58:00 AM | 3 | Width 3ft | 6002089.32864 | 2107372.68693 | 37.7665617321566 | -122.436028447274 | (37.7665617321566, -122.436028447274) | ||
| 5437 | 5437 | 3009 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2402 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2012 12:00:00 AM | 3 | 3x3 | 6002808.01196 | 2115517.13179 | 37.7889651474795 | -122.43412492783399 | (37.7889651474795, -122.434124927834) | ||
| 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) | ||
| 6060 | 6060 | 28725 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1970 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2013 12:00:00 AM | 3 | 3x3 | 6003187.8589 | 2114511.853 | 37.7862264577302 | -122.43273886791201 | (37.7862264577302, -122.432738867912) | ||
| 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) | ||
| 7078 | 7078 | 95163 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 998 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001491.8688 | 2111772.0851 | 37.7786074207661 | -122.438410176931 | (37.7786074207661, -122.438410176931) | |
| 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) | ||
| 9113 | 9113 | 91843 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 855 HARRISON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 9 | 3x3 | 6012443.0 | 2111954.0 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | ||
| 9134 | 9134 | 117955 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 855 HARRISON ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6012443.0 | 2111954.0 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | |||
| 9200 | 9200 | 117958 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 851X HARRISON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6012435.0 | 2111995.0 | 37.7798358648386 | -122.40056910858499 | (37.7798358648386, -122.400569108585) | |||
| 9311 | 9311 | 91790 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 850 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 12 | 3x3 | 6012369.025423001 | 2112032.027439 | 37.7799338540171 | -122.400799947263 | (37.7799338540171, -122.400799947263) | ||
| 9373 | 9373 | 91791 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 850 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012369.025423001 | 2112032.027439 | 37.7799338540171 | -122.400799947263 | (37.7799338540171, -122.400799947263) | ||
| 9414 | 9414 | 117959 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 851X HARRISON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012435.0 | 2111995.0 | 37.7798358648386 | -122.40056910858499 | (37.7798358648386, -122.400569108585) | |||
| 10067 | 10067 | 83989 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1765 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2013 12:00:00 AM | 3x4 | 6005922.82997861 | 2115889.71332947 | 37.7901644509246 | -122.42337455669501 | (37.7901644509246, -122.423374556695) | |||
| 16059 | 16059 | 13793 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 929 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2016 06:56:00 AM | 3 | 4X4 | 6010115.5056 | 2113327.9166 | 37.7833661076198 | -122.408687358048 | (37.7833661076198, -122.408687358048) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 19170 | 19170 | 2795 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 6530X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987349.71414 | 2113973.9756400003 | 37.783838627391 | -122.48749447615101 | (37.783838627391, -122.487494476151) | |||
| 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) | ||
| 19358 | 19358 | 100409 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 201 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006409.6 | 2110870.2 | 37.776409557160704 | -122.42133376349399 | (37.7764095571607, -122.421333763494) | |||
| 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) | ||
| 27179 | 27179 | 28332 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3247 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2004 12:00:00 AM | 9 | 3x3 | 6006498.83651 | 2099346.5132400002 | 37.744773232920004 | -122.420207017141 | (37.74477323292, -122.420207017141) | ||
| 38338 | 38338 | 27303 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 4339 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5994091.63002 | 2114139.7776099998 | 37.784684758580106 | -122.46418217924801 | (37.7846847585801, -122.464182179248) | |||
| 50106 | 50106 | 28049 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 51261 | 51261 | 28503 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 270 06th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/2013 12:00:00 AM | 3 | 3x3 | 6010824.2979387 | 2111653.7211901 | 37.77880883239779 | -122.406117215604 | (37.7788088323978, -122.406117215604) | ||
| 66187 | 66187 | 28326 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3284 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006311.45985 | 2099177.31377 | 37.74429808959321 | -122.420842920924 | (37.7442980895932, -122.420842920924) | ||
| 66638 | 66638 | 28339 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007038.71469 | 2100348.34949 | 37.7475544551381 | -122.41841123937901 | (37.7475544551381, -122.418411239379) | ||
| 75299 | 75299 | 27259 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 690 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006717.7455722 | 2112795.3484564996 | 37.781712917040295 | -122.420404476934 | (37.7817129170403, -122.420404476934) | |||
| 77170 | 77170 | 28335 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3221 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006572.11195 | 2099482.47917 | 37.74515069323721 | -122.41996329086099 | (37.7451506932372, -122.419963290861) | ||
| 77301 | 77301 | 27984 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 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) | ||
| 77392 | 77392 | 14183 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1844 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2012 12:00:00 AM | 12 | 4X4 | Permit Number 769087 | 6005554.6579568 | 2109080.5883488 | 37.7714474783148 | -122.424163948162 | (37.7714474783148, -122.424163948162) | |
| 77482 | 77482 | 91795 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 500x Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 775014 | 6014662.1325 | 2114223.547757 | 37.786078905224706 | -122.39302038306002 | (37.7860789052247, -122.39302038306) | |
| 77969 | 77969 | 28181 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X King St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.39176704065201 | (37.7780379351787, -122.391767040652) | |||
| 78099 | 78099 | 111374 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | ||||
| 78109 | 78109 | 207 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2919 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2X3 | 5990501.92231 | 2095794.16798 | 37.7341050531518 | -122.47526143143 | (37.7341050531518, -122.47526143143) | ||
| 78483 | 78483 | 111371 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | ||||
| 78782 | 78782 | 92566 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52905 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | |||
| 79049 | 79049 | 27992 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 79086 | 79086 | 70859 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 201 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | Permit Number 767727 | 6006431.93006457 | 2110802.5343302 | 37.776225022484496 | -122.42125171126499 | (37.7762250224845, -122.421251711265) | |||
| 79310 | 79310 | 91850 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 855 HARRISON ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 7 | 3x3 | 6012443.0 | 2111954.0 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | ||
| 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) | ||
| 79843 | 79843 | 3131 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3200 California St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 5998952.52581 | 2114994.22768 | 37.7873098198001 | -122.447426688631 | (37.7873098198001, -122.447426688631) | ||
| 79881 | 79881 | 97900 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 375X Precita Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x4 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
| 80075 | 80075 | 26878 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 275 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | Permit Number 771536 | 6006101.0 | 2108089.0 | 37.7687556461675 | -122.42220366043199 | (37.7687556461675, -122.422203660432) | ||
| 80340 | 80340 | 28045 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 80632 | 80632 | 13581 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 525 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6012787.5365724005 | 2115865.9219292 | 37.790484170826396 | -122.399621379879 | (37.7904841708264, -122.399621379879) | |||
| 80697 | 80697 | 112842 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 604 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2015 12:00:00 AM | Permit Number 773221 | 5992274.9 | 2111288.5 | 37.776751052460604 | -122.470259695975 | (37.7767510524606, -122.470259695975) | |||
| 80759 | 80759 | 15613 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3435 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2004 12:00:00 AM | 6 | 3x3 | 6005895.33669 | 2098270.89959 | 37.7417858175205 | -122.42221740366199 | (37.7417858175205, -122.422217403662) | ||
| 80798 | 80798 | 27258 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 690 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006717.7455722 | 2112795.3484564996 | 37.781712917040295 | -122.420404476934 | (37.7817129170403, -122.420404476934) | |||
| 80840 | 80840 | 28169 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.39176704065201 | (37.7780379351787, -122.391767040652) | |||
| 80845 | 80845 | 26270 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 16 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2015 10:26:00 AM | 3 | 3X3 | 6006157.7043564 | 2098703.0541301 | 37.742987212058296 | -122.42134090318001 | (37.7429872120583, -122.42134090318) | ||
| 80889 | 80889 | 111372 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | ||||
| 81061 | 81061 | 13492 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 215 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013729.1406446 | 2116782.463481 | 37.793053221420706 | -122.396427736192 | (37.7930532214207, -122.396427736192) | ||
| 81330 | 81330 | 116229 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 81692 | 81692 | 91855 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 601x Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6014039.760938 | 2113573.4180650003 | 37.7842592071543 | -122.395128082808 | (37.7842592071543, -122.395128082808) | ||
| 81886 | 81886 | 116302 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 81948 | 81948 | 28363 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3469 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6005899.78718 | 2098063.61718 | 37.7412169177624 | -122.42218729229299 | (37.7412169177624, -122.422187292293) | ||
| 81994 | 81994 | 28180 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X King St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.39176704065201 | (37.7780379351787, -122.391767040652) | |||
| 82042 | 82042 | 27988 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 82097 | 82097 | 91787 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 974 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011579.2012910005 | 2111277.19318 | 37.7778171686355 | -122.403479195946 | (37.7778171686355, -122.403479195946) | |||
| 82142 | 82142 | 111376 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | ||||
| 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) | |||
| 82777 | 82777 | 85446 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 82836 | 82836 | 91344 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 90 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.77389001482361 | -122.42187731202 | (37.7738900148236, -122.42187731202) | ||
| 82911 | 82911 | 28340 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3125 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007038.71469 | 2100348.34949 | 37.7475544551381 | -122.41841123937901 | (37.7475544551381, -122.418411239379) | ||
| 83060 | 83060 | 116290 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 83155 | 83155 | 91814 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2621 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008916.0 | 2103203.0 | 37.755498187104294 | -122.41212139441099 | (37.7554981871043, -122.412121394411) | ||
| 83494 | 83494 | 27972 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 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) | |||
| 83857 | 83857 | 8417 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1625X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1997 12:00:00 AM | 6 | 3X3 | 6003997.4163 | 2113895.15466 | 37.7845790386871 | -122.42989400585199 | (37.7845790386871, -122.429894005852) | ||
| 83925 | 83925 | 14094 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1455 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2004 12:00:00 AM | 3 | 4X4 | 6007204.2526311 | 2110536.5858952 | 37.7755383026332 | -122.418561167244 | (37.7755383026332, -122.418561167244) | ||
| 84016 | 84016 | 8521 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | ||
| 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) | |||
| 84099 | 84099 | 116291 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 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) |
| 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) | |||
| 84513 | 84513 | 26639 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 6530X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1998 12:00:00 AM | 80 | 5 | 5987349.71414 | 2113973.9756400003 | 37.783838627391 | -122.48749447615101 | (37.783838627391, -122.487494476151) | ||
| 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) | ||
| 84669 | 84669 | 122511 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 715 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x6 | 6006287.0 | 2105397.0 | 37.7613745389022 | -122.42136910171301 | (37.7613745389022, -122.421369101713) | |||
| 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) | |||
| 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) | |||
| 84990 | 84990 | 27964 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 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) | ||
| 85161 | 85161 | 27995 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 85201 | 85201 | 28323 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3100 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 11 | 4x4 | 6007076.903940001 | 2100561.83623 | 37.7481427912413 | -122.41829431716101 | (37.7481427912413, -122.418294317161) | ||
| 85697 | 85697 | 14170 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1776X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2015 10:09:00 AM | 3 | 4x4 | 6005777.896097 | 2109293.199395 | 37.77204385917771 | -122.423406872271 | (37.7720438591777, -122.423406872271) | ||
| 85845 | 85845 | 102158 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 4300X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) |
| 86476 | 86476 | 27965 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 86931 | 86931 | 15604 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3333 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2004 12:00:00 AM | 3 | 4X4 | 6006368.010980001 | 2098829.09498 | 37.7433451466609 | -122.420622664534 | (37.7433451466609, -122.420622664534) | ||
| 86973 | 86973 | 27255 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 620X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006737.40655 | 2112650.78896 | 37.7813170997428 | -122.42032619562401 | (37.7813170997428, -122.420326195624) | |||
| 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) | ||||
| 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) | ||
| 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) |
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");