NSTA Licensed And Unlicensed Blocks (WGS84)

North Sea Transition Authority

@ukgov.nsta_licensed_and_unlicensed_blocks_wgs84

Table List

1 table(319.21 KB)

Table 1

@ukgov.nsta_licensed_and_unlicensed_blocks_wgs84.table_1

319.21 KB
8212 rows
32 columns

objectid OBJECTID	quadno QUADNO	blockno BLOCKNO	blocksuffi BLOCKSUFFI	blockref BLOCKREF	location LOCATION	licensed LICENSED	shapestarea SHAPESTArea	shapestlength SHAPESTLength
2771516	TF	6		TF6	ONSHORE	No	0.0134436087654247	0.478940712430349
2771517	SK	52	c	SK52c	ONSHORE	No	0.0052674271193667	0.386466177096395
2771518	164	28		164/28	OFFSHORE	No	0.0333333334	0.733333334
2771519	164	29		164/29	OFFSHORE	No	0.0333333334	0.733333334
2771520	154	1		154/1	OFFSHORE	No	0.0333333334	0.733333334
2771521	154	2		154/2	OFFSHORE	No	0.0333333334	0.733333334
2771522	154	3		154/3	OFFSHORE	No	0.0333333334	0.733333334
2771523	164	18		164/18	OFFSHORE	No	0.0333333332	0.733333332
2771524	164	19		164/19	OFFSHORE	No	0.0333333332	0.733333332
2771525	164	23		164/23	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,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "rndstartdt" TIMESTAMP,
  "rndenddt" TIMESTAMP,
  "licensed" VARCHAR,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);