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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19970 | 19970 | 191 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3016 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2015 03:04:00 PM | 3 | 4X4 | 6006680.54829 | 2106746.56856 | 37.765102318639705 | -122.420103759676 | (37.7651023186397, -122.420103759676) | ||
18609 | 18609 | 192 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 385X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/09/2013 12:00:00 AM | 3 | 3X3 | 6005547.989469999 | 2106715.71324 | 37.7649537200544 | -122.424018813443 | (37.7649537200544, -122.424018813443) | ||
17890 | 17890 | 193 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 423X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2008 12:00:00 AM | 3 | 3X3 | 6005562.55526 | 2106507.52991 | 37.764382920371496 | -122.423953628772 | (37.7643829203715, -122.423953628772) | ||
17148 | 17148 | 197 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002246.85388 | 2106423.49653 | 37.7639644352284 | -122.43541568967899 | (37.7639644352284, -122.435415689679) | |||
100426 | 100426 | 199 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1621X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5990403.2095800005 | 2114714.97277 | 37.7860508060194 | -122.476984794344 | (37.7860508060194, -122.476984794344) | |||
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) | |||
88096 | 88096 | 201 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1800X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X6 | 5989853.087040001 | 2114748.48442 | 37.7861108905335 | -122.478890501056 | (37.7861108905335, -122.478890501056) | |||
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) | ||
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) | ||
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) | ||
21279 | 21279 | 209 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2924 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 5990600.52986 | 2095750.0689299998 | 37.7339896833587 | -122.474917299886 | (37.7339896833587, -122.474917299886) | |||
12433 | 12433 | 211 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2929 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 5990523.61376 | 2095726.5411900003 | 37.7339206244383 | -122.475181502724 | (37.7339206244383, -122.475181502724) | |||
21373 | 21373 | 212 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2930 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 5990603.05334 | 2095685.5251099998 | 37.7338126086681 | -122.474903865842 | (37.7338126086681, -122.474903865842) | |||
11219 | 11219 | 213 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2933 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 5990523.08308 | 2095701.4011400002 | 37.7338515654947 | -122.475181502731 | (37.7338515654947, -122.475181502731) | |||
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) | ||
12021 | 12021 | 219 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2949 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 5X8 | 5990525.93487 | 2095591.0616 | 37.7335487664486 | -122.475163590944 | (37.7335487664486, -122.475163590944) | |||
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) | ||
17413 | 17413 | 225 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2962 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/17/1991 12:00:00 AM | 40 | 3X4 | 5990608.66265 | 2095460.33335 | 37.7331946143326 | -122.47486804133301 | (37.7331946143326, -122.474868041333) | ||
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) | |||
117409 | 117409 | 227 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 2X3 | 5990630.67566 | 2095430.1647700001 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | |||
21024 | 21024 | 228 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.732946707226205 | -122.47484341251601 | (37.7329467072262, -122.474843412516) | ||
92204 | 92204 | 229 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2974 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5990632.173690001 | 2095387.1701099998 | 37.7329950890785 | -122.474781419889 | (37.7329950890785, -122.474781419889) | |||
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) | ||
20582 | 20582 | 233 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2980 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 5990616.421680001 | 2095336.99138 | 37.732856398203104 | -122.474832216845 | (37.7328563982031, -122.474832216845) | |||
17522 | 17522 | 236 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2996X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X5 | 5990618.96661 | 2095242.77985 | 37.732597864700395 | -122.47481654436599 | (37.7325978647004, -122.474816544366) | |||
97846 | 97846 | 238 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3007 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990525.395690001 | 2095120.4577099998 | 37.7322565763444 | -122.47513111186001 | (37.7322565763444, -122.47513111186) | ||
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) | ||
18239 | 18239 | 247 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3040 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990628.1224 | 2094940.11862 | 37.7317673641661 | -122.47476280805401 | (37.7317673641661, -122.474762808054) | |||
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) | ||
19039 | 19039 | 250 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3060 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 2x10 | 5990631.19828 | 2094871.0468099997 | 37.7315778886877 | -122.474747134678 | (37.7315778886877, -122.474747134678) | |||
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) | |||
21868 | 21868 | 258 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3100 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X3 | 5990642.03803 | 2094556.09253 | 37.7307137319489 | -122.47468668135201 | (37.7307137319489, -122.474686681352) | |||
17630 | 17630 | 259 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 3100 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2X3 | 5990639.72639 | 2094599.99663 | 37.7308341475716 | -122.47469787612499 | (37.7308341475716, -122.474697876125) | |||
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) | ||
129124 | 129124 | 266 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
128857 | 128857 | 267 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
111882 | 111882 | 269 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
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) | ||
145883 | 145883 | 271 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
119215 | 119215 | 272 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 3201X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X2 | 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) | ||
21389 | 21389 | 276 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3250 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990658.152869999 | 2093877.27418 | 37.7288508016084 | -122.4745814481 | (37.7288508016084, -122.4745814481) | |||
20002 | 20002 | 277 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2 | 5990658.58913 | 2094051.40062 | 37.7293289342608 | -122.47459264285801 | (37.7293289342608, -122.474592642858) | |||
20176 | 20176 | 278 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/18/1995 12:00:00 AM | 4 | 2 | 5990657.14807 | 2094136.56397 | 37.7295626878705 | -122.47460383762 | (37.7295626878705, -122.47460383762) | ||
20604 | 20604 | 279 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/18/1995 12:00:00 AM | 6 | 2 | 5990654.48819 | 2094194.6647700001 | 37.729722063906294 | -122.47461727168199 | (37.7297220639063, -122.474617271682) | ||
85313 | 85313 | 280 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.47453510192301 | (37.7294662695904, -122.474535101923) | |||
115765 | 115765 | 281 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.47453510192301 | (37.7294662695904, -122.474535101923) | |||
141544 | 141544 | 282 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3250 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2 | 5990676.28121 | 2094101.04473 | 37.7294662695904 | -122.47453510192301 | (37.7294662695904, -122.474535101923) | |||
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) | ||
12177 | 12177 | 287 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3355 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1998 12:00:00 AM | 6 | 2 | 5990530.52606 | 2093814.1828 | 37.7286701727855 | -122.475018054542 | (37.7286701727855, -122.475018054542) | ||
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) | ||
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) | ||
82334 | 82334 | 294 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3451X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | |||
19064 | 19064 | 296 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3451X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | |||
89956 | 89956 | 298 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3451X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | |||
111827 | 111827 | 315 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3430X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2 | 5990580.98006 | 2092524.42255 | 37.7251317386157 | -122.474749535596 | (37.7251317386157, -122.474749535596) | |||
106214 | 106214 | 318 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3498X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/24/1994 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
91919 | 91919 | 320 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3486X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
113882 | 113882 | 322 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3982X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 2X2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
128477 | 128477 | 324 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
85958 | 85958 | 325 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3462X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
120142 | 120142 | 327 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3470X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
79259 | 79259 | 329 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3454X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
114548 | 114548 | 330 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3494X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
58965 | 58965 | 331 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 50 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
78918 | 78918 | 332 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 80 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
107940 | 107940 | 333 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3498X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2008 12:00:00 AM | 25 | 2 | 5990578.06761 | 2092479.06027 | 37.7250070163682 | -122.47475629413799 | (37.7250070163682, -122.474756294138) | ||
17613 | 17613 | 334 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2008 12:00:00 AM | 3 | 2 | 5990580.28082 | 2092709.64357 | 37.7256402686825 | -122.474765465576 | (37.7256402686825, -122.474765465576) | ||
144000 | 144000 | 335 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/07/2015 01:03:00 PM | 3 | 3x18 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
100734 | 100734 | 336 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/07/2015 01:06:00 PM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
89961 | 89961 | 337 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 3590X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
96255 | 96255 | 338 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1999 12:00:00 AM | 2 | 5990537.683837099 | 2091850.0721832002 | 37.723277631918 | -122.474850005229 | (37.723277631918, -122.474850005229) | |||
142135 | 142135 | 339 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3590X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
79275 | 79275 | 340 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
127778 | 127778 | 341 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2013 12:00:00 AM | 10 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
110799 | 110799 | 342 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
84381 | 84381 | 343 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
126668 | 126668 | 344 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 3 | 2X2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
119861 | 119861 | 345 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | |||
98859 | 98859 | 346 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/07/2015 01:09:00 PM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
115580 | 115580 | 347 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 25 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
79970 | 79970 | 348 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
129471 | 129471 | 349 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
98611 | 98611 | 350 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3590X 19th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2000 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
94449 | 94449 | 351 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
104889 | 104889 | 352 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3590X 19th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1994 12:00:00 AM | 3 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
119299 | 119299 | 353 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3590X 19th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) |
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");