SDC Offshore Infrastructure Structures

North Sea Transition Authority

@ukgov.sdc_offshore_infrastructure_structures3

Table List

1 table(414.84 KB)

Table 1

@ukgov.sdc_offshore_infrastructure_structures3.table_1

414.84 KB
6724 rows
22 columns

x X	y Y	objectid OBJECTID	inf_layer INF LAYER	feature_id FEATURE ID	name NAME	inf_type INF TYPE	rep_group REP GROUP	description DESCRIPTION	status STATUS	wdepth_m WDEPTH M	length_m LENGTH M	breadth_m BREADTH M	mass_t_air MASS T AIR	foundation FOUNDATION	pile_state PILE STATE	d_assumpt D ASSUMPT	d_maturity D MATURITY	comments COMMENTS	height_m HEIGHT M
1.53301122800002	61.4662205450001	1	Subsea Points	b3bdd29e-6b4b-4845-912d-688771f3	211/18a-S10	WELLHEAD	ENQUEST PLC	DON SOUTH WEST PRODUCTION WELL P6 DSW P06	NOT IN USE	160	3.5	3.9	120	PILED	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED		6
1.53250834200003	61.4662749720001	2	Subsea Points	275c376f-95cf-4d43-a834-5c40276b	211/18a-S14	WELLHEAD	ENQUEST PLC	DON SOUTH WEST PRODUCTION WELL P7 DSW P07	NOT IN USE	160	3.5	3.9	120	PILED	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED		6
1.53197826300004	61.466337653	3	Subsea Points	36b5384c-1b3a-4915-a41d-6ddc4307	211/18a-S15	WELLHEAD	ENQUEST PLC	DON SOUTH WEST PRODUCTION WELL P8 DSW P08 (Ythan P1)	NOT IN USE	160	3.5	3.9	120	PILED	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	Petrofac are duty holders, Enquest are owners	6
1.53197777700007	61.466158126	4	Subsea Points	011b77c7-2348-405a-9e9e-4cd23c6a	211/18a-S7	WELLHEAD	ENQUEST PLC	DON SOUTH WEST PRODUCTION WELL S7	NOT IN USE	160	3.5	3.9	120	PILED	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	Petrofac are duty holders, Enquest are owners	6
1.20378094900002	59.8919850600001	5	Subsea Points	4f0a7915-3ecf-4200-9354-43f6e07a	DC1 Production Manifold	MANIFOLD	ENQUEST PLC	DC1 Production Manifold	ACTIVE	116	29.65	8.87	237	GRAVITY	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED		5.98
1.20286650100007	59.891731984	6	Subsea Points	7e8dab72-dbda-429a-9c4f-dd13db16	DC1 Water Injection Manifold	MANIFOLD	ENQUEST PLC	DC1 Water Injection Manifold	ACTIVE	116	29.65	8.87	139	GRAVITY	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED		5.98
1.26263785900005	59.948238572	7	Subsea Points	06f97926-d1c2-40fa-ab23-e76a6122	DC3 Production Manifold	MANIFOLD	ENQUEST PLC	DC3 Production Manifold	ACTIVE	116	29.65	8.87	237	GRAVITY	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED		5.98
1.26215130800006	59.948696259	8	Subsea Points	5f382ea9-4ca5-4944-9ae7-f6f0bf07	DC3 Water Injection Manifold	MANIFOLD	ENQUEST PLC	DC3 Water Injection Manifold	ACTIVE	116	29.65	8.87	139	GRAVITY	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED		5.98
1.42811274400003	61.494112091	9	Subsea Points	f7618837-fa61-49a9-8899-55053491	211/18a-W6	WELLHEAD	ENQUEST PLC	West Don W02 WI Well	NOT IN USE						INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED
1.58081626400002	61.365696997	10	Subsea Points	40a05f56-5fa5-41b8-8949-d24726fc	Thistle COS Tank B	STORAGE TANK	ENQUEST PLC	Wet Stored Crude Oil Storage Tank B	NOT IN USE	165	91.4	10	1017	GRAVITY	INTACT	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED		10


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "inf_layer" VARCHAR,
  "feature_id" VARCHAR,
  "name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "point_desc" VARCHAR,
  "description" VARCHAR,
  "status" VARCHAR,
  "wdepth_m" DOUBLE,
  "length_m" DOUBLE,
  "breadth_m" DOUBLE,
  "mass_t_air" DOUBLE,
  "foundation" VARCHAR,
  "pile_state" VARCHAR,
  "d_assumpt" VARCHAR,
  "d_maturity" VARCHAR,
  "comments" VARCHAR,
  "d_comments" VARCHAR,
  "height_m" DOUBLE
);