Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8115 | 8115 | 12319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 999 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 18 | 6004795.7539 | 2112145.0577 | 37.7798188836778 | -122.427007335387 | (37.7798188836778, -122.427007335387) | |||
| 10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 25107 | 25107 | 191446 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Tulare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6016252.95003 | 2100312.60959 | 37.747970718394704 | -122.386546192477 | (37.7479707183947, -122.386546192477) | ||||
| 25839 | 25839 | 36982 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 251 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39606 | 5993044.7391 | 2113780.4585 | 37.7836377719626 | -122.467777899893 | (37.7836377719626, -122.467777899893) | ||
| 28383 | 28383 | 49433 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 364@ KEARNY Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 8 | Permit Number 46371 | 6011642.68179 | 2116034.05853 | 37.7908819508039 | -122.403594362585 | (37.7908819508039, -122.403594362585) | ||
| 34798 | 34798 | 122131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.120209999 | 2115013.7594 | 37.786912464412104 | -122.47454361357 | (37.7869124644121, -122.47454361357) | ||||
| 36259 | 36259 | 208014 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998954.765869999 | 2093228.45695 | 37.7275465328469 | -122.44585295156901 | (37.7275465328469, -122.445852951569) | ||||
| 38218 | 38218 | 71535 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1145 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1995 12:00:00 AM | 6 | 6007520.46607 | 2118819.9604700003 | 37.7983002218264 | -122.41805466610201 | (37.7983002218264, -122.418054666102) | ||
| 42545 | 42545 | 227299 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002389.0649 | 2100323.63751 | 37.7472237585745 | -122.43448765677499 | (37.7472237585745, -122.434487656775) | ||||
| 44989 | 44989 | 72175 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 9 | 6000606.57902 | 2119937.60106 | 37.80097740645329 | -122.44205899784201 | (37.8009774064533, -122.442058997842) | ||
| 47166 | 47166 | 227292 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1831 Castro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6002653.15618 | 2100170.70248 | 37.746818822623894 | -122.433563522461 | (37.7468188226239, -122.433563522461) | ||||
| 47461 | 47461 | 247844 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6009115.842759999 | 2098211.0441099997 | 37.7418025958075 | -122.41107768521002 | (37.7418025958075, -122.41107768521) | ||||
| 52226 | 52226 | 247946 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 15 Joy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | 6010368.2533 | 2098885.09245 | 37.7437235405125 | -122.406794734117 | (37.7437235405125, -122.406794734117) | ||||
| 54549 | 54549 | 227289 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 687 29th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002191.96194 | 2098829.02358 | 37.743108709092496 | -122.435062343346 | (37.7431087090925, -122.435062343346) | ||||
| 55289 | 55289 | 177095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | ||||
| 58120 | 58120 | 40227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.0178400003 | 37.78138030849961 | -122.39387241520001 | (37.7813803084996, -122.3938724152) | ||
| 64784 | 64784 | 37497 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 645 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010338.55748 | 2115802.28849 | 37.790172633000005 | -122.408090243478 | (37.790172633, -122.408090243478) | |
| 70732 | 70732 | 46972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228081996 | -122.50333832645 | (37.755217228082, -122.50333832645) | |
| 73281 | 73281 | 114558 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.42581446009599 | (37.7936541667538, -122.425814460096) | ||
| 75056 | 75056 | 32770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37143 | 6000719.0381 | 2110275.1768 | 37.7744533006426 | -122.440976272213 | (37.7744533006426, -122.440976272213) | |
| 83421 | 83421 | 41268 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091001 | (37.7726810295415, -122.42136607091) | |||
| 88091 | 88091 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 95375 | 95375 | 98676 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 96424 | 96424 | 37257 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | ||
| 96494 | 96494 | 110186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 625 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006167.62160945 | 2096413.49051844 | 37.736701142359294 | -122.421144072665 | (37.7367011423593, -122.421144072665) | ||||
| 99490 | 99490 | 34781 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1167 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38419 | 6008092.50780159 | 2101138.05263813 | 37.74978206863771 | -122.41482315731301 | (37.7497820686377, -122.414823157313) | ||
| 99934 | 99934 | 33771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 100780 | 100780 | 63619 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 801X Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1987 12:00:00 AM | Permit Number 24261 | 5993268.63068404 | 2106608.32607844 | 37.7639579422382 | -122.466481867874 | (37.7639579422382, -122.466481867874) | |||
| 102595 | 102595 | 34533 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 395 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | Permit Number 38241 | 6007729.86435225 | 2097252.7163141 | 37.7390934181522 | -122.415802113579 | (37.7390934181522, -122.415802113579) | |||
| 103792 | 103792 | 35727 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.41262825854099 | (37.7280780839519, -122.412628258541) | ||
| 103890 | 103890 | 32822 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4251 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37180 | 6001518.68863728 | 2102305.7083643 | 37.7526166065877 | -122.43763927134898 | (37.7526166065877, -122.437639271349) | ||
| 106587 | 106587 | 122454 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||||
| 106910 | 106910 | 40057 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | ||
| 129054 | 129054 | 101245 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.763865841987204 | -122.465411719392 | (37.7638658419872, -122.465411719392) | |||
| 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) | ||
| 137832 | 137832 | 37501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 830 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1998 12:00:00 AM | 9 | Permit Number 39965 | 6009497.3756099995 | 2115737.1064 | 37.7899465245609 | -122.41099607352601 | (37.7899465245609, -122.410996073526) | ||
| 148274 | 148274 | 72147 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 73 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 10 | 6001070.59946 | 2093593.78195 | 37.7286702168354 | -122.43856467842 | (37.7286702168354, -122.43856467842) | ||
| 154902 | 154902 | 191501 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 299x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6016915.88272 | 2095866.14342 | 37.735798300938704 | -122.383944206463 | (37.7357983009387, -122.383944206463) | ||||
| 159072 | 159072 | 227265 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6001689.18438 | 2099736.15615 | 37.7455709197615 | -122.436865735887 | (37.7455709197615, -122.436865735887) | ||||
| 161571 | 161571 | 107462 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6008769.702769999 | 2118455.29192 | 37.797369163620296 | -122.41370610855101 | (37.7973691636203, -122.413706108551) | ||||
| 172576 | 172576 | 30910 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 500 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 11 | Permit Number 34732 | 5994801.3845 | 2091947.2904299998 | 37.723790729247 | -122.46011834680901 | (37.723790729247, -122.460118346809) | ||
| 176161 | 176161 | 31106 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | |
| 179791 | 179791 | 36154 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.8051 | 2114133.6254 | 37.7848092398389 | -122.45567731688699 | (37.7848092398389, -122.455677316887) | |
| 186737 | 186737 | 73860 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1652 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1993 12:00:00 AM | 12 | 6008793.24364 | 2118610.57457 | 37.7977968533 | -122.41363563948299 | (37.7977968533, -122.413635639483) | ||
| 78058 | 78058 | 20276 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 86580 | 86580 | 20261 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 4 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | ||
| 87631 | 87631 | 20266 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 140346 | 140346 | 20271 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | |||
| 118724 | 118724 | 194 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 419X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X3 | 6005567.0759942 | 2106542.8569591 | 37.7644801752938 | -122.423940505082 | (37.7644801752938, -122.423940505082) | |||
| 67888 | 67888 | 101143 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6013205.5803 | 2104971.74956 | 37.760594538837296 | -122.397410636805 | (37.7605945388373, -122.397410636805) | |||
| 99786 | 99786 | 10163 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1013 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 6005764.7450429 | 2102960.7456767 | 37.7546556947331 | -122.423002202394 | (37.7546556947331, -122.423002202394) | |||
| 582 | 582 | 27390 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | |||
| 2283 | 2283 | 7972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1950 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005640.29534 | 2116816.4309400003 | 37.7926930351995 | -122.424418048575 | (37.7926930351995, -122.424418048575) | |||
| 2886 | 2886 | 7974 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.935869999 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | |||
| 4694 | 4694 | 7986 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | |||
| 5334 | 5334 | 17712 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1214 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6002329.348999999 | 2112708.9615 | 37.7812274480895 | -122.435580057373 | (37.7812274480895, -122.435580057373) | |||
| 6112 | 6112 | 17719 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6002302.3774 | 2112913.4677 | 37.78178743852221 | -122.43568800125799 | (37.7817874385222, -122.435688001258) | |||
| 6348 | 6348 | 7967 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1901 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005619.52925 | 2116640.16995 | 37.7922078941213 | -122.424477357045 | (37.7922078941213, -122.424477357045) | |||
| 7479 | 7479 | 7952 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1740 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005743.00192 | 2116111.2494799998 | 37.7907625828685 | -122.424012509171 | (37.7907625828685, -122.424012509171) | |||
| 10599 | 10599 | 25290 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000711.5604 | 2091742.5944599998 | 37.7235668493142 | -122.439673234935 | (37.7235668493142, -122.439673234935) | |||
| 14345 | 14345 | 25704 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6012091.3603 | 2110309.05533 | 37.7751874779549 | -122.401639385748 | (37.7751874779549, -122.401639385748) | |||
| 16320 | 16320 | 12187 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016297.2469 | 2095451.6147 | 37.7346258690942 | -122.386054205025 | (37.7346258690942, -122.386054205025) | |||
| 16421 | 16421 | 12185 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016337.4341 | 2095323.5181 | 37.734276365571105 | -122.385906337047 | (37.7342763655711, -122.385906337047) | |||
| 16766 | 16766 | 12174 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1415X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6016429.1110000005 | 2095062.9295 | 37.7335659143966 | -122.385571222674 | (37.7335659143966, -122.385571222674) | |||
| 17545 | 17545 | 17038 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001065.34359 | 2109713.09337 | 37.772929678688506 | -122.43973803201 | (37.7729296786885, -122.43973803201) | |||
| 19050 | 19050 | 4227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3984 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2003 12:00:00 AM | 5 | 3X3 | 6004005.18822 | 2100441.9925599997 | 37.7476403416378 | -122.428907662964 | (37.7476403416378, -122.428907662964) | ||
| 22502 | 22502 | 1654 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1992 12:00:00 AM | 3 | 3X3 | 6006190.88992 | 2115436.6109700003 | 37.788935469840105 | -122.42241488063699 | (37.7889354698401, -122.422414880637) | ||
| 23288 | 23288 | 15312 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1665 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/27/2001 12:00:00 AM | 4 | 3X3 | 6006906.5597 | 2108955.7422 | 37.771180919322 | -122.419478782903 | (37.771180919322, -122.419478782903) | ||
| 44679 | 44679 | 101107 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | Permit Number 14067 | 5988779.1453 | 2103160.9003 | 37.7542321578078 | -122.48175694812299 | (37.7542321578078, -122.481756948123) | ||
| 82904 | 82904 | 12198 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1485 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016165.701365701 | 2095622.0691082 | 37.7350866214264 | -122.38652088789301 | (37.7350866214264, -122.386520887893) | |||
| 83389 | 83389 | 422 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 685X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005653.198434 | 2104994.6037312 | 37.7602338989595 | -122.423532549649 | (37.7602338989595, -122.423532549649) | |||
| 88966 | 88966 | 8120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 850X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | |||
| 93142 | 93142 | 12170 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1421X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1993 12:00:00 AM | 9 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | ||
| 102821 | 102821 | 7209 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
| 106974 | 106974 | 25707 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 582 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6012142.68592 | 2110270.08873 | 37.7750833484994 | -122.401459098675 | (37.7750833484994, -122.401459098675) | |||
| 107274 | 107274 | 12183 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016331.060111799 | 2095306.4617143 | 37.7342291794135 | -122.385927185653 | (37.7342291794135, -122.385927185653) | |||
| 107293 | 107293 | 27486 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2113 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.42343749988899 | (37.7949042735724, -122.423437499889) | |||
| 112287 | 112287 | 12177 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1409X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 121009 | 121009 | 2694 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003424.2987912 | 2114891.8357248 | 37.787283200782 | -122.431947991092 | (37.787283200782, -122.431947991092) | |||
| 123069 | 123069 | 1691 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017695.7876646 | 2093605.1145141998 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | |||
| 124120 | 124120 | 2170 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2299X FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005396.0 | 2117789.0 | 37.7953496659997 | -122.42533256183701 | (37.7953496659997, -122.425332561837) | |||
| 129338 | 129338 | 12165 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1439X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 143245 | 143245 | 17111 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1837 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5998183.72781 | 2109230.9980599997 | 37.7714415276809 | -122.44967109380501 | (37.7714415276809, -122.449671093805) | |||
| 145506 | 145506 | 12205 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 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) | ||
| 166 | 166 | 251230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 9709 | 9709 | 121554 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 330 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 779292 | 6001441.0 | 2103840.0 | 37.7568249841019 | -122.438017823933 | (37.7568249841019, -122.438017823933) | ||
| 10235 | 10235 | 173926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997414.0 | 2094357.0 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | ||||
| 10409 | 10409 | 104687 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | |||
| 31106 | 31106 | 114466 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009278.4623 | 2121786.53745 | 37.8065444922964 | -122.412181221704 | (37.8065444922964, -122.412181221704) | |||
| 47750 | 47750 | 96007 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009660.15049 | 2116404.46705 | 37.791788061820704 | -122.41048002812599 | (37.7917880618207, -122.410480028126) |
| 52422 | 52422 | 34688 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) |
| 71584 | 71584 | 97818 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 431 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5997175.35999 | 2114852.37402 | 37.7868186114345 | -122.453565028427 | (37.7868186114345, -122.453565028427) | |||
| 78027 | 78027 | 107959 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2299X 25TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012136.0 | 2101880.0 | 37.752045663585896 | -122.400892625965 | (37.7520456635859, -122.400892625965) | ||||
| 80541 | 80541 | 111018 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2015 12:00:00 AM | 3x3 | 5998894.0 | 2107683.0 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | |||
| 81087 | 81087 | 103602 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
| 81547 | 81547 | 103610 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | ||||
| 87413 | 87413 | 116811 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3660x 23RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005401.0 | 2102665.0 | 37.7538231135776 | -122.42423909941999 | (37.7538231135776, -122.42423909942) | ||||
| 89173 | 89173 | 117520 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1601 PAGE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998904.0 | 2109014.0 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | ||||
| 91394 | 91394 | 121040 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006363.0 | 2118098.0 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) |
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");