Pipeline Points (ETRS89)
North Sea Transition Authority
@ukgov.pipeline_points_etrs895
Table 1
@ukgov.pipeline_points_etrs895.table_1
- 1.67 MB
- 20058 rows
- 23 columns
xX | yY | objectidOBJECTID | feature_idFEATURE ID | nameNAME | inf_typeINF TYPE | rep_groupREP GROUP | pipe_sysPIPE SYS | descriptioDESCRIPTIO | statusSTATUS | commentsCOMMENTS | point_descPOINT DESC | crs_codeCRS CODE | crs_nameCRS NAME | orig_x_lonORIG X LON | orig_y_latORIG Y LAT | start_dateSTART DATE | end_dateEND DATE | end_reasEND REAS | upd_typeUPD TYPE | upd_reasUPD REAS | legacy_idLEGACY ID | upd_dateUPD DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.808923481000022 | 57.2570137590001 | 1 | 7c437e01-135c-451c-97e7-41ea76731830 | TEAL RISERS MID WATER ARCH | SUBSEA BUOYANCY | ANASURIA OPERATING COMPANY LIMITED | TEAL RISERS MIDWATER ARCH | ACTIVE | RELATING TO LINES PL1236 PL1237 PL1235 | CENTRE OF ARCH | 23090 | TM 0 N, ED50 | 548896.062 | 6346501.862 | MODIFY | ADDED COMMENT ON PL NUMBER AND POINT_DESC | 800008561 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 0.816264033000039 | 57.2304698770001 | 2 | 88468e26-d918-4e2b-a104-74e4c3d8c936 | TEAL SOUTH PRODUCTION/TEST TEE CENTRE | PIPE JUNCTION | ANASURIA OPERATING COMPANY LIMITED | TEAL SOUTH PRODUCTION/TEST TEE CENTRE | ACTIVE | RELATING TO LINES PLU3002 PL1241 PLU3002 PL1241 PL1248 PL1246 | CENTRE OF TEE | 23090 | TM 0 N, ED50 | 549374.3 | 6343552.4 | MODIFY | ADDED COMMENT ON PL NUMBER | 800008555 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 0.81594857400006 | 57.229236729 | 3 | 66df8488-1dab-4ca7-95be-95d6ca54d33a | TEAL SOUTH WATER INJECTION TEE | PIPE JUNCTION | ANASURIA OPERATING COMPANY LIMITED | TEAL SOUTH WATER INJECTION TEE (PL1247/PL1240) | ACTIVE | JUNCTION OF PL1247 AND PL1240 | CENTRE OF TEE | 23090 | TM 0 N, ED50 | 549356.9 | 6343414.9 | MODIFY | ADDED COMMENT ON PL NUMBER AND POINT_DESC | 800008602 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 0.810122002000071 | 57.257674389 | 4 | bc5950c3-71f2-4cd5-96f2-4c6a7e01e850 | PL1236 TEAL WI VALVE STRUCTUE | VALVE | ANASURIA OPERATING COMPANY LIMITED | TEAL WI VALVE STRUCTUE PL1236 | ACTIVE | WITHIN FPSO 500M ZONE | CENTRE OF VALVE ASSEMBLY | 23090 | TM 0 N, ED50 | 548967.58 | 6346576.26 | Sun Sep 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | UPDATED DESCRIPTION WITH PL NUMBER | 810005197 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | |||
| 0.825451598000029 | 57.2880198830001 | 5 | 4c3dd7bf-46b3-477e-8200-af9b09ae30bb | TEAL WATER INJECTION LINE TEE | PIPE JUNCTION | ANASURIA OPERATING COMPANY LIMITED | TEAL WATER INJECTION LINE TEE (PL1236/PL1236.1/PL1236.2) | ACTIVE | JUNCTION OF PL1236, PL1236.1 AND PL1236.2 | CENTRE OF TEE | 23090 | TM 0 N, ED50 | 549851.3 | 6349965.3 | MODIFY | ADDED COMMENT ON PL NUMBER AND POINT_DESC | 800008601 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 0.808486922000043 | 57.2559427150001 | 6 | 9e0c85ae-0009-47ef-8d56-64d96f844ea3 | GUILLEMOT MID WATER ARCH BS | SUBSEA BUOYANCY | ANASURIA OPERATING COMPANY LIMITED | GUILLEMOT MID WATER ARCH BS | ACTIVE | RELATING TO LINES PL1240 PL1241 PL1239 PL1238 | CENTRE OF ARCH | 23090 | TM 0 N, ED50 | 548871.1 | 6346382.32 | MODIFY | ADDED COMMENT ON PL NUMBER AND POINT_DESC | 800008560 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 0.810041166000076 | 57.2576997040001 | 7 | f3a9b0d4-ac46-44d6-af7a-a79fcc6cf99d | TEE PIECE PL1236 / PL4603 | PIPE JUNCTION | ANASURIA OPERATING COMPANY LIMITED | TEE ON WI PIPELINE PL1236 / PL4603 | ACTIVE | JUNCTION OF PL1236 AND PL4603 (ITHACA ENERGY). WITHIN FPSO 500M ZONE | CENTRE OF TEE | 23090 | TM 0 N, ED50 | 548962.58 | 6346579.02 | Sun Sep 22 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | UPDATED COMMENT TO INCLUDE PL NUMBERS | 810005195 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | |||
| 0.825514157000043 | 57.166824638 | 8 | 3cc6a70c-54d2-4c99-a489-c504a1ceaa7e | ANODE SKID - GUILLEMOT P5 | ANODE ASSEMBLY (PIPELINE) | ANASURIA OPERATING COMPANY LIMITED | ANODE SKID PL3144 | ACTIVE | FOR PROTRCTION OF WARMING SPOOLS ON PL3144 | CENTRE OF ANODE | 23090 | TM 0 N, ED50 | 550018.54 | 6336474.48 | Fri Jun 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | MODIFY | ADDED POINT_DESC AND RELEVANT PL NUMBER | 810001516 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | |||
| 0.847470957000041 | 57.283972992 | 9 | a674163a-f75a-4ce5-b46b-e18fbda459dd | TEAL SUBSEA COOLING COIL | SPOOL PIECE | ANASURIA OPERATING COMPANY LIMITED | TEAL SUBSEA COOLING COIL PL1235 | ACTIVE | CENTRE OF SPOOL | 23090 | TM 0 N, ED50 | 551184.4 | 6349531.5 | MODIFY | UPDATED DESCRIPTION WITH PL NUMBER | 800009930 | Wed Jun 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||
| 0.809319105000043 | 57.256417142 | 10 | 2b7b4c89-6d10-4737-bf2b-cce14ff32a54 | DISTRIBUTED BUOYANCY MODULES 1 | SUBSEA BUOYANCY | ANASURIA OPERATING COMPANY LIMITED | DISTRIBUTED BUOYANCY MODULES 1 PL1234 | ACTIVE | SERIES OF 6 MODULES ON PL1234 | 23090 | TM 0 N, ED50 | 548920.72 | 6346435.73 | MODIFY | ADDED COMMENT ON PL NUMBER | 800010273 | 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" DOUBLE,
"crs_name" VARCHAR,
"orig_x_lon" DOUBLE,
"orig_y_lat" DOUBLE,
"start_date" TIMESTAMP,
"end_date" VARCHAR,
"end_reas" VARCHAR,
"upd_type" VARCHAR,
"upd_reas" VARCHAR,
"legacy_id" DOUBLE,
"upd_date" TIMESTAMP
);