Surface Points - Removed (ETRS89)

North Sea Transition Authority

@ukgov.surface_points_removed_etrs892

Table List

1 table(18.67 KB)

Table 1

@ukgov.surface_points_removed_etrs892.table_1

18.67 KB
10 rows
24 columns

x X	y Y	objectid OBJECTID	feature_id FEATURE ID	name NAME	inf_type INF TYPE	rep_group REP GROUP	descriptio DESCRIPTIO	pipe_sys PIPE SYS	crs_code CRS CODE	crs_name CRS NAME	orig_x_lon ORIG X LON	orig_y_lat ORIG Y LAT	status STATUS	comments COMMENTS	start_date START DATE	end_date END DATE	end_reas END REAS	upd_date UPD DATE	upd_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID
-136.269306843	89.998906407	29	1cf35035-5917-459b-84e1-d6cd8aff02e8	BOOSTER PLATFORM 36/22A NORPIPE A.S	PLATFORM	CONOCOPHILLIPS	BOOSTER PLATFORM 36/22A NORPIPE A.S	Norpipe Oil Pipeline	4230	GCS_European_1950	0.2032017	55.2907125	REMOVED	Bypass of removed platform 36/22A				Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	REMOVED	700002351
-136.269306842	89.998906407	30	ee9ab494-003f-4e87-8998-289a7065cb7e	BOOSTER PLATFORM 37/4A NORPIPE A.S	PLATFORM	CONOCOPHILLIPS	BOOSTER PLATFORM 37/4A NORPIPE A.S	Norpipe Oil Pipeline	4230	GCS_European_1950	1.6118361	55.9001669	REMOVED	Bypass of removed platform 37/4A				Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	REMOVED	700002350
2.48840230800005	54.0494218970001	31	7adf1f6e-8409-4805-831c-1bb6c82a285f	KETCH	PLATFORM	DNO NORTH SEA	WELLHEAD STEEL		4326	GCS_WGS_1984	2.48835	54.0494167	REMOVED	Shut-in awaiting removal				Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	No successful pass in Q1 2023	700002083
2.07643871200003	54.059038795	32	aea1c605-a9c9-4e06-9413-4be6e8260191	SCHOONER A	PLATFORM	DNO NORTH SEA	WELLHEAD STEEL		4326	GCS_WGS_1984	2.0763833	54.0590333	REMOVED	Removed				Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	V42 FSIP submission - V37 FSIP submission - comments-duty	700002085
1.70476155100005	53.7621623060001	62	e4a1d16f-462b-426f-b39d-3f3440073b5a	48/9A MIMAS	PLATFORM	HARBOUR ENERGY PLC	MIMAS PLATFORM		23031	ED_1950_UTM_Zone_31N	414704.28	5958049.24	NOT IN USE	Platform is in cold suspension with no mobile hydrocarbons and is awaiting removal	Wed Jul 05 2006 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	700002603
2.05621320000006	53.650126567	63	0f393e82-d62f-4be3-a2b6-8ae23f8ddcee	49/11B TETHYS	PLATFORM	HARBOUR ENERGY PLC	TETHYS PLATFORM		23031	ED_1950_UTM_Zone_31N	437706.43	5945220	NOT IN USE	Platform is in cold suspension with no mobile hydrocarbons and is awaiting removal	Mon Jun 05 2006 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	700002605
-3.56231692999995	53.8752648460001	188	e08d6897-fd22-4b81-a452-ff8e10e75ae9	DP4 PLATFORM	PLATFORM	SPIRIT ENERGY	DP4 PLATFORM		23030	ED_1950_UTM_Zone_30N	463117	5970008	REMOVED	Jacket Removed 2023		Sat Jul 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Removed	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	Status and comments update	700003539
2.05484141800002	53.71566117	191	7569afb8-ecc6-4562-8850-dba71add4b7b	ANN TEMPLATE BUOY: KFB 17/2008	BUOY	SPIRIT ENERGY	ANN TEMPLATE BUOY: KINGFISHER FORTNIGHTLY BULLETIN 17/2008		4326	GCS_WGS_1984	2.0547667	53.71565	REMOVED	Position is 100 mtrs x 360 Degrees (T) from the template. No longer there.	Tue Aug 12 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jun 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Removed	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	Status and comments update	700002864
1.77337704100006	53.590542805	192	8c606fb1-2b89-4405-8994-e8a4cb86b6f3	ENSIGN PLATFORM	PLATFORM	SPIRIT ENERGY	ENSIGN NPAI PLATFORM		23031	ED_1950_UTM_Zone_31N	418898.05	5938876.7	REMOVED	Topside and Jacket removed in 2023	Fri Aug 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Removed	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	Status and comments update	700003356
1.23771504900003	57.9762716340001	221	18137851-e94d-4327-8df2-28b4d24c	HUMMINGBIRD FPSO	FPSO	TEEKAY PETROJARL	HUMMINGBIRD	Hummingbird FPSO	23031	ED_1950_UTM_Zone_31N	395857	6427641	ACTIVE	1st circular FPSO in North Sea, WG PSN operators - now Altera Infrastructure on behalf of THPL	Sun Dec 23 2007 00:00:00 GMT+0000 (Coordinated Universal Time)			Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	Teekay confirmed everything has been removed from the seabed - email 27/2/2023	700002800


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