About this Dataset

Approach Surface, Precision

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:48:58.919260
Tags: airfield, aviation, imaginary-surface, inventory, part-77, runway

Tables

Table 1

@usgov.state_of_iowa_approach_surface_precision_data.table_1

37.13 kB
23 rows
37 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_width_ft" BIGINT  -- Surface Width (FT),
  "surface_ratio" VARCHAR,
  "runway_end" BIGINT,
  "approach_type" VARCHAR,
  "approach_inward" BIGINT,
  "approach_outward" BIGINT,
  "approach_surface_length_ft" BIGINT  -- Approach Surface Length (FT),
  "notes" VARCHAR,
  "approach_elevation_1_ft_msl" BIGINT  -- Approach Elevation 1 (FT MSL),
  "part_77_surface_1" VARCHAR,
  "surface_description_1" VARCHAR,
  "inner_elevation_1_ft_msl" BIGINT  -- Inner Elevation 1 (FT MSL),
  "outer_elevation_1_ft_msl" BIGINT  -- Outer Elevation 1 (FT MSL),
  "surface_width_1_ft" BIGINT  -- Surface Width 1 (FT),
  "surface_ratio_1" VARCHAR,
  "runway_end_1" BIGINT,
  "approach_type_1" VARCHAR,
  "approach_inward_1" BIGINT,
  "approach_outward_1" BIGINT,
  "approach_surface_length_1_ft" BIGINT  -- Approach Surface Length 1 (FT),
  "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
);