About this Dataset

Airports -- Citizen Connect

The Airports dataset includes all official and operational aerodromes as of July 16, 2020 and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Airports database is a geographic point database of official operational aerodromes in the United States and U.S. Territories. Attribute data is provided on the physical and operational characteristics of the aerodrome, current usage including enplanements and aircraft operations, congestion levels and usage categories. This geospatial data is derived from the FAA's National Airspace System Resource Aeronautical Data Product.
Organization: Department of Transportation
Last updated: 2023-10-20T19:43:58.679555
Tags: airport, airports, national-transportation-atlas-database, ntad

Tables

Table 1

@usgov.dot_gov_airports_5e97a.table_1

5.36 MB
19,850 rows
107 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "rec_type" VARCHAR,
  "site_num" VARCHAR,
  "fac_type" VARCHAR,
  "loc_id" VARCHAR,
  "eff_date" TIMESTAMP,
  "region_cod" VARCHAR,
  "field_offi" VARCHAR,
  "state_post" VARCHAR,
  "state_name" VARCHAR,
  "county" VARCHAR,
  "county_pos" VARCHAR,
  "city" VARCHAR,
  "fac_name" VARCHAR,
  "owner_type" VARCHAR,
  "fac_use" VARCHAR,
  "owner_name" VARCHAR,
  "owner_addr" VARCHAR,
  "owner_city" VARCHAR,
  "owner_phon" VARCHAR,
  "manager_na" VARCHAR,
  "manager_ad" VARCHAR,
  "manager_ci" VARCHAR,
  "manager_ph" VARCHAR,
  "ref_point" VARCHAR,
  "ref_poin_1" VARCHAR,
  "ref_poin_2" VARCHAR,
  "ref_poin_3" VARCHAR,
  "ref_poin_4" VARCHAR,
  "elevation" DOUBLE,
  "elevation_20d020" VARCHAR  -- Elevation,
  "mag_var" VARCHAR,
  "mag_var_ye" DOUBLE,
  "pattern_al" DOUBLE,
  "sectional" VARCHAR,
  "dist_city" DOUBLE,
  "dir_city_t" VARCHAR,
  "land_area" DOUBLE,
  "boundary_a" VARCHAR,
  "boundary_1" VARCHAR,
  "boundary_2" VARCHAR,
  "responsibl" VARCHAR,
  "responsi_1" VARCHAR,
  "responsi_2" VARCHAR,
  "fss_on_fac" VARCHAR,
  "fss_id" VARCHAR,
  "fss_name" VARCHAR,
  "local_phon" VARCHAR,
  "toll_free" VARCHAR,
  "alt_fss_id" VARCHAR,
  "alt_fss_na" VARCHAR,
  "toll_fre_1" VARCHAR,
  "notam_wx_f" VARCHAR,
  "notam_dser" VARCHAR,
  "activation" VARCHAR,
  "status_cod" VARCHAR,
  "arff_cert" VARCHAR,
  "npias_fed" VARCHAR,
  "airspace_a" VARCHAR,
  "intl_custo" VARCHAR,
  "intl_cus_1" VARCHAR,
  "mil_joint" VARCHAR,
  "mil_landin" VARCHAR,
  "inspection" VARCHAR,
  "agency_ins" VARCHAR,
  "last_inspe" DOUBLE,
  "last_info" DOUBLE,
  "fuel_types" VARCHAR,
  "repair_ser" VARCHAR,
  "power_plan" VARCHAR,
  "bottled_ox" VARCHAR,
  "bulk_oxyge" VARCHAR,
  "lighting_s" VARCHAR,
  "beacon_lig" VARCHAR,
  "atc_tower" VARCHAR,
  "unicom" DOUBLE,
  "ctaf" DOUBLE,
  "seg_circle" VARCHAR,
  "beacon_col" VARCHAR,
  "landing_fe" VARCHAR,
  "medical_fa" VARCHAR,
  "based_sing" DOUBLE,
  "based_mult" DOUBLE,
  "based_jet" DOUBLE,
  "based_heli" DOUBLE,
  "based_glid" DOUBLE,
  "based_mili" DOUBLE,
  "based_ultr" DOUBLE,
  "commercial" DOUBLE,
  "commuter_o" VARCHAR,
  "air_taxi_o" DOUBLE,
  "ga_local_o" DOUBLE,
  "ga_itinera" DOUBLE,
  "mitary_ops" DOUBLE,
  "annual_ops" TIMESTAMP,
  "position_s" VARCHAR,
  "position_1" TIMESTAMP,
  "elevatio_1" VARCHAR,
  "elevatio_2" TIMESTAMP
);