edmonton-ca/driver-feedback-sign-dfs004-swsb-6cri
Icon for Socrata external plugin
 
Readme
Updated 2 days ago
Indexed 2 hours ago

Driver Feedback Sign - DFS004

Driver Feedback Sign DFS004

Latitude: 53.482088

Longitude: -113.412205

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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"edmonton-ca/driver-feedback-sign-dfs004-swsb-6cri\".\"driver_feedback_sign_dfs004\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • driver_feedback_sign_dfs004
     
Upstream Metadata