Name: Restaurant Inspections

Display Field:

Type: Table

Description: <p>The Restaurant Inspections dataset includes records for food safety inspections conducted by the Detroit Health Department between August 1, 2016 and approximately one month ago. Due to the the inspection process, records in this data set do not reflect inspections started within 30 days of the most recent data update.</p>

Copyright Text:

Max Record Count: 1000

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:

• inspection_id (type: esriFieldTypeDouble, alias: Inspection ID, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• establishment_id (type: esriFieldTypeDouble, alias: Establishment ID, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• establishment_name (type: esriFieldTypeString, alias: Establishment Name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• inspection_date (type: esriFieldTypeDateOnly, alias: Inspection Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• inspection_type (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• inspector_id (type: esriFieldTypeDouble, alias: Inspector ID, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• num_priority_violations (type: esriFieldTypeDouble, alias: num_priority_violations, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• num_foundation_violations (type: esriFieldTypeDouble, alias: Priority Violations, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• num_core_violations (type: esriFieldTypeDouble, alias: Core Violations, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• num_corrected_violations (type: esriFieldTypeDouble, alias: num_corrected_violations, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• is_in_compliance (type: esriFieldTypeString, alias: is_in_compliance, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/2/2025 1:13:06 AM

Schema Last Edit Date: 12/2/2025 1:13:06 AM

Data Last Edit Date: 12/2/2025 1:13:06 AM

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