NSTA Licensed And Unlicensed Blocks (BNG)

North Sea Transition Authority

@ukgov.nsta_licensed_and_unlicensed_blocks_bng3

Table List

1 table(94.48 KB)

Table 1

@ukgov.nsta_licensed_and_unlicensed_blocks_bng3.table_1

94.48 KB
3336 rows
32 columns

objectid OBJECTID	quadno QUADNO	blockno BLOCKNO	blocksuffi BLOCKSUFFI	blockref BLOCKREF	location LOCATION	licensed LICENSED	shapestarea SHAPESTArea	shapestlength SHAPESTLength
570784	SK	52	c	SK52c	ONSHORE	No	39500000	30000
570785	SD	64		SD64	ONSHORE	No	100000000	40000
570786	SK	63		SK63	ONSHORE	No	100000000	40000
570787	SS	98		SS98	ONSHORE	No	100000000	40000
570788	SS	78		SS78	ONSHORE	No	100000000	40000
570789	SS	88		SS88	ONSHORE	No	100000000	40000
570790	SS	69		SS69	ONSHORE	No	100000000	40000
570791	ST	38		ST38	ONSHORE	No	100000000	40000
570792	SN	80		SN80	ONSHORE	No	100000000	40000
570793	SS	99		SS99	ONSHORE	No	100000000	40000


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
);