Pipeline Freespans (WGS84)

North Sea Transition Authority

@ukgov.pipeline_freespans_wgs843

Table List

1 table(87.17 KB)

Table 1

@ukgov.pipeline_freespans_wgs843.table_1

87.17 KB
982 rows
21 columns

objectid OBJECTID	feature_id FEATURE ID	label LABEL	nstapipno NSTAPIPNO	pipe_name PIPE NAME	rep_group REP GROUP	freespanno FREESPANNO	length_m LENGTH M	mxheight_m MXHEIGHT M	comments COMMENTS	crs_code CRS CODE	crs_name CRS NAME	start_date START DATE	upd_date UPD DATE	upd_type UPD TYPE	upd_reas UPD REAS	survey_id SURVEY ID	shape_length Shape, Length	legacy_id LEGACY ID
1	08b8d3a5-738c-4751-8e8a-ddad5edaaefd	PL149	PL149	BERYL A TO SPM2	APACHE CORPORATION	5	23.6	1.46		4230	ED50	Fri Oct 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	2020 ROVSV Inspection campaign	0.0003505091644444	610004926
2	532d3f44-2250-4fc1-93cf-c66e1a64ecc6	PL1606A	PL1606A	PL1606A	APACHE CORPORATION	2	8.32	0.89		4230	ED50	Fri Oct 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	2021 ROVSV Inspection campaign	0.0001064723944481	610004928
3	fb4f7b26-be8b-4f92-8f85-159c5424f7a9	PL725	PL725	BERYL B TO BERYL A GAS LINE	APACHE CORPORATION	22	52.33	0.94		4230	ED50	Fri Oct 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	2020 ROVSV Inspection campaign	0.0004763298157038	610004937
4	ed75f07e-2a19-45b1-93ba-316fef2e56f4	PL762	PL762	PL762	APACHE CORPORATION		16.63	0.77	New	4230	ED50		Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	2021 ROVSV Inspection campaign	0.0002414913895386
5	e98d06ae-af55-4766-a55c-bb89f6624d56	PL725	PL725	BERYL B TO BERYL A GAS LINE	APACHE CORPORATION		14.87	0.06		23031	ED_1950_UTM_Zone_31N		Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE		0.0002553650753039
6	f43c0b0d-3642-4d63-911a-dcceb32b1e9c	PL725	PL725	BERYL B TO BERYL A GAS LINE	APACHE CORPORATION		11.1	0.07		23031	ED_1950_UTM_Zone_31N		Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE		0.0001885012255583
7	d14d7b64-2255-4e13-af74-142e62a9cc84	PL725	PL725	BERYL B TO BERYL A GAS LINE	APACHE CORPORATION		10.01	0.07		23031	ED_1950_UTM_Zone_31N		Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE		0.000162075094956
8	c649573b-7a75-4c2a-9e92-f193311cb959	PL725	PL725	BERYL B TO BERYL A GAS LINE	APACHE CORPORATION		13	0.09		23031	ED_1950_UTM_Zone_31N		Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE		0.0001550933000519
9	9f482a32-e720-4fc6-96f8-83a408d1f730	PL725	PL725	BERYL B TO BERYL A GAS LINE	APACHE CORPORATION		11.61	0.07		23031	ED_1950_UTM_Zone_31N		Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE		0.0001287246009898
10	67dd638a-cb4e-4c5b-aa44-7b51dcb902f2	PL725	PL725	BERYL B TO BERYL A GAS LINE	APACHE CORPORATION		17.34	0.06		23031	ED_1950_UTM_Zone_31N		Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE		0.0001851729680541


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feature_id" VARCHAR,
  "label" VARCHAR,
  "nstapipno" VARCHAR,
  "pipe_name" VARCHAR,
  "rep_group" VARCHAR,
  "freespanno" DOUBLE,
  "length_m" DOUBLE,
  "mxheight_m" DOUBLE,
  "comments" VARCHAR,
  "crs_code" DOUBLE,
  "crs_name" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" VARCHAR,
  "end_reas" VARCHAR,
  "upd_date" TIMESTAMP,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "survey_id" VARCHAR,
  "shape_length" DOUBLE,
  "legacy_id" DOUBLE
);