About this Dataset

NSTA Field Production Points, PPRS (WGS84)

Contains recent and historic production data for Oil Tanker to Loader, Dry Gas Fields, Oil Field Exporting to Pipeline, and Onshore Oil Field unit types.

PON 7 and petroleum reporting is handled under the PPRS (Petroleum Production Reporting System) system. The submission guidance on this system describes the data requirements and format for the reporting of hydrocarbon production from offshore and onshore fields and terminals in the UK. The PPRS system was enhanced on 9 June 2017.

Click to view column names or a unique list of reporting units used in the data.
Publisher name: North Sea Transition Authority
Last updated: 2025-07-01T04:00:34Z

Tables

Table 1

@ukgov.nsta_field_production_points_pprs_wgs845.table_1

7.44 MB
130,281 rows
48 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "field_name" VARCHAR,
  "field_region" VARCHAR,
  "onshore_offshore_flag" VARCHAR  -- Onshore, Offshore Flag,
  "operator_organisation_group" VARCHAR,
  "reporting_unit_name" VARCHAR,
  "reporting_unit_type_code" VARCHAR,
  "reporting_unit_type_description" VARCHAR,
  "reporting_period_in_yyyymm_format" BIGINT,
  "reporting_period_year" BIGINT,
  "reporting_period_month" BIGINT,
  "reporting_period_month_name" VARCHAR,
  "reporting_period_date" VARCHAR,
  "oil_production_mass_tonnes" DOUBLE  -- Oil Production - Mass (tonnes),
  "oil_production_volume_m3" DOUBLE  -- Oil Production - Volume (m3),
  "oil_production_volume_mb_d" DOUBLE  -- Oil Production - Volume (mb/d),
  "oil_production_density_kg_m3" DOUBLE  -- Oil Production - Density (Kg/m3),
  "associated_gas_production_mass_tonnes" DOUBLE  -- Associated Gas Production - Mass (tonnes),
  "associated_gas_production_volume_ksm3" DOUBLE  -- Associated Gas Production - Volume (Ksm3),
  "associated_gas_production_volume_mmscf_d" DOUBLE  -- Associated Gas Production - Volume (MMscf/d),
  "associated_gas_production_density_kg_sm3" DOUBLE  -- Associated Gas Production - Density (Kg/sm3),
  "dry_gas_production_mass_tonnes" DOUBLE  -- Dry Gas Production - Mass (tonnes),
  "dry_gas_production_volume_ksm3" DOUBLE  -- Dry Gas Production - Volume (Ksm3),
  "dry_gas_production_volume_mmscf_d" DOUBLE  -- Dry Gas Production - Volume (MMscf/d),
  "dry_gas_production_density_kg_sm3" DOUBLE  -- Dry Gas Production - Density (Kg/sm3),
  "gas_condensate_mass_tonnes" DOUBLE  -- Gas Condensate - Mass (tonnes),
  "gas_condensate_volume_m3" DOUBLE  -- Gas Condensate - Volume (m3),
  "gas_condensate_volume_mb_d" DOUBLE  -- Gas Condensate - Volume (mb/d),
  "gas_condensate_density_kg_m3" DOUBLE  -- Gas Condensate - Density (Kg/m3),
  "gas_injected_cv_mj_sm3" DOUBLE  -- Gas Injected - CV (MJ/sm3),
  "gas_injected_volume_ksm3" DOUBLE  -- Gas Injected - Volume (Ksm3),
  "gas_flared_volume_ksm3" DOUBLE  -- Gas Flared - Volume (Ksm3),
  "gas_flared_density_kg_sm3" DOUBLE  -- Gas Flared - Density (Kg/sm3),
  "gas_flared_non_hydrocarbon" DOUBLE  -- Gas Flared - Non Hydrocarbon (%),
  "gas_vented_volume_ksm3" DOUBLE  -- Gas Vented - Volume (Ksm3),
  "gas_vented_density_kg_sm3" DOUBLE  -- Gas Vented - Density (Kg/sm3),
  "gas_vented_non_hydrocarbon" DOUBLE  -- Gas Vented - Non Hydrocarbon (%),
  "injected_water_volume_m3" DOUBLE  -- Injected Water - Volume (m3),
  "injected_water_volume_mb_d" DOUBLE  -- Injected Water - Volume (mb/d),
  "produced_water_volume_m3" DOUBLE  -- Produced Water - Volume (m3),
  "produced_water_volume_mb_d" DOUBLE  -- Produced Water - Volume (mb/d),
  "reinjected_produced_water_volume_m3" DOUBLE  -- Reinjected Produced Water - Volume (m3),
  "gas_to_pipeline_cv_mj_sm3" DOUBLE  -- Gas To Pipeline - CV (MJ/sm3),
  "gas_to_pipeline_volume_ksm3" DOUBLE  -- Gas To Pipeline - Volume (Ksm3),
  "gas_to_pipeline_volume_mmscf_d" DOUBLE  -- Gas To Pipeline - Volume (MMscf/d),
  "gas_to_pipeline_density_kg_sm3" DOUBLE  -- Gas To Pipeline - Density (Kg/sm3),
  "x" DOUBLE,
  "y" DOUBLE
);