Layer: Crashes (ID:0)

View In: Map Viewer

Name: Crashes

Display Field: STREET1

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:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,75,94,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:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
ACCIDENTS_POINTS_NBR (type: esriFieldTypeDouble, alias: Accidents Points Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
LOGPOINT_SLM_NBR (type: esriFieldTypeDouble, alias: Logpoint SLM Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRASH_DT (type: esriFieldTypeDouble, alias: Crash Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREET1 (type: esriFieldTypeString, alias: Street 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DISTANCE_OFFSET (type: esriFieldTypeString, alias: Distance Offset, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STREET2_REFERENCE (type: esriFieldTypeString, alias: Street 2 Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DAY_OF_WEEK_TXT (type: esriFieldTypeString, alias: Day of Week (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HOUR_OF_DAY (type: esriFieldTypeDouble, alias: Hour of Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
LIGHT_CONDITION_TXT (type: esriFieldTypeString, alias: Light Condition (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TYPE_OF_CRASH_TXT (type: esriFieldTypeString, alias: Type of Crash (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
NUMBER_OF_VEHICLES (type: esriFieldTypeString, alias: Number of Vehicles, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CRASH_SEVERITY_TXT (type: esriFieldTypeString, alias: Crash Severity (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
WEATHER_CONDITION_TXT (type: esriFieldTypeString, alias: Weather Condition (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ROAD_CONDITION_TXT (type: esriFieldTypeString, alias: Road Condition (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LOCATION_TXT (type: esriFieldTypeString, alias: Location (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CONTRIBUTING_FACTOR1_TXT (type: esriFieldTypeString, alias: Unit 1: Contributing Factor (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ACTION1_TXT (type: esriFieldTypeString, alias: Unit 1: Pre-Crash Action (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VEHICLE_TYPE1_TXT (type: esriFieldTypeString, alias: Unit 1: Vehicle Type (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DIRECTION_FROM1_TXT (type: esriFieldTypeString, alias: Unit 1: Direction From (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DIRECTION_TO1_TXT (type: esriFieldTypeString, alias: Unit 1: Direction To (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DRIVER_AGE1 (type: esriFieldTypeString, alias: Unit 1: Driver Age, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DRIVER_GENDER1_TXT (type: esriFieldTypeString, alias: Unit 1: Driver Gender (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TRAFFIC_CONTROL1_TXT (type: esriFieldTypeString, alias: Unit 1: Traffic Control (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DRIVER_ALCOHOL1_TXT (type: esriFieldTypeString, alias: Unit 1: Driver Alcohol Suspected (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DRIVER_DRUGS1_TXT (type: esriFieldTypeString, alias: Unit 1: Driver Drugs Suspected (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ESTIMATED_SPEED1_TXT (type: esriFieldTypeString, alias: Unit 1: Estimated Speed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
POSTED_SPEED1_TXT (type: esriFieldTypeString, alias: Unit 1: Posted Speed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CONTRIBUTING_FACTOR2_TXT (type: esriFieldTypeString, alias: Unit 2: Contributing Factor (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ACTION2_TXT (type: esriFieldTypeString, alias: Unit 2: Pre-Crash Action (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VEHICLE_TYPE2_TXT (type: esriFieldTypeString, alias: Unit 2: Vehicle Type (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DRIVER_AGE2 (type: esriFieldTypeString, alias: Unit 2: Driver Age, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DRIVER_GENDER2_TXT (type: esriFieldTypeString, alias: Unit 2: Driver Gender (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DIRECTION_FROM2_TXT (type: esriFieldTypeString, alias: Unit 2: Direction From (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DIRECTION_TO2_TXT (type: esriFieldTypeString, alias: Unit 2: Direction To (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DRIVER_ALCOHOL2_TXT (type: esriFieldTypeString, alias: Unit 2: Driver Alcohol Suspected (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DRIVER_DRUGS2_TXT (type: esriFieldTypeString, alias: Unit 2: Driver Drugs Suspected (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SPECIAL_AREA_TXT (type: esriFieldTypeString, alias: Special Area (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ANIMAL_TYPE_TXT (type: esriFieldTypeString, alias: Animal Type (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ROAD_CONTOUR_TXT (type: esriFieldTypeString, alias: Road Contour (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
INJ_TYPE1_FATAL (type: esriFieldTypeDouble, alias: Injury Type 1: Fatal, SQL Type: sqlTypeOther, nullable: true, editable: true)
INJ_TYPE2_SERIOUS_VISIBLE (type: esriFieldTypeDouble, alias: Injury Type 2: Serious Visible, SQL Type: sqlTypeOther, nullable: true, editable: true)
INJ_TYPE3_MINOR_VISIBLE (type: esriFieldTypeDouble, alias: Injury Type 3: Minor Visible, SQL Type: sqlTypeOther, nullable: true, editable: true)
INJ_TYPE4_NO_VISIBLE (type: esriFieldTypeDouble, alias: Injury Type 4: No Visible, SQL Type: sqlTypeOther, nullable: true, editable: true)
DIRECTION_FROM_REF_TXT (type: esriFieldTypeString, alias: Direction From Reference (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DISTRICT_NBR (type: esriFieldTypeDouble, alias: District Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNTY_CD (type: esriFieldTypeString, alias: County Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
City_Village_Twp_Cd (type: esriFieldTypeDouble, alias: City/Village/Township Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
City_Village_Twp_Nme (type: esriFieldTypeString, alias: City/Village/Township Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
TRAFFIC_CRASH_YEAR (type: esriFieldTypeDouble, alias: Crash Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRASH_MONTH_NBR (type: esriFieldTypeDouble, alias: Crash Month (Number), SQL Type: sqlTypeOther, nullable: true, editable: true)
ODOT_INTERSECTION_REL_IND (type: esriFieldTypeString, alias: ODOT Intersection Related Indicated, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CO (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
MCD (type: esriFieldTypeString, alias: Political Unit, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
INT_ID (type: esriFieldTypeString, alias: Intersection ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SEG_ID (type: esriFieldTypeString, alias: Segment ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TYPE (type: esriFieldTypeString, alias: Intersection / Segment, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
SEV_PDO (type: esriFieldTypeSmallInteger, alias: Crash Severity: Property Damage Only, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEV_INJ (type: esriFieldTypeSmallInteger, alias: Crash Severity: Injury, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEV_SI (type: esriFieldTypeSmallInteger, alias: Crash Severity: Serious Injury, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEV_FAT (type: esriFieldTypeSmallInteger, alias: Crash Severity: Fatal, SQL Type: sqlTypeOther, nullable: true, editable: true)
BIKE (type: esriFieldTypeSmallInteger, alias: Bicycle Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
PED (type: esriFieldTypeSmallInteger, alias: Pedestrian Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
ANIMAL (type: esriFieldTypeSmallInteger, alias: Animal Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
WORK_ZONE (type: esriFieldTypeSmallInteger, alias: Work Zone Related, SQL Type: sqlTypeOther, nullable: true, editable: true)
Wrong (type: esriFieldTypeString, alias: Checked?, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
created_user (type: esriFieldTypeString, alias: Created By:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: Date Created:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: Last Edited By:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: Date Last Edited:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/15/2025 3:09:05 PM

Schema Last Edit Date: 7/15/2025 3:09:05 PM

Data Last Edit Date: 7/15/2025 2:30:12 PM

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