Baselight

NSTA Licensed Blocks History (WGS84)

North Sea Transition Authority

@ukgov.nsta_licensed_blocks_history_wgs843

Loading...
Loading...

About this Dataset

NSTA Licensed Blocks History (WGS84)

{{description}}
Publisher name: North Sea Transition Authority
Last updated: 2025-06-05T04:00:27Z

Tables

Table 1

@ukgov.nsta_licensed_blocks_history_wgs843.table_1
  • 822.76 KB
  • 9116 rows
  • 31 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.