Name: Historic District Violations

Display Field: street_name

Type: Table

Description:

A violation is any unapproved work on the exterior of a property. Violations that are not addressed stay with a property, despite ownership changes, until reviewed and cleared by the Commission in response to an application. Unaddressed violations may complicate or prevent property transfers/sales. Unaddressed violations may result in enforcement activities, inspections, fines and "Stop Work" orders by the Buildings, Safety Engineering and Environmental Department (BSEED), or court orders to remedy the violation.

Each violation in this dataset has one of the following statuses:Cleared: Violation scope received a COA (Certificate of Appropriateness), a NTP (Notice to Proceed), or was considered ordinary maintenance.Open: Case may be going through one of several processes including applications, pending conditions for COAs, denials, HDC reviews, or notice letters.Open- Sent to BSEED: Violation scope has been referred to BSEED (Buildings, Safety Engineering and Environmental Department) for inspection and potential further enforcement. Questions about such enforcement should be directed to BSEED.Open - Sent to Court (BSEED): BSEED has referred these cases to court for further enforcement.

For more information please contact hdviolations@detroitmi.gov or visit Making Exterior Changes within Local Historic Districts within the city of Detroit's website.

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• violation_id (type: esriFieldTypeBigInteger, alias: Violation ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• intake_date (type: esriFieldTypeDateOnly, alias: Intake Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• historic_district (type: esriFieldTypeString, alias: Historic District, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• case_status (type: esriFieldTypeString, alias: Case Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• violation_scope (type: esriFieldTypeString, alias: Violation Scope, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_addition_violation (type: esriFieldTypeString, alias: Has Addition Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_construction_new_violation (type: esriFieldTypeString, alias: Has New Construction Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_demolition_violation (type: esriFieldTypeString, alias: Has Demolition Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_doors_violation (type: esriFieldTypeString, alias: Has Doors Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_fence_violation (type: esriFieldTypeString, alias: Has Fence Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_garage_shed_violation (type: esriFieldTypeString, alias: Has Garage/Shed Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_landscape_violation (type: esriFieldTypeString, alias: Has Landscape Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_paint_violation (type: esriFieldTypeString, alias: Has Paint Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_porch_deck_violation (type: esriFieldTypeString, alias: Has Porch/Deck Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_roof_gutter_chimney_violati (type: esriFieldTypeString, alias: Has Roof/Gutter/Chimney Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_siding_walls_violation (type: esriFieldTypeString, alias: Has Siding/Walls Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_signage_violation (type: esriFieldTypeString, alias: Has Signage Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_site_improvements_violation (type: esriFieldTypeString, alias: Has Site Improvements Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_windows_violation (type: esriFieldTypeString, alias: Has Windows Violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• has_other_violation (type: esriFieldTypeString, alias: Has Other Violation, SQL Type: sqlTypeOther, length: 8000, 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)
• zip_code (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 5, 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 Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• address_id (type: esriFieldTypeInteger, alias: Address ID, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: historic_district_violations
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/21/2025 4:06:40 AM

Schema Last Edit Date: 7/21/2025 4:06:40 AM

Data Last Edit Date: 7/21/2025 4:06:40 AM

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