Pipeline Points - Removed (ED50)

North Sea Transition Authority

@ukgov.pipeline_points_removed_ed505

Table List

1 table(50.28 KB)

Table 1

@ukgov.pipeline_points_removed_ed505.table_1

50.28 KB
386 rows
23 columns

x X	y Y	objectid OBJECTID	feature_id FEATURE ID	name NAME	inf_type INF TYPE	rep_group REP GROUP	pipe_sys PIPE SYS	descriptio DESCRIPTIO	status STATUS	comments COMMENTS	point_desc POINT DESC	crs_code CRS CODE	crs_name CRS NAME	orig_x_lon ORIG X LON	orig_y_lat ORIG Y LAT	start_date START DATE	end_date END DATE	end_reas END REAS	upd_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID	upd_date UPD DATE
1.72605300000004	57.7120620000001	797	267450e0-df31-45f7-a2e5-0fe56e42232a	HUNTINGTON TEE STRUCTURE	TEE PIECE	HARBOUR ENERGY PLC		HUNTINGTON TEE STRUCTURE	ABANDONED	Physically removed in 2023		23031	ED_1950_UTM_Zone_31N	424088	6397514	Tue Aug 30 2011 00:00:00 GMT+0000 (Coordinated Universal Time)			REMOVE	2024_03 Physically removed	810000962	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
2.33380260700005	53.4474765960001	798	aa85d65c-78b2-4f80-a3d5-a6284b57c3ee	VIKING VALVE SKID	VALVE	HARBOUR ENERGY PLC		VIKING VALVE SKID	NOT IN USE	Physically removed in 2023		23031	ED_1950_UTM_Zone_31N	455753	5922383				REMOVE	2024_03 Physically removed	810001281	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
2.28489585400007	53.462271979	1884	9fc9b9a0-75c3-47ed-883b-488a5c781f1e	VICTORIA VALVE SKID	VALVE	NEO ENERGY GROUP		VICTORIA VALVE SKID	REMOVED			23031	ED_1950_UTM_Zone_31N	452521	5924060				REMOVE	Valve skid disconnected and removed from seabed in 2023	810001280	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
2.21876850000007	53.03287419	1935	7b64f840-1c68-489f-ac13-8e0d758d8acd	PIPE EXPOSED AT SUBSEA TEE :1170	OTHER (PIPELINE)	PERENCO OIL & GAS	LEMAN	PIPE EXPOSED AT SUBSEA TEE	ACTIVE		Centre	4326	WGS84	2.2173797	53.0320872				REMOVE	Exposed section not observed	800006319	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.55195705200003	59.350193179	10313	dd3c75bd-9301-461c-9ea6-3519d6bb7d0f	GRYPHON SDU2	OTHER (PIPELINE)	TOTALENERGIES UPSTREAM UK LIMITED		SUBSEA DISTRIBUTION UNIT AT GRYPHON WELL CLUSTER	ACTIVE	Gryphon re-started 26/05/2013- Now Active		23031	UTM31N - ED50	417653	6580095	Thu May 03 2007 00:00:00 GMT+0000 (Coordinated Universal Time)			REMOVE	DUPLICATE OF ITEM LISTED AT "SUBSEA POINTS" = OBJECTID 10168 (both have same feature ID)	810000565	Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.69962295000005	61.0241318400001	10690	c28a6155-bfbb-4d3f-88c1-f4f4e6af3bc2	VASP	VALVE	SHELL PLC		VASP	REMOVED	VALVE ASSEMBLY SPOOL PIECE. Position modified 02/10/2019 as per As-Found location in Subsea 7 report - ET1030_SAT_FR_001 Spool and Mattress Wetstore	CENTRE OF STRUCTURE	23090	TM 0 N, ED50	591853.25	6766827.67		Sun Apr 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	STRUCTURE RECOVERED TO SHORE	REMOVE	STRUCTURE RECOVERED TO SHORE		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.70947160900005	61.055031603	10736	1946cf27-c217-45bd-95cd-ade8a9837239	BRENT B SSIV	VALVE	SHELL PLC		BRENT B SSIV	REMOVED		CENTRE OF STRUCTURE	23090	TM 0 N, ED50	592295.56	6770282.64	Fri Aug 09 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	STRUCTURE RECOVERED TO SHORE	REMOVE	STRUCTURE RECOVERED TO SHORE		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.95746610300006	57.03123413	11542	a6e94731-0bd3-4d97-b0d8-c58bad9432d9	CONCRETE MATTRESS	MATTRESS	SHELL PLC		CONCRETE MATTRESS PROTECTING PL4867	ACTIVE	853-5 X WET STORED KESTREL 2021	CENTRE OF MATTRESS	4326	WGS84	1.95592928	57.03058018				REMOVE	WET STORED OR OFF PIPELINE		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
2.06708902600008	57.4794718960001	12152	46992ec0-a7b3-42ac-935d-f0399bd32d20	CONCRETE MATTRESS	MATTRESS	SHELL PLC		CONCRETE MATTRESS PROTECTING PL4645	ACTIVE	1466-SEVEN ARTIC FEBRUARY 2020	CENTRE OF MATTRESS	4326	WGS84	2.06553692	57.4788354				REMOVE	WET STORED OR OFF PIPELINE		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
2.06773895400005	57.479361822	12155	cdf8d4bc-4aea-42cc-8525-8c8d240fa767	CONCRETE MATTRESS	MATTRESS	SHELL PLC		CONCRETE MATTRESS PROTECTING PLU4650	ACTIVE	1469-SEVEN ARTIC FEBRUARY 2020	CENTRE OF MATTRESS	4326	WGS84	2.06618687	57.47872533				REMOVE	WET STORED OR OFF PIPELINE		Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "feature_id" VARCHAR,
  "name" VARCHAR,
  "inf_type" VARCHAR,
  "rep_group" VARCHAR,
  "pipe_sys" VARCHAR,
  "descriptio" VARCHAR,
  "status" VARCHAR,
  "comments" VARCHAR,
  "point_desc" VARCHAR,
  "crs_code" BIGINT,
  "crs_name" VARCHAR,
  "orig_x_lon" DOUBLE,
  "orig_y_lat" DOUBLE,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "upd_date" TIMESTAMP
);