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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46731 | 46731 | 129654 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009752.81774 | 2121876.7234099996 | 37.806818725266204 | -122.41054599249901 | (37.8068187252662, -122.410545992499) | |||
| 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) | |||
| 122212 | 122212 | 129655 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009755.164419999 | 2121852.22782 | 37.8067515980625 | -122.41053614045201 | (37.8067515980625, -122.410536140452) | |||
| 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) | |||
| 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) | ||
| 68366 | 68366 | 129656 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009761.436430001 | 2121807.95495 | 37.80663038745121 | -122.410511306563 | (37.8066303874512, -122.410511306563) | |||
| 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) | |||
| 146797 | 146797 | 66827 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1994 12:00:00 AM | 7 | 3x3 | Permit Number 33308 | 6009276.00847 | 2121806.9136099997 | 37.8066003024322 | -122.412191154694 | (37.8066003024322, -122.412191154694) | |
| 173227 | 173227 | 129672 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6009324.29914 | 2121805.6091 | 37.806599430082 | -122.412023942863 | (37.806599430082, -122.412023942863) | |||
| 52193 | 52193 | 129657 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009762.6965 | 2121791.5732400003 | 37.8065854780119 | -122.410505788321 | (37.8065854780119, -122.410505788321) | |||
| 31106 | 31106 | 114466 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009278.4623 | 2121786.53745 | 37.8065444922964 | -122.412181221704 | (37.8065444922964, -122.412181221704) | |||
| 187414 | 187414 | 129671 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009327.569680001 | 2121786.16938 | 37.8065462369833 | -122.41201124983101 | (37.8065462369833, -122.412011249831) | |||
| 186375 | 186375 | 114467 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009280.92289 | 2121766.4788599997 | 37.8064895545061 | -122.412171287793 | (37.8064895545061, -122.412171287793) | |||
| 83225 | 83225 | 20264 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | |||
| 86580 | 86580 | 20261 | 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 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | ||
| 87823 | 87823 | 20263 | 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 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | ||
| 142958 | 142958 | 20262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | |||
| 99189 | 99189 | 20272 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | ||
| 113858 | 113858 | 20273 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | |||
| 140346 | 140346 | 20271 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | |||
| 144349 | 144349 | 20274 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | |||
| 155190 | 155190 | 129670 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009329.84162 | 2121764.6853 | 37.8064873745564 | -122.412001868104 | (37.8064873745564, -122.412001868104) | |||
| 60663 | 60663 | 114468 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009284.18017 | 2121746.40432 | 37.806434617621704 | -122.412158595669 | (37.8064346176217, -122.412158595669) | |||
| 120436 | 120436 | 129669 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009331.7978300005 | 2121743.36685 | 37.8064289491925 | -122.41199359074899 | (37.8064289491925, -122.411993590749) | |||
| 87631 | 87631 | 20266 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 89702 | 89702 | 20267 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 92446 | 92446 | 20269 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 92797 | 92797 | 20265 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 143379 | 143379 | 20268 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 78058 | 78058 | 20276 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 82162 | 82162 | 20277 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 84314 | 84314 | 20275 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 139054 | 139054 | 20279 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | ||
| 144635 | 144635 | 20278 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 70618 | 70618 | 129658 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009773.35506 | 2121727.83726 | 37.8064110724651 | -122.410464398813 | (37.8064110724651, -122.410464398813) | |||
| 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) | |||
| 23407 | 23407 | 129668 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009333.59805 | 2121722.21012 | 37.806370959118205 | -122.411985864676 | (37.8063709591182, -122.411985864676) | |||
| 180232 | 180232 | 129659 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009774.54384 | 2121707.96355 | 37.8063565708655 | -122.410458880595 | (37.8063565708655, -122.410458880595) | |||
| 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) | ||
| 158501 | 158501 | 129660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009777.616330001 | 2121686.62202 | 37.8062981445983 | -122.410446739741 | (37.8062981445983, -122.410446739741) | |||
| 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) | |||
| 158698 | 158698 | 129667 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009344.79815 | 2121669.41984 | 37.806226638614895 | -122.41194337170099 | (37.8062266386149, -122.411943371701) | |||
| 60959 | 60959 | 129661 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009779.91781 | 2121666.56674 | 37.8062432068281 | -122.41043735801 | (37.8062432068281, -122.41043735801) | |||
| 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) | ||
| 187447 | 187447 | 129666 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009347.64919 | 2121645.06555 | 37.806159927791 | -122.41193178303101 | (37.806159927791, -122.411931783031) | |||
| 23408 | 23408 | 129662 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009783.75485 | 2121643.62173 | 37.806180420661505 | -122.41042245803101 | (37.8061804206615, -122.410422458031) | |||
| 130227 | 130227 | 114469 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009301.69448 | 2121635.8419 | 37.806132023649795 | -122.41209016533999 | (37.8061320236498, -122.41209016534) | |||
| 155744 | 155744 | 129665 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009349.70654 | 2121620.88667 | 37.806093654068796 | -122.411922953492 | (37.8060936540688, -122.411922953492) | |||
| 177215 | 177215 | 114470 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6009302.49876 | 2121620.58079 | 37.8060901655936 | -122.412086302768 | (37.8060901655936, -122.412086302768) | |||
| 182178 | 182178 | 129664 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009352.05636 | 2121603.21217 | 37.8060452561514 | -122.411913571751 | (37.8060452561514, -122.411913571751) | |||
| 135383 | 135383 | 129663 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009355.57432 | 2121580.27361 | 37.805982469978 | -122.411899775251 | (37.805982469978, -122.411899775251) | |||
| 63156 | 63156 | 129673 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2350 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008873.50879 | 2121535.92397 | 37.8058336402841 | -122.413564906915 | (37.8058336402841, -122.413564906915) | |||
| 167171 | 167171 | 41176 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.193109999 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | |
| 56944 | 56944 | 68985 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1938 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32975 | 5999918.5445 | 2121272.0114700003 | 37.804602105955404 | -122.44453584225 | (37.8046021059554, -122.44453584225) | |
| 56390 | 56390 | 142954 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 170 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010024.909 | 2121108.7696 | 37.8047253656701 | -122.40955012692301 | (37.8047253656701, -122.409550126923) | |||
| 155464 | 155464 | 41179 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.9248200003 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | |
| 174993 | 174993 | 129644 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 724 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6007831.26083 | 2120995.6473 | 37.804291598853 | -122.41713346715099 | (37.804291598853, -122.417133467151) | |||
| 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) | |||
| 151723 | 151723 | 129628 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2700 Larkin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 6006529.89635 | 2120833.1576900003 | 37.8037721486334 | -122.421625403586 | (37.8037721486334, -122.421625403586) | |||
| 113185 | 113185 | 13031 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 462 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/21/2015 12:00:00 AM | 10 | 3X3 | 6010124.59861 | 2120694.43773 | 37.803593298513 | -122.409175884375 | (37.803593298513, -122.409175884375) | ||
| 32388 | 32388 | 129645 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 745 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008221.44348 | 2120654.50156 | 37.803376840820704 | -122.415759034171 | (37.8033768408207, -122.415759034171) | |||
| 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) | |||
| 25515 | 25515 | 143042 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 443 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010246.7521 | 2120590.0026 | 37.8033133880365 | -122.408745792286 | (37.8033133880365, -122.408745792286) | |||
| 30710 | 30710 | 143048 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 471 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010123.4556 | 2120570.2538 | 37.803252256148504 | -122.409171071628 | (37.8032522561485, -122.409171071628) | |||
| 100879 | 100879 | 13032 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 463 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6010133.82601 | 2120566.41199 | 37.803242288456204 | -122.409134913081 | (37.8032422884562, -122.409134913081) | |||
| 28227 | 28227 | 129629 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2705 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006528.35996 | 2120536.34413 | 37.8029570876493 | -122.42160962679199 | (37.8029570876493, -122.421609626792) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 157897 | 157897 | 129565 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2399 North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999377.07485 | 2120460.44202 | 37.802342844411996 | -122.44635122363 | (37.802342844412, -122.44635122363) | |||
| 164318 | 164318 | 129564 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2399 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999360.9422 | 2120457.57627 | 37.802334054437104 | -122.446406844005 | (37.8023340544371, -122.446406844005) | |||
| 155754 | 155754 | 33325 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3129 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 6 | Permit Number 37467 | 6004621.77515 | 2120339.1795900003 | 37.8023080334521 | -122.42819334046301 | (37.8023080334521, -122.428193340463) | |
| 185546 | 185546 | 129643 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 926 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007928.293190001 | 2120314.2038 | 37.8024259849283 | -122.416749372103 | (37.8024259849283, -122.416749372103) | |||
| 179764 | 179764 | 129630 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2615 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006581.14365 | 2120192.71417 | 37.802016543384205 | -122.421402549791 | (37.8020165433842, -122.421402549791) | |||
| 185710 | 185710 | 129631 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2615 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006581.14621 | 2120178.38554 | 37.8019772007523 | -122.421401522778 | (37.8019772007523, -122.421401522778) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 39991 | 39991 | 249929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | Width 0ft | 6011103.53501 | 2120007.07668 | 37.801760767194 | -122.405739765471 | (37.801760767194, -122.405739765471) | |||
| 170238 | 170238 | 249928 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 0ft | 6011076.21302 | 2120004.52946 | 37.801752245226396 | -122.40583413315001 | (37.8017522452264, -122.40583413315) | |||
| 25475 | 25475 | 129560 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3400 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000343.81245 | 2119969.12315 | 37.8010489798926 | -122.442970544376 | (37.8010489798926, -122.442970544376) | |||
| 174666 | 174666 | 68980 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2258 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53507 | 6000514.3803 | 2119968.0276200003 | 37.8010556951124 | -122.44238022937901 | (37.8010556951124, -122.442380229379) | |
| 45623 | 45623 | 65828 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2270 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 5 | Permit Number 28818 | 6000482.650780001 | 2119964.5331599996 | 37.8010442917326 | -122.44248977580601 | (37.8010442917326, -122.442489775806) | |
| 31254 | 31254 | 129563 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2270 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000463.82549 | 2119961.7151099998 | 37.8010354810636 | -122.442554716754 | (37.8010354810636, -122.442554716754) | |||
| 36676 | 36676 | 65829 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 9 | Permit Number 28819 | 6000416.29807 | 2119955.15085 | 37.8010147480994 | -122.442718709912 | (37.8010147480994, -122.442718709912) | |
| 45147 | 45147 | 65822 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2231 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | 5 | Permit Number 28812 | 6000656.13395 | 2119945.18642 | 37.8010010577013 | -122.44188806188 | (37.8010010577013, -122.44188806188) | |
| 44989 | 44989 | 72175 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 9 | 6000606.57902 | 2119937.60106 | 37.80097740645329 | -122.44205899784201 | (37.8009774064533, -122.442058997842) | ||
| 55221 | 55221 | 73723 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1990 12:00:00 AM | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | ||
| 156948 | 156948 | 65824 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2261 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/1990 12:00:00 AM | 7 | Permit Number 28814 | 6000527.32419 | 2119926.01796 | 37.800941085523 | -122.442332420517 | (37.800941085523, -122.442332420517) | |
| 70460 | 70460 | 129566 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99 Toledo Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001391.4418 | 2119925.56535 | 37.800989055367 | -122.439342181017 | (37.800989055367, -122.439342181017) | |||
| 161120 | 161120 | 129572 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2267 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000506.86895 | 2119922.56555 | 37.8009304402543 | -122.442402956127 | (37.8009304402543, -122.442402956127) | |||
| 70598 | 70598 | 65826 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2267 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 10 | Permit Number 28816 | 6000491.01592 | 2119920.15776 | 37.8009229255132 | -122.442457641208 | (37.8009229255132, -122.442457641208) | |
| 60821 | 60821 | 68981 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2365 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 6 | Permit Number 32971 | 6000015.55575 | 2119854.08532 | 37.8007143961175 | -122.444098179086 | (37.8007143961175, -122.444098179086) | |
| 48819 | 48819 | 129571 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2375 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999991.43277 | 2119850.4812 | 37.8007031239957 | -122.444181395175 | (37.8007031239957, -122.444181395175) | |||
| 116895 | 116895 | 68983 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2377 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | Permit Number 32973 | 5999960.55241622 | 2119841.40083737 | 37.800676429994205 | -122.444287600709 | (37.8006764299942, -122.444287600709) | ||
| 49510 | 49510 | 129642 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1161 Greenwich St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 5ft | 6007337.31848 | 2119837.29751 | 37.8010832638317 | -122.418760599735 | (37.8010832638317, -122.418760599735) | |||
| 29190 | 29190 | 129640 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1201 Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007123.06001 | 2119804.16548 | 37.8009802258023 | -122.41949967607701 | (37.8009802258023, -122.419499676077) | |||
| 156398 | 156398 | 142477 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 420 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010878.7798 | 2119674.0611 | 37.800833816739505 | -122.40649404680201 | (37.8008338167395, -122.406494046802) | |||
| 25221 | 25221 | 129562 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3299 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000843.46741 | 2119560.3613299998 | 37.7999551030067 | -122.441212183615 | (37.7999551030067, -122.441212183615) |
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");