Proof of concept. This is an unofficial demo built by Datopian from the North Sea Transition Authority's public data. The official portal is NSTA Open Data. Questions or feedback: hello@datopian.com

UKCS SDC 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 see Oil and Gas Authority User Agreement .

Records
567
Formats
4
Last updated
2 Jul 2025

Download & API

UKCS SDC infrastructure pipelines (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
UKCS SDC infrastructure pipelines (GeoParquet)geoparquet
Columnar — query with DuckDB / SQL
Download
UKCS SDC infrastructure pipelines (map tiles)pmtiles
Vector tiles — embed in a map
Download
Live ArcGIS layer (source)arcgis
Download

Rendered from PMTiles, queried in-browser from GeoParquet — no server. How this works

Schema

FieldTypeValues
Infrastructure layer
INF_LAYER
string1 values: Pipelines (567)
Description
DESCRIPTIO
string
Feature ID
FEATURE_ID
string
NSTA pipeline number
NSTAPIPNO
string
Pipeline name
PIPE_NAME
string
Infrastructure type
INF_TYPE
string3 values: PIPELINE (413), UMBILICAL (151), RISER (3)
Reporting group name
REP_GROUP
string4 values: TAQA EUROPA B.V. (173), CNR INTERNATIONAL (142), ENQUEST PLC (129)…
Fluid
FLUID
string10 values: WATER (108), GAS (105), OIL (96)…
Pipeline system name
PIPE_SYS
string
Status
STATUS
string3 values: ACTIVE (380), NOT IN USE (133), ABANDONED (54)
Comments
COMMENTS
string
Diameter (mm)
DIAMETERMM
number0 to 1,206
Length (m)
LENGTH_M
number7 to 210,404
Insulation coating type
INSUL_TYPE
string5 values: THREE LAYER (224), N/A (58), FUSION BONDED EPOXY (53)…
Internal diameter (mm)
INT_DIAM
number0 to 775
Wall thickness (mm)
THICKNESS
number0 to 102
Name
NAME
string
Pipeline material
P_MATERIAL
string7 values: STEEL (256), COMPOSITE (200), API 5LX (22)…
Multi flag
MULTI_FLG
string5 values: SINGULAR (285), PIGGY-BACK (24), BUNDLE (19)…
Trenched?
TRENCHED
string4 values: Y (211), N (147), n (113)…
Burial status
BURIAL_ST
string6 values: FULLY EXPOSED (176), BURIED >0.6M (116), BURIED >0.6M WITH EXPOSURES (74)…
Anomalies
ANOMALIES
string2 values: N (76), Y (73)
Decomm basis assumptions
D_ASSUMPT
string4 values: DECOMMISSION IN SITU (209), FULL REMOVAL (195), PARTIAL REMOVAL (75)…
Decomm basis maturity
D_MATURE
string3 values: COMPARATIVE ASSESSMENT NOT COMPLETED (242), COMPARATIVE ASSESSMENT COMPLETED (132), DECOMMISSIONING PROGRAMME APPROVED (36)
Decomm basis comments
D_COMMENTS
string
Deposits group 1: type of deposit
TYPE1
string2 values: BOLLARD (265), CONCRETE MATTRESS (193)
Deposits group 1 length (m)
LENGTH_M1
number5 to 158
Deposits group 1 breadth (m)
BREADTH_M1
number1.00 to 8.00
Deposits group 1 height (m)
HEIGHT_M1
number0.15 to 4.40
Deposits group 1 weight (tonnes in air)
MASS_AIR_1
number10 to 499
Deposits group 1 quantity of items
QUANTITY1
number1 to 101
Deposits group 1 burial status
BURIAL_ST1
string1 values: FULLY EXPOSED (178)
Deposits group 1 decomm assumptions
D_ASSUMPT1
string2 values: FULL REMOVAL (192), OUT OF SCOPE (4)
Deposits group 1: decomm basis maturity
D_MATURE1
string3 values: COMPARATIVE ASSESSMENT COMPLETED (132), COMPARATIVE ASSESSMENT NOT COMPLETED (45), DECOMMISSIONING PROGRAMME APPROVED (21)
Deposits group 1: from KP
FROM_KP_1
number0.00 to 73.04
Deposits group 1: to KP
TO_KP_1
number0 to 147
Deposits group 2: type of deposit
TYPE2
string2 values: CONCRETE MATTRESS (265), GROUT BAG (165)
Deposits group 2: length (m)
LENGTH_M2
number0 to 10,000
Deposits group 2: breadth (m)
BREADTH_M2
number0 to 3,000
Deposits group 2: height (m)
HEIGHT_M2
number0 to 350
Deposits group 2: weight (tonnes in air)
MASS_AIR_2
number0.03 to 10.79
Deposits group 2: quantity of items
QUANTITY2
number1 to 621
Deposits group 2: burial status
BURIAL_ST2
string5 values: FULLY EXPOSED (113), 0.011 (2), 1.688 (2)…
Deposits group 2: decomm basis assumptions
D_ASSUMPT2
string6 values: DECOMMISSION IN SITU (34), FULL REMOVAL (6), 1.746 (2)…
Deposits group 2: decomm basis maturity
D_MATURE2
string2 values: COMPARATIVE ASSESSMENT COMPLETED (132), COMPARATIVE ASSESSMENT NOT COMPLETED (81)
Deposits group 2: from KP
FROM_KP_2
number0.00 to 27.68
Deposits group 2: to KP
TO_KP_2
number0 to 147
Deposits group 3: type of deposit
TYPE3
string2 values: FROND MATTRESS (265), GRAVEL/ROCK/SAND BAG (20)
Deposits group 3: length (m)
LENGTH_M3
number
Deposits group 3: breadth (m)
BREADTH_M3
number
Deposits group 3: height (m)
HEIGHT_M3
number
Deposits group 3: weight (tonnes in air)
MASS_AIR_3
number
Deposits group 3: quantity of items
QUANTITY3
number5 to 440
Deposits group 3: burial status
BURIAL_ST3
string1 values: FULLY EXPOSED (20)
Deposits group 3: decomm basis assumptions
D_ASSUMPT3
string
Deposits group 3: decomm basis maturity
D_MATURE3
string
Deposits group 3: from KP
FROM_KP_3
number0.00 to 15.99
Deposits group 3: to KP
TO_KP_3
number0.03 to 16.40
Deposits group 4: type of deposit
TYPE4
string1 values: GRAVEL/ROCK/SAND BAG (267)
Deposits group 4: length (m)
LENGTH_M4
number
Deposits group 4: breadth (m)
BREADTH_M4
number
Deposits group 4: height (m)
HEIGHT_M4
number
Deposits group 4: weight (tonnes in air)
MASS_AIR_4
number4 to 2,482,667
Deposits group 4: quantity of items
QUANTITY4
number4 to 15,000
Deposits group 4: burial status
BURIAL_ST4
string1 values: FULLY EXPOSED (6)
Deposits group 4: decomm basis assumptions
D_ASSUMPT4
string2 values: FULL REMOVAL (3), DECOMMISSION IN SITU (2)
Deposits group 4: decomm basis maturity
D_MATURE4
string1 values: COMPARATIVE ASSESSMENT NOT COMPLETED (4)
Deposits group 4: from KP
FROM_KP_4
number0.00 to 3.22
Deposits group 4: to KP
TO_KP_4
number0.01 to 15.95
Deposits group 5: type of deposit
TYPE5
string1 values: GROUT BAG (265)
Deposits group 5: length (m)
LENGTH_M5
number
Deposits group 5: breadth (m)
BREADTH_M5
number
Deposits group 5: height (m)
HEIGHT_M5
number
Deposits group 5: weight (tonnes in air)
MASS_AIR_5
number0.03 to 1.00
Deposits group 5: quantity of items
QUANTITY5
number3 to 3,000
Deposits group 5: burial status
BURIAL_ST5
string1 values: FULLY EXPOSED (14)
Deposits group 5: decomm basis assumptions
D_ASSUMPT5
string2 values: DECOMMISSION IN SITU (10), FULL REMOVAL (4)
Deposits group 5: decomm basis maturity
D_MATURE5
string1 values: COMPARATIVE ASSESSMENT NOT COMPLETED (14)
Deposits group 5: from KP
FROM_KP_5
number0.00 to 7.00
Deposits group 5: to KP
TO_KP_5
number0.20 to 21.00
Deposit comments
DEP_COM
string