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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |
| 105913 | 105913 | 293 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3355 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/1994 12:00:00 AM | 20 | 2 | 5990512.87275 | 2093746.7583599999 | 37.7284840191392 | -122.47507416251301 | (37.7284840191392, -122.475074162513) | ||
| 120667 | 120667 | 270 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3201X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 6 | 2X2 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
| 78109 | 78109 | 207 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2919 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2X3 | 5990501.92231 | 2095794.16798 | 37.7341050531518 | -122.47526143143 | (37.7341050531518, -122.47526143143) | ||
| 91190 | 91190 | 24389 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3641 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6005406.19827 | 2096949.60563 | 37.7381302401684 | -122.423814755555 | (37.7381302401684, -122.423814755555) | ||
| 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) | ||
| 145684 | 145684 | 28327 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3435 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2004 12:00:00 AM | 3 | 3x3 | 6005943.504290001 | 2098256.08104 | 37.741747845924394 | -122.422049803265 | (37.7417478459244, -122.422049803265) | ||
| 80759 | 80759 | 15613 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3435 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2004 12:00:00 AM | 6 | 3x3 | 6005895.33669 | 2098270.89959 | 37.7417858175205 | -122.42221740366199 | (37.7417858175205, -122.422217403662) | ||
| 128351 | 128351 | 28655 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3395 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6006036.04282 | 2098446.39955 | 37.7422756364725 | -122.421743350168 | (37.7422756364725, -122.421743350168) | ||
| 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) | ||
| 143641 | 143641 | 26271 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 16 Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2004 12:00:00 AM | 3 | 3X3 | 6006157.7043564 | 2098703.0541301 | 37.742987212058296 | -122.42134090318001 | (37.7429872120583, -122.42134090318) | ||
| 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) | ||
| 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) | ||
| 128227 | 128227 | 28331 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3281 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006413.773030001 | 2099188.67497 | 37.7443350512574 | -122.420489949359 | (37.7443350512574, -122.420489949359) | ||
| 97215 | 97215 | 15597 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3281 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/03/2013 12:00:00 AM | 9 | 3X3 | 6006413.8 | 2099188.7 | 37.7443351215041 | -122.420489857879 | (37.7443351215041, -122.420489857879) | ||
| 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) | ||
| 89533 | 89533 | 28334 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3241 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2005 12:00:00 AM | 9 | 3X3 | 6006567.490569999 | 2099355.8078400004 | 37.744802621975296 | -122.419970283481 | (37.7448026219753, -122.419970283481) | ||
| 77170 | 77170 | 28335 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3221 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006572.11195 | 2099482.47917 | 37.74515069323721 | -122.41996329086099 | (37.7451506932372, -122.419963290861) | ||
| 113127 | 113127 | 28337 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3209 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 6 | 3X3 | 6006571.86084 | 2099543.08303 | 37.745317083610296 | -122.41996845900299 | (37.7453170836103, -122.419968459003) | ||
| 79881 | 79881 | 97900 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 375X Precita Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x4 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 85201 | 85201 | 28323 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3100 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/2004 12:00:00 AM | 11 | 4x4 | 6007076.903940001 | 2100561.83623 | 37.7481427912413 | -122.41829431716101 | (37.7481427912413, -122.418294317161) | ||
| 94128 | 94128 | 91801 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3071 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009060.650721 | 2100687.104692 | 37.7485982168729 | -122.4114434106 | (37.7485982168729, -122.4114434106) | |||
| 99090 | 99090 | 91802 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2997 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009042.060032 | 2101022.818937 | 37.7495189707644 | -122.411531412589 | (37.7495189707644, -122.411531412589) | |||
| 98203 | 98203 | 91803 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2989 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009039.569733 | 2101067.5188080003 | 37.7496415669707 | -122.41154318187799 | (37.7496415669707, -122.411543181878) | |||
| 123640 | 123640 | 91806 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2945 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009025.873083999 | 2101313.36822 | 37.7503158463726 | -122.411607913685 | (37.7503158463726, -122.411607913685) | |||
| 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) | ||
| 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) |
| 128294 | 128294 | 102160 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 4300X 24th St | 3 | 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) |
| 116389 | 116389 | 91807 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2859 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008997.743306 | 2101817.227115 | 37.7516977523567 | -122.41174078681401 | (37.7516977523567, -122.411740786814) | |||
| 84123 | 84123 | 84564 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.751495629752704 | -122.429718442511 | (37.7514956297527, -122.429718442511) |
| 91903 | 91903 | 84562 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.751495629752704 | -122.429718442511 | (37.7514956297527, -122.429718442511) |
| 118956 | 118956 | 84563 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1100X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.751495629752704 | -122.429718442511 | (37.7514956297527, -122.429718442511) |
| 115045 | 115045 | 84557 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1111X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.75150164846921 | -122.42961857746599 | (37.7515016484692, -122.429618577466) |
| 142483 | 142483 | 84558 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1111X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.75150164846921 | -122.42961857746599 | (37.7515016484692, -122.429618577466) |
| 93262 | 93262 | 84561 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1095X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) |
| 99904 | 99904 | 84560 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1095X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) |
| 100512 | 100512 | 102122 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 104237 | 104237 | 102123 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 122650 | 122650 | 102121 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1090X Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) |
| 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) |
| 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) | ||
| 112780 | 112780 | 91810 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2701x Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008948.888017 | 2102724.532648 | 37.754186268869205 | -122.411973846441 | (37.7541862688692, -122.411973846441) | ||
| 103519 | 103519 | 91813 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2625 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008924.574272 | 2103174.237398 | 37.7554196925843 | -122.41208970920799 | (37.7554196925843, -122.412089709208) | ||
| 95120 | 95120 | 121027 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1101X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6007689.0 | 2103175.0 | 37.7553523831166 | -122.41636276728902 | (37.7553523831166, -122.416362767289) | |||
| 101968 | 101968 | 121026 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1101X South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6007689.0 | 2103175.0 | 37.7553523831166 | -122.41636276728902 | (37.7553523831166, -122.416362767289) | |||
| 142251 | 142251 | 121025 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1101X South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6007689.0 | 2103175.0 | 37.7553523831166 | -122.41636276728902 | (37.7553523831166, -122.416362767289) | |||
| 142941 | 142941 | 121028 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1101X South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6007689.0 | 2103175.0 | 37.7553523831166 | -122.41636276728902 | (37.7553523831166, -122.416362767289) | |||
| 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) | ||
| 125812 | 125812 | 91815 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2601 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008917.295639 | 2103308.711999 | 37.755788521075 | -122.41212438434601 | (37.755788521075, -122.412124384346) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 94022 | 94022 | 91821 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2395x Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008850.144084 | 2104529.130727 | 37.7591357459563 | -122.41244287861099 | (37.7591357459563, -122.412442878611) | ||
| 112879 | 112879 | 91820 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2395x Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008850.144084 | 2104529.130727 | 37.7591357459563 | -122.41244287861099 | (37.7591357459563, -122.412442878611) | ||
| 121403 | 121403 | 91822 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2345 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008829.344656 | 2104857.3288080003 | 37.7600357358129 | -122.41253801314801 | (37.7600357358129, -122.412538013148) | ||
| 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) | |||
| 128063 | 128063 | 23014 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 790 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006206.16059 | 2105091.96533 | 37.7605324270074 | -122.421627026238 | (37.7605324270074, -122.421627026238) | |||
| 106803 | 106803 | 122821 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 777 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6006304.0 | 2105101.0 | 37.7605627505881 | -122.421289285481 | (37.7605627505881, -122.421289285481) | |||
| 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) | ||
| 109523 | 109523 | 122515 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x6 | 6006189.0 | 2105199.0 | 37.7608253514989 | -122.42169397947501 | (37.7608253514989, -122.421693979475) | |||
| 90807 | 90807 | 23003 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 740X Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 8 | 3X3 | 6006197.0 | 2105252.0 | 37.7609713282095 | -122.421670075458 | (37.7609713282095, -122.421670075458) | ||
| 88982 | 88982 | 122512 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 721 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x6 | 6006289.0 | 2105371.0 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | |||
| 101868 | 101868 | 122513 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 721 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x6 | 6006289.0 | 2105371.0 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | |||
| 84669 | 84669 | 122511 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 715 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x6 | 6006287.0 | 2105397.0 | 37.7613745389022 | -122.42136910171301 | (37.7613745389022, -122.421369101713) | |||
| 118473 | 118473 | 25176 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3066 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2006 12:00:00 AM | 3 | 3X3 | Permit Number 772743 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.44261677830299 | (37.7611492576992, -122.442616778303) | |
| 123080 | 123080 | 91825 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2147 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008764.72509 | 2105924.0732650002 | 37.7629611450186 | -122.412836921531 | (37.7629611450186, -122.412836921531) | ||
| 96822 | 96822 | 103745 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1999X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008051.81901 | 2107091.2259400003 | 37.766125834179704 | -122.41538525721201 | (37.7661258341797, -122.415385257212) | ||
| 111773 | 111773 | 91829 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1941 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.41312959117799 | (37.7664314036014, -122.413129591178) | ||
| 122201 | 122201 | 91827 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1941 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.41312959117799 | (37.7664314036014, -122.413129591178) | ||
| 126965 | 126965 | 91828 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1941 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008705.970676 | 2107189.131 | 37.7664314036014 | -122.41312959117799 | (37.7664314036014, -122.413129591178) | ||
| 118782 | 118782 | 14316 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2190X Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2004 12:00:00 AM | 3 | 4X4 | 6003585.7913445 | 2107202.1800301997 | 37.7661784627239 | -122.430840279858 | (37.7661784627239, -122.430840279858) | ||
| 124340 | 124340 | 14315 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/22/2000 12:00:00 AM | 6 | 4X4 | 6003585.7913445 | 2107202.1800301997 | 37.7661784627239 | -122.430840279858 | (37.7661784627239, -122.430840279858) | ||
| 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) | ||
| 82777 | 82777 | 85446 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 88231 | 88231 | 85433 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y1 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 95845 | 95845 | 85448 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y14 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 96265 | 96265 | 85437 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y4 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 97533 | 97533 | 85444 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y10 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 98712 | 98712 | 85439 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y5 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 99579 | 99579 | 85445 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y11 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 102642 | 102642 | 85435 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y3 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/07/2006 12:00:00 AM | 3 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 103498 | 103498 | 85440 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y6 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 105788 | 105788 | 85443 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y9 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | ||||
| 122914 | 122914 | 85441 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y7 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 123072 | 123072 | 85434 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y2 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/23/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 126348 | 126348 | 85447 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 143542 | 143542 | 85442 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 360Y8 Valencia St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | |||
| 123833 | 123833 | 91830 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1849 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008677.188747 | 2107760.2433169996 | 37.7679979296822 | -122.413269533592 | (37.7679979296822, -122.413269533592) | ||
| 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) | ||
| 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) |
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");