Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19020 | 19020 | 25 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 736 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/1995 12:00:00 AM | 0 | 6003903.525084401 | 2107767.6234363 | 37.7677490306877 | -122.429781635515 | (37.7677490306877, -122.429781635515) | |||
| 126224 | 126224 | 28 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 742 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2011 12:00:00 AM | 3 | 3x3 | 6003863.8671794 | 2107765.4342001 | 37.76774077377821 | -122.42991865118601 | (37.7677407737782, -122.429918651186) | ||
| 17593 | 17593 | 35 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003712.362269999 | 2107704.7999 | 37.767565705622296 | -122.430438361268 | (37.7675657056223, -122.430438361268) | |||
| 116627 | 116627 | 63 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 847 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2015 12:00:00 AM | 3 | 3X3 | 6003197.9718305 | 2107678.5983679 | 37.7674646107508 | -122.43221569826001 | (37.7674646107508, -122.43221569826) | ||
| 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) | |||
| 12865 | 12865 | 210 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2929 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 2X3 | 5990521.9439 | 2095739.47468 | 37.7339560397287 | -122.475188219755 | (37.7339560397287, -122.475188219755) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 83114 | 83114 | 366 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | |||
| 110873 | 110873 | 367 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/1994 12:00:00 AM | 12 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 79963 | 79963 | 368 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3690X 19th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/07/2015 01:12:00 PM | 3 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | ||
| 120248 | 120248 | 383 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 85567 | 85567 | 384 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 125863 | 125863 | 385 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 86727 | 86727 | 387 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 114841 | 114841 | 388 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 80402 | 80402 | 389 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3721X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | ||
| 89509 | 89509 | 399 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3790X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990543.5477982005 | 2090571.3277717 | 37.719766857298396 | -122.474736447703 | (37.7197668572984, -122.474736447703) | ||
| 16908 | 16908 | 406 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3822 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 2x5 | 5990686.0398699995 | 2090357.61675 | 37.7191883155766 | -122.47422832208599 | (37.7191883155766, -122.474228322086) | ||
| 21232 | 21232 | 409 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3838 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2X3 | 5990744.200019999 | 2090277.4187900003 | 37.7189714809286 | -122.474021438444 | (37.7189714809286, -122.474021438444) | ||
| 21161 | 21161 | 419 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3874 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2X3 | 5990927.36264 | 2090022.7346400002 | 37.718282789105295 | -122.47336975731501 | (37.7182827891053, -122.473369757315) | ||
| 78172 | 78172 | 442 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700x 23rd Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988814.32729 | 2110443.9038299997 | 37.7742313463884 | -122.482168813724 | (37.7742313463884, -122.482168813724) | ||||
| 144664 | 144664 | 449 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700x 23rd Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988819.75093 | 2110337.06115 | 37.7739383014913 | -122.482142223603 | (37.7739383014913, -122.482142223603) | |||
| 120774 | 120774 | 452 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 740x 23rd Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988823.98791 | 2110205.31094 | 37.773576798380205 | -122.482117913396 | (37.7735767983802, -122.482117913396) | ||||
| 90389 | 90389 | 464 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 760x 23rd Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5988827.211759999 | 2110098.29514 | 37.7732831501538 | -122.48209892030701 | (37.7732831501538, -122.482098920307) | ||||
| 94915 | 94915 | 465 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 760x 23rd Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988826.12619 | 2110109.25362 | 37.773313175965 | -122.482103478364 | (37.773313175965, -122.482103478364) | |||
| 122619 | 122619 | 478 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5988301.98955 | 2114692.83548 | 37.7858679033343 | -122.484252736316 | (37.7858679033343, -122.484252736316) | |||
| 86609 | 86609 | 685 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2340X Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3 | 4X4 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | ||
| 84299 | 84299 | 699 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2551X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5987474.44326 | 2114604.18984 | 37.785576288970795 | -122.487109266635 | (37.7855762889708, -122.487109266635) | |||
| 139749 | 139749 | 819 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 5982179.061767 | 2105489.8566905 | 37.7602407921924 | -122.50475385101299 | (37.7602407921924, -122.504753851013) | ||
| 21813 | 21813 | 851 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 362 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 18 | 3X3 | 6008418.030180001 | 2095243.6630400002 | 37.7336156580305 | -122.413280706764 | (37.7336156580305, -122.413280706764) | ||
| 11213 | 11213 | 893 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1162X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1997 12:00:00 AM | 8 | 3X6 | 6003397.35641 | 2094349.3863099997 | 37.730877020048 | -122.430574836985 | (37.730877020048, -122.430574836985) | ||
| 11380 | 11380 | 928 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1285 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 10 | 3X4 | 6002746.05074 | 2094024.26586 | 37.729947394457604 | -122.432803287742 | (37.7299473944576, -122.432803287742) | ||
| 11225 | 11225 | 952 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | 6002047.349219999 | 2093382.65925 | 37.7281460362049 | -122.435172906015 | (37.7281460362049, -122.435172906015) | |||
| 9439 | 9439 | 995 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1682 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6001498.326169999 | 2092340.4216099998 | 37.725253096867206 | -122.436996309494 | (37.7252530968672, -122.436996309494) | ||
| 11881 | 11881 | 1007 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1827 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 10 | 3X3 | 6001335.27273 | 2091591.54514 | 37.723187582737395 | -122.43750636433701 | (37.7231875827374, -122.437506364337) | ||
| 12617 | 12617 | 1019 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1868 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/1997 12:00:00 AM | 12 | 3X3 | 6001068.280809999 | 2091265.41408 | 37.722276917520496 | -122.43840594717 | (37.7222769175205, -122.43840594717) | ||
| 125827 | 125827 | 1028 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1989X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | |||
| 10581 | 10581 | 1040 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2003X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 6000664.666119999 | 2090352.04738 | 37.7197460535115 | -122.439735693745 | (37.7197460535115, -122.439735693745) | |||
| 17836 | 17836 | 1046 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.43970324513701 | (37.7197661846273, -122.439703245137) | ||
| 12030 | 12030 | 1064 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2073X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 12 | 3X3 | 6000384.95261 | 2090073.81885 | 37.7189661758191 | -122.44068261512399 | (37.7189661758191, -122.440682615124) | ||
| 13084 | 13084 | 1106 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2355 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 10 | 3x3 | 5999402.478519999 | 2089142.52516 | 37.716353057130604 | -122.44401175335699 | (37.7163530571306, -122.444011753357) | ||
| 125777 | 125777 | 1112 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2385 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 10 | 3x3 | 5999333.8364 | 2089049.0837 | 37.7160925721821 | -122.44424230229299 | (37.7160925721821, -122.444242302293) | ||
| 98603 | 98603 | 1122 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2454 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | 5999000.36988 | 2088909.59415 | 37.7156905350991 | -122.445384893004 | (37.7156905350991, -122.445384893004) | ||
| 12429 | 12429 | 1133 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2566 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/1997 12:00:00 AM | 10 | 3X3 | 5998552.75251 | 2088645.69218 | 37.7149403579834 | -122.44691307777599 | (37.7149403579834, -122.446913077776) | ||
| 4075 | 4075 | 1149 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2678 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2017 08:44:00 AM | 3 | 3X3 | 5998020.45993 | 2088357.3562599998 | 37.7141182292418 | -122.448732141877 | (37.7141182292418, -122.448732141877) | ||
| 4414 | 4414 | 1175 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2900 Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 10:42:00 AM | 3 | 3X3 | 5996816.67595 | 2087452.1631200002 | 37.711563867747 | -122.452827563661 | (37.711563867747, -122.452827563661) | ||
| 12019 | 12019 | 1187 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3022 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1998 12:00:00 AM | 20 | 3X3 | 5996561.5746 | 2087275.10705 | 37.7110630910694 | -122.45369647960399 | (37.7110630910694, -122.453696479604) | ||
| 11067 | 11067 | 1190 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3034 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5996528.95527 | 2087256.53034 | 37.7110102136125 | -122.45380787863199 | (37.7110102136125, -122.453807878632) | ||
| 12413 | 12413 | 1191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3044 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 12 | 3X3 | 5996503.24503 | 2087241.9631400001 | 37.710968741375105 | -122.45389568755199 | (37.7109687413751, -122.453895687552) | ||
| 13225 | 13225 | 1194 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3051 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 6 | 3X3 | 5996527.0746 | 2087144.8903599998 | 37.7107035681781 | -122.453806321904 | (37.7107035681781, -122.453806321904) | ||
| 11552 | 11552 | 1195 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3062-3062 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 8 | 3x3 | 5996475.62372 | 2087226.6805900002 | 37.710925195309294 | -122.453990049815 | (37.7109251953093, -122.453990049815) | ||
| 12871 | 12871 | 1197 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3080 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/25/2015 12:00:00 AM | 3 | 3X3 | 5996407.37603 | 2087190.7232 | 37.7108225512021 | -122.454223333055 | (37.7108225512021, -122.454223333055) | ||
| 20467 | 20467 | 1216 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3501 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2000 12:00:00 AM | 8 | 3X3 | 5993668.38843 | 2087432.7738400002 | 37.711329717576 | -122.46370738819999 | (37.711329717576, -122.4637073882) | ||
| 139038 | 139038 | 1224 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3600X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1998 12:00:00 AM | 15 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 113065 | 113065 | 1228 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3600X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1998 12:00:00 AM | 12 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 115339 | 115339 | 1229 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3600X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1998 12:00:00 AM | 12 | 3X5 | 5993524.054670201 | 2087589.4711722 | 37.7117516532039 | -122.46421760708901 | (37.7117516532039, -122.464217607089) | ||
| 125751 | 125751 | 1231 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3601X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1992 12:00:00 AM | 15 | 3X3 | 5993438.31243 | 2087500.5986099998 | 37.71150268788671 | -122.464507504506 | (37.7115026878867, -122.464507504506) | ||
| 11711 | 11711 | 1236 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3702X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5993199.6595 | 2087639.3681700001 | 37.711869955605394 | -122.465342418633 | (37.7118699556054, -122.465342418633) | ||
| 138419 | 138419 | 1282 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3995X Alemany Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2000 12:00:00 AM | 3 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||
| 17127 | 17127 | 1361 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 14 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/29/2016 12:00:00 AM | 3 | 3X3 | 5999192.9019 | 2100038.7006099997 | 37.746259440735294 | -122.445519216737 | (37.7462594407353, -122.445519216737) | ||
| 19259 | 19259 | 1364 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999126.95834 | 2100012.88601 | 37.746184795201 | -122.445745384538 | (37.746184795201, -122.445745384538) | |||
| 17550 | 17550 | 1369 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 34 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1997 12:00:00 AM | 3 | 5999059.98844 | 2100047.12811 | 37.746274991794294 | -122.445979419622 | (37.7462749917943, -122.445979419622) | |||
| 18338 | 18338 | 1372 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 44 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1997 12:00:00 AM | 3 | 3X3 | 5998995.9428900005 | 2100044.21237 | 37.74626332849721 | -122.44620067084401 | (37.7462633284972, -122.446200670844) | ||
| 23285 | 23285 | 1681 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5994319.83202 | 2111404.8234200003 | 37.7771884605269 | -122.46319416353901 | (37.7771884605269, -122.463194163539) | |||
| 21455 | 21455 | 1939 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 209 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 08:31:00 AM | 3 | 3x3 | 6000815.48464 | 2097758.14469 | 37.740090072596004 | -122.439745061994 | (37.740090072596, -122.439745061994) | ||
| 7561 | 7561 | 2191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1059 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1998 12:00:00 AM | 6 | 4X4 | 6000860.0298 | 2112380.5159 | 37.780242057456704 | -122.440639597689 | (37.7802420574567, -122.440639597689) | ||
| 9487 | 9487 | 2233 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1217 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1993 12:00:00 AM | 9 | 4X4 | 6000793.5299 | 2112868.6894 | 37.781578670102704 | -122.440904680944 | (37.7815786701027, -122.440904680944) | ||
| 18549 | 18549 | 2328 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2308 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2016 12:00:00 AM | 3 | 3X3 | 6009637.87747 | 2103837.38143 | 37.7572805334784 | -122.409669683221 | (37.7572805334784, -122.409669683221) | ||
| 13925 | 13925 | 2497 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016766.5915 | 2098782.9536200003 | 37.7437990179202 | -122.384663486948 | (37.7437990179202, -122.384663486948) | |||
| 9416 | 9416 | 2543 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1580 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6016211.0400559995 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | |||
| 18505 | 18505 | 2550 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1999 12:00:00 AM | 3 | 3x3 | 6001174.5251400005 | 2095817.91912 | 37.7347830958454 | -122.438364680879 | (37.7347830958454, -122.438364680879) |
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");