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

About this Dataset

Airports

Airport locations and information in Iowa including contact information, location details and more.
Organization: State of Iowa
Last updated: 2024-04-12T12:53:18.566476
Tags: airports

Tables

Table 1

@usgov.state_of_iowa_airports_data.table_1

45.37 kB
111 rows
31 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "airport_acreage" BIGINT,
  "airport_name" VARCHAR,
  "street_address" VARCHAR,
  "airport_use" VARCHAR,
  "zip_code" BIGINT,
  "associated_city" VARCHAR,
  "direction_cbd" VARCHAR,
  "distance_cdb" BIGINT,
  "elevation" BIGINT,
  "elevation_code" VARCHAR,
  "faa_code" VARCHAR,
  "far_139" VARCHAR,
  "inspection_code" VARCHAR,
  "inspedtion_date" VARCHAR,
  "maintenance_first_name" VARCHAR,
  "maintenance_last_name" VARCHAR,
  "maintenance_phone" VARCHAR,
  "sponsor_population" BIGINT,
  "ownership_type" VARCHAR,
  "weather_type" VARCHAR,
  "weather_phone" VARCHAR,
  "attendant_onduty_day" VARCHAR,
  "attendant_onduty_hour" VARCHAR,
  "attendant_onduty_month" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "globalid" VARCHAR
);