trees
2,180 rows where qSpecies_id = 57 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
4618 | 31345 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 270 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 10 | Permit Number 34956 | 6006088.23081 | 2111255.80978 | 37.7774502243821 | -122.422472877923 | (37.7774502243821, -122.422472877923) | 7 | 9 | 11 | 28852 | 10 | |
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 | |||
7768 | 227479 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 245 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003729.95896 | 2109287.50824 | 37.7719124339341 | -122.430490439197 | (37.7719124339341, -122.430490439197) | 15 | 9 | 11 | 29492 | 10 | |||
7918 | 129616 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007378.23169 | 2111027.62658 | 37.7768963760054 | -122.417994148015 | (37.7768963760054, -122.417994148015) | 7 | 9 | 9 | 28852 | 36 | |||
8371 | 12302 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 945X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004623.92182 | 2111884.23425 | 37.7790930089412 | -122.427583190964 | (37.7790930089412, -122.427583190964) | 7 | 9 | 11 | 29490 | 41 | |||
11655 | 140565 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1135 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003754.9228 | 2111761.6819 | 37.7787073194129 | -122.4305806639 | (37.7787073194129, -122.4305806639) | 15 | 9 | 11 | 29492 | 41 | |||
15127 | 103601 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
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 | |||
16833 | 23387 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006004.32963 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | 13 | 9 | 1 | 28858 | 41 | |||
17812 | 129601 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005516.81947 | 2117765.82234 | 37.7952928511338 | -122.424912856464 | (37.7952928511338, -122.424912856464) | 13 | 9 | 1 | 28858 | 27 | |||
19703 | 129607 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005934.12087 | 2117690.49416 | 37.7951095809901 | -122.42346356661 | (37.7951095809901, -122.42346356661) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |
20799 | 108149 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
21508 | 12295 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 845 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004849.7362 | 2111749.3214 | 37.7787353414927 | -122.426792396306 | (37.7787353414927, -122.426792396306) | 7 | 9 | 11 | 28852 | 41 | |||
21673 | 129611 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005874.36357 | 2117588.54131 | 37.7948262711743 | -122.423663083898 | (37.7948262711743, -122.423663083898) | 13 | 9 | 1 | 28858 | 27 | |||
21791 | 141984 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1077 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004054.425 | 2111804.9181 | 37.7788429977364 | -122.429547653761 | (37.7788429977364, -122.429547653761) | 7 | 9 | 11 | 29490 | 41 | |||
22447 | 227487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 363 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003972.26213 | 2109022.08762 | 37.7711973766861 | -122.429633361902 | (37.7711973766861, -122.429633361902) | 7 | 9 | 11 | 29492 | 10 | |||
22633 | 141822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1001 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004770.3402 | 2112320.581 | 37.7802993903032 | -122.427107758126 | (37.7802993903032, -122.427107758126) | 7 | 9 | 11 | 29490 | 41 | |||
23340 | 226753 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004702.0529 | 2110024.96112 | 37.7739923194146 | -122.427180432244 | (37.7739923194146, -122.427180432244) | 7 | 9 | 11 | 28852 | 10 | |||
25375 | 12330 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1035 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004740.4097 | 2112512.03764 | 37.7808233903837 | -122.427224943262 | (37.7808233903837, -122.427224943262) | 7 | 9 | 11 | 29490 | 41 | ||
25460 | 227484 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 233 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003739.20839 | 2109215.47693 | 37.7717151775349 | -122.43045330438 | (37.7717151775349, -122.43045330438) | 15 | 9 | 11 | 29492 | 10 | |||
25621 | 250098 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006037.70809 | 2115548.99376 | 37.7892354027317 | -122.422952860496 | (37.7892354027317, -122.422952860496) | 13 | 9 | 1 | 28858 | 41 | |||
26118 | 129592 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Jackson St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6005880.07877 | 2117261.61148 | 37.7939289267389 | -122.42362005315 | (37.7939289267389, -122.42362005315) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |
26426 | 129584 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100 Webster St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003287.46949 | 2116304.94268 | 37.7911554750944 | -122.432522363823 | (37.7911554750944, -122.432522363823) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |
27441 | 12328 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1025 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004756.1585 | 2112422.6893 | 37.780578952524 | -122.427164094387 | (37.780578952524, -122.427164094387) | 7 | 9 | 11 | 29490 | 41 | |||
27818 | 98647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | 13 | 9 | 1 | 57 | 17 | ||
28045 | 7974 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1955 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005597.93587 | 2116784.08675 | 37.7926018340689 | -122.424562312409 | (37.7926018340689, -122.424562312409) | 13 | 9 | 1 | 28858 | 27 | |||
28646 | 42768 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 837 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42744 | 6003836.146 | 2110735.9706 | 37.7758955707266 | -122.430226485287 | (37.7758955707266, -122.430226485287) | 7 | 9 | 11 | 29492 | 10 | ||
30465 | 143380 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1897 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003965.1287 | 2118668.8078 | 37.7976844492982 | -122.430346412036 | (37.7976844492982, -122.430346412036) | 13 | 9 | 1 | 57 | 17 | |||
30495 | 129591 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Jackson St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6005908.12306 | 2117266.84801 | 37.7939448878875 | -122.423523389509 | (37.7939448878875, -122.423523389509) | 13 | 9 | 1 | 28858 | 27 | |||
31252 | 14760 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 967 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004525.58671 | 2111875.68505 | 37.7790639723642 | -122.427922762836 | (37.7790639723642, -122.427922762836) | 7 | 9 | 11 | 29490 | 41 | |||
34652 | 108151 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
35565 | 143365 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1735 UNION ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 0ft | 6004681.3503 | 2118768.1568 | 37.7979977794826 | -122.427875172085 | (37.7979977794826, -122.427875172085) | 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 | |
36405 | 98645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.7992008856766 | -122.434457791187 | (37.7992008856766, -122.434457791187) | 13 | 9 | 1 | 57 | 17 | ||
36625 | 2170 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2299X FRANKLIN ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005396 | 2117789 | 37.7953496659997 | -122.425332561837 | (37.7953496659997, -122.425332561837) | 13 | 9 | 1 | 28858 | 27 | |||
36663 | 142060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004266.4173 | 2112234.0727 | 37.7800333508893 | -122.428844891753 | (37.7800333508893, -122.428844891753) | 7 | 9 | 11 | 29490 | 41 | |||
37048 | 129586 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1915 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004232.4663 | 2118008.34749 | 37.795886133905 | -122.429374228549 | (37.795886133905, -122.429374228549) | 13 | 9 | 1 | 28858 | 27 | |||
37518 | 14788 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1077 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/1992 12:00:00 AM | 6 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.429603641013 | (37.7788514015092, -122.429603641013) | 7 | 9 | 11 | 29490 | 41 | ||
38172 | 34688 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) | 13 | 9 | 1 | 57 | 17 |
39094 | 17357 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2200 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005533.42048 | 2117633.73572 | 37.7949311123398 | -122.42484601254 | (37.7949311123398, -122.42484601254) | 13 | 9 | 1 | 28858 | 27 | |||
39406 | 129582 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003450.16372 | 2117252.10795 | 37.7937653733223 | -122.432027112554 | (37.7937653733223, -122.432027112554) | 13 | 9 | 1 | 29490 | 27 | |||
40600 | 17748 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005989.12058 | 2115543.08105 | 37.7892164261498 | -122.423120547185 | (37.7892164261498, -122.423120547185) | 13 | 9 | 1 | 28858 | 41 | |||
40866 | 137562 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1341 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002737.4159 | 2112945.2111 | 37.7818992986555 | -122.434185243226 | (37.7818992986555, -122.434185243226) | 15 | 9 | 11 | 29490 | 41 | |||
40930 | 103608 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
41173 | 20204 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1315 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002765.7195 | 2112737.651 | 37.7813309972121 | -122.434072484072 | (37.7813309972121, -122.434072484072) | 15 | 9 | 11 | 29490 | 41 | |||
41197 | 129600 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005520.4 | 2117740.68195 | 37.7952240242221 | -122.424898677743 | (37.7952240242221, -122.424898677743) | 13 | 9 | 1 | 28858 | 27 | |||
41442 | 35152 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 265 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38683 | 6003463.92079467 | 2109118.95080504 | 37.7714345424169 | -122.431398649315 | (37.7714345424169, -122.431398649315) | 15 | 9 | 11 | 29492 | 10 | ||
42108 | 12331 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1045 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | 6004735.87767 | 2112555.20778 | 37.7809416686235 | -122.427243697772 | (37.7809416686235, -122.427243697772) | 7 | 9 | 11 | 29490 | 41 | |||
43511 | 98646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.7991951444108 | -122.434518715761 | (37.7991951444108, -122.434518715761) | 13 | 9 | 1 | 57 | 17 | ||
44846 | 129615 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 211 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006279.39268 | 2111260.53143 | 37.7774739709929 | -122.421811920298 | (37.7774739709929, -122.421811920298) | 7 | 9 | 11 | 28852 | 10 | |||
44926 | 103602 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
44946 | 12309 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 949 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004806.25288 | 2112097.03189 | 37.7796876103034 | -122.426967593325 | (37.7796876103034, -122.426967593325) | 7 | 9 | 11 | 29490 | 41 | |||
45042 | 141896 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601 Redwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004778.1201 | 2112091.5685 | 37.7796710183851 | -122.427064527635 | (37.7796710183851, -122.427064527635) | 7 | 9 | 11 | 29490 | 41 | |||
45053 | 98657 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002607.56666 | 2119218.59599 | 37.7991170337862 | -122.435083283187 | (37.7991170337862, -122.435083283187) | 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 | |
46037 | 12311 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 959X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004793.556 | 2112123.84108 | 37.7797605037857 | -122.427013427347 | (37.7797605037857, -122.427013427347) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |
48534 | 114558 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005244.08524 | 2117174.62604 | 37.7936541667538 | -122.425814460096 | (37.7936541667538, -122.425814460096) | 13 | 9 | 1 | 28858 | 27 | ||
49823 | 98650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002693.158 | 2119231.97091 | 37.7991586175436 | -122.434788065428 | (37.7991586175436, -122.434788065428) | 13 | 9 | 1 | 57 | 17 | ||
52203 | 7963 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1840 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005718.27737 | 2116441.98594 | 37.7916693064652 | -122.424121585933 | (37.7916693064652, -122.424121585933) | 13 | 9 | 1 | 28858 | 27 | |||
53669 | 250111 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Austin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006107.64961 | 2115425.94774 | 37.7889014952475 | -122.422702123212 | (37.7889014952475, -122.422702123212) | 13 | 9 | 1 | 28858 | 41 | |||
53690 | 103610 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | ||||
53881 | 254253 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601 Grove St | 1 | Front Yard : Yard | Tree | Private 2 | 6004708 | 2111182 | 37.777169601607 | -122.427242295103 | (37.777169601607, -122.427242295103) | 7 | 9 | 11 | 28852 | 10 | |||||
54055 | 7986 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2111 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005534.41759 | 2117282.00669 | 37.7939654095207 | -122.424817527421 | (37.7939654095207, -122.424817527421) | 13 | 9 | 1 | 28858 | 27 | |||
55440 | 141422 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004543.5906 | 2111042.8919 | 37.7767783457628 | -122.42780112527 | (37.7767783457628, -122.42780112527) | 7 | 9 | 11 | 28852 | 10 | |||
56083 | 141960 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 873 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004838.5689 | 2111828.9652 | 37.778953392387 | -122.426836701877 | (37.778953392387, -122.426836701877) | 7 | 9 | 11 | 28852 | 41 | |||
56368 | 34692 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) | 13 | 9 | 1 | 57 | 17 |
56899 | 226665 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 Buchanan St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004711.01966 | 2109215.80754 | 37.7717710874854 | -122.427091769887 | (37.7717710874854, -122.427091769887) | 7 | 9 | 11 | 28852 | 10 | |||
58569 | 14804 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1140 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/1994 12:00:00 AM | 3 | 4X4 | 6003547.1646 | 2111783.654 | 37.7787558775283 | -122.431300948764 | (37.7787558775283, -122.431300948764) | 15 | 9 | 11 | 29490 | 41 | ||
58686 | 98656 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.7991261619004 | -122.435006269744 | (37.7991261619004, -122.435006269744) | 13 | 9 | 1 | 57 | 17 | ||
59716 | 129606 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005930.11566 | 2117709.23046 | 37.7951608000883 | -122.423478757933 | (37.7951608000883, -122.423478757933) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
60654 | 137991 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1908 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003942.8867 | 2115083.0611 | 37.7878376428475 | -122.430167434422 | (37.7878376428475, -122.430167434422) | 13 | 9 | 11 | 29490 | 27 | |||
61099 | 142797 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 699 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6007064.6918 | 2113244.5216 | 37.7829657823409 | -122.419236076253 | (37.7829657823409, -122.419236076253) | 7 | 9 | 9 | 28852 | 36 | |||
61185 | 110060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2661 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000157.93618 | 2118825.46591 | 37.7978982024034 | -122.443531554039 | (37.7978982024034, -122.443531554039) | 13 | 9 | 1 | 57 | 17 | ||||
61667 | 12329 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1035 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 4X4 | 6004738.43022 | 2112529.1477 | 37.7808702584368 | -122.427233010388 | (37.7808702584368, -122.427233010388) | 7 | 9 | 11 | 29490 | 41 | |||
61795 | 88217 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2833 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51182 | 6002528.21368 | 2117927.18 | 37.7955666353375 | -122.435265448048 | (37.7955666353375, -122.435265448048) | 13 | 9 | 1 | 57 | 17 | |
64257 | 227480 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 247 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003730.80574 | 2109266.10983 | 37.7718537271043 | -122.430485983041 | (37.7718537271043, -122.430485983041) | 15 | 9 | 11 | 29492 | 10 | |||
64404 | 14762 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 975 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004490.14846 | 2111870.78512 | 37.7790485134681 | -122.428045008866 | (37.7790485134681, -122.428045008866) | 7 | 9 | 11 | 29490 | 41 | |||
66513 | 226752 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 188 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004776.27473 | 2109101.09065 | 37.7714597925537 | -122.426857876903 | (37.7714597925537, -122.426857876903) | 7 | 9 | 5 | 28852 | 10 | |||
68304 | 129610 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005886.38297 | 2117589.46023 | 37.7948294727542 | -122.423621560411 | (37.7948294727542, -122.423621560411) | 13 | 9 | 1 | 28858 | 27 | |||
68439 | 99103 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 201 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006380 | 2111267.6 | 37.7774990526419 | -122.421464387784 | (37.7774990526419, -122.421464387784) | 7 | 9 | 11 | 28852 | 10 | ||||
69727 | 226663 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Buchanan St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6004754.99125 | 2108900.44461 | 37.7709076637003 | -122.426917205171 | (37.7709076637003, -122.426917205171) | 7 | 9 | 11 | 28852 | 10 | |||
70071 | 129614 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1050 Van Ness Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6006528.24106 | 2114177.52587 | 37.7854973571526 | -122.42115824897 | (37.7854973571526, -122.42115824897) | 13 | 9 | 9 | 28858 | 36 | |||
71245 | 129580 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2845 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5999458.55424 | 2117691.50013 | 37.7947447233346 | -122.445870006289 | (37.7947447233346, -122.445870006289) | 13 | 9 | 1 | 57 | 27 | |||
73436 | 27488 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2113 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.423437499889 | (37.7949042735724, -122.423437499889) | 13 | 9 | 1 | 28858 | 27 | |||
73845 | 20210 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1349 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002745.5181122 | 2112859.7826276 | 37.7816651934241 | -122.434151104411 | (37.7816651934241, -122.434151104411) | 15 | 9 | 11 | 29490 | 41 | |||
74240 | 14761 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 971 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004507.86758 | 2111873.23509 | 37.7790562429454 | -122.427983885875 | (37.7790562429454, -122.427983885875) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
75426 | 8120 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 850X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6003699.00422 | 2111459.33104 | 37.7778739709463 | -122.430752525918 | (37.7778739709463, -122.430752525918) | 15 | 9 | 11 | 29492 | 41 | |||
75514 | 58120 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 839 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 17101 | 6003847.07815842 | 2110734.06414103 | 37.7758909552538 | -122.430188532102 | (37.7758909552538, -122.430188532102) | 7 | 9 | 11 | 29492 | 10 | ||
75796 | 12296 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 853 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004840.61204 | 2111776.51991 | 37.7788095060362 | -122.426825897852 | (37.7788095060362, -122.426825897852) | 7 | 9 | 11 | 28852 | 41 | |||
76069 | 115717 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1533 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2016 12:00:00 AM | 3 | 3x3 | 6006572.5 | 2115603.9 | 37.78941632368 | -122.421106442083 | (37.78941632368, -122.421106442083) | 13 | 9 | 10 | 28858 | 21 | ||
76453 | 227477 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 200 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004706.62756 | 2109170.30594 | 37.7716459027615 | -122.42710372096 | (37.7716459027615, -122.42710372096) | 7 | 9 | 11 | 28852 | 10 | |||
78093 | 7993 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2250 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.424915114283 | (37.7950822509185, -122.424915114283) | 13 | 9 | 1 | 28858 | 27 | |||
80334 | 129603 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1617 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005654.34929 | 2118205.1509 | 37.7965069035375 | -122.424468245119 | (37.7965069035375, -122.424468245119) | 13 | 9 | 1 | 28858 | 27 |
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) );