Pipelines Linear - Removed (WGS84)

North Sea Transition Authority

@ukgov.pipelines_linear_removed_wgs843

Table List

1 table(30 KB)

Table 1

@ukgov.pipelines_linear_removed_wgs843.table_1

30 KB
67 rows
35 columns

objectid OBJECTID	feature_id FEATURE ID	nstapipno NSTAPIPNO	pipe_name PIPE NAME	inf_type INF TYPE	rep_group REP GROUP	fluid FLUID	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	rep_owner REP OWNER	rep_opertr REP OPERTR	rep_holder REP HOLDER	shape_length Shape, Length	simplified SIMPLIFIED
1300	71954961-5dd0-4d91-a2e0-9aa0634078f4	PL1330	MACCULLOCH WESTBOUND Gas - Disconnected	PIPELINE	HARBOUR ENERGY PLC	GAS	PL1330 MACCULLOCH WESTBOUND Gas - Disconnected	NOT IN USE	1846.72550083	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2023_05 Geometry Update	Y	Y	Y	0.0301607625494114	N
1301	ca432ebe-4fc7-4f21-bd4c-2a854e188049	PL1326	MACCULLOCH WESTBOUND Production - Disconnected	PIPELINE	HARBOUR ENERGY PLC		PL1326 MACCULLOCH WESTBOUND Production - Disconnected	NOT IN USE	1528.05542769	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR	Y	Y	Y	0.0278118445747761	N
1302	544d0733-b9d6-4a8e-8c6f-3f4626a683ce	PL1327	MACCULLOCH WESTBOUND Production - Disconnected	PIPELINE	HARBOUR ENERGY PLC		PL1327 MACCULLOCH WESTBOUND Production - Disconnected	NOT IN USE	1513.27860773	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR \| Geometry Update	Y	Y	Y	0.0274014429691049	N
1303	3aa85149-6431-403a-bbfa-9e4bfbf0823e	PL1332	MACCULLOCH WESTBOUND Water Injection - Disconnected	PIPELINE	HARBOUR ENERGY PLC	WATER	PL1332 MACCULLOCH WESTBOUND Water Injection - Disconnected	NOT IN USE	1834.93362993	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR	Y	Y	Y	0.0302388140965081	N
1304	4963432e-dcfb-4106-8a90-2349d4e9d533	PL1329	MACCULLOCH EASTBOUND Production - Disconnected	PIPELINE	HARBOUR ENERGY PLC		PL1329 MACCULLOCH EASTBOUND Production - Disconnected	NOT IN USE	2829.67682706	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR	Y	Y	Y	0.0347458026452643	N
1305	6ad92102-271f-4b0e-89e9-2c8157d57afe	PL1331	MACCULLOCH EASTBOUND Gas - Disconnected	PIPELINE	HARBOUR ENERGY PLC	GAS	PL1331 MACCULLOCH EASTBOUND Gas - Disconnected	NOT IN USE	2781.77005167	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR	Y	Y	Y	0.034150096866532	N
1306	eb0ce8f8-dc9b-4718-bf3a-593248faec28	PL1333	MACCULLOCH EASTBOUND Water Injection - Disconnected	PIPELINE	HARBOUR ENERGY PLC	WATER	PL1333 MACCULLOCH EASTBOUND Water Injection - Disconnected	NOT IN USE	2809.763697	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR	Y	Y	Y	0.0342437368342802	N
1307	0382d404-260d-4eae-a1c1-14aa6b888219	PL1335.1	MACCULLOCH EASTBOUND Umbilical - Disconnected	UMBILICAL	HARBOUR ENERGY PLC		PL1335.1 MACCULLOCH EASTBOUND Umbilical - Disconnected	NOT IN USE	2871.2894458	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR	Y	Y	Y	0.0353430566102277	N
1308	53aeabac-6745-4a45-86e7-1a19aff281ca	PL1328	MACCULLOCH WESTBOUND Production - Disconnected	PIPELINE	HARBOUR ENERGY PLC		PL1328 MACCULLOCH WESTBOUND Production - Disconnected	NOT IN USE	1432.66772332	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR	Y	Y	Y	0.0241702230540172	N
1309	e824b7e1-1818-41c0-b28c-a1f51f24fb36	PL1334.2	MACCULLOCH WESTBOUND Umbilical - Disconnected	UMBILICAL	HARBOUR ENERGY PLC		PL1334.2 MACCULLOCH WESTBOUND Umbilical - Disconnected	NOT IN USE	2123.7654257	23031	ED_1950_UTM_Zone_31N	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	REMOVE	2024_03 Physically Removed \| 2022_05 CHR to HBR \| Geometry Update	Y	Y	Y	0.0336408535749588	N


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "feature_id" VARCHAR,
  "nstapipno" VARCHAR,
  "pipe_name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "fluid" VARCHAR,
  "pipe_sys" VARCHAR,
  "descriptio" VARCHAR,
  "status" VARCHAR,
  "comments" VARCHAR,
  "diametermm" DOUBLE,
  "length_m" DOUBLE,
  "insul_type" VARCHAR,
  "int_diam" BIGINT,
  "mx_op_pres" BIGINT,
  "thickness" BIGINT,
  "bundle" BIGINT,
  "bundle_flg" VARCHAR,
  "crs_code" BIGINT,
  "crs_name" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "untrenched" VARCHAR,
  "exposed" VARCHAR,
  "upd_date" TIMESTAMP,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "rep_owner" VARCHAR,
  "rep_opertr" VARCHAR,
  "rep_holder" VARCHAR,
  "shape_length" DOUBLE,
  "simplified" VARCHAR
);