edmonton-ca/driver-feedback-sign-dfs008-x4xj-xv4q
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 14 minutes ago
Indexed 11 minutes ago

Driver Feedback Sign - DFS008

Driver Feedback Sign DFS008

Latitude: 53.487703

Longitude: -113.673541

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-dfs008-x4xj-xv4q\".\"driver_feedback_sign_dfs008\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • driver_feedback_sign_dfs008
     
     
     
     
     
Upstream Metadata