About this Dataset

Road Weather Demonstration Data

The Belle Isle data was collected between May 1st, 2014 and September 16th, 2014 on the Belle Isle Park in Michigan. However, within the data file provided as part of this data environment, only data during the World Congress demonstration period from September 5, 2014 to September 11, 2014 is included. Several vehicles equipped with multiple sensors drove around the island collecting 572,030 readings of multiple variables. The uploaded data file lists all those observations and the pertaining details about the sensor equipment, the sensor platform and the status of quality checking performed for each observation.
Organization: Department of Transportation
Last updated: 2020-11-12T12:50:19.640897
Tags: arterial, basic-safety-message-bsm, belle-isle-park, connected-vehicles, environment-sensor-stations, fhwa-road-weather-management-program, integrated-mobile-observation-imo, intelligent-transportation-systems-its, its-joint-program-office-jpo, its-world-congress, michigan, michigan-department-of-transportation-mdot, motorist-advisories-and-warnings, road-weather-demonstration, sensor-data, simulated-road-weather, vehicle-data-translator, weather

Tables

Table 1

@usgov.dot_gov_road_weather_demonstration_data.table_1

5.51 MB
572,030 rows
34 columns

CREATE TABLE table_1 (
  "sourceid" BIGINT,
  "obstypeid" BIGINT,
  "obstypename" VARCHAR,
  "sensorid" BIGINT,
  "sensorindex" BIGINT,
  "platformid" BIGINT,
  "siteid" BIGINT,
  "category" VARCHAR,
  "contribid" BIGINT,
  "contributor" VARCHAR,
  "platformcode" VARCHAR,
  "timestamp" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation" BIGINT,
  "observation" DOUBLE,
  "units" VARCHAR,
  "englishvalue" DOUBLE,
  "englishunits" VARCHAR,
  "confvalue" DOUBLE,
  "flag_1" VARCHAR,
  "flag_2" VARCHAR,
  "flag_3" VARCHAR,
  "flag_4" VARCHAR,
  "flag_5" VARCHAR,
  "flag_6" VARCHAR,
  "flag_7" VARCHAR,
  "flag_8" VARCHAR,
  "flag_9" VARCHAR,
  "flag_10" VARCHAR,
  "flag_11" VARCHAR,
  "flag_12" VARCHAR,
  "flag_13" VARCHAR,
  "location" VARCHAR
);