NSTA Offshore Licence Relinquishments (WGS84)

North Sea Transition Authority

@ukgov.nsta_offshore_licence_relinquishments_wgs844

Table List

1 table(492.87 KB)

Table 1

@ukgov.nsta_offshore_licence_relinquishments_wgs844.table_1

492.87 KB
7345 rows
31 columns

objectid OBJECTID	blockref BLOCKREF	quadno QUADNO	blockno BLOCKNO	blocksuffi BLOCKSUFFI	licref LICREF	lictype LICTYPE	licno LICNO	rndtype RNDTYPE	rndno RNDNO	subareaorg SUBAREAORG	sareaorgrp SAREAORGRP	reldate RELDATE	location LOCATION	origdatum ORIGDATUM	relreport RELREPORT	blckstrtdt BLCKSTRTDT	reportadd REPORTADD	created_user Created User	created_date Created Date	last_edited_user Last Edited User	last_edited_date Last Edited Date	rel_check REL CHECK	link LINK	shapestarea SHAPESTArea	shapestlength SHAPESTLength
1	109/10	109	10		P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0333351249050593	0.733352705247744
2	109/5	109	5		P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0333351332221233	0.733352794252318
3	110/6	110	6		P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0333351289217541	0.733352751246297
4	110/7b	110	7	b	P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0305572051963583	0.900024470333261
5	110/1	110	1		P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0333351371388189	0.733352839250871
6	112/30	112	30		P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.019010976898182	0.648435056973128
7	109/15	109	15		P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0333351166880012	0.733352617243344
8	110/12c	110	12	c	P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0038890982822337	0.400011098160177
9	110/11	110	11		P2489	P	2489	F	31	NO OPERATOR	NO OPERATOR	Thu Jul 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf	Mon Oct 14 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2489_109_5_10_15_110_1_6_7b_11_12c_112_30_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0333351207880332	0.733352664241946
10	22/4b	22	4	b	P2374	P	2374	F	30	NO OPERATOR	NO OPERATOR	Fri Sep 30 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFSHORE	ED 50	https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2374_22_3_22_4b_22_8b_22_9b_Harbour_Energy_RelReport_Aug23.pdf	Thu Sep 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Thu Feb 15 2024 03:41:07 GMT+0000 (Coordinated Universal Time)	OGAEXTERNAL	Mon Jan 13 2025 03:31:00 GMT+0000 (Coordinated Universal Time)	Full	<a href="https://datanstauthority.blob.core.windows.net/external/relinqs/2023_09/P2374_22_3_22_4b_22_8b_22_9b_Harbour_Energy_RelReport_Aug23.pdf">Click Here</a>	0.0305575028405762	0.733356376333445


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "blockref" VARCHAR,
  "quadno" BIGINT,
  "blockno" BIGINT,
  "blocksuffi" VARCHAR,
  "licref" VARCHAR,
  "lictype" VARCHAR,
  "licno" BIGINT,
  "rndtype" VARCHAR,
  "rndno" DOUBLE,
  "admorg" VARCHAR,
  "admorggrp" VARCHAR,
  "licorg" VARCHAR,
  "licorggrp" VARCHAR,
  "subareaorg" VARCHAR,
  "sareaorgrp" VARCHAR,
  "reldate" TIMESTAMP,
  "location" VARCHAR,
  "origdatum" VARCHAR,
  "relreport" VARCHAR,
  "blckstrtdt" TIMESTAMP,
  "reportadd" TIMESTAMP,
  "shape" VARCHAR,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "rel_check" VARCHAR,
  "link" VARCHAR,
  "shapestarea" DOUBLE,
  "shapestlength" DOUBLE
);