trees
2,180 rows where qSpecies_id = 57 sorted by Latitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
127640 | 68918 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1731 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 13 | Permit Number 32899 | 6009145.56642 | 2119236.5699 | 37.799535459556 | -122.412460772349 | (37.799535459556, -122.412460772349) | 3 | 1 | 10 | 308 | 32 | |
142139 | 34693 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.434380455813 | (37.799535058456, -122.434380455813) | 13 | 9 | 1 | 57 | 17 |
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 |
115029 | 61248 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1993 12:00:00 AM | Permit Number 21122 | 6007711.12009364 | 2119245.98740089 | 37.7994807139026 | -122.417425152198 | (37.7994807139026, -122.417425152198) | 5 | 1 | 1 | 308 | 32 | ||
162318 | 34689 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.7994344701793 | -122.434367321195 | (37.7994344701793, -122.434367321195) | 13 | 9 | 1 | 57 | 17 |
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 | |||
47447 | 129639 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1136 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007510.50379 | 2119218.83195 | 37.7993948622524 | -122.418117431574 | (37.7993948622524, -122.418117431574) | 5 | 1 | 1 | 28858 | 32 | |||
123087 | 34690 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) | 13 | 9 | 1 | 57 | 17 |
21457 | 73647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1100 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769028 | 6011581.87532 | 2119117.15178 | 37.7993439875935 | -122.404021813977 | (37.7993439875935, -122.404021813977) | 3 | 1 | 10 | 308 | 23 | |
168139 | 34691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.434350145047 | (37.7993346796145, -122.434350145047) | 13 | 9 | 1 | 57 | 17 |
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 | |||
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 | |
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 |
98189 | 53446 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/1986 12:00:00 AM | 13 | Permit Number 23061 | 6007531.55063 | 2119171.09402 | 37.799264970461 | -122.418041215832 | (37.799264970461, -122.418041215832) | 5 | 1 | 10 | 28858 | 32 | |
108543 | 67860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.434397983605 | (37.7992088356751, -122.434397983605) | 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 | ||
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 | ||
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 | ||
93651 | 98648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | 13 | 9 | 1 | 57 | 17 | ||
119738 | 129636 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1181 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007340.70028 | 2119141.24699 | 37.7991722746363 | -122.418699507883 | (37.7991722746363, -122.418699507883) | 5 | 1 | 10 | 28858 | 32 | |||
152683 | 98649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.7991623281478 | -122.434737597267 | (37.7991623281478, -122.434737597267) | 13 | 9 | 1 | 57 | 17 | ||
65632 | 129635 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1181 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007311.91376 | 2119137.96682 | 37.7991616473392 | -122.418798886561 | (37.7991616473392, -122.418798886561) | 5 | 1 | 10 | 28858 | 32 | |||
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 | ||
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 | |||
137518 | 98655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | 5x5 | 6002650.75991 | 2119226.56813 | 37.7991413757273 | -122.434934390513 | (37.7991413757273, -122.434934390513) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
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 | ||
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 | ||
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 | ||||
9311 | 71535 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007520.46607 | 2118819.96047 | 37.7983002218264 | -122.418054666102 | (37.7983002218264, -122.418054666102) | 5 | 1 | 10 | 28858 | 32 | |||
18649 | 73588 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1145 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007504.43189 | 2118817.2788 | 37.7982919561693 | -122.418109959117 | (37.7982919561693, -122.418109959117) | 5 | 1 | 10 | 28858 | 32 | |||
133864 | 142939 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 308 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010769.7296 | 2118667.9444 | 37.7980651646277 | -122.406800460442 | (37.7980651646277, -122.406800460442) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
162983 | 129559 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2661 Greenwich St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 1ft | 6000174.65033 | 2118828.48318 | 37.7979074402255 | -122.443473935388 | (37.7979074402255, -122.443473935388) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||||
48624 | 129633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1828 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007334.41691 | 2118641.32283 | 37.7977992544837 | -122.418685778819 | (37.7977992544837, -122.418685778819) | 5 | 1 | 10 | 28858 | 32 | |||
9252 | 73860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1652 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6008793.24364 | 2118610.57457 | 37.7977968533 | -122.413635639483 | (37.7977968533, -122.413635639483) | 3 | 1 | 10 | 308 | 21 | |||
91460 | 68920 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1652 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 5 | Permit Number 32904 | 6008796.25541 | 2118594.60343 | 37.79775316962 | -122.413624087676 | (37.79775316962, -122.413624087676) | 3 | 1 | 10 | 308 | 21 | |
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 | |||
172128 | 129570 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1895 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003964.93284 | 2118665.52225 | 37.7976754169294 | -122.43034685523 | (37.7976754169294, -122.43034685523) | 13 | 9 | 1 | 57 | 17 | |||
131683 | 107463 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008753.83856 | 2118472.3887 | 37.7974152162793 | -122.413762212943 | (37.7974152162793, -122.413762212943) | 5 | 1 | 10 | 308 | 21 | |||||
113675 | 38523 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2014 12:00:00 AM | 3 | Permit Number 773138 | 6008768.83808 | 2118471.22766 | 37.7974128706661 | -122.41371022836 | (37.7974128706661, -122.41371022836) | 5 | 1 | 10 | 308 | 21 | |
67147 | 107462 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6008769.70277 | 2118455.29192 | 37.7973691636203 | -122.413706108551 | (37.7973691636203, -122.413706108551) | 5 | 1 | 10 | 308 | 21 | ||||
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 | |
130951 | 129625 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 54 Glover St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 2ft | 6008038.60532 | 2118409.42437 | 37.7972021406145 | -122.416232651327 | (37.7972021406145, -122.416232651327) | 5 | 1 | 10 | 28858 | 21 | |||
121578 | 33112 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2628 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 9 | Permit Number 37349 | 6000339.44764 | 2118557.89779 | 37.7971738812189 | -122.442884250816 | (37.7971738812189, -122.442884250816) | 13 | 9 | 1 | 57 | 17 | |
177750 | 129604 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1675 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004955.93946 | 2118458.8169 | 37.7971639410302 | -122.426902971605 | (37.7971639410302, -122.426902971605) | 13 | 9 | 1 | 57 | 17 | |||
114604 | 129587 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1911 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 15 | Width 4ft | Permit Number 52344 | 6003864.05358 | 2118305.88007 | 37.7966822173737 | -122.430670247849 | (37.7966822173737, -122.430670247849) | 13 | 9 | 1 | 57 | 17 | |
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 | |||
90277 | 129602 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1699 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005553.17918 | 2118195.8648 | 37.7964756925582 | -122.424817655109 | (37.7964756925582, -122.424817655109) | 13 | 9 | 1 | 28858 | 27 | |||
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 | ||
84106 | 121040 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
123182 | 121041 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
161574 | 129626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2137 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006390.19971 | 2118075.36591 | 37.7961920733723 | -122.421912814324 | (37.7961920733723, -122.421912814324) | 13 | 9 | 10 | 28858 | 32 | |||
188173 | 129627 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2137 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006391.72079 | 2118062.38927 | 37.7961565285655 | -122.421906628814 | (37.7961565285655, -122.421906628814) | 13 | 9 | 10 | 28858 | 32 | |||
125749 | 129569 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2817 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6001039.8423 | 2118145.56698 | 37.7960816348005 | -122.440431129607 | (37.7960816348005, -122.440431129607) | 13 | 9 | 1 | 57 | 17 | |||
83091 | 34203 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1911 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | 9 | Permit Number 38022 | 6004270.98382 | 2118013.74533 | 37.7959031355868 | -122.429241335742 | (37.7959031355868, -122.429241335742) | 13 | 9 | 1 | 28858 | 27 | ||
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 | |||
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 | |
110653 | 33285 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1537 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 6 | Permit Number 37447 | 6008380.61834 | 2117789.48589 | 37.7955191682212 | -122.415005295285 | (37.7955191682212, -122.415005295285) | 5 | 1 | 10 | 28858 | 21 | |
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 | |||
131069 | 129599 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2363 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005464.37199 | 2117777.39415 | 37.7953216618076 | -122.425095157137 | (37.7953216618076, -122.425095157137) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
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 | |||
105524 | 129605 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2101 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 4ft | 6005928.19437 | 2117729.67294 | 37.7952168215458 | -122.423486859933 | (37.7952168215458, -122.423486859933) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
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 | |||
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 | |||
140957 | 7994 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2250 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6005514.59005 | 2117689.16769 | 37.7950822509185 | -122.424915114283 | (37.7950822509185, -122.424915114283) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
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 | |||
116611 | 27486 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2113 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6005940.11472 | 2117615.5981 | 37.7949042735724 | -122.423437499889 | (37.7949042735724, -122.423437499889) | 13 | 9 | 1 | 28858 | 27 | |||
141509 | 27487 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2113 Van Ness Ave | 1 | 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 | |||
193421 | 129608 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005921.62398 | 2117595.14821 | 37.7948470796741 | -122.423500026015 | (37.7948470796741, -122.423500026015) | 13 | 9 | 1 | 28858 | 27 | |||
133692 | 129609 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1700 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005904.29601 | 2117592.2982 | 37.7948382762124 | -122.423559780579 | (37.7948382762124, -122.423559780579) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
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 | |||
165186 | 129581 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2845 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999473.29615 | 2117693.165 | 37.794750136363 | -122.445819117259 | (37.794750136363, -122.445819117259) | 13 | 9 | 1 | 57 | 27 | |||
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 | |||
92358 | 129597 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005573.05547 | 2117336.02058 | 37.7941159002879 | -122.424687680612 | (37.7941159002879, -122.424687680612) | 13 | 9 | 1 | 28858 | 27 | |||
147150 | 11437 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005576.77796 | 2117294.00706 | 37.7940007519905 | -122.424671810255 | (37.7940007519905, -122.424671810255) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
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 | |||
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 | |||
92842 | 7985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2111 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005519.50842 | 2117258.74677 | 37.7939007015449 | -122.424867459092 | (37.7939007015449, -122.424867459092) | 13 | 9 | 1 | 28858 | 27 | |||
177360 | 129593 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1730 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6005825.1894 | 2117248.62262 | 37.7938901641474 | -122.423809051951 | (37.7938901641474, -122.423809051951) | 13 | 9 | 1 | 28858 | 27 | |||
131350 | 129598 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2111 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005541.32227 | 2117252.79941 | 37.7938856036766 | -122.424791557691 | (37.7938856036766, -122.424791557691) | 13 | 9 | 1 | 28858 | 27 | |||
191258 | 129594 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1730 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6005803.86488 | 2117245.73922 | 37.793881043227 | -122.423882631794 | (37.793881043227, -122.423882631794) | 13 | 9 | 1 | 28858 | 27 | |||
174184 | 129595 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1730 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005777.14779 | 2117244.21265 | 37.7938753433298 | -122.423974966976 | (37.7938753433298, -122.423974966976) | 13 | 9 | 1 | 28858 | 27 | |||
159730 | 11438 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X FRANKLIN ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005630 | 2117242 | 37.7938609593863 | -122.424483955414 | (37.7938609593863, -122.424483955414) | 13 | 9 | 1 | 28858 | 27 | |||
121809 | 129596 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1730 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6005755.36361 | 2117239.26251 | 37.793860521606 | -122.424049990209 | (37.793860521606, -122.424049990209) | 13 | 9 | 1 | 28858 | 27 | |||
90155 | 11435 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2100X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005584.47186 | 2117242.36199 | 37.7938593821703 | -122.424641513005 | (37.7938593821703, -122.424641513005) | 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 | |||
171596 | 129583 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2230 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003442.92967 | 2117250.46473 | 37.79376045134 | -122.432052025606 | (37.79376045134, -122.432052025606) | 13 | 9 | 1 | 29490 | 27 | |||
151462 | 62699 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1870 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 3 | Permit Number 777072 | 6005257.84776 | 2117174.75811 | 37.793655307103 | -122.425766849977 | (37.793655307103, -122.425766849977) | 13 | 9 | 1 | 28858 | 27 | ||
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 | ||
121081 | 7978 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2020 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005621.04444 | 2116972.96262 | 37.7931217447269 | -122.424495796768 | (37.7931217447269, -122.424495796768) | 13 | 9 | 1 | 28858 | 27 | |||
106136 | 7975 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2003 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005570.14471 | 2116971.51831 | 37.7931149044793 | -122.42467181028 | (37.7931149044793, -122.42467181028) | 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) );