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

RailroadCommissionOfTexas

Table gp_county
Text name GP County
Schema railroadcommissionoftexas
Description General purpose table that stores county information.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
county_no character
county_fips_code character
county_name character varying
district_no character
district_name character
on_shore_flag character
onshore_assc_cnty_flag character
Table gp_date_range_cycle
Text name GP Date Range Cycle
Schema railroadcommissionoftexas
Description General-purpose table of PDQ data range ( Jan. 1993-current Prod month/year).
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oldest_prod_cycle_year_month character varying
newest_prod_cycle_year_month character varying
newest_sched_cycle_year_month character varying
gas_extract_date date
oil_extract_date date
Table gp_district
Text name GP District
Schema railroadcommissionoftexas
Description General-purpose table that contains district information.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
district_no character
district_name character
office_phone_no character varying
office_location character varying
Table og_county_cycle
Text name OG County Cycle
Schema railroadcommissionoftexas
Description This table stores range of dates. The year/month that pertains to county data.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
county_no character
district_no character
cycle_year character
cycle_month character
cycle_year_month character varying
cnty_oil_prod_vol bigint
cnty_oil_allow bigint
cnty_oil_ending_bal bigint
cnty_gas_prod_vol bigint
cnty_gas_allow bigint
cnty_gas_lift_inj_vol bigint
cnty_cond_prod_vol bigint
cnty_cond_limit bigint
cnty_cond_ending_bal bigint
cnty_csgd_prod_vol bigint
cnty_csgd_limit bigint
cnty_csgd_gas_lift bigint
cnty_oil_tot_disp bigint
cnty_gas_tot_disp bigint
cnty_cond_tot_disp bigint
cnty_csgd_tot_disp bigint
county_name character varying
district_name character varying
oil_gas_code character
Table og_county_lease_cycle
Text name OG County Lease Cycle
Schema railroadcommissionoftexas
Description This table stores range of dates. Pertains to county and lease information.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oil_gas_code character
district_no character
lease_no character varying
cycle_year character
cycle_month character
county_no character
operator_no character varying
field_no character varying
cycle_year_month character varying
field_type character
gas_well_no character varying
prod_report_filed_flag character
cnty_lse_oil_prod_vol integer
cnty_lse_oil_allow integer
cnty_lse_oil_ending_bal integer
cnty_lse_gas_prod_vol integer
cnty_lse_gas_allow integer
cnty_lse_gas_lift_inj_vol integer
cnty_lse_cond_prod_vol integer
cnty_lse_cond_limit integer
cnty_lse_cond_ending_bal integer
cnty_lse_csgd_prod_vol integer
cnty_lse_csgd_limit integer
cnty_lse_csgd_gas_lift integer
cnty_lse_oil_tot_disp integer
cnty_lse_gas_tot_disp integer
cnty_lse_cond_tot_disp integer
cnty_lse_csgd_tot_disp integer
district_name character
lease_name character varying
operator_name character varying
field_name character varying
county_name character varying
Table og_district_cycle
Text name OG District Cycle
Schema railroadcommissionoftexas
Description This table stores range of dates. Pertains to district.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
district_no character
cycle_year character
cycle_month character
cycle_year_month character varying
district_name character
dist_oil_prod_vol integer
dist_gas_prod_vol integer
dist_cond_prod_vol integer
dist_csgd_prod_vol integer
Table og_field_cycle
Text name OG Field Cycle
Schema railroadcommissionoftexas
Description This Table contains data on a field by cycle date.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
district_no character
field_no character varying
cycle_year character
cycle_month character
cycle_year_month character varying
district_name character
field_name character varying
field_oil_prod_vol integer
field_gas_prod_vol integer
field_cond_prod_vol integer
field_csgd_prod_vol integer
Table og_field_dw
Text name OG Field Dw
Schema railroadcommissionoftexas
Description Table of field identifying data.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
field_no character varying
field_name character varying
district_no character
district_name character
field_class character
field_h2s_flag character
field_manual_rev_flag character
wildcat_flag character
o_derived_rule_type_code character
g_derived_rule_type_code character
o_rescind_dt date
g_rescind_dt character varying
o_salt_dome_flag character
g_salt_dome_flag character
o_offshore_code character
g_offshore_code character
o_dont_permit character
g_dont_permit character
o_noa_man_rev_rule character varying
g_noa_man_rev_rule character varying
o_county_no character
g_county_no character
o_discovery_dt date
g_discovery_dt date
o_sched_remarks character varying
g_sched_remarks character varying
o_comments character varying
g_comments character varying
create_by character varying
create_dt date
modify_by character varying
modify_dt date
Table og_lease_cycle
Text name OG Lease Cycle
Schema railroadcommissionoftexas
Description This table stores production data on a lease by cycle date.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oil_gas_code character
district_no character
lease_no character varying
cycle_year character
cycle_month character
cycle_year_month character varying
lease_no_district_no bigint
operator_no character varying
field_no character varying
field_type character
gas_well_no character varying
prod_report_filed_flag character
lease_oil_prod_vol integer
lease_oil_allow integer
lease_oil_ending_bal integer
lease_gas_prod_vol integer
lease_gas_allow integer
lease_gas_lift_inj_vol integer
lease_cond_prod_vol integer
lease_cond_limit integer
lease_cond_ending_bal integer
lease_csgd_prod_vol integer
lease_csgd_limit integer
lease_csgd_gas_lift integer
lease_oil_tot_disp integer
lease_gas_tot_disp integer
lease_cond_tot_disp integer
lease_csgd_tot_disp integer
district_name character
lease_name character varying
operator_name character varying
field_name character varying
Table og_lease_cycle_disp
Text name OG Lease Cycle Disp
Schema railroadcommissionoftexas
Description This table stores production data on a lease by cycle that includes all disposition codes.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oil_gas_code character
district_no character
lease_no character varying
cycle_year character
cycle_month character
operator_no character varying
field_no character varying
cycle_year_month character varying
lease_oil_dispcd00_vol integer
lease_oil_dispcd01_vol integer
lease_oil_dispcd02_vol integer
lease_oil_dispcd03_vol integer
lease_oil_dispcd04_vol integer
lease_oil_dispcd05_vol integer
lease_oil_dispcd06_vol integer
lease_oil_dispcd07_vol integer
lease_oil_dispcd08_vol integer
lease_oil_dispcd09_vol integer
lease_oil_dispcd99_vol integer
lease_gas_dispcd01_vol integer
lease_gas_dispcd02_vol integer
lease_gas_dispcd03_vol integer
lease_gas_dispcd04_vol integer
lease_gas_dispcd05_vol integer
lease_gas_dispcd06_vol integer
lease_gas_dispcd07_vol integer
lease_gas_dispcd08_vol integer
lease_gas_dispcd09_vol integer
lease_gas_dispcd99_vol integer
lease_cond_dispcd00_vol integer
lease_cond_dispcd01_vol integer
lease_cond_dispcd02_vol integer
lease_cond_dispcd03_vol integer
lease_cond_dispcd04_vol integer
lease_cond_dispcd05_vol integer
lease_cond_dispcd06_vol integer
lease_cond_dispcd07_vol integer
lease_cond_dispcd08_vol integer
lease_cond_dispcd99_vol integer
lease_csgd_dispcde01_vol integer
lease_csgd_dispcde02_vol integer
lease_csgd_dispcde03_vol integer
lease_csgd_dispcde04_vol integer
lease_csgd_dispcde05_vol integer
lease_csgd_dispcde06_vol integer
lease_csgd_dispcde07_vol integer
lease_csgd_dispcde08_vol integer
lease_csgd_dispcde99_vol integer
district_name character
lease_name character varying
operator_name character varying
field_name character varying
Table og_operator_cycle
Text name OG Operator Cycle
Schema railroadcommissionoftexas
Description This table stores production data for operators leases by cycle date.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
operator_no character varying
cycle_year character
cycle_month character
cycle_year_month character varying
operator_name character varying
oper_oil_prod_vol integer
oper_gas_prod_vol integer
oper_cond_prod_vol integer
oper_csgd_prod_vol integer
Table og_operator_dw
Text name OG Operator Dw
Schema railroadcommissionoftexas
Description This table contains identifying operator Information.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
operator_no character varying
operator_name character varying
p5_status_code character
p5_last_filed_dt character varying
operator_tax_cert_flag character
operator_sb639_flag character
fa_option_code character
record_status_code character
efile_status_code character
efile_effective_dt date
create_by character varying
create_dt date
modify_by character varying
modify_dt date
Table og_regulatory_lease_dw
Text name OG Regulatory Lease Dw
Schema railroadcommissionoftexas
Description This table contains identifying lease Information.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oil_gas_code character
district_no character
lease_no character varying
district_name character
lease_name character varying
operator_no character varying
operator_name character varying
field_no character varying
field_name character varying
well_no character varying
lease_off_sched_flag character
lease_severance_flag character
Table og_summary_master_large
Text name OG Summary Master Large
Schema railroadcommissionoftexas
Description Summary table. (Used for query purposes at the operator level)
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oil_gas_code character
district_no character
lease_no character varying
operator_no character varying
field_no character varying
cycle_year_month_min integer
cycle_year_month_max integer
district_name character
lease_name character varying
operator_name character varying
field_name character varying
Table og_summary_onshore_lease
Text name OG Summary Onshore Lease
Schema railroadcommissionoftexas
Description Summary table. (Used for query purposes on the leases in on-shore counties)
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oil_gas_code character
district_no character
lease_no character varying
operator_no character varying
field_no character varying
cycle_year_month_min integer
cycle_year_month_max integer
lease_name character varying
operator_name character varying
field_name character varying
Table og_well_completion
Text name OG Well Completion
Schema railroadcommissionoftexas
Description This table contains identifying well-bore information.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oil_gas_code character
district_no character
lease_no character varying
well_no character varying
api_county_code character
api_unique_no character varying
onshore_assc_cnty character
district_name character
county_name character varying
oil_well_unit_no character varying
well_root_no character varying
wellbore_shutin_dt character varying
well_shutin_dt character varying
well_14b2_status_code character
well_subject_14b2_flag character
wellbore_location_code character
Table og_well_cycle
Text name OG Well Cycle
Schema railroadcommissionoftexas
Description For future use.
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Field descriptions Field descriptions
Columns data type
oil_gas_code character
district_no character
lease_no character varying
cycle_year character
cycle_month character
well_no character varying
cycle_year_month character varying
api_county_code character
api_unique character
onshore_assc_cnty character
well_type_code character
well_allow_vol integer
well_potential integer
oil_well_unit_no character
gas_well_word_allow_text character varying
well_allow_code character
well_producing_method character
well_est_percent_lease_prod numeric
wellbore_location_code character
delq_form_status_flag character
district_name character
county_name character varying
Table pr_pending_lease
Text name PR Pending Lease
Schema railroadcommissionoftexas
Description ..
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Columns data type
pending_lease_id integer
production_report_id integer
gas_well_no character varying
drill_permit_no character varying
lease_name character varying
field_name character varying
api_no character varying
remarks text
modified_by character varying
modified_dt timestamp without time zone
Table pr_production_report
Text name PR Production Report
Schema railroadcommissionoftexas
Description ..
Source organization Railroad Commission of Texas
Source organization webpage http://www.rrc.state.tx.us/
Data source url http://www.rrc.state.tx.us/about-us/resource-center/research/data-sets-available-for-purchase/
Columns data type
production_report_id integer
prod_cycle_yyyymm integer
crctd_filing_flag character varying
cmgl_lease_tot_flag character varying
current_month_flag character varying
stock_trnsfr_flag character varying
is_deleted_flag character varying
workflow_state_code character varying
report_medium_code character varying
edi_filer_key character varying
oil_or_gas_code character varying
district_no character varying
lease_no character varying
lease_id character varying
filing_operator_id integer
filing_operator_no integer
posted_dt timestamp without time zone
received_dt timestamp without time zone
universal_doc_no integer
cmgl_permit_no integer
cmgl_group_id integer
cmgl_permit_one_time_use_rmrk text
locked_by character varying
liq_prod_vol real
gas_prod_vol real
beginning_soh_vol real
ending_soh_vol real
drv_sepext_loss_vol real
drv_sepext_loss_factor real
liq_disp_00_vol real
liq_disp_01_vol real
liq_disp_02_vol real
liq_disp_03_vol real
liq_disp_03_remark text
liq_disp_04_vol real
liq_disp_04_remark text
liq_disp_05_vol real
liq_disp_06_vol real
liq_disp_06_remark text
liq_disp_07_vol real
liq_disp_08_vol real
liq_disp_09_vol real
liq_disp_71_vol real
liq_disp_72_vol real
liq_disp_73_vol real
liq_disp_74_vol real
liq_disp_75_vol real
liq_disp_75_remark text
liq_disp_null_code_vol real
gas_disp_01_vol real
gas_disp_02_vol real
gas_disp_03_vol real
gas_disp_04_vol real
gas_disp_04_remark text
gas_disp_05_vol real
gas_disp_06_vol real
gas_disp_07_vol real
gas_disp_07_plant_name character varying
gas_disp_08_vol real
gas_disp_09_vol real
gas_disp_null_code_vol real
cond_no_gas_remark text
lgcy_oldest_eom_vol real
lgcy_gaslft_injct_vol real
batch_no integer
item_id integer
modified_by character varying
modified_dt timestamp without time zone
bridge_type character varying
bridge_dt timestamp without time zone
resp_error_code character varying
create_dt timestamp without time zone
bridge_attempt_count character varying
on_top_flag character varying
on_top_dt timestamp without time zone

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