Pipeline Freespans - Removed (WGS84)

North Sea Transition Authority

@ukgov.pipeline_freespans_removed_wgs843

Table List

1 table(15.42 KB)

Table 1

@ukgov.pipeline_freespans_removed_wgs843.table_1

15.42 KB
7 rows
21 columns

objectid OBJECTID	feature_id FEATURE ID	label LABEL	nstapipno NSTAPIPNO	pipe_name PIPE NAME	rep_group REP GROUP	freespanno FREESPANNO	length_m LENGTH M	mxheight_m MXHEIGHT M	comments COMMENTS	crs_code CRS CODE	crs_name CRS NAME	start_date START DATE	upd_date UPD DATE	upd_type UPD TYPE	upd_reas UPD REAS	survey_id SURVEY ID	shape_length Shape, Length	legacy_id LEGACY ID
56	8c22e606-740c-4ea0-bf94-d71870ac7ba7	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	59	11.85	5.18		23031	UTM31, ED50	Mon Nov 06 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	PIPELINE NO LONGER THERE	<Null>	0.0001831855873151	610002571
303	b9cea6fc-ee54-47b9-ba0a-692718b6b839	KP 7.792 - 7.808	PL023	Leman 49/27 AP to Bacton	PERENCO OIL & GAS		16	1	Span no longer present	23031	UTM31, ED50		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	Span no longer present	Q1 Interim Survey 2024	0.0002534052284582
304	1f6e64ad-d216-4faa-b8b9-d2283bccfa7b	KP 5.819 - 5.842	PL022	Inde 49/23 AT to Leman 49/27 BT	PERENCO OIL & GAS		23	0.8	Span no longer present	23031	UTM31, ED50		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	Span no longer present	Q1 Interim Survey 2024	0.0002581755156962
305	185046ef-36f9-4da2-8c6a-2175bd8bb97d	KP 165.227 - 165.243	PL253	Trent Elbow to Bacton	PERENCO OIL & GAS		16	1	Span no longer present	23031	UTM31, ED50		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	Span no longer present	Q4 Interim Survey 2023	0.0001762146237064
972	1193905b-31c7-40aa-9958-524a29f942c8	PL25	PL25	30" GAS LEMAN AP - BACTON	SHELL PLC		11.8	1.6	S0201	4326	WGS84	Tue May 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	SPAN NOT FOUND DURING 2023 API SURVEY	22-VI	0.0001680627334806
973	eb9888ce-5f34-4871-9850-32407a270593	PL1611	PL1611	4.5" METHANOL CORVETTE - LEMAN AP	SHELL PLC	79	10.92	1.16	S1011	4326	WGS84	Sun Aug 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	SPAN NOT FOUND DURING 2023 API SURVEY	11-VI	0.0001119330093627
974	bb42f3eb-67a7-44af-9faf-234e22ac1b27	PL632	PL632	24" GAS LEMAN CP - LEMAN BT	SHELL PLC	89	14	1.5	S0204	4326	WGS84	Wed Oct 10 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	SPAN NOT FOUND DURING 2023 API SURVEY	07-VI	0.000205066945074


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feature_id" VARCHAR,
  "label" VARCHAR,
  "nstapipno" VARCHAR,
  "pipe_name" VARCHAR,
  "rep_group" VARCHAR,
  "freespanno" BIGINT,
  "length_m" DOUBLE,
  "mxheight_m" DOUBLE,
  "comments" VARCHAR,
  "crs_code" BIGINT,
  "crs_name" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" VARCHAR,
  "end_reas" VARCHAR,
  "upd_date" TIMESTAMP,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "survey_id" VARCHAR,
  "shape_length" DOUBLE,
  "legacy_id" DOUBLE
);