Pipeline Freespans (ETRS89)

North Sea Transition Authority

@ukgov.pipeline_freespans_etrs893

Table List

1 table(89.69 KB)

Table 1

@ukgov.pipeline_freespans_etrs893.table_1

89.69 KB
1010 rows
21 columns

objectid OBJECTID	feature_id FEATURE ID	label LABEL	nstapipno NSTAPIPNO	pipe_name PIPE NAME	rep_group REP GROUP	length_m LENGTH M	mxheight_m MXHEIGHT M	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
1	82816c91-9114-4065-94c5-d496b049f866	PL2225A	PL2225	BBL BALGZAND TO BACTON	BBL COMPANY	61	0.82	23028	UTM31, ED50	Mon Oct 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	Span identified in 2022 survey	2022 MBES Survey	0.0008922191160029
2	29795ccc-db2b-4e5b-86cc-674fe28c525b	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	41	0.91	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0006145931843176
3	765b5af4-ce15-41f5-b247-6ec8573653dc	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	33	1.02	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0005149556669082
4	bc89dc36-7816-444b-89a9-d4780fe48af9	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	40	0.88	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0006255524626082
5	e9300911-40e4-4895-8c75-1ab70baeef00	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	33	1.07	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0005352540075627
6	8942b8d7-9cd8-435e-8348-8e1a28245a33	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	30	1.24	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0004769141346812
7	85cff7eb-7179-496a-bebc-d1a87777ab35	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	39	1.1	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0006023094101173
8	8fce54f7-2833-41e8-b466-9be61c33cb46	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	49	0.81	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0007573369561991
9	d48dd4fe-2d8d-4bde-aa2c-9691c02e5c89	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	43	0.98	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0004082694162792
10	26223fe2-7eb5-457a-98dc-73f2009df938	PL720 - MLR30	PL720	MILLER TO ST. FERGUS	BP EXPLORATION	47	1.07	23031	UTM31, ED50	Fri Jan 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	snapped to pipeline	2022 GVI Survey	0.0007182018875631


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feature_id" VARCHAR,
  "label" VARCHAR,
  "nstapipno" VARCHAR,
  "pipe_name" VARCHAR,
  "rep_group" VARCHAR,
  "freespanno" DOUBLE,
  "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
);