Skip to main content
All CollectionsAgency Specific ArticlesOhio Department of Transportation
Ohio - Custom Filter Logic
Ohio - Custom Filter Logic

This article summarizes the custom filters created for Ohio and the logic behind them.

Greg Olsen avatar
Written by Greg Olsen
Updated over 10 months ago

Alcohol

The Alcohol filter searches the Crash Table for the following criteria:

WHEN

ODPS_ALCOHO_IND = “Y”

THEN

Alcohol Involved = Yes

Bicycle

The Bicycle filter searches the Crash Table for the following criteria:

WHEN

ODPS_BICYCLE_IND = “Y”

THEN

Bicycle Involved = Yes

Bicycle

The Commercial Motor Vehicle filter searches the Crash Table for the following criteria:

WHEN

CMV_INVOLVED = “Y”

THEN

Commercial Motor Vehicle Involved = Yes

Driver Distracted

The Driver Distracted filter searches the Crash Table for the following criteria:

WHEN

DISTRACTED_DRIVER_IND = “Y”

THEN

Driver Distracted Involved = Yes

Drugs

The Drugs filter searches the Crash Table for the following criteria:

WHEN

ODPS_DRUGS_IND = “Y”

THEN

Drug Involved = Yes

Freeway

The Freeway filter searches the Crash Table for the following criteria:

WHEN

FREEWAY_IND = “Y”

THEN

Freeway Involved = Yes

Intersection

The Intersection filter searches the Crash Table for the following criteria:

WHEN

ODOT_INTERSECTION_REL_IND = “Y”

THEN

Intersection Involved = Yes

Interstate Highway

The Interstate Highway filter searches the Crash Table for the following criteria:

WHEN

INTERSTATE_IND = “Y”

THEN

Interstate Highway Involved = Yes

Motorcycle

The Motorcycle filter searches the Crash Table for the following criteria:

WHEN

ODPS_MOTORCYCLE_IND = “Y”

THEN

Motorcycle Involved = Yes

ODOT Maintained Involved

The ODOT Maintained Involved filter searches the Crash Table for the following criteria:

WHEN

MAINTENANCE_AUTHORITY_CD = “ODOT Maintained”

THEN

ODOT Maintained Involved = Yes

Pedestrian

The Pedestrian filter searches the Crash Table for the following criteria:

WHEN

ODPS_PEDESTRIAN_IND = “Y”

THEN

Pedestrian Involved = Yes

Roadway Departure

The Roadway Departure filter searches the Crash Table for the following criteria:

WHEN

FHWA_RDWY_DEPARTURE_IND = “Y”

THEN

Roadway Departure Involved = Yes

School Zone

The School Zone filter searches the Crash Table for the following criteria:

WHEN

U1_TRAFFIC_CONTROL_CD = “School Zone”

THEN

School Zone Involved = Yes

Senior Driver (Age 65+)

The Senior Driver (Age 65+) filter searches the Crash Table for the following criteria:

WHEN

ODPS_SENIOR_DRIVER_IND = “Y”

THEN

Senior Driver (65+) Involved = Yes

Speed

The Speed filter searches the Crash Table for the following criteria:

WHEN

ODPS_SPEED_IND = “Y”

THEN

Speed Involved = Yes

Unrestrained

The Unrestrained filter searches the Crash Table for the following criteria:

WHEN

NO_RESTRAINT_USED_IND = “Y”

THEN

Unrestrained Involved = Yes

Work Zone

The Work Zone filter searches the Crash Table for the following criteria:

WHEN

ODPS_WORK_ZONE_IND = “Y”

THEN

Work Zone Involved = Yes

Younger Driver (Age 15-25)

The Younger Driver (Age 15-25) filter searches the Crash Table for the following criteria:

WHEN

ODOT_YOUNG_DRIVER_IND = “Y”

THEN

Bicycle Involved = Yes

Did this answer your question?