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)

Did this answer your question?