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

About this Dataset

OGA SubAreas 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:22:42Z

Tables

Table 1

@ukgov.oga_subareas_wgs84.table_1

137.09 KB
1221 rows
31 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "subareaid" BIGINT,
  "subshortnm" VARCHAR,
  "subareanam" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "lictype" VARCHAR,
  "licno" BIGINT,
  "licref" VARCHAR,
  "licstartdt" TIMESTAMP,
  "initenddt" TIMESTAMP,
  "secenddt" TIMESTAMP,
  "licenddt" VARCHAR,
  "licstatus" VARCHAR,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "location" VARCHAR,
  "licsubtype" VARCHAR,
  "blockref" VARCHAR,
  "admorg" VARCHAR,
  "admorggrp" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "oporg" VARCHAR,
  "oporggrp" VARCHAR,
  "eqorg" VARCHAR,
  "eqorggrp" VARCHAR,
  "origidatum" VARCHAR,
  "rndstartdt" TIMESTAMP,
  "rndenddt" TIMESTAMP,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);