NSTA Licensed And Unlicensed Blocks (ETRS89)

North Sea Transition Authority

@ukgov.nsta_licensed_and_unlicensed_blocks_etrs893

Table List

1 table(326.14 KB)

Table 1

@ukgov.nsta_licensed_and_unlicensed_blocks_etrs893.table_1

326.14 KB
8277 rows
32 columns

objectid OBJECTID	quadno QUADNO	blockno BLOCKNO	blocksuffi BLOCKSUFFI	blockref BLOCKREF	location LOCATION	licensed LICENSED	shapestarea SHAPESTArea	shapestlength SHAPESTLength
1402754	TF	6		TF6	ONSHORE	No	0.0134436087654247	0.478940712430349
1402755	TF	7	d	TF7d	ONSHORE	No	0.0004955267821375	0.10047603962304
1402756	TF	7	e	TF7e	ONSHORE	No	0.0040744710302848	0.44037863513228
1402757	SK	52	c	SK52c	ONSHORE	No	0.0052674271193667	0.386466177096395
1402758	164	28		164/28	OFFSHORE	No	0.0333333334	0.733333334
1402759	164	29		164/29	OFFSHORE	No	0.0333333334	0.733333334
1402760	154	1		154/1	OFFSHORE	No	0.0333333334	0.733333334
1402761	154	2		154/2	OFFSHORE	No	0.0333333334	0.733333334
1402762	154	3		154/3	OFFSHORE	No	0.0333333334	0.733333334
1402763	164	18		164/18	OFFSHORE	No	0.0333333334	0.733333334


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "licblockid" DOUBLE,
  "quadno" VARCHAR,
  "blockno" BIGINT,
  "blocksuffi" VARCHAR,
  "blockref" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "agreed_km2" DOUBLE,
  "calc_km2" DOUBLE,
  "location" VARCHAR,
  "lictype" VARCHAR,
  "licno" DOUBLE,
  "licref" VARCHAR,
  "licsubtype" VARCHAR,
  "licstartdt" TIMESTAMP,
  "initenddt" TIMESTAMP,
  "secenddt" TIMESTAMP,
  "licenddt" TIMESTAMP,
  "licstatus" VARCHAR,
  "admorg" VARCHAR,
  "admorggrp" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "oporg" VARCHAR,
  "oporggrp" VARCHAR,
  "licensed" VARCHAR,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "rndstartdt" TIMESTAMP,
  "rndenddt" TIMESTAMP,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);