Name: Blight Tickets

Display Field: agency_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Blight Tickets are issued by city inspectors, police officers, and other city officials with the power to investigate and cite code violations. Blight Tickets are adjudicated as civil cases by the Department of Administrative Hearings (DAH), an independent quasi-judicial department established in January 2005 as a major component of the City's efforts to address blight. This dataset largely models the Blight Violation Case History system, which is administered by DAH and integrates data from departments that issue, process, and adjudicate blight violations. Blight tickets that are issued may be subsequently voided by the ticket writing department for various reasons.

Property maintenance codes are described in Article 15 of the Detroit City Code. Article 15, Section 10 defines violations of Article 15 as blight violations, and Section 11 contains a schedule of civil fines assessed for specified violations.

Blight Violations data is updated once daily.

Click here for the Analytics Hub visualization of Blight Violations.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9271518.4159
YMin: 0
XMax: 0
YMax: 5228630.6046
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"a50c1d95abac9ffc99cd08019e661853","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15,"angle":0,"xoffset":0,"yoffset":0}},"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:

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)
• ticket_id (type: esriFieldTypeDouble, alias: Ticket ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ticket_number (type: esriFieldTypeString, alias: Ticket Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ordinance_law (type: esriFieldTypeString, alias: Ordinance Law, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ordinance_description (type: esriFieldTypeString, alias: Ordinance Description, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• disposition (type: esriFieldTypeString, alias: Disposition, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• agency_name (type: esriFieldTypeString, alias: Agency Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• inspector_name (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ticket_issued_date (type: esriFieldTypeDateOnly, alias: Ticket Issued Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ticket_issued_time (type: esriFieldTypeTimeOnly, alias: Ticket Issued Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hearing_date (type: esriFieldTypeDateOnly, alias: Hearing Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hearing_time (type: esriFieldTypeTimeOnly, alias: Hearing Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• judgment_date (type: esriFieldTypeDateOnly, alias: Judgement Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• payment_date (type: esriFieldTypeDateOnly, alias: Payment Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ticket_updated_at (type: esriFieldTypeDate, alias: Ticket Updated At, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• amt_fine (type: esriFieldTypeDouble, alias: Fine Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amt_admin_fee (type: esriFieldTypeDouble, alias: Admin Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amt_state_fee (type: esriFieldTypeDouble, alias: State Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amt_late_fee (type: esriFieldTypeDouble, alias: Late Fee, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amt_discount (type: esriFieldTypeDouble, alias: Discount Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amt_clean_up_cost (type: esriFieldTypeDouble, alias: Clean Up Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amt_judgment (type: esriFieldTypeDouble, alias: Judgement Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amt_payment (type: esriFieldTypeDouble, alias: Payment Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
• amt_balance_due (type: esriFieldTypeDouble, alias: Balance Due, SQL Type: sqlTypeOther, nullable: true, editable: true)
• payment_status (type: esriFieldTypeString, alias: Payment Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• collection_status (type: esriFieldTypeString, alias: Collection Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• property_owner_id (type: esriFieldTypeDouble, alias: Property Owner ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• property_owner_name (type: esriFieldTypeString, alias: Property Owner Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• property_owner_address (type: esriFieldTypeString, alias: Property Owner Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• property_owner_street_number (type: esriFieldTypeString, alias: Property Owner Street Number, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• property_owner_street_name (type: esriFieldTypeString, alias: Property Owner Street Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• property_owner_city (type: esriFieldTypeString, alias: Property Owner City, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• property_owner_state (type: esriFieldTypeString, alias: Property Owner State, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• property_owner_zip_code (type: esriFieldTypeString, alias: Property Owner Zip Code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• property_owner_non_us_address (type: esriFieldTypeString, alias: Property Owner Non US Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• property_owner_country (type: esriFieldTypeString, alias: Property Owner Country, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• council_district (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• zip_code (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• street_number (type: esriFieldTypeDouble, alias: Street Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• street_prefix (type: esriFieldTypeString, alias: Street Prefix, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• street_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• street_type (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• parcel_id (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• address_id (type: esriFieldTypeDouble, 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)

Templates:

Name: blight_tickets
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/18/2025 10:58:11 PM

Schema Last Edit Date: 7/18/2025 10:58:11 PM

Data Last Edit Date: 7/18/2025 10:58:11 PM

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