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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) |
| 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) | ||
| 88902 | 88902 | 14084 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1411 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | 4X4 | Permit Number 775519 | 6007340.8551319 | 2110667.3761307 | 37.775905110846296 | -122.418097899429 | (37.7759051108463, -122.418097899429) | |
| 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) | ||
| 89442 | 89442 | 27302 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 4327 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5994140.41077 | 2114141.5978200003 | 37.7846925678068 | -122.464013547575 | (37.7846925678068, -122.464013547575) | |||
| 89865 | 89865 | 5231 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1053 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 6 | 3X3 | 6001315.02339 | 2112044.91566 | 37.7793464837663 | -122.43904151019899 | (37.7793464837663, -122.439041510199) | ||
| 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) | ||
| 89981 | 89981 | 5221 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1009X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2005 12:00:00 AM | 5 | 3X3 | 6001407.0548 | 2111843.67263 | 37.7787991574032 | -122.438708711528 | (37.7787991574032, -122.438708711528) | ||
| 90009 | 90009 | 91794 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 700x Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6013352.664153 | 2112972.090127 | 37.7825698655965 | -122.397463025411 | (37.7825698655965, -122.397463025411) | ||
| 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) | ||
| 91903 | 91903 | 84562 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.751495629752704 | -122.429718442511 | (37.7514956297527, -122.429718442511) |
| 92128 | 92128 | 95181 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1301X Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001253.460519999 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | |||
| 93143 | 93143 | 23203 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 590 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1999 12:00:00 AM | 8 | 3x3 | 6006785.5209800005 | 2112480.30357 | 37.780851699394105 | -122.420147639969 | (37.7808516993941, -122.420147639969) | ||
| 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) | ||
| 93262 | 93262 | 84561 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1095X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) |
| 95082 | 95082 | 26877 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 275 Valencia St | 2 | 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) | ||
| 95814 | 95814 | 16723 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1075 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2012 12:00:00 AM | 3 | 4X4 | 6006252.84558 | 2113856.0640000002 | 37.7845991729485 | -122.42208819225701 | (37.7845991729485, -122.422088192257) | ||
| 96143 | 96143 | 23383 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1451X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/1999 12:00:00 AM | 10 | 3X3 | 6006248.25114 | 2115440.18145 | 37.7889485091226 | -122.42221667202 | (37.7889485091226, -122.42221667202) | ||
| 97741 | 97741 | 26653 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2324 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003670.20137 | 2115963.1333 | 37.7902386497824 | -122.43117371613 | (37.7902386497824, -122.43117371613) | |||
| 98269 | 98269 | 91768 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008825.910208999 | 2108635.634966 | 37.7704098999414 | -122.412817017344 | (37.7704098999414, -122.412817017344) | ||
| 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) | ||||
| 99904 | 99904 | 84560 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1095X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) |
| 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) | ||||
| 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) | ||
| 100512 | 100512 | 102122 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 100910 | 100910 | 16721 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1040 O'Farrell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1999 12:00:00 AM | 3 | 4X4 | 6006312.05395 | 2113904.5769700003 | 37.784735716896 | -122.421886798179 | (37.784735716896, -122.421886798179) | ||
| 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) | ||
| 103576 | 103576 | 91854 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 601x Harrison St | 2 | 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) | ||
| 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) | ||
| 104220 | 104220 | 62108 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 295 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773730 | 6006765.73996863 | 2102077.12480026 | 37.7522859081758 | -122.419477800449 | (37.7522859081758, -122.419477800449) |
| 104237 | 104237 | 102123 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 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) | |||
| 104409 | 104409 | 91847 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 855 HARRISON ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443.0 | 2111954.0 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | ||
| 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) | ||||
| 104687 | 104687 | 23005 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 766 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1997 12:00:00 AM | 8 | 3X3 | 6006192.39683 | 2105141.54299 | 37.7606677795421 | -122.421678150262 | (37.7606677795421, -122.421678150262) | ||
| 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) | ||||
| 105092 | 105092 | 91844 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 855 HARRISON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443.0 | 2111954.0 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | ||
| 105472 | 105472 | 5837 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 850X Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2015 12:00:00 AM | 6 | 3x3 | 6006360.7801 | 2113218.82973 | 37.7828555709323 | -122.421669498691 | (37.7828555709323, -122.421669498691) | ||
| 105614 | 105614 | 91846 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 855 HARRISON ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6012443.0 | 2111954.0 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | ||
| 105849 | 105849 | 95180 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1301X Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001253.460519999 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | |||
| 106328 | 106328 | 28369 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 352-360 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 3 | 3X3 | 6011197.0 | 2111276.0 | 37.7777925370097 | -122.40480128596201 | (37.7777925370097, -122.404801285962) | ||
| 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) | |||
| 107046 | 107046 | 91849 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 855 HARRISON ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 8 | 3x3 | 6012443.0 | 2111954.0 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | ||
| 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) | ||||
| 108015 | 108015 | 78666 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 600X Bowdoin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008870.67132607 | 2093251.69361296 | 37.7281715390597 | -122.411575098353 | (37.7281715390597, -122.411575098353) | |
| 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) | ||||
| 108459 | 108459 | 5275 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1325 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001243.83619 | 2112984.00007 | 37.781920920014294 | -122.439355107677 | (37.7819209200143, -122.439355107677) | |||
| 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) | |||
| 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) | |||
| 115045 | 115045 | 84557 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1111X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.75150164846921 | -122.42961857746599 | (37.7515016484692, -122.429618577466) |
| 115090 | 115090 | 95179 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1301X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2008 12:00:00 AM | 3 | 3x3 | 6001253.460519999 | 2112914.04483 | 37.781729388453 | -122.439316796194 | (37.781729388453, -122.439316796194) | ||
| 115166 | 115166 | 27307 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 4431 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5993817.95209 | 2114090.93355 | 37.7845348684789 | -122.465125457344 | (37.7845348684789, -122.465125457344) | |||
| 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) | |||
| 116826 | 116826 | 14083 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1411 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2004 12:00:00 AM | 3 | 4X4 | 6007365.6919502 | 2110691.1561735 | 37.775971803050496 | -122.418013668426 | (37.7759718030505, -122.418013668426) | ||
| 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) | ||
| 117681 | 117681 | 28324 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3120 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2004 12:00:00 AM | 3 | 4X4 | 6006915.49742 | 2100327.3639700003 | 37.7474898965029 | -122.41883582998999 | (37.7474898965029, -122.41883582999) | ||
| 118072 | 118072 | 23013 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 780 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006206.16059 | 2105091.96533 | 37.7605324270074 | -122.421627026238 | (37.7605324270074, -122.421627026238) | |||
| 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) | ||
| 118956 | 118956 | 84563 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.751495629752704 | -122.429718442511 | (37.7514956297527, -122.429718442511) |
| 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) | |
| 121382 | 121382 | 5205 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 781 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/28/2015 07:08:00 AM | 3 | 4X4 | 6001514.7755792 | 2111067.8471612 | 37.776675063930504 | -122.438280468838 | (37.7766750639305, -122.438280468838) | |
| 121399 | 121399 | 27499 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3478X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997784.225 | 2114880.84142 | 37.786931659649 | -122.451460562094 | (37.786931659649, -122.451460562094) | |||
| 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) | |||
| 122650 | 122650 | 102121 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 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) | ||
| 124063 | 124063 | 91853 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 601x Harrison St | 1 | 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) | ||
| 124168 | 124168 | 103088 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 256 SHIPLEY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011387.0 | 2111652.0 | 37.7788355638527 | -122.404170475964 | (37.7788355638527, -122.404170475964) |
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");