NSTA Licensed And Unlicensed Blocks (WGS84)

North Sea Transition Authority

@ukgov.nsta_licensed_and_unlicensed_blocks_wgs842

Table List

1 table(319.52 KB)

Table 1

@ukgov.nsta_licensed_and_unlicensed_blocks_wgs842.table_1

319.52 KB
8208 rows
32 columns

objectid OBJECTID	quadno QUADNO	blockno BLOCKNO	blocksuffi BLOCKSUFFI	blockref BLOCKREF	location LOCATION	licensed LICENSED	shapestarea SHAPESTArea	shapestlength SHAPESTLength
2820776	TF	6		TF6	ONSHORE	No	0.0134436087654247	0.478940712430349
2820777	SK	52	c	SK52c	ONSHORE	No	0.0052674271193667	0.386466177096395
2820778	164	28		164/28	OFFSHORE	No	0.0333333334	0.733333334
2820779	164	29		164/29	OFFSHORE	No	0.0333333334	0.733333334
2820780	154	1		154/1	OFFSHORE	No	0.0333333334	0.733333334
2820781	154	2		154/2	OFFSHORE	No	0.0333333334	0.733333334
2820782	154	3		154/3	OFFSHORE	No	0.0333333334	0.733333334
2820783	164	18		164/18	OFFSHORE	No	0.0333333332	0.733333332
2820784	164	19		164/19	OFFSHORE	No	0.0333333332	0.733333332
2820785	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
);