Datasources:

FDOT CARS - data is parsed from CARS CSV

Date Ranges:

Data is available from 2016 through 2022
Data is stored in Hourly, Daily, Month, Quarterly. Yearly, 3 Year and 5 Year aggregate tables based on performance measure requirements.

Data Refresh Interval:

CARS data is received manually, quarterly

Collection Method:

CSV files parsed to and stored as PostGreSQL, JSON and CSV

Methodology:

Urban SDK provides Data ETL across multiple data sources to aggregate and calculate FDOT specific performance measures including:

FDOT RCI
HERE Road Network Segments FDOT AADT 2020
FDOT SOURCEBOOK VMT 2019

Performance Measures Include:

Measure Name

Measure Detail

Calculation

Map Description

Reporting Period

Data Source

Total Crashes

Total Crashes per Date Range

SUM of all mapped/processed & unmapped/unprocessed crashes; based on the filters selected.

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS (Options: Signal 4, Sunguide)

Total Fatalities

Total fatal crashes per date range

The COUNT of all reported crashes with an injury severity equal to Fatality (5) or Fatality within 30 days (6), per user selected filter criteria.

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS, FARS

Total Serious Injuries

Total serious injury crashes per date range

The SUM of all crashes with an Injury severity equal to Incapacitating Injury (4) per user selected filter criteria.

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS

Total Bike Crashes

Total Bike Crashes per Date Range

SUM of all mapped/processed & unmapped/unprocessed bike crashes; based on the filters selected.

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS (Options: Signal 4, Sunguide)

Total Pedestrian Crashes

Total Pedestrian per Date Range

SUM of all mapped/processed & unmapped/unprocessed pedestrian crashes; based on the filters selected.

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS (Options: Signal 4, Sunguide)

Intersection Crashes

Total number of crashes related to Intersections per date range

The COUNT of all crashes where the following is true ((CRSH.WRK_ZONE_REL_CD = '02') OR (CRSH.FRST_RD_COND_CD = '04') OR (CRSH.SCND_RD_COND_CD = '04') OR (CRSH. THRD_RD_COND_CD = '04'))

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS (Options: Signal 4, Sunguide)

Crash Severity

Total crashes by Crash Severity per date range

The total COUNT of all crashes per user selected filters separated out by the total COUNT of crashes by each injury severity type, shown on the x- axis. Fatal Crashes = crashes with an injury severity equal to fatalities (5) or fatal within 30days (6), Serious Injury Crashes = crashes with an injury severity equal to incapacitating injury (4),

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS (Options: Signal 4, Sunguide)

Crash Rate (VMT)

The road segment crash rate per route per date range

Section= 1,000,000 x CRASH / AADT x Length x 365 x yrs
Intersection = 1,000,000 x CRASH / AADT x 365 x yrs

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS (Options: Signal 4, Sunguide)

Crash Rate (Miles)

The road segment crash rate per route length in miles per date range

Section= 1,000,000 x CRASH / AADT x Length x 365 x yrs
Intersection = 1,000,000 x CRASH / AADT x 365 x yrs

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS (Options: Signal 4, Sunguide)

Work Zone Crashes

Total number of crashes related to work zones per date range

The COUNT of all crashes where the following is true ((CRSH.WRK_ZONE_REL_CD = '02') OR (CRSH.FRST_RD_COND_CD = '04') OR (CRSH.SCND_RD_COND_CD = '04') OR (CRSH. THRD_RD_COND_CD = '04'))

1. Display Point for crash location

2. Hover on tool tip to show crash details

Hour (if available) Day (if available) Month (if available) Quarter (if available)

Year (if available) 3 Year (if available)
5 Year (if available)

CARS (Options: Signal 4, Sunguide)

Did this answer your question?