About this Dataset

NESHAP Notifications Tied To Demolition Activity, January 2009 To April 2015

NESHAP is a program of the United States Environmental Protection Agency that regulates hazardous air pollutants and ensures that construction and demolition activities are in compliance with federal regulations. As a part of this program, the State of Michigan Department of Environmental Quality (MDEQ) requires notification from all contractors conducting alterations (either rehabilitation or demolition) on structures that have the potential to contain a hazardous substance such as lead or asbestos, regardless of whether the structure is actually found to contain the hazardous material. Because of this requirement, NESHAP notifications are an excellent proxy for identifying structures that have been demolished.

This dataset contains information on NESHAP notifications that have been identified as tied to demolition activity. The notifications date from 2009 through April, 2015, and have been sourced from the MDEQ's website as well as several tables obtained through a Freedom of Information Act request. The data contain information on the contractors for each demolition, the start and end date for the notification, and whether the property was surveyed as a residential structure in the 2009 Detroit Residential Parcel Survey.

Metadata associated with this file includes field description metadata and a narrative summary detailing the creation of the dataset.

The work to produce this file fell under the Motor City Mapping project. For more information on this project, please visit www.motorcitymapping.org.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T07:03:16.737907
Tags: asbestos, demolitions, detroit, environment, epa, mcm, mdeq, motor-city-mapping, neshap-notifications, property-land-use-and-housing, public-safety

Tables

Table 1

@usgov.city_of_ferndale_michigan_neshap_notifications_tied_to_9f1dadc1.table_1

1.13 MB
11524 rows
32 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "loc_name" VARCHAR,
  "status" VARCHAR,
  "score" DOUBLE,
  "match_type" VARCHAR,
  "match_addr" VARCHAR,
  "user_fld" VARCHAR,
  "addr_type" VARCHAR,
  "side" VARCHAR,
  "arc_street" VARCHAR,
  "arc_city" VARCHAR,
  "arc_state" VARCHAR,
  "arc_zip" VARCHAR,
  "facility_name" VARCHAR,
  "notification_id" VARCHAR,
  "facility_address" VARCHAR,
  "abatement_contractor" VARCHAR,
  "demo_contractor" VARCHAR,
  "datestartactual" TIMESTAMP,
  "monthstart" BIGINT,
  "daystart" BIGINT,
  "yearstart" BIGINT,
  "dateendactual" TIMESTAMP,
  "monthend" DOUBLE,
  "dayend" BIGINT,
  "yearend" BIGINT,
  "geoid10_tract" DOUBLE,
  "zcta5ce10" DOUBLE,
  "drps_resstr" DOUBLE,
  "d3_surveyparcelid" VARCHAR
);