Name: Intermodal Passenger Connectivity Database (IPCD)

Display Field: fac_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: 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

Copyright Text: This NTAD dataset is a work of the United States government as defined in 17 U.S.C. § 101 and as such are not protected by any U.S. copyrights. This work is available for unrestricted public use.

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -176.646030000419
YMin: 19.7202599997756
XMax: -66.9850400002959
YMax: 71.2854500000434
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[40,150,44,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FAC_ID (type: esriFieldTypeString, alias: FAC_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• POINT_ID (type: esriFieldTypeInteger, alias: POINT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NEAR_ID_1 (type: esriFieldTypeInteger, alias: NEAR_ID_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NEAR_ID_2 (type: esriFieldTypeInteger, alias: NEAR_ID_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NEAR_ID_3 (type: esriFieldTypeInteger, alias: NEAR_ID_3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AIR_CODE (type: esriFieldTypeString, alias: AIR_CODE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• AIR_CODE2 (type: esriFieldTypeString, alias: AIR_CODE2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AMTRAKCODE (type: esriFieldTypeString, alias: AMTRAKCODE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• FERRY_CODE (type: esriFieldTypeString, alias: FERRY_CODE, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• RAIL_ID (type: esriFieldTypeString, alias: RAIL_ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BIKE_ID (type: esriFieldTypeString, alias: BIKE_ID, SQL Type: sqlTypeOther, length: 72, nullable: true, editable: true)
• DATE_UPDTE (type: esriFieldTypeDate, alias: DATE_UPDTE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 214, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 78, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• ZIPCODE (type: esriFieldTypeString, alias: ZIPCODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• METRO_AREA (type: esriFieldTypeString, alias: METRO_AREA, SQL Type: sqlTypeOther, length: 90, nullable: true, editable: true)
• FAC_NAME (type: esriFieldTypeString, alias: FAC_NAME, SQL Type: sqlTypeOther, length: 148, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: LATITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_LON (type: esriFieldTypeDouble, alias: POINT_LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_LAT (type: esriFieldTypeDouble, alias: POINT_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FAC_TYPE (type: esriFieldTypeInteger, alias: FAC_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FERRY_T (type: esriFieldTypeInteger, alias: FERRY_T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FERRY_I (type: esriFieldTypeInteger, alias: FERRY_I, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUS_T (type: esriFieldTypeInteger, alias: BUS_T, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUS_I (type: esriFieldTypeInteger, alias: BUS_I, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUS_CODE_S (type: esriFieldTypeInteger, alias: BUS_CODE_S, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUS_SUPP (type: esriFieldTypeInteger, alias: BUS_SUPP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RAIL_I (type: esriFieldTypeInteger, alias: RAIL_I, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RAIL_C (type: esriFieldTypeInteger, alias: RAIL_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RAIL_H (type: esriFieldTypeInteger, alias: RAIL_H, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RAIL_LIGHT (type: esriFieldTypeInteger, alias: RAIL_LIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AIR_SERVE (type: esriFieldTypeInteger, alias: AIR_SERVE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIKE_SHARE (type: esriFieldTypeInteger, alias: BIKE_SHARE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIKE_SYS_ID (type: esriFieldTypeInteger, alias: BIKE_SYS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BIKE_SYS (type: esriFieldTypeString, alias: BIKE_SYS, SQL Type: sqlTypeOther, length: 176, nullable: true, editable: true)
• WEBSITE (type: esriFieldTypeString, alias: WEBSITE, SQL Type: sqlTypeOther, length: 282, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 674, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: SOURCE, SQL Type: sqlTypeOther, length: 374, nullable: true, editable: true)
• I_SERVICE (type: esriFieldTypeInteger, alias: I_SERVICE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• T_SERVICE (type: esriFieldTypeInteger, alias: T_SERVICE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CBSA_CODE (type: esriFieldTypeInteger, alias: CBSA_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CBSA_TYPE (type: esriFieldTypeInteger, alias: CBSA_TYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODES_SERV (type: esriFieldTypeInteger, alias: MODES_SERV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODE_BUS (type: esriFieldTypeInteger, alias: MODE_BUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODE_AIR (type: esriFieldTypeInteger, alias: MODE_AIR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODE_RAIL (type: esriFieldTypeInteger, alias: MODE_RAIL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODE_FERRY (type: esriFieldTypeInteger, alias: MODE_FERRY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODE_BIKE (type: esriFieldTypeInteger, alias: MODE_BIKE, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Intermodal Passenger Connectivity Database (IPCD)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/30/2025 8:58:17 PM

Schema Last Edit Date: 4/30/2025 8:58:17 PM

Data Last Edit Date: 4/30/2025 8:58:17 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat