Data source: data.sfgov.org
This data as json, CSV (advanced)
qSiteInfo ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15890 | 15890 | 17142 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.7049599998 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | ||
| 99391 | 99391 | 17145 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
| 146083 | 146083 | 17143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
| 120523 | 120523 | 61840 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1031 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21879 | 6010263.10380919 | 2103214.40384755 | 37.7556049923888 | -122.40746347613 | (37.7556049923888, -122.40746347613) | ||
| 20291 | 20291 | 61846 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1032 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21885 | 6010211.80559334 | 2103200.31460596 | 37.7555634350502 | -122.407639888906 | (37.7555634350502, -122.407639888906) | ||
| 136670 | 136670 | 227260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001350.1729 | 2100676.3582200003 | 37.748133217784 | -122.438105320914 | (37.748133217784, -122.438105320914) | |||
| 155175 | 155175 | 227259 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 1ft | 6001350.9072 | 2100668.98044 | 37.748113001917 | -122.438102253317 | (37.748113001917, -122.438102253317) | |||
| 181998 | 181998 | 141820 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004741.7405 | 2112502.8158 | 37.7807981447488 | -122.42721968229799 | (37.7807981447488, -122.427219682298) | |||
| 86245 | 86245 | 12329 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 4X4 | 6004738.4302199995 | 2112529.1477 | 37.7808702584368 | -122.427233010388 | (37.7808702584368, -122.427233010388) | |||
| 126371 | 126371 | 12330 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004740.4097 | 2112512.03764 | 37.7808233903837 | -122.427224943262 | (37.7808233903837, -122.427224943262) | ||
| 33985 | 33985 | 227246 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 104 Red Rock Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000168.90266 | 2100069.23534 | 37.7463989525502 | -122.442146526165 | (37.7463989525502, -122.442146526165) | |||
| 75453 | 75453 | 60026 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 16 | Permit Number 19514 | 6014265.094769999 | 2112604.60863 | 37.781611606035 | -122.394280648053 | (37.781611606035, -122.394280648053) | |
| 93685 | 93685 | 61047 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | ||
| 183847 | 183847 | 227240 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1041 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005776.90584 | 2102650.34664 | 37.753804097106205 | -122.422938087332 | (37.7538040971062, -122.422938087332) | |||
| 37569 | 37569 | 141819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004740.795 | 2112530.2338 | 37.7808733743326 | -122.42722490683998 | (37.7808733743326, -122.42722490684) | |||
| 62803 | 62803 | 141818 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004738.0171 | 2112555.418 | 37.7809423668258 | -122.427236311405 | (37.7809423668258, -122.427236311405) | |||
| 83552 | 83552 | 12331 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6004735.877669999 | 2112555.20778 | 37.7809416686235 | -122.42724369777201 | (37.7809416686235, -122.427243697772) | |||
| 32186 | 32186 | 73447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 5 | 6007557.7828 | 2115066.68598 | 37.787996759296796 | -122.417659373585 | (37.7879967592968, -122.417659373585) | ||
| 131591 | 131591 | 70619 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1045 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 10 | 6007580.409 | 2115068.8992 | 37.7880041094384 | -122.417581247698 | (37.7880041094384, -122.417581247698) | ||
| 124780 | 124780 | 34389 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38137 | 6004014.39109162 | 2097091.94465812 | 37.7384424015374 | -122.428637072989 | (37.7384424015374, -122.428637072989) | ||
| 166204 | 166204 | 227327 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 105 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6003998.12904 | 2097070.3333 | 37.738382141325104 | -122.428691759122 | (37.7383821413251, -122.428691759122) | |||
| 106703 | 106703 | 61847 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21886 | 6010217.4028677 | 2103099.43948978 | 37.7552867678032 | -122.407613419659 | (37.7552867678032, -122.407613419659) | ||
| 47017 | 47017 | 129614 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006528.24106 | 2114177.52587 | 37.7854973571526 | -122.42115824896999 | (37.7854973571526, -122.42115824897) | |||
| 53835 | 53835 | 64389 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1988 12:00:00 AM | 4 | Permit Number 25231 | 6006529.57186 | 2114155.94695 | 37.78543818176271 | -122.421152111986 | (37.7854381817627, -122.421152111986) | ||
| 142944 | 142944 | 61841 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1051 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1991 12:00:00 AM | Permit Number 29816 | 6010269.32300261 | 2103102.32039095 | 37.7552975843096 | -122.40743406658301 | (37.7552975843096, -122.407434066583) | ||
| 65546 | 65546 | 61848 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21887 | 6010218.02478734 | 2103088.23113889 | 37.755256026984 | -122.407610478643 | (37.755256026984, -122.407610478643) | ||
| 178363 | 178363 | 226739 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1052 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010223.2273 | 2103077.92399 | 37.7552280170702 | -122.407591760047 | (37.7552280170702, -122.407591760047) | |||
| 151295 | 151295 | 207819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 106 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998117.86344 | 2093869.45755 | 37.7292587475919 | -122.448792267857 | (37.7292587475919, -122.448792267857) | |||
| 91185 | 91185 | 61842 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21881 | 6010272.43259961 | 2103046.27865741 | 37.7551438802467 | -122.40741936190001 | (37.7551438802467, -122.4074193619) | ||
| 149026 | 149026 | 226713 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1061 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010264.70472 | 2103053.83895 | 37.7551642065834 | -122.407446620265 | (37.7551642065834, -122.407446620265) | |||
| 97311 | 97311 | 68478 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1064 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32347 | 6010221.7563028 | 2103020.9810753996 | 37.755071582179 | -122.40759283260599 | (37.755071582179, -122.407592832606) | ||
| 137126 | 137126 | 226740 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1064 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010224.3865 | 2103036.6159599996 | 37.755114659315794 | -122.407584838872 | (37.7551146593158, -122.407584838872) | |||
| 177945 | 177945 | 45683 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 107 Bernard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2001 12:00:00 AM | 4 | Permit Number 44370 | 6008292.83323 | 2118060.93092 | 37.79625955578 | -122.41532827329901 | (37.79625955578, -122.415328273299) | ||
| 136193 | 136193 | 227322 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000618.205469999 | 2102486.60155 | 37.7530620547894 | -122.440766265559 | (37.7530620547894, -122.440766265559) | |||
| 134406 | 134406 | 141984 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1077 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004054.425 | 2111804.9181 | 37.7788429977364 | -122.429547653761 | (37.7788429977364, -122.429547653761) | |||
| 128542 | 128542 | 14788 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1077 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 6 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.42960364101299 | (37.7788514015092, -122.429603641013) | ||
| 144967 | 144967 | 14791 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1077 McAllister St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 12 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.42960364101299 | (37.7788514015092, -122.429603641013) | ||
| 90947 | 90947 | 61850 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1078 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21889 | 6010226.10973791 | 2102942.52266102 | 37.754856396543204 | -122.407572245672 | (37.7548563965432, -122.407572245672) | ||
| 57357 | 57357 | 60034 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 108 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 7 | Permit Number 19523 | 6014255.56955 | 2112594.8494700002 | 37.7815842801353 | -122.39431291753401 | (37.7815842801353, -122.394312917534) | |
| 170068 | 170068 | 227213 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1085 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007654.8641 | 2103387.34278 | 37.7559335082294 | -122.416495860392 | (37.7559335082294, -122.416495860392) | |||
| 176961 | 176961 | 227212 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1085 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007655.00083 | 2103359.6493 | 37.7558574759534 | -122.416493425951 | (37.7558574759534, -122.416493425951) | |||
| 148097 | 148097 | 141983 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1087 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003986.8959 | 2111785.937 | 37.7787870565894 | -122.429779909358 | (37.7787870565894, -122.429779909358) | |||
| 120391 | 120391 | 61844 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1089 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21883 | 6010281.13947097 | 2102889.36180769 | 37.754713508851 | -122.40737818911 | (37.754713508851, -122.40737818911) | ||
| 185445 | 185445 | 226712 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1089 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010271.799319999 | 2102896.97753 | 37.754733897156 | -122.407411026915 | (37.754733897156, -122.407411026915) | |||
| 183784 | 183784 | 226662 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 109 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004759.3932300005 | 2108882.7963099997 | 37.7708594546408 | -122.42690072149901 | (37.7708594546408, -122.426900721499) | |||
| 187511 | 187511 | 226663 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 109 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004754.99125 | 2108900.4446099997 | 37.77090766370029 | -122.426917205171 | (37.7709076637003, -122.426917205171) | |||
| 65550 | 65550 | 207817 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997420.9118099995 | 2093893.18113 | 37.7292840068365 | -122.451203388929 | (37.7292840068365, -122.451203388929) | |||
| 79967 | 79967 | 67901 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31603 | 5997414.60785489 | 2093843.94609455 | 37.729148458175004 | -122.45122163283001 | (37.729148458175, -122.45122163283) | ||
| 115192 | 115192 | 10179 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1090X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6005708.480965099 | 2102624.2723741 | 37.7537286419918 | -122.42317286327801 | (37.7537286419918, -122.423172863278) | |||
| 98083 | 98083 | 10181 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1097X Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005777.346268901 | 2102574.3880576002 | 37.753595557271 | -122.422931166019 | (37.753595557271, -122.422931166019) | |||
| 160872 | 160872 | 226708 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1098 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6005707.60508 | 2102663.54756 | 37.7538364331257 | -122.42317868384701 | (37.7538364331257, -122.423178683847) | |||
| 42997 | 42997 | 226711 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1099 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6010275.94257 | 2102860.1164700002 | 37.7546329167906 | -122.40739409985599 | (37.7546329167906, -122.407394099856) | |||
| 85474 | 85474 | 61845 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1099 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21884 | 6010284.24906681 | 2102833.32009511 | 37.7545598048232 | -122.407363484663 | (37.7545598048232, -122.407363484663) | ||
| 187310 | 187310 | 227505 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 11 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | |||
| 32112 | 32112 | 191454 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6014422.1933 | 2115994.29604 | 37.790927639935205 | -122.39397451700701 | (37.7909276399352, -122.393974517007) | |||
| 38703 | 38703 | 191455 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6014431.23151 | 2115982.96922 | 37.7908970414242 | -122.393942451705 | (37.7908970414242, -122.393942451705) | |||
| 51641 | 51641 | 191459 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6014515.877119999 | 2115897.3284299998 | 37.790666595532606 | -122.393643582697 | (37.7906665955326, -122.393643582697) | |||
| 134273 | 134273 | 191457 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6014474.3471099995 | 2115936.1277 | 37.7907708215543 | -122.393789992334 | (37.7907708215543, -122.393789992334) | |||
| 149263 | 149263 | 191456 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6014463.08258 | 2115949.76346 | 37.7908076361998 | -122.393829922227 | (37.7908076361998, -122.393829922227) | |||
| 156782 | 156782 | 191453 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6014408.51358 | 2116009.54729 | 37.790968756046794 | -122.39402291674 | (37.7909687560468, -122.39402291674) | |||
| 159114 | 159114 | 191451 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6014385.345480001 | 2116032.04037 | 37.7910292291593 | -122.39410465341001 | (37.7910292291593, -122.39410465341) | |||
| 162552 | 162552 | 191452 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6014395.4165199995 | 2116019.0408900003 | 37.790994095352296 | -122.39406889728501 | (37.7909940953523, -122.394068897285) | |||
| 179227 | 179227 | 191458 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6014482.2077 | 2115927.0882900003 | 37.790746438249 | -122.393762161888 | (37.790746438249, -122.393762161888) | |||
| 185619 | 185619 | 191460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6014521.60501 | 2115886.5907099997 | 37.7906374305211 | -122.393623012505 | (37.7906374305211, -122.393623012505) | |||
| 153988 | 153988 | 201856 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010248.3954 | 2110901.8137 | 37.7767120417305 | -122.408056457346 | (37.7767120417305, -122.408056457346) | |||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 48797 | 48797 | 142060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004266.4173 | 2112234.0727 | 37.7800333508893 | -122.428844891753 | (37.7800333508893, -122.428844891753) | |||
| 138244 | 138244 | 142061 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004236.163 | 2112229.3455 | 37.7800186587405 | -122.428949217889 | (37.7800186587405, -122.428949217889) | |||
| 165700 | 165700 | 73647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769028 | 6011581.87532 | 2119117.15178 | 37.799343987593495 | -122.404021813977 | (37.7993439875935, -122.404021813977) | |
| 62544 | 62544 | 226705 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1100 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004844.71466 | 2096725.50128 | 37.7374831871032 | -122.42574014009199 | (37.7374831871032, -122.425740140092) | ||||
| 107510 | 107510 | 61248 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1993 12:00:00 AM | Permit Number 21122 | 6007711.12009364 | 2119245.98740089 | 37.799480713902604 | -122.417425152198 | (37.7994807139026, -122.417425152198) | ||
| 188803 | 188803 | 201857 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1104 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010239.403 | 2110891.1863 | 37.776682357885896 | -122.408086815194 | (37.7766823578859, -122.408086815194) | |||
| 38755 | 38755 | 227169 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1105 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998133.53414 | 2106486.83201 | 37.76390387397821 | -122.44964693765499 | (37.7639038739782, -122.449646937655) | |||
| 40083 | 40083 | 227170 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1105 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998136.607340001 | 2106470.82303 | 37.7638600931786 | -122.449635154751 | (37.7638600931786, -122.449635154751) | |||
| 94202 | 94202 | 61851 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1109 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21890 | 6010288.806738901 | 2102753.58958513 | 37.7543411376679 | -122.407342102556 | (37.7543411376679, -122.407342102556) | ||
| 136907 | 136907 | 226723 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1109 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010287.53935 | 2102671.43851 | 37.754115498145794 | -122.40734069452299 | (37.7541154981458, -122.407340694523) | |||
| 42571 | 42571 | 226722 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1111 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010289.0097 | 2102653.41278 | 37.7540660857915 | -122.40733433900499 | (37.7540660857915, -122.407334339005) | |||
| 123764 | 123764 | 10183 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1113 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X2 | 6005790.6047359 | 2102492.1542693 | 37.7533705104285 | -122.422879471267 | (37.7533705104285, -122.422879471267) | |||
| 43632 | 43632 | 129637 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1113 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007650.63926 | 2119186.93082 | 37.7993151562271 | -122.417630249946 | (37.7993151562271, -122.417630249946) | |||
| 71305 | 71305 | 201859 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1114 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010175.6391 | 2110829.8748 | 37.776510440443396 | -122.40830306884399 | (37.7765104404434, -122.408303068844) | |||
| 168636 | 168636 | 201858 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1114 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010186.2664 | 2110842.1371 | 37.776544704946105 | -122.40826717087499 | (37.7765447049461, -122.408267170875) | |||
| 6847 | 6847 | 14796 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1115 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003814.9868 | 2111771.4066 | 37.77873742350471 | -122.430373573251 | (37.7787374235047, -122.430373573251) | |||
| 136938 | 136938 | 201860 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1116 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010161.8818 | 2110817.0652 | 37.7764744978974 | -122.408349755778 | (37.7764744978974, -122.408349755778) | |||
| 172939 | 172939 | 201861 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1116 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010150.0088 | 2110807.2194 | 37.7764467987551 | -122.408390133412 | (37.7764467987551, -122.408390133412) | |||
| 41046 | 41046 | 227239 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1117 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6005786.23679 | 2102453.87032 | 37.753265145094794 | -122.422891855875 | (37.7532651450948, -122.422891855875) | |||
| 153989 | 153989 | 207834 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 Marston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998700.55085 | 2093216.8077 | 37.7275000279916 | -122.446730933593 | (37.7275000279916, -122.446730933593) | |||
| 27045 | 27045 | 72016 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 10 | 6014238.82874 | 2112579.70736 | 37.7815417727734 | -122.394369772655 | (37.7815417727734, -122.394369772655) | ||
| 78084 | 78084 | 61853 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21892 | 6010293.32119713 | 2102675.26098556 | 37.75412631741629 | -122.407320968841 | (37.7541263174163, -122.407320968841) | ||
| 166039 | 166039 | 226721 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1123 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6010296.192530001 | 2102509.90887 | 37.753672457944 | -122.407299383281 | (37.753672457944, -122.407299383281) | |||
| 19071 | 19071 | 10185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005788.9112599995 | 2102417.59249 | 37.7531656854677 | -122.422880028901 | (37.7531656854677, -122.422880028901) | |||
| 136619 | 136619 | 57386 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 9 | Permit Number 16225 | 6008086.74583 | 2116379.2072799997 | 37.791630372888 | -122.41592223145099 | (37.791630372888, -122.415922231451) | ||
| 184064 | 184064 | 62716 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1125 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/1986 12:00:00 AM | 17 | Permit Number 23059 | 6007595.431480001 | 2119179.891 | 37.799292719927294 | -122.417820789314 | (37.7992927199273, -122.417820789314) | |
| 72514 | 72514 | 61855 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21894 | 6010294.61104225 | 2102652.88138717 | 37.7540649402035 | -122.40731493066002 | (37.7540649402035, -122.40731493066) | ||
| 181721 | 181721 | 226720 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1127 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6010300.3347 | 2102457.6667400002 | 37.75352924447979 | -122.407281376151 | (37.7535292444798, -122.407281376151) | |||
| 87503 | 87503 | 34773 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1130 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38414 | 6008029.42163869 | 2101336.50490812 | 37.7503234289999 | -122.41505535764 | (37.7503234289999, -122.41505535764) | |
| 127865 | 127865 | 61857 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1985 12:00:00 AM | Permit Number 21897 | 6010295.90088737 | 2102630.50178879 | 37.7540035629897 | -122.407308892489 | (37.7540035629897, -122.407308892489) | ||
| 162865 | 162865 | 226719 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1131 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010302.322919999 | 2102389.91254 | 37.7533433177573 | -122.407269724513 | (37.7533433177573, -122.407269724513) | |||
| 130223 | 130223 | 227191 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1132 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997742.39239 | 2106527.65668 | 37.76399358315221 | -122.45100271691999 | (37.7639935831522, -122.45100271692) | |||
| 160933 | 160933 | 227192 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1132 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997744.69092 | 2106510.1833599997 | 37.76394573743271 | -122.450993506942 | (37.7639457374327, -122.450993506942) | |||
| 181081 | 181081 | 227190 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1132 Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997735.89415 | 2106562.64297 | 37.764089274613205 | -122.45102771536502 | (37.7640892746132, -122.451027715365) |
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");