{"accessLevel": "public", "contactPoint": {"fn": "ligisteam@phila.gov", "hasEmail": "mailto:LIGISTEAM@phila.gov"}, "description": "Complaints that were entered via 311 or by an individual in the department. Complaints were formerly known as 'Service Requests' in L&I's old enterprise database called 'Hansen', which was decommissioned in March 2020.\r\n\r\nEach row in the table represents a single 'call'. Calls are sometimes bunched into one 'Complaint' all sharing the same unique number.\r\n\r\n\r\n", "distribution": [{"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#complaints", "format": "API", "mediaType": "application/http", "title": "L&I Complaints (API)"}, {"accessURL": "https://data.phila.gov/visualizations/li-complaints", "format": "HTML", "mediaType": "text/html", "title": "L&I Complaints (Visualization)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca6d5c4ae4cd66d3ff52/representationdetails/5e5d50e0fbc9650019b56025/", "format": "HTML", "mediaType": "text/html", "title": "L&I Complaints (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+complaints&filename=complaints&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "L&I Complaints (GeoJSON)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+complaints&filename=complaints&format=shp&skipfields=cartodb_id", "format": "SHP", "mediaType": "application/zip", "title": "L&I Complaints (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+complaints&filename=complaints&format=csv&skipfields=cartodb_id", "format": "CSV", "mediaType": "text/csv", "title": "L&I Complaints (CSV)"}], "identifier": "licenses-and-inspections-complaints", "keyword": ["Department of Licenses and Inspections", "Visualization", "environment", "land records", "planning", "real estate", "zoning"], "license": "https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/", "modified": "R/P1D", "publisher": {"@type": "org:Organization", "name": "City of Philadelphia"}, "spatial": "Philadelphia, Pennsylvania", "title": "Licenses and Inspections Complaints"}