Name: OGA Licensed Blocks WGS84
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

OGA Licensed Blocks WGS84

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:36:51Z

Tables

Table 1

@ukgov.oga_licensed_blocks_wgs84.table_1

120.74 KB
998 rows
34 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "licblockid" BIGINT,
  "quadno" VARCHAR,
  "blockno" BIGINT,
  "blocksuffi" VARCHAR,
  "blockref" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "agreed_km2" DOUBLE,
  "calc_km2" DOUBLE,
  "lictype" VARCHAR,
  "licno" BIGINT,
  "licref" VARCHAR,
  "licstartdt" TIMESTAMP,
  "initenddt" TIMESTAMP,
  "secenddt" TIMESTAMP,
  "licenddt" TIMESTAMP,
  "licstatus" VARCHAR,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "location" VARCHAR,
  "licsubtype" VARCHAR,
  "origidatum" VARCHAR,
  "admorg" VARCHAR,
  "admorggrp" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "oporg" VARCHAR,
  "oporggrp" VARCHAR,
  "team_lead" VARCHAR,
  "region" VARCHAR,
  "rndstartdt" TIMESTAMP,
  "rndenddt" TIMESTAMP,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);