Dataset: Pipelines Linear (ETRS89)

About this Dataset

Pipelines Linear (ETRS89)

NSTA Infrastructure Data is a set of data reported to the NSTA by relevant persons pursuant to Section 34 of the 2016 Energy Act. The data represents physical structures and facilities installed on the UKCS in fulfilment of relevant persons’ licence, field operations or pipeline works authorisation (PWA) related activities. The data is currently updated on a 6 monthly cycle (April / October). Data includes surface installations, subsea infrastructure, pipelines and pipeline freespans.

Warning: Due to the 254 character limit of shapefile downloads, some attributes within this dataset will be truncated when downloading as a shapefile.
Publisher name: North Sea Transition Authority
Last updated: 2025-06-14T04:00:08Z

Tables

Table 1

@ukgov.pipelines_linear_etrs894.table_1

651.48 KB
6514 rows
35 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feature_id" VARCHAR,
  "nstapipno" VARCHAR,
  "pipe_name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "fluid" VARCHAR,
  "pipe_sys" VARCHAR,
  "descriptio" VARCHAR,
  "status" VARCHAR,
  "comments" VARCHAR,
  "diametermm" DOUBLE,
  "length_m" DOUBLE,
  "insul_type" VARCHAR,
  "int_diam" DOUBLE,
  "mx_op_pres" DOUBLE,
  "thickness" DOUBLE,
  "bundle" DOUBLE,
  "bundle_flg" VARCHAR,
  "crs_code" DOUBLE,
  "crs_name" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "untrenched" VARCHAR,
  "exposed" VARCHAR,
  "upd_date" TIMESTAMP,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "rep_owner" VARCHAR,
  "rep_opertr" VARCHAR,
  "rep_holder" VARCHAR,
  "shape_length" DOUBLE,
  "simplified" VARCHAR
);