Street_Tree_List

Data source: data.sfgov.org

2,202 rows where qSpecies = 55 sorted by DBH

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)
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)
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)
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          
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 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 173900 Private 5 Ligustrum lucidum :: Glossy Privet 55 601x Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
10204 173902 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 601x Hearst Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
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 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)
12636 99746 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4250 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3            
17867 98680 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 199X Park St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
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)
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)
20844 59583 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 4071 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/07/1981 12:00:00 AM     Permit Number 18981 6002727.56027236 2101791.13153415 37.7512723603586 -122.433422018052 (37.7512723603586, -122.433422018052)
42965 61941 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 178 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/18/1985 12:00:00 AM     Permit Number 21999 6005366.58200406 2100230.03647017 37.747135322118204 -122.424184964624 (37.7471353221182, -122.424184964624)
44078 66992 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 173 Granada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/12/1992 12:00:00 AM     Permit Number 30345 5995611.62082258 2091036.47990525 37.721336430114796 -122.457251654811 (37.7213364301148, -122.457251654811)
54141 67725 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1340 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1993 12:00:00 AM     Permit Number 31343 5992114.71357014 2106313.78524878 37.763082557956295 -122.470451434039 (37.7630825579563, -122.470451434039)
65546 61848 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1052 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1985 12:00:00 AM     Permit Number 21887 6010218.02478734 2103088.23113889 37.755256026984 -122.407610478643 (37.755256026984, -122.407610478643)
72514 61855 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1127 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1985 12:00:00 AM     Permit Number 21894 6010294.61104225 2102652.88138717 37.7540649402035 -122.40731493066002 (37.7540649402035, -122.40731493066)
74401 121592 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4233 Cesar Chavez St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6002342.0 2100313.0 37.7471918787018 -122.434649642859 (37.7471918787018, -122.434649642859)
75753 108149 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2232 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6003295.44003 2116396.66877 37.791407783491294 -122.432501340527 (37.7914077834913, -122.432501340527)
77326 54931 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1466 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/16/1972 12:00:00 AM   3x3 Permit Number 51416 6003271.64345897 2099695.83318704 37.7455500147976 -122.43139096057 (37.7455500147976, -122.43139096057)
77555 99747 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4250 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002274.0 2100636.0 37.7480748999105 -122.434907877013 (37.7480748999105, -122.434907877013)
77610 109992 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 501X Shotwell St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 DPW 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
77722 50451 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 12 Delmar St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2003 12:00:00 AM     Permit Number 47097 5999287.88101991 2108301.76865452 37.768953206578296 -122.445784947419 (37.7689532065783, -122.445784947419)
78027 107959 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2299X 25TH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6012136.0 2101880.0 37.752045663585896 -122.400892625965 (37.7520456635859, -122.400892625965)
78044 68850 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 235 Flood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1993 12:00:00 AM     Permit Number 32813 5999189.08755836 2094052.99169606 37.7298238896011 -122.445102154978 (37.7298238896011, -122.445102154978)
78084 61853 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1123 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1985 12:00:00 AM     Permit Number 21892 6010293.32119713 2102675.26098556 37.75412631741629 -122.407320968841 (37.7541263174163, -122.407320968841)
78314 62107 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 373 Bartlett St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/10/2007 12:00:00 AM   3x3 Permit Number 49980 6006792.08421569 2101617.3134298 37.751024854952796 -122.419354081346 (37.7510248549528, -122.419354081346)
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)
79610 32821 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 4251 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM     Permit Number 37180 6001518.68863728 2102305.7083643 37.7526166065877 -122.43763927134898 (37.7526166065877, -122.437639271349)
79613 51053 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 557 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/09/2004 12:00:00 AM     Permit Number 47523 6002734.05323147 2103248.96658127 37.7552755973804 -122.433503735784 (37.7552755973804, -122.433503735784)
79635 61858 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1150 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1985 12:00:00 AM     Permit Number 21898 6010250.43626462 2102515.61174925 37.7536855558022 -122.40745802144 (37.7536855558022, -122.40745802144)
79769 113436 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 198x HIGHLAND AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
79967 67901 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 109 Gennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/1993 12:00:00 AM     Permit Number 31603 5997414.60785489 2093843.94609455 37.729148458175004 -122.45122163283001 (37.729148458175, -122.45122163283)
80541 111018 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 90x DOWNEY ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/14/2015 12:00:00 AM   3x3   5998894.0 2107683.0 37.7672317271747 -122.447102814384 (37.7672317271747, -122.447102814384)
80636 33769 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 3101 20th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 37819 6009092.65010174 2104478.80438725 37.759011167375796 -122.41160061802 (37.7590111673758, -122.41160061802)
80855 57660 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 4417 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/18/1976 12:00:00 AM   3x3 Permit Number 772993 6001718.02788931 2104070.42319625 37.7574734209258 -122.437076257467 (37.7574734209258, -122.437076257467)
81286 35152 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 265 Laussat St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/02/1998 12:00:00 AM     Permit Number 38683 6003463.92079467 2109118.95080504 37.7714345424169 -122.431398649315 (37.7714345424169, -122.431398649315)
81547 103610 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 200X Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
81970 114877 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 226 BRODERICK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001315.0 2109584.0 37.7725894276985 -122.438865189694 (37.7725894276985, -122.438865189694)
82008 105875 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2X 27th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006029.156359999 2100240.43464 37.7472012619439 -122.421894571047 (37.7472012619439, -122.421894571047)
82276 96882 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2200X San Jose Ave 7 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
82585 44826 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 129 Leland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/20/2001 12:00:00 AM     Permit Number 43918 6010308.29040288 2087358.77915196 37.7120713475932 -122.40619016379601 (37.7120713475932, -122.406190163796)
82598 62789 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 196 Ocean Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/24/1986 12:00:00 AM     Permit Number 23145 6000321.17614419 2091703.51030925 37.7234373055999 -122.44101991790899 (37.7234373055999, -122.441019917909)
82923 92842 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 3440 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/28/2009 12:00:00 AM   3x3   6006883.0 2101475.0 37.7506392147773 -122.419029591774 (37.7506392147773, -122.419029591774)
83421 41268 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 44 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/1999 12:00:00 AM     Permit Number 41952 6006372.39336546 2109513.04186009 37.7726810295415 -122.42136607091001 (37.7726810295415, -122.42136607091)
83522 35726 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 190 Dartmouth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/14/1998 12:00:00 AM     Permit Number 39007 6008565.46175199 2093223.89460892 37.7280780839519 -122.41262825854099 (37.7280780839519, -122.412628258541)
83821 114799 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 103 Grattan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998130.990703201 2106502.59817932 37.7639470183873 -122.44965687078998 (37.7639470183873, -122.44965687079)
84112 68819 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 201 Detroit St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/30/1993 12:00:00 AM     Permit Number 32767 5999394.1666158 2093791.36471631 37.729117226145 -122.44437438127702 (37.729117226145, -122.444374381277)
84624 96883 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2200X San Jose Ave 8 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
84742 121398 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4098x 19th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002425.0 2104765.0 37.7594207214866 -122.434680934086 (37.7594207214866, -122.434680934086)
84977 98681 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 199X Park St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
84994 89034 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 272 Main St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 51778 6014884.0 2115520.0 37.7896509872655 -122.392343484767 (37.7896509872655, -122.392343484767)
85009 98240 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 800 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 32025 5993314.0 2106663.0 37.7641106803471 -122.466328924005 (37.7641106803471, -122.466328924005)
85474 61845 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1099 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1985 12:00:00 AM     Permit Number 21884 6010284.24906681 2102833.32009511 37.7545598048232 -122.407363484663 (37.7545598048232, -122.407363484663)
85767 99103 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 201 Ivy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006380.0 2111267.6 37.7774990526419 -122.421464387784 (37.7774990526419, -122.421464387784)
85949 109996 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 501X Shotwell St 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 DPW 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
86463 96884 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2200X San Jose Ave 9 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5998886.2 2091075.7 37.7216316467069 -122.445935216513 (37.7216316467069, -122.445935216513)
86603 114790 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 100x GILLETTE AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6013060.0 2086881.0 37.7109129945759 -122.39664592325 (37.7109129945759, -122.39664592325)
86964 113437 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 198x HIGHLAND AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
87389 46271 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 325 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/16/2002 12:00:00 AM     Permit Number 44555 6006560.87997001 2097281.80561087 37.739107504355005 -122.419846001297 (37.739107504355, -122.419846001297)
87413 116811 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3660x 23RD ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005401.0 2102665.0 37.7538231135776 -122.42423909941999 (37.7538231135776, -122.42423909942)
87544 61695 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 9 Ramona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/07/1984 12:00:00 AM     Permit Number 21694 6005214.10969137 2107753.44919209 37.7677842392376 -122.425247470035 (37.7677842392376, -122.425247470035)
87789 63516 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 3130 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/08/1987 12:00:00 AM     Permit Number 24125 6009013.02136045 2104526.43175215 37.7591374742847 -122.41187937836399 (37.7591374742847, -122.411879378364)
88011 58120 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 839 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/20/1999 12:00:00 AM     Permit Number 17101 6003847.07815842 2110734.06414103 37.7758909552538 -122.430188532102 (37.7758909552538, -122.430188532102)
88051 62207 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 55 San Gabriel Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/26/1985 12:00:00 AM     Permit Number 22329 6001115.41413851 2093618.10384038 37.728739548363 -122.438411493533 (37.728739548363, -122.438411493533)
88091 87157 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 237 Rivoli St 2 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 50138 5997662.0 2105892.0 37.762243628012705 -122.451234923187 (37.7622436280127, -122.451234923187)
88113 41267 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 44 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/07/1999 12:00:00 AM     Permit Number 41952 6006372.39336546 2109513.04186009 37.7726810295415 -122.42136607091001 (37.7726810295415, -122.42136607091)
88400 89032 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 272 Main St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 51778 6014884.0 2115520.0 37.7896509872655 -122.392343484767 (37.7896509872655, -122.392343484767)
88630 38432 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 3844 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/19/1998 12:00:00 AM     Permit Number 40460 5995813.83516301 2115862.46033815 37.7895138928462 -122.45834869498002 (37.7895138928462, -122.45834869498)
88992 98678 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 199X Park St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
89173 117520 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1601 PAGE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998904.0 2109014.0 37.7708868872166 -122.447164026359 (37.7708868872166, -122.447164026359)
89336 68787 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2319 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/22/1993 12:00:00 AM     Permit Number 32724 5991980.95842416 2099649.38115823 37.74477610705139 -122.470428661516 (37.7447761070514, -122.470428661516)
89620 114798 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 103 Grattan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998130.990703201 2106502.59817932 37.7639470183873 -122.44965687078998 (37.7639470183873, -122.44965687079)
90728 63893 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1X BRADY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/1987 12:00:00 AM     Permit Number 24602 6006435.0 2109828.0 37.773549358695796 -122.42117187599301 (37.7735493586958, -122.421171875993)
90812 114431 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2787 PINE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000638.0 2114779.0 37.7868150321065 -122.44157986784799 (37.7868150321065, -122.441579867848)
90947 61850 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1078 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1985 12:00:00 AM     Permit Number 21889 6010226.10973791 2102942.52266102 37.754856396543204 -122.407572245672 (37.7548563965432, -122.407572245672)
91185 61842 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 1061 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1985 12:00:00 AM     Permit Number 21881 6010272.43259961 2103046.27865741 37.7551438802467 -122.40741936190001 (37.7551438802467, -122.4074193619)
91213 68860 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 388 Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1993 12:00:00 AM     Permit Number 32823 5998853.554712901 2094405.18527642 37.7307717735093 -122.446287451153 (37.7307717735093, -122.446287451153)
91394 121040 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2101 Polk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006363.0 2118098.0 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697)
91855 122410 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
91870 122411 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 499x Ocean Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
91968 37256 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 4200 20th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1998 12:00:00 AM     Permit Number 39805 6002396.16255256 2104159.25249428 37.7577558475859 -122.434737351341 (37.7577558475859, -122.434737351341)
91983 61697 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 22 Ramona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/07/1984 12:00:00 AM     Permit Number 21696 6005166.04109398 2107681.05439541 37.767582744756 -122.425408581153 (37.767582744756, -122.425408581153)
92018 110190 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 625 Holly Park Cir 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4           6006167.62160945 2096413.49051844 37.736701142359294 -122.421144072665 (37.7367011423593, -122.421144072665)
92026 58585 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 103 Grattan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/1979 12:00:00 AM   3x3 Permit Number 17781 5998130.990703201 2106502.59817932 37.7639470183873 -122.44965687078998 (37.7639470183873, -122.44965687079)
92119 64694 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 114 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/16/2009 12:00:00 AM   3x3 Permit Number 52635 6005548.53237974 2104042.55194245 37.757613879648105 -122.42382684305099 (37.7576138796481, -122.423826843051)
92448 69203 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 2837 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1994 12:00:00 AM     Permit Number 33251 6008996.86818866 2101940.25932804 37.752035522179206 -122.411752505652 (37.7520355221792, -122.411752505652)
92605 112350 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 130 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5992742.0 2097684.0 37.7394236424672 -122.46765424156 (37.7394236424672, -122.46765424156)
92729 98679 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 199X Park St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
93011 113435 DPW Maintained 3 Ligustrum lucidum :: Glossy Privet 55 198x HIGHLAND AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4       4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
93483 68881 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 318 Edna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM     Permit Number 32853 5998787.73896502 2093851.41161762 37.7292474820186 -122.446475160796 (37.7292474820186, -122.446475160796)
93525 66553 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 160 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/10/1991 12:00:00 AM     Permit Number 29737 6005262.81634386 2104026.69666345 37.7575542112069 -122.424813838267 (37.7575542112069, -122.424813838267)
93685 61047 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 104 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/1993 12:00:00 AM     Permit Number 32830 5999375.36037511 2093808.9050602 37.7291643148165 -122.444440655825 (37.7291643148165, -122.444440655825)
93704 111067 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1800 10TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993175.0 2103134.0 37.754412945302796 -122.46655315826901 (37.7544129453028, -122.466553158269)
93845 102075 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 273 Magellan Ave 5 Front Yard : Yard 7 Tree 1 Private 1           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194)
93915 34045 Permitted Site 1 Ligustrum lucidum :: Glossy Privet 55 298 Alabama St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/1997 12:00:00 AM     Permit Number 37957 6008878.33665025 2106854.71470607 37.7655228486031 -122.41250976517 (37.7655228486031, -122.41250976517)

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 1242.756ms · Data source: data.sfgov.org