United States Department of Transportation

Table 3: Database Fields

Thursday, September 6, 2012

The following fields identify the facility:

Facility ID	A unique nine digit facility identifi er consisting of the state code for the facility, the zip code, and a sequential two digit number assigned to facilities within that zip code.
Facility name	Facility name
Facility type	Rail station, airport, bus station, etc.
Website	URL of website for the facility (when one exists)
Data Source	Public and other external data sources used by the Bureau of Transportation Statistics to find information on modes serving this location.
Notes	Listing of modes serving the facility and other factors relevant to the fi ndings in regard to service status of the various modes.
Date updated	Date that this record was last updated.

The following fields are included so that records can be correlated with those in other publicly available databases:

Airport code	The three-letter IATA code assigned to this facility where applicable.
Airport code2	The FAA airport code used for this facility when it differs from the IATA code.
Amtrak station code	The three-letter code used by Amtrak for this terminal.
Ferry terminal code	The terminal identifier used in the BTS National Census of Ferry Operators.

The following are location information fields:

Address	Street address
City	City where the facility is located
State	Postal state abbreviation
Zip code	Postal fi ve-digit zip code
Metro area	Name of Census Bureau Core Based Statistical Area (Metro Area) where the facility is located.
CBSA type	Indicates whether CBSA is a Metropolitan Statistical Area (population at least 50,000+) or a Micropolitan Statistical Area (population 10,000-50,000)
CBSA code	Census Bureau Core Based Statistical Area Code

The following fields indicate the status of service for each of the modes at this terminal facility (see table 4 for a definition of each mode):

Ferry transit	Indicates whether transit ferry serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Ferry intercity	Indicates whether intercity ferry serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Bus transit	Indicates whether transit bus serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Bus intercity	Indicates whether intercity bus serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Bus code share	Indicates whether code share bus serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Bus supplemental	Indicates whether supplemental bus serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Rail intercity	Indicates whether intercity rail serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Rail commuter	Indicates whether commuter rail serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Rail heavy	Indicates whether heavy rail serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Rail light	Indicates whether light rail serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).
Air service	Indicates whether airline service serves this facility (=1), is a "near connection" (=2), serves elsewhere in the city but not this facility (=0), or does not serve the city at all (=3).

The following fields contain statistical data based on the services provided by the various modes:

Intercity service	Indicates whether service at this location is provided by at least one intercity mode (Rail Intercity, Bus Intercity, Bus CodeShare, Bus Supplemental, Ferry Intercity, or Air Service) (0="no"/1="yes")
Transit service	Indicates whether service at this location is provided by at least one transit mode (Rail Commuter, Rail Heavy, Rail Light, Bus Transit or Ferry Transit) (0="no"/1="yes")
Modes serving	Count of the number of modes
Mode air	Indicator of whether the air mode serves this location (0="no"/1="yes")
Mode rail standard	Indicator of whether Rail Commuter or Rail Intercity serves this location (0="no"/1="yes")
Mode rail transit	Indicator of whether Rail Heavy or Rail Light serves this location. (0="no"/1="yes")
Mode ferry	Indicator of whether Ferry Intercity or Ferry Transit serves this location (0="no"/1="yes")
Mode bus	Indicator of whether at least one of the four bus modes serves this location (0="no"/1="yes")