Dataset: UKCS Licences WGS84

About this Dataset

UKCS Licences WGS84

A Licence is a geographically defined area for prospecting, exploration or extraction of petroleum resources. The North Sea Transition Authority’s licensing system covers oil and gas within Great Britain, its territorial sea and on the UK Continental Shelf (UKCS).
The Petroleum Act 1998 vests all rights to the nation’s petroleum resources in the Crown, but the NSTA can grant licences that confer exclusive rights to ‘search and bore for and get’ petroleum.
Licences fall into several categories. The principal distinctions are between onshore and offshore licences, and between exploration licences (which cover exploration alone) and production licences (which cover both exploration and production). The NSTA has discretion in the granting of licences to help maximise the economic recovery of the UK’s oil and gas resources.
Licence data is represented by 3 different datasets; Licences, Licence Blocks and Sub Areas. Licence polygons represent the whole licence and have one polygon per licence. Licenced Blocks and Sub areas represent finer divisions of these licences and may have many polygons per licence. Most Licenced Blocks are split with several sub areas, sometimes with differing operators and beneficiaries.
Publisher name: North Sea Transition Authority
Last updated: 2025-06-06T04:00:25Z

Tables

Table 1

@ukgov.ukcs_licences_wgs843.table_1

118.31 KB
452 rows
49 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "datapid" BIGINT,
  "location" VARCHAR,
  "licno" BIGINT,
  "licprefix" VARCHAR,
  "lictype" VARCHAR,
  "licref" VARCHAR,
  "licstatus" VARCHAR,
  "blockref" VARCHAR,
  "fields" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "suboporg" VARCHAR,
  "subopgrps" VARCHAR,
  "regions" VARCHAR,
  "licstartdt" TIMESTAMP,
  "licenddt" VARCHAR,
  "licexpdt" TIMESTAMP,
  "licschsttd" TIMESTAMP,
  "schevents" VARCHAR,
  "agreed_km2" DOUBLE,
  "calc_km2" DOUBLE,
  "ph_a_start" TIMESTAMP,
  "ph_a_end" TIMESTAMP,
  "ph_b_start" TIMESTAMP,
  "ph_b_end" TIMESTAMP,
  "ph_c_start" TIMESTAMP,
  "ph_c_end" TIMESTAMP,
  "tm_1_start" TIMESTAMP,
  "tm_1_end" TIMESTAMP,
  "tm_2_start" TIMESTAMP,
  "tm_2_end" TIMESTAMP,
  "tm_3_start" TIMESTAMP,
  "tm_3_end" TIMESTAMP,
  "no_extns" BIGINT,
  "hastm1" VARCHAR,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "rndstartdt" TIMESTAMP,
  "rndenddt" TIMESTAMP,
  "admorg" VARCHAR,
  "admhistnme" VARCHAR,
  "admprvnams" VARCHAR,
  "admorgno" VARCHAR,
  "admorggrp" VARCHAR,
  "url" VARCHAR,
  "pdfdateadd" TIMESTAMP,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);