Subsea Linear (ED50)

North Sea Transition Authority

@ukgov.subsea_linear_ed502

Table List

1 table(142.75 KB)

Table 1

@ukgov.subsea_linear_ed502.table_1

142.75 KB
2227 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_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID	shape_length Shape, Length	upd_date UPD DATE
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	NO CHANGE	NO CHANGE	510001276	0.014997501258543	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001277	0.0103309230952515	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001281	0.0180287413315517	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001271	0.0103406926750581	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001274	0.017977495320539	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001275	0.0156912170337422	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001272	0.0107215992277272	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001283	0.0150363592667906	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001273	0.0176760602227985	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
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	NO CHANGE	NO CHANGE	510001279	0.0106959805534603	Tue Nov 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" DOUBLE,
  "crs_name" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "shape_length" DOUBLE,
  "upd_date" TIMESTAMP
);