About this Dataset

Road Weather Information Stations

This data is derived from sensor stations placed on bridges and surface streets within city limits. Each station has a temperature sensor that measures the temperature of the street surface and a sensor that measures the ambient air temperature at the station each second. Those values are averaged into temperature readings that are recorded by the station every minute. The dataset is updated hourly with new data. Only the most recent 48 hours of data is stored in the dataset.
Organization: City of Seattle
Last updated: 2024-12-16T22:25:47.288586
Tags: road, seattle, street, temperature, transportation, weather

Tables

Table 1

@usgov.city_of_seattle_road_weather_information_stations_d8499.table_1

166.03 kB
16,955 rows
6 columns

CREATE TABLE table_1 (
  "stationname" VARCHAR,
  "stationlocation" VARCHAR,
  "datetime" VARCHAR,
  "recordid" BIGINT,
  "roadsurfacetemperature" DOUBLE,
  "airtemperature" DOUBLE
);