Pipeline Points (ED50)
North Sea Transition Authority
@ukgov.pipeline_points_ed505
Table 1
@ukgov.pipeline_points_ed505.table_1
- 2.24 MB
- 28166 rows
- 24 columns
xX | yY | objectidOBJECTID | feature_idFEATURE ID | nstapipnoNSTAPIPNO | nameNAME | inf_typeINF TYPE | rep_groupREP GROUP | pipe_sysPIPE SYS | descriptioDESCRIPTIO | statusSTATUS | commentsCOMMENTS | crs_codeCRS CODE | crs_nameCRS NAME | orig_x_lonORIG X LON | orig_y_latORIG Y LAT | point_descPOINT DESC | start_dateSTART DATE | end_dateEND DATE | end_reasEND REAS | upd_dateUPD DATE | upd_typeUPD TYPE | upd_reasUPD REAS | legacy_idLEGACY ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2.29190916800007 | 57.1645076830001 | 1 | 0d435317-7f7f-4eed-9e70-d44285505c85 | PIERCE PRODUCTION PIPELINE PLET | MANIFOLD | AKER BP ASA | PL3083 | PIERCE PRODUCTION PIPELINE PLET | ABANDONED | STRUCTURE CENTRE COMPLETELY WITHIN 500M SAFETY ZONE | 23090 | ED_1950_TM_0_N | 638605.326 | 6338170.452 | CENTRE | Thu Jun 26 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | PIPE_SYS ID added | 810004876 | |||
| 2.29285803200003 | 57.1634429630001 | 2 | 29e521ba-01cd-4aa8-983a-22d6fed6ec4d | BRYNHILD RISER BASE MANIFOLD | MANIFOLD | AKER BP ASA | PL3083 | BRYNHILD RISER BASE MANIFOLD | ABANDONED | STRUCTURE CENTRE COMPLETELY WITHIN 500M SAFETY ZONE | 23090 | ED_1950_TM_0_N | 638666.683 | 6338053.893 | CENTRE | Fri Sep 26 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | PIPE_SYS ID added | 810004733 | |||
| 2.29283008900006 | 57.163453137 | 3 | d88d1cbf-fc09-481d-a96b-ba463b199b00 | BRYNHILD RISER BASE MANIFOLD | MANIFOLD | AKER BP ASA | PL3083 | RISER BASE MANIFOLD AT PIERCE | ABANDONED | 23031 | ED_1950_UTM_Zone_31N | 457227.78 | 6335945.06 | Sun May 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | PIPE_SYS ID added | 810001453 | |||||
| 0.810679402000062 | 57.255881715 | 4 | 3e05e175-e17f-47a0-ab0f-6a9b2541576d | PL1238 | GUILLEMOT RISER BASE ANODE SKID 01 | ANODE ASSEMBLY (PIPELINE) | ANASURIA OPERATING COMPANY LIMITED | GUILLEMOT RISER BASE ANODE SKID 01 | ACTIVE | 23090 | TM 0 N, ED50 | 548910.3 | 6346303.8 | CENTRE OF ANODE | Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | MOVED FROM SUBSEA POINTS TO PIPELINE POINTS | |||||
| 0.810700059000055 | 57.2558411580001 | 5 | 0579001a-402b-4df9-a647-b243ab41809a | PL1238 | GUILLEMOT RISER BASE ANODE SKID 02 | ANODE ASSEMBLY (PIPELINE) | ANASURIA OPERATING COMPANY LIMITED | GUILLEMOT RISER BASE ANODE SKID 02 | ACTIVE | 23090 | TM 0 N, ED50 | 548911.6 | 6346299.3 | CENTRE OF ANODE | Tue May 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | MOVED FROM SUBSEA POINTS TO PIPELINE POINTS | |||||
| 0.81161597800002 | 57.258237244 | 6 | bbb16f73-0f1a-4e90-b4e2-ff8c6e4b23bf | PL1235 | TEAL RISER BASE NORTHERN ANODE SKID | ANODE ASSEMBLY (PIPELINE) | ANASURIA OPERATING COMPANY LIMITED | TEAL RISER BASE NORTHERN ANODE SKID | ACTIVE | 23090 | TM 0 N, ED50 | 548963.68 | 6346566.69 | CENTRE OF ANODE | Wed Aug 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | MOVED FROM SUBSEA POINTS TO PIPELINE POINTS | |||||
| 0.811560082000028 | 57.2581979890001 | 7 | 92f93e4c-19ee-4ef3-9d15-15bad6c21caa | PL1235 | TEAL RISER BASE SOUTHERN ANODE SKID | ANODE ASSEMBLY (PIPELINE) | ANASURIA OPERATING COMPANY LIMITED | TEAL RISER BASE SOUTHERN ANODE SKID | ACTIVE | 23090 | TM 0 N, ED50 | 548960.36 | 6346562.28 | CENTRE OF ANODE | Wed Aug 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | MOVED FROM SUBSEA POINTS TO PIPELINE POINTS | |||||
| 0.84903 | 57.2846200000001 | 8 | a674163a-f75a-4ce5-b46b-e18fbda459dd | PL1235 | TEAL SUBSEA COOLING COIL | OTHER (PIPELINE) | ANASURIA OPERATING COMPANY LIMITED | TEAL SUBSEA COOLING COIL PL1235 | ACTIVE | 23090 | TM 0 N, ED50 | 551184.4 | 6349531.5 | CENTRE OF SPOOL | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | UPDATE AS PREVIOUSLY LISTED AS SPOOL PIECE, NSTAPIPNO ADDED | 800009930 | |||||
| 0.829004500000053 | 57.1679435 | 9 | 7535437b-99c2-4625-85b5-0a6792115747 | PL1954 | GUILLEMOT GAS LIFT MANIFOLD | MANIFOLD | ANASURIA OPERATING COMPANY LIMITED | GUILLEMOT GAS LIFT MANIFOLD | ACTIVE | RELATING TO PL1954, PL1954JP2, PL3145, PL4309 AND PL4726 | 23090 | TM 0 N, ED50 | 550134.95 | 6336527.92 | CENTRE OF VALVE ASSEMBLY | Mon Mar 17 2003 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | RELABLE AS MANIFOLD AND NSTAPIPNO ADDED, NSTAPIPNO ADDED | 800009193 | |||
| 0.81051130000003 | 57.2558208 | 10 | 2b3467d4-2c24-47df-841d-8a6e033e6338 | PL1238 | GUILLEMOT RISER BASE AT FPSO ANASURIA | RISER BASE | ANASURIA OPERATING COMPANY LIMITED | GUILLEMOT RISER BASE AT FPSO ANASURIA | ACTIVE | 23090 | TM 0 N, ED50 | 548900.239 | 6346296.898 | Sun Jan 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | NSTAPIPNO ADDED | 800008570 |
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid" BIGINT,
"feature_id" VARCHAR,
"nstapipno" VARCHAR,
"name" VARCHAR,
"inf_type" VARCHAR,
"rep_group" VARCHAR,
"pipe_sys" VARCHAR,
"descriptio" VARCHAR,
"status" VARCHAR,
"comments" VARCHAR,
"crs_code" DOUBLE,
"crs_name" VARCHAR,
"orig_x_lon" DOUBLE,
"orig_y_lat" DOUBLE,
"point_desc" VARCHAR,
"start_date" TIMESTAMP,
"end_date" VARCHAR,
"end_reas" VARCHAR,
"upd_date" TIMESTAMP,
"upd_type" VARCHAR,
"upd_reas" VARCHAR,
"legacy_id" DOUBLE
);