Offshore Wells (ETRS89)

North Sea Transition Authority

@ukgov.offshore_wells_etrs892

Table List

1 table(2.35 MB)

Table 1

@ukgov.offshore_wells_etrs892.table_1

2.35 MB
12693 rows
127 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	subareaop SUBAREAOP	subopno SUBOPNO	subopprev SUBOPPREV	subopgrp SUBOPGRP	tdoperator TDOPERATOR	tdsaopnum TDSAOPNUM	tdopprev TDOPPREV	tdopgrp TDOPGRP	datarepent DATAREPENT	dataentnum DATAENTNUM	dataenprev DATAENPREV	dataengrp DATAENGRP	targetfld TARGETFLD	licno LICNO	lictype LICTYPE	origintent ORIGINTENT	currwellin CURRWELLIN	deviattyp DEVIATTYP	datumtype DATUMTYPE	datelev_f DATELEV F	datelev_m DATELEV M	topholedtm TOPHOLEDTM	topholeyge TOPHOLEYGE	topholexge TOPHOLEXGE	botholedtm BOTHOLEDTM	botholeydd BOTHOLEYDD	botholexdd BOTHOLEXDD	tddepdatty TDDEPDATTY	tddatdep_f TDDATDEP F	tddatdep_m TDDATDEP M	tdmddepf TDMDDEPF	tdmddepm TDMDDEPM	tdtvdssf TDTVDSSF	tdtvdssm TDTVDSSM	parentwell PARENTWELL	roporg ROPORG	respopnum RESPOPNUM	roporgprev ROPORGPREV	wellorigin WELLORIGIN	originstat ORIGINSTAT	complestat COMPLESTAT	wellopstat WELLOPSTAT	wellsuffix WELLSUFFIX	primarytar PRIMARYTAR	devtype DEVTYPE	pprswellno PPRSWELLNO	denno DENNO	drillseqno DRILLSEQNO	discovery DISCOVERY	regowned REGOWNED	wellsymbol WELLSYMBOL	mapsymdesc MAPSYMDESC	flowclass FLOWCLASS	fluidtypes FLUIDTYPES	wellseq WELLSEQ	mntdtempf MNTDTEMPF	mxtdtempf MXTDTEMPF	releaseno RELEASENO	sdtrktype SDTRKTYPE
2.01947426200007	59.9003309280001	1	1066	211019	10/01- 3	Thu Sep 18 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 27 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 18 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 18 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Appraisal	Appraisal	Vertical	Kelly Bushing	81.9881891	24.99	ED50	59 54 3.16 NORTH	2 1 16.09 EAST	ED50	59.900878	2.021136	Kelly Bushing	82	24.99359996	9055.0853156	2759.99				TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01- 3	Decommissioned	Abandoned Phase 3	Decomissioned					760	3	N	N	6	Gas Well	Gas Well	Gas	WB1	32	32	8
2.03006150900006	59.8832581840001	2	1067	211022	10/01- 4	Fri Nov 21 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Dec 30 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 09 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 09 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Appraisal	Appraisal	Vertical	Kelly Bushing	79.06824159	24.1	ED50	59 53 1.7 NORTH	2 1 54.2 EAST	ED50	59.87939593	2.05271319	Kelly Bushing	79	24.07919996	8694.225735	2650	7119.5538166	2170.04		TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01- 4	Decommissioned	Abandoned Phase 3	Decomissioned					787	4	N	N	6	Gas Well	Gas Well	Gas	WB1			9
2.04133996800005	59.8759524540001	3	21300	216897	10/01- 5	Wed Dec 05 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 10 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 10 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 08 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Development	Development	Vertical		82.02	24.99969596	ED50	59 52 35.4 NORTH	2 2 34.8 EAST	ED50	59.88663889	2.04236389				4717.8	1437.98543781	3681.3	1122.06023829		TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01- 5	Decommissioned	Abandoned Phase 3	Decomissioned		E			2560	5	N	N				Gas
2.04133996800005	59.8759524540001	4	1068	216899	10/01- 5Z	Wed Dec 05 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 25 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 08 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Mar 08 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Development	Development	Vertical	Kelly Bushing	82.0209975	25	ED50	59 52 35.4 NORTH	2 2 34.8 EAST	ED50	59.88663889	2.05903056	Kelly Bushing	82	24.99359996	9416.010513	2870	7805.1181221	2379	10/01- 5	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01- 5	Decommissioned	Abandoned Phase 3	Decomissioned	Z	E			2560	5	N	N	6	Gas Well	Gas Well	Gas	WB1			37	Mechanical
2.05970955900005	59.8747136650001	5	1069	216896	10/01-A1	Mon Oct 11 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 03 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 08 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 08 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Development	Development	Vertical	Kelly Bushing	157.4803152	48	ED50	59 52 30.9396 NORTH	2 3 40.9284 EAST	ED50	59.87518382	2.06147989	Kelly Bushing	157.4	47.97551993	6338.5826868	1932	6181.1023716	1884		TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01-A1	Decommissioned	Abandoned Phase 3	Decomissioned			Producer	B01	958	1	N	N	18	Gas Producing Well	Gas Well	Gas	WB1			13
2.05958755500006	59.874727664	6	1078	216901	10/01-A10	Sat Oct 16 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 21 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 26 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Development	Development	Vertical	Kelly Bushing	157.4803152	48	ED50	59 52 30.99 NORTH	2 3 40.4892 EAST	ED50	59.87595927	2.056396	Kelly Bushing	157.4	47.97551993	6433.7270439	1961	6156.49607235	1876.5		TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01-A10	Decommissioned	Abandoned Phase 3	Decomissioned			Producer	B10	1044	10	N	N	18	Gas Producing Well	Gas Well	Gas	WB1			13
2.05962955700005	59.8747196640001	7	1079	216907	10/01-A11	Fri Oct 08 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 03 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 06 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 06 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Development	Development	Vertical	Kelly Bushing	157.4803152	48	ED50	59 52 30.9612 NORTH	2 3 40.6404 EAST	ED50	59.87385754	2.05482487	Kelly Bushing	157.4	47.97551993	6509.1863616	1984	6125.98426128	1867.2		TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01-A11	Decommissioned	Abandoned Phase 3	Decomissioned			Producer	B11	1065	11	N	N	18	Gas Producing Well	Gas Well	Gas	WB1			13
2.05961855700002	59.874702664	8	1080	216902	10/01-A12	Wed Oct 06 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 27 1977 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 27 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Development	Development	Vertical	Kelly Bushing	157.4803152	48	ED50	59 52 30.9 NORTH	2 3 40.6008 EAST	ED50	59.8712158	2.05320857	Kelly Bushing	157.4	47.97551993	6853.6745511	2089	6145.66930068	1873.2		TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01-A12	Decommissioned	Abandoned Phase 3	Decomissioned			Producer	B12	1066	12	N	N	18	Gas Producing Well	Gas Well	Gas	WB1			13
2.06011257500006	59.8746356670001	9	1081	216906	10/01-A13	Sun Jan 22 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 27 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 01 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 01 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	No Data Available	No Data Available	No Data Available	No Data Available	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Development	Development	Vertical	Kelly Bushing	157.4803152	48	ED50	59 52 30.6588 NORTH	2 3 42.3792 EAST	ED50	59.8708162	2.07277735	Kelly Bushing	157.4	47.97551993	6978.3464673	2127	6147.96588861	1873.9		TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01-A13	Decommissioned	Abandoned Phase 3	Decomissioned			Producer	B13	1167	13	N	N	18	Gas Producing Well	Gas Well	Gas	WB1			14
2.06009857500004	59.8746166660001	10	1082	216898	10/01-A14	Mon Jan 23 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 02 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Nov 05 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 05 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	No Data Available	No Data Available	No Data Available	No Data Available	TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	TOTALENERGIES UPSTREAM UK LIMITED	FRIGG	P118	Production	Development	Development	Vertical	Kelly Bushing	157.4803152	48	ED50	59 52 30.5904 NORTH	2 3 42.3288 EAST	ED50	59.87088698	2.06817311	Kelly Bushing	157.4	47.97551993	6729.0026349	2051	6136.48294896	1870.4		TOTALENERGIES E&P UK LIMITED	00811900	TOTAL E&P UK LIMITED, TOTAL E&P UK PLC, TOTALFINAELF EXPLORATION UK PLC, TOTAL OIL MARINE PLC, TOTAL OIL MARINE LIMITED	10/01-A14	Decommissioned	Abandoned Phase 3	Decomissioned			Producer	B14	1168	14	N	N	18	Gas Producing Well	Gas Well	Gas	WB1			14


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" DOUBLE,
  "topholexdd" DOUBLE,
  "topholeyge" VARCHAR,
  "topholexge" VARCHAR,
  "topholeyng" DOUBLE,
  "topholexng" DOUBLE,
  "tphlbngref" VARCHAR,
  "botholedtm" VARCHAR,
  "botholeydd" DOUBLE,
  "botholexdd" DOUBLE,
  "bh_easting" VARCHAR,
  "bh_northin" VARCHAR,
  "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,
  "compop" VARCHAR,
  "compopnum" VARCHAR,
  "compopprev" VARCHAR,
  "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" DOUBLE,
  "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" DOUBLE,
  "sdtrktype" VARCHAR
);