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

About this Dataset

Primary Surface

The dataset provides information on the primary surfaces of Iowa airports. The primary surface extends 200 feet beyond each end of the runway, but when the runway has no specially prepared hard surface, the surface ends at the end of that runway.
Organization: State of Iowa
Last updated: 2024-04-12T12:45:57.494180
Tags: airfield, aviation, imaginary-surface, inventory, part-77, runway

Tables

Table 1

@usgov.state_of_iowa_primary_surface_data.table_1

61.95 kB
116 rows
24 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "faa_code" VARCHAR,
  "associated_city" VARCHAR,
  "airport_name" VARCHAR,
  "maintenance_first_name" VARCHAR,
  "maintenance_last_name" VARCHAR,
  "maintenance_phone" VARCHAR,
  "elevation_ft_msl" BIGINT  -- Elevation (FT MSL),
  "fed_agreement" VARCHAR,
  "far_139" VARCHAR,
  "inspection_code" VARCHAR,
  "inspection_date" VARCHAR,
  "sponsor" VARCHAR,
  "sponsor_population" BIGINT,
  "chamber_s_website" VARCHAR,
  "airport_active" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "perimeter_meter_state_plane" DOUBLE  -- Perimeter (Meter - State Plane),
  "area_acre_state_plane" DOUBLE  -- Area (Acre - State Plane),
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);