Dataset: NSTA Field Production Points, PPRS (WGS84)

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-06-14T04:00:06Z

Tables

Table 1

@ukgov.nsta_field_production_points_pprs_wgs845.table_1

7.23 MB
129939 rows
48 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "field_name" VARCHAR,
  "field_region" VARCHAR,
  "onshore_offshore_flag" VARCHAR,
  "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_volume_m3" DOUBLE,
  "oil_production_volume_mb_d" DOUBLE,
  "oil_production_density_kg_m3" DOUBLE,
  "associated_gas_production_mass_tonnes" DOUBLE,
  "associated_gas_production_volume_ksm3" DOUBLE,
  "associated_gas_production_volume_mmscf_d" DOUBLE,
  "associated_gas_production_density_kg_sm3" DOUBLE,
  "dry_gas_production_mass_tonnes" DOUBLE,
  "dry_gas_production_volume_ksm3" DOUBLE,
  "dry_gas_production_volume_mmscf_d" DOUBLE,
  "dry_gas_production_density_kg_sm3" DOUBLE,
  "gas_condensate_mass_tonnes" DOUBLE,
  "gas_condensate_volume_m3" DOUBLE,
  "gas_condensate_volume_mb_d" DOUBLE,
  "gas_condensate_density_kg_m3" DOUBLE,
  "gas_injected_cv_mj_sm3" DOUBLE,
  "gas_injected_volume_ksm3" DOUBLE,
  "gas_flared_volume_ksm3" DOUBLE,
  "gas_flared_density_kg_sm3" DOUBLE,
  "gas_flared_non_hydrocarbon" DOUBLE,
  "gas_vented_volume_ksm3" DOUBLE,
  "gas_vented_density_kg_sm3" DOUBLE,
  "gas_vented_non_hydrocarbon" DOUBLE,
  "injected_water_volume_m3" DOUBLE,
  "injected_water_volume_mb_d" DOUBLE,
  "produced_water_volume_m3" DOUBLE,
  "produced_water_volume_mb_d" DOUBLE,
  "reinjected_produced_water_volume_m3" DOUBLE,
  "gas_to_pipeline_cv_mj_sm3" DOUBLE,
  "gas_to_pipeline_volume_ksm3" DOUBLE,
  "gas_to_pipeline_volume_mmscf_d" DOUBLE,
  "gas_to_pipeline_density_kg_sm3" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);