31st Round Provisional Awards (WGS84)

North Sea Transition Authority

@ukgov.n_31st_round_provisional_awards_wgs843

Table List

1 table(17.26 KB)

Table 1

@ukgov.n_31st_round_provisional_awards_wgs843.table_1

17.26 KB
148 rows
15 columns

objectid OBJECTID	quadno QUADNO	blockno BLOCKNO	blocksuff BLOCKSUFF	blockref BLOCKREF	roundtype ROUNDTYPE	roundref ROUNDREF	licadmin LICADMIN	sourcesrs SOURCESRS	areasqkm AREASQKM	admconname ADMCONNAME	admconmail ADMCONMAIL	shapestarea ShapeSTArea	shapestlength ShapeSTLength
496	2	10	a	2/10a	F	31	CYCLE PETROLEUM LIMITED	ED 50	182.28505364	Mr. Daniel Baltar Pardo	daniel.baltar@cycle-petroleum.com	0.0300020375205318	0.733357904495089
497	3	1		3/1	F	31	CYCLE PETROLEUM LIMITED	ED 50	201.51390392	Mr. Daniel Baltar Pardo	daniel.baltar@cycle-petroleum.com	0.0333356101937823	0.733358059502851
498	3	11	c	3/11c	F	31	CYCLE PETROLEUM LIMITED	ED 50	54.21680108	Mr. Daniel Baltar Pardo	daniel.baltar@cycle-petroleum.com	0.0088894919102822	0.466681536207059
499	3	2	e	3/2e	F	31	CYCLE PETROLEUM LIMITED	ED 50	16.82429448	Mr. Daniel Baltar Pardo	daniel.baltar@cycle-petroleum.com	0.0027779675189092	0.233341143150013
500	3	6	b	3/6b	F	31	CYCLE PETROLEUM LIMITED	ED 50	189.04847123	Mr. Daniel Baltar Pardo	daniel.baltar@cycle-petroleum.com	0.0311132267113775	0.733357955491509
501	3	7	b	3/7b	F	31	CYCLE PETROLEUM LIMITED	ED 50	101.21510295	Mr. Daniel Baltar Pardo	daniel.baltar@cycle-petroleum.com	0.0166678040049906	0.70002369648639
502	3	11	d	3/11d	F	31	CYCLE PETROLEUM LIMITED	ED 50	79.81785753	Mr. Daniel Baltar Pardo	daniel.baltar@cycle-petroleum.com	0.0130564395509282	0.666688581390442
503	3	12	b	3/12b	F	31	CORALLIAN ENERGY LIMITED	ED 50	135.82809288	Mr David Gaudoin	dave.gaudoin@corallian.co.uk	0.0222237303505546	0.73335788847772
504	3	17	b	3/17b	F	31	CORALLIAN ENERGY LIMITED	ED 50	68.2158175	Mr David Gaudoin	dave.gaudoin@corallian.co.uk	0.0111118625584205	0.466683399444734
505	3	18		3/18	F	31	CORALLIAN ENERGY LIMITED	ED 50	204.6472172	Mr David Gaudoin	dave.gaudoin@corallian.co.uk	0.0333355905252747	0.733357846463388


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "quadno" BIGINT,
  "blockno" BIGINT,
  "blocksuff" VARCHAR,
  "blockref" VARCHAR,
  "roundtype" VARCHAR,
  "roundref" BIGINT,
  "licadmin" VARCHAR,
  "sourcesrs" VARCHAR,
  "areasqkm" DOUBLE,
  "admconname" VARCHAR,
  "admconmail" VARCHAR,
  "tranche" VARCHAR,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);