Skip to main content

GDOT - Custom Filters

This article summarizes the custom filters available in the Georgia Department of Transportation instance.

Lauren Miller avatar
Written by Lauren Miller
Updated over a week ago

Find an explanation of filters available in GDOT summarized here.

% of Vehicles Exceeding Speed Limit ≥ 10 MPH (Clearguide)

The “% of Vehicles Exceeding Speed Limit ≥ 10 MPH (Clearguide)” filter shows the percentage of vehicles traveling 10+ mph over the posted speed limit at locations with 25+ observations. Results display in the following preset ranges:

  • 0–5%

  • 5–15%

  • 15–25%

  • 25–50%

  • 75%+

This filter displays data from the most recent month of available speed data. Speed data will be updated periodically to remain current.

The same information is available as a map layer in Crash Query. To enable it, open Layer Settings in the map toolbar and look under Other for the “% of Vehicles Exceeding Speed Limit ≥ 10 MPH (Clearguide)” layer options.


100 Days of Summer

Filter Logic

IF

Date and Time is during May 24, 2013, and Sept. 3, 2013

OR

Date and Time is during May 23, 2014, and Sept. 2, 2014

OR

Date and Time is during May 22, 2015, and Sept. 8, 2015

OR

Date and Time is during May 27, 2016, and Sept. 6, 2016

OR

Date and Time is during May 26, 2017, and Sept. 5, 2017

OR

Date and Time is during May 25, 2018, and Sept. 4, 2018

OR

Date and Time is during May 24, 2019, and Sept. 3, 2019

OR

Date and Time is during May 22, 2020, and Sept. 8, 2020

OR

Date and Time is during May 28, 2021, and Sept. 7, 2021

Bridge Data work/filters

GDOT bridge data has been joined to the crash data if the crash occurred within the bridge's radius.

Minimum bridge radius: 125 ft

Maximum bridge radius: 1000 ft

Census Filters

The census filters are built from census data and allow users to filter crashes based on various census criteria. The following outlines the logic of each filter.

  • Employment (Census) - This filter displays crashes that occurred in a census tract with the indicated number of occupation categories.

  • Median Household Income (Census) - This filter displays crashes in census tracts with the indicated median household income.

  • Median Household Income Group (Census) - This filter allows users to group median household incomes based on natural breaks, which are classes based on natural groupings inherent in data. The natural breaks for the Median Household Income Group (Census) filter are:

    • 0 - No median household income

    • 1 - $2500 to $14514

    • 2 - $14764 to $37054

    • 3 - $37136 to $53097

    • 4 - $53125 to $68207

    • 5 - $68497 to $84453

    • 6 - $84583 to $103345

    • 7 - $103487 to $127109

    • 8 - $127431 to $157784

    • 9 - $157986 to $195380

    • 10 - $196923 to $249028

  • Population Per Square Mile (Census) - This filter displays crashes that took place in census tracts with the indicated population per square mile.

  • Population Per Square Mile Group (Census) - This filter allows users to group population per square mile census tracts based on natural breaks, which are classes based on natural groupings inherent in data. The natural breaks for the Population Per Square Mile (Census) filter are:

    • 0: No population per square mile reported

    • 1: 1 - 724

    • 2: 725 - 1780

    • 3: 1781 - 3002

    • 4: 3003 - 4619

    • 5: 4620 - 6892

    • 6: 6893 - 10168

    • 7: 10169 - 14907

    • 8: 14908 - 23711

    • 9: 23712 - 51464

    • 10: 51465 - 102633​

Curve Data work/filters

GDOT curve data for State Routes was joined to the crash data. If the crash is within 150 feet of a curve, we assign the curve to the crash.

Distracted Driver (Confirmed)

IF

UnitFactorCode = (Any of the following) Inattentive or other distraction (distracted), texting (distracted), talking on hands-free device (distracted), talking on hand-held device (distracted), other activity - mobile device (distracted), occupant distraction (distracted), other interior distraction (distracted), other exterior distraction (distracted)

Distracted Driver (Suspected)

IF

Person Type (Crash Level) = Driver

AND

Manner of Collision (Crash Level) = (Any of the following) Rear end, head on, not a collision with motor vehicle, sideswipe-opposite direction

AND

First Harmful Event (Unit Order) ≠ (Any of the following) Deer, animal

AND

Surface Condition (Crash Level) ≠ (Any of the following) Ice/frost, slush, snow

AND

Vehicle Contributing Factor ≠ (Any of the following) Tire failure, slick tires, brake failure, steering failure, power train, suspension, truck coupling/trailer hitch/safety chains

AND

Driver Condition (Crash Level) ≠ (Any of the following) U.I. alcohol, U.I. alcohol & drugs, U.I. drugs, suspected U.I. (alcohol and/or drugs) suspected fatigued or asleep

AND

Alcohol Test Status (Crash Level) ≠ (Any of the following) Yes, refused

AND

Drug Test Status (Crash Level) ≠ (Any of the following) Yes, refused

AND

