Licenses and Inspections: Case Investigations

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.**

Resources

Name Format Description Link
21 https://data.phila.gov/visualizations/li-inspections
8 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'
8 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'
8 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'
8 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'
61 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'
61 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'
61 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'
61 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'
61 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'
61 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'
2 https://cityofphiladelphia.github.io/carto-api-explorer/#case_investigations
21 https://metadata.phila.gov/#home/datasetdetails/5543ca785c4ae4cd66d3ff80/representationdetails/5e986970b2c39b001522fb9d/
8 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'
8 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'

Tags

  • department-of-licenses-and-inspections
  • planning
  • land-records
  • visualization
  • real-estate
  • zoning

Topics

  • Local Government

Categories