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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 323 | 323 | 27392 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.801646927424706 | -122.419461214785 | (37.8016469274247, -122.419461214785) | |||
| 582 | 582 | 27390 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | |||
| 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) | ||||
| 1858 | 1858 | 12328 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952523996 | -122.427164094387 | (37.780578952524, -122.427164094387) | |||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 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) | |||
| 2219 | 2219 | 122754 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 6011277.363419999 | 2105334.1858 | 37.761482160689894 | -122.404105006665 | (37.7614821606899, -122.404105006665) | |||
| 2240 | 2240 | 122755 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.40411744427601 | (37.7615439863765, -122.404117444276) | |||
| 2246 | 2246 | 191498 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 4ft | 6016692.24365 | 2094766.72457 | 37.732767150375295 | -122.38464086270099 | (37.7327671503753, -122.384640862701) | |||
| 2249 | 2249 | 191500 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1196 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 3ft | 6016876.9140800005 | 2094649.78681 | 37.732456273623704 | -122.38399426453998 | (37.7324562736237, -122.38399426454) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 2886 | 2886 | 7974 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005597.935869999 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 3383 | 3383 | 17357 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2200 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005533.42048 | 2117633.73572 | 37.794931112339796 | -122.42484601254 | (37.7949311123398, -122.42484601254) | |||
| 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) | ||
| 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) | |
| 3801 | 3801 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.72285164275971 | -122.445718558684 | (37.7228516427597, -122.445718558684) | |||
| 3805 | 3805 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998924.5969 | 2091518.7811599998 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | |||
| 3806 | 3806 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998978.57855 | 2091518.5364400002 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | |||
| 3808 | 3808 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369563999 | (37.7228504376851, -122.44574369564) | |||
| 3826 | 3826 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998921.0818300005 | 2091519.29315 | 37.722851642780796 | -122.44584652679501 | (37.7228516427808, -122.445846526795) | |||
| 3827 | 3827 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 7 | Width 5ft | 5998933.177730001 | 2091518.16383 | 37.7228492325857 | -122.44580463279199 | (37.7228492325857, -122.445804632792) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 4694 | 4694 | 7986 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | |||
| 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) | ||
| 5334 | 5334 | 17712 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1214 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6002329.348999999 | 2112708.9615 | 37.7812274480895 | -122.435580057373 | (37.7812274480895, -122.435580057373) | |||
| 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) | ||
| 5775 | 5775 | 14804 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1140 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1994 12:00:00 AM | 3 | 4X4 | 6003547.1646 | 2111783.654 | 37.7787558775283 | -122.431300948764 | (37.7787558775283, -122.431300948764) | ||
| 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) | |||
| 6106 | 6106 | 7959 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1800 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005709.66614 | 2116337.52814 | 37.791382005314 | -122.424143948706 | (37.791382005314, -122.424143948706) | |||
| 6112 | 6112 | 17719 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6002302.3774 | 2112913.4677 | 37.78178743852221 | -122.43568800125799 | (37.7817874385222, -122.435688001258) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 7554 | 7554 | 12324 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1005 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004768.4493 | 2112339.49 | 37.780351202823205 | -122.427115646852 | (37.7803512028232, -122.427115646852) | |||
| 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) | |||
| 7677 | 7677 | 11437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005576.77796 | 2117294.0070599997 | 37.7940007519905 | -122.42467181025499 | (37.7940007519905, -122.424671810255) | |||
| 7730 | 7730 | 7960 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1800 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005701.62625 | 2116374.60015 | 37.7914833418188 | -122.42417440425 | (37.7914833418188, -122.42417440425) | |||
| 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) | |||
| 8115 | 8115 | 12319 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 999 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 18 | 6004795.7539 | 2112145.0577 | 37.7798188836778 | -122.427007335387 | (37.7798188836778, -122.427007335387) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
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");