Operator Pedestrian Contributing Factors ≠ (Any of the following) Exceeding speed limit, too fast for conditions, reckless driving, improper passing, improper passing of school bus, disregard other traffic control, misjudged clearance, aggressive driving, racing, disregard police - evasion, failure to yield, disregard stop sign/signal, improper turn, not visible (object, person, or vehicle), vision obscured, under the influence (u.i.), driver condition

AND

Distracted Driver Related (Confirmed) = False

Distracted Drive

Distracted Driver (Suspected or Confirmed)

IF

Distracted Driver Related (Confirmed) = True

OR

Distracted Driver (Suspected) = True

Holiday Periods

Find more information about the Holiday Periods filter here: https://support.numetric.com/en/articles/6716452-gdot-holiday-period-filter

Incorporated in City

Filter Logic

IF

City (Geo) = Not Blank

Intersection ID (Signal ID)

Filter Logic

IF

Intersection ID = Not Blank

AND

Signal ID Empty = False

Intersection Ownership

Filter Logic

State Routes

IF

Intersection Related = True

AND

Roadway Ownership/Maintenance Agency = (Any of the following) State, State Ramp, State CD, State Mainline

County Road

IF

Intersection Related = True

AND

Roadway Ownership/Maintenance Agency = (Any of the following) County, County Ramp, County Road

AND

Roadway Ownership/Maintenance Agency ≠ (Any of the following) State, State Ramp, State CD, State Mainline

City Streets

IF

Intersection Related = True

AND

Roadway Ownership/Maintenance Agency = (Any of the following) City Street, City

AND

Roadway Ownership/Maintenance Agency ≠ (Any of the following) State, State Ramp, State CD, State Mainline

Inventory Route Number Filter

This filter combines the route number and route suffix to create the inventory route number, enabling users to filter crashes along a single corridor.

Land Cover Filter

The Land Cover filter lets users filter and view land cover classification information for specific roadways and crashes. This data allows users to apply context classifications to their analysis. For example, instead of simply querying “rural” area crashes, users can now search for Rural Built Area crashes.

The Land Cover filter is based on 2023 ESRI Land Cover data, which classifies the developed status of land. The ESRI data used to create this filter categorizes land classifications in 10-meter sections. The classifications available for each section are:

  • Built area

  • Trees

  • Rangeland

  • Crops

  • Water

  • Flooded vegetation

  • Bare ground

More information about these ESRI class definitions and land cover data can be found here. The land cover classification for the midpoint of a segment applies to the entire segment.

(Disclaimer: The roads displayed in the graphic above are used as examples and may not represent the actual Land Cover filter values. )

Note: Divided roadways may have different land cover results. For example, a northbound segment could have a different land classification than the opposing southbound segment.

(Disclaimer: The roads displayed in the graphic above are used as examples and may not represent the actual Land Cover filter values.)

Narrative

Users can view the crash narrative in the crash flyout and use keywords to filter the narrative.

Roadway Departure

Filter Logic

IF

First Harmful Event (Unit Order) = (Any of the following) Impact Attenuate, Bridge/Pier Abutment, Bridge/Parapet End, Bridge Rail, Guard Rail Face, Guard Rail End, Median Barrier, Highway Traffic Sign Post, Overhead Sign Support, Utility Pole, Other Post/ Pole Support, Curb, Ditch, Embankment, Fence, Mail Box, Tree, Other - Fixed Object, Work Zone/Maintenance Equipment, Cable Barrier, Other/Unknown, Culvert, Luminarie Light Support

OR

LocationAtImpactCode = (Any of the following) On shoulder, Off roadway, Median, Off Roadway - Sidewalk

Safe Routes to Schools (SRTS)

High School Name (within 2 miles)

High School Name (within 1 mile)

High School Name (within ½ mile)

High School Name (within ¼ mile)

Middle School Name (within 2 miles)

Middle School Name (within 1 mile)

Middle School Name (within ½ mile)

Middle School Name (within ¼ mile)

Elementary School Name (within 2 miles)

Elementary School Name (within 1 mile)

Elementary School Name (within ½ mile)

Elementary School Name (within ¼ mile)

School Level (within 2 miles)

School Level (within 1 mile)

School Level (within ½ mile)

School Level (within ¼ mile)

School District (within 2 miles)

School District (within 1 mile)

School District (within ½ mile)

School District (within ¼ mile)

School Name (within 2 miles)

School Name (within 1 mile)

School Name (within ½ mile)

School Name (within ¼ mile)

SHSP Emphasis Areas

The following fields are included in the SHSP Emphasis Area filter:

Intersection Related

Distracted Driver (Suspected)

Young Adult Driver (Age 20-24)

Older Driver Related (55-64)

Older Driver Related (65+)

Roadway Departure

Young Driver (Age 15-19)

Hit & Run

Aggressive/Speed Related

Distracted Driver (Confirmed)

Large Truck Related

Improper Occupant Protection

Secondary Crash

Impaired Driving (Confirmed)

Motorcycle Related

Pedestrian Related

Bicycle Related

Impaired Driving (Suspected)

Social Vulnerability Index (SVI)

Total Crash Cost

Formula

(A) Crash Cost + (B) Crash Cost + (C) Crash Cost + (O) Crash Cost + (K) Crash Cost

Did this answer your question?