About this Dataset

Airports

The Airports database is a geographic point database of aircraft landing facilities in the State of Maryland. Attribute data is provided on the physical and operational characteristics of the landing facility, 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. This dataset only contains features located within the State of Maryland.
Organization: State of Maryland
Last updated: 2025-07-26T20:53:37.947078

Tables

Table 1

@usgov.state_of_maryland_airports_0267a.table_1

62.78 kB
217 rows
49 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "gis_object_id" BIGINT,
  "site_number" VARCHAR,
  "landing_facility_type" VARCHAR,
  "location_id" VARCHAR,
  "information_effective_date" TIMESTAMP,
  "faa_region" VARCHAR,
  "faa_district" VARCHAR,
  "state_postal_abbreviation" VARCHAR,
  "state_fips_code" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "city_name" VARCHAR,
  "full_name" VARCHAR,
  "owner_type" VARCHAR,
  "facility_use" VARCHAR,
  "facility_city_state_and_zip" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation" DOUBLE,
  "aeronautical_chart" VARCHAR,
  "central_business_district_distance" DOUBLE,
  "central_business_district_direction" VARCHAR,
  "month_and_year_added_to_nfdc_database" VARCHAR,
  "airport_certification_type_and_date" VARCHAR,
  "federal_agreement_code" VARCHAR,
  "customs_international_airport" VARCHAR,
  "customs_landing_rights_airport" VARCHAR,
  "joint_use_airport" VARCHAR,
  "military_landing_rights" VARCHAR,
  "airport_control_tower" VARCHAR,
  "single_engine_based_craft" DOUBLE,
  "multi_engine_based_craft" DOUBLE,
  "jet_engine_based_craft" DOUBLE,
  "based_helicopters" DOUBLE,
  "base_operational_gliders" DOUBLE,
  "based_military_aircraft" DOUBLE,
  "based_ultralight_aircraft" DOUBLE,
  "commercial_services" DOUBLE,
  "air_taxi_operators" DOUBLE,
  "local_operations" DOUBLE,
  "itinerant_operations" DOUBLE,
  "military_operations_aircraft" DOUBLE,
  "arrivals" BIGINT,
  "departures" BIGINT,
  "enplanements" BIGINT,
  "passengers" BIGINT,
  "data_source" VARCHAR,
  "access" VARCHAR
);