UKCS Licences WGS84
North Sea Transition Authority
@ukgov.ukcs_licences_wgs843
North Sea Transition Authority
@ukgov.ukcs_licences_wgs843
CREATE TABLE table_1 (
"objectid" BIGINT,
"datapid" BIGINT,
"location" VARCHAR,
"licno" BIGINT,
"licprefix" VARCHAR,
"lictype" VARCHAR,
"licref" VARCHAR,
"licstatus" VARCHAR,
"blockref" VARCHAR,
"fields" VARCHAR,
"licorg" VARCHAR,
"licorggrp" VARCHAR,
"suboporg" VARCHAR,
"subopgrps" VARCHAR,
"regions" VARCHAR,
"licstartdt" TIMESTAMP,
"licenddt" VARCHAR,
"licexpdt" TIMESTAMP,
"licschsttd" TIMESTAMP,
"schevents" VARCHAR,
"agreed_km2" DOUBLE,
"calc_km2" DOUBLE,
"ph_a_start" TIMESTAMP,
"ph_a_end" TIMESTAMP,
"ph_b_start" TIMESTAMP,
"ph_b_end" TIMESTAMP,
"ph_c_start" TIMESTAMP,
"ph_c_end" TIMESTAMP,
"tm_1_start" TIMESTAMP,
"tm_1_end" TIMESTAMP,
"tm_2_start" TIMESTAMP,
"tm_2_end" TIMESTAMP,
"tm_3_start" TIMESTAMP,
"tm_3_end" TIMESTAMP,
"no_extns" BIGINT,
"hastm1" VARCHAR,
"rndtype" VARCHAR,
"rndno" DOUBLE,
"rndstartdt" TIMESTAMP,
"rndenddt" TIMESTAMP,
"admorg" VARCHAR,
"admhistnme" VARCHAR,
"admprvnams" VARCHAR,
"admorgno" VARCHAR,
"admorggrp" VARCHAR,
"url" VARCHAR,
"pdfdateadd" TIMESTAMP,
"shapestarea" DOUBLE,
"shapestlength" DOUBLE
);
Anyone who has the link will be able to view this.