About this Dataset

Intermodal Passenger Connectivity Database (IPCD)

The Intermodal Passenger Connectivity Database (IPCD) dataset was compiled on August 10, 2021 and was updated October 19, 2022 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The IPCD is a nationwide database of passenger transportation terminals, with data on the availability of connections among the various scheduled public transportation modes at each facility. IPCD is no longer being updated, the latest information is from 2022. The IPCD data covers the following types of passenger transportation terminals/stops: 1. Scheduled airline service airports. 2. Intercity bus stations (includes stations served by regular scheduled intercity bus service such as Greyhound, Trailways, code sharing buses such as Amtrak Thruway feeder buses, supplemental buses that provide additional frequencies along rail routes, and airport bus services from locations that are outside of the airport metropolitan area). 3. Intercity and transit ferry terminals. 4. Light-rail transit stations. 5. Heavy-rail transit stations. 6. Passenger-rail stations on the national rail network served by intercity rail and/or commuter rail services. 7. Bikeshare stations belonging to bikeshare systems that are open to the general public, IT-automated, and station based (contain hubs to which users can grab and return a bike). The bikeshare stations only include those from the latest IPCD data collection in 2022. Please consult the latest bikeshare layer (https://doi.org/10.21949/1522020) for the most current information. The IPCD includes data elements describing the location of the above types of terminals as well as the availability of intercity, commuter, and transit rail; scheduled air service; intercity and transit bus; intercity and transit ferry services; and bikeshare availability. Transit bus service locations are not specifically included in the database. However, the status of transit bus as a connecting mode is included for each bikeshare facility in the database. A data dictionary, or other source of attribute information, is accessible at https://doi.org/10.21949/1529035
Organization: Federal Geographic Data Committee
Last updated: 2025-06-30T16:04:45.649346
Tags: ngda-fgdc-gda-transportation

Tables

Table 1

@usgov.fgdc_gov_intermodal_passenger_connectivity_database_ipcd_14a6e.table_1

2.12 MB
15488 rows
55 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE,
  "fac_id" VARCHAR,
  "point_id" BIGINT,
  "near_id_1" DOUBLE,
  "near_id_2" DOUBLE,
  "near_id_3" DOUBLE,
  "air_code" VARCHAR,
  "air_code2" VARCHAR,
  "amtrakcode" VARCHAR,
  "ferry_code" DOUBLE,
  "rail_id" VARCHAR,
  "bike_id" VARCHAR,
  "date_updte" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "metro_area" VARCHAR,
  "fac_name" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "point_lon" DOUBLE,
  "point_lat" DOUBLE,
  "fac_type" BIGINT,
  "ferry_t" BIGINT,
  "ferry_i" BIGINT,
  "bus_t" BIGINT,
  "bus_i" BIGINT,
  "bus_code_s" BIGINT,
  "bus_supp" BIGINT,
  "rail_i" BIGINT,
  "rail_c" BIGINT,
  "rail_h" BIGINT,
  "rail_light" BIGINT,
  "air_serve" BIGINT,
  "bike_share" BIGINT,
  "bike_sys_id" BIGINT,
  "bike_sys" VARCHAR,
  "website" VARCHAR,
  "notes" VARCHAR,
  "source" VARCHAR,
  "i_service" BIGINT,
  "t_service" BIGINT,
  "cbsa_code" DOUBLE,
  "cbsa_type" BIGINT,
  "modes_serv" BIGINT,
  "mode_bus" BIGINT,
  "mode_air" BIGINT,
  "mode_rail" BIGINT,
  "mode_ferry" BIGINT,
  "mode_bike" BIGINT,
  "x2" DOUBLE,
  "y2" DOUBLE
);