trees
2,180 rows where qSpecies_id = 57 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134917 | 37498 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 10 | Permit Number 39964 | 6010355.28098 | 2115804.39021 | 37.7901793401628 | -122.408032529472 | (37.7901793401628, -122.408032529472) | 5 | 1 | 10 | 28857 | 6 | |
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 | |||
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 | ||
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 | |||
142017 | 37534 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1138 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | Permit Number 39980 | 6008135.8621207 | 2116394.85818942 | 37.7916761076557 | -122.415753397731 | (37.7916761076557, -122.415753397731) | 5 | 1 | 10 | 28858 | 21 | |||
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 | |||
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 | |||
145386 | 37500 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 830 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39965 | 6009516.4157 | 2115739.57789 | 37.7899543783457 | -122.410930370855 | (37.7899543783457, -122.410930370855) | 5 | 1 | 10 | 28857 | 21 | |
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 | |||
151295 | 129677 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012069.97592 | 2116796.72183 | 37.7929999018796 | -122.402169577472 | (37.7929999018796, -122.402169577472) | 4 | 1 | 10 | 28854 | 6 | |||
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 | |||
151520 | 129634 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1181 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007297.84859 | 2119136.53505 | 37.7991569241134 | -122.418847455366 | (37.7991569241134, -122.418847455366) | 5 | 1 | 10 | 28858 | 32 | |||
154201 | 129637 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1113 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007650.63926 | 2119186.93082 | 37.7993151562271 | -122.417630249946 | (37.7993151562271, -122.417630249946) | 5 | 1 | 10 | 28858 | 32 | |||
155856 | 58198 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 920 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/1978 12:00:00 AM | 18 | Permit Number 17187 | 6009149.67357 | 2116129.24917 | 37.7910037495643 | -122.412226823621 | (37.7910037495643, -122.412226823621) | 5 | 1 | 10 | 28857 | 21 | ||
158132 | 37497 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 645 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 8 | Permit Number 39964 | 6010338.55748 | 2115802.28849 | 37.790172633 | -122.408090243478 | (37.790172633, -122.408090243478) | 5 | 1 | 10 | 28857 | 6 | |
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 | |||
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 | |||
167090 | 129618 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1220 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008573.01833 | 2116697.29547 | 37.7925310915872 | -122.414262243012 | (37.7925310915872, -122.414262243012) | 5 | 1 | 10 | 28857 | 21 | |||
169794 | 129680 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012023.67826 | 2116790.52383 | 37.7929802993494 | -122.40232933485 | (37.7929802993494, -122.40232933485) | 4 | 1 | 10 | 28854 | 6 | |||
170773 | 129638 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1136 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007528.45422 | 2119220.18419 | 37.7993995854823 | -122.418055412524 | (37.7993995854823, -122.418055412524) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
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 | |||
174197 | 37544 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 825 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39986 | 6008203.02144852 | 2114810.28677718 | 37.7873290368122 | -122.415408797554 | (37.7873290368122, -122.415408797554) | 13 | 1 | 9 | 28858 | 36 | ||
174459 | 4606 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 300 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010770.74502 | 2118660.66826 | 37.7980452429337 | -122.40679643371 | (37.7980452429337, -122.40679643371) | 3 | 1 | 10 | 308 | 23 | |||
176346 | 129612 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 711 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009194.01202 | 2115430.46227 | 37.7890875380168 | -122.412024009404 | (37.7890875380168, -122.412024009404) | 5 | 1 | 10 | 28858 | 21 | |||
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 | |||
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 | |||
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 | |||
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 | |||
179184 | 45683 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 107 Bernard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2001 12:00:00 AM | 4 | Permit Number 44370 | 6008292.83323 | 2118060.93092 | 37.79625955578 | -122.415328273299 | (37.79625955578, -122.415328273299) | 5 | 1 | 10 | 28858 | 21 | ||
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 | |||
181453 | 129623 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1914 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008683.00237 | 2119409.78027 | 37.7999850828041 | -122.414073675855 | (37.7999850828041, -122.414073675855) | 3 | 1 | 10 | 308 | 32 | |||
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 | |||
183933 | 37549 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 533 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39989 | 6009274.16052214 | 2114821.41225481 | 37.7874197302007 | -122.411703653187 | (37.7874197302007, -122.411703653187) | 5 | 1 | 10 | 28852 | 36 | ||
184419 | 68922 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1255 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 9 | Permit Number 32906 | 6007550.61627 | 2118479.08218 | 37.7973659521424 | -122.417926160173 | (37.7973659521424, -122.417926160173) | 5 | 1 | 10 | 28858 | 32 | |
187862 | 62716 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1125 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/1986 12:00:00 AM | 17 | Permit Number 23059 | 6007595.43148 | 2119179.891 | 37.7992927199273 | -122.417820789314 | (37.7992927199273, -122.417820789314) | 5 | 1 | 10 | 28858 | 32 | |
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 | |||
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 | ||
189283 | 129675 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 464 California St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6012092.09526 | 2116799.41386 | 37.7930085281603 | -122.402093232241 | (37.7930085281603, -122.402093232241) | 4 | 1 | 10 | 28854 | 6 | |||
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 | |||
190312 | 62706 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | Permit Number 23046 | 6007274.51894323 | 2119093.66115296 | 37.7990378895325 | -122.418925141627 | (37.7990378895325, -122.418925141627) | 5 | 1 | 10 | 28858 | 32 | ||
192754 | 66835 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 701 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30135 | 6009204.71418502 | 2115334.29605872 | 37.7888240893158 | -122.41198018251 | (37.7888240893158, -122.41198018251) | 5 | 1 | 10 | 28858 | 21 | ||
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 | |||
193416 | 129641 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 943 Green St | 12 | Side Yard : Yard | Tree | Private 2 | 41 | 6008676.12705 | 2118976.42517 | 37.7987948111981 | -122.414066792462 | (37.7987948111981, -122.414066792462) | 5 | 1 | 10 | 308 | 21 | ||||
1280 | 191487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 288 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010205.79697 | 2110974.44372 | 37.7769090816273 | -122.408208942312 | (37.7769090816273, -122.408208942312) | 8 | 2 | 9 | 28853 | 34 | |||
3425 | 60034 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 108 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 7 | Permit Number 19523 | 6014255.56955 | 2112594.84947 | 37.7815842801353 | -122.394312917534 | (37.7815842801353, -122.394312917534) | 6 | 2 | 9 | 28856 | 6 | |
4770 | 191477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6014491.1655 | 2112621.09872 | 37.7816694477368 | -122.393499699264 | (37.7816694477368, -122.393499699264) | 6 | 2 | 9 | 28856 | 6 | |||
7612 | 15318 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006784.5559 | 2108731.4352 | 37.7705581530288 | -122.419884880101 | (37.7705581530288, -122.419884880101) | 8 | 2 | 9 | 28853 | 19 | |||
7855 | 60037 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 84 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 13 | Permit Number 19526 | 6014370.64542 | 2112704.82281 | 37.7818926378878 | -122.393922507437 | (37.7818926378878, -122.393922507437) | 6 | 2 | 9 | 28856 | 6 | |
8666 | 72016 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 112 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6014238.82874 | 2112579.70736 | 37.7815417727734 | -122.394369772655 | (37.7815417727734, -122.394369772655) | 6 | 2 | 9 | 28856 | 6 | |||
9666 | 60024 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 181 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 14 | Permit Number 19511 | 6014126.74175 | 2112333.046 | 37.7808582655241 | -122.394740263669 | (37.7808582655241, -122.394740263669) | 6 | 2 | 9 | 28856 | 6 | |
9894 | 60029 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 21 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 17 | Permit Number 19517 | 6014545.42984 | 2112673.52396 | 37.7818164104522 | -122.393315638611 | (37.7818164104522, -122.393315638611) | 6 | 2 | 9 | 28856 | 6 | |
12964 | 60035 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 15 | Permit Number 19524 | 6014295.81848 | 2112435.53684 | 37.7811490811156 | -122.394162517581 | (37.7811490811156, -122.394162517581) | 6 | 2 | 9 | 28856 | 6 | |
13190 | 60028 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 10 | Permit Number 19516 | 6014481.96574 | 2112615.13715 | 37.7816525674538 | -122.393531108971 | (37.7816525674538, -122.393531108971) | 6 | 2 | 9 | 28856 | 6 | |
15001 | 60031 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 16 | Permit Number 19519 | 6014189.65421 | 2112531.72054 | 37.7814072782548 | -122.394536533027 | (37.7814072782548, -122.394536533027) | 6 | 2 | 9 | 28856 | 6 | |
17343 | 60021 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 76 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 14 | Permit Number 19508 | 6014385.60562 | 2112720.25781 | 37.781935850286 | -122.393871832437 | (37.781935850286, -122.393871832437) | 6 | 2 | 9 | 28856 | 6 | |
17473 | 201860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1116 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010161.8818 | 2110817.0652 | 37.7764744978974 | -122.408349755778 | (37.7764744978974, -122.408349755778) | 8 | 2 | 9 | 28853 | 34 | |||
18310 | 60036 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 147 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 12 | Permit Number 19525 | 6014255.98068 | 2112398.36524 | 37.7810448020107 | -122.394297734267 | (37.7810448020107, -122.394297734267) | 6 | 2 | 9 | 28856 | 6 | |
18458 | 191458 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 6014482.2077 | 2115927.08829 | 37.790746438249 | -122.393762161888 | (37.790746438249, -122.393762161888) | 12 | 2 | 9 | 28855 | 6 | |||
18665 | 60026 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 104 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1982 12:00:00 AM | 16 | Permit Number 19514 | 6014265.09477 | 2112604.60863 | 37.781611606035 | -122.394280648053 | (37.781611606035, -122.394280648053) | 6 | 2 | 9 | 28856 | 6 | |
24120 | 103523 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 41X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006623 | 2109623 | 37.7729970743853 | -122.420507000439 | (37.7729970743853, -122.420507000439) | 8 | 2 | 9 | 28853 | 19 | |||
26208 | 191473 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6014315.40863 | 2112455.42682 | 37.7812047833188 | -122.394096137746 | (37.7812047833188, -122.394096137746) | 6 | 2 | 9 | 28856 | 6 | |||
27217 | 191492 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008677.6339 | 2110340.84375 | 37.7750836791036 | -122.413450522147 | (37.7750836791036, -122.413450522147) | 8 | 2 | 9 | 28853 | 34 | |||
27870 | 191476 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 45 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6014442.93612 | 2112579.76279 | 37.7815532688034 | -122.393663657352 | (37.7815532688034, -122.393663657352) | 6 | 2 | 9 | 28856 | 6 | |||
28121 | 113967 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 200 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011658 | 2107333 | 37.7669917162652 | -122.402929122897 | (37.7669917162652, -122.402929122897) | 8 | 2 | 8 | 28853 | 20 | ||||
29008 | 191456 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6014463.08258 | 2115949.76346 | 37.7908076361998 | -122.393829922227 | (37.7908076361998, -122.393829922227) | 12 | 2 | 9 | 28855 | 6 | |||
30040 | 25706 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 582 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6012130.73474 | 2110269.98363 | 37.7750823930813 | -122.401500433298 | (37.7750823930813, -122.401500433298) | 14 | 2 | 9 | 28853 | 34 | |||
35183 | 15320 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1680 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2004 12:00:00 AM | 3 | 3X3 | 6006776.8374 | 2108697.9883 | 37.7704658809505 | -122.419909204722 | (37.7704658809505, -122.419909204722) | 8 | 2 | 9 | 28853 | 19 | ||
36321 | 191463 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014423.52986 | 2112756.14838 | 37.7820365051332 | -122.393743143935 | (37.7820365051332, -122.393743143935) | 6 | 2 | 9 | 28856 | 6 | |||
37311 | 60032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 301 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1982 12:00:00 AM | Permit Number 19520 | 6014916.63829129 | 2112653.79570554 | 37.7817828574395 | -122.39203004009 | (37.7817828574395, -122.39203004009) | 6 | 2 | 9 | 28856 | 6 | ||
39167 | 227506 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 149 Otis St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6006716.29525 | 2108893.94632 | 37.7710005240788 | -122.420132529885 | (37.7710005240788, -122.420132529885) | 8 | 2 | 9 | 28853 | 19 | |||
39231 | 41268 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
43925 | 112146 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 299X 05TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011616 | 2112272 | 37.7805507327562 | -122.403421899857 | (37.7805507327562, -122.403421899857) | 6 | 2 | 9 | 28853 | 34 | |||
45757 | 201240 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 832 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6011987.3715 | 2112559.9702 | 37.7813621675722 | -122.402157393633 | (37.7813621675722, -122.402157393633) | 6 | 2 | 9 | 28853 | 34 | |||
47240 | 191474 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 135 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6014326.75697 | 2112466.04784 | 37.7812345769599 | -122.39405762156 | (37.7812345769599, -122.39405762156) | 6 | 2 | 9 | 28856 | 6 | |||
47478 | 68437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 22 | Permit Number 32291 | 6008616.38965 | 2110404.13314 | 37.7752540178903 | -122.413666857651 | (37.7752540178903, -122.413666857651) | 8 | 2 | 9 | 28853 | 34 | ||
48700 | 191468 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014292.29593 | 2112680.88237 | 37.7818225483087 | -122.394191885869 | (37.7818225483087, -122.394191885869) | 6 | 2 | 9 | 28856 | 6 | |||
54289 | 191452 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6014395.41652 | 2116019.04089 | 37.7909940953523 | -122.394068897285 | (37.7909940953523, -122.394068897285) | 12 | 2 | 9 | 28855 | 6 | |||
55363 | 191486 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 347 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011893.8519 | 2112710.62909 | 37.7817706214524 | -122.402491524862 | (37.7817706214524, -122.402491524862) | 6 | 2 | 9 | 28853 | 34 | |||
56278 | 227508 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 41 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6006644.81895 | 2109605.92162 | 37.7729514108221 | -122.420430313409 | (37.7729514108221, -122.420430313409) | 8 | 2 | 9 | 28853 | 19 | |||
57854 | 227510 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 37 Brady St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006532.91743 | 2109718.55388 | 37.7732543654386 | -122.420825392799 | (37.7732543654386, -122.420825392799) | 8 | 2 | 9 | 28853 | 19 | |||
60491 | 227507 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 78 Colton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006662.68149 | 2109606.33946 | 37.7729535646992 | -122.420368554271 | (37.7729535646992, -122.420368554271) | 8 | 2 | 9 | 28853 | 19 | |||
62124 | 191480 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 526 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012537.84104 | 2111160.5359 | 37.7775503530914 | -122.400154712085 | (37.7775503530914, -122.400154712085) | 14 | 2 | 9 | 28856 | 34 | |||
62275 | 191483 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6012443.09783 | 2111154.53509 | 37.7775285931066 | -122.400482041007 | (37.7775285931066, -122.400482041007) | 14 | 2 | 9 | 28856 | 34 | |||
62433 | 25704 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 564 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6012091.3603 | 2110309.05533 | 37.7751874779549 | -122.401639385748 | (37.7751874779549, -122.401639385748) | 14 | 2 | 9 | 28853 | 34 | |||
62566 | 113965 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6011669.50654 | 2107216.87583 | 37.7666735080099 | -122.402881155253 | (37.7666735080099, -122.402881155253) | 8 | 2 | 8 | 28853 | 20 | |||
66394 | 201861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1116 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010150.0088 | 2110807.2194 | 37.7764467987551 | -122.408390133412 | (37.7764467987551, -122.408390133412) | 8 | 2 | 9 | 28853 | 34 | |||
66593 | 112141 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 299 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6011568.52353 | 2112270.39261 | 37.7805436673854 | -122.403586031292 | (37.7805436673854, -122.403586031292) | 6 | 2 | 9 | 28853 | 34 | |||
67489 | 191489 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 190 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008631.45432 | 2110388.01646 | 37.7752106112282 | -122.41361360519 | (37.7752106112282, -122.41361360519) | 8 | 2 | 9 | 28853 | 34 | |||
67877 | 201858 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1114 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010186.2664 | 2110842.1371 | 37.7765447049461 | -122.408267170875 | (37.7765447049461, -122.408267170875) | 8 | 2 | 9 | 28853 | 34 | |||
68254 | 201859 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1114 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010175.6391 | 2110829.8748 | 37.7765104404434 | -122.408303068844 | (37.7765104404434, -122.408303068844) | 8 | 2 | 9 | 28853 | 34 | |||
68654 | 89034 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
68814 | 89032 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 272 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
70767 | 41267 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 44 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1999 12:00:00 AM | Permit Number 41952 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | |||
71624 | 113963 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 8 | 3x3 | 6011667.06303 | 2107250.97581 | 37.7667670024209 | -122.402892005557 | (37.7667670024209, -122.402892005557) | 8 | 2 | 8 | 28853 | 20 | ||
71975 | 63893 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1X BRADY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24602 | 6006435 | 2109828 | 37.7735493586958 | -122.421171875993 | (37.7735493586958, -122.421171875993) | 8 | 2 | 9 | 28853 | 19 | ||
76720 | 227517 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1173 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6006514.95028 | 2109636.302 | 37.7730275087506 | -122.420881702949 | (37.7730275087506, -122.420881702949) | 8 | 2 | 9 | 28853 | 19 | |||
77590 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 99X Cleveland St | 3 | Side Yard : Yard | Tree | Private 2 | 3x6 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
77862 | 39881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.7830638517017 | -122.394581669285 | (37.7830638517017, -122.394581669285) | 6 | 2 | 9 | 28856 | 6 | ||
77998 | 191459 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 110 Main St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6014515.87712 | 2115897.32843 | 37.7906665955326 | -122.393643582697 | (37.7906665955326, -122.393643582697) | 12 | 2 | 9 | 28855 | 6 |
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) );