Return to search results
Licenses and Inspections: Case Investigations
All investigations completed on a property with property maintenance violations by an inspector of the Department of Licenses & Inspections.
**Please note that this is a very large dataset. To see all investigations, download all datasets for all years.**
**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’s SQL API site and in the Carto guide in the section on making calls to the API.**
Complete Metadata
| accessLevel | public |
|---|---|
| contactPoint |
{
"fn": "ligisteam@phila.gov",
"hasEmail": "mailto:LIGISTEAM@phila.gov"
}
|
| description | All investigations completed on a property with property maintenance violations by an inspector of the Department of Licenses & Inspections. **Please note that this is a very large dataset. To see all investigations, download all datasets for all years.** **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’s SQL API site and in the Carto guide in the section on making calls to the API.** |
| distribution |
[
{
"title": "L&I Case investigations (API)",
"format": "API",
"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#case_investigations",
"mediaType": "application/http"
},
{
"title": "L&I Inspections (Visualization)",
"format": "HTML",
"accessURL": "https://data.phila.gov/visualizations/li-inspections",
"mediaType": "text/html"
},
{
"title": "L&I Case investigations (Metadata) ",
"format": "HTML",
"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca785c4ae4cd66d3ff80/representationdetails/5e986970b2c39b001522fb9d/",
"mediaType": "text/html"
},
{
"title": "L&I Case investigations - before 2007 (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3C%20'2007-01-01'"
},
{
"title": "L&I Case investigations - 2007 to 2009 (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2007-01-01'%20AND%20investigationcompleted%20%3C%20'2010-01-01'"
},
{
"title": "L&I Case investigations - 2010 to 2012 (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2010-01-01'%20AND%20investigationcompleted%20%3C%20'2013-01-01'"
},
{
"title": "L&I Case investigations - 2013 to 2015 (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2013-01-01'%20AND%20investigationcompleted%20%3C%20'2016-01-01'"
},
{
"title": "L&I Case investigations - 2016 to 2018 (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2016-01-01'%20AND%20investigationcompleted%20%3C%20'2019-01-01'"
},
{
"title": "L&I Case investigations - 2019 to present (CSV)",
"format": "CSV",
"mediaType": "text/csv",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2019-01-01'"
},
{
"title": "L&I Case investigations - before 2007 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3C%20'2007-01-01'"
},
{
"title": "L&I Case investigations - 2007 to 2009 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2007-01-01'%20AND%20investigationcompleted%20%3C%20'2010-01-01'"
},
{
"title": "L&I Case investigations - 2010 to 2012 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2010-01-01'%20AND%20investigationcompleted%20%3C%20'2013-01-01'"
},
{
"title": "L&I Case investigations - 2013 to 2015 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2013-01-01'%20AND%20investigationcompleted%20%3C%20'2016-01-01'"
},
{
"title": "L&I Case investigations - 2016 to 2018 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2016-01-01'%20AND%20investigationcompleted%20%3C%20'2019-01-01'"
},
{
"title": "L&I Case investigations - 2019 to present (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2019-01-01'"
}
]
|
| identifier | licenses-and-inspections-case-investigations |
| keyword |
[
"Department of Licenses and Inspections",
"Visualization",
"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: Case Investigations |
