Street_Tree_List

Data source: data.sfgov.org

2,202 rows where qSpecies = 55 sorted by PlantType

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 899.722ms · Data source: data.sfgov.org