trees
2,180 rows where qSpecies_id = 57 sorted by YCoord descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34155 | 129654 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009752.81774 | 2121876.72341 | 37.8068187252662 | -122.410545992499 | (37.8068187252662, -122.410545992499) | 3 | 1 | 10 | 308 | 23 | |||
167074 | 129653 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009793.38554 | 2121873.20249 | 37.8068113319477 | -122.410405350227 | (37.8068113319477, -122.410405350227) | 3 | 1 | 10 | 308 | 23 | |||
19061 | 129655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009755.16442 | 2121852.22782 | 37.8067515980625 | -122.410536140452 | (37.8067515980625, -122.410536140452) | 3 | 1 | 10 | 308 | 23 | |||
57516 | 129652 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009798.02273 | 2121850.39999 | 37.8067489819353 | -122.410387691144 | (37.8067489819353, -122.410387691144) | 3 | 1 | 10 | 308 | 23 | |||
78441 | 129651 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 2 | Width 3ft | 6009800.43185 | 2121827.80217 | 37.8066870690198 | -122.410377757248 | (37.8066870690198, -122.410377757248) | 3 | 1 | 10 | 308 | 23 | ||
87339 | 129656 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009761.43643 | 2121807.95495 | 37.8066303874512 | -122.410511306563 | (37.8066303874512, -122.410511306563) | 3 | 1 | 10 | 308 | 23 | |||
146811 | 129650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009803.21453 | 2121807.89591 | 37.8066325673946 | -122.410366720757 | (37.8066325673946, -122.410366720757) | 3 | 1 | 10 | 308 | 23 | |||
45173 | 66827 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1994 12:00:00 AM | 7 | 3x3 | Permit Number 33308 | 6009276.00847 | 2121806.91361 | 37.8066003024322 | -122.412191154694 | (37.8066003024322, -122.412191154694) | 3 | 1 | 10 | 308 | 23 | |
59074 | 129672 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009324.29914 | 2121805.6091 | 37.806599430082 | -122.412023942863 | (37.806599430082, -122.412023942863) | 3 | 1 | 10 | 308 | 23 | |||
111185 | 129657 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009762.6965 | 2121791.57324 | 37.8065854780119 | -122.410505788321 | (37.8065854780119, -122.410505788321) | 3 | 1 | 10 | 308 | 23 | |||
110642 | 114466 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009278.4623 | 2121786.53745 | 37.8065444922964 | -122.412181221704 | (37.8065444922964, -122.412181221704) | 3 | 1 | 10 | 308 | 23 | |||
94177 | 129671 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009327.56968 | 2121786.16938 | 37.8065462369833 | -122.412011249831 | (37.8065462369833, -122.412011249831) | 3 | 1 | 10 | 308 | 23 | |||
193318 | 114467 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009280.92289 | 2121766.47886 | 37.8064895545061 | -122.412171287793 | (37.8064895545061, -122.412171287793) | 3 | 1 | 10 | 308 | 23 | |||
39700 | 20264 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | |||
67128 | 20261 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 4 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | ||
74464 | 20263 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | ||
178583 | 20262 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | |||
109986 | 20272 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2290 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | ||
141995 | 20273 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2290 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | |||
180075 | 20271 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2290 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | |||
188267 | 20274 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2290 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | |||
91189 | 129670 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009329.84162 | 2121764.6853 | 37.8064873745564 | -122.412001868104 | (37.8064873745564, -122.412001868104) | 3 | 1 | 10 | 308 | 23 | |||
172898 | 114468 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009284.18017 | 2121746.40432 | 37.8064346176217 | -122.412158595669 | (37.8064346176217, -122.412158595669) | 3 | 1 | 10 | 308 | 23 | |||
58782 | 129669 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009331.79783 | 2121743.36685 | 37.8064289491925 | -122.411993590749 | (37.8064289491925, -122.411993590749) | 3 | 1 | 10 | 308 | 23 | |||
69778 | 20266 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
75292 | 20267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
89650 | 20269 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
93790 | 20265 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
182926 | 20268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | 3 | 1 | 10 | 308 | 23 | |||
29595 | 20276 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
44444 | 20277 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
44808 | 20275 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
172124 | 20278 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
189251 | 20279 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | ||
30959 | 129658 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009773.35506 | 2121727.83726 | 37.8064110724651 | -122.410464398813 | (37.8064110724651, -122.410464398813) | 3 | 1 | 10 | 308 | 23 | |||
31614 | 129649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009816.83805 | 2121725.36163 | 37.8064067125673 | -122.410313742595 | (37.8064067125673, -122.410313742595) | 3 | 1 | 10 | 308 | 23 | |||
46242 | 129668 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009333.59805 | 2121722.21012 | 37.8063709591182 | -122.411985864676 | (37.8063709591182, -122.411985864676) | 3 | 1 | 10 | 308 | 23 | |||
151354 | 129659 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009774.54384 | 2121707.96355 | 37.8063565708655 | -122.410458880595 | (37.8063565708655, -122.410458880595) | 3 | 1 | 10 | 308 | 23 | |||
52944 | 129648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2005 12:00:00 AM | 3 | Width 3ft | 6009818.04009 | 2121706.12273 | 37.8063539547338 | -122.410308223449 | (37.8063539547338, -122.410308223449) | 3 | 1 | 10 | 308 | 23 | ||
67102 | 129660 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009777.61633 | 2121686.62202 | 37.8062981445983 | -122.410446739741 | (37.8062981445983, -122.410446739741) | 3 | 1 | 10 | 308 | 23 | |||
124383 | 129647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009820.66032 | 2121686.06094 | 37.8062990169459 | -122.410297738259 | (37.8062990169459, -122.410297738259) | 3 | 1 | 10 | 308 | 23 | |||
142514 | 129667 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009344.79815 | 2121669.41984 | 37.8062266386149 | -122.411943371701 | (37.8062266386149, -122.411943371701) | 3 | 1 | 10 | 308 | 23 | |||
55358 | 129661 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009779.91781 | 2121666.56674 | 37.8062432068281 | -122.41043735801 | (37.8062432068281, -122.41043735801) | 3 | 1 | 10 | 308 | 23 | |||
62625 | 129646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2210 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 4 | Width 3ft | 6009824.55896 | 2121666.13191 | 37.8062445153435 | -122.410282838289 | (37.8062445153435, -122.410282838289) | 3 | 1 | 10 | 308 | 23 | ||
136723 | 129666 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009347.64919 | 2121645.06555 | 37.806159927791 | -122.411931783031 | (37.806159927791, -122.411931783031) | 3 | 1 | 10 | 308 | 23 | |||
111045 | 129662 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2211 Stockton St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009783.75485 | 2121643.62173 | 37.8061804206615 | -122.410422458031 | (37.8061804206615, -122.410422458031) | 3 | 1 | 10 | 308 | 23 | |||
177774 | 114469 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009301.69448 | 2121635.8419 | 37.8061320236498 | -122.41209016534 | (37.8061320236498, -122.41209016534) | 3 | 1 | 10 | 308 | 23 | |||
15786 | 129665 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009349.70654 | 2121620.88667 | 37.8060936540688 | -122.411922953492 | (37.8060936540688, -122.411922953492) | 3 | 1 | 10 | 308 | 23 | |||
54535 | 114470 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2351 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6009302.49876 | 2121620.58079 | 37.8060901655936 | -122.412086302768 | (37.8060901655936, -122.412086302768) | 3 | 1 | 10 | 308 | 23 | |||
99253 | 129664 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009352.05636 | 2121603.21217 | 37.8060452561514 | -122.411913571751 | (37.8060452561514, -122.411913571751) | 3 | 1 | 10 | 308 | 23 | |||
122206 | 129663 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2300 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009355.57432 | 2121580.27361 | 37.805982469978 | -122.411899775251 | (37.805982469978, -122.411899775251) | 3 | 1 | 10 | 308 | 23 | |||
178135 | 129673 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2400 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008873.50879 | 2121535.92397 | 37.8058336402841 | -122.413564906915 | (37.8058336402841, -122.413564906915) | 3 | 1 | 10 | 308 | 23 | |||
26783 | 41176 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1529 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 9 | Permit Number 41895 | 6002871.19311 | 2121292.04704 | 37.8048251531279 | -122.434319365747 | (37.8048251531279, -122.434319365747) | 13 | 9 | 1 | 57 | 17 | |
125117 | 68985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1938 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 8 | Permit Number 32975 | 5999918.5445 | 2121272.01147 | 37.8046021059554 | -122.44453584225 | (37.8046021059554, -122.44453584225) | 13 | 9 | 1 | 57 | 17 | |
20777 | 41179 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1768 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 8 | Permit Number 41898 | 6001615.11314 | 2121098.92482 | 37.8042235156744 | -122.438652307458 | (37.8042235156744, -122.438652307458) | 13 | 9 | 1 | 57 | 17 | |
28627 | 102624 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 305 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010336.6771 | 2120942.4897 | 37.8042862667019 | -122.408459480806 | (37.8042862667019, -122.408459480806) | 3 | 1 | 10 | 308 | 23 | |||
118615 | 129628 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2700 Larkin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 6006529.89635 | 2120833.15769 | 37.8037721486334 | -122.421625403586 | (37.8037721486334, -122.421625403586) | 5 | 9 | 1 | 28858 | 32 | |||
141494 | 13031 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 462 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2015 12:00:00 AM | 10 | 3X3 | 6010124.59861 | 2120694.43773 | 37.803593298513 | -122.409175884375 | (37.803593298513, -122.409175884375) | 3 | 1 | 10 | 308 | 23 | ||
189885 | 129645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 745 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008221.44348 | 2120654.50156 | 37.8033768408207 | -122.415759034171 | (37.8033768408207, -122.415759034171) | 5 | 1 | 10 | 308 | 32 | |||
26934 | 13003 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6010581.7377 | 2120629.8347 | 37.8034415139042 | -122.40758936746 | (37.8034415139042, -122.40758936746) | 3 | 1 | 10 | 308 | 23 | |||
4710 | 143042 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 443 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010246.7521 | 2120590.0026 | 37.8033133880365 | -122.408745792286 | (37.8033133880365, -122.408745792286) | 3 | 1 | 10 | 308 | 23 | |||
113851 | 143048 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 471 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010123.4556 | 2120570.2538 | 37.8032522561485 | -122.409171071628 | (37.8032522561485, -122.409171071628) | 3 | 1 | 10 | 308 | 23 | |||
97501 | 13032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 463 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6010133.82601 | 2120566.41199 | 37.8032422884562 | -122.409134913081 | (37.8032422884562, -122.409134913081) | 3 | 1 | 10 | 308 | 23 | |||
74313 | 129629 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2705 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006528.35996 | 2120536.34413 | 37.8029570876493 | -122.421609626792 | (37.8029570876493, -122.421609626792) | 5 | 9 | 1 | 28858 | 32 | |||
61798 | 13045 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 529 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009805.9101 | 2120528.6658 | 37.8031202711111 | -122.410267014555 | (37.8031202711111, -122.410267014555) | 3 | 1 | 10 | 308 | 23 | |||
32837 | 13047 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 539 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009759.7837 | 2120522.8139 | 37.8031016175536 | -122.410426223368 | (37.8031016175536, -122.410426223368) | 3 | 1 | 10 | 308 | 23 | |||
100302 | 13050 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 547 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009740.1627 | 2120520.7485 | 37.8030948465246 | -122.41049397668 | (37.8030948465246, -122.41049397668) | 3 | 1 | 10 | 308 | 23 | |||
138019 | 129565 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2399 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999377.07485 | 2120460.44202 | 37.802342844412 | -122.44635122363 | (37.802342844412, -122.44635122363) | 13 | 9 | 1 | 57 | 17 | |||
175144 | 129564 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2399 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999360.9422 | 2120457.57627 | 37.8023340544371 | -122.446406844005 | (37.8023340544371, -122.446406844005) | 13 | 9 | 1 | 57 | 17 | |||
48203 | 33325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3129 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 6 | Permit Number 37467 | 6004621.77515 | 2120339.17959 | 37.8023080334521 | -122.428193340463 | (37.8023080334521, -122.428193340463) | 13 | 9 | 1 | 57 | 17 | |
159335 | 129643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 926 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007928.29319 | 2120314.2038 | 37.8024259849283 | -122.416749372103 | (37.8024259849283, -122.416749372103) | 5 | 1 | 1 | 308 | 32 | |||
130554 | 129630 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2615 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006581.14365 | 2120192.71417 | 37.8020165433842 | -122.421402549791 | (37.8020165433842, -122.421402549791) | 5 | 9 | 1 | 28858 | 32 | |||
59907 | 129631 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2615 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006581.14621 | 2120178.38554 | 37.8019772007523 | -122.421401522778 | (37.8019772007523, -122.421401522778) | 5 | 9 | 1 | 28858 | 32 | |||
4457 | 27392 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.8016469274247 | -122.419461214785 | (37.8016469274247, -122.419461214785) | 5 | 1 | 1 | 28858 | 32 | |||
19205 | 27390 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | 5 | 1 | 1 | 28858 | 32 | |||
87677 | 27389 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2240 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007143.32837 | 2120019.72314 | 37.8015732342833 | -122.419444839906 | (37.8015732342833, -122.419444839906) | 5 | 1 | 1 | 28858 | 32 | |||
126589 | 249929 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | Width 0ft | 6011103.53501 | 2120007.07668 | 37.801760767194 | -122.405739765471 | (37.801760767194, -122.405739765471) | 3 | 1 | 10 | 308 | 23 | |||
178148 | 249928 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 0ft | 6011076.21302 | 2120004.52946 | 37.8017522452264 | -122.40583413315 | (37.8017522452264, -122.40583413315) | 3 | 1 | 10 | 308 | 23 | |||
92844 | 129560 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3400 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000343.81245 | 2119969.12315 | 37.8010489798926 | -122.442970544376 | (37.8010489798926, -122.442970544376) | 13 | 9 | 1 | 57 | 17 | |||
35577 | 68980 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2258 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53507 | 6000514.3803 | 2119968.02762 | 37.8010556951124 | -122.442380229379 | (37.8010556951124, -122.442380229379) | 13 | 9 | 1 | 57 | 17 | |
141447 | 65828 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2270 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 5 | Permit Number 28818 | 6000482.65078 | 2119964.53316 | 37.8010442917326 | -122.442489775806 | (37.8010442917326, -122.442489775806) | 13 | 9 | 1 | 57 | 17 | |
189912 | 129563 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2270 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000463.82549 | 2119961.71511 | 37.8010354810636 | -122.442554716754 | (37.8010354810636, -122.442554716754) | 13 | 9 | 1 | 57 | 17 | |||
92318 | 65829 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2290 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 9 | Permit Number 28819 | 6000416.29807 | 2119955.15085 | 37.8010147480994 | -122.442718709912 | (37.8010147480994, -122.442718709912) | 13 | 9 | 1 | 57 | 17 | |
26356 | 65822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2231 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1990 12:00:00 AM | 5 | Permit Number 28812 | 6000656.13395 | 2119945.18642 | 37.8010010577013 | -122.44188806188 | (37.8010010577013, -122.44188806188) | 13 | 9 | 1 | 57 | 17 | |
6285 | 72175 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6000606.57902 | 2119937.60106 | 37.8009774064533 | -122.442058997842 | (37.8009774064533, -122.442058997842) | 13 | 9 | 1 | 57 | 17 | |||
2536 | 73723 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2243 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000588.661 | 2119935.00811 | 37.8009692657904 | -122.442120815418 | (37.8009692657904, -122.442120815418) | 13 | 9 | 1 | 57 | 17 | |||
148845 | 65824 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2261 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1990 12:00:00 AM | 7 | Permit Number 28814 | 6000527.32419 | 2119926.01796 | 37.800941085523 | -122.442332420517 | (37.800941085523, -122.442332420517) | 13 | 9 | 1 | 57 | 17 | |
111251 | 129566 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 99 Toledo Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001391.4418 | 2119925.56535 | 37.800989055367 | -122.439342181017 | (37.800989055367, -122.439342181017) | 13 | 9 | 1 | 57 | 17 | |||
185337 | 129572 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2267 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000506.86895 | 2119922.56555 | 37.8009304402543 | -122.442402956127 | (37.8009304402543, -122.442402956127) | 13 | 9 | 1 | 57 | 17 | |||
45391 | 65826 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2267 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 10 | Permit Number 28816 | 6000491.01592 | 2119920.15776 | 37.8009229255132 | -122.442457641208 | (37.8009229255132, -122.442457641208) | 13 | 9 | 1 | 57 | 17 | |
131383 | 68981 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2365 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 6 | Permit Number 32971 | 6000015.55575 | 2119854.08532 | 37.8007143961175 | -122.444098179086 | (37.8007143961175, -122.444098179086) | 13 | 9 | 1 | 57 | 17 | |
128050 | 129571 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2375 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999991.43277 | 2119850.4812 | 37.8007031239957 | -122.444181395175 | (37.8007031239957, -122.444181395175) | 13 | 9 | 1 | 57 | 17 | |||
169851 | 68983 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2377 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | Permit Number 32973 | 5999960.55241622 | 2119841.40083737 | 37.8006764299942 | -122.444287600709 | (37.8006764299942, -122.444287600709) | 13 | 9 | 1 | 57 | 17 | ||
110775 | 129642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1161 Greenwich St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 5ft | 6007337.31848 | 2119837.29751 | 37.8010832638317 | -122.418760599735 | (37.8010832638317, -122.418760599735) | 5 | 1 | 1 | 28858 | 32 | |||
62320 | 129640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1201 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007123.06001 | 2119804.16548 | 37.8009802258023 | -122.419499676077 | (37.8009802258023, -122.419499676077) | 5 | 1 | 1 | 28858 | 32 | |||
142067 | 142477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 420 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010878.7798 | 2119674.0611 | 37.8008338167395 | -122.406494046802 | (37.8008338167395, -122.406494046802) | 3 | 1 | 10 | 308 | 23 | |||
146406 | 129562 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3299 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000843.46741 | 2119560.36133 | 37.7999551030067 | -122.441212183615 | (37.7999551030067, -122.441212183615) | 13 | 9 | 1 | 57 | 17 | |||
62054 | 9946 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2145X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007159.165551 | 2119559.7591564 | 37.8003111812757 | -122.419357387093 | (37.8003111812757, -122.419357387093) | 5 | 1 | 1 | 28858 | 32 | |||
15687 | 129561 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3299 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000845.88514 | 2119539.08728 | 37.7998968278242 | -122.441202290165 | (37.7998968278242, -122.441202290165) | 13 | 9 | 1 | 57 | 17 | |||
80667 | 129624 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1914 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008681.88388 | 2119422.08299 | 37.8000188001918 | -122.414078417112 | (37.8000188001918, -122.414078417112) | 3 | 1 | 10 | 308 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );