Subsea Linear (ETRS89)

North Sea Transition Authority

@ukgov.subsea_linear_etrs892

Table List

1 table(558.25 KB)

Table 1

@ukgov.subsea_linear_etrs892.table_1

558.25 KB
8663 rows
19 columns

objectid OBJECTID	feature_id FEATURE ID	name NAME	inf_type INF TYPE	rep_group REP GROUP	descriptio DESCRIPTIO	status STATUS	length_m LENGTH M	crs_code CRS CODE	crs_name CRS NAME	upd_date UPD DATE	upd_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID	shape_length Shape, Length
1	6f35da0e-842f-4027-b584-ed0023719f58	ANASURIA FPSO ANCHOR CABLE 6	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 6	ACTIVE	1116.80518321	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001276	0.014998112365796
2	2dfcf0d9-75f6-4a28-afde-09bd29d97f04	ANASURIA FPSO ANCHOR CABLE 7	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 7	ACTIVE	1116.55487296	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001277	0.0103312116122938
3	ec71838a-8d9f-4770-acd4-a0e9126a7995	ANASURIA FPSO ANCHOR CABLE 10	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 10	ACTIVE	1118.3044384	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001281	0.0180291580067051
4	9aa676ed-40f2-48c6-8b07-c252d987208c	ANASURIA FPSO ANCHOR CABLE 1	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 1	ACTIVE	1117.57696708	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001271	0.010340982387286
5	1ee14c7a-526c-4f0a-bc0f-0bf940b6c8f4	ANASURIA FPSO ANCHOR CABLE 4	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 4	ACTIVE	1114.95903588	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001274	0.0179779117850802
6	d34d3796-1149-476e-a7d0-be360f2679b1	ANASURIA FPSO ANCHOR CABLE 5	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 5	ACTIVE	1117.3576872	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001275	0.0156918298360686
7	2e5675b7-45cf-4525-94a8-25303d5186a3	ANASURIA FPSO ANCHOR CABLE 2	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 2	ACTIVE	1116.34068348	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001272	0.0107218571291926
8	4781350a-c28d-4a48-bc1f-767040e8d740	ANASURIA FPSO ANCHOR CABLE 12	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 12	ACTIVE	1120.46216504	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001283	0.0150369723596142
9	cb8feb30-636d-479a-8112-5425ae182dc8	ANASURIA FPSO ANCHOR CABLE 3	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 3	ACTIVE	1117.87192492	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001273	0.0176764494831531
10	2fa0ae95-dbc5-4b8d-ab0f-999e40d30dcd	ANASURIA FPSO ANCHOR CABLE 8A	ANCHOR CABLE	ANASURIA OPERATING COMPANY LIMITED	ANASURIA FPSO ANCHOR CABLE 8A	ACTIVE	1117.06415568	23090	TM 0 N, ED50	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE FROM PREVIOUS SUBMISSION	510001279	0.010696239939162


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" DOUBLE,
  "crs_name" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "upd_date" TIMESTAMP,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "shape_length" DOUBLE
);