SDC Offshore Infrastructure Pipelines

North Sea Transition Authority

@ukgov.sdc_offshore_infrastructure_pipelines3

Table List

1 table(123.74 KB)

Table 1

@ukgov.sdc_offshore_infrastructure_pipelines3.table_1

123.74 KB
567 rows
82 columns

objectid OBJECTID	inf_layer INF LAYER	description DESCRIPTION	feature_id FEATURE ID	nstapipno NSTAPIPNO	pipe_name PIPE NAME	inf_type INF TYPE	rep_group REP GROUP	fluid FLUID	pipe_sys PIPE SYS	status STATUS	comments COMMENTS	diametermm DIAMETERMM	length_m LENGTH M	insul_type INSUL TYPE	int_diam INT DIAM	thickness THICKNESS	name NAME	p_material P MATERIAL	multi_flg MULTI FLG	trenched TRENCHED	burial_st BURIAL ST	anomalies ANOMALIES	d_assumpt D ASSUMPT	d_comments D COMMENTS	type1 TYPE1	type2 TYPE2	length_m2 LENGTH M2	breadth_m2 BREADTH M2	height_m2 HEIGHT M2	quantity2 QUANTITY2	burial_st2 BURIAL ST2	type3 TYPE3	type4 TYPE4	mass_t_air4 MASS T AIR4	type5 TYPE5	mass_t_air5 MASS T AIR5	quantity5 QUANTITY5	dep_com DEP COM
1	Pipelines	NORTH ALWYN A (NAA) TO ALWYN SUBSEA BARRIER VALVE (SBV)	1136b223-23e2-41b6-a5e1-4e40990c	PL336	ALWYN GAS EXPORT - RISER	RISER	TOTALENERGIES UPSTREAM UK LIMITED	GAS		ACTIVE		610	300			27	ALWYN GAS EXPORT - RISER	STEEL	SINGULAR	N		Y	FULL REMOVAL	2 OPEN ANOMALIES - DEBRIS X 1; PHYSICAL DAMAGE X 1	BOLLARD	CONCRETE MATTRESS						FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG
2	Pipelines	ELGIN PUQ TO GE SSIV 34" GAS EXPORT (GE) TO SEAL PL1570	bc144cd0-65d7-4ef9-842d-00dbc8ca	PL1570A	ELGIN PUQ TO GE SSIV (SEAL PL1570)	RISER	TOTALENERGIES UPSTREAM UK LIMITED	GAS	SEAL	ACTIVE	Laid on seabed, mattress protection on spools	868	465			20	ELGIN PUQ TO GE SSIV (SEAL PL1570)	STEEL	SINGULAR	N	FULLY EXPOSED	N	FULL REMOVAL		BOLLARD	CONCRETE MATTRESS	5	3	0.15	227	FULLY EXPOSED	FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG	0.025	40	Mattresses deployed along the length of the Riser tie-in Spools from platfrom to SSIV at various locations. Grout Bags are 25kg each, does not reviger at colume CE (Mass)
3	Pipelines	NUGGETS N1 MANIFOLD TO NUGGETS NGA WELLHEAD 2" HYDRATE INHIBITOR	59634800-2511-4e77-a0ad-13ed27e7	PL1821	NUGGETS NGA UMB (FROM N1)	UMBILICAL	TOTALENERGIES UPSTREAM UK LIMITED	OTHER FLUID		ACTIVE	concrete mattresses over entire length	84	80				NUGGETS NGA UMB (FROM N1)	COMPOSITE	SINGULAR	N		N	FULL REMOVAL		BOLLARD	CONCRETE MATTRESS						FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG
4	Pipelines	NUGGETS N3 MANIFOLD TO NUGGETS NGD WELLHEAD ELECTRO-HYDRAULIC UNBILICAL	b4a4f0c7-31f2-49e3-a977-a425cecb	PL1825	NUGGETS NGD UMB (FROM N3)	UMBILICAL	TOTALENERGIES UPSTREAM UK LIMITED	OTHER FLUID		ACTIVE	concrete mattresses over entire length	84	80				NUGGETS NGD UMB (FROM N3)	COMPOSITE	SINGULAR	Y		N	FULL REMOVAL		BOLLARD	CONCRETE MATTRESS						FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG
5	Pipelines	GRYPHON RISER BASE D TO FRAMO MANIFOLD AT GRYPHON CLUSTER	8ce3b99a-82a1-4c73-89c1-4fad40e4	PLU2987	GRYPHON FRAMO CONTRAOL UMBILICAL	UMBILICAL	TOTALENERGIES UPSTREAM UK LIMITED	OTHER FLUID		ACTIVE		133	1595				GRYPHON FRAMO CONTRAOL UMBILICAL	COMPOSITE	SINGULAR	Y		Y	FULL REMOVAL	1 OPEN ANOMALIES - LACK OF SUPPORT X 1	BOLLARD	CONCRETE MATTRESS	6	3	0.015	6	FULLY EXPOSED	FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG	0.025	400	Protection Deposits are deployed at the FPSO the tie-in locations
6	Pipelines	GRYPHON FPSO TO NGRY METERING SKID	cb710378-515d-4f67-9d44-3181c1b5	PLU2995	NORTH GRYPHON UMBILICAL	UMBILICAL	TOTALENERGIES UPSTREAM UK LIMITED	OTHER FLUID		ACTIVE		133	1945				NORTH GRYPHON UMBILICAL	COMPOSITE	SINGULAR	Y		N	FULL REMOVAL		BOLLARD	CONCRETE MATTRESS	6	3	0.015	120	FULLY EXPOSED	FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG	0.025	400	Protection Deposits are deployed at either end of Pipeline at the tie-in locations
7	Pipelines	CUT TAIL: BOTTOM OF MCP01 TO VACINITY OF PL06S TIE IN TO PL2026 = 920M	8e3df224-42cf-47e5-8e4c-da0ef7b5	PL6C	CUT TAIL AT MCP01 BASE - TO SOUTH	PIPELINE	TOTALENERGIES UPSTREAM UK LIMITED	GAS		ABANDONED	ON DPR/IPR SINCE 2004	813	950	CONCRETE	775	19	CUT TAIL AT MCP01 BASE - TO SOUTH	STEEL	SINGULAR	N		N	OUT OF SCOPE		BOLLARD	CONCRETE MATTRESS						FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG
8	Pipelines	CUT TAIL: BOTTOM OF MCP01 TO VACINITY OF PL06N TIE IN TO PL2026 = 950M	a6d092c7-223f-44c7-bda2-204acab9	PL6B	CUT TAIL AT MCP01 BASE - TO NORTH	PIPELINE	TOTALENERGIES UPSTREAM UK LIMITED	GAS		ABANDONED	ON DPN/IPR SINCE 2004	813	950	CONCRETE	775	19	CUT TAIL AT MCP01 BASE - TO NORTH	STEEL	SINGULAR	N		N	OUT OF SCOPE		BOLLARD	CONCRETE MATTRESS						FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG
9	Pipelines	CUT TAIL: BOTTOM OF FRIGG TP01 RISER TO VACINITY OF FRIGG TP1 BYPASS SKID = 3000M	a6d092c7-223f-44c7-bda2-204acab9	PL6A	CUT TAIL AT FRIGG TP01 PLATFORM	PIPELINE	TOTALENERGIES UPSTREAM UK LIMITED	GAS		ABANDONED	ON DPN/IPR SINCE 2004	813	3000	CONCRETE	775	19	CUT TAIL AT FRIGG TP01 PLATFORM	STEEL	SINGULAR	Y		N	OUT OF SCOPE		BOLLARD	CONCRETE MATTRESS						FROND MATTRESS	GRAVEL/ROCK/SAND BAG		GROUT BAG
10	Pipelines	CUT TAIL: BOTTOM OF FRIGG TP01 RISER TO VACINITY OF FRIGG TP1 BYPASS SKID = 3500M	7878e775-3088-495e-ad2b-55b41514	PL336A	CUT TAIL AT FRIGG TP01 PLATFORM	PIPELINE	TOTALENERGIES UPSTREAM UK LIMITED	GAS		ABANDONED	ON DPN/IPR SINCE 2004	610	3500	COAL TAR ENAMEL	556	27	CUT TAIL AT FRIGG TP01 PLATFORM	STEEL	SINGULAR	Y		N	DECOMMISSION IN SITU		BOLLARD	CONCRETE MATTRESS						FROND MATTRESS	GRAVEL/ROCK/SAND BAG	80	GROUT BAG			Rockdump at cut end of disused pipline tail


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,
  "to_kp_1" DOUBLE,
  "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,
  "to_kp_2" DOUBLE,
  "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,
  "to_kp_3" DOUBLE,
  "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,
  "to_kp_4" DOUBLE,
  "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,
  "to_kp_5" DOUBLE,
  "dep_com" VARCHAR
);