Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97457 | 97457 | 6 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4949X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5992285.036119999 | 2114103.37756 | 37.784480522922394 | -122.470429683488 | (37.7844805229224, -122.470429683488) | |||
| 110072 | 110072 | 18 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2801X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5992314.354430901 | 2097139.1969018 | 37.737903049839396 | -122.469093199098 | (37.7379030498394, -122.469093199098) | |||
| 114915 | 114915 | 19 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2801X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5992314.354430901 | 2097139.1969018 | 37.737903049839396 | -122.469093199098 | (37.7379030498394, -122.469093199098) | |||
| 128627 | 128627 | 20 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2810X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5992369.501524299 | 2097155.3271501 | 37.7379505257286 | -122.468903703785 | (37.7379505257286, -122.468903703785) | |||
| 83534 | 83534 | 21 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2810X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5992369.501524299 | 2097155.3271501 | 37.7379505257286 | -122.468903703785 | (37.7379505257286, -122.468903703785) | |||
| 9511 | 9511 | 161 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5240X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5991235.99739 | 2114119.3924 | 37.784463784314 | -122.474060130881 | (37.784463784314, -122.474060130881) | |||
| 9320 | 9320 | 163 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2790X 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5991861.232316299 | 2096712.8875626998 | 37.7367063200182 | -122.470628807941 | (37.7367063200182, -122.470628807941) | |||
| 9074 | 9074 | 164 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2790X 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5991861.232316299 | 2096712.8875626998 | 37.7367063200182 | -122.470628807941 | (37.7367063200182, -122.470628807941) | |||
| 117989 | 117989 | 175 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5400X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990796.10602 | 2114048.44446 | 37.7842434899767 | -122.475576806045 | (37.7842434899767, -122.475576806045) | |||
| 9574 | 9574 | 176 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5340X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5990964.24262 | 2114110.49658 | 37.784423613403504 | -122.474999649931 | (37.7844236134035, -122.474999649931) | |||
| 9525 | 9525 | 177 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5340X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5990912.96055 | 2114105.91561 | 37.7844080632129 | -122.47517673183799 | (37.7844080632129, -122.475176731838) | |||
| 107070 | 107070 | 200 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5604X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4x4 | 5990186.04567 | 2114081.13509 | 37.784297864805104 | -122.477689766774 | (37.7842978648051, -122.477689766774) | |||
| 18237 | 18237 | 203 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2912 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/02/1994 12:00:00 AM | 20 | 2X3 | 5990600.62302 | 2095815.8473599998 | 37.7341702996075 | -122.474921777626 | (37.7341702996075, -122.474921777626) | ||
| 18704 | 18704 | 204 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2912 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1994 12:00:00 AM | 20 | 2X3 | 5990598.496180001 | 2095837.8189400001 | 37.7342305047257 | -122.474930733974 | (37.7342305047257, -122.474930733974) | ||
| 21686 | 21686 | 205 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2918 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1994 12:00:00 AM | 10 | 2X3 | 5990601.803119999 | 2095779.7077 | 37.734071137676295 | -122.474915060599 | (37.7340711376763, -122.474915060599) | ||
| 12562 | 12562 | 206 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2919 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 6 | 2X3 | 5990516.43657 | 2095785.37905 | 37.734081762249296 | -122.475210610191 | (37.7340817622493, -122.475210610191) | ||
| 20959 | 20959 | 208 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2924 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1994 12:00:00 AM | 7 | 3x3 | 5990600.55143 | 2095720.40284 | 37.7339082290639 | -122.4749150606 | (37.7339082290639, -122.4749150606) | ||
| 18108 | 18108 | 215 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2940 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 18 | 2X3 | 5990603.87201 | 2095662.9362299999 | 37.733750632784705 | -122.47489938720699 | (37.7337506327847, -122.474899387207) | ||
| 21117 | 21117 | 216 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2944 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 20 | 3X3 | 5990608.35114 | 2095598.99571 | 37.7335753279252 | -122.474879236093 | (37.7335753279252, -122.474879236093) | ||
| 18299 | 18299 | 217 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2944 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 18 | 2X3 | 5990605.54964 | 2095619.69203 | 37.733631992415106 | -122.47489043175501 | (37.7336319924151, -122.474890431755) | ||
| 17759 | 17759 | 220 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2950 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 10 | 3X3 | 5990607.61646 | 2095564.18629 | 37.7334797075204 | -122.474879236111 | (37.7334797075204, -122.474879236111) | ||
| 12873 | 12873 | 221 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2955 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2008 12:00:00 AM | 6 | 2X3 | 5990527.06047 | 2095552.3434400002 | 37.7334425214563 | -122.47515687389799 | (37.7334425214563, -122.475156873898) | ||
| 17208 | 17208 | 223 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2956 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1995 12:00:00 AM | 20 | 2X3 | 5990609.51977 | 2095500.9447299999 | 37.733306172547 | -122.474868041348 | (37.733306172547, -122.474868041348) | ||
| 13169 | 13169 | 226 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2965 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2X3 | 5990527.81867 | 2095496.22007 | 37.7332884648813 | -122.475150156876 | (37.7332884648813, -122.475150156876) | |||
| 12538 | 12538 | 230 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2 | 5990529.537280001 | 2095454.9094099998 | 37.7331751359068 | -122.475141200505 | (37.7331751359068, -122.475141200505) | |||
| 11508 | 11508 | 231 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2975 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2000 12:00:00 AM | 16 | 2 | 5990528.9249599995 | 2095425.9012900002 | 37.7330954514847 | -122.475141200519 | (37.7330954514847, -122.475141200519) | ||
| 11341 | 11341 | 241 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990539.35496 | 2095091.6143599998 | 37.73217818885811 | -122.47508074718701 | (37.7321781888581, -122.475080747187) | ||
| 11685 | 11685 | 242 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990541.155259999 | 2095054.1708099998 | 37.7320754826964 | -122.47507179083401 | (37.7320754826964, -122.475071790834) | ||
| 12400 | 12400 | 243 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3027 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990541.3262 | 2095031.59495 | 37.732013505011295 | -122.475069552433 | (37.7320135050113, -122.475069552433) | ||
| 11463 | 11463 | 244 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3027 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 20 | 2 | 5990542.03599 | 2095003.8484200002 | 37.731937361205 | -122.475065073818 | (37.731937361205, -122.475065073818) | ||
| 21416 | 21416 | 245 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1994 12:00:00 AM | 12 | 2x3 | 5990627.42638 | 2094968.5100900002 | 37.7318452796259 | -122.4747672858 | (37.7318452796259, -122.4747672858) | ||
| 20642 | 20642 | 248 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3050 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1994 12:00:00 AM | 20 | 2 | 5990629.27539 | 2094902.6887400001 | 37.7316646579979 | -122.474756091044 | (37.7316646579979, -122.474756091044) | ||
| 21787 | 21787 | 249 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3060 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1994 12:00:00 AM | 7 | 2 | 5990633.958819999 | 2094848.4163099998 | 37.7315159110224 | -122.47473593992201 | (37.7315159110224, -122.474735939922) | ||
| 21075 | 21075 | 253 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3070 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1994 12:00:00 AM | 10 | 2 | 5990634.6279 | 2094818.7355900002 | 37.7314344540416 | -122.474731461301 | (37.7314344540416, -122.474731461301) | ||
| 20224 | 20224 | 254 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3080 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 12:00:00 AM | 13 | 2 | 5990635.11986 | 2094780.67442 | 37.7313299761991 | -122.474726983585 | (37.7313299761991, -122.474726983585) | ||
| 11974 | 11974 | 256 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3095 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990551.14028 | 2094790.83071 | 37.7313529961409 | -122.475018054557 | (37.7313529961409, -122.475018054557) | |||
| 20338 | 20338 | 260 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4x4 | 5990641.60602 | 2094627.68915 | 37.730910293152796 | -122.474693398398 | (37.7309102931528, -122.474693398398) | |||
| 85264 | 85264 | 261 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 12 | 2X3 | 5990658.74483 | 2094624.5636900002 | 37.730902704527395 | -122.474633919299 | (37.7309027045274, -122.474633919299) | ||
| 106654 | 106654 | 264 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3201X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
| 18283 | 18283 | 274 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3210 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 20 | 2X3 | 5990651.757780001 | 2094310.81175 | 37.730040816024704 | -122.47463518438101 | (37.7300408160247, -122.474635184381) | ||
| 22098 | 22098 | 275 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3210 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 20 | 2X3 | 5990662.18152 | 2094375.08558 | 37.7302178997362 | -122.47460383761299 | (37.7302178997362, -122.474603837613) | ||
| 12261 | 12261 | 285 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1998 12:00:00 AM | 20 | 2 | 5990533.55676 | 2093865.7150400002 | 37.728811842983106 | -122.47501133751999 | (37.7288118429831, -122.47501133752) | ||
| 13129 | 13129 | 286 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1998 12:00:00 AM | 20 | 2 | 5990533.76855 | 2093845.0720799998 | 37.728755174887795 | -122.475009099088 | (37.7287551748878, -122.475009099088) | ||
| 12467 | 12467 | 288 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 18 | 2 | 5990528.50995 | 2093780.0430700001 | 37.7285763168388 | -122.475022533176 | (37.7285763168388, -122.475022533176) | ||
| 10577 | 10577 | 289 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/1994 12:00:00 AM | 25 | 2 | 5990526.76624 | 2093758.79648 | 37.7285178779945 | -122.475027010894 | (37.7285178779945, -122.475027010894) | ||
| 5237 | 5237 | 290 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2017 12:00:00 AM | 25 | 2X2 | 5990524.87284 | 2093730.4583599998 | 37.728439958917704 | -122.47503148863001 | (37.7284399589177, -122.47503148863) | ||
| 5212 | 5212 | 291 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1994 12:00:00 AM | 20 | 2x10 | 5990518.299980001 | 2093633.8541299999 | 37.7281743270786 | -122.475047162015 | (37.7281743270786, -122.475047162015) | ||
| 11895 | 11895 | 292 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990518.982340001 | 2093604.8167400002 | 37.7280946372571 | -122.475042684288 | (37.7280946372571, -122.475042684288) | ||
| 21948 | 21948 | 413 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3854 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 8 | 2X3 | 5990824.06176 | 2090161.99601 | 37.7186591841634 | -122.47373697479401 | (37.7186591841634, -122.473736974794) | ||
| 92749 | 92749 | 425 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5800X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 5989566.99548 | 2114057.22504 | 37.7841962699423 | -122.479829688766 | (37.7841962699423, -122.479829688766) | |||
| 98075 | 98075 | 426 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5750X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5989712.1969 | 2114062.83414 | 37.784220105429 | -122.47932775959801 | (37.784220105429, -122.479327759598) | |||
| 83054 | 83054 | 427 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5750X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5989666.908430001 | 2114060.8985200003 | 37.7842121602686 | -122.479484298226 | (37.7842121602686, -122.479484298226) | |||
| 79980 | 79980 | 433 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5900X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5989228.21331 | 2114045.1734599997 | 37.7841434921695 | -122.481000858329 | (37.7841434921695, -122.481000858329) | |||
| 114813 | 114813 | 675 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3323X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006894.8894879995 | 2102019.509041 | 37.7521349819704 | -122.41902709370001 | (37.7521349819704, -122.4190270937) | |||
| 127039 | 127039 | 676 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3323X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006894.8894879995 | 2102019.509041 | 37.7521349819704 | -122.41902709370001 | (37.7521349819704, -122.4190270937) | |||
| 95526 | 95526 | 695 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6350X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5987883.41225 | 2113998.48777 | 37.7839370417256 | -122.485649902252 | (37.7839370417256, -122.485649902252) | |||
| 77774 | 77774 | 696 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6337X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5987881.546 | 2113941.91653 | 37.7837816044506 | -122.485652205518 | (37.7837816044506, -122.485652205518) | |||
| 102620 | 102620 | 700 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6440X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5987497.2290900005 | 2113983.68287 | 37.783873882692795 | -122.48698484907699 | (37.7838738826928, -122.486984849077) | |||
| 126299 | 126299 | 704 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
| 85390 | 85390 | 705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6640X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5 | 5987010.88181 | 2113961.86712 | 37.783785614219205 | -122.48866580397 | (37.7837856142192, -122.48866580397) | |||
| 145405 | 145405 | 709 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 5 | 5986789.82302 | 2113953.9673099997 | 37.783751021306 | -122.489429993159 | (37.783751021306, -122.489429993159) | |||
| 141614 | 141614 | 710 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6710X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 5 | 5986716.67704 | 2113957.13547 | 37.783755449840996 | -122.489683280356 | (37.783755449841, -122.489683280356) | |||
| 94870 | 94870 | 711 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 140386 | 140386 | 712 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 88068 | 88068 | 713 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6720X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5 | 5986760.01545 | 2113952.9021099997 | 37.783746356447 | -122.489533036385 | (37.783746356447, -122.489533036385) | |||
| 128019 | 128019 | 714 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 5x33 | 5986452.35935 | 2113947.57202 | 37.7837137557398 | -122.490597003715 | (37.7837137557398, -122.490597003715) | |||
| 128102 | 128102 | 715 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6810X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5x33 | 5986402.41509 | 2113942.22606 | 37.7836961598318 | -122.490769396103 | (37.7836961598318, -122.490769396103) | |||
| 138348 | 138348 | 716 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 5x33 | 5986347.76159 | 2113942.4719599998 | 37.783693642189 | -122.490958491989 | (37.783693642189, -122.490958491989) | |||
| 117882 | 117882 | 717 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 5 | 5986305.22988 | 2113941.78658 | 37.783689275454705 | -122.49110558308901 | (37.7836892754547, -122.491105583089) | |||
| 129062 | 129062 | 718 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6820X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 5x33 | 5986263.20776 | 2113937.4435799997 | 37.783674895540706 | -122.491250641927 | (37.7836748955407, -122.491250641927) | |||
| 114035 | 114035 | 719 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6910X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3 | 5986168.89485 | 2113931.77767 | 37.7836538273778 | -122.491576507002 | (37.7836538273778, -122.491576507002) | |||
| 82840 | 82840 | 720 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6910X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 5986168.89485 | 2113931.77767 | 37.7836538273778 | -122.491576507002 | (37.7836538273778, -122.491576507002) | |||
| 119423 | 119423 | 721 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6859X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5986379.68484 | 2113889.27863 | 37.783549453567 | -122.49084413577101 | (37.783549453567, -122.490844135771) | |||
| 91298 | 91298 | 722 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6920X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5986139.11309 | 2113930.71339 | 37.7836491646774 | -122.491679460735 | (37.7836491646774, -122.491679460735) | |||
| 117646 | 117646 | 724 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 6933X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5986042.95345 | 2113873.6493599997 | 37.783486862959705 | -122.492007929 | (37.7834868629597, -122.492007929) | |||
| 84108 | 84108 | 886 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X ALEMANY BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X6 | 6003437.0 | 2094359.0 | 37.7309056628368 | -122.43043846836599 | (37.7309056628368, -122.430438468366) | |||
| 9457 | 9457 | 894 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3X5 | 6003365.90456 | 2094243.1413900002 | 37.730583513638294 | -122.43067599245 | (37.7305835136383, -122.43067599245) | |||
| 9058 | 9058 | 895 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6003365.90456 | 2094243.1413900002 | 37.730583513638294 | -122.43067599245 | (37.7305835136383, -122.43067599245) | |||
| 9338 | 9338 | 897 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X4 | 6003365.90456 | 2094243.1413900002 | 37.730583513638294 | -122.43067599245 | (37.7305835136383, -122.43067599245) | |||
| 9123 | 9123 | 898 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X4 | 6003365.90456 | 2094243.1413900002 | 37.730583513638294 | -122.43067599245 | (37.7305835136383, -122.43067599245) | |||
| 12070 | 12070 | 901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4x4 | 6003468.47317 | 2094282.9713400002 | 37.7306986880783 | -122.4303242382 | (37.7306986880783, -122.4303242382) | |||
| 10760 | 10760 | 902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1175 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4X4 | 6003443.98955 | 2094273.43373 | 37.7306711130822 | -122.430408201588 | (37.7306711130822, -122.430408201588) | |||
| 12118 | 12118 | 905 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1183 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3X3 | 6003394.233080001 | 2094256.01413 | 37.7306204641588 | -122.43057897475599 | (37.7306204641588, -122.430578974756) | |||
| 9088 | 9088 | 907 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1206 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x6 | 6003162.80838 | 2094269.92054 | 37.7306455348647 | -122.431380036745 | (37.7306455348647, -122.431380036745) | |||
| 12349 | 12349 | 910 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1220 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6003088.28944 | 2094244.8616099998 | 37.730572505104 | -122.431635871508 | (37.730572505104, -122.431635871508) | |||
| 12395 | 12395 | 911 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1226 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 5x8 | 6003062.670580001 | 2094235.77356 | 37.7305460992123 | -122.431723791042 | (37.7305460992123, -122.431723791042) | |||
| 103658 | 103658 | 920 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1250 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X6 | 6002950.328840001 | 2094206.9021299998 | 37.7304604561159 | -122.43211011174401 | (37.7304604561159, -122.432110111744) | |||
| 9125 | 9125 | 935 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1296X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x6 | 6002794.708219999 | 2094140.5399099998 | 37.7302694162157 | -122.432643375557 | (37.7302694162157, -122.432643375557) | |||
| 10852 | 10852 | 945 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1418 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002308.48218 | 2093739.6046799999 | 37.7291409525794 | -122.43429566951401 | (37.7291409525794, -122.434295669514) | |||
| 10416 | 10416 | 971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1599 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 6001877.39832 | 2092933.59931 | 37.7269033673725 | -122.43572831651501 | (37.7269033673725, -122.435728316515) | |||
| 13216 | 13216 | 972 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1599 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6001888.30681 | 2092957.5679400002 | 37.7269697994111 | -122.43569232024099 | (37.7269697994111, -122.435692320241) | |||
| 11763 | 11763 | 980 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2015 12:00:00 AM | 16 | 3x3 | 6001812.25191 | 2092793.77395 | 37.726515738 | -122.435943525179 | (37.726515738, -122.435943525179) | ||
| 10675 | 10675 | 982 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1604 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6001730.40867 | 2092823.64801 | 37.7265931156608 | -122.4362285905 | (37.7265931156608, -122.4362285905) | |||
| 10669 | 10669 | 983 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1616 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6001693.07933 | 2092739.79074 | 37.7263607416377 | -122.43635163751699 | (37.7263607416377, -122.436351637517) | |||
| 12202 | 12202 | 987 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1642 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6001628.10442 | 2092593.14767 | 37.7259544009542 | -122.436565760724 | (37.7259544009542, -122.436565760724) | |||
| 12061 | 12061 | 988 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1650 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6001605.56044 | 2092548.13054 | 37.7258295130094 | -122.43664047277299 | (37.7258295130094, -122.436640472773) | |||
| 11798 | 11798 | 990 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1660 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001575.36599 | 2092477.83222 | 37.7256347738177 | -122.43673982271099 | (37.7256347738177, -122.436739822711) | |||
| 11445 | 11445 | 993 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1678 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 4x4 | 6001520.694019999 | 2092363.0865 | 37.725316600860204 | -122.43692060802 | (37.7253166008602, -122.43692060802) | |||
| 12386 | 12386 | 996 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1683 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X6 | 6001571.37803 | 2092269.72252 | 37.7250631251444 | -122.436738718312 | (37.7250631251444, -122.436738718312) | |||
| 10640 | 10640 | 998 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1720 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4X4 | 6001400.68712 | 2092099.7720700002 | 37.7245867776358 | -122.43731661368601 | (37.7245867776358, -122.437316613686) |
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");