Data source: data.sfgov.org
This data as json, CSV (advanced)
qCareAssistant ✖
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18602 | 18602 | 234 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2994 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 2X3 | 5990616.60068 | 2095284.10448 | 37.7327111945568 | -122.474827739114 | (37.7327111945568, -122.474827739114) | |||
| 20431 | 20431 | 235 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2994 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1994 12:00:00 AM | 14 | 3X3 | 5990616.42942 | 2095306.68002 | 37.7327731713422 | -122.474829978418 | (37.7327731713422, -122.474829978418) | ||
| 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) | |||
| 11340 | 11340 | 237 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3007 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990538.44703 | 2095140.6475 | 37.732312768812896 | -122.47508746420799 | (37.7323127688129, -122.475087464208) | ||
| 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) | ||
| 86397 | 86397 | 239 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.73231439650579 | -122.474793962374 | (37.7323143965058, -122.474793962374) | |||
| 98100 | 98100 | 240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3010X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 5x5 | 5990623.3177 | 2095139.449 | 37.73231439650579 | -122.474793962374 | (37.7323143965058, -122.474793962374) | |||
| 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) | ||
| 12218 | 12218 | 246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3039 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990544.75562 | 2094979.28403 | 37.7318700712305 | -122.47505387905599 | (37.7318700712305, -122.475053879056) | ||
| 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) | |||
| 12773 | 12773 | 251 | Permitted Site 1 | Acer saccharinum :: Silver Maple 273 | 3063 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2 | 5990548.37754 | 2094874.7295400002 | 37.7315832009825 | -122.47503372794701 | (37.7315832009825, -122.475033727947) | |||
| 12253 | 12253 | 252 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3063 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2003 12:00:00 AM | 6 | 2 | 5990549.27758 | 2094856.00777 | 37.731531847902495 | -122.47502925021601 | (37.7315318479025, -122.475029250216) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 82798 | 82798 | 265 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
| 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) | ||
| 139213 | 139213 | 268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |||
| 120852 | 120852 | 314 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3438X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 18 | 2 | 5990580.98006 | 2092524.42255 | 37.7251317386157 | -122.474749535596 | (37.7251317386157, -122.474749535596) | ||
| 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) | |||
| 141431 | 141431 | 317 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3498X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 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) | ||
| 84908 | 84908 | 319 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3488X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/1999 12:00:00 AM | 4 | 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) | ||
| 83243 | 83243 | 321 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3484X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 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) | ||
| 100457 | 100457 | 323 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3482X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 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) | ||
| 88883 | 88883 | 328 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3446X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 8 | 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) | |||
| 22038 | 22038 | 354 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1995 12:00:00 AM | 24 | 2 | 5990504.49839 | 2091477.17058 | 37.722251813860204 | -122.474937513077 | (37.7222518138602, -122.474937513077) | ||
| 113903 | 113903 | 355 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.7429471 | 2091103.3809490001 | 37.7212246253597 | -122.47496124712299 | (37.7212246253597, -122.474961247123) | ||
| 98926 | 98926 | 357 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 98662 | 98662 | 358 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3690X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | |||
| 108637 | 108637 | 360 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 85494 | 85494 | 361 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1994 12:00:00 AM | 20 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) |
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");