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

About this Dataset

OGA Licensed Blocks History WGS84

There is no description available.
Publisher name: North Sea Transition Authority
Last updated: 2023-11-23T03:37:26Z

Tables

Table 1

@ukgov.oga_licensed_blocks_history_wgs84.table_1

822.37 KB
9114 rows
31 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "licblockid" BIGINT,
  "quadno" VARCHAR,
  "blockno" BIGINT,
  "suffix" VARCHAR,
  "blockref" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "blckenddt" TIMESTAMP,
  "agreed_km2" DOUBLE,
  "calc_km2" DOUBLE,
  "lictype" VARCHAR,
  "licno" BIGINT,
  "licref" VARCHAR,
  "licstartdt" 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,
  "admhisname" VARCHAR,
  "lichisname" VARCHAR,
  "ophisnames" VARCHAR,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);