PPRS View

North Sea Transition Authority

@ukgov.pprs_view2

Table List

1 table(7.16 MB)

Table 1

@ukgov.pprs_view2.table_1

7.16 MB
128888 rows
48 columns

x X	y Y	objectid OBJECTID	fieldname FIELDNAME	fieldarea FIELDAREA	location LOCATION	orggrpnm ORGGRPNM	unitname UNITNAME	unittypcod UNITTYPCOD	unittypdes UNITTYPDES	periodyrmn PERIODYRMN	periodyr PERIODYR	periodmnth PERIODMNTH	periodmnnm PERIODMNNM	perioddate PERIODDATE	oilprodmas OILPRODMAS	oilprodm3 OILPRODM3	oilprodmbd OILPRODMBD	oilprddens OILPRDDENS	agasprodma AGASPRODMA	agasproksm AGASPROKSM	agaspromms AGASPROMMS	agasproden AGASPRODEN	gasflarvol GASFLARVOL	gasflarden GASFLARDEN	gasflarnh GASFLARNH	gasventvol GASVENTVOL	gasventden GASVENTDEN	gasventnh GASVENTNH	watprodvol WATPRODVOL	watprodmbd WATPRODMBD	gaspipcv GASPIPCV	gaspipvol GASPIPVOL	gaspipvolm GASPIPVOLM	gaspipdens GASPIPDENS
1.88971914782729	56.7957565878753	1	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202210	2022	10	October	Sat Oct 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	6948.1176	8963	1.81862161290323	775.2	2703.39	2787	3.17493241935484	0.97	8.728	1.321	3.02	5	1.368	3.02	1393	0.282644193548387	50.66	2431	2.76937951612903	0.977
1.88971914782729	56.7957565878753	2	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202211	2022	11	November	Tue Nov 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	16983.0378	21891	4.589813	775.8	6191.91	6390	7.522095	0.969	0.97	0.92	3.02	12	1.368	3.02	2599	0.544923666666667	50.7	5540	6.52150333333333	0.978
1.88971914782729	56.7957565878753	3	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202212	2022	12	December	Thu Dec 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	15525.4893	20051	4.06841258064516	774.3	5723.315	5993	6.82718693548387	0.955	2.909	1.189	3.02	12	1.368	3.02	2244	0.455314838709677	49.98	5182	5.90330096774194	0.962
1.88971914782729	56.7957565878753	4	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202301	2023	1	January	Sun Jan 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	15987.7248	20672	4.19441548387097	773.4	5392.972	5606	6.38631903225806	0.962	2.909	1.125	3.02			3.02	373	0.0756829032258065	50.36	4767	5.43053564516129	0.972
1.88971914782729	56.7957565878753	5	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202302	2023	2	February	Wed Feb 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11877.456	15306	3.43838357142857	776	3579.6	3800	4.79275	0.942	12	1.076	3.02			3.02	277	0.0622260714285714	49.27	3130	3.9477125	0.948
1.88971914782729	56.7957565878753	6	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202303	2023	3	March	Wed Mar 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	2100.8378	2701	0.548041612903226	777.8	892.925	935	1.06514596774194	0.955			3.02			3.02	81	0.0164351612903226	49.7	820	0.934138709677419	0.959
1.88971914782729	56.7957565878753	7	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202304	2023	4	April	Sat Apr 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	16368.1119	21009	4.404887	779.1	5574.657	5753	6.77223983333333	0.969	0.97	0.981	3.02			3.02	443	0.0928823333333333	50.59	4870	5.73280166666667	0.977
1.88971914782729	56.7957565878753	8	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202305	2023	5	May	Mon May 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	15930.72	20424	4.14409548387097	780	5150.235	5315	6.05481370967742	0.969			3.02			3.02	449	0.0911035483870968	50.66	4436	5.05346258064516	0.979
1.88971914782729	56.7957565878753	9	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202306	2023	6	June	Thu Jun 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	14670.1548	18779	3.93733033333333	781.2	4709.544	4947	5.8234435	0.952	2.909	1.357	3.02			3.02	473	0.0991723333333333	49.71	4123	4.85345816666667	0.961
1.88971914782729	56.7957565878753	10	ABIGAIL	CNS	Offshore	ITHACA ENERGY	ABIGAIL	P	Oil Field Exporting to Pipeline	202307	2023	7	July	Sat Jul 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	13938.0218	17819	3.61553258064516	782.2	4694.4	4800	5.46812903225806	0.978	2	1.11					457	0.0927267741935484	51.21	3973	4.52601596774194	0.992


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "fieldname" VARCHAR,
  "fieldarea" VARCHAR,
  "location" VARCHAR,
  "orggrpnm" VARCHAR,
  "unitname" VARCHAR,
  "unittypcod" VARCHAR,
  "unittypdes" VARCHAR,
  "periodyrmn" BIGINT,
  "periodyr" BIGINT,
  "periodmnth" BIGINT,
  "periodmnnm" VARCHAR,
  "perioddate" TIMESTAMP,
  "oilprodmas" DOUBLE,
  "oilprodm3" DOUBLE,
  "oilprodmbd" DOUBLE,
  "oilprddens" DOUBLE,
  "agasprodma" DOUBLE,
  "agasproksm" DOUBLE,
  "agaspromms" DOUBLE,
  "agasproden" DOUBLE,
  "dgasprodma" DOUBLE,
  "dgasproksm" DOUBLE,
  "dgaspromms" DOUBLE,
  "dgasproden" DOUBLE,
  "gcondmass" DOUBLE,
  "gcondvol" DOUBLE,
  "gcondmbd" DOUBLE,
  "gcondden" DOUBLE,
  "gasinjcv" DOUBLE,
  "gasinjvol" DOUBLE,
  "gasflarvol" DOUBLE,
  "gasflarden" DOUBLE,
  "gasflarnh" DOUBLE,
  "gasventvol" DOUBLE,
  "gasventden" DOUBLE,
  "gasventnh" DOUBLE,
  "injwatvol" DOUBLE,
  "injwatmbd" DOUBLE,
  "watprodvol" DOUBLE,
  "watprodmbd" DOUBLE,
  "reinjwatvo" DOUBLE,
  "gaspipcv" DOUBLE,
  "gaspipvol" DOUBLE,
  "gaspipvolm" DOUBLE,
  "gaspipdens" DOUBLE
);