{
  "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"
}