Name: AWOS Data
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

AWOS Data

Live Automated Weather Observing System (AWOS) data pulled from NOAA METAR GeoJSON Feed for Iowa AWOS sites.
Organization: State of Iowa
Last updated: 2024-04-12T12:46:10.056034
Tags: airport, aviation, awos, faa, operations, weather

Tables

Table 1

@usgov.state_of_iowa_awos_data_data.table_1

50.26 kB
130 rows
42 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "awos_id" VARCHAR,
  "faa_code" VARCHAR,
  "airport_name" VARCHAR,
  "associated_city" VARCHAR,
  "status" BIGINT,
  "county_number" DOUBLE,
  "county_name" VARCHAR,
  "awos_data_last_pulled_utc" VARCHAR  -- AWOS Data Last Pulled (UTC),
  "dew_point_f" DOUBLE  -- Dew Point (F),
  "pressure_in_hg" DOUBLE  -- Pressure (IN Hg),
  "precipitation" VARCHAR,
  "wind_direction" VARCHAR,
  "wind_direction_deg" BIGINT,
  "wind_speed_mph" DOUBLE  -- Wind Speed (MPH),
  "wind_speed_knots" BIGINT  -- Wind Speed (Knots),
  "wind_gust_mph" DOUBLE  -- Wind Gust (MPH),
  "wind_gust_knots" BIGINT  -- Wind Gust (Knots),
  "first_cloud_layer_type" VARCHAR,
  "first_cloud_layer_ft" BIGINT  -- First Cloud Layer (FT),
  "second_cloud_layer_type" VARCHAR,
  "second_cloud_layer_ft" BIGINT  -- Second Cloud Layer (FT),
  "third_cloud_layer_type" VARCHAR,
  "third_cloud_layer_ft" BIGINT  -- Third Cloud Layer (FT),
  "latitude_ll84" DOUBLE  -- Latitude (LL84),
  "longitude_ll84" DOUBLE  -- Longitude (LL84),
  "state" VARCHAR,
  "raw_metar_observation" VARCHAR,
  "flight_category" VARCHAR,
  "ceiling_ft_agl" BIGINT  -- Ceiling (Ft AGL),
  "pressure_at_sea_level_in_hg" BIGINT  -- Pressure At Sea Level (IN Hg),
  "utc_offset" VARCHAR,
  "visibility_miles" BIGINT  -- Visibility (Miles),
  "average_windspeed_knots" BIGINT  -- Average Windspeed (Knots),
  "max_windspeed_knots" BIGINT  -- Max Windspeed (Knots),
  "data_last_pulled_from_awos_sensor_utc" VARCHAR  -- Data Last Pulled From AWOS Sensor (UTC),
  "precipitation_2" VARCHAR,
  "max_windspeed_mph" DOUBLE  -- Max Windspeed (MPH),
  "average_windspeed_mph" DOUBLE  -- Average Windspeed (MPH),
  "air_temperature_f" DOUBLE  -- Air Temperature (F),
  "rest_service_data_last_update_utc" VARCHAR  -- REST Service Data Last Update (UTC)
);