Name: Traffic Crashes 2015

Display Field: primary_road

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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: -83.2871987679999
YMin: 42.2571379010001
XMax: -82.910589511
YMax: 42.450246996
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[137,28,81,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"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)
• crash_id (type: esriFieldTypeInteger, alias: Crash ID, SQL Type: sqlTypeOther, 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: esriFieldTypeDateOnly, alias: Crash Date, SQL Type: sqlTypeOther, 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: esriFieldTypeString, alias: Property Damage Only, SQL Type: sqlTypeNVarchar, length: 4000, 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: esriFieldTypeString, alias: Traffic Control, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_red_light_run_involved (type: esriFieldTypeString, alias: Red Light Run, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_hit_and_run_involved (type: esriFieldTypeString, alias: Hit and Run, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_alcohol_involved (type: esriFieldTypeString, alias: Alcohol, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_drug_involved (type: esriFieldTypeString, alias: Drugs, SQL Type: sqlTypeNVarchar, length: 4000, 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: esriFieldTypeString, alias: Pedestrian, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_elderly_driver_involved (type: esriFieldTypeString, alias: Elderly Driver, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_young_driver_involved (type: esriFieldTypeString, alias: Young Driver, SQL Type: sqlTypeNVarchar, length: 4000, 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: esriFieldTypeString, alias: Train, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_school_bus_involved (type: esriFieldTypeString, alias: School Bus, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_motorcycle_involved (type: esriFieldTypeString, alias: Motorcycle, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_bicycle_involved (type: esriFieldTypeString, alias: Bicycle, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• is_deer_involved (type: esriFieldTypeString, alias: Deer, SQL Type: sqlTypeNVarchar, length: 4000, 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)
• geom (type: esriFieldTypeString, alias: geom, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• geog (type: esriFieldTypeString, alias: geog, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: Traffic Crashes 2015
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/6/2025 6:01:14 PM

Schema Last Edit Date: 11/6/2025 6:01:14 PM

Data Last Edit Date: 11/6/2025 5:46:49 PM

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