NSTA Sub Areas By Equity Group Holder (BNG)
North Sea Transition Authority
@ukgov.nsta_sub_areas_by_equity_group_holder_bng3
North Sea Transition Authority
@ukgov.nsta_sub_areas_by_equity_group_holder_bng3
CREATE TABLE table_1 (
"objectid" BIGINT,
"subareaid" BIGINT,
"subshortnm" VARCHAR,
"subareanam" VARCHAR,
"blockref" VARCHAR,
"licno" BIGINT,
"licref" VARCHAR,
"eqgrphold" VARCHAR,
"equity" VARCHAR,
"licstartdt" TIMESTAMP,
"licstatus" VARCHAR,
"rndtype" VARCHAR,
"rndno" DOUBLE,
"location" VARCHAR,
"lictype" VARCHAR,
"licsubtype" VARCHAR,
"admorg" VARCHAR,
"admorggrp" VARCHAR,
"licorg" VARCHAR,
"licorggrp" VARCHAR,
"oporg" VARCHAR,
"oporggrp" VARCHAR,
"eqorg" VARCHAR,
"origidatum" VARCHAR,
"blckstrtdt" TIMESTAMP,
"initenddt" TIMESTAMP,
"secenddt" TIMESTAMP,
"eqorggrp" VARCHAR,
"licenddt" TIMESTAMP,
"rndstartdt" TIMESTAMP,
"rndenddt" VARCHAR,
"shapestarea" DOUBLE,
"shapestlength" DOUBLE
);
Anyone who has the link will be able to view this.