Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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) | ||||
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) | ||||
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) | ||||
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 | |||||||||
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) | ||||
12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
17867 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
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");