Traffic Counts
The Average Weekday Traffic Volume is a count of the number of vehicle axle pairs (a car has 2 axles) passing through a given location on an average weekday. This is the traffic volume over a one-day weekday period and is a summary of the data that is collected in 15-minute intervals. The 15-minute interval traffic volumes for a particular location are available through Mesa’s Interactive Traffic Count Map application at https://gis.mesaaz.gov/TrafficCounts
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 \"citydata-mesaaz-gov/traffic-counts-4pai-2bwn\".\"traffic_counts\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
