trees
439 rows where qSpecies_id = 148 sorted by SiteOrder
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2658 | 91806 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2945 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009025.873084 | 2101313.36822 | 37.7503158463726 | -122.411607913685 | (37.7503158463726, -122.411607913685) | 2 | 4 | 7 | 28859 | 19 | |||
| 14247 | 256666 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1406 California St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782597 | |||||||||||
| 23858 | 85447 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 35185 | 103088 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 256 SHIPLEY ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011387 | 2111652 | 37.7788355638527 | -122.404170475964 | (37.7788355638527, -122.404170475964) | 14 | 2 | 9 | 28856 | 34 | ||||
| 44768 | 85446 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 49387 | 91787 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 974 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011579.201291 | 2111277.19318 | 37.7778171686355 | -122.403479195946 | (37.7778171686355, -122.403479195946) | 14 | 2 | 9 | 28856 | 34 | |||
| 72192 | 85433 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y1 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 76312 | 91803 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2989 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009039.569733 | 2101067.518808 | 37.7496415669707 | -122.411543181878 | (37.7496415669707, -122.411543181878) | 2 | 4 | 7 | 28859 | 19 | |||
| 76766 | 85437 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y4 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 79095 | 85444 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y10 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 91070 | 91801 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3071 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009060.650721 | 2100687.104692 | 37.7485982168729 | -122.4114434106 | (37.7485982168729, -122.4114434106) | 2 | 4 | 7 | 28859 | 19 | |||
| 94031 | 85448 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y14 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 96901 | 85439 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y5 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 107166 | 91802 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2997 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009042.060032 | 2101022.818937 | 37.7495189707644 | -122.411531412589 | (37.7495189707644, -122.411531412589) | 2 | 4 | 7 | 28859 | 19 | |||
| 107246 | 91840 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 895x Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012119.593271 | 2111738.315629 | 37.7791134735728 | -122.401642199835 | (37.7791134735728, -122.401642199835) | 6 | 2 | 9 | 28856 | 34 | |||
| 109129 | 85445 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y11 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 111192 | 85440 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y6 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 113755 | 85435 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y3 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/07/2006 12:00:00 AM | 3 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 116463 | 85443 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y9 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | |||
| 153570 | 91807 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2859 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008997.743306 | 2101817.227115 | 37.7516977523567 | -122.411740786814 | (37.7516977523567, -122.411740786814) | 2 | 4 | 7 | 28859 | 19 | |||
| 160935 | 91785 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1020 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011200.069593 | 2110914.857315 | 37.7768010945018 | -122.404765235736 | (37.7768010945018, -122.404765235736) | 14 | 2 | 9 | 28853 | 34 | |||
| 165300 | 85441 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y7 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 170510 | 85434 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y2 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/23/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 175372 | 85442 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y8 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 181552 | 91786 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 966 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2010 12:00:00 AM | 3 | 3x3 | 6011627.673411 | 2111323.517939 | 37.7779470730221 | -122.403314772772 | (37.7779470730221, -122.403314772772) | 14 | 2 | 9 | 28856 | 34 | |||
| 866 | 28332 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3247 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 9 | 3x3 | 6006498.83651 | 2099346.51324 | 37.74477323292 | -122.420207017141 | (37.74477323292, -122.420207017141) | 2 | 7 | 7 | 28859 | 2 | ||
| 920 | 91853 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 601x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6014039.760938 | 2113573.418065 | 37.7842592071543 | -122.395128082808 | (37.7842592071543, -122.395128082808) | 6 | 2 | 9 | 28856 | 6 | ||
| 7309 | 14032 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1245 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2012 12:00:00 AM | 3 | 4X4 | 6008153.5614441 | 2111445.1787375 | 37.7780864807987 | -122.415341604846 | (37.7780864807987, -122.415341604846) | 8 | 2 | 9 | 28853 | 34 | ||
| 9814 | 28339 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007038.71469 | 2100348.34949 | 37.7475544551381 | -122.418411239379 | (37.7475544551381, -122.418411239379) | 2 | 7 | 7 | 28859 | 2 | ||
| 9871 | 91779 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1184 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6010158.993686 | 2109919.902048 | 37.7740109351691 | -122.408296453122 | (37.7740109351691, -122.408296453122) | 8 | 2 | 9 | 28853 | 34 | ||
| 14266 | 104341 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 953 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2013 12:00:00 AM | 3x3 | Permit Number 770725 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | ||
| 15454 | 28326 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3284 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006311.45985 | 2099177.31377 | 37.7442980895932 | -122.420842920924 | (37.7442980895932, -122.420842920924) | 2 | 7 | 7 | 28859 | 2 | ||
| 16919 | 27303 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4339 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5994091.63002 | 2114139.77761 | 37.7846847585801 | -122.464182179248 | (37.7846847585801, -122.464182179248) | 11 | 6 | 2 | 54 | 11 | |||
| 18997 | 146023 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 211 Cornwall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5994760.92974 | 2114191.03867 | 37.7848640608675 | -122.46187036015 | (37.7848640608675, -122.46187036015) | 11 | 6 | 2 | 54 | 11 | |||
| 20292 | 41297 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 135 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2000 12:00:00 AM | 18 | Permit Number 41974 | 6006066.97178257 | 2108901.70025465 | 37.770985207585 | -122.422379113504 | (37.770985207585, -122.422379113504) | 8 | 2 | 9 | 28853 | 19 | ||
| 21126 | 27305 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4405 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5993893.05463 | 2114093.73932 | 37.7845469027899 | -122.464865833974 | (37.7845469027899, -122.464865833974) | 11 | 6 | 2 | 54 | 11 | |||
| 24063 | 91815 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2601 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008917.295639 | 2103308.711999 | 37.755788521075 | -122.412124384346 | (37.755788521075, -122.412124384346) | 2 | 4 | 7 | 28859 | 19 | ||
| 25067 | 91795 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 500x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 775014 | 6014662.1325 | 2114223.547757 | 37.7860789052247 | -122.39302038306 | (37.7860789052247, -122.39302038306) | 6 | 2 | 9 | 28855 | 6 | |
| 26282 | 2872 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1408 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 6007572.07583 | 2116196.88046 | 37.7911008000132 | -122.417690060515 | (37.7911008000132, -122.417690060515) | 5 | 1 | 10 | 28858 | 21 | ||
| 26852 | 23014 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 790 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006206.16059 | 2105091.96533 | 37.7605324270074 | -122.421627026238 | (37.7605324270074, -122.421627026238) | 2 | 4 | 5 | 28859 | 19 | |||
| 27805 | 49020 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 507 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.396149816377 | (37.7883441634439, -122.396149816377) | 6 | 2 | 9 | 28855 | 6 | |||
| 27923 | 28655 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3395 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6006036.04282 | 2098446.39955 | 37.7422756364725 | -122.421743350168 | (37.7422756364725, -122.421743350168) | 2 | 7 | 7 | 28859 | 2 | ||
| 31330 | 28335 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3221 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006572.11195 | 2099482.47917 | 37.7451506932372 | -122.419963290861 | (37.7451506932372, -122.419963290861) | 2 | 7 | 7 | 28859 | 2 | ||
| 31354 | 5288 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1450 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 01/01/2010 12:00:00 AM | 3 | 3X3 | 6001279.3901091 | 2113342.5749494 | 37.7829074983832 | -122.439257816981 | (37.7829074983832, -122.439257816981) | 15 | 5 | 11 | 29490 | 41 | ||
| 34558 | 28331 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3281 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006413.77303 | 2099188.67497 | 37.7443350512574 | -122.420489949359 | (37.7443350512574, -122.420489949359) | 2 | 7 | 7 | 28859 | 2 | ||
| 39073 | 27258 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 690 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
| 39865 | 26270 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 16 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2015 10:26:00 AM | 3 | 3X3 | 6006157.7043564 | 2098703.0541301 | 37.7429872120583 | -122.42134090318 | (37.7429872120583, -122.42134090318) | 2 | 7 | 7 | 28859 | 2 | ||
| 42186 | 15613 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3435 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2004 12:00:00 AM | 6 | 3x3 | 6005895.33669 | 2098270.89959 | 37.7417858175205 | -122.422217403662 | (37.7417858175205, -122.422217403662) | 2 | 7 | 7 | 28859 | 2 | ||
| 43063 | 13918 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1077 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2015 08:31:00 AM | 3 | 4X4 | 6009171.9340081 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | 14 | 2 | 9 | 28853 | 34 | ||
| 43112 | 26878 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 275 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | Permit Number 771536 | 6006101 | 2108089 | 37.7687556461675 | -122.422203660432 | (37.7687556461675, -122.422203660432) | 8 | 4 | 7 | 28853 | 19 | ||
| 43287 | 91814 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2621 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008916 | 2103203 | 37.7554981871043 | -122.412121394411 | (37.7554981871043, -122.412121394411) | 2 | 4 | 7 | 28859 | 19 | ||
| 50243 | 26639 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 6530X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 80 | 5 | 5987349.71414 | 2113973.97564 | 37.783838627391 | -122.487494476151 | (37.783838627391, -122.487494476151) | 11 | 6 | 1 | 55 | 33 | ||
| 51452 | 2624 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781445 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | 13 | 9 | 11 | 28858 | 27 | |
| 51845 | 116302 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1550 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | |||||
| 52938 | 28045 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
| 53422 | 84564 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
| 54616 | 13948 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1112X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/1994 12:00:00 AM | 12 | 4x4 | 6008868.4803223 | 2112239.1730786 | 37.7803067555436 | -122.412924586563 | (37.7803067555436, -122.412924586563) | 7 | 2 | 9 | 28852 | 36 | ||
| 57943 | 95166 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1300X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001355.20441 | 2112906.07306 | 37.7817132894018 | -122.438964239497 | (37.7817132894018, -122.438964239497) | 15 | 5 | 11 | 29490 | 41 | |||
| 57956 | 122512 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 721 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006289 | 2105371 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | 2 | 4 | 7 | 28859 | 19 | |||
| 58214 | 102158 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4300X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 |
| 58809 | 14170 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1776X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2015 10:09:00 AM | 3 | 4x4 | 6005777.896097 | 2109293.199395 | 37.7720438591777 | -122.423406872271 | (37.7720438591777, -122.423406872271) | 7 | 2 | 11 | 28852 | 10 | ||
| 59981 | 27302 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4327 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 5994140.41077 | 2114141.59782 | 37.7846925678068 | -122.464013547575 | (37.7846925678068, -122.464013547575) | 11 | 6 | 2 | 54 | 11 | |||
| 61352 | 27964 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 61354 | 24389 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3641 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6005406.19827 | 2096949.60563 | 37.7381302401684 | -122.423814755555 | (37.7381302401684, -122.423814755555) | 2 | 7 | 7 | 28859 | 2 | ||
| 66342 | 14084 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1411 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | 4X4 | Permit Number 775519 | 6007340.8551319 | 2110667.3761307 | 37.7759051108463 | -122.418097899429 | (37.7759051108463, -122.418097899429) | 8 | 2 | 9 | 28853 | 34 | |
| 67495 | 3009 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2402 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2012 12:00:00 AM | 3 | 3x3 | 6002808.01196 | 2115517.13179 | 37.7889651474795 | -122.434124927834 | (37.7889651474795, -122.434124927834) | 13 | 9 | 1 | 29490 | 27 | ||
| 67522 | 5221 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1009X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2005 12:00:00 AM | 5 | 3X3 | 6001407.0548 | 2111843.67263 | 37.7787991574032 | -122.438708711528 | (37.7787991574032, -122.438708711528) | 15 | 5 | 11 | 29490 | 41 | ||
| 69655 | 122511 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 715 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x6 | 6006287 | 2105397 | 37.7613745389022 | -122.421369101713 | (37.7613745389022, -122.421369101713) | 2 | 4 | 7 | 28859 | 19 | |||
| 70694 | 23003 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 740X Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1994 12:00:00 AM | 8 | 3X3 | 6006197 | 2105252 | 37.7609713282095 | -122.421670075458 | (37.7609713282095, -122.421670075458) | 2 | 4 | 5 | 28859 | 19 | ||
| 73894 | 91794 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 700x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6013352.664153 | 2112972.090127 | 37.7825698655965 | -122.397463025411 | (37.7825698655965, -122.397463025411) | 6 | 2 | 9 | 28856 | 34 | ||
| 75312 | 28323 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3100 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 11 | 4x4 | 6007076.90394 | 2100561.83623 | 37.7481427912413 | -122.418294317161 | (37.7481427912413, -122.418294317161) | 2 | 4 | 7 | 28859 | 2 | ||
| 75983 | 91335 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
| 77944 | 27674 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | 7 | 9 | 9 | 28852 | 36 | |||
| 78850 | 23383 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1451X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/1999 12:00:00 AM | 10 | 3X3 | 6006248.25114 | 2115440.18145 | 37.7889485091226 | -122.42221667202 | (37.7889485091226, -122.42221667202) | 13 | 9 | 1 | 28858 | 41 | ||
| 79199 | 84561 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1095X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) | 2 | 4 | 5 | 28862 | 22 |
| 81937 | 16723 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1075 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2012 12:00:00 AM | 3 | 4X4 | 6006252.84558 | 2113856.064 | 37.7845991729485 | -122.422088192257 | (37.7845991729485, -122.422088192257) | 7 | 9 | 11 | 28858 | 41 | ||
| 81977 | 15597 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3281 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2013 12:00:00 AM | 9 | 3X3 | 6006413.8 | 2099188.7 | 37.7443351215041 | -122.420489857879 | (37.7443351215041, -122.420489857879) | 2 | 7 | 7 | 28859 | 2 | ||
| 82500 | 112842 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 604 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2015 12:00:00 AM | Permit Number 773221 | 5992274.9 | 2111288.5 | 37.7767510524606 | -122.470259695975 | (37.7767510524606, -122.470259695975) | 11 | 6 | 2 | 54 | 11 | |||
| 84052 | 13946 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1108 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/08/1999 12:00:00 AM | 12 | 4x4 | 6008893.4024674 | 2112262.9816205 | 37.7803735270406 | -122.412840052753 | (37.7803735270406, -122.412840052753) | 7 | 2 | 9 | 28852 | 36 | ||
| 86603 | 116285 | Undocumented 4 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1901X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009504.70132 | 2120333.42493 | 37.8025672995432 | -122.41129555893 | (37.8025672995432, -122.41129555893) | 3 | 1 | 10 | 308 | 23 | |||||
| 93141 | 23203 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 590 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1999 12:00:00 AM | 8 | 3x3 | 6006785.52098 | 2112480.30357 | 37.7808516993941 | -122.420147639969 | (37.7808516993941, -122.420147639969) | 7 | 9 | 9 | 28852 | 36 | ||
| 93447 | 27256 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 660X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006717.7455722 | 2112795.3484565 | 37.7817129170403 | -122.420404476934 | (37.7817129170403, -122.420404476934) | 7 | 9 | 9 | 28852 | 36 | |||
| 97976 | 13567 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 484X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 6 | 4x4 | 6012939.9788554 | 2116125.819916 | 37.791206285852 | -122.399112186297 | (37.791206285852, -122.399112186297) | 4 | 2 | 10 | 28860 | 6 | ||
| 100369 | 91768 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008825.910209 | 2108635.634966 | 37.7704098999414 | -122.412817017344 | (37.7704098999414, -122.412817017344) | 8 | 2 | 9 | 28853 | 19 | ||
| 101337 | 95167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1300 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3 | 3x3 | 6001355 | 2112906 | 37.7817130771674 | -122.43896494142 | (37.7817130771674, -122.43896494142) | 15 | 5 | 11 | 29490 | 41 | ||
| 104372 | 28148 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 105019 | 95178 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3 | 3x3 | 6001286.14287 | 2112595.80793 | 37.7808574507306 | -122.439180914838 | (37.7808574507306, -122.439180914838) | 15 | 5 | 11 | 29490 | 41 | ||
| 105085 | 91204 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52043 | 6006233.7 | 2109956.2 | 37.7738900148236 | -122.42187731202 | (37.7738900148236, -122.42187731202) | 7 | 9 | 11 | 28852 | 10 | ||
| 105706 | 91813 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2625 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008924.574272 | 2103174.237398 | 37.7554196925843 | -122.412089709208 | (37.7554196925843, -122.412089709208) | 2 | 4 | 7 | 28859 | 19 | ||
| 108275 | 97789 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 150X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995458 | 2088095 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | 9 | 8 | 6 | 28861 | 24 | ||||
| 114348 | 23005 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 766 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1997 12:00:00 AM | 8 | 3X3 | 6006192.39683 | 2105141.54299 | 37.7606677795421 | -122.421678150262 | (37.7606677795421, -122.421678150262) | 2 | 4 | 5 | 28859 | 19 | ||
| 119087 | 101070 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3018 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768630 | 5999883.5 | 2115123.7 | 37.7877184733225 | -122.444215032048 | (37.7877184733225, -122.444215032048) | 13 | 6 | 1 | 29490 | 27 | |
| 119843 | 28004 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014041.13301 | 2117989.35001 | 37.7963844052449 | -122.39543280592 | (37.7963844052449, -122.39543280592) | 3 | 2 | 10 | 28860 | 6 | ||
| 120690 | 13657 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 619 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6012007.3883744 | 2115123.3531128 | 37.7884017343709 | -122.402268428095 | (37.7884017343709, -122.402268428095) | 12 | 2 | 9 | 28855 | 6 | |||
| 122483 | 14626 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 410X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/05/2001 12:00:00 AM | 20 | 3X3 | 6007165.24508 | 2112272.29684 | 37.7803019512551 | -122.418819229453 | (37.7803019512551, -122.418819229453) | 7 | 9 | 9 | 28852 | 36 | ||
| 124837 | 122515 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x6 | 6006189 | 2105199 | 37.7608253514989 | -122.421693979475 | (37.7608253514989, -122.421693979475) | 2 | 4 | 5 | 28859 | 19 | |||
| 125402 | 13924 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1083 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2004 12:00:00 AM | 16 | 4X4 | 6009134.0341107 | 2112383.6460599 | 37.7807183466268 | -122.41201612229 | (37.7807183466268, -122.41201612229) | 14 | 2 | 9 | 28853 | 34 | ||
| 126438 | 62108 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 295 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773730 | 6006765.73996863 | 2102077.12480026 | 37.7522859081758 | -122.419477800449 | (37.7522859081758, -122.419477800449) | 2 | 4 | 7 | 28859 | 19 |
| 126905 | 243200 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 220 Valencia St | 1 | : | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781817 | 6006037.36793 | 2108352.33176 | 37.7694751030168 | -122.422442472745 | (37.7694751030168, -122.422442472745) | 8 | 4 | 5 | 28853 | 19 | |
| 127325 | 97529 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );