Subsea Points - Removed (ETRS89)

North Sea Transition Authority

@ukgov.subsea_points_removed_etrs892

Table List

1 table(20.92 KB)

Table 1

@ukgov.subsea_points_removed_etrs892.table_1

20.92 KB
31 rows
23 columns

x X	y Y	objectid OBJECTID	name NAME	inf_type INF TYPE	rep_group REP GROUP	descriptio DESCRIPTIO	status STATUS	comments COMMENTS	point_desc POINT DESC	crs_code CRS CODE	crs_name CRS NAME	orig_x_lon ORIG X LON	orig_y_lat ORIG Y LAT	start_date START DATE	upd_date UPD DATE	upd_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID	feature_id FEATURE ID
2.02493530500004	54.084365045	5881	NORTH WEST SCHOONER	WELLHEAD	DNO NORTH SEA	WELLHEAD 44/26A- 7 NORTH WEST SCHOONER	REMOVED	Removed		23031	ED_1950_UTM_Zone_31N	436305.7	5993558.18	Tue May 22 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	No successful pass in Q1 2023	810001972	0b8522ef-5b82-4242-bfc8-8e86281ec729
-3.45514097699993	53.6010772060001	6007	110/13-3	WELLHEAD	ENI UK LIMITED	LBA Wellhead 110/13-3 in Hamilton East Reservoir ABANDONED (AB3)	REMOVED	Wellhead 110/13-3 in Hamilton East Reservoir (AB3 DECOM.)		23030	UTM30, ED50	469981.8	5939452.9		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	WELLHEAD DECOMMISSIONED AB3		98f94925-3770-4d9f-9f95-d2d8589e83f1
-3.45700319099996	53.5707282720001	6008	110/13-1	WELLHEAD	ENI UK LIMITED	LBA WELLHEAD 110/13-1 ABANDONED (AB3)	REMOVED	LBA WELLHEAD 110/13-1 (AB3 DECOM.)		23030	UTM30, ED50	469836.9	5936077.3		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	WELLHEAD DECOMMISSIONED AB3		4a9924b1-bd90-4906-9448-88a9495d5756
-3.19205151599994	53.641193806	6009	110/15-7	WELLHEAD	ENI UK LIMITED	LBA WELLEAD 110/15-7 ABANDONED (AB3)	REMOVED	LBA WELLEAD 110/15-7		23030	UTM30, ED50	487403.7	5943836.9		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	WELLHEAD DECOMMISSIONED AB3		b1cccff1-820e-4615-a75a-fe533741daa9
0.726276063000057	58.321575431	6317	MACCULLOCH PLEM	MANIFOLD	HARBOUR ENERGY PLC	MACCULLOCH PIPELINE END MANIFOLD	NOT IN USE	Asset transfer from ConocoPhillips to Chrysaor October 2019	Centre point	23031	ED_1950_UTM_Zone_31N	366914.33	6466974.73		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed	800011003	7956eedd-b3f8-4b56-9f21-cdf22605f562
0.727747829000066	58.3212370460001	6318	MACCULLOCH TIE-IN SKID	MANIFOLD	HARBOUR ENERGY PLC	MACCULLOCH TIE-IN SKID	NOT IN USE	Asset transfer from ConocoPhillips to Chrysaor October 2019		4230	GCS_European_1950	0.7293528	58.3218472		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed	800010506	b87cdddd-a5da-4c1d-af04-b5a6ada1c2f6
1.10820958500005	58.227901628	6334	BALMORAL RISER BASE RB02	RISER BASE	HARBOUR ENERGY PLC	BALMORAL RISER BASE RB02	ABANDONED			4326	GCS_WGS_1984	1.10819	58.22789	Mon Sep 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed	800009126	5f464801-ef6f-4764-801f-5bb8b39358f8
1.10842959700005	58.2280016340001	6335	BALMORAL RISER BASE RB03	RISER BASE	HARBOUR ENERGY PLC	BALMORAL RISER BASE RB03	ABANDONED			4326	GCS_WGS_1984	1.10841	58.22799	Mon Sep 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed	800009127	0e52a3f1-ed85-4b82-b47b-91a9f42d45c5
1.10567955700003	58.2295216590001	6344	BALMORAL RISER BASE RB06	RISER BASE	HARBOUR ENERGY PLC	BALMORAL RISER BASE RB06	ABANDONED			4326	GCS_WGS_1984	1.10566	58.22951	Mon Sep 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed	800009129	3fcc7bfc-f5ae-4161-acfa-7c2ff6f89d23
1.10859957800005	58.2280916400001	6354	BALMORAL RISER BASE RB04	RISER BASE	HARBOUR ENERGY PLC	BALMORAL RISER BASE RB04	ABANDONED			4326	GCS_WGS_1984	1.10858	58.22808	Mon Sep 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed	800009128	3ee5492e-906f-414c-ba95-300004b97cbf


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "descriptio" VARCHAR,
  "status" VARCHAR,
  "comments" VARCHAR,
  "point_desc" VARCHAR,
  "crs_code" BIGINT,
  "crs_name" VARCHAR,
  "orig_x_lon" DOUBLE,
  "orig_y_lat" DOUBLE,
  "protect_by" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "upd_date" TIMESTAMP,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "feature_id" VARCHAR
);