Description

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

Dataset Attributes

  • ObjectID
    Number
  • Loc_name
    Text
    {"value"=>"ParcelLocator_", "count"=>11323} (), {"value"=>"ParcelLocator3", "count"=>178} (), {"value"=>"ParcelLocator1", "count"=>12} ()
  • Status
    Text
    {"value"=>"M", "count"=>11513} (), {"value"=>"U", "count"=>11} ()
  • Score
    Number
    0 to 100
  • Match_type
    Text
    {"value"=>"A", "count"=>11394} (), {"value"=>"M", "count"=>130} ()
  • Match_addr
    Text
    {"value"=>"13137 WADE ST, DETROIT, MI, 48213", "count"=>1} (), {"value"=>"13136 MAYFIELD ST, DETROIT, MI, 48205", "count"=>1} (), {"value"=>"13133 MAINE ST, DETROIT, MI, 48212", "count"=>1} (), {"value"=>"13133 GRATIOT AVE, DETROIT, MI, 48205", "count"=>1} (), {"value"=>"13131 FLANDERS ST, DETROIT, MI, 48205", "count"=>1} (), {"value"=>"13128 MAYFIELD ST, DETROIT, MI, 48205", "count"=>1} (), {"value"=>"13127 WILFRED ST, DETROIT, MI, 48213", "count"=>1} (), {"value"=>"13126 MENDOTA ST, DETROIT, MI, 48238", "count"=>1} (), {"value"=>"13124 MORAN RD, DETROIT, MI, 48212", "count"=>1} (), {"value"=>"13121 MOENART ST, DETROIT, MI, 48212", "count"=>1} ()
  • User_fld
    Text
    {"value"=>"08009062.", "count"=>1} (), {"value"=>"08009056.", "count"=>1} (), {"value"=>"08009050.", "count"=>1} (), {"value"=>"08009044.", "count"=>1} (), {"value"=>"08009018.", "count"=>1} (), {"value"=>"08009015-6", "count"=>1} (), {"value"=>"08009006.", "count"=>1} (), {"value"=>"08009003.", "count"=>1} (), {"value"=>"08008997.", "count"=>1} (), {"value"=>"08008992.", "count"=>1} ()
  • Addr_type
    Text
    {"value"=>"StreetAddress", "count"=>11513} ()
  • Side
    Text
  • Street or Intersection
    Text
    {"value"=>"13138 Mackay", "count"=>1} (), {"value"=>"13138 APPOLINE", "count"=>1} (), {"value"=>"13137 WADE ST", "count"=>1} (), {"value"=>"13136 MAYFIELD ST", "count"=>1} (), {"value"=>"13133 Maine St", "count"=>1} (), {"value"=>"13133 GRATIOT AVE", "count"=>1} (), {"value"=>"13131 FLANDERS ST", "count"=>1} (), {"value"=>"13128 MAYFIELD ST", "count"=>1} (), {"value"=>"13127 WILFRED ST", "count"=>1} (), {"value"=>"13126 Mendota", "count"=>1} ()
  • City or Placename
    Text
    {"value"=>"Detroit", "count"=>11524} ()
  • State
    Text
    {"value"=>"MI", "count"=>7686} ()
  • ZIP Code
    Text
    {"value"=>"482", "count"=>5580} (), {"value"=>"48205", "count"=>45} (), {"value"=>"48228", "count"=>34} (), {"value"=>"48202", "count"=>20} (), {"value"=>"48227", "count"=>13} (), {"value"=>"48223", "count"=>10} (), {"value"=>"48201", "count"=>8} (), {"value"=>"48213", "count"=>8} (), {"value"=>"48226", "count"=>5} (), {"value"=>"48224", "count"=>3} ()
  • Facility_Name
    Text
    {"value"=>"Vacant House", "count"=>1612} (), {"value"=>"Abandoned/Vacant Structure", "count"=>1213} (), {"value"=>"VACANT RESIDENCE", "count"=>1008} (), {"value"=>"RESIDENTIAL DEMOLITION", "count"=>661} (), {"value"=>"RESIDENCE", "count"=>640} (), {"value"=>"ABANDONED SCHEDULED FOR D", "count"=>613} (), {"value"=>"ABANDONED", "count"=>563} (), {"value"=>"Residential", "count"=>477} (), {"value"=>"DWELLING", "count"=>440} (), {"value"=>"ABANDONED HOME", "count"=>381} ()
  • Notification_ID
    Text
    {"value"=>"20105486", "count"=>1} (), {"value"=>"20105485", "count"=>1} (), {"value"=>"20105433", "count"=>1} (), {"value"=>"20105432", "count"=>1} (), {"value"=>"20105431", "count"=>1} (), {"value"=>"20105430", "count"=>1} (), {"value"=>"20105429", "count"=>1} (), {"value"=>"20105385", "count"=>1} (), {"value"=>"20105384", "count"=>1} (), {"value"=>"20105383", "count"=>1} ()
  • Facility_Address
    Text
    {"value"=>"13139 Mackay", "count"=>1} (), {"value"=>"13138 Mcdougall Street", "count"=>1} (), {"value"=>"13138 Mackay", "count"=>1} (), {"value"=>"13138 APPOLINE", "count"=>1} (), {"value"=>"13137 WADE", "count"=>1} (), {"value"=>"13136 MAYFIELD", "count"=>1} (), {"value"=>"13133 Maine St", "count"=>1} (), {"value"=>"13133 GRATIOT", "count"=>1} (), {"value"=>"13131 FLANDERS", "count"=>1} (), {"value"=>"13128 MAYFIELD", "count"=>1} ()
  • Abatement_Contractor
    Text
    {"value"=>"PROFESSIONAL ABATEME", "count"=>792} (), {"value"=>"ENVIRONMENTAL MAINTE", "count"=>323} (), {"value"=>"LAKESHORE ENG SERVIC", "count"=>278} (), {"value"=>"NA", "count"=>149} (), {"value"=>"QUALITY ENVIRONMENTA", "count"=>74} (), {"value"=>"BROWN ENV CONSTRUCTI", "count"=>69} (), {"value"=>"AIR TECHNOLOGY SYSTE", "count"=>66} (), {"value"=>"GLOBAL GREEN SERVICE", "count"=>39} (), {"value"=>"GREEN EARTH ENVIRONM", "count"=>35} (), {"value"=>"BROWN ENVIRONMENTAL", "count"=>30} ()
  • Demo_Contractor
    Text
    {"value"=>"ADAMO DEMOLITION COMPANY", "count"=>1646} (), {"value"=>"HOMRICH WRECKING", "count"=>1171} (), {"value"=>"FARROW GROUP, INC.", "count"=>879} (), {"value"=>"ABLE DEMOLITION INC", "count"=>759} (), {"value"=>"1 WAY SERVICE, INC.", "count"=>701} (), {"value"=>"ADAMO DEMOLITION CO", "count"=>624} (), {"value"=>"ABLE DEMOLITION INC.", "count"=>606} (), {"value"=>"DMC CONSULTANTS, INC.", "count"=>487} (), {"value"=>"ABC DEMOLITION COMPANY, INC.", "count"=>426} (), {"value"=>"ABC DEMOLITION COMPA", "count"=>358} ()
  • DateStartActual
    Date
    1233619200000 to 1428624000000
  • MonthStart
    Text
    {"value"=>"8", "count"=>1668} (), {"value"=>"1", "count"=>1431} (), {"value"=>"9", "count"=>1123} (), {"value"=>"10", "count"=>920} (), {"value"=>"12", "count"=>914} (), {"value"=>"11", "count"=>881} (), {"value"=>"7", "count"=>858} (), {"value"=>"3", "count"=>855} (), {"value"=>"2", "count"=>806} (), {"value"=>"6", "count"=>745} ()
  • DayStart
    Text
    {"value"=>"5", "count"=>508} (), {"value"=>"12", "count"=>499} (), {"value"=>"18", "count"=>454} (), {"value"=>"8", "count"=>448} (), {"value"=>"6", "count"=>447} (), {"value"=>"23", "count"=>423} (), {"value"=>"11", "count"=>418} (), {"value"=>"14", "count"=>417} (), {"value"=>"16", "count"=>408} (), {"value"=>"28", "count"=>399} ()
  • YearStart
    Text
    {"value"=>"2014", "count"=>4393} (), {"value"=>"2013", "count"=>1913} (), {"value"=>"2011", "count"=>1716} (), {"value"=>"2010", "count"=>1390} (), {"value"=>"2015", "count"=>945} (), {"value"=>"2012", "count"=>935} (), {"value"=>"2009", "count"=>232} ()
  • DateEndActual
    Date
    1234137600000 to 1440979200000
  • MonthEnd
    Text
    {"value"=>"9", "count"=>1348} (), {"value"=>"8", "count"=>1282} (), {"value"=>"1", "count"=>1189} (), {"value"=>"11", "count"=>1014} (), {"value"=>"10", "count"=>931} (), {"value"=>"2", "count"=>913} (), {"value"=>"5", "count"=>879} (), {"value"=>"7", "count"=>864} (), {"value"=>"12", "count"=>851} (), {"value"=>"6", "count"=>787} ()
  • DayEnd
    Text
    {"value"=>"30", "count"=>1038} (), {"value"=>"31", "count"=>697} (), {"value"=>"1", "count"=>678} (), {"value"=>"28", "count"=>506} (), {"value"=>"15", "count"=>505} (), {"value"=>"10", "count"=>383} (), {"value"=>"25", "count"=>360} (), {"value"=>"23", "count"=>351} (), {"value"=>"11", "count"=>347} (), {"value"=>"29", "count"=>339} ()
  • YearEnd
    Text
    {"value"=>"2014", "count"=>4266} (), {"value"=>"2013", "count"=>1932} (), {"value"=>"2011", "count"=>1787} (), {"value"=>"2010", "count"=>1300} (), {"value"=>"2015", "count"=>1155} (), {"value"=>"2012", "count"=>868} (), {"value"=>"2009", "count"=>216} ()
  • GEOID10_Tract
    Text
    {"value"=>"26163524500", "count"=>324} (), {"value"=>"26163543600", "count"=>263} (), {"value"=>"26163541100", "count"=>236} (), {"value"=>"26163546000", "count"=>202} (), {"value"=>"26163543700", "count"=>197} (), {"value"=>"26163502000", "count"=>186} (), {"value"=>"26163536300", "count"=>164} (), {"value"=>"26163500600", "count"=>162} (), {"value"=>"26163507900", "count"=>160} (), {"value"=>"26163512100", "count"=>155} ()
  • ZCTA5CE10
    Text
    {"value"=>"48205", "count"=>1264} (), {"value"=>"48228", "count"=>1046} (), {"value"=>"48224", "count"=>925} (), {"value"=>"48223", "count"=>802} (), {"value"=>"48238", "count"=>669} (), {"value"=>"48213", "count"=>586} (), {"value"=>"48210", "count"=>579} (), {"value"=>"48219", "count"=>558} (), {"value"=>"48209", "count"=>526} (), {"value"=>"48203", "count"=>495} ()
  • DRPS_ResStr
    Number
    1 to 1
  • D3_SurveyParcelID
    Text
    {"value"=>"04001990.10963", "count"=>2} (), {"value"=>"03002170.11795", "count"=>2} (), {"value"=>"08009015-6", "count"=>1} (), {"value"=>"08009006.18140", "count"=>1} (), {"value"=>"08009003.18140", "count"=>1} (), {"value"=>"08008997.17441", "count"=>1} (), {"value"=>"08008992.17441", "count"=>1} (), {"value"=>"08008919.6377", "count"=>1} (), {"value"=>"08008908.6377", "count"=>1} (), {"value"=>"08008646.2209", "count"=>1} ()

Related Datasets