Schema
Intermodal Passenger Connectivity Database (IPCD) / Intermodal Passenger Connectivity Database (IPCD) / v1.0.0
Schema from intermodal-passenger-connectivity-database-ipcd.parquet, gcp-portolan-published, v1.0.0.
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. 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. Bike-share stations belonging to bike-share 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 data elements describe 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 bike-share 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 bike-share facility in the database.
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| X | float | No | 0 | — | — Range: -176.64603 to -66.98504Length: — | Examples: -87.7636, -76.6522, -73.9766, -74.9585, -74.16489 Values: — |
| Y | float | No | 0 | — | — Range: 19.72026 to 71.28545Length: — | Examples: 41.97114, 39.3684, 40.7883, 40.0393, 40.73428 Values: — |
| FAC_ID | string | No | 0 | — | — Range: —Length: 10 | Examples: IL6063003, MD2120902, NY1002401, NJ0807502, NJ0710201 Values: — |
| POINT_ID | integer | No | 0 | — | — Range: 1 to 4300Length: — | Examples: 158, 3106, 4200, 3995, 261 Values: — |
| NEAR_ID_1 | float | Yes | 4,556 | — | — Range: 9 to 19038Length: — | Examples: 4131.0, 2313.0, 351.0, 4647.0, 195.0 Values: — |
| NEAR_ID_2 | float | Yes | 4,942 | — | — Range: 68 to 18397Length: — | Examples: 7509.0, 8338.0, 7723.0, 17682.0, 17147.0 Values: — |
| NEAR_ID_3 | float | Yes | 4,989 | — | — Range: 4130 to 8683Length: — | Examples: 4130.0, 7732.0, 8359.0, 8683.0, 4132.0 Values: — |
| AIR_CODE | string | Yes | 4,467 | — | — Range: —Length: 3 | Examples: CLE, IPL, GSO, MLS, JLN Values: — |
| AIR_CODE2 | string | Yes | 4,928 | — | — Range: —Length: 4 | Examples: 16A, 6R7, 51Z, AK81, AK5 Values: — |
| AMTRAKCODE | string | Yes | 4,331 | — | — Range: —Length: 3 | Examples: DUL, RVM, BUR, BAT, EMY Values: — |
| FERRY_CODE | string | Yes | 4,811 | — | — Range: —Length: 3 | Examples: 180, 81, 294, 147, 274 Values: — |
| RAIL_ID | string | Yes | 3,880 | — | — Range: —Length: 4 | Examples: 1090, 2483, 387, 1483, 94 Values: — |
| BIKE_ID | string | Yes | 4,404 | — | — Range: —Length: 27 | Examples: B32035, 84, hub_2118, 124, bcycle_greenbikeslc_3181 Values: — |
| DATE_UPDTE | string | No | 0 | — | — Range: —Length: 25 | Examples: 2016-04-16T00:00:00+00:00, 2016-04-16T00:00:00+00:00, 2016-04-16T00:00:00+00:00, 2016-04-16T00:00:00+00:00, 2016-04-16T00:00:00+00:00 Values: 2016-04-16T00:00:00+00:00, 2016-05-30T00:00:00+00:00, 2016-07-05T00:00:00+00:00, 2016-08-17T00:00:00+00:00, 2016-09-14T00:00:00+00:00, 2016-09-16T00:00:00+00:00, 2016-09-18T00:00:00+00:00, 2016-09-19T00:00:00+00:00, 2016-09-20T00:00:00+00:00, 2016-10-04T00:00:00+00:00, 2017-08-18T00:00:00+00:00, 2018-07-01T00:00:00+00:00, 2019-08-12T00:00:00+00:00, 2019-11-04T00:00:00+00:00, 2020-08-20T00:00:00+00:00, 2021-07-21T08:56:07+00:00, 2021-08-08T00:00:00+00:00, 2022-02-15T00:00:00+00:00, 2022-08-07T00:00:00+00:00 |
| ADDRESS | string | Yes | 390 | — | — Range: —Length: 63 | Examples: 711 Des Plaines Ave, 650 Airport Dr, 4917 N Milwaukee Ave, Canal St & Poydras St, 6402 N Central Values: — |
| CITY | string | No | 0 | — | — Range: —Length: 37 | Examples: Chicago, Mt Washington, New York, Riverside, Newark Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 2 | Examples: IL, MD, NY, NJ, NJ Values: — |
| ZIPCODE | string | No | 0 | — | — Range: —Length: 5 | Examples: 60630, 21209, 10024, 8075, 7102 Values: — |
| METRO_AREA | string | Yes | 517 | — | — Range: —Length: 45 | Examples: Merced CA, Chicago-Naperville-Elgin IL-IN-WI, Phoenix-Mesa-Scottsdale AZ, Hilo HI, Stockton-Lodi CA Values: — |
| FAC_NAME | string | Yes | 365 | — | — Range: —Length: 63 | Examples: Rockridge (Oakland), Baypointe, Hempstead Transit Center, San Jose Diridon, Union Station Values: — |
| LONGITUDE | float | No | 0 | — | — Range: -176.64603 to -66.98504Length: — | Examples: -87.7636, -76.6522, -73.9766, -74.9585, -74.16489 Values: — |
| LATITUDE | float | No | 0 | — | — Range: 19.72026 to 71.28545Length: — | Examples: 41.97114, 39.3684, 40.7883, 40.0393, 40.73428 Values: — |
| POINT_LON | float | No | 0 | — | — Range: -176.64603 to -66.98504Length: — | Examples: -87.763, -76.6522, -73.9766, -74.9585, -74.164596 Values: — |
| POINT_LAT | float | No | 0 | — | — Range: 19.72026 to 71.28545Length: — | Examples: 41.97047, 39.3684, 40.7883, 40.0393, 40.734452 Values: — |
| FAC_TYPE | integer | No | 0 | — | — Range: 1 to 12Length: — | Examples: 11, 8, 9, 8, 10 Values: — |
| FERRY_T | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 3, 0, 0, 0 Values: — |
| FERRY_I | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 3, 3, 0, 3, 0 Values: — |
| BUS_T | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| BUS_I | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 1 Values: — |
| BUS_CODE_S | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| BUS_SUPP | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 3, 0, 0, 0 Values: — |
| RAIL_I | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 1 Values: — |
| RAIL_C | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 1, 0, 0, 0, 1 Values: — |
| RAIL_H | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 1, 0, 1, 0, 1 Values: — |
| RAIL_LIGHT | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 1, 0, 1, 1 Values: — |
| AIR_SERVE | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| BIKE_SHARE | integer | No | 0 | — | — Range: 0 to 3Length: — | Examples: 0, 3, 2, 0, 0 Values: — |
| BIKE_SYS_ID | integer | No | 0 | — | — Range: 0 to 153Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| BIKE_SYS | string | Yes | 4,399 | — | — Range: —Length: 81 | Examples: Citi Bike, Citi Bike, Capital Bikeshare, Bay Area BikeShare (became Ford GoBike 06/28/2017 then became Bay Wheels 06/2019), Divvy Values: — |
| WEBSITE | string | Yes | 2,666 | — | — Range: —Length: 141 | Examples: metrarail.com/metra/en/home/maps_schedules/metra_system_map/md-w/station.BIGTIMBER.html, www.mta.info/nyct/service/index.html, www.sdmts.com/Trolley/TrolleyStationInfo.asp, www.alamosacounty.org/depts/Airport/index.html, metrarail.com/metra/en/home/maps_schedules/metra_system_map/md-w/station.MONTCLARE.html Values: — |
| NOTES | string | Yes | 610 | — | — Range: —Length: 337 | Examples: Served by NJ Transit commuter trains and NJ Transit buses., No scheduled ground transportation., Served by Porter Stage Lines, Served by MUNI light rail, Served by MUNI bus and light rail and Samtrans Bus; near connection with Caltrain commuter rail Values: — |
| SOURCE | string | Yes | 676 | — | — Range: —Length: 187 | Examples: FTA/NTD Database and tripplanner.transit.511.org/mtc/XSLT_TRIP_REQUEST2?language=en, www.mbta.com/, www.amtrakcalififornia.com; www.yarts.com, FTA/NTD Database and tripplanner.transit.511.org/mtc/XSLT_TRIP_REQUEST2?language=en, metrarail.com and www.pacebus.com Values: — |
| I_SERVICE | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 1 Values: — |
| T_SERVICE | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| CBSA_CODE | float | Yes | 517 | — | — Range: 10460 to 49740Length: — | Examples: 32900.0, 16980.0, 38060.0, 25900.0, 44700.0 Values: — |
| CBSA_TYPE | integer | No | 0 | — | — Range: 0 to 2Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| MODES_SERV | integer | No | 0 | — | — Range: 1 to 4Length: — | Examples: 2, 2, 2, 2, 2 Values: — |
| MODE_BUS | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| MODE_AIR | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| MODE_RAIL | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 1, 1, 1, 1, 1 Values: — |
| MODE_FERRY | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| MODE_BIKE | integer | No | 0 | — | — Range: 0 to 1Length: — | Examples: 0, 0, 0, 0, 0 Values: — |