Surface Points (WGS84)

North Sea Transition Authority

@ukgov.surface_points_wgs842

Table List

1 table(55.71 KB)

Table 1

@ukgov.surface_points_wgs842.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_date UPD DATE	upd_type UPD TYPE	upd_reas UPD REAS	legacy_id LEGACY ID
0.808234943000059	57.2565330310001	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.		Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE TO PREVIOUS SUBMISSION	700002106
1.55763208400003	59.533807617	2	f3725b3a-1c44-4944-ac56-2775113bc8f1	BERYL SPM-3	SBM	APACHE CORPORATION	SPM-3		4326	GCS_WGS_1984	1.5575667	59.5338333	ACTIVE			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	MODIFY	Position updated	700002045
1.53342593200006	59.545820066	3	ee04614a-d911-4e71-a0b5-aad848300d22	BERYL FLARE	PLATFORM	APACHE CORPORATION	FLARE BRIDGE/VERTICAL STACK		4326	GCS_WGS_1984	1.5327333	59.5459833	ACTIVE			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700002042
1.53421542300003	59.5445885290001	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			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700002034
1.56116112700005	59.553722877	5	4bb90fc7-1697-4a2d-89cd-a6465e2ef278	BERYL SPM-2	SBM	APACHE CORPORATION	SPM-2		4326	GCS_WGS_1984	1.561	59.5537667	ACTIVE			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700002032
1.53635839600003	59.5451212400001	6	1e078993-d72a-4423-9581-7c03678adb16	BERYL A RISER	PLATFORM	APACHE CORPORATION	RISER STEEL		4326	GCS_WGS_1984	1.53625	59.5451167	ACTIVE			Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700002044
0.901627943000051	57.7217610970001	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)	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700002147
0.968956002000027	57.7312014680001	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)	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700003547
0.913570459000027	57.7486612650001	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)	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700001918
1.03063263600006	57.715561479	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)	Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	NO CHANGE	NO CHANGE	700001920


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_date" TIMESTAMP,
  "upd_type" VARCHAR,
  "upd_reas" VARCHAR,
  "legacy_id" DOUBLE,
  "plat_flag" VARCHAR
);