Pipelines Linear (ETRS89)

North Sea Transition Authority

@ukgov.pipelines_linear_etrs893

Table List

1 table(651.48 KB)

Table 1

@ukgov.pipelines_linear_etrs893.table_1

651.48 KB
6514 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	int_diam INT DIAM	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	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)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510000999	Y	N	Y	0.114994959239566	Y
2	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)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510001001	Y	N	Y	0.119909558447365	N
3	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)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510000999	Y	N	Y	0.104011690645043	N
4	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)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510001001	Y	N	Y	0.108923341711509	N
5	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)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510001000	Y	N	Y	0.114146200085867	N
6	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)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		510001000	Y	N	Y	0.128498874160527	N
7	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	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	Improved accuracy of feature geometry/attributes		Y	Y	Y	0.613857032626205	N
8	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)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	UPDATED DESCRIPTION	510004681	N	Y	Y	0.0003676581876936	N
9	9a4efd55-38ea-4781-b97e-0069724884e6	PL1716	COOK TO ANASURIA PRODUCTION PIPELINE	RISER	ANASURIA OPERATING COMPANY LIMITED	OIL		COOK TO ANASURIA 6IN PRODUCTION PIPELINE	ACTIVE		271	395	152.4			23090	TM 0 N, ED50	Sat Oct 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHNAGE SINCE PREVIOUS SUBMISSION		N	Y	Y	0.0030251295522931	N
10	7baf4cd7-244e-4f95-992d-00864ffa1811	PL1234	ANASURIA FPSO TO FULMAR	RISER	ANASURIA OPERATING COMPANY LIMITED	GAS		ANASURIA FPSO TO FULMAR 8IN GAS LINE	ACTIVE		301	380	203			23090	TM 0 N, ED50	Sat Oct 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHNAGE SINCE PREVIOUS SUBMISSION		N	Y	Y	0.0045348801843386	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
);