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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 3706 | 3706 | 226704 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 18 | Width 4ft | Permit Number 38040 | 6007388.533559999 | 2107001.8580400003 | 37.7658431486538 | -122.41767310175399 | (37.7658431486538, -122.417673101754) | |
| 4584 | 4584 | 129646 | 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 | Width 3ft | 6009824.55896 | 2121666.13191 | 37.8062445153435 | -122.41028283828899 | (37.8062445153435, -122.410282838289) | ||
| 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) | |||
| 6879 | 6879 | 6058 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1905 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6001281.6188 | 2112455.0533 | 37.780470716869395 | -122.439186474434 | (37.7804707168694, -122.439186474434) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) |
| 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) | |
| 70114 | 70114 | 38632 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 17 | 6x60 | Permit Number 767658 | 6014957.1802 | 2094111.5595 | 37.730872092312204 | -122.390593696874 | (37.7308720923122, -122.390593696874) |
| 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) | |
| 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) | |||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||||
| 95860 | 95860 | 114797 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
| 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) | ||||
| 97203 | 97203 | 89033 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 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) | ||||
| 106709 | 106709 | 56255 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 250 Randall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1973 12:00:00 AM | 12 | 3x3 | Permit Number 12381 | 6004004.54241313 | 2097731.78472111 | 37.740198698919 | -122.428716724311 | (37.740198698919, -122.428716724311) | |
| 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) | ||
| 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) | |||
| 110352 | 110352 | 89007 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 114 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52635 | 6005558.0 | 2104034.0 | 37.757590932481 | -122.42379349206001 | (37.757590932481, -122.42379349206) | ||
| 115817 | 115817 | 7994 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2250 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.42491511428301 | (37.7950822509185, -122.424915114283) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 140445 | 140445 | 6002 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.467190799 | 2112668.0181364 | 37.7811196348904 | -122.43529649933501 | (37.7811196348904, -122.435296499335) | |
| 143263 | 143263 | 14807 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1160X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003602.65321 | 2111793.09154 | 37.7787849351465 | -122.43110966583299 | (37.7787849351465, -122.431109665833) | |||
| 153048 | 153048 | 98645 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.799200885676605 | -122.434457791187 | (37.7992008856766, -122.434457791187) | ||
| 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) | |
| 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) | ||||
| 2689 | 2689 | 207839 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626X Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994826.85492 | 2091253.8672900002 | 37.721888220645 | -122.459980091334 | (37.721888220645, -122.459980091334) | |||
| 2916 | 2916 | 140305 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997929.2973 | 2109958.9845 | 37.7734258317863 | -122.450603670824 | (37.7734258317863, -122.450603670824) | |||
| 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) | ||
| 10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 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) | |||
| 23372 | 23372 | 137917 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 408 AUSTIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005199.6845 | 2115305.406 | 37.7885192491697 | -122.425834977285 | (37.7885192491697, -122.425834977285) | |||
| 23553 | 23553 | 200578 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1423 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016466.7865 | 2094992.602 | 37.7333748936582 | -122.385436067152 | (37.7333748936582, -122.385436067152) | |||
| 24110 | 24110 | 227479 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 245 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003729.9589599995 | 2109287.5082400003 | 37.771912433934105 | -122.430490439197 | (37.7719124339341, -122.430490439197) | |||
| 24229 | 24229 | 141575 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1478 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000744.6746 | 2110704.0393 | 37.7756323088735 | -122.44091836280899 | (37.7756323088735, -122.440918362809) | |||
| 24609 | 24609 | 227488 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003985.989080001 | 2109021.37679 | 37.771196202169705 | -122.429585829147 | (37.7711962021697, -122.429585829147) | |||
| 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) | ||||
| 25221 | 25221 | 129562 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3299 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000843.46741 | 2119560.3613299998 | 37.7999551030067 | -122.441212183615 | (37.7999551030067, -122.441212183615) | |||
| 25228 | 25228 | 123214 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 598 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5993175.3131800005 | 2111469.83533 | 37.7773009664124 | -122.467158112666 | (37.7773009664124, -122.467158112666) | |||
| 25497 | 25497 | 227302 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1287 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6003266.52543 | 2100725.05977 | 37.7483757406618 | -122.43148211980301 | (37.7483757406618, -122.431482119803) | |||
| 25638 | 25638 | 139004 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 155 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998267.7815 | 2110059.6372 | 37.7737215666049 | -122.44944006458599 | (37.7737215666049, -122.449440064586) | |||
| 26392 | 26392 | 207957 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995759.15859 | 2100245.2253900003 | 37.7466298786655 | -122.45740754733102 | (37.7466298786655, -122.457407547331) | |||
| 26441 | 26441 | 226744 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1198 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010266.86598 | 2102287.21405 | 37.753059346011895 | -122.40738510305599 | (37.7530593460119, -122.407385103056) | |||
| 26570 | 26570 | 226725 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2730 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010324.661 | 2102839.65935 | 37.754579472764895 | -122.407224175681 | (37.7545794727649, -122.407224175681) | |||
| 26709 | 26709 | 177070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.712548932973206 | -122.44155935339501 | (37.7125489329732, -122.441559353395) | |||
| 26782 | 26782 | 141376 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 340 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000731.9492 | 2110174.3711 | 37.7741772489645 | -122.440924377301 | (37.7741772489645, -122.440924377301) | |||
| 27711 | 27711 | 142321 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1542 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000429.2107 | 2110311.8766 | 37.7745375574505 | -122.441981472333 | (37.7745375574505, -122.441981472333) | |||
| 28241 | 28241 | 227326 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 279 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004157.53404 | 2096855.56287 | 37.737801450879104 | -122.42812531304199 | (37.7378014508791, -122.428125313042) | |||
| 29149 | 29149 | 226660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.5122 | 2108095.82328 | 37.7686970968169 | -122.426937645858 | (37.7686970968169, -122.426937645858) | |||
| 30591 | 30591 | 207827 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5999363.8655900005 | 2093797.08144 | 37.7291311940404 | -122.444479544704 | (37.7291311940404, -122.444479544704) | |||
| 30756 | 30756 | 124328 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 116 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5995929.77747 | 2113622.35703 | 37.783369832624004 | -122.45778538742901 | (37.783369832624, -122.457785387429) | |||
| 31136 | 31136 | 201239 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 832 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6012006.1458 | 2112576.455 | 37.7814084789041 | -122.4020936026 | (37.7814084789041, -122.4020936026) | |||
| 31254 | 31254 | 129563 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2270 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000463.82549 | 2119961.7151099998 | 37.8010354810636 | -122.442554716754 | (37.8010354810636, -122.442554716754) | |||
| 31932 | 31932 | 191468 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014292.29593 | 2112680.8823700002 | 37.7818225483087 | -122.394191885869 | (37.7818225483087, -122.394191885869) | |||
| 32071 | 32071 | 227389 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3014 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009181.84583 | 2104530.5514 | 37.759158255859106 | -122.411295791464 | (37.7591582558591, -122.411295791464) | |||
| 32805 | 32805 | 227501 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 49 Everson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003541.82296 | 2097107.65785 | 37.738458790548 | -122.430272104489 | (37.738458790548, -122.430272104489) | |||
| 33361 | 33361 | 246400 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 612 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998516.7885 | 2108556.8079 | 37.7696094224276 | -122.448470464048 | (37.7696094224276, -122.448470464048) | |||
| 33884 | 33884 | 227436 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 18 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000934.92196 | 2104940.29183 | 37.759817324036796 | -122.439846911128 | (37.7598173240368, -122.439846911128) | |||
| 34201 | 34201 | 142176 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1480 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000776.2338 | 2110357.6285 | 37.774682949664204 | -122.44078433758999 | (37.7746829496642, -122.44078433759) | |||
| 34744 | 34744 | 177051 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.44564302283199 | (37.7191438872553, -122.445643022832) | |||
| 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) | ||||
| 34920 | 34920 | 226714 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1208 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010278.22843 | 2102080.18456 | 37.7524915248726 | -122.407331215672 | (37.7524915248726, -122.407331215672) | |||
| 35313 | 35313 | 208011 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 126 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998765.6075 | 2093383.3893099998 | 37.727961138279205 | -122.446518012793 | (37.7279611382792, -122.446518012793) | |||
| 35392 | 35392 | 227233 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3591 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006377.06245 | 2104334.1505299998 | 37.7584612794952 | -122.420982147336 | (37.7584612794952, -122.420982147336) | |||
| 35764 | 35764 | 143380 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1897 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003965.1287 | 2118668.8078 | 37.7976844492982 | -122.430346412036 | (37.7976844492982, -122.430346412036) |
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");