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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9330 | 9330 | 24138 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 120X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1997 12:00:00 AM | 9 | 3x3 | 6016341.404377299 | 2096017.7564546003 | 37.736182824394206 | -122.38594098669901 | (37.7361828243942, -122.385940986699) | ||
| 14351 | 14351 | 24146 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 12 | 3x3 | 6016692.87185 | 2095191.38157 | 37.733933208639606 | -122.384668261453 | (37.7339332086396, -122.384668261453) | ||
| 9247 | 9247 | 24150 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 100X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1996 12:00:00 AM | 7 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | ||
| 72507 | 72507 | 24170 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 95X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2004 12:00:00 AM | 8 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 13934 | 13934 | 24172 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 101X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2000 12:00:00 AM | 12 | 3x3 | 6016627.62077 | 2095425.11976 | 37.7345713981576 | -122.384910134993 | (37.7345713981576, -122.384910134993) | ||
| 129196 | 129196 | 24175 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 95X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 6 | 4x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 142562 | 142562 | 24187 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 55X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 12 | 3x4 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 138879 | 138879 | 24188 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 55X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1997 12:00:00 AM | 6 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 92517 | 92517 | 24190 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 55X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/2000 12:00:00 AM | 6 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 118202 | 118202 | 24426 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1220 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 12 | 3X3 | 6005780.2605800005 | 2114178.73009 | 37.785458468558105 | -122.42374612949699 | (37.7854584685581, -122.423746129497) | ||
| 121215 | 121215 | 24427 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1220 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 12 | 3X3 | 6005780.2605800005 | 2114178.73009 | 37.785458468558105 | -122.42374612949699 | (37.7854584685581, -122.423746129497) | ||
| 22566 | 22566 | 24430 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 10X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005698.75494 | 2114337.53552 | 37.7858899076294 | -122.42403941239999 | (37.7858899076294, -122.4240394124) | ||
| 22562 | 22562 | 24431 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 10X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005684.88689 | 2114317.71447 | 37.7858347009549 | -122.42408598197599 | (37.7858347009549, -122.424085981976) | ||
| 22745 | 22745 | 24432 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 10X Peter Yorke Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005673.10821 | 2114299.89066 | 37.785785096156296 | -122.424125464932 | (37.7857850961563, -122.424125464932) | ||
| 97951 | 97951 | 24433 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 112421 | 112421 | 24434 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2002 12:00:00 AM | 3 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 90479 | 90479 | 24437 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 78086 | 78086 | 24438 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 83108 | 83108 | 24439 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 93710 | 93710 | 24440 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 99X Peter Yorke Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1995 12:00:00 AM | 6 | 3X3 | 6005916.1529 | 2114537.1027597 | 37.7864501414891 | -122.423301466307 | (37.7864501414891, -122.423301466307) | ||
| 96899 | 96899 | 24507 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 4750 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | 12 | 3X3 | 6001492.23136 | 2091194.61222 | 37.7221066170749 | -122.436935387053 | (37.7221066170749, -122.436935387053) | ||
| 11647 | 11647 | 24814 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 4749 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/1995 12:00:00 AM | 12 | 3X3 | 6001619.1557 | 2091250.5894 | 37.7222675310536 | -122.436500645989 | (37.7222675310536, -122.436500645989) | ||
| 14665 | 14665 | 24958 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3150 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1995 12:00:00 AM | 3 | 3x2 | 6015944.400780001 | 2100851.85574 | 37.7494342903725 | -122.387650769466 | (37.7494342903725, -122.387650769466) | ||
| 23330 | 23330 | 25192 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 3351 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 10 | 3X3 | 5999863.3058400005 | 2104356.47488 | 37.7581532490819 | -122.44351115562 | (37.7581532490819, -122.44351115562) | ||
| 20729 | 20729 | 25193 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 3351 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999854.12011 | 2104362.71552 | 37.758169860475995 | -122.443543372027 | (37.758169860476, -122.443543372027) | |||
| 120156 | 120156 | 25194 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 3351 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999855.7330384 | 2104370.4484178 | 37.7581911850977 | -122.443538349322 | (37.7581911850977, -122.443538349322) | |||
| 116504 | 116504 | 25543 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 245X Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6010692.9519893 | 2096884.4242043998 | 37.738248298479704 | -122.40553112058399 | (37.7382482984797, -122.405531120584) | |||
| 127270 | 127270 | 25544 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 245X Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6010692.9519893 | 2096884.4242043998 | 37.738248298479704 | -122.40553112058399 | (37.7382482984797, -122.405531120584) | |||
| 16762 | 16762 | 25545 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 211 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1997 12:00:00 AM | 35 | 3X3 | 6010962.7216300005 | 2096974.8083 | 37.73851155467371 | -122.40460474641701 | (37.7385115546737, -122.404604746417) | ||
| 14184 | 14184 | 25546 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 211 Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 20 | 2X3 | 6010986.1155199995 | 2096981.2518200001 | 37.7385305546342 | -122.40452431464199 | (37.7385305546342, -122.404524314642) | ||
| 15345 | 15345 | 25550 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 8 | 3X3 | 6012164.070040001 | 2097372.25832 | 37.739669937231 | -122.40047894733999 | (37.739669937231, -122.40047894734) | ||
| 121314 | 121314 | 25551 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2X Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 24 | 3X3 | 6012387.620709999 | 2097478.4289 | 37.739973923618706 | -122.39971345271299 | (37.7399739236187, -122.399713452713) | ||
| 99279 | 99279 | 25552 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2X Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 24 | 3X3 | 6012387.620709999 | 2097478.4289 | 37.739973923618706 | -122.39971345271299 | (37.7399739236187, -122.399713452713) | ||
| 108095 | 108095 | 25553 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2X Industrial St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 24 | 3X3 | 6012387.620709999 | 2097478.4289 | 37.739973923618706 | -122.39971345271299 | (37.7399739236187, -122.399713452713) | ||
| 98023 | 98023 | 25554 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2X Industrial St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 24 | 3X3 | 6012387.620709999 | 2097478.4289 | 37.739973923618706 | -122.39971345271299 | (37.7399739236187, -122.399713452713) | ||
| 13918 | 13918 | 25904 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1700 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 3 | 3X3 | 6014497.75019 | 2095918.5425099998 | 37.7358082006905 | -122.39230836824899 | (37.7358082006905, -122.392308368249) | ||
| 13946 | 13946 | 25905 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1722 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/1997 12:00:00 AM | 6 | 3x3 | 6014408.7500599995 | 2095988.0053299998 | 37.7359939889401 | -122.39262093662501 | (37.7359939889401, -122.392620936625) | ||
| 15380 | 15380 | 25906 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1726 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 6 | 3X3 | 6014385.46965 | 2096004.245 | 37.7360372867842 | -122.392702562673 | (37.7360372867842, -122.392702562673) | ||
| 15990 | 15990 | 25908 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1744 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1997 12:00:00 AM | 6 | 3X3 | 6014300.07795 | 2096067.0404400001 | 37.736204967168895 | -122.393002190722 | (37.7362049671689, -122.393002190722) | ||
| 16119 | 16119 | 25909 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1748 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 6 | 3X3 | 6014281.93138 | 2096080.88268 | 37.7362419670851 | -122.393065899587 | (37.7362419670851, -122.393065899587) | ||
| 82899 | 82899 | 25910 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1758 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 6 | 3X3 | 6014246.34431 | 2096128.3835200001 | 37.7363704176882 | -122.39319226251301 | (37.7363704176882, -122.393192262513) | ||
| 14492 | 14492 | 25920 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6013439.08711 | 2096707.4096400002 | 37.7379154237493 | -122.396023873224 | (37.7379154237493, -122.396023873224) | ||
| 14310 | 14310 | 25921 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013425.09297 | 2096721.31671 | 37.737952831067 | -122.39607323250601 | (37.737952831067, -122.396073232506) | ||
| 15028 | 15028 | 25922 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013411.01512 | 2096731.0793 | 37.737978853826604 | -122.396122590895 | (37.7379788538266, -122.396122590895) | ||
| 103322 | 103322 | 25923 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013379.37918 | 2096773.8064400002 | 37.7380944133833 | -122.396234966455 | (37.7380944133833, -122.396234966455) | ||
| 13623 | 13623 | 25924 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6013360.04633 | 2096769.62618 | 37.7380818594982 | -122.396301517325 | (37.7380818594982, -122.396301517325) | ||
| 128518 | 128518 | 25925 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 12 | 3x3 | 6013379.37918 | 2096773.8064400002 | 37.7380944133833 | -122.396234966455 | (37.7380944133833, -122.396234966455) | ||
| 15065 | 15065 | 25926 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1997 12:00:00 AM | 14 | 3x3 | 6013312.92964 | 2096802.5667400002 | 37.7381696854804 | -122.396466732646 | (37.7381696854804, -122.396466732646) | ||
| 88756 | 88756 | 25927 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1900 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013379.37918 | 2096773.8064400002 | 37.7380944133833 | -122.396234966455 | (37.7380944133833, -122.396234966455) | ||
| 14461 | 14461 | 25928 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1940 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2015 12:45:00 PM | 3 | 3x3 | 6013206.38179 | 2096882.0048599998 | 37.7383818760104 | -122.396840692362 | (37.7383818760104, -122.396840692362) | ||
| 95058 | 95058 | 25929 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1940 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/1997 12:00:00 AM | 4 | 3x3 | 6013182.41894 | 2096920.43607 | 37.738486066262396 | -122.39692623851002 | (37.7384860662624, -122.39692623851) | ||
| 16145 | 16145 | 25931 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1940 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013151.64445 | 2096926.6357200001 | 37.738501376141 | -122.397033077137 | (37.738501376141, -122.397033077137) | ||
| 79355 | 79355 | 25932 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1940 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013182.41894 | 2096920.43607 | 37.738486066262396 | -122.39692623851002 | (37.7384860662624, -122.39692623851) | ||
| 16884 | 16884 | 25933 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 8 | 3x3 | 6013124.42835 | 2096948.9932900001 | 37.7385612502888 | -122.397128745193 | (37.7385612502888, -122.397128745193) | ||
| 13693 | 13693 | 25934 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 14 | 3x3 | 6013105.1413900005 | 2096960.5409 | 37.7385918838981 | -122.39719624022499 | (37.7385918838981, -122.397196240225) | ||
| 81280 | 81280 | 25935 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1980 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 24 | 3x3 | 6013056.68658 | 2097014.0389 | 37.7387360805466 | -122.397367525612 | (37.7387360805466, -122.397367525612) | ||
| 108505 | 108505 | 25936 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2000 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2003 12:00:00 AM | 10 | 3x3 | 6012867.82476 | 2097156.93166 | 37.7391179171316 | -122.39803054667 | (37.7391179171316, -122.39803054667) | ||
| 15448 | 15448 | 25937 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2000 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 10 | 3x3 | 6012876.83116 | 2097128.12307 | 37.7390393164014 | -122.39799738599702 | (37.7390393164014, -122.397997385997) | ||
| 23266 | 23266 | 25941 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2040 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 7 | 3x3 | 6012690.56665 | 2097267.49994 | 37.739411640236 | -122.39865118591601 | (37.739411640236, -122.398651185916) | ||
| 14974 | 14974 | 25942 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2040 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6012651.9981 | 2097296.89439 | 37.7394902023226 | -122.398786602234 | (37.7394902023226, -122.398786602234) | ||
| 16636 | 16636 | 25943 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2040 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 3x3 | 6012631.62363 | 2097312.6354799997 | 37.739532288795 | -122.398858153188 | (37.739532288795, -122.398858153188) | ||
| 82984 | 82984 | 25944 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2040 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6012684.150909999 | 2097293.6699 | 37.7394831399929 | -122.398675204895 | (37.7394831399929, -122.398675204895) | ||
| 79793 | 79793 | 25945 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2076 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1997 12:00:00 AM | 18 | 3x3 | 6012602.39779 | 2097471.73155 | 37.7399675045813 | -122.39897036769301 | (37.7399675045813, -122.398970367693) | ||
| 114371 | 114371 | 25947 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2088 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 3x3 | 6012602.39779 | 2097471.73155 | 37.7399675045813 | -122.39897036769301 | (37.7399675045813, -122.398970367693) | ||
| 16024 | 16024 | 25948 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2100 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3X3 | 6012350.25705 | 2097525.2305900003 | 37.740100348252 | -122.399845927154 | (37.740100348252, -122.399845927154) | ||
| 16052 | 16052 | 25950 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2130 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3X3 | 6012258.5541199995 | 2097593.00957 | 37.7402813422027 | -122.40016775945699 | (37.7402813422027, -122.400167759457) | ||
| 15244 | 15244 | 25951 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2198 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011979.2336 | 2097803.31735 | 37.7408432242339 | -122.401148318148 | (37.7408432242339, -122.401148318148) | ||
| 15362 | 15362 | 25953 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2424 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011669.28435 | 2098033.15665 | 37.741457017814795 | -122.402236168686 | (37.7414570178148, -122.402236168686) | ||
| 13626 | 13626 | 25954 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2424 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011648.47337 | 2098048.0207700003 | 37.741496669839705 | -122.402309171152 | (37.7414966698397, -122.402309171152) | ||
| 83104 | 83104 | 25959 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2301X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6011400.367219999 | 2098224.16578 | 37.741966473568795 | -122.40317942951 | (37.7419664735688, -122.40317942951) | ||
| 129369 | 129369 | 25963 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2165X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012113.82333 | 2097630.4428 | 37.74037605486671 | -122.400670812787 | (37.7403760548667, -122.400670812787) | ||
| 112883 | 112883 | 25964 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2165X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012113.82333 | 2097630.4428 | 37.74037605486671 | -122.400670812787 | (37.7403760548667, -122.400670812787) | ||
| 106538 | 106538 | 25965 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2165X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012113.82333 | 2097630.4428 | 37.74037605486671 | -122.400670812787 | (37.7403760548667, -122.400670812787) | ||
| 23300 | 23300 | 25966 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 6 | 2x3 | 6012182.59825 | 2097568.59521 | 37.7402100700509 | -122.40042867166599 | (37.7402100700509, -122.400428671666) | ||
| 14209 | 14209 | 25967 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012203.8178199995 | 2097553.63348 | 37.740170171620704 | -122.40035425186599 | (37.7401701716207, -122.400354251866) | ||
| 15126 | 15126 | 25968 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2000 12:00:00 AM | 3 | 2x3 | 6012223.9288800005 | 2097537.9675 | 37.7401282776092 | -122.400283615495 | (37.7401282776092, -122.400283615495) | ||
| 123788 | 123788 | 25969 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2121 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6012170.05975 | 2097512.80398 | 37.740056179910205 | -122.40046810708401 | (37.7400561799102, -122.400468107084) | ||
| 91105 | 91105 | 25970 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 2x3 | 6012475.65333 | 2097362.28804 | 37.7396599323249 | -122.399400919032 | (37.7396599323249, -122.399400919032) | ||
| 122085 | 122085 | 25971 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 26 | 8x6 | 6012498.75973 | 2097344.83298 | 37.739613292243796 | -122.399319801459 | (37.7396132922438, -122.399319801459) | ||
| 14384 | 14384 | 25972 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2016 07:07:00 AM | 3 | 3x3 | 6012485.58798 | 2097305.21052 | 37.7395037631998 | -122.39936256315 | (37.7395037631998, -122.39936256315) | ||
| 125161 | 125161 | 25975 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2015 12:54:00 PM | 3 | 2x3 | 6012520.92453 | 2097295.50422 | 37.7394790811646 | -122.399239702796 | (37.7394790811646, -122.399239702796) | ||
| 141085 | 141085 | 25977 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2065 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 16 | 2x3 | 6012520.92453 | 2097295.50422 | 37.7394790811646 | -122.399239702796 | (37.7394790811646, -122.399239702796) | ||
| 14840 | 14840 | 25979 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1955 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 12 | 3x3 | 6013151.4880800005 | 2096853.8753799999 | 37.7383015827389 | -122.39702851757299 | (37.7383015827389, -122.397028517573) | ||
| 13905 | 13905 | 25980 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1951 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 18 | 3x3 | 6013173.42584 | 2096838.9136400002 | 37.738261722099 | -122.396951618345 | (37.738261722099, -122.396951618345) | ||
| 14274 | 14274 | 25994 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1789 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014073.074569999 | 2096169.5895900002 | 37.7364739337157 | -122.393794216455 | (37.7364739337157, -122.393794216455) | ||
| 1808 | 1808 | 26069 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 271 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/1997 12:00:00 AM | 3 | 3X3 | 5993995.7894187 | 2088348.3730133998 | 37.713862596316 | -122.462642190986 | (37.713862596316, -122.462642190986) | ||
| 149 | 149 | 26071 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 247 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 01:41:00 PM | 3 | 3X3 | 5993990.1569314 | 2088190.8403771 | 37.7134297247264 | -122.46265023824101 | (37.7134297247264, -122.462650238241) | ||
| 93751 | 93751 | 26118 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1487 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6015608.80353 | 2094994.85724 | 37.7333335795896 | -122.38840253716299 | (37.7333335795896, -122.388402537163) | ||
| 13633 | 13633 | 26120 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1469 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6015722.0682 | 2094937.3446 | 37.733181937191205 | -122.388006934363 | (37.7331819371912, -122.388006934363) | ||
| 15593 | 15593 | 26121 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1451 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6015827.8735 | 2094858.5401 | 37.7329714171096 | -122.387635637434 | (37.7329714171096, -122.387635637434) | ||
| 16069 | 16069 | 26134 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1506 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015502.3956 | 2095169.2882 | 37.733806634802896 | -122.388782595026 | (37.7338066348029, -122.388782595026) | ||
| 96605 | 96605 | 26144 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 Oakdale Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 82186 | 82186 | 26402 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2785X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6011103.823919999 | 2098382.6856299997 | 37.742385169509795 | -122.404215940733 | (37.7423851695098, -122.404215940733) | ||
| 16088 | 16088 | 26417 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2100 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3X3 | 6012309.7802800005 | 2097554.6976900003 | 37.7401790020488 | -122.399987948985 | (37.7401790020488, -122.399987948985) | ||
| 14842 | 14842 | 26422 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2198 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 12 | 3X3 | 6011934.89939 | 2097835.39684 | 37.7409288343056 | -122.401303863995 | (37.7409288343056, -122.401303863995) | ||
| 14863 | 14863 | 26487 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2130 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/1997 12:00:00 AM | 12 | 3X3 | 6012213.921519999 | 2097628.14131 | 37.7403753177698 | -122.400324549047 | (37.7403753177698, -122.400324549047) | ||
| 15560 | 15560 | 26663 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2100 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/09/1999 12:00:00 AM | 6 | 3X3 | 6012286.22112 | 2097573.09512 | 37.7402282039703 | -122.40007069922899 | (37.7402282039703, -122.400070699229) | ||
| 89360 | 89360 | 26821 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 2088 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5.5x9 | 6012602.39779 | 2097471.73155 | 37.7399675045813 | -122.39897036769301 | (37.7399675045813, -122.398970367693) | |||
| 88101 | 88101 | 27506 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1761 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2001 12:00:00 AM | 3 | 2X2 | 6001616.04524 | 2112155.78866 | 37.7796680361617 | -122.438008095678 | (37.7796680361617, -122.438008095678) | ||
| 96480 | 96480 | 27535 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1300 Illinois St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/05/2001 12:00:00 AM | 15 | 3X3 | 6016127.146980001 | 2102787.87807 | 37.754760323366206 | -122.38715384385 | (37.7547603233662, -122.38715384385) |
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");