Legacy Publication

You are here

Table 3: Database Fields

Table 3: Database Fields

Excel | CSV

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")
Updated: Saturday, May 20, 2017