Name: OGA Licences ETRS89
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

OGA Licences ETRS89

Licence boundaries covering both onshore and offshore UK taken directly from OGA's Petroleum E-business, Assignment and Relinquishment System (PEARS)
Publisher name: North Sea Transition Authority
Last updated: 2023-11-23T03:28:29Z

Tables

Table 1

@ukgov.oga_licences_etrs89.table_1

118.6 KB
456 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
);