
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) | 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) | 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) | 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) | 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) | 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) | 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) | 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 | 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) | 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 | 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) | 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) | CARS (Options: Signal 4, Sunguide) |