About this Dataset

Horizontal Surface

The dataset provides information on the horizontal surfaces of Iowa airports. The horizontal surface is a plane 150’ above the established airport elevation. The perimeter of which is constructed by swinging arcs of specified radii from the center of each end of the primary surface and connecting adjacent arcs by lines tangent to those arcs.
Organization: State of Iowa
Last updated: 2024-04-12T12:50:17.904153
Tags: airfield, aviation, imaginary-surface, inventory, part-77, runway

Tables

Table 1

@usgov.state_of_iowa_horizontal_surface_data.table_1

932.97 kB
116 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),
  "surface_width_ft" BIGINT  -- Surface Width (FT),
  "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
);