Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 259 | 259 | 141361 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 262 | 262 | 141360 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 305 | 305 | 191509 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 905 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 2918 | 2918 | 140306 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997911.1716 | 2109955.9635 | 37.773416499401705 | -122.450666152059 | (37.7734164994017, -122.450666152059) | |||
| 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) | |||
| 2920 | 2920 | 140307 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997894.6936 | 2109955.1396 | 37.7734132939715 | -122.45072309212 | (37.7734132939715, -122.45072309212) | |||
| 3002 | 3002 | 141577 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1470 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000705.688999999 | 2110697.4418 | 37.7756119733478 | -122.44105274978997 | (37.7756119733478, -122.44105274979) | |||
| 3258 | 3258 | 253374 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
| 3625 | 3625 | 129585 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100 Webster St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2017 12:00:00 AM | 3 | Width 4ft | 6003281.99401 | 2116331.1346 | 37.7912270809146 | -122.432543180443 | (37.7912270809146, -122.432543180443) | ||
| 3852 | 3852 | 244053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Cole St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997903.1431 | 2109164.16 | 37.7712419510675 | -122.450636826227 | (37.7712419510675, -122.450636826227) | |||
| 4191 | 4191 | 244054 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Cole St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997907.6831 | 2109139.8095 | 37.771175350707296 | -122.450619366393 | (37.7711753507073, -122.450619366393) | |||
| 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) | |||
| 4579 | 4579 | 129649 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009816.83805 | 2121725.3616299997 | 37.806406712567295 | -122.41031374259501 | (37.8064067125673, -122.410313742595) | |||
| 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) | ||
| 4587 | 4587 | 129651 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 2 | Width 3ft | 6009800.43185 | 2121827.80217 | 37.8066870690198 | -122.410377757248 | (37.8066870690198, -122.410377757248) | ||
| 4592 | 4592 | 129653 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009793.38554 | 2121873.20249 | 37.806811331947706 | -122.410405350227 | (37.8068113319477, -122.410405350227) | |||
| 4593 | 4593 | 129647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009820.66032 | 2121686.06094 | 37.80629901694589 | -122.41029773825899 | (37.8062990169459, -122.410297738259) | |||
| 4601 | 4601 | 129650 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009803.21453 | 2121807.89591 | 37.8066325673946 | -122.41036672075701 | (37.8066325673946, -122.410366720757) | |||
| 4614 | 4614 | 129652 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009798.02273 | 2121850.3999900003 | 37.80674898193529 | -122.41038769114401 | (37.8067489819353, -122.410387691144) | |||
| 4616 | 4616 | 129648 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | Width 3ft | 6009818.04009 | 2121706.12273 | 37.806353954733794 | -122.41030822344901 | (37.8063539547338, -122.410308223449) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 7129 | 7129 | 20204 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002765.7195 | 2112737.651 | 37.7813309972121 | -122.434072484072 | (37.7813309972121, -122.434072484072) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 9486 | 9486 | 6754 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1215 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 8 | 3x3 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 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) | ||||
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 19637 | 19637 | 100232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983809.619390001 | 2110917.38856 | 37.775239033091104 | -122.499515726535 | (37.7752390330911, -122.499515726535) | |||
| 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) | |||
| 21367 | 21367 | 10196 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005751.90575 | 2101904.66457 | 37.7517552157318 | -122.422971548421 | (37.7517552157318, -122.422971548421) | |||
| 21469 | 21469 | 15341 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1735 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006768.902000001 | 2108274.3401 | 37.769302196475294 | -122.419906586242 | (37.7693021964753, -122.419906586242) | |||
| 21740 | 21740 | 26336 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2564 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997739.3987300005 | 2089429.54745 | 37.7170461430363 | -122.449780813452 | (37.7170461430363, -122.449780813452) | |||
| 22383 | 22383 | 1653 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006219.57926 | 2115439.98405 | 37.788946349830105 | -122.42231585899401 | (37.7889463498301, -122.422315858994) | |||
| 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) | ||
| 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) | |||
| 23407 | 23407 | 129668 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009333.59805 | 2121722.21012 | 37.806370959118205 | -122.411985864676 | (37.8063709591182, -122.411985864676) | |||
| 23408 | 23408 | 129662 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009783.75485 | 2121643.62173 | 37.806180420661505 | -122.41042245803101 | (37.8061804206615, -122.410422458031) | |||
| 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) | |||
| 23563 | 23563 | 227340 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3925 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008430.643540001 | 2096807.7680099998 | 37.7379110584464 | -122.41334767206499 | (37.7379110584464, -122.413347672065) | |||
| 23612 | 23612 | 177049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998733.2334 | 2090880.1248400002 | 37.721085906663106 | -122.44644991615299 | (37.7210859066631, -122.446449916153) | |||
| 23653 | 23653 | 227371 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1156 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008041.47882 | 2101204.6216 | 37.749961984661205 | -122.415004329382 | (37.7499619846612, -122.415004329382) | |||
| 23737 | 23737 | 129604 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1675 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004955.93946 | 2118458.8169 | 37.7971639410302 | -122.426902971605 | (37.7971639410302, -122.426902971605) | |||
| 23905 | 23905 | 207996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999475.26279 | 2094946.5125 | 37.732293618635396 | -122.44417699929 | (37.7322936186354, -122.44417699929) | |||
| 24079 | 24079 | 207947 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992701.4282599995 | 2100499.03593 | 37.74715067337829 | -122.467999226394 | (37.7471506733783, -122.467999226394) | |||
| 24084 | 24084 | 217648 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 377 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5992011.4385 | 2096784.9217 | 37.7369127922508 | -122.470114728443 | (37.7369127922508, -122.470114728443) | |||
| 24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
| 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) | |||
| 24118 | 24118 | 250112 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6006087.8268 | 2115423.32638 | 37.7888931792348 | -122.42277052116002 | (37.7888931792348, -122.42277052116) | |||
| 24191 | 24191 | 227330 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 221 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 8ft | 5998955.44589 | 2106862.7801900003 | 37.764983120694296 | -122.44683125657801 | (37.7649831206943, -122.446831256578) | |||
| 24194 | 24194 | 122139 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | ||||
| 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) | |||
| 24247 | 24247 | 227356 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007559.31004 | 2096165.80664 | 37.7360994137559 | -122.41631485115101 | (37.7360994137559, -122.416314851151) | |||
| 24341 | 24341 | 227284 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 312 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000612.642030001 | 2101912.76536 | 37.751486122399996 | -122.44074434639799 | (37.7514861224, -122.440744346398) | |||
| 24370 | 24370 | 207978 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 155 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6001108.30575 | 2095400.37488 | 37.733632849462104 | -122.43856371615101 | (37.7336328494621, -122.438563716151) | |||
| 24497 | 24497 | 227291 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 65 Zircon Pl | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.43449077742399 | (37.7428156470274, -122.434490777424) | |||
| 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) | |||
| 24746 | 24746 | 207954 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 20 Sotelo Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994065.04944 | 2100893.3637099997 | 37.7483120506561 | -122.46331257952801 | (37.7483120506561, -122.463312579528) | |||
| 24752 | 24752 | 227245 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 102 Red Rock Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000206.60136 | 2100087.0389900003 | 37.746449985492504 | -122.442017446473 | (37.7464499854925, -122.442017446473) |
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");