NorthAmericanElectricReliabilityCorporation

Table nercregions_201610
Text name North American Electric Reliability Corporation (NERC) Regions.
Schema northamericanelectricreliabilitycorporation
Source organization North American Energy Regulatory Corporation
Source organization webpage http://www.nerc.com
Data source url https://www.eia.gov/maps/map_data/NERC_Regions_EIA.zip
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
nerc character varying
nerc_label character varying

USEnergyInformationAgency

Table biodiesel_plants_us_201505v3
Text name U.S. Biodiesel Plants
Schema usenergyinformationagency
Description Location and basic information for U.S. biodiesel plants
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
company character varying
state character varying
padd numeric
longitude numeric
latitude numeric
source character varying
period numeric
Table crudeoil_pipelines_us_201703
Text name Crude Oil Pipelines
Schema usenergyinformationagency
Description Major crude oil pipelines in the United States.
Dataset includes interstate trunk lines and selected intrastate lines but excludes gathering lines. Based on publicly available data from a variety of sources with varying scales and levels of accuracy.
Updated 03/2017.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
opername character varying
pipename character varying
shape_leng numeric
Table crudeoil_railterminals_nov2014
Schema usenergyinformationagency
Description Rail terminals that handle the loading and unloading of crude oil.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
site_name character varying
city character varying
state character varying
padd numeric
station_ty character varying
facility_t character varying
handling character varying
longitude numeric
latitude numeric
source character varying
Table electric_power_transmission_lines
Schema usenergyinformationagency
Description Includes lines operated at relatively high voltages varying from 69 kV up to 765 kV which are capable of transmitting large quantities of electricity over long distances. Underground transmission lines are included where sources were available.
Source organization Homeland Infrastructure Foundation-Level Data (HIFLD)
Source organization webpage https://hifld-geoplatform.opendata.arcgis.com/
Data source url https://hifld-geoplatform.opendata.arcgis.com/datasets/electric-power-transmission-lines
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
objectid numeric
id character varying
owner character varying
status character varying
voltage numeric
volt_class character varying
inferred character varying
sub_1 character varying
sub_2 character varying
method character varying
date character varying
source character varying
shape__len numeric
Table electric_retail_service_territories
Schema usenergyinformationagency
Description Areas serviced by electric power utilities responsible for the retail sale of electric power to local customers, whether residential, industrial, or commercial.
Source organization Homeland Infrastructure Foundation-Level Data (HIFLD)
Source organization webpage https://hifld-geoplatform.opendata.arcgis.com/
Data source url https://hifld-geoplatform.opendata.arcgis.com/datasets/c4fd0b01c2544a2f83440dab292f0980_0
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
objectid numeric
id character varying
name character varying
phone character varying
address character varying
city character varying
state character varying
zipcode character varying
country character varying
website character varying
owner_type character varying
regulated character varying
cntrl_area character varying
plan_area character varying
holding_co character varying
year character varying
summr_peak numeric
wintr_peak numeric
summer_cap numeric
winter_cap numeric
net_gen numeric
purchased numeric
net_ex numeric
retail_mwh numeric
wsale_mwh numeric
total_mwh numeric
trans_mwh numeric
customers numeric
method character varying
date character varying
source character varying
shape__are numeric
shape__len numeric
Table electric_substations
Schema usenergyinformationagency
Description Facilities and equipment that switch, transform, or regulate electric voltage. Includes taps, a location where power on a transmission line is tapped by another transmission line.
Source organization Homeland Infrastructure Foundation-Level Data (HIFLD)
Source organization webpage https://hifld-geoplatform.opendata.arcgis.com/
Data source url https://hifld-geoplatform.opendata.arcgis.com/datasets/ec5ecb9e8fec448fa0de73d37cbd74c3_0
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
objectid numeric
id character varying
name character varying
city character varying
state character varying
zipcode character varying
country character varying
lines numeric
max_volt numeric
min_volt numeric
max_infer character varying
min_infer character varying
latitude numeric
longitude numeric
method character varying
date character varying
source character varying
Table ethanol_plants_us_aug2015v2
Schema usenergyinformationagency
Description Operating fuel ethanol production plants in the United States.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
company character varying
site_name character varying
capacity numeric
state character varying
padd numeric
longitude numeric
latitude numeric
source character varying
data_perio date
Table hgl_pipelines_us_201703
Schema usenergyinformationagency
Description Major HGL pipelines in the United States. Layer includes interstate trunk lines and selected intrastate lines. Based on publicly available data from a variety of sources with varying scales and levels of accuracy.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
opername character varying
pipename character varying
shape_leng numeric
Table lng_impexp_terminals_us_201606
Schema usenergyinformationagency
Description Liquefied natural gas import/export terminals in the United States. The map excludes the import facility in Puerto Rico. These are defined as terminals capable of liquefaction of natural gas for transport or receipt and regasification of LNG for use as natural gas.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
facility character varying
owner character varying
operator character varying
city character varying
county character varying
state character varying
latitude numeric
longitude numeric
impexp character varying
period numeric
cap_bcfd numeric
liq_bcfd numeric
stora_mmcf numeric
source character varying
Table naturalgas_markethubs_us
Schema usenergyinformationagency
Description Natural gas market hubs in the contiguous United States. A hub is a physical transfer point for natural gas where several pipelines are connected. A market center is a hub where the operator offers services that facilitate the buying, selling, and transportation of natural gas.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
state character varying
adminstr character varying
operator character varying
typeoper character varying
yr_activat numeric
maxthru numeric
avgdaily numeric
numcust numeric
status character varying
notes character varying
city character varying
county_1 character varying
authority character varying
rates character varying
platform character varying
yearofdata numeric
latitude numeric
longitude numeric
Table naturalgas_pipelines_us_201703
Schema usenergyinformationagency
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
typepipe character varying
operator character varying
shape_leng numeric
Table naturalgas_processingplants_us_2014_v2
Schema usenergyinformationagency
Description Natural gas processing plants in the U.S. Map locations based on approximate zip code centroids.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
facility character varying
owner character varying
operator character varying
state character varying
county character varying
city character varying
zipcode numeric
plant_flow numeric
btu_conten character varying
dry_stor character varying
ngl_stor character varying
latitude numeric
longitude numeric
capa_mmcfd numeric
Table naturalgas_undergroundstorage_us_201607_v2
Schema usenergyinformationagency
Description U.S. underground natural gas storage fields. County centroid are used for map location.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
statename character varying
fld_code numeric
res_code numeric
field character varying
reservoir character varying
fld_type character varying
company character varying
county character varying
region character varying
status character varying
base_gas numeric
work_cap numeric
fld_cap numeric
maxdeliv numeric
source character varying
period numeric
latitude numeric
longitude numeric
Table petroleumproduct_pipelines_us_201703
Schema usenergyinformationagency
Description Major petroleum product pipelines in the United States. Layer includes interstate trunk lines and selected intrastate lines. Based on publicly available data from a variety of sources with varying scales and levels of accuracy.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
opername character varying
pipename character varying
shape_leng numeric
Table petroleumproduct_terminals_us_201608
Schema usenergyinformationagency
Description All operable bulk petroleum product terminals located in the 50 States and the District of Columbia with a total bulk shell storage capacity of 50,000 barrels or more, and/or ability to receive volumes from tanker, barge, or pipeline. Survey locations adjusted using public data.
Source organization U.S. Energy Information Agency
Source organization webpage https://www.eia.gov
Data source url https://www.eia.gov/maps/layer_info-m.php
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
company character varying
site character varying
state character varying
padd numeric
longitude numeric
latitude numeric
period numeric
Table us_padd
Schema usenergyinformationagency
Description The largest stockpile of government-owned emergency crude oil in the world, established in Bayou Choctaw and West Hackberry, LA and in Big Hill and Bryan Mound, TX to protect against disruptions in U.S. commercial oil supplies.
Source organization U.S. Department of Energy
Source organization webpage https://energy.gov/
Data source url https://energy.gov/fe/services/petroleum-reserves
Columns data type
ogc_fid integer
wkb_geometry USER-DEFINED
padd character varying
name character varying
source character varying
shape_leng numeric
shape_area numeric