d o t logoUnited States Department of Transportation
  OST-R > BTS
transtats logo
 
Advanced Search
Resources
Data Tools
: Passenger Connectivity
   Data Tables   Table Contents
Download Instructions  
Select all fields   % Missing in table Documentation
Field Name  Description  Support Table 
FacilityIDUnique record identifier. The identifier is unique to each record; records located at the same location as another will each have a unique FacilityID. 
PointIDUnique identifier for the transportation facility. The identifier is the same for records of different modes that are located at the same facility 
AirportCode3 Letter Airport CodeGet Lookup Table
AirportCode2Alternate 3 Character Airport Code 
AmtrakStationCode3 Character Amtrak Station Code 
FerryTerminalCode4 Digit Ferry Terminal Code 
RailIDRecord number for the heavy, light, or commuter rail station found in the U.S. Department of Transportation Bureau of Transportation Statistics National Transportation Atlas Database (2013) Fixed-Guideway Transit Facilities database.  
BikeIDID assigned by bike share system provider to the bike-share station. Unique within a bike share system 
DateUpdatedDate on Which Record was Last Updated 
AddressStreet Address 
CityName of City Where Facility is Located 
StatePostal State AbbreviationGet Lookup Table
ZipCodePostal Five Digit Zip Code 
MetroAreaMetro Area 
FacilityNameFacility Name 
LongitudeLongitude, Decimal degrees for the facility identified by the FacilityID. This is unique to each record. 
LatitudeLatitude, Decimal degrees for the facility identified by the FacilityID. This is unique to each record. 
PointLONLongitude, Decimal degrees for the facility identified by the point_ID. When two or more records are found at the same location, POINT_LON is the average of the Longitude fields for those records; otherwise same as the Longitude field. 
PointLATLatitude, Decimal degrees for the facility identified by the point_ID. When two or more records are found at the same location, POINT_LAT is the average of the Latitude fields for those records; otherwise same as the Latitude field. 
FacilityTypeFacility Mode Identifier That Shows Primary Mode Serving a Facility. Other Modes May Also Provide Service as Shown in the Individual Facility Record.Get Lookup Table
FerryTransitService Availability Indicator for Transit FerryGet Lookup Table
FerryIntercityService Availabililty Indicator for Intercity FerryGet Lookup Table
BusTransitService Availability Indicator for Transit BusGet Lookup Table
BusIntercityService Availability Indicator for Intercity BusGet Lookup Table
BusCodeShareService Availability Indicator for Code Share Bus Operated as Connecting Service to Rail or Airline ServiceGet Lookup Table
BusSupplementalService Availability Indicator for Supplemental Bus Service operated to provide additional frequencies on a route served by Intercity or Commuter Rail.Get Lookup Table
RailIntercityService Availability Indicator for Intercity RailGet Lookup Table
RailCommuterService Availability Indicator for Commuter RailGet Lookup Table
RailHeavyService Availability Indicator for Heavy RailGet Lookup Table
RailLightService Availability Indicator for Light RailGet Lookup Table
AirServiceService Availability Indicator for Scheduled Airline ServiceGet Lookup Table
Bike Share ServiceService Availability Indicator for Bike ShareGet Lookup Table
BikeSystemIDUnique ID for bike-share system 
BikeSystemName of bike-share system 
WebsiteWeb Address for Official Facility Website 
NotesNotes on Service Providers, Connectivity Issues, etc. 
SourceDataData Sources Used 
IntercityServiceIndicator that Service at Facility is Provided by at Least One Intercity Transportation Mode (RailIntercity, BusIntercity, BusShare, BusSupplemental, FerryIntercity or AirService)Get Lookup Table
TransitServiceIndicator that service at facility is provided by at least one transit mode (RailCommuter, RailHeavy, RailLight, BusTransit, or FerryTransit)Get Lookup Table
CBSACodeCensus Bureau Core Based Statistical Area CodeGet Lookup Table
CBSATypeIndicates whether CBSA is a Metropolitan Statistical Area (at least one urbanized area of 50,000+ population), or Micropolitan Statistical Area (at least one urbanized area of 10,000-50,000 population)Get Lookup Table
ModesServingCount of the Number of Transportation Modes Serving the Facility (from ModeBus, ModeAir, ModeRailStd, ModeRailTrt, ModeFerry, ModeBike)Get Lookup Table
ModeBusIndicates if Any Category of Bus Service is Provided at the Facility (BusIntercity, BusTransit, BusCodeShare, BusSupplemental)Get Lookup Table
ModeAirIndicates if Any Category of Air Service is Provided at the Facility (AirService)Get Lookup Table
ModeRailIndicates if Any Category of Rail Service is Provided at the Facility (RailIntercity. RailCommuter, RailHeavy, or RailLight)Get Lookup Table
ModeFerryIndicates if Any Category of Ferry Service is Provided at the Facility (FerryIntercity or FerryTransit)Get Lookup Table
ModeBikeIndicates if a Bike-share Station is Located at the Facility (Bike Share Service)Get Lookup Table