UKCS SubAreas WGS84
North Sea Transition Authority
@ukgov.ukcs_subareas_wgs843
North Sea Transition Authority
@ukgov.ukcs_subareas_wgs843
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
);
Anyone who has the link will be able to view this.