Subsea Points (ETRS89)

North Sea Transition Authority

@ukgov.subsea_points_etrs892

Table List

1 table(1.36 MB)

Table 1

@ukgov.subsea_points_etrs892.table_1

1.36 MB
18038 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.29039441300006	57.1638729050001	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		810004876	0d435317-7f7f-4eed-9e70-d44285505c85
2.29134334400004	57.162808157	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		810004733	29e521ba-01cd-4aa8-983a-22d6fed6ec4d
2.29131540000003	57.162818331	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		810001453	d88d1cbf-fc09-481d-a96b-ba463b199b00
2.29192947700005	57.162263642	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		810004732	f4523dc4-ebb3-4c84-9b69-0eb70f2919e7
2.29241997700007	57.1616591650001	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE		810004731	5603753e-f973-4f89-bacb-68ca43fdbcbf
1.38973668200003	59.4781325280001	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			d442dfba-9928-4ec9-a7a7-2a79e75d1420
1.38943196300005	59.4781455560001	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			eab81aec-a6b7-42e3-b4c4-c80072f304e7
1.38963187400003	59.4781342480001	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			bda57783-3318-4cb7-a60f-c63c4857e403
1.38953120700006	59.4781382	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)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE			f2706ebf-39c7-4610-b5f8-811b5eabc189
1.38842931900007	59.47800161	10	Concrete Mattress	PROTECTION	AKER BP ASA	CONCRETE MATTRESS	ACTIVE		Concrete Mattress covering pipeline	23031	ED_1950_UTM_Zone_31N	408793.55064868	6594598.94540518	Thu Jun 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	ADD	Missing in database		dab76ac7-bbae-4ce1-b0a9-984a406b6bcb


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" DOUBLE,
  "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
);