edmonton-ca/driver-feedback-sign-dfs006-tbqn-es5s
Icon for Socrata external plugin
 
Readme
Updated 6 days ago
Indexed 4 hours ago

Driver Feedback Sign - DFS006

Driver Feedback Sign DFS006

Latitude: 53.492769

Longitude: -113.682597

The City has a number of Driver Feedback Signs (DFS) installed around the city. These units collect data as traffic approaches them and in some cases may display a message or a speed that is being detected. Also, these units are radar based and can only track one vehicle at a time (strongest signal).

Due to the number of DFS installations combined with the volume of data collected, each DFS has its own dataset.

Details of how the data is collected by the DFS are as follows:

  • Data is accumulated and reported in 15 minute intervals

  • Vehicle speeds are captured/reported in speed intervals (bins)

  • Speed range/interval for the bins are determined by parameters/settings set for the DFS (Minimum/Maximum Speed Detection Setting)

  • Two speed values are recorded for every vehicle - a Highest Speed Detected and a Slowest Speed Detected (explaining why there are two vehicle counts)

  • The bins go from Bin 1 to Bin 10. Bin 1 can also be referred to a LO BIN and Bin 10 can also be referred to as HIGH BIN.

Things to note:

DFS devices are not to be used as or confused with traffic counters, as they are not.

DFS devices have a minimum detectable speed of approximately 6 km/hr.

DFS devices have a maximum (theoretical) detectable speed of approximately 225 km/hr.

DFS devices are programmable with different parameters that can also follow a timed schedule.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Vehicle Count at Slowest Speed Detectedvehicle_count_at_slowest_speed_detectedvehicle_count_at_slowest_speed_detectedNumberThe number of vehicles counted in the 15 minute time interval where the detected slowest speed of the vehicle was equal to or greater than the Minimum Speed for the Bin and is less than or equal to the Maximum Speed for the Bin.
Speed Range for Binspeed_range_for_binspeed_range_for_binNumberA calculated value based on (Maximum Speed Detection Setting and Minimum Speed Detection Setting). NOTE: - For Bin 1, the minimum detectable speed is approximately 6 KPH. - For Bin 10, the maximum detectable speed is approximately 225 KPH.
Log Timestamplog_timestamplog_timestampCalendar dateThe Timestamp of when the data was recorded. The time interval between recordings is 15 minutes. Note: It is possible to not have a specific recording of data at a specific Timestamp. This can occur for a number of reasons; however, the data values are still for the 15 minute interval.
Vehicle Count at Highest Speed Detectedvehicle_count_at_highest_speed_detectedvehicle_count_at_highest_speed_detectedNumberThe number of vehicles counted in the 15 minute time interval where the detected fastest speed of the vehicle was equal to or greater than the Minimum Speed for the Bin and is less than or equal to the Maximum Speed for the Bin.
Vehicle Count for Log Intervalvehicle_count_for_log_intervalvehicle_count_for_log_intervalNumberThe number of vehicles that were successfully detected and recorded within the specified parameters. This Vehicle Count is not and should not be correlated to a traffic volume count within the 15 minute interval.
Row IDrow_idrow_idTextSystem generated ID to eliminate the possibility of duplicate data.
Minimum Speed Detection Settingminimum_speed_detection_settingminimum_speed_detection_settingNumberThe lowest speed setting for the DFS Unit used to determine the speed ranges for each Bin.
Location Descriptionlocation_descriptionlocation_descriptionTextA brief / abbreviated description of the location where the DFS unit is located.
Speed Unit of Measurespeed_unit_of_measurespeed_unit_of_measureTextThe Speed Unit of Measure. Note: The usual setting is KPH but could also be MPH.
Bin Over Speed Limit Flagbin_over_speed_limit_flagbin_over_speed_limit_flagNumberA flag value that indicates the following: 0 - if the both the Minimum Speed and Maximum Speed for the Bin are below the Speed Limit 1 - if the Speed Limit is between the Minimum Speed and Maximum Speed for the Bin 2 - if the value of both the Minimum Speed and Maximum Speed for the Bin are greater than the Speed Limit
Maximum Speed for Bin Numbermaximum_speed_for_bin_numbermaximum_speed_for_bin_numberNumberThe fastest detected speed travelled that corresponds to the Bin Number. Vehicles can travel less than or equal to this speed for it to be recorded for the Bin. NOTE: For Bin 10, the maximum detectable speed is approximately 225 KPH.
Minimum Speed for Bin Numberminimum_speed_for_bin_numberminimum_speed_for_bin_numberNumberThe slowest detected speed travelled that corresponds to the Bin Number. Vehicles can travel equal to or faster than this speed for it to be recorded for the Bin. NOTE: For Bin 1, the minimum detectable speed is approximately 6 KPH.
Speed Limitspeed_limitspeed_limitNumberThe Speed Limit setting for the DFS unit. Note: This may not be the enforceable speed for the roadway.
Maximum Speed Detection Settingmaximum_speed_detection_settingmaximum_speed_detection_settingNumberThe fastest speed setting for the DFS Unit used to determine the speed ranges for each Bin.
Bin Numberbin_numberbin_numberNumberA value between 1 and 10, representing the data bin for which the vehicle count and the speed range is applicable. Bin 1 records the number of vehicles that were detected to travel in the slowest speed range and Bin 10 would be for the fastest speed range.
DirectiondirectiondirectionTextThe direction of travel of vehicles that are being detected by the DFS unit.
Site IDsite_idsite_idTextA unique ID assigned to the location for proper/accurate identification.
 
Preview
  • driver_feedback_sign_dfs006
     
Upstream Metadata