Real-Time Road Conditions by US Government | Transportation and Logistics

About this Dataset

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
Organization: City of Austin
Last updated: 2021-08-07T11:59:54.018323

Tables

Table 1

@usgov.city_of_austin_real_time_road_conditions.table_1

155.32 MB
5351023 rows
24 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "sensor_id" BIGINT,
  "location_name" VARCHAR,
  "location" VARCHAR,
  "timestamp" VARCHAR,
  "voltage_y" BIGINT,
  "voltage_x" BIGINT,
  "voltage_ratio" DOUBLE,
  "air_temp_secondary" DOUBLE,
  "temp_surface" DOUBLE,
  "condition_code_displayed" BIGINT,
  "condition_code_measured" BIGINT,
  "condition_text_displayed" VARCHAR,
  "condition_text_measured" VARCHAR,
  "friction_code_displayed" BIGINT,
  "friction_code_measured" BIGINT,
  "friction_value_displayed" DOUBLE,
  "friction_value_measured" DOUBLE,
  "dirty_lens_score" BIGINT,
  "grip_text" VARCHAR,
  "relative_humidity" DOUBLE,
  "air_temp_primary" DOUBLE,
  "air_temp_tertiary" DOUBLE,
  "status_code" BIGINT
);