Permanent Count Station Traffic Counts

This dataset comprises directional traffic counts collected at the City of Winnipeg’s permanent count stations. Each station utilizes a dual side-fire microwave radar sensor, which is installed adjacent to the roadway and faces perpendicular to the directions of travel.

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 \"winnipeg-ca/permanent-count-station-traffic-counts-46sc-6jrs\".\"permanent_count_station_traffic_counts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.