Name: Project_Crashes_2017_24

Display Field: COUNTY_NAME

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: 529706.693500001
YMin: 219196.3654
XMax: 790752.952100001
YMax: 702868.3689
Spatial Reference: 3087 (3087)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[70,124,163,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)
• REPORT_NUMBER (type: esriFieldTypeInteger, alias: HSMV Report Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_YEAR (type: esriFieldTypeInteger, alias: Crash Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRASH_DATE_AND_TIME (type: esriFieldTypeString, alias: Crash Date and Time, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FORM_TYPE (type: esriFieldTypeString, alias: Form Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TOTAL_NUMBER_OF_VEHICLES (type: esriFieldTypeInteger, alias: Total Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_NUMBER_OF_PERSONS (type: esriFieldTypeInteger, alias: Total Persons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_NAME (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CITY_NAME (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RURAL_OR_URBAN (type: esriFieldTypeString, alias: Rural or Urban, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ON_STREET_ROAD_HIGHWAY (type: esriFieldTypeString, alias: Crash Street, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: Latitude (Decimal Degrees), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: Longitude (Decimal Degrees), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FROM_INTERSECTION_OF (type: esriFieldTypeString, alias: Intersecting Street, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROAD_SYSTEM_IDENTIFIER (type: esriFieldTypeString, alias: Road System Identifier, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TYPE_OF_SHOULDER (type: esriFieldTypeString, alias: Type of Shoulder, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TYPE_OF_INTERSECTION (type: esriFieldTypeString, alias: Type of Intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LIGHT_CONDITION (type: esriFieldTypeString, alias: Light Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WEATHER_CONDITION (type: esriFieldTypeString, alias: Weather Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROAD_SURFACE_CONDITION (type: esriFieldTypeString, alias: Road Surface Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SCHOOL_BUS_RELATED_CODE (type: esriFieldTypeString, alias: School Bus Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TYPE_OF_IMPACT (type: esriFieldTypeString, alias: Manner of Collision, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FIRST_HARMFUL_EVENT (type: esriFieldTypeString, alias: First Harmful Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: First Harmful Event Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• INTERCHANGE_FLAG (type: esriFieldTypeString, alias: First Harmful Event within Interchange, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• JUNCTION_FLAG (type: esriFieldTypeString, alias: First Harmful Event in Relation to Junction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROAD_CIRCUMSTANCES_1 (type: esriFieldTypeString, alias: Contributing Road Circumstances 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROAD_CIRCUMSTANCES_2 (type: esriFieldTypeString, alias: Contributing Road Circumstances 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ROAD_CIRCUMSTANCES_3 (type: esriFieldTypeString, alias: Contributing Road Circumstances 3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENVIRONMENT_CIRCUMSTANCES_1 (type: esriFieldTypeString, alias: Contributing Environmental Circumstances 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENVIRONMENT_CIRCUMSTANCES_2 (type: esriFieldTypeString, alias: Contributing Environmental Circumstances 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ENVIRONMENT_CIRCUMSTANCES_3 (type: esriFieldTypeString, alias: Contributing Environmental Circumstances 3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WORK_ZONE_RELATED_FLAG (type: esriFieldTypeString, alias: Work Zone Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CRASH_IN_WORK_ZONE (type: esriFieldTypeString, alias: Crash in Work Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TYPE_OF_WORK_ZONE (type: esriFieldTypeString, alias: Type of Work Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WORKERS_PRESENT (type: esriFieldTypeString, alias: Workers Present, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LAW_ENFORCEMENT_PRESENT (type: esriFieldTypeString, alias: Law Enforcement Present, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_CRASH_TYPE (type: esriFieldTypeString, alias: Crash Type - Detailed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_CRASH_TYPE_SIMPLIFIED (type: esriFieldTypeString, alias: Crash Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_CRASH_SEVERITY (type: esriFieldTypeString, alias: Crash Severity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_DAY_OR_NIGHT (type: esriFieldTypeString, alias: Day or Night, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_AGGRESSIVE_DRIVING (type: esriFieldTypeString, alias: Aggressive Driving Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_ALCOHOL_RELATED (type: esriFieldTypeString, alias: Alcohol Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_CMV_INVOLVED (type: esriFieldTypeString, alias: Commercial Motor Vehicle Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_DISTRACTED (type: esriFieldTypeString, alias: Distraction Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_DRUG_RELATED (type: esriFieldTypeString, alias: Drug Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_HIT_AND_RUN (type: esriFieldTypeString, alias: Hit and Run Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_INTERSECTION_RELATED (type: esriFieldTypeString, alias: Intersection Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_LANE_DEPARTURE_RELATED (type: esriFieldTypeString, alias: Lane Departure Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_SPEEDING_RELATED (type: esriFieldTypeString, alias: Speeding Related, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_INJURY_COUNT (type: esriFieldTypeInteger, alias: Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_POSSIBLE_INJURY_COUNT (type: esriFieldTypeInteger, alias: Possible Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_NON_INCAPACITATING_INJURY (type: esriFieldTypeInteger, alias: Non-Incapacitating Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_INCAPACITATING_INJURY_CNT (type: esriFieldTypeInteger, alias: Incapacitating Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_FATALITY_COUNT (type: esriFieldTypeInteger, alias: Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_FATALITY_WITHIN_30_DAYS_CT (type: esriFieldTypeInteger, alias: Fatalities within 30 Days, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_NON_TRAFFIC_FATALITY_COUNT (type: esriFieldTypeInteger, alias: Non-Traffic Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_MOTORCYCLE_COUNT (type: esriFieldTypeInteger, alias: Motorcycles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_MOPED_COUNT (type: esriFieldTypeInteger, alias: Mopeds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_NON_MOTORIST_COUNT (type: esriFieldTypeInteger, alias: Non-Motorists, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_BICYCLIST_COUNT (type: esriFieldTypeInteger, alias: Bicylists, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_PEDESTRIAN_COUNT (type: esriFieldTypeInteger, alias: Pedestrians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_DRIVER_COUNT (type: esriFieldTypeInteger, alias: Drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_AGING_DRIVER_COUNT (type: esriFieldTypeInteger, alias: Aging Drivers (65+), SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_TEENAGER_DRIVER_COUNT (type: esriFieldTypeInteger, alias: Teenage Drivers (15-19), SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_PASSENGER_COUNT (type: esriFieldTypeInteger, alias: Passengers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_UNRESTRAINED_COUNT (type: esriFieldTypeInteger, alias: Unrestrained Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_UNRESTRAINED_INJURY_COUNT (type: esriFieldTypeInteger, alias: Unrestrained Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_UNRESTR_INCAPAC_INJURY (type: esriFieldTypeInteger, alias: Unrestrained Incapacitating Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_UNRESTRAINED_FATALITY_CT (type: esriFieldTypeInteger, alias: Unrestrained Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_IS_PEDESTRIAN_INVOLVED (type: esriFieldTypeString, alias: Pedestrian Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_IS_BICYCLIST_INVOLVED (type: esriFieldTypeString, alias: Bicyclist Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_CITATION_COUNT (type: esriFieldTypeInteger, alias: Citations, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_PROPERTY_DAMAGE_AMOUNT (type: esriFieldTypeInteger, alias: Estimated Property Damage ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_VEHICLE_DAMAGE_AMOUNT (type: esriFieldTypeInteger, alias: Estimated Vehicle Damage ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_TOTAL_DAMAGE_AMOUNT (type: esriFieldTypeInteger, alias: Total Damages ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_TRANSPORT_BY_EMS_COUNT (type: esriFieldTypeInteger, alias: Transported by EMS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_TRANSPORT_BY_LAW_ENFORCEMT (type: esriFieldTypeInteger, alias: Transported by Law Enforcement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_TRANSPORT_BY_OTHER_COUNT (type: esriFieldTypeInteger, alias: Transported by Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• S4_PED_CRASH_GROUP_DESCRIP (type: esriFieldTypeString, alias: Pedestrian Crash Group, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_PED_CRASH_TYPE_DESCRIP (type: esriFieldTypeString, alias: Pedestrian Crash Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_PED_CRASH_LOCATION (type: esriFieldTypeString, alias: Pedestrian Crash Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_PED_MOTORIST_DIRECTION (type: esriFieldTypeString, alias: Pedestrian Motorist Direction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_PED_MOTORIST_MANEUVER (type: esriFieldTypeString, alias: Pedestrian Motorist Maneuver, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_PED_DIRECTION (type: esriFieldTypeString, alias: Pedestrian Travel Direction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_PED_POSTION (type: esriFieldTypeString, alias: Pedestrian Position, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_PED_MOVEMENT (type: esriFieldTypeString, alias: Pedestrian Movement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_PED_TYPING_NOTES (type: esriFieldTypeString, alias: Pedestrian Typing Notes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_BIKE_CRASH_GROUP_DESCRIP (type: esriFieldTypeString, alias: Bicyclist Crash Group, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_BIKE_CRASH_TYPE_DESCRIP (type: esriFieldTypeString, alias: Bicyclist Crash Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_BIKE_CRASH_LOCATION (type: esriFieldTypeString, alias: Bicyclist Crash Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_BICYCLIST_DIRECTION (type: esriFieldTypeString, alias: Bicyclist Direction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_BICYCLIST_POSTION (type: esriFieldTypeString, alias: Bicyclist Position, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• S4_BIKE_TYPING_NOTES (type: esriFieldTypeString, alias: Bicyclist Typing Notes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LRS_MILEPOINT (type: esriFieldTypeDouble, alias: Milepoint, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LRS_ROADWAY (type: esriFieldTypeString, alias: Roadway ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CRASH_LANE (type: esriFieldTypeString, alias: Crash Lane, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: Project_Crashes_2017_24
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/15/2025 8:39:56 PM

Schema Last Edit Date: 12/15/2025 8:39:56 PM

Data Last Edit Date: 12/15/2025 8:39:56 PM

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