NSTA Licensed Blocks History (WGS84)
North Sea Transition Authority
@ukgov.nsta_licensed_blocks_history_wgs843
North Sea Transition Authority
@ukgov.nsta_licensed_blocks_history_wgs843
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
);
Anyone who has the link will be able to view this.