CS Licences WGS84
North Sea Transition Authority
@ukgov.cs_licences_wgs842
Table 1
@ukgov.cs_licences_wgs842.table_1
- 15 KB
- 27 rows
- 15 columns
objectidOBJECTID | licrefLICREF | shape_areaShape, Area | shape_lengthShape, Length | round_noROUND NO | exploration_operatorEXPLORATION OPERATOR | partner_org_1PARTNER ORG 1 | partner_org_2PARTNER ORG 2 | partner_org_3PARTNER ORG 3 | partner_org_4PARTNER ORG 4 | award_processAWARD PROCESS | licstartdtLICSTARTDT | licence_doc_linkLICENCE DOC LINK | pub_reg_linkPUB REG LINK | doc_add_dateDOC ADD DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28 | CS001 | 0.0498949395180514 | 1.10965133513299 | BP EXPLORATION OPERATING COMPANY LIMITED | EQUINOR NEW ENERGY LIMITED | OUT OF ROUND | Fri Nov 02 2012 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/f1vfr40j/carbon-dioxide-appraisal-and-storage-licence-cs001-deed-of-variation-dated-2-april-2024.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | Fri Sep 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 31 | CS005 | 0.109172888126232 | 1.60004451539758 | CHRYSAOR PRODUCTION (UK) LIMITED | OUT OF ROUND | Fri Oct 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/8097/cs005-signed-copy-_redacted.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | Tue Mar 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | |||||
| 32 | CS006 | 0.103061521652516 | 1.666712338379 | BP EXPLORATION OPERATING COMPANY LIMITED | EQUINOR NEW ENERGY LIMITED | OUT OF ROUND | Sun May 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/8156/cs006_licence_redacted-accessabile-1.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 33 | CS007 | 0.0958388930155961 | 1.46670752635751 | BP EXPLORATION OPERATING COMPANY LIMITED | EQUINOR NEW ENERGY LIMITED | OUT OF ROUND | Sun May 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/8157/cs007_licence_redacted-1.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time) | ||||
| 34 | CS025 | 0.0633369958439251 | 1.13336464428664 | 1 | BP EXPLORATION OPERATING COMPANY LIMITED | EQUINOR NEW ENERGY LIMITED | LICENSING ROUND | Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/jqufgg0j/carbon-dioxide-appraisal-and-storage-licence-cs025-deed-of-variation-dated-13-march-2024redacted-1.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | ||||
| 35 | CS023 | 0.050280627321622 | 1.03336221127251 | 1 | CHRYSAOR PRODUCTION (UK) LIMITED | BP EXPLORATION OPERATING COMPANY LIMITED | LICENSING ROUND | Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/mi4pwbak/cs023-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accessability-copy.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | ||||
| 36 | CS024 | 0.0258348075384443 | 0.766687581171139 | 1 | CHRYSAOR PRODUCTION (UK) LIMITED | BP EXPLORATION OPERATING COMPANY LIMITED | LICENSING ROUND | Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/ybrbxpqg/cs024-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accessability-copy.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | ||||
| 37 | CS008 | 0.0844491866926412 | 1.43337155329232 | 1 | ENI UK LIMITED | LICENSING ROUND | Sat Jul 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/44oavkxu/cs008-eni-uk-limited-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accesability-copy.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | |||||
| 38 | CS013 | 0.0400027848757425 | 0.800027848652137 | 1 | ENQUEST CCS LIMITED | LICENSING ROUND | Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/y4dg2wtb/cs013-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accesible-version.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ | |||||
| 39 | CS014 | 0.0166678231977945 | 0.533351216324237 | 1 | ENQUEST CCS LIMITED | LICENSING ROUND | Tue Aug 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time) | https://www.nstauthority.co.uk/media/wfwdjf0h/cs014-carbon-dioxide-appraisal-and-storage-licence-appraisal-term-accessible-version.pdf | https://www.nstauthority.co.uk/licensing-consents/carbon-storage/ |
CREATE TABLE table_1 (
"objectid" BIGINT,
"licref" VARCHAR,
"shape_area" DOUBLE,
"shape_length" DOUBLE,
"round_no" DOUBLE,
"exploration_operator" VARCHAR,
"partner_org_1" VARCHAR,
"partner_org_2" VARCHAR,
"partner_org_3" VARCHAR,
"partner_org_4" VARCHAR,
"award_process" VARCHAR,
"licstartdt" TIMESTAMP,
"licence_doc_link" VARCHAR,
"pub_reg_link" VARCHAR,
"doc_add_date" TIMESTAMP
);