About this Dataset

Intermodal Freight Facilities Pipeline Terminals

The Intermodal Freight Facilities - Pipeline Terminals dataset was compiled on February 02, 2021 and was updated on April 21, 2021 from the Bureau of Transportation Statistics (BTS) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). Pipeline terminals interface between pipeline mode and other transportation modes. They have the ability to receive or deliver freight commodities via pipeline and truck/rail/water. The data consists of location information, truck/rail/water mode connections, storage capacity, and a list of commodities handled at the terminal. Geographical coverage includes the United States and U.S. territories. This dataset is one of several layers in the Bureau of Transportation Statistics (BTS) Intermodal Freight Facility Database.
Organization: Federal Geographic Data Committee
Last updated: 2025-06-30T16:06:06.829312
Tags: ngda-fgdc-gda-transportation

Tables

Table 1

@usgov.fgdc_gov_intermodal_freight_facilities_pipeline_terminals_55ac3.table_1

233.84 KB
1401 rows
35 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "term_id" BIGINT,
  "irs_id" VARCHAR,
  "hifld_id" VARCHAR,
  "comp_name" VARCHAR,
  "term_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "state_fips" BIGINT,
  "county" VARCHAR,
  "cnty_fips" BIGINT,
  "truck" VARCHAR,
  "rail" VARCHAR,
  "water" VARCHAR,
  "capacity" VARCHAR,
  "crude_oil" VARCHAR,
  "refined" VARCHAR,
  "pet_chem" VARCHAR,
  "ngl" VARCHAR,
  "gasoline" VARCHAR,
  "distillate" VARCHAR,
  "biodiesel" VARCHAR,
  "jetfuel" VARCHAR,
  "ethanol" VARCHAR,
  "website" VARCHAR,
  "google" VARCHAR,
  "bing" VARCHAR,
  "zoomearth" VARCHAR,
  "val_date" TIMESTAMP,
  "source" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);