Datasources:
Sunguide Events - data is parsed from Sunguide event feed
Date Ranges:
Data is available from 2011 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:
Event data is received~ every 15 seconds, processed and stored in 15 minute interval bins and update performance measures hourly.
Collection Method:
Sunguide event feed XML 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
Sunguide Events
Performance Measures Include:
Measure Name | Measure Detail | Calculation | Map Description | Reporting Period | Data Source |
Total Incidents | Total incidents per date range | SUM of all Performance Measure Events per date range. Events with any travel lane blockage of event type = Crash, Debris on Roadway, Disabled Vehicle, Emergency Vehicles, Flooding, Other, Pedestrian, Police Activity, Vehicle Fire Segment = HERE Roadway Network in miles Facility Type = FDOT RCI Functional classes Date Range = Hourly, Daily, Monthly, Quarterly, Yearly, 3 Year, 5 Year | 1. Display Point for incident location 2. Hover on tool tip to show Incident Details | Hour (if available) Day (if available) Month (if available) Quarter (if available) Year (if available) 3 Year (if available) 5 Year (if available) | SunGuide (Option: Waze) |
Total Incidents Date Range | Total incidents trend of selected date range to previous year | SUM of all Performance Measure Events per date range. Events with any travel lane blockage of event type = Crash, Debris on Roadway, Disabled Vehicle, Emergency Vehicles, Flooding, Other, Pedestrian, Police Activity, Vehicle Fire Segment = HERE Roadway Network in miles Facility Type = FDOT RCI Functional classes Date Range = Hourly, Daily, Monthly, Quarterly, Yearly, 3 Year, 5 Year | 1. Display Point for incident location 2. Hover on tool tip to show Incident Details | Hour (if available) Day (if available) Month (if available) Quarter (if available) Year (if available) 3 Year (if available) 5 Year (if available) | SunGuide (Option: Waze) |
Roadway Clearance Time | Average time in minutes to clear the roadway after an event per date range | Average number of minutes between (FDOT or FHP Notified time) and (Travel Lanes Cleared Time) Def. FDOT/FHP notified time = first knowledge time, earliest of either the Event Record Creation or the Notification time of al agencies. Segment = HERE Roadway Network in miles Facility Type = FDOT RCI Functional classes Date Range = Hourly, Daily, Monthly, Quarterly, Yearly, 3 Year, 5 Year | 1. Display Point for incident location 2. Hover on tool tip to show Incident Details | Hour (if available) Day (if available) Month (if available) Quarter (if available) Year (if available) 3 Year (if available) 5 Year (if available) | SunGuide |
Roadway Clearance Duration | Measures all incidents by the percentage of roadway clearance time range | average number of minutes between (FDOT or FHP Notified time) and (Travel Lanes Cleared Time) Def. FDOT/FHP notified time = first knowledge time, earliest of either the Event Record Creation or the Notification time of al agencies. Per time clearance time categories of 30-60mins, less than 30min, 60 - 90min or greater than 90mins Segment = HERE Roadway Network in miles Facility Type = FDOT RCI Functional classes Date Range = Hourly, Daily, Monthly, Quarterly, Yearly, 3 Year, 5 Year | 1. Display Point for incident location 2. Hover on tool tip to show Incident Details | Hour (if available) Day (if available) Month (if available) Quarter (if available) Year (if available) 3 Year (if available) 5 Year (if available) | SunGuide |
Secondary Crash | Total number of secondary crashes of selected date range | SUM of all Secondary Crashes per date range. E Segment = HERE Roadway Network in miles Facility Type = FDOT RCI Functional classes Date Range = Hourly, Daily, Monthly, Quarterly, Yearly, 3 Year, 5 Year | 1. Display Point for crash location 2. Hover on tooltip 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) | SunGuide |
Top Incident Types | The total comparison of the top incident types | SUM of all Performance Measure Events per date range. Events with any travel lane blockage of event type = Crash, Debris on Roadway, Disabled Vehicle, Emergency Vehicles, Flooding, Other, Pedestrian, Police Activity, Vehicle Fire Segment = HERE Roadway Network in miles Facility Type = FDOT RCI Functional classes Date Range = Hourly, Daily, Monthly, Quarterly, Yearly, 3 Year, 5 Year | 1. Display Point for incident location 2. Hover on tool tip to show Incident Details | Hour (if available) Day (if available) Month (if available) Quarter (if available) Year (if available) 3 Year (if available) 5 Year (if available) | SunGuide (Option: Waze) |