Surface Points (ED50)

North Sea Transition Authority

@ukgov.surface_points_ed503

Table List

1 table(55.71 KB)

Table 1

@ukgov.surface_points_ed503.table_1

55.71 KB
322 rows
24 columns

x X	y Y	objectid OBJECTID	feature_id FEATURE ID	name NAME	inf_type INF TYPE	rep_group REP GROUP	descriptio DESCRIPTIO	pipe_sys PIPE SYS	crs_code CRS CODE	crs_name CRS NAME	orig_x_lon ORIG X LON	orig_y_lat ORIG Y LAT	status STATUS	comments COMMENTS	start_date START DATE	upd_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID	upd_date UPD DATE
0.809811332000038	57.257192719	1	bcb1c849-dc88-4c24-83a9-e95310037e3b	ANASURIA	FPSO	ANASURIA OPERATING COMPANY LIMITED	FPSO (ANASURIA)	Fulmar Gas Pipeline	23090	TM 0 N, ED50	548850	6346448	ACTIVE	amend Company Identifying Installation and Installation Owner from SHELL to ANASURIA, Shell have been informed.		NO CHANGE	NO CHANGE TO PREVIOUS SUBMISSION	700002106	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.55928949000003	59.534374133	2	f3725b3a-1c44-4944-ac56-2775113bc8f1	BERYL SPM-3	SBM	APACHE CORPORATION	SPM-3		4326	GCS_WGS_1984	1.5575667	59.5338333	ACTIVE			MODIFY	Position updated	700002045	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.53508460000006	59.546386425	3	ee04614a-d911-4e71-a0b5-aad848300d22	BERYL FLARE	PLATFORM	APACHE CORPORATION	FLARE BRIDGE/VERTICAL STACK		4326	GCS_WGS_1984	1.5327333	59.5459833	ACTIVE			NO CHANGE	NO CHANGE	700002042	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.53587400900005	59.5451549250001	4	ba90780a-347a-4ed7-a849-62053d0ea4be	BERYL A	PLATFORM	APACHE CORPORATION	PRODUCTION DRILLING CONCRETE GRAVITY BASE		4326	GCS_WGS_1984	1.5340667	59.5446167	ACTIVE			NO CHANGE	NO CHANGE	700002034	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.56281938500007	59.5542885950001	5	4bb90fc7-1697-4a2d-89cd-a6465e2ef278	BERYL SPM-2	SBM	APACHE CORPORATION	SPM-2		4326	GCS_WGS_1984	1.561	59.5537667	ACTIVE			NO CHANGE	NO CHANGE	700002032	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.53801694700007	59.5456875890001	6	1e078993-d72a-4423-9581-7c03678adb16	BERYL A RISER	PLATFORM	APACHE CORPORATION	RISER STEEL		4326	GCS_WGS_1984	1.53625	59.5451167	ACTIVE			NO CHANGE	NO CHANGE	700002044	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
0.903221464000069	57.7224028680001	7	6b746730-66c1-4075-a97d-5ee9b2288b21	FORTIES DELTA	PLATFORM	APACHE CORPORATION	FORTIES DELTA	Forties Pipeline System (FPS)	23031	ED_1950_UTM_Zone_31N	375102.9	6399882.5	ACTIVE		Mon Jun 30 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700002147	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
0.970548132000033	57.7318420720001	8	9cab0e3e-ccf1-40d0-bfcb-b3902cabc80f	FASP	PLATFORM	APACHE CORPORATION	FORTIES ALPHA SUPPORT PLATFORM		23031	ED_1950_UTM_Zone_31N	379143.7	6400811.46	ACTIVE		Sun Jun 30 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700003547	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
0.915164813000047	57.7493019130001	9	0978a4c7-f031-4f81-94b2-f7653985a1f8	FORTIES BRAVO	PLATFORM	APACHE CORPORATION	FORTIES BRAVO	Forties Pipeline System (FPS)	23031	ED_1950_UTM_Zone_31N	375906.32	6402854.45	ACTIVE		Sat Aug 31 1974 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700001918	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
1.03222245200004	57.7162018970001	10	7721311b-c72a-4ce9-ac03-4032b3b0b750	FORTIES ECHO	PLATFORM	APACHE CORPORATION	FORTIES ECHO	Forties Pipeline System (FPS)	23031	ED_1950_UTM_Zone_31N	382765.55	6398961.83	ACTIVE		Mon Jun 30 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700001920	Tue Nov 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,
  "descriptio" VARCHAR,
  "pipe_sys" VARCHAR,
  "point_desc" VARCHAR,
  "crs_code" BIGINT,
  "crs_name" VARCHAR,
  "orig_x_lon" DOUBLE,
  "orig_y_lat" DOUBLE,
  "status" VARCHAR,
  "comments" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "end_reas" VARCHAR,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "plat_flag" VARCHAR,
  "upd_date" TIMESTAMP
);