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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | ||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 88440 | 88440 | 116286 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 89246 | 89246 | 91335 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 90 Gough St | 1 | 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) | ||
| 89720 | 89720 | 116304 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 89921 | 89921 | 104164 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2000 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.781718266066605 | -122.43943438946 | (37.7817182660666, -122.43943438946) | ||
| 90747 | 90747 | 109763 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 899 VALENCIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | ||
| 90870 | 90870 | 116303 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 92543 | 92543 | 116287 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 93144 | 93144 | 91336 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 90 Gough St | 2 | 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) | ||
| 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) | |||
| 94547 | 94547 | 116285 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 98431 | 98431 | 116227 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 99378 | 99378 | 97789 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 150X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995458.0 | 2088095.0 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | ||||
| 100093 | 100093 | 111373 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | ||||
| 100230 | 100230 | 116306 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 100308 | 100308 | 91204 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 90 Gough St | 1 | 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) | ||
| 102107 | 102107 | 105854 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3440 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2014 12:00:00 AM | 3x3 | Permit Number 771130 | 5998402.1 | 2115236.7 | 37.7879441154945 | -122.449348514051 | (37.7879441154945, -122.449348514051) | ||
| 104356 | 104356 | 94527 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1545 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2010 12:00:00 AM | Permit Number 53714 | 6001163.0 | 2113666.0 | 37.7837889169409 | -122.439683671841 | (37.7837889169409, -122.439683671841) | |||
| 104471 | 104471 | 106964 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 275 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 771536 | 6006216.687469999 | 2108092.2365599996 | 37.76877105765121 | -122.42180373539401 | (37.7687710576512, -122.421803735394) | ||||
| 104628 | 104628 | 116305 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 104709 | 104709 | 111377 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | ||||
| 106740 | 106740 | 92087 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 710 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52197 | 6010351.0 | 2116200.0 | 37.7912653498297 | -122.408075252992 | (37.7912653498297, -122.408075252992) | |||
| 107041 | 107041 | 49022 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 507 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.39614981637699 | (37.7883441634439, -122.396149816377) | |||
| 107183 | 107183 | 97790 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 150X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995458.0 | 2088095.0 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | ||||
| 108212 | 108212 | 111370 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | ||||
| 108909 | 108909 | 116293 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 109942 | 109942 | 101514 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 240X DRUMM ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11/30/2012 12:00:00 AM | 3x3 | Permit Number 769442 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||
| 110874 | 110874 | 49019 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 507 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.39614981637699 | (37.7883441634439, -122.396149816377) | |||
| 110949 | 110949 | 116228 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 111377 | 111377 | 100408 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 201 Franklin St | 4 | 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) | |||
| 111444 | 111444 | 116288 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 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) | ||
| 115998 | 115998 | 49021 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 507 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.39614981637699 | (37.7883441634439, -122.396149816377) | |||
| 117393 | 117393 | 109765 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 899 VALENCIA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | ||
| 118321 | 118321 | 104166 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2000 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.781718266066605 | -122.43943438946 | (37.7817182660666, -122.43943438946) | ||
| 121932 | 121932 | 100715 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 507 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013735.0 | 2115044.0 | 37.7882801326001 | -122.39628556098499 | (37.7882801326001, -122.396285560985) | |||
| 123347 | 123347 | 116289 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 123538 | 123538 | 104341 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 953 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2013 12:00:00 AM | 3x3 | Permit Number 770725 | 6015057.1 | 2104275.7 | 37.758786250670205 | -122.39095836980302 | (37.7587862506702, -122.390958369803) | ||
| 124383 | 124383 | 97792 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 150X Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995458.0 | 2088095.0 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | ||||
| 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) | ||||
| 124718 | 124718 | 91343 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 90 Gough St | 3 | 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) | ||
| 124834 | 124834 | 49020 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 507 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013774.69039299 | 2115066.5155164 | 37.7883441634439 | -122.39614981637699 | (37.7883441634439, -122.396149816377) | |||
| 124949 | 124949 | 104165 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2000 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.781718266066605 | -122.43943438946 | (37.7817182660666, -122.43943438946) | ||
| 126279 | 126279 | 41431 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 352-360 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2005 12:00:00 AM | Permit Number 42039 | 6011197.0 | 2111276.0 | 37.7777925370097 | -122.40480128596201 | (37.7777925370097, -122.404801285962) | |||
| 126438 | 126438 | 91205 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 90 Gough St | 2 | 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) | ||
| 127160 | 127160 | 104167 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2000 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.781718266066605 | -122.43943438946 | (37.7817182660666, -122.43943438946) | ||
| 129070 | 129070 | 100407 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 201 Franklin St | 3 | 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) | |||
| 138967 | 138967 | 111375 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 222 Stanyan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996693.0 | 2111182.0 | 37.776713072168704 | -122.454968563419 | (37.7767130721687, -122.454968563419) | ||||
| 139446 | 139446 | 116292 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 139598 | 139598 | 109764 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 899 VALENCIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | ||
| 141307 | 141307 | 109766 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 899 VALENCIA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | ||
| 143007 | 143007 | 85036 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 977 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002333.0 | 2109831.0 | 37.7733254935974 | -122.435361498487 | (37.7733254935974, -122.435361498487) | |||||
| 143393 | 143393 | 97791 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 150X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995458.0 | 2088095.0 | 37.7132509964384 | -122.457569958917 | (37.7132509964384, -122.457569958917) | ||||
| 143534 | 143534 | 53296 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 4124 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50423 | 6002335.15488349 | 2102402.29787451 | 37.7529282071332 | -122.434822699235 | (37.7529282071332, -122.434822699235) | ||
| 145936 | 145936 | 59740 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 4301 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001257.45272634 | 2101704.38356178 | 37.7509506561918 | -122.43849958866801 | (37.7509506561918, -122.438499588668) | ||
| 120217 | 120217 | 109761 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 899 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | 3x3 | Permit Number 772584 | 6006382.7 | 2104441.4 | 37.7587560793788 | -122.420970264824 | (37.7587560793788, -122.420970264824) | |
| 103982 | 103982 | 3220 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3838 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2012 12:00:00 AM | 2 | 3x3 | 5995990.5445804 | 2114559.6929387003 | 37.785946997123396 | -122.457643002187 | (37.7859469971234, -122.457643002187) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
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");