Subsea Points (WGS84)

North Sea Transition Authority

@ukgov.subsea_points_wgs842

Table List

1 table(903.55 KB)

Table 1

@ukgov.subsea_points_wgs842.table_1

903.55 KB
10774 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.29037594900007	57.1638625030001	1	PIERCE PRODUCTION PIPELINE PLET	MANIFOLD	AKER BP ASA	PIERCE PRODUCTION PIPELINE PLET	ABANDONED	STRUCTURE CENTRE COMPLETELY WITHIN 500M SAFETY ZONE	CENTRE	23090	ED_1950_TM_0_N	638605.326	6338170.452	Thu Jun 26 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	Transfer from Lundin to Aker BP due to merger	810004876	0d435317-7f7f-4eed-9e70-d44285505c85	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
2.29132488100004	57.162797756	2	BRYNHILD RISER BASE MANIFOLD	MANIFOLD	AKER BP ASA	BRYNHILD RISER BASE MANIFOLD	ABANDONED	STRUCTURE CENTRE COMPLETELY WITHIN 500M SAFETY ZONE	CENTRE	23090	ED_1950_TM_0_N	638666.683	6338053.893	Fri Sep 26 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	Transfer from Lundin to Aker BP due to merger	810004733	29e521ba-01cd-4aa8-983a-22d6fed6ec4d	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
2.29129693700003	57.16280793	3	BRYNHILD RISER BASE MANIFOLD	MANIFOLD	AKER BP ASA	RISER BASE MANIFOLD AT PIERCE	ABANDONED			23031	ED_1950_UTM_Zone_31N	457227.78	6335945.06	Sun May 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	Transfer from Lundin to Aker BP due to merger	810001453	d88d1cbf-fc09-481d-a96b-ba463b199b00	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
2.29191101500004	57.1622532420001	4	BRYNHILD PILE P2	OTHER (SUBSEA)	AKER BP ASA	BRYNHILD PILE P2	NOT IN USE	STRUCTURE CENTRE COMPLETELY WITHIN 500M SAFETY ZONE	CENTRE	23090	ED_1950_TM_0_N	638704.16	6337994.49	Fri Sep 19 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	Transfer from Lundin to Aker BP due to merger	810004732	f4523dc4-ebb3-4c84-9b69-0eb70f2919e7	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
2.29240151500005	57.1616487650001	5	BRYNHILD PILE P1	OTHER (SUBSEA)	AKER BP ASA	BRYNHILD PILE P1	NOT IN USE	STRUCTURE CENTRE COMPLETELY WITHIN 500M SAFETY ZONE	CENTRE	23090	ED_1950_TM_0_N	638736.08	6337928.22	Fri Sep 19 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	Transfer from Lundin to Aker BP due to merger	810004731	5603753e-f973-4f89-bacb-68ca43fdbcbf	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
1.38971408600003	59.4781205450001	6	Concrete Mattress	PROTECTION	AKER BP ASA	CONCRETE MATTRESS	ACTIVE		Concrete Mattress covering pipeline	23031	ED_1950_UTM_Zone_31N	408868	6594612	Thu Jun 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			d442dfba-9928-4ec9-a7a7-2a79e75d1420	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
1.38940936800003	59.478133573	7	Concrete Mattress	PROTECTION	AKER BP ASA	CONCRETE MATTRESS	ACTIVE		Concrete Mattress covering pipeline	23031	ED_1950_UTM_Zone_31N	408851	6594616	Thu Jun 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			eab81aec-a6b7-42e3-b4c4-c80072f304e7	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
1.38960927800002	59.4781222650001	8	Concrete Mattress	PROTECTION	AKER BP ASA	CONCRETE MATTRESS	ACTIVE		Concrete Mattress covering pipeline	23031	ED_1950_UTM_Zone_31N	408862	6594612	Thu Jun 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			bda57783-3318-4cb7-a60f-c63c4857e403	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
1.38950861200004	59.4781262170001	9	Concrete Mattress	PROTECTION	AKER BP ASA	CONCRETE MATTRESS	ACTIVE		Concrete Mattress covering pipeline	23031	ED_1950_UTM_Zone_31N	408856	6594616	Thu Jun 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			f2706ebf-39c7-4610-b5f8-811b5eabc189	Thu Sep 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)
0.808934986000054	57.255161071	10	GUILLEMOT RISER BASE AT FPSO ANASURIA	RISER BASE	ANASURIA OPERATING COMPANY LIMITED	GUILLEMOT RISER BASE AT FPSO ANASURIA	ACTIVE			23090	TM 0 N, ED50	548900.239	6346296.898	Sun Jan 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	AMENDED NAME AND DESCRIPTION	800008570	2b3467d4-2c24-47df-841d-8a6e033e6338	Thu Sep 21 2023 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
);