Onshore Wells (BNG)

North Sea Transition Authority

@ukgov.onshore_wells_bng2

Table List

1 table(454.33 KB)

Table 1

@ukgov.onshore_wells_bng2.table_1

454.33 KB
2135 rows
124 columns
Only the first 100 columns are shown

x X	y Y	objectid OBJECTID	w_id W ID	wellboreid WELLBOREID	wellregno WELLREGNO	spuddate SPUDDATE	datetdreac DATETDREAC	compledate COMPLEDATE	releasedat RELEASEDAT	targetfld TARGETFLD	licno LICNO	lictype LICTYPE	origintent ORIGINTENT	currwellin CURRWELLIN	deviattyp DEVIATTYP	datumtype DATUMTYPE	datelev_f DATELEV F	datelev_m DATELEV M	topholedtm TOPHOLEDTM	topholeyng TOPHOLEYNG	topholexng TOPHOLEXNG	botholedtm BOTHOLEDTM	bh_easting BH EASTING	bh_northin BH NORTHIN	tddepdatty TDDEPDATTY	tddatdep_f TDDATDEP F	tddatdep_m TDDATDEP M	tdmddepf TDMDDEPF	tdmddepm TDMDDEPM	tdtvdssf TDTVDSSF	tdtvdssm TDTVDSSM	wellorigin WELLORIGIN	originstat ORIGINSTAT	complestat COMPLESTAT	wellopstat WELLOPSTAT	name NAME	devtype DEVTYPE	drillseqno DRILLSEQNO	discovery DISCOVERY	regowned REGOWNED	licconfper LICCONFPER	wellsymbol WELLSYMBOL	mapsymdesc MAPSYMDESC	flowclass FLOWCLASS	fluidtypes FLUIDTYPES	origopname ORIGOPNAME	wellconven WELLCONVEN	releaseno RELEASENO	strkdtmty STRKDTMTY	stmddatf STMDDATF
545730	107750	1	7029	192430	L100/01- 1	Wed Apr 01 1936 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 02 1936 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 03 1936 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Apr 05 1941 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	A12		Exploration	Exploration	Vertical	Rotary Table	55	16.76399997	OSGB NG	107750	545730	OSGB NG	545730	107750	Rotary Table	55	16.76399997	76	23.16479996	21	6.40079999	L100/01- 1	Decommissioned	Abandoned Phase 3	Decomissioned	LEWES 1		1	N	N	5	4	Dry Hole	Dry Hole		D'ARCY EXPLORATION CO LTD	Conventional	6	Rotary Table	55
547936	114823	2	6473	192088	L100/01- 2	Sun Aug 09 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Aug 19 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 20 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 20 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	PL247	PL	Exploration	Exploration	Deviated	Kelly Bushing	120	36.57599994	OSGB NG	114823	547936	OSGB NG	546998	114971	Kelly Bushing	120	36.57599994	4551	1387.14479789	2865	873.25199867	L100/01- 2	Decommissioned	Abandoned Phase 3	Decomissioned	RINGMER 1		2	N	Y	5	4	Dry Hole	Dry Hole		CONOCOPHILLIPS (U.K.) LIMITED	Conventional	13	Kelly Bushing	120
558030	121350	3	13097	191151	L100/02- 1	Wed Jan 01 1902 00:00:00 GMT+0000 (Coordinated Universal Time)		Wed Jan 01 1902 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 01 1907 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	No Data Available	No Data Available	Exploration	Exploration	Vertical	Ground Level Elevation	450	137.15999979	OSGB NG	121350	558030	OSGB NG	558030	121350				377	114.90959983	-73	-22.25039997	L100/02- 1	Decommissioned	Abandoned Phase 3	Decomissioned	HEATHFIELD 2	Producer	1	Y	N	5	18	Gas Producing Well	Gas Well	Gas		Conventional	22
558872	114656	4	6474	192092	L100/02- 10	Mon Jun 02 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 13 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jun 14 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 14 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	PL247	PL	Exploration	Exploration	Vertical	Kelly Bushing	128	39.01439994	OSGB NG	114656	558872	OSGB NG	558872	114656	Kelly Bushing	128	39.01439994	3220	981.45599851	3085	940.30799857	L100/02- 10	Decommissioned	Abandoned Phase 3	Decomissioned	HELLINGLY 2		10	N	Y	5	4	Dry Hole	Dry Hole		CONOCOPHILLIPS (U.K.) LIMITED	Conventional	13	Kelly Bushing	128
558110	121380	5	13098	191158	L100/02- 2	Fri Feb 28 1902 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Feb 28 1902 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Feb 28 1907 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	No Data Available	No Data Available	Exploration	Exploration	Vertical				OSGB NG	121380	558110	OSGB NG	558110	121380								L100/02- 2	Decommissioned	Abandoned Phase 3	Decomissioned	HEATHFIELD 3	Producer	2	N	N	5	18	Gas Producing Well	Gas Well	Gas	NATURAL GAS FIELDS OF ENGLAND LTD	Conventional	22
558280	121420	6	13099	191327	L100/02- 3	Wed Apr 30 1902 00:00:00 GMT+0000 (Coordinated Universal Time)		Wed Apr 30 1902 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 30 1907 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	No Data Available	No Data Available	Exploration	Exploration	Vertical				OSGB NG	121420	558280	OSGB NG	558280	121420								L100/02- 3	Decommissioned	Abandoned Phase 3	Decomissioned	HEATHFIELD 4	Producer	3	N	N	5	18	Gas Producing Well	Gas Well	Gas	NATURAL GAS FIELDS OF ENGLAND LTD	Conventional	22
558340	121620	7	13100	191157	L100/02- 4	Mon Jun 30 1902 00:00:00 GMT+0000 (Coordinated Universal Time)		Mon Jun 30 1902 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 30 1907 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	No Data Available	No Data Available	Exploration	Exploration	Vertical				OSGB NG	121620	558340	OSGB NG	558340	121620								L100/02- 4	Decommissioned	Abandoned Phase 3	Decomissioned	HEATHFIELD 5		4	N	N	5	4	Dry Hole	Dry Hole		NATURAL GAS FIELDS OF ENGLAND LTD	Conventional	22
558170	120650	8	13101	192538	L100/02- 5	Sun Aug 31 1902 00:00:00 GMT+0000 (Coordinated Universal Time)		Sun Aug 31 1902 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Aug 31 1907 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	No Data Available	No Data Available	Exploration	Exploration	Vertical				OSGB NG	120650	558170	OSGB NG	558170	120650								L100/02- 5	Decommissioned	Abandoned Phase 3	Decomissioned	HEATHFIELD 6	Producer	5	N	N	5	18	Gas Producing Well	Gas Well	Gas	NATURAL GAS FIELDS OF ENGLAND LTD	Conventional	22
562140	106620	9	13273	191357	L100/02- 6	Tue Apr 14 1936 00:00:00 GMT+0000 (Coordinated Universal Time)		Fri Apr 17 1936 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Apr 17 1941 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	A12		Exploration	Exploration	Vertical	Ground Level Elevation	34	10.36319998	OSGB NG	106620	562140	OSGB NG	562140	106620	Ground Level Elevation	34	10.36319998	219	66.7511999	185	56.38799991	L100/02- 6	Decommissioned	Abandoned Phase 3	Decomissioned	PEVENSEY G4 (RICKNEY)		6	N	N	5	3	Hydrocarbon Indications	Hydrocarbon Indications		D'ARCY EXPLORATION CO LTD	Conventional	22	Ground Level Elevati	34
560100	113580	10	7030	192282	L100/02- 7	Tue May 18 1937 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 16 1937 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jul 17 1937 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 17 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	No Data Available	A43		Exploration	Exploration	Vertical	Rotary Table	201	61.26479991	OSGB NG	113580	560100	OSGB NG	560100	113580	Rotary Table	201	61.26479991	3506	1068.62879838	3305	1007.36399847	L100/02- 7	Decommissioned	Abandoned Phase 3	Decomissioned	HELLINGLY 1 (GROVE HILL)		7	N	N	5	4	Dry Hole	Dry Hole		ANGLO AMERICAN OIL COMPANY LIMITED	Conventional	6	Rotary Table	201


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "w_id" BIGINT,
  "wellboreid" BIGINT,
  "wellregno" VARCHAR,
  "spuddate" TIMESTAMP,
  "datetdreac" TIMESTAMP,
  "compledate" TIMESTAMP,
  "releasedat" TIMESTAMP,
  "subareaop" VARCHAR,
  "subopno" VARCHAR,
  "subopprev" VARCHAR,
  "subopgrp" VARCHAR,
  "tdoperator" VARCHAR,
  "tdsaopnum" VARCHAR,
  "tdopprev" VARCHAR,
  "tdopgrp" VARCHAR,
  "entitytype" VARCHAR,
  "repentreas" VARCHAR,
  "datarepent" VARCHAR,
  "dataentnum" VARCHAR,
  "dataenprev" VARCHAR,
  "dataengrp" VARCHAR,
  "targetfld" VARCHAR,
  "licno" VARCHAR,
  "lictype" VARCHAR,
  "origintent" VARCHAR,
  "currwellin" VARCHAR,
  "deviattyp" VARCHAR,
  "datumtype" VARCHAR,
  "datelev_f" DOUBLE,
  "datelev_m" DOUBLE,
  "topholedtm" VARCHAR,
  "topholeydd" VARCHAR,
  "topholexdd" VARCHAR,
  "topholeyge" VARCHAR,
  "topholexge" VARCHAR,
  "topholeyng" DOUBLE,
  "topholexng" DOUBLE,
  "tphlbngref" VARCHAR,
  "botholedtm" VARCHAR,
  "botholeydd" DOUBLE,
  "botholexdd" DOUBLE,
  "bh_easting" DOUBLE,
  "bh_northin" DOUBLE,
  "bh_bng_ref" VARCHAR,
  "tddepdatty" VARCHAR,
  "tddatdep_f" DOUBLE,
  "tddatdep_m" DOUBLE,
  "tdmddepf" DOUBLE,
  "tdmddepm" DOUBLE,
  "tdtvdssf" DOUBLE,
  "tdtvdssm" DOUBLE,
  "td_age" VARCHAR,
  "released" VARCHAR,
  "parentwell" VARCHAR,
  "stmddepf" DOUBLE,
  "stmddepm" DOUBLE,
  "sttvdssf" DOUBLE,
  "sttvdssm" DOUBLE,
  "roporg" VARCHAR,
  "respopnum" VARCHAR,
  "roporgprev" VARCHAR,
  "wellorigin" VARCHAR,
  "originstat" VARCHAR,
  "complestat" VARCHAR,
  "wellopstat" VARCHAR,
  "wellsuffix" VARCHAR,
  "wellalias" VARCHAR,
  "name" VARCHAR,
  "primarytar" VARCHAR,
  "prospect" VARCHAR,
  "devtype" VARCHAR,
  "pprswellno" VARCHAR,
  "denno" DOUBLE,
  "drillseqno" BIGINT,
  "discovery" VARCHAR,
  "regowned" VARCHAR,
  "licconfper" DOUBLE,
  "wellsymbol" DOUBLE,
  "mapsymdesc" VARCHAR,
  "flowclass" VARCHAR,
  "otherclass" VARCHAR,
  "fluidtypes" VARCHAR,
  "origopname" VARCHAR,
  "wellconven" VARCHAR,
  "uncweltyp" VARCHAR,
  "tempclass" VARCHAR,
  "pressclass" VARCHAR,
  "wellseq" VARCHAR,
  "mntdtempc" DOUBLE,
  "mntdtempf" DOUBLE,
  "mxtdtempc" DOUBLE,
  "mxtdtempf" DOUBLE,
  "releaseno" VARCHAR,
  "sdtrktype" VARCHAR,
  "parentrole" VARCHAR,
  "strkdtmty" VARCHAR,
  "stmddatf" DOUBLE
);