SDC Offshore Pipeline Points

North Sea Transition Authority

@ukgov.sdc_offshore_pipeline_points3

Table List

1 table(59.17 KB)

Table 1

@ukgov.sdc_offshore_pipeline_points3.table_1

59.17 KB
97 rows
80 columns

x X	y Y	objectid OBJECTID	inf_layer INF LAYER	description DESCRIPTION	feature_id FEATURE ID	name NAME	inf_type INF TYPE	rep_group REP GROUP	status STATUS	trenched_y_n TRENCHED Y N	burial_status BURIAL STATUS	d_assumpt D ASSUMPT	d_mature D MATURE	d_comments D COMMENTS	type1 TYPE1	type2 TYPE2	type3 TYPE3	type4 TYPE4	type5 TYPE5
1.13597618000006	61.0520099290001	1	Pipelines	BRENT A(PL17) JUNCTION WITH PL114 AND PL352 IGLOO	c3d22657-729e-4f44-8ca4-7e06246f	WLGS SYSTEM WELGAS JUNCTION (shell owned)	PIPE JUNCTION	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
1.12729993700003	61.0334176160001	2	Pipelines	SSIV 16" valve within manifold	6ff3d207-a6d2-4dd0-983e-7ebf06d3	Pelican	VALVE	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
1.10724241700007	61.159835022	3	Pipelines	CORMORANT A PRESSURE BALANCE SAFETY JT ON PL168/N0703/N0704 is in the protective igloo UMC end. 2 on each line (4 total)	1266c59e-049d-4027-b12c-0dd48ac2	Cormorant Alpha 24" OIL (2X3") BUNDLE UMC - CORMORANT A PL168/N0703/N0704	VALVE	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
1.10708998600006	61.1603337380001	4	Pipelines	CORMORANT A PRESSURE BALANCE SAFETY JT ON PL167/N0705 is in the protective igloo UMC end	25a7db3e-7935-41dd-b148-8b821487	CORMORANT A PRESSURE BALANCE SAFETY JT ON UMC PL167/N0705	VALVE	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
1.10685949700007	61.1604306450001	5	Pipelines	CORMORANT A PRESSURE BALANCE SAFETY JT ON PL210/N0706 is in the protective igloo UMC end	22b2b5ae-f784-4928-93cd-122c5cb4	CORMORANT A PRESSURE BALANCE SAFETY JT ON UMC PL210/N0706	VALVE	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
1.07021141000007	61.1031863600001	6	Pipelines	CORMORANT A PRESSURE BALANCE SAFETY JT ON PL210/N0706 is in the protective igloo CA end	625a3889-abb0-42e9-981b-a3bba9c4	CORMORANT A PRESSURE BALANCE SAFETY JT ON UMC PL210/N0706	VALVE	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
0.918392059000041	61.2741254300001	7	Pipelines	Western Isles SSIV (Dana's)	9e525124-500d-49b3-83c5-c4613cf0	Tern WI -SSIV	VALVE	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
1.15210011500005	61.2388534580001	8	Pipelines	SSIV	1cb51106-3d80-43c4-97e4-962a31f4	North Cormorant	VALVE	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
0.918550044000028	61.2737535520001	9	Pipelines	SSIV Manifold in TERN 500m Zone	a0eab3e4-ba78-496d-9347-cc62af83	Cladhan	VALVE	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG
1.54840753000002	59.276404648	10	Pipelines	PLEM Structure	e49fc36e-f546-4729-8693-d497eca8	Harding	PIPE JUNCTION	TAQA EUROPA B.V.	ACTIVE	N	FULLY EXPOSED	FULL REMOVAL	COMPARATIVE ASSESSMENT NOT COMPLETED	No CA required - all strucutres to be removed	BOLLARD	CONCRETE MATTRESS	FROND MATTRESS	GRAVEL/ROCK/SAND BAG	GROUT BAG


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "inf_layer" VARCHAR,
  "description" VARCHAR,
  "feature_id" VARCHAR,
  "name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "pipe_sys" VARCHAR,
  "status" VARCHAR,
  "comments" VARCHAR,
  "point_desc" VARCHAR,
  "length_m" DOUBLE,
  "diametermm" DOUBLE,
  "thickness" DOUBLE,
  "pipe_material" VARCHAR,
  "insul_type" VARCHAR,
  "trenched_y_n" VARCHAR,
  "burial_status" VARCHAR,
  "anomalies" VARCHAR,
  "d_assumpt" VARCHAR,
  "d_mature" VARCHAR,
  "d_comments" VARCHAR,
  "type1" VARCHAR,
  "length_m1" VARCHAR,
  "breadth_m1" VARCHAR,
  "height_m1" VARCHAR,
  "mass_t_air1" VARCHAR,
  "quantity1" VARCHAR,
  "burial_st1" VARCHAR,
  "d_assumpt1" VARCHAR,
  "d_mature1" VARCHAR,
  "from_kp_1" VARCHAR,
  "to_kp_1" VARCHAR,
  "type2" VARCHAR,
  "length_m2" VARCHAR,
  "breadth_m2" VARCHAR,
  "height_m2" VARCHAR,
  "mass_t_air2" VARCHAR,
  "quantity2" VARCHAR,
  "burial_st2" VARCHAR,
  "d_assumpt2" VARCHAR,
  "d_mature2" VARCHAR,
  "from_kp_2" VARCHAR,
  "to_kp_2" VARCHAR,
  "type3" VARCHAR,
  "length_m3" VARCHAR,
  "breadth_m3" VARCHAR,
  "height_m3" VARCHAR,
  "mass_t_air3" VARCHAR,
  "quantity3" VARCHAR,
  "burial_st3" VARCHAR,
  "d_assumpt3" VARCHAR,
  "d_mature3" VARCHAR,
  "from_kp_3" VARCHAR,
  "to_kp_3" VARCHAR,
  "type4" VARCHAR,
  "length_m4" VARCHAR,
  "breadth_m4" VARCHAR,
  "height_m4" VARCHAR,
  "mass_t_air4" VARCHAR,
  "quantity4" VARCHAR,
  "burial_st4" VARCHAR,
  "d_assumpt4" VARCHAR,
  "d_mature4" VARCHAR,
  "from_kp_4" DOUBLE,
  "to_kp_4" DOUBLE,
  "type5" VARCHAR,
  "length_m5" VARCHAR,
  "breadth_m5" VARCHAR,
  "height_m5" VARCHAR,
  "mass_t_air5" VARCHAR,
  "quantity5" VARCHAR,
  "burial_st5" VARCHAR,
  "d_assumpt5" VARCHAR,
  "d_mature5" VARCHAR,
  "from_kp_5" VARCHAR,
  "to_kp_5" VARCHAR,
  "dep_com" VARCHAR
);