{"accessLevel": "public", "contactPoint": {"fn": "Chris Park", "hasEmail": "mailto:chris.park@phila.gov"}, "description": "Displays the locations of picnic sites located within Philadelphia Parks and Recreation boundaries. Picnic sites are denoted as any location with a picnic table.", "distribution": [{"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+ppr_picnic_sites&filename=ppr_picnic_sites&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator", "format": "CSV", "mediaType": "text/csv", "title": "Picnic Sites (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+ppr_picnic_sites&filename=ppr_picnic_sites&format=shp&skipfields=cartodb_id", "format": "SHP", "mediaType": "application/zip", "title": "Picnic Sites (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+ppr_picnic_sites&filename=ppr_picnic_sites&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "Picnic Sites (GeoJSON)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#ppr_picnic_sites", "format": "API", "mediaType": "application/http", "title": "Picnic Sites (API)"}, {"accessURL": "http://metadata.phila.gov/#home/datasetdetails/5ce320f835d1480006084e0a/representationdetails/5ce320f835d1480006084e0e/", "format": "HTML", "mediaType": "text/html", "title": "Picnic Sites (Metadata)"}], "identifier": "ppr-picnic-sites", "keyword": ["environment", "health", "human services", "parks", "recreation", "Philadelphia Parks and Recreation"], "license": "https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/", "publisher": {"@type": "org:Organization", "name": "City of Philadelphia"}, "spatial": "Philadelphia, Pennsylvania", "title": "PPR Picnic Sites"}