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

About this Dataset

Transitional Surface

This dataset provides information on the transitional surfaces of Iowa airports. The transitional surface extends outward and upward at right angles to the primary and approach surfaces at a slope of 7:1.
Organization: State of Iowa
Last updated: 2024-04-12T12:50:59.073193
Tags: airfield, aviation, imaginary-surface, inventory, part-77, runway

Tables

Table 1

@usgov.state_of_iowa_transitional_surface_data.table_1

165.03 kB
348 rows
19 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "faa_code" VARCHAR,
  "facility_name" VARCHAR,
  "airport_elevation_ft_msl" BIGINT  -- Airport Elevation (FT MSL),
  "part_77_surface" VARCHAR,
  "surface_description" VARCHAR,
  "inner_elevation_ft_msl" BIGINT  -- Inner Elevation (FT MSL),
  "outer_elevation_ft_msl" BIGINT  -- Outer Elevation (FT MSL),
  "surfwidth" BIGINT,
  "surface_ratio" VARCHAR,
  "notes" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "utc_offset" VARCHAR,
  "area_acre_state_plane" DOUBLE  -- Area (Acre - State Plane),
  "perimeter_meter_state_plane" DOUBLE  -- Perimeter (Meter - State Plane),
  "globalid" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);