{"accessLevel": "public", "contactPoint": {"fn": "LIGISTEAM@phila.gov", "hasEmail": "mailto:LIGISTEAM@phila.gov"}, "description": "Violations issued by the Department of Licenses and Inspections in reference to the Philadelphia Building Construction and Occupancy Code.\r\n\r\n**Please note that L&I Violations is a very large dataset. To see all violations, download all datasets for all years.** \r\n\r\n**If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto\u2019s SQL API site and in the Carto guide in the section on making calls to the API.**\r\n", "distribution": [{"accessURL": "https://data.phila.gov/visualizations/li-violations", "format": "HTML", "mediaType": "text/html", "title": "L&I Violations (Visualization)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2019-01-01'", "format": "CSV", "mediaType": "text/csv", "title": "L&I Violations - 2019 to present (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2016-01-01'%20AND%20violationdate%20%3C%20'2019-01-01'", "format": "CSV", "mediaType": "text/csv", "title": "L&I Violations - 2016 to 2018 (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2013-01-01'%20AND%20violationdate%20%3C%20'2016-01-01'", "format": "CSV", "mediaType": "text/csv", "title": "L&I Violations - 2013 to 2015 (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2010-01-01'%20AND%20violationdate%20%3C%20'2013-01-01'", "format": "CSV", "mediaType": "text/csv", "title": "L&I Violations - 2010 to 2012 (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2007-01-01'%20AND%20violationdate%20%3C%20'2010-01-01'", "format": "CSV", "mediaType": "text/csv", "title": "L&I Violations - 2007 to 2009 (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2019-01-01'", "format": "SHP", "mediaType": "application/zip", "title": "L&I Violations - 2019 to present (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2016-01-01'%20AND%20violationdate%20%3C%20'2019-01-01'", "format": "SHP", "mediaType": "application/zip", "title": "L&I Violations - 2016 to 2018 (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2013-01-01'%20AND%20violationdate%20%3C%20'2016-01-01'", "format": "SHP", "mediaType": "application/zip", "title": "L&I Violations - 2013 to 2015 (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2010-01-01'%20AND%20violationdate%20%3C%20'2013-01-01'", "format": "SHP", "mediaType": "application/zip", "title": "L&I Violations - 2010 to 2012 (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2007-01-01'%20AND%20violationdate%20%3C%20'2010-01-01'", "format": "SHP", "mediaType": "application/zip", "title": "L&I Violations - 2007 to 2009 (SHP)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#violations", "format": "API", "mediaType": "application/http", "title": "L&I Violations (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/5e99bab227c80700158695b0/", "format": "HTML", "mediaType": "text/html", "title": "L&I Violations (Metadata)"}, {"accessURL": "https://data.phila.gov/visualizations/li-unsafe", "format": "HTML", "mediaType": "text/html", "title": "L&I Unsafe Buildings (Visualization)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+unsafe&filename=unsafe&format=csv&skipfields=cartodb_id", "format": "CSV", "mediaType": "text/csv", "title": "L&I Unsafe Buildings (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+unsafe&filename=unsafe&format=shp&skipfields=cartodb_id", "format": "SHP", "mediaType": "application/zip", "title": "L&I Unsafe Buildings (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+unsafe&filename=unsafe&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "L&I Unsafe Buildings (GeoJSON)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#unsafe", "format": "API", "mediaType": "application/http", "title": "L&I Unsafe Buildings (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/5e98b247c4d4770015ca69f7/", "format": "HTML", "mediaType": "text/html", "title": "L&I Unsafe Buildings (Metadata)"}, {"accessURL": "https://data.phila.gov/visualizations/li-imminently-dangerous", "format": "HTML", "mediaType": "text/html", "title": "L&I Imminently Dangerous (Visualization)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+imm_dang&filename=imm_dang&format=csv&skipfields=cartodb_id", "format": "CSV", "mediaType": "text/csv", "title": "L&I Imminently Dangerous Buildings (CSV)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+imm_dang&filename=imm_dang&format=shp&skipfields=cartodb_id", "format": "SHP", "mediaType": "application/zip", "title": "L&I Imminently Dangerous Buildings (SHP)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+imm_dang&filename=imm_dang&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "L&I Imminently Dangerous Buildings (GeoJSON)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#imm_dang", "format": "API", "mediaType": "application/http", "title": "L&I Imminently Dangerous Buildings (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/5e98add33441510015135305/", "format": "HTML", "mediaType": "text/html", "title": "L&I Imminently Dangerous Buildings (Metadata)"}, {"downloadURL": "https://hub.arcgis.com/api/v3/datasets/d9753daaefcb47cebabbfb9f9f344a91_0/downloads/data?format=csv&spatialRefId=3857&where=1%3D1", "format": "CSV", "mediaType": "text/csv", "title": "L&I Violation Definition (CSV)"}, {"accessURL": "https://services.arcgis.com/fLeGjb7u4uXqeF9q/ArcGIS/rest/services/VIOLATION_DEFINITION/FeatureServer/0/query?where=1%3D1", "format": "API", "mediaType": "application/http", "title": "L&I Violation Definition (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/60f6cc83d3d51d00211c2c5e/", "format": "HTML", "mediaType": "text/html", "title": "L&I Violation Definition (Metadata)"}, {"downloadURL": "https://hub.arcgis.com/api/v3/datasets/dbc8c4b06d3c40aab87d48a5fcdafc58_0/downloads/data?format=csv&spatialRefId=3857&where=1%3D1", "format": "CSV", "mediaType": "text/csv", "title": "L&I Contractor Violations (CSV)"}, {"accessURL": "https://services.arcgis.com/fLeGjb7u4uXqeF9q/arcgis/rest/services/CONTRACTOR_VIOLATIONS/FeatureServer/0/query?outFields=%2A&where=1%3D1", "format": "API", "mediaType": "application/http", "title": "L&I Contractor Violations (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/60a56925ef206f001ed69179/", "format": "HTML", "mediaType": "text/html", "title": "L&I Contractor Violations (Metadata)"}], "identifier": "licenses-and-inspections-code-violations", "keyword": ["public safety", "real estate", "land records", "Department of Licenses and Inspections", "code violations", "contractors", "dangerous buildings"], "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 Code Violations"}