NSTA Licensed And Unlicensed Blocks (ED50)

North Sea Transition Authority

@ukgov.nsta_licensed_and_unlicensed_blocks_ed502

Table List

1 table(315.96 KB)

Table 1

@ukgov.nsta_licensed_and_unlicensed_blocks_ed502.table_1

315.96 KB
8208 rows
32 columns

objectid OBJECTID	quadno QUADNO	blockno BLOCKNO	blocksuffi BLOCKSUFFI	blockref BLOCKREF	location LOCATION	licensed LICENSED	shapestarea SHAPESTArea	shapestlength SHAPESTLength
2828776	TF	6		TF6	ONSHORE	No	0.013442868099758	0.478928096786031
2828777	SK	52	c	SK52c	ONSHORE	No	0.0052671421457644	0.386456625508325
2828778	164	28		164/28	OFFSHORE	No	0.0333313480697332	0.73331192850972
2828779	164	29		164/29	OFFSHORE	No	0.0333313433197587	0.733311873507108
2828780	154	1		154/1	OFFSHORE	No	0.0333313657524359	0.733312127504097
2828781	154	2		154/2	OFFSHORE	No	0.0333313611024627	0.733312073501514
2828782	154	3		154/3	OFFSHORE	No	0.0333313566191593	0.733312021498965
2828783	164	18		164/18	OFFSHORE	No	0.0333313308042317	0.73331174053211
2828784	164	19		164/19	OFFSHORE	No	0.0333313261542588	0.733311686529456
2828785	164	23		164/23	OFFSHORE	No	0.0333313393369838	0.733311833520852


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