Subsea Points - Removed (WGS84)

North Sea Transition Authority

@ukgov.subsea_points_removed_wgs842

Table List

1 table(20.92 KB)

Table 1

@ukgov.subsea_points_removed_wgs842.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_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID	feature_id FEATURE ID	upd_date UPD DATE
2.02492112000004	54.084356552	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)	REMOVE	No successful pass in Q1 2023	810001972	0b8522ef-5b82-4242-bfc8-8e86281ec729	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
-3.45514821399996	53.601067196	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		REMOVE	WELLHEAD DECOMMISSIONED AB3		98f94925-3770-4d9f-9f95-d2d8589e83f1	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
-3.45701039099993	53.5707182960001	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		REMOVE	WELLHEAD DECOMMISSIONED AB3		4a9924b1-bd90-4906-9448-88a9495d5756	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
-3.19205915599997	53.6411838540001	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		REMOVE	WELLHEAD DECOMMISSIONED AB3		b1cccff1-820e-4615-a75a-fe533741daa9	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
0.726256663000072	58.3215635650001	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		REMOVE	2024_03 Physically Removed	800011003	7956eedd-b3f8-4b56-9f21-cdf22605f562	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
0.727728428000034	58.321225181	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		REMOVE	2024_03 Physically Removed	800010506	b87cdddd-a5da-4c1d-af04-b5a6ada1c2f6	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.10819006400004	58.227890034	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)	REMOVE	2024_03 Physically Removed	800009126	5f464801-ef6f-4764-801f-5bb8b39358f8	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.10841007500005	58.2279900400001	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)	REMOVE	2024_03 Physically Removed	800009127	0e52a3f1-ed85-4b82-b47b-91a9f42d45c5	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.10566003400004	58.2295100630001	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)	REMOVE	2024_03 Physically Removed	800009129	3fcc7bfc-f5ae-4161-acfa-7c2ff6f89d23	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.10858005600005	58.2280800460001	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)	REMOVE	2024_03 Physically Removed	800009128	3ee5492e-906f-414c-ba95-300004b97cbf	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)


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_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "feature_id" VARCHAR,
  "upd_date" TIMESTAMP
);