Layer: Post Abatement Verification Reports (ID:0)

View In: Map Viewer

Name: Post Abatement Verification Reports

Display Field: street_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Post-Abatement Verification (PAV) reports for residential and commercial properties for the City of Detroit's demolition program. Each row in this table represents a "Passed" PAV Report which indicates the property had sufficient Asbestos and Hazardous and Regulated Materials (HAZMAT) abatement performed. This data is provided by the Detroit Construction and Demolition Department.

Before a property is contracted for demolition, an Asbestos Survey is performed to identify and test potential Hazardous and Regulated Materials (HAZMAT) within the structure. The report also outlines the location and quantities of the hazardous materials that should be abated before the demolition takes place. The Demolition Contractor performs the Asbestos and HAZMAT abatement. The PAV Contractor then performs an inspection of the building to verify that the materials outlined in the Asbestos Survey were adequately abated. For planned demolitions, the passed PAV Report must be publicly available online 3 days prior to the demolition of the structure. Buildings that have been issued an Emergency Demolition Order by the Building Safety Engineering and Environmental Department (BSEED) are exempt from this requirement.

For more information on the demolition process please refer to: https://detroitmi.gov/departments/construction-and-demolition-department/demolition-process

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,76,115,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
pav_id (type: esriFieldTypeString, alias: PAV ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
structure_type (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
pav_passed_date (type: esriFieldTypeDateOnly, alias: PAV Passed Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
pav_contractor (type: esriFieldTypeString, alias: PAV Contractor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
demolition_contractor (type: esriFieldTypeString, alias: Demolition Contractor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
demolition_contract_group (type: esriFieldTypeString, alias: Demolition Contract Group, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
public_access_url (type: esriFieldTypeString, alias: Public Access URL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
pav_report_posted_at (type: esriFieldTypeDate, alias: PAV Report Publicly Uploaded At, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
council_district (type: esriFieldTypeInteger, alias: Council District, SQL Type: sqlTypeOther, nullable: true, editable: true)
street_number (type: esriFieldTypeInteger, alias: Street Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
street_prefix (type: esriFieldTypeString, alias: Street Prefix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
street_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
street_type (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
parcel_id (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
address_id (type: esriFieldTypeInteger, alias: Address ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
zip_code (type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/20/2025 11:12:01 PM

Schema Last Edit Date: 4/20/2025 11:12:01 PM

Data Last Edit Date: 4/20/2025 11:12:01 PM

Supported Operations: Query Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat