Description

more
This is a public dataset for the Department of Transportation, Office of the Assistant Secretary for Research and Technology's Bureau of Transportation Statistics. The public database consists of four tables. One of the tables is a spatial table: INTERMODAL_FACILITY. The three other tables consist of attribute data for the database: INTERMODAL_CARGO, INTERMODAL_COMMODITY and INTERMODAL_DIRECTIONALITY. This database was based on the requirements from the Commodity Flow Survey and with the different modes of DOT, supervised by OST-R/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.

Dataset Attributes

  • OBJECTID
    Number
  • ID
    Text
  • NAME
    Text
    {"value"=>"CF Industries, Rosemount Fertilizer Terminal, Dock", "count"=>2} (), {"value"=>"FARMERS COOPERATIVE-BAYARD-IA", "count"=>1} (), {"value"=>"FARMERS COOPERATIVE SOCIETY-SIOUX CENTER-IA", "count"=>1} (), {"value"=>"Farmers Cooperative Society", "count"=>1} (), {"value"=>"Farmers Cooperative of Hanska", "count"=>1} (), {"value"=>"FARMERS COOPERATIVE GRAIN CO.-KINDE-MI", "count"=>1} (), {"value"=>"Farmers Cooperative Grain and Supply Co.", "count"=>1} (), {"value"=>"FARMERS COOPERATIVE ELEVATOR-WESTERN-NE", "count"=>1} (), {"value"=>"FARMERS COOPERATIVE ELEVATOR CO.-CLEAR LAKE-IA", "count"=>1} (), {"value"=>"FARMERS COOPERATIVE CO.-REMSEN-IA", "count"=>1} ()
  • TYPE
    Text
    {"value"=>"RAIL", "count"=>2158} (), {"value"=>"TRUCK", "count"=>444} (), {"value"=>"AIR", "count"=>407} (), {"value"=>"PORT", "count"=>183} (), {"value"=>"INDEPENDENT PORT", "count"=>88} ()
  • MODE_TYPE
    Text
    {"value"=>"RAIL & TRUCK", "count"=>2270} (), {"value"=>"AIR & TRUCK", "count"=>407} (), {"value"=>"TRUCK - PORT - RAIL", "count"=>340} (), {"value"=>"TRUCK & TRUCK", "count"=>135} (), {"value"=>"PORT & TRUCK", "count"=>112} (), {"value"=>"RAIL & PORT", "count"=>10} (), {"value"=>"TRUCK - PORT - AIR", "count"=>4} (), {"value"=>"TRUCK - PORT - RAIL - AIR", "count"=>1} (), {"value"=>"TRUCK - AIR - RAIL", "count"=>1} ()
  • CITY
    Text
    {"value"=>"KANSAS CITY", "count"=>58} (), {"value"=>"CHICAGO", "count"=>53} (), {"value"=>"MEMPHIS", "count"=>36} (), {"value"=>"HOUSTON", "count"=>36} (), {"value"=>"Portland", "count"=>35} (), {"value"=>"ATLANTA", "count"=>28} (), {"value"=>"COLUMBUS", "count"=>27} (), {"value"=>"BALTIMORE", "count"=>27} (), {"value"=>"CLEVELAND", "count"=>26} (), {"value"=>"BIRMINGHAM", "count"=>23} ()
  • STATE
    Text
    {"value"=>"IL", "count"=>227} (), {"value"=>"CA", "count"=>212} (), {"value"=>"TX", "count"=>195} (), {"value"=>"OH", "count"=>190} (), {"value"=>"MI", "count"=>135} (), {"value"=>"PA", "count"=>135} (), {"value"=>"WA", "count"=>119} (), {"value"=>"MO", "count"=>114} (), {"value"=>"FL", "count"=>107} (), {"value"=>"MN", "count"=>106} ()
  • FIPS
    Text
    {"value"=>"17", "count"=>227} (), {"value"=>"06", "count"=>212} (), {"value"=>"48", "count"=>195} (), {"value"=>"39", "count"=>190} (), {"value"=>"42", "count"=>135} (), {"value"=>"26", "count"=>135} (), {"value"=>"53", "count"=>119} (), {"value"=>"29", "count"=>114} (), {"value"=>"12", "count"=>107} (), {"value"=>"27", "count"=>106} ()
  • ZIP
    Text
    {"value"=>" ", "count"=>38} (), {"value"=>"21224", "count"=>9} (), {"value"=>"35207", "count"=>8} (), {"value"=>"19148", "count"=>8} (), {"value"=>"38118", "count"=>7} (), {"value"=>"38109", "count"=>7} (), {"value"=>"32206", "count"=>7} (), {"value"=>"30336", "count"=>7} (), {"value"=>"44114", "count"=>6} (), {"value"=>"43219", "count"=>6} ()
  • ZIP2
    Text
    {"value"=>" ", "count"=>2979} (), {"value"=>"2140", "count"=>3} (), {"value"=>"1009", "count"=>3} (), {"value"=>"2270", "count"=>3} (), {"value"=>"4409", "count"=>2} (), {"value"=>"1462", "count"=>2} (), {"value"=>"1475", "count"=>2} (), {"value"=>"2838", "count"=>2} (), {"value"=>"2560", "count"=>2} (), {"value"=>"5027", "count"=>2} ()
  • PARCEL
    Number
    0 to 0
  • LATITUDE
    Number
    18.439 to 64.80709
  • LONGITUDE
    Number
    -165.43611 to -66.002
  • GEOSOURCE
    Text
    {"value"=>"GDT 2000 STREETS", "count"=>1785} (), {"value"=>"GDT 2001 STREETS", "count"=>1428} (), {"value"=>"NTAD2002PORT", "count"=>28} (), {"value"=>"NTAD2002AIRPORT", "count"=>28} (), {"value"=>"NTAD 2001 AIRPORTS", "count"=>7} (), {"value"=>"Port Series Report", "count"=>4} ()
  • CREATEDATE
    Date
    1049846400000 to 1049846400000
  • CREATOR
    Text
    {"value"=>"INDUS", "count"=>3280} ()
  • MODDATE
    Date
  • ASSOC
    Text
    {"value"=>" ", "count"=>1464} (), {"value"=>"BNSF", "count"=>524} (), {"value"=>"NS", "count"=>296} (), {"value"=>"CSXT", "count"=>178} (), {"value"=>"CN", "count"=>101} (), {"value"=>"UP", "count"=>91} (), {"value"=>"UNION PACIFIC", "count"=>31} (), {"value"=>"CR (SAA)", "count"=>30} (), {"value"=>"BNSF, UP", "count"=>30} (), {"value"=>"INTERMODAL CONTRACTORS WITH VARIOUS RAIL CARRIERS", "count"=>21} ()
  • Shape
    Number

Related Datasets