Subsea Linear (WGS84)

North Sea Transition Authority

@ukgov.subsea_linear_wgs842

Table List

1 table(142.76 KB)

Table 1

@ukgov.subsea_linear_wgs842.table_1

142.76 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_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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001276	0.0149981076594371
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001277	0.010331202039442
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001281	0.0180291384759912
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001271	0.0103409725250845
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001274	0.0179778922517584
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001275	0.0156918235660583
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001272	0.0107218451213605
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001283	0.0150369681070015
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001273	0.0176764295517463
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	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	510001279	0.0106962285299704


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
);