Layers:
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:
XMin: -9271518.18790792
YMin: 5199369.76080233
XMax: -9229631.48344504
YMax: 5228630.63166429
Spatial Reference: 102100 (3857)
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:
IsSystemMaintained : True
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:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/28/2025 2:38:56 PM
Schema Last Edit Date: 7/28/2025 2:38:56 PM
Data Last Edit Date: 7/28/2025 2:38:56 PM