About this Dataset

Approach Surface

The dataset provides information on airport approach surfaces. The approach surface is longitudinally centered on the extended runway centerline and extends outward and upward from each end of the primary surface. An approach surface is applied to the end of each runway based upon the type of approach available. (Slopes can vary from 20:1, 34:1, 40:1 or 50:1).
Organization: State of Iowa
Last updated: 2024-04-12T12:50:04.687723
Tags: airfield, aviation, imaginary-surface, inventory, part-77, runway

Tables

Table 1

@usgov.state_of_iowa_approach_surface_data.table_1

92.07 kB
326 rows
25 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "faa_code" VARCHAR,
  "associated_city" 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),
  "surface_widht_ft" BIGINT  -- Surface Widht (FT),
  "surface_ratio" VARCHAR,
  "approach_type" VARCHAR,
  "approach_inward" BIGINT,
  "approach_outward" BIGINT,
  "approach_surface_length_ft" BIGINT  -- Approach Surface Length (FT),
  "notes" VARCHAR,
  "merged_faa_code_surface_id" VARCHAR  -- Merged FAA Code & Surface ID,
  "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
);