Layer: Improve Detroit Issues (ID:0)

View In: Map Viewer

Name: Improve Detroit Issues

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Issues from the Improve Detroit application. Detroiters use Improve Detroit to submit non-emergency service requests to the City and to check the status of non-emergency requests such as potholes, graffiti and damaged street signs. Issues are submitted through the Improve Detroit mobile app or the website. Improve Detroit uses the SeeClickFix CRM system from CivicPlus.

Each row in the dataset represents a recorded issue, and includes information such as the type of issue reported, a brief description, issue status, and when an issue was opened, acknowledged, and closed. Links to a SeeClickFix webpage with an issue summary are also included. City of Detroit departments that use Improve Detroit are: DWSD, DPD, GSD, BSEED, DPW, PLA, PDD, Demolition, CRIO and DDOT. DoIT acts as system administrators.

Click here for the Analytics Hub visualization of Improve Detroit Issues.

NOTE: This dataset may not be downloadable through the Open Data Portal. The complete dataset, updated daily, is available to download in csv format.

Copyright Text:

Min. Scale: 4622325

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","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}}}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

issue_id (type: esriFieldTypeDouble, alias: Issue ID, SQL Type: sqlTypeFloat, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 401, nullable: true, editable: true)
request_type (type: esriFieldTypeString, alias: Request Type Title, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
report_method (type: esriFieldTypeString, alias: Report Method, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
priority_code (type: esriFieldTypeString, alias: Priority Code, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
created_at (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
acknowledged_at (type: esriFieldTypeDate, alias: Date Acknowledged, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
updated_at (type: esriFieldTypeDate, alias: Date Updated, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
closed_at (type: esriFieldTypeDate, alias: Days to Close, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
reopened_at (type: esriFieldTypeDate, alias: Date Reopened, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
num_days_to_close (type: esriFieldTypeDouble, alias: Number of Days to Close, SQL Type: sqlTypeFloat, nullable: true, editable: true)
num_hours_to_close (type: esriFieldTypeDouble, alias: Number of Hours to Close, SQL Type: sqlTypeFloat, nullable: true, editable: true)
issue_url (type: esriFieldTypeString, alias: Issue URL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
council_district (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
zip_code (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
street_number (type: esriFieldTypeDouble, alias: Street Number, SQL Type: sqlTypeFloat, nullable: true, editable: true)
street_prefix (type: esriFieldTypeString, alias: Street Prefix, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
street_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
street_type (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
address_id (type: esriFieldTypeDouble, alias: Address ID, SQL Type: sqlTypeFloat, nullable: true, editable: true)
longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/19/2025 2:39:26 PM

Schema Last Edit Date: 7/19/2025 2:39:26 PM

Data Last Edit Date: 7/19/2025 2:39:26 PM

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