Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker
qCareAssistant ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78421 | 78421 | 88365 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411001 | (37.7707473776731, -122.44194989411) | |||
| 175263 | 175263 | 226690 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1451 San Bruno Ave | 0 | Front Yard : Yard 7 | Tree 1 | Private 1 | 0 | 6011227.792669999 | 2101285.4147 | 37.7503623610541 | -122.40399151941901 | (37.7503623610541, -122.403991519419) | ||||
| 167 | 167 | 251232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 286 | 286 | 10157 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005745.7610599995 | 2103227.37374 | 37.755386722241504 | -122.42308680461201 | (37.7553867222415, -122.423086804612) | |||
| 291 | 291 | 129605 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 4ft | 6005928.19437 | 2117729.67294 | 37.79521682154579 | -122.42348685993299 | (37.7952168215458, -122.423486859933) | |||
| 888 | 888 | 14525 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 638 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999197.0779 | 2110617.9064 | 37.7753075467631 | -122.44626566212901 | (37.7753075467631, -122.446265662129) | |||
| 1494 | 1494 | 251576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490X Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998892.0 | 2109203.0 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | ||||
| 2021 | 2021 | 7975 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2003 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005570.14471 | 2116971.5183099997 | 37.793114904479296 | -122.42467181028 | (37.7931149044793, -122.42467181028) | |||
| 2069 | 2069 | 129587 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1911 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 15 | Width 4ft | Permit Number 52344 | 6003864.05358 | 2118305.88007 | 37.79668221737371 | -122.43067024784901 | (37.7966822173737, -122.430670247849) | |
| 2091 | 2091 | 12295 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 845 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004849.7362 | 2111749.3214 | 37.778735341492705 | -122.426792396306 | (37.7787353414927, -122.426792396306) | |||
| 2255 | 2255 | 191499 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1196 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6016833.73477 | 2094673.4854599999 | 37.732518958184706 | -122.38414519683998 | (37.7325189581847, -122.38414519684) | |||
| 2259 | 2259 | 191494 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 4ft | 6016613.84098 | 2094824.1997599998 | 37.7329206295756 | -122.384915925743 | (37.7329206295756, -122.384915925743) | |||
| 2346 | 2346 | 14522 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 616 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999189.6891 | 2110673.8503 | 37.7754607324086 | -122.446295246866 | (37.7754607324086, -122.446295246866) | |||
| 2567 | 2567 | 252819 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 407 Miguel St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | Permit Number 780051 | 6004479.0 | 2096413.0 | 37.736604456337105 | -122.426982337456 | (37.7366044563371, -122.426982337456) | ||
| 2919 | 2919 | 140304 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997945.3633 | 2109960.495 | 37.7734308988042 | -122.45054820541701 | (37.7734308988042, -122.450548205417) | |||
| 3052 | 3052 | 17713 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1230 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002323.545 | 2112760.8562 | 37.7813696081859 | -122.435603850031 | (37.7813696081859, -122.435603850031) | |||
| 4112 | 4112 | 226674 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 145 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2015 12:00:00 AM | 18 | Width 7ft | Permit Number 21993 | 6005571.69833 | 2100193.82022 | 37.747047459974 | -122.423473113803 | (37.747047459974, -122.423473113803) | |
| 4235 | 4235 | 13003 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 363 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6010581.7377 | 2120629.8347 | 37.803441513904204 | -122.40758936746 | (37.8034415139042, -122.40758936746) | |||
| 4819 | 4819 | 38523 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773138 | 6008768.83808 | 2118471.22766 | 37.7974128706661 | -122.41371022836 | (37.7974128706661, -122.41371022836) | |
| 5062 | 5062 | 17716 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1238 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 6 | 3X3 | 6002311.2541 | 2112835.6256 | 37.7815742079744 | -122.43565172132 | (37.7815742079744, -122.43565172132) | ||
| 5410 | 5410 | 41173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3253 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779130 | 5999305.0198 | 2120031.7499700002 | 37.801161655947396 | -122.446569707626 | (37.8011616559474, -122.446569707626) | |
| 5523 | 5523 | 13045 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 529 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009805.9101 | 2120528.6658 | 37.803120271111105 | -122.410267014555 | (37.8031202711111, -122.410267014555) | |||
| 5561 | 5561 | 63512 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1912 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 24121 | 6000303.945 | 2111684.2477 | 37.7782986006192 | -122.442513341395 | (37.7782986006192, -122.442513341395) |
| 5649 | 5649 | 102624 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 305 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010336.6771 | 2120942.4897 | 37.8042862667019 | -122.408459480806 | (37.8042862667019, -122.408459480806) | |||
| 5669 | 5669 | 102626 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2039 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001408.07759 | 2115496.16268 | 37.7888280197366 | -122.43896700003799 | (37.7888280197366, -122.438967000038) | |||
| 5679 | 5679 | 17669 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1015X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002374.7226 | 2112093.816 | 37.779540990434604 | -122.435379071124 | (37.7795409904346, -122.435379071124) | ||
| 5856 | 5856 | 120901 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2032 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778866 | 6001448.95372 | 2115547.55562 | 37.7889714571097 | -122.438829258958 | (37.7889714571097, -122.438829258958) | |
| 5902 | 5902 | 27389 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6007143.328369999 | 2120019.7231400004 | 37.801573234283296 | -122.419444839906 | (37.8015732342833, -122.419444839906) | |||
| 5980 | 5980 | 11435 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005584.47186 | 2117242.36199 | 37.7938593821703 | -122.42464151300501 | (37.7938593821703, -122.424641513005) | |||
| 6170 | 6170 | 7970 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1930 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6005659.59563 | 2116718.6943 | 37.792425764795205 | -122.42434431405701 | (37.7924257647952, -122.424344314057) | |||
| 6419 | 6419 | 14764 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 979 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1992 12:00:00 AM | 6 | 4X4 | 6004493.2004 | 2111862.6209 | 37.7790262692006 | -122.428033869018 | (37.7790262692006, -122.428033869018) | ||
| 6503 | 6503 | 20205 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002758.336 | 2112798.3603 | 37.7814972706416 | -122.43410236848699 | (37.7814972706416, -122.434102368487) | |||
| 6656 | 6656 | 105519 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 649 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5999623.0034 | 2110786.8502 | 37.775795739067995 | -122.44480443932 | (37.775795739068, -122.44480443932) | |||
| 6722 | 6722 | 7978 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2020 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005621.04444 | 2116972.96262 | 37.793121744726896 | -122.424495796768 | (37.7931217447269, -122.424495796768) | |||
| 6757 | 6757 | 7971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1950 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6005647.3062 | 2116796.9112400003 | 37.7926398349056 | -122.42439240168999 | (37.7926398349056, -122.42439240169) | |||
| 6795 | 6795 | 13050 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 547 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009740.1627 | 2120520.7485 | 37.8030948465246 | -122.41049397668002 | (37.8030948465246, -122.41049397668) | |||
| 6808 | 6808 | 7969 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1920 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005664.22303 | 2116673.38884 | 37.7923016286726 | -122.42432507933998 | (37.7923016286726, -122.42432507934) | |||
| 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) | |||
| 7155 | 7155 | 17717 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1244 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1992 12:00:00 AM | 6 | 3X3 | 6002311.9369 | 2112856.7932 | 37.7816323676405 | -122.435650874011 | (37.7816323676405, -122.435650874011) | ||
| 7670 | 7670 | 7966 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1901 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005614.52229 | 2116667.02972 | 37.7922813615542 | -122.424496592638 | (37.7922813615542, -122.424496592638) | |||
| 7848 | 7848 | 51578 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47872 | |||||||||
| 7964 | 7964 | 6057 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1905 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001269.0972 | 2112453.6996 | 37.780466287428105 | -122.43922969539301 | (37.7804662874281, -122.439229695393) | |||
| 8224 | 8224 | 13047 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 539 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009759.7837 | 2120522.8139 | 37.8031016175536 | -122.41042622336799 | (37.8031016175536, -122.410426223368) | |||
| 8493 | 8493 | 21649 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1688 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004570.4383 | 2114705.5152 | 37.7868365199802 | -122.42796930808301 | (37.7868365199802, -122.427969308083) | |||
| 8498 | 8498 | 18823 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005861.74139 | 2116275.81208 | 37.7912211336846 | -122.423613381076 | (37.7912211336846, -122.423613381076) | |||
| 8501 | 8501 | 17711 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1214 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6002331.3974 | 2112685.404 | 37.7811628814816 | -122.435571285126 | (37.7811628814816, -122.435571285126) | |||
| 8692 | 8692 | 2693 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2107 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1991 12:00:00 AM | 6 | 3X3 | 6003334.0194 | 2114827.0332 | 37.7871001510547 | -122.432255708662 | (37.7871001510547, -122.432255708662) | ||
| 9955 | 9955 | 173749 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3299x 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006897.0 | 2106023.0 | 37.7631277620706 | -122.41930377135598 | (37.7631277620706, -122.419303771356) | ||||
| 10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10226 | 10226 | 173925 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997414.0 | 2094357.0 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | ||||
| 10520 | 10520 | 95069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | ||||
| 10748 | 10748 | 47214 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 570 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 6x4 | Permit Number 45165 | 6008824.68232 | 2093406.4927400001 | 37.728594004685895 | -122.41174501811301 | (37.7285940046859, -122.411745018113) |
| 10803 | 10803 | 25289 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000745.99488 | 2091748.7856599998 | 37.72358580881671 | -122.439554644937 | (37.7235858088167, -122.439554644937) | |||
| 11054 | 11054 | 1139 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5998352.02606 | 2088442.52333 | 37.7143710331717 | -122.447592253902 | (37.7143710331717, -122.447592253902) | |||
| 11106 | 11106 | 25304 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 5999755.51283 | 2091622.1717 | 37.7231817335313 | -122.44296946786501 | (37.7231817335313, -122.442969467865) | |||
| 11402 | 11402 | 1130 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2554 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5998598.100380001 | 2088668.31183 | 37.7150050570134 | -122.446757963627 | (37.7150050570134, -122.446757963627) | |||
| 11487 | 11487 | 110355 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988563.2444 | 2106497.4984 | 37.763380996470005 | -122.482748079472 | (37.76338099647, -122.482748079472) | |||
| 11537 | 11537 | 25293 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6000659.82425 | 2091738.03378 | 37.7235513818789 | -122.43985175036998 | (37.7235513818789, -122.43985175037) | |||
| 11709 | 11709 | 25297 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 164 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000520.37509 | 2091718.7559 | 37.723490510352995 | -122.440332418218 | (37.723490510353, -122.440332418218) | |||
| 11719 | 11719 | 54938 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 14 | 4x3 | Permit Number 10816 | 6013051.4266099995 | 2086907.8440900003 | 37.7109862260136 | -122.39667743572599 | (37.7109862260136, -122.396677435726) | |
| 12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 12673 | 12673 | 25310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 197 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000354.040159999 | 2091646.91959 | 37.7232837922084 | -122.440902255631 | (37.7232837922084, -122.440902255631) | |||
| 13006 | 13006 | 25299 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000418.66631 | 2091706.69164 | 37.7234515931109 | -122.44068314123001 | (37.7234515931109, -122.44068314123) | |||
| 14180 | 14180 | 12213 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1503 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016014.681 | 2095761.1814 | 37.7354602343635 | -122.387052723732 | (37.7354602343635, -122.387052723732) | |||
| 14202 | 14202 | 12169 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1425X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016491.2755 | 2094964.9733 | 37.7333003856228 | -122.38534947643299 | (37.7333003856228, -122.385349476433) | ||
| 14416 | 14416 | 12182 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1447 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016313.573 | 2095416.4509 | 37.734530219899895 | -122.38599530928002 | (37.7345302198999, -122.38599530928) | |||
| 14646 | 14646 | 112141 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 299 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6011568.52353 | 2112270.39261 | 37.780543667385395 | -122.403586031292 | (37.7805436673854, -122.403586031292) | |||
| 14762 | 14762 | 12188 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1457 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016282.8047 | 2095488.6622 | 37.734726794786404 | -122.386106718848 | (37.7347267947864, -122.386106718848) | |||
| 14796 | 14796 | 25703 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6012079.76947 | 2110324.35268 | 37.7752288341828 | -122.401680556721 | (37.7752288341828, -122.401680556721) | |||
| 14865 | 14865 | 12184 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1445 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016331.1548 | 2095344.2396 | 37.734332915157296 | -122.385929490724 | (37.7343329151573, -122.385929490724) | |||
| 15422 | 15422 | 12186 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1455 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016291.5956 | 2095467.9407 | 37.7346703842439 | -122.38607488138001 | (37.7346703842439, -122.38607488138) | |||
| 15744 | 15744 | 12173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1411X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 9 | 3X3 | 6016408.3895 | 2095102.4888 | 37.733673389774204 | -122.385645619675 | (37.7336733897742, -122.385645619675) | ||
| 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) | ||
| 16102 | 16102 | 12179 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1405X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016402.1103 | 2095116.3031 | 37.733710973632995 | -122.385668291381 | (37.733710973633, -122.385668291381) | |||
| 16400 | 16400 | 1687 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 15 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017775.00772 | 2093610.25153 | 37.729651522897 | -122.38081707126301 | (37.729651522897, -122.380817071263) | ||
| 16425 | 16425 | 12214 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1505 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6015992.7036 | 2095777.5074 | 37.735503845269 | -122.38712984693001 | (37.735503845269, -122.38712984693) | |||
| 16755 | 16755 | 12181 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1401X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016385.1563 | 2095160.2578 | 37.733830726311396 | -122.385729969415 | (37.7338307263114, -122.385729969415) | |||
| 16816 | 16816 | 12175 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1413X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016419.0642 | 2095079.8835 | 37.733611910792796 | -122.385607138859 | (37.7336119107928, -122.385607138859) | |||
| 17247 | 17247 | 10229 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1417 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005889.94053 | 2100616.0721299998 | 37.748224824522296 | -122.422402655257 | (37.7482248245223, -122.422402655257) | |||
| 17605 | 17605 | 10230 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1426 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2x3 | 6005817.36142 | 2100645.21865 | 37.7483007596771 | -122.42265570290199 | (37.7483007596771, -122.422655702902) | |||
| 17617 | 17617 | 26521 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2837 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 7.5x7 | 6009000.88013 | 2101922.6219900004 | 37.7519873190611 | -122.411737385595 | (37.7519873190611, -122.411737385595) | |||
| 17678 | 17678 | 10075 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 595 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6005616.34075 | 2105560.18901 | 37.7617847825636 | -122.423700237591 | (37.7617847825636, -122.423700237591) | |||
| 17896 | 17896 | 10143 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 920 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005657.84848 | 2103570.5399700003 | 37.7563240154596 | -122.423415228047 | (37.7563240154596, -122.423415228047) | |||
| 18011 | 18011 | 103601 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
| 18155 | 18155 | 1705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017900.557664401 | 2093604.0676713001 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | |||
| 18162 | 18162 | 10221 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1370 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6005802.11698 | 2100976.8322900003 | 37.7492104347131 | -122.42273198069599 | (37.7492104347131, -122.422731980696) | |||
| 18782 | 18782 | 10078 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 615 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005625.0168 | 2105365.53505 | 37.761250798395295 | -122.42365639023599 | (37.7612507983953, -122.423656390236) | |||
| 18810 | 18810 | 10105 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 779 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 18 | 4x4 | 6005674.55908 | 2104459.44386 | 37.7587656810971 | -122.42342062756201 | (37.7587656810971, -122.423420627562) | ||
| 18862 | 18862 | 10055 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 432 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X2 | 6005503.26278 | 2106415.24362 | 37.7641261764966 | -122.424152141508 | (37.7641261764966, -122.424152141508) | |||
| 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) | |||
| 19433 | 19433 | 10011 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X3 | 6005417.15338 | 2107897.14895 | 37.76819027309789 | -122.424555388522 | (37.7681902730979, -122.424555388522) | |||
| 19488 | 19488 | 10031 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 310 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 2x3 | 6005459.49344 | 2107143.4221799998 | 37.7661231103266 | -122.42435532265301 | (37.7661231103266, -122.424355322653) | |||
| 19677 | 19677 | 55532 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 630 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | Permit Number 11496 | 5993837.97104338 | 2106679.85882422 | 37.7641871892319 | -122.464517899057 | (37.7641871892319, -122.464517899057) | |||
| 19690 | 19690 | 69083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1406 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 10 | 3x3 | Permit Number 33092 | 5992130.4466308 | 2105856.46587897 | 37.761827789630104 | -122.470363712817 | (37.7618277896301, -122.470363712817) |
| 19969 | 19969 | 10013 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.42427222529899 | (37.7676948680391, -122.424272225299) | |||
| 20101 | 20101 | 10202 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1243 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005829.09689 | 2101725.42508 | 37.7512674207747 | -122.42269187452601 | (37.7512674207747, -122.422691874526) | |||
| 20132 | 20132 | 10004 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.768821154693896 | -122.424619539876 | (37.7688211546939, -122.424619539876) | |||
| 20212 | 20212 | 5507 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 800 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2x2 | 6004984.13536 | 2103653.10654 | 37.756512676133 | -122.42575103988999 | (37.756512676133, -122.42575103989) | |||
| 20274 | 20274 | 10158 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1001 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005753.82676 | 2103093.98635 | 37.7550209265961 | -122.423049430612 | (37.7550209265961, -122.423049430612) | |||
| 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) |
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");