Real-Time Road Conditions
Austin Transportation & Public Works maintains road condition sensors across the city which monitor the temperature and surface condition of roadways. These sensors enable our Mobility Management Center to stay apprised of potential roadway freezing events and intervene when necessary.
This data is updated continuously every 5 minutes.
See also, the data descriptions from the sensor's instruction manual:
https://github.com/cityofaustin/atd-road-conditions/blob/production/5433-3X-manual.pdf
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 \"datahub-austintexas-gov/realtime-road-conditions-ypbq-i42h\".\"realtime_road_conditions\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
