{"slug":"building-demolitions","title":"Building Demolitions","description":"This inventory records building demolitions in Philadelphia performed by private owners/contractors and the Department of Licenses and Inspections due to dangerous conditions. Each record provides information such as the demolition date, property address, permit number, and the entity responsible for the demolition.","publisher":"City of Philadelphia","organization_title":"City of Philadelphia","landing_page":"https://phl.carto.com/api/v2/sql?q=SELECT+*,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+demolitions&filename=demolitions&format=csv&skipfields=cartodb_id","file_count":1,"use_cases":[],"enrichment":{"jurisdiction_names":["Philadelphia, PA"],"jurisdiction_levels":["city"],"date_range":{},"date_descriptions":["Updated daily"],"cluster_name":"Demolition Notices And Airport Runways","has_geo_fields":true,"has_contact_fields":false,"has_temporal_fields":false,"has_financial_fields":false,"has_business_data":true,"resource_version_url":"https://phl.carto.com/api/v2/sql?q=SELECT+*,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+demolitions&filename=demolitions&format=csv&skipfields=cartodb_id"},"schema_count":1,"schemas":[{"columns":["city","state","zip_code","business_name","street_address","business_name_2","full_name_string","full_address_string"],"column_mapping":null,"sample_rows":[]}]}