Abstract: This is a public dataset for the Department of Transportation, Research and Innovative Technology Administration's Bureau of Transportation Statistics. The public database consists of four tables. One of the tables is a spatial table: FACILITY. The three other tables consist of attribute data for the database: SHIPMENT, COMMODI and DIRECTIO. This database was based on the requirements from the Commodity Flow Survey and with the different modes of DOT, supervised by RITA/BTS. The database will extend its design to support all of the modes within the DOT and in reference to modes involved with Intermodal transfer.
Purpose: This is a public dataset for the Department of Transportation, Research and Innovative Technology Administration's Bureau of Transportation Statistics for internal use in GIS efforts. The data can be utilized alone or in conjunction with various networks developed for the data.
Field Number
Attribute
Description
Data Type
0
FID
Internal feature number.
Long Integer representing an object identifier
1
Shape
Feature geometry.
Geometry
2
ID
Primary Key
Character String
3
NAME
Unique name for the facility location
Character String
4
TYPE
Name of the function of the primary function of the facility.
Character String
5
MODE_TYPE
Defines all the modes that are affiliated with this facility.
Character String
6
CITY
The city for the facilities location
Character String
7
STATE
The state abbreviation for the facilities location
Character String
8
FIPS
Federal Information Processing Standards for the states
Character String
9
ZIP
The zip code for the facilities location
Character String
10
ZIP2
Zip Code Plus 4
Character String
11
PARCEL
Indicates if a mail carrier is affiliated with this location
Double Precision Floating Point
12
LATITUDE
Latitude for the location
Double Precision Floating Point
13
LONGITUDE
Longitude for the location
Double Precision Floating Point
14
GEOSOURCE
Source information of the latitude/longitude: either pre-determined or geocoded with Dynamap 2000
Character String
15
CREATEDATE
The date the information was placed into the database
Date
16
CREATOR
The group of individuals responsible for populating that record
Character String
17
MODDATE
Date of modifications to that facility's entry in the database
Date
18
VERSION
BTS tracking number
Character String
19
ASSOC
List of other major business associated with this facility
Character String
20
BTSVERSION
The VERSION is a 2-digit number that will be incremented for all records in the database whenever a new release is distributed.
