All Collections
Agency Specific Articles
Ohio 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.

G
Written by Gentry White
Updated over a week 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?