Pipelines Linear (ED50)

North Sea Transition Authority

@ukgov.pipelines_linear_ed503

Table List

1 table(808.19 KB)

Table 1

@ukgov.pipelines_linear_ed503.table_1

808.19 KB
8142 rows
35 columns

objectid OBJECTID	feature_id FEATURE ID	nstapipno NSTAPIPNO	pipe_name PIPE NAME	inf_type INF TYPE	rep_group REP GROUP	fluid FLUID	pipe_sys PIPE SYS	descriptio DESCRIPTIO	status STATUS	comments COMMENTS	diametermm DIAMETERMM	length_m LENGTH M	bundle BUNDLE	bundle_flg BUNDLE FLG	crs_code CRS CODE	crs_name CRS NAME	start_date START DATE	untrenched UNTRENCHED	exposed EXPOSED	upd_date UPD DATE	upd_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID	rep_owner REP OWNER	rep_opertr REP OPERTR	rep_holder REP HOLDER	shape_length Shape, Length	simplified SIMPLIFIED
1	e5042657-47bb-442a-b92b-90c1c6f05f84	PL2190	ALVHEIM GAS EXPORT PIPELINE	PIPELINE	AKER BP ASA	GAS	SAGE	ALVHEIM GAS EXPORT PIPELINE	ACTIVE	Gas Export from Alvheim FPSO, Line feature , operated by Aker BP ASA	355.6	36534.1424698			23031	ED_1950_UTM_Zone_31N	Thu Jun 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	T	B	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			Y	Y	Y	0.613841854234308	N
2	5365b617-3516-49fa-87dd-1034c531986d	PL3083	BRYNHILD TO PIERCE PRODUCTION	PIPELINE	AKER BP ASA	OIL		BRYNHILD TO PIERCE INSULATED PRODUCTION PIPELINE (10 PIPE IN PIPE)	ABANDONED	Decommissioning Programme approved by BEIS on 11/06/2020	254	36797.420583			23031	ED_1950_UTM_Zone_31N	Sun May 25 2014 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510000999	Y	N	Y	0.11499092264307	Y
3	678f3c80-e1f0-4700-bbdd-ceaaec5a9cb5	PLU3085	BRYNHILD TO PIERCE CONTROL UMBILICAL	UMBILICAL	AKER BP ASA	OTHER FLUID		BRYNHILD TO PIERCE CONTROL UMBILICAL	ABANDONED	Decommissioning Programme approved by BEIS on 11/06/2020	127	37103.174425	510000999	P	23031	ED_1950_UTM_Zone_31N	Sun Aug 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510001001	Y	N	Y	0.119905348898805	N
4	5365b617-3516-49fa-87dd-1034c531986d	PL3083	BRYNHILD TO PIERCE PRODUCTION	PIPELINE	AKER BP ASA	WATER		BRYNHILD TO PIERCE INSULATED PRODUCTION PIPELINE (10 PIPE IN PIPE)	ABANDONED	Decommissioning Programme approved by BEIS on 11/06/2020	254	36797.42058329			23031	ED_1950_UTM_Zone_31N	Sun May 25 2014 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510000999	Y	N	Y	0.104007925766509	N
5	678f3c80-e1f0-4700-bbdd-ceaaec5a9cb5	PLU3085	BRYNHILD TO PIERCE CONTROL UMBILICAL	UMBILICAL	AKER BP ASA	OTHER FLUID		BRYNHILD TO PIERCE CONTROL UMBILICAL	ABANDONED	Decommissioning Programme approved by BEIS on 11/06/2020. Updated PWA Category 2 variation is currently evaluated by OGA.	127	37103.17442454	510000999	P	23031	ED_1950_UTM_Zone_31N	Sun Aug 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510001001	Y	N	Y	0.108919503703468	N
6	284caf0a-a13f-41b9-8cec-251f8fca594a	PL3084	BRYNHILD TO PIERCE WATER INHECTION	PIPELINE	AKER BP ASA	WATER		PIERCE TO BRYNHILD 6 ID WATER INJECTION PIPELINE	NOT IN USE	Decommissioning Programme approved by BEIS on 11/06/2020. Updated PWA Category 2 variation is currently evaluated by OGA.	152.4	37967.28718086			23031	ED_1950_UTM_Zone_31N	Sat Jun 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510001000	Y	N	Y	0.114142815960765	N
7	284caf0a-a13f-41b9-8cec-251f8fca594a	PL3084	BRYNHILD TO PIERCE WATER INJECTION	PIPELINE	AKER BP ASA	WATER		PIERCE TO BRYNHILD 6 ID WATER INJECTION PIPELINE	NOT IN USE	Decommissioning Programme approved by BEIS on 11/06/2020. Updated PWA Category 2 variation is currently evaluated by OGA.	152.4	37967.28718086			23031	ED_1950_UTM_Zone_31N	Sat Jun 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510001000	Y	N	Y	0.128495005295386	N
8	64135bf0-c214-4bbd-9ea9-a13b8edc5fb8	PL1240.1	GUILLEMOT A-WELL GUA-W1 5" WATER	PIPELINE	ANASURIA OPERATING COMPANY LIMITED	WATER		DISUSED 5IN WATER INJECTION LINE	NOT IN USE	LAID ASIDE ON SEABED TO EAST OF CLUSTER	200	59.59991974			23090	TM 0 N, ED50	Sat Oct 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	UPDATED COMMENT	500004288	N	Y	Y	0.0005578045202205	N
9	5a3a633b-f278-4250-8562-a7aa271669a2	PL1235	PL1235 TEAL COOL SPOOL TO VALVE SKID	PIPELINE	ANASURIA OPERATING COMPANY LIMITED	OIL		TEAL COOL SPOOL TO VALVE SKID 8IN OIL LINE	ACTIVE		219.1	28.92193883			23090	TM 0 N, ED50	Sat Oct 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHNAGE SINCE PREVIOUS SUBMISSION	510004681	N	Y	Y	0.0003676513740331	N
10	f348ddf8-0b9d-40b8-bfd2-52817cd7eb95	PL1237-.5	TEAL WI UTA TO TEAL PRODUCTION WELL UMBILICAL	RISER	ANASURIA OPERATING COMPANY LIMITED	OTHER FLUID		TEAL WATER INJECTION UTA TO TEAL PRODUCTION WELL 5IN CONTROL UMBILICAL	ACTIVE	MULTICORE UMBILICAL	208.5	287			23090	TM 0 N, ED50	Sat Oct 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	UPDATED COMMENT AND NSTAPIPNO		N	Y	Y	0.0019394038445432	N


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
);