Subsea Linear - Removed (ED50)

North Sea Transition Authority

@ukgov.subsea_linear_removed_ed502

Table List

1 table(15.16 KB)

Table 1

@ukgov.subsea_linear_removed_ed502.table_1

15.16 KB
17 rows
19 columns

objectid OBJECTID	feature_id FEATURE ID	name NAME	inf_type INF TYPE	rep_group REP GROUP	descriptio DESCRIPTIO	status STATUS	comments COMMENTS	length_m LENGTH M	crs_code CRS CODE	crs_name CRS NAME	end_date END DATE	end_reas END REAS	upd_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID	shape_length Shape, Length	upd_date UPD DATE
8323	2845dbf0-1cac-421f-bd18-4336410a2369	ATHENA ESP POWER CABLE	POWER CABLE	ITHACA ENERGY	ATHENA ESP POWER CABLE	REMOVED	Removed to shore	1895.3053182	23030	UTM30, ED50	Tue Oct 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Removed to shore	REMOVE	STATUS CHANGE and geometry updated		0.02445236505169	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8330	de3c9c06-a1e2-4e3c-bede-7f4dfdf42dac	ATHENA MANIFOLD TO WELL P4 UMBILICAL - PLU2821JP4	POWER CABLE	ITHACA ENERGY	ATHENA MANIFOLD TO WELL P4 UMBILICAL	REMOVED	Added 29/03/22	52.24967372	23030	UTM30, ED50	Tue Oct 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Removed to shore	REMOVE	Removed to shore		0.0007190652050268	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8331	0616123c-6512-421d-b8ad-3dabedbfaeee	ATHENA MANIFOLD TO WELL P3 UMBILICAL - PLU2821JP3	POWER CABLE	ITHACA ENERGY	ATHENA MANIFOLD TO WELL P3 UMBILICAL	REMOVED	Added 29/03/22	63.7655427	23030	UTM30, ED50	Tue Oct 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Removed to shore	REMOVE	Removed to shore		0.0008645038948395	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8332	fb3a267a-1db2-44ca-b5e0-d8797befdd5a	ATHENA MANIFOLD TO WELL P2 UMBILICAL - PLU2821JP2	POWER CABLE	ITHACA ENERGY	ATHENA MANIFOLD TO WELL P2 UMBILICAL	REMOVED	Added 29/03/22	63.56513098	23030	UTM30, ED50	Tue Oct 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Removed to shore	REMOVE	Removed to shore		0.0008774976157141	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8534	40514275-3c2b-4a03-8951-e7090c36	HUMMINGBIRD FPSO ANCHOR CABLE 12	ANCHOR CABLE	TEEKAY PETROJARL	HUMMINGBIRD FPSO ANCHOR CABLE 12	ACTIVE		1527.51952197	23031	ED_1950_UTM_Zone_31N			REMOVE	Teekay confirmed everything has been removed from the seabed - email 27/2/2023	510001270	0.0257809458566161	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8535	839ffb4d-8778-42a2-a7d2-f11abb46	HUMMINGBIRD FPSO ANCHOR CABLE 6	ANCHOR CABLE	TEEKAY PETROJARL	HUMMINGBIRD FPSO ANCHOR CABLE 6	ACTIVE		1379.62822891	23031	ED_1950_UTM_Zone_31N			REMOVE	Teekay confirmed everything has been removed from the seabed - email 27/2/2023	510001264	0.0199812453694764	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8536	8028ecb7-a228-4f41-913a-1db497bc	HUMMINGBIRD FPSO ANCHOR CABLE 2	ANCHOR CABLE	TEEKAY PETROJARL	HUMMINGBIRD FPSO ANCHOR CABLE 2	ACTIVE		1528.007356	23031	ED_1950_UTM_Zone_31N			REMOVE	Teekay confirmed everything has been removed from the seabed - email 27/2/2023	510001260	0.0137572688146699	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8537	5b580a33-ebab-43f8-8850-8f4f20af	HUMMINGBIRD FPSO ANCHOR CABLE 1	ANCHOR CABLE	TEEKAY PETROJARL	HUMMINGBIRD FPSO ANCHOR CABLE 1	ACTIVE		1529.23612958	23031	ED_1950_UTM_Zone_31N			REMOVE	Teekay confirmed everything has been removed from the seabed - email 27/2/2023	510001259	0.0137356542919621	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8538	262165f1-77aa-4b70-add1-48d9402a	HUMMINGBIRD FPSO ANCHOR CABLE 5	ANCHOR CABLE	TEEKAY PETROJARL	HUMMINGBIRD FPSO ANCHOR CABLE 5	ACTIVE		1378.40496589	23031	ED_1950_UTM_Zone_31N			REMOVE	Teekay confirmed everything has been removed from the seabed - email 27/2/2023	510001263	0.0202783327699225	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
8539	1d432a6f-edb9-4c43-918f-f2dc4f93	HUMMINGBIRD FPSO ANCHOR CABLE 10	ANCHOR CABLE	TEEKAY PETROJARL	HUMMINGBIRD FPSO ANCHOR CABLE 10	ACTIVE		1528.08235707	23031	ED_1950_UTM_Zone_31N			REMOVE	Teekay confirmed everything has been removed from the seabed - email 27/2/2023	510001268	0.0249727438675568	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feature_id" VARCHAR,
  "name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "descriptio" VARCHAR,
  "status" VARCHAR,
  "comments" VARCHAR,
  "length_m" DOUBLE,
  "crs_code" BIGINT,
  "crs_name" VARCHAR,
  "start_date" VARCHAR,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "shape_length" DOUBLE,
  "upd_date" TIMESTAMP
);