About this Dataset

SDC Offshore Infrastructure Pipelines

Subsea Decommissioning Collaboration (SDC) Offshore Infrastructure in the North Sea and United Kingdom Continental Shelf (UKCS).

The Subsea Decommissioning Collaboration (SDC) dataset is a point in time dataset. The dataset was created by merging data voluntarily provided by SDC operators with publicly available data provided to the NSTA under the Energy Act 2016, s.34(1). The dataset has been created for the purposes of supporting the SDC in its goal of reducing subsea infrastructure decommissioning costs and to pilot the provision of additional information to the NSTA. The dataset has not been quality checked or assured by the NSTA, and assumes all information entered by the operators to be correct. There are no plans for this dataset to be updated and it should only be used for indicative purposes only. For further information on the use of NSTA open data seeOil and Gas Authority User Agreement.
Publisher name: North Sea Transition Authority
Last updated: 2025-06-14T04:00:08Z

Tables

Table 1

@ukgov.sdc_offshore_infrastructure_pipelines5.table_1

126.71 kB
567 rows
82 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "inf_layer" VARCHAR,
  "description" VARCHAR,
  "feature_id" VARCHAR,
  "nstapipno" VARCHAR,
  "pipe_name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "fluid" VARCHAR,
  "pipe_sys" VARCHAR,
  "status" VARCHAR,
  "comments" VARCHAR,
  "diametermm" DOUBLE,
  "length_m" DOUBLE,
  "insul_type" VARCHAR,
  "int_diam" DOUBLE,
  "thickness" DOUBLE,
  "name" VARCHAR,
  "p_material" VARCHAR,
  "multi_flg" VARCHAR,
  "trenched" VARCHAR,
  "burial_st" VARCHAR,
  "anomalies" VARCHAR,
  "d_assumpt" VARCHAR,
  "d_mature" VARCHAR,
  "d_comments" VARCHAR,
  "type1" VARCHAR,
  "length_m1" DOUBLE,
  "breadth_m1" DOUBLE,
  "height_m1" DOUBLE,
  "mass_t_air1" DOUBLE,
  "quantity1" DOUBLE,
  "burial_st1" VARCHAR,
  "d_assumpt1" VARCHAR,
  "d_mature1" VARCHAR,
  "from_kp_1" DOUBLE  -- FROM, KP 1,
  "to_kp_1" DOUBLE  -- TO, KP 1,
  "type2" VARCHAR,
  "length_m2" DOUBLE,
  "breadth_m2" DOUBLE,
  "height_m2" DOUBLE,
  "mass_t_air2" DOUBLE,
  "quantity2" DOUBLE,
  "burial_st2" VARCHAR,
  "d_assumpt2" VARCHAR,
  "d_mature2" VARCHAR,
  "from_kp_2" DOUBLE  -- FROM, KP 2,
  "to_kp_2" DOUBLE  -- TO, KP 2,
  "type3" VARCHAR,
  "length_m3" DOUBLE,
  "breadth_m3" DOUBLE,
  "height_m3" DOUBLE,
  "mass_t_air3" DOUBLE,
  "quantity3" DOUBLE,
  "burial_st3" VARCHAR,
  "d_assumpt3" DOUBLE,
  "d_mature3" DOUBLE,
  "from_kp_3" DOUBLE  -- FROM, KP 3,
  "to_kp_3" DOUBLE  -- TO, KP 3,
  "type4" VARCHAR,
  "length_m4" DOUBLE,
  "breadth_m4" DOUBLE,
  "height_m4" DOUBLE,
  "mass_t_air4" DOUBLE,
  "quantity4" DOUBLE,
  "burial_st4" VARCHAR,
  "d_assumpt4" VARCHAR,
  "d_mature4" VARCHAR,
  "from_kp_4" DOUBLE  -- FROM, KP 4,
  "to_kp_4" DOUBLE  -- TO, KP 4,
  "type5" VARCHAR,
  "length_m5" DOUBLE,
  "breadth_m5" DOUBLE,
  "height_m5" DOUBLE,
  "mass_t_air5" DOUBLE,
  "quantity5" DOUBLE,
  "burial_st5" VARCHAR,
  "d_assumpt5" VARCHAR,
  "d_mature5" VARCHAR,
  "from_kp_5" DOUBLE  -- FROM, KP 5,
  "to_kp_5" DOUBLE  -- TO, KP 5,
  "dep_com" VARCHAR
);