Name: Traffic Crashes 2013

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

The State of Michigan’s criteria for a crash is a motor vehicle that was in transport and on the roadway, that resulted in death, injury, or property damage of $1,000 or more. Traffic crashes in this dataset are derived from SEMCOG’s Open Data Portal. Each row in the dataset represents a traffic crash that includes data about when and where the crash occurred, road conditions, number of individuals involved in the crash, and various factors that apply to the crash (Train, Bus, Deer, etc.). Also included is the number of injuries and fatalities that are associated with the crash.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9271487.08959499
YMin: 5199348.73439645
XMax: -9229583.89706844
YMax: 5228674.93401106
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:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• crash_id (type: esriFieldTypeInteger, alias: Crash ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• primary_road (type: esriFieldTypeString, alias: Primary Road, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• intersecting_road (type: esriFieldTypeString, alias: Intersecting Road, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• crash_date (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• day (type: esriFieldTypeSmallInteger, alias: Day, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• month (type: esriFieldTypeSmallInteger, alias: Month, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• year (type: esriFieldTypeSmallInteger, alias: Year, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• hour (type: esriFieldTypeSmallInteger, alias: Hour, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• weekday (type: esriFieldTypeSmallInteger, alias: Weekday, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• crash_type_code (type: esriFieldTypeSmallInteger, alias: Crash Type Code, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• highway_classification_code (type: esriFieldTypeSmallInteger, alias: Highway Classification Code, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• community_code (type: esriFieldTypeString, alias: Community Code, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• jurisdiction_code (type: esriFieldTypeSmallInteger, alias: Jurisdiction Code, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• lane_departure_type_code (type: esriFieldTypeSmallInteger, alias: Lane Departure Type Code, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• surface_type (type: esriFieldTypeString, alias: Surface Type, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• road_condition_code (type: esriFieldTypeSmallInteger, alias: Road Condition, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• weather_condition_code (type: esriFieldTypeSmallInteger, alias: Weather Condition, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• lighting_condition_code (type: esriFieldTypeSmallInteger, alias: Lighting Condition, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• speed_limit (type: esriFieldTypeSmallInteger, alias: Speed Limit, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• num_lanes (type: esriFieldTypeSmallInteger, alias: Lanes, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• num_units (type: esriFieldTypeSmallInteger, alias: Units, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• num_occupants (type: esriFieldTypeSmallInteger, alias: Occupants, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• most_severe_injury_code (type: esriFieldTypeSmallInteger, alias: Most Severe Injury, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• num_fatal_injuries (type: esriFieldTypeSmallInteger, alias: Fatal Injuries, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• num_suspected_serious_injuries (type: esriFieldTypeSmallInteger, alias: Suspected Serious Injuries, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• num_suspected_minor_injuries (type: esriFieldTypeSmallInteger, alias: Suspected Minor Injuries, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• num_possible_injuries (type: esriFieldTypeSmallInteger, alias: Possible Injuries, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_property_damage_only (type: esriFieldTypeSmallInteger, alias: Property Damage Only, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_secondary_crash (type: esriFieldTypeString, alias: Secondary Crash, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_traffic_control_disregarded (type: esriFieldTypeSmallInteger, alias: Traffic Control, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_red_light_run_involved (type: esriFieldTypeSmallInteger, alias: Red Light Run, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_hit_and_run_involved (type: esriFieldTypeSmallInteger, alias: Hit and Run, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_alcohol_involved (type: esriFieldTypeSmallInteger, alias: Alcohol, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_drug_involved (type: esriFieldTypeSmallInteger, alias: Drugs, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_unbelted_person_involved (type: esriFieldTypeString, alias: Unbelted Person, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_work_zone_involved (type: esriFieldTypeString, alias: Work Zone, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_speeding_driver_involved (type: esriFieldTypeString, alias: Speeding Driver, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_distracted_driver_involved (type: esriFieldTypeString, alias: Distracted Driver, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_driveway_involved (type: esriFieldTypeString, alias: Driveway, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_pedestrian_involved (type: esriFieldTypeSmallInteger, alias: Pedestrian, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_elderly_driver_involved (type: esriFieldTypeSmallInteger, alias: Elderly Driver, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_young_driver_involved (type: esriFieldTypeSmallInteger, alias: Young Driver, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_commercial_vehicle_involved (type: esriFieldTypeString, alias: Commercial Vehicle, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_emergency_vehicle_involved (type: esriFieldTypeString, alias: Emergency Vehicles, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_train_involved (type: esriFieldTypeSmallInteger, alias: Train, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_school_bus_involved (type: esriFieldTypeSmallInteger, alias: School Bus, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_motorcycle_involved (type: esriFieldTypeSmallInteger, alias: Motorcycle, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_bicycle_involved (type: esriFieldTypeSmallInteger, alias: Bicycle, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• is_deer_involved (type: esriFieldTypeSmallInteger, alias: Deer, SQL Type: sqlTypeSmallInt, nullable: true, editable: true)
• longitude (type: esriFieldTypeSingle, alias: Longitude, SQL Type: sqlTypeReal, nullable: true, editable: true)
• latitude (type: esriFieldTypeSingle, alias: Latitude, SQL Type: sqlTypeReal, 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:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/17/2025 3:32:52 PM

Schema Last Edit Date: 2/17/2025 3:32:52 PM

Data Last Edit Date: 1/29/2025 3:35:34 PM

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