Return to search results
Licenses and Inspections Complaints
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.
Each row in the table represents a single 'call'. Calls are sometimes bunched into one 'Complaint' all sharing the same unique number.
Complete Metadata
| 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. Each row in the table represents a single 'call'. Calls are sometimes bunched into one 'Complaint' all sharing the same unique number. |
| distribution |
[
{
"title": "L&I Complaints (API)",
"format": "API",
"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#complaints",
"mediaType": "application/http"
},
{
"title": "L&I Complaints (Visualization)",
"format": "HTML",
"accessURL": "https://data.phila.gov/visualizations/li-complaints",
"mediaType": "text/html"
},
{
"title": "L&I Complaints (Metadata)",
"format": "HTML",
"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca6d5c4ae4cd66d3ff52/representationdetails/5e5d50e0fbc9650019b56025/",
"mediaType": "text/html"
},
{
"title": "L&I Complaints (GeoJSON)",
"format": "GEOJSON",
"mediaType": "application/octet-stream",
"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+complaints&filename=complaints&format=geojson&skipfields=cartodb_id"
},
{
"title": "L&I Complaints (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+complaints&filename=complaints&format=shp&skipfields=cartodb_id"
},
{
"title": "L&I Complaints (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"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"
}
]
|
| 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 |
{
"name": "City of Philadelphia",
"@type": "org:Organization"
}
|
| spatial | Philadelphia, Pennsylvania |
| title | Licenses and Inspections Complaints |
