Offshore Wells (WGS84)

North Sea Transition Authority

@ukgov.offshore_wells_wgs843

Table List

1 table(2.39 MB)

Table 1

@ukgov.offshore_wells_wgs843.table_1

2.39 MB
12879 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	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	origopname ORIGOPNAME	wellseq WELLSEQ	mntdtempf MNTDTEMPF	mxtdtempf MXTDTEMPF	releaseno RELEASENO	sdtrktype SDTRKTYPE	parentrole PARENTROLE	strkdtmty STRKDTMTY	stmddatf STMDDATF
2.00767428100005	59.8357005020001	1	16316	211021	10/01- 1	Fri Dec 31 1971 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 10 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 08 1976 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	No Data Available	P118	Production	Exploration	Exploration					ED50	59 50 10.5 NORTH	2 0 33.6 EAST	ED50	59.83625	2.00933333									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- 1	Decommissioned	Abandoned Phase 3	Decomissioned						1	N	N					TOTAL E&P UK LTD
2.00767428100005	59.835700536	2	1064	211015	10/01- 1A	Sun Feb 27 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 21 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 07 1976 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	No Data Available	P118	Production	Exploration	Exploration	Vertical	Kelly Bushing	87.59842533	26.7	ED50	59 50 10.5 NORTH	2 0 33.6 EAST	ED50	59.83625	2.009333	Kelly Bushing	89	27.12719996	9333.9895155	2845				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- 1A	Decommissioned	Abandoned Phase 3	Decomissioned	A				380	1	N	N	6	Gas Well	Gas Well	Gas		WB1	32	32	4			Kelly Bushing	89
2.00864399500006	59.887952544	3	1065	211013	10/01- 2	Tue May 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 15 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 23 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jun 23 1976 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	No Data Available	P118	Production	Exploration	Exploration	Vertical	Kelly Bushing	87.99212612	26.82	ED50	59 53 18.6 NORTH	2 0 37.1 EAST	ED50	59.8885	2.010306	Kelly Bushing	89	27.12719996	8202.0013248	2499.97				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- 2	Decommissioned	Abandoned Phase 3	Decomissioned					405	2	N	N	4	Dry Hole	Dry Hole			WB1			5			Kelly Bushing	89
2.01947426200007	59.9003309280001	4	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			Kelly Bushing	82
2.03006150900006	59.8832581830001	5	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			Kelly Bushing	79
2.04133996800005	59.8759524530001	6	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.8759524530001	7	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	Sidetrack	Kelly Bushing	82
2.05970955900005	59.8747136640001	8	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			Kelly Bushing	157.4
2.05958755500006	59.874727663	9	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			Kelly Bushing	157.4
2.05962955700005	59.8747196640001	10	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			Kelly Bushing	157.4


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,
  "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,
  "parentrole" VARCHAR,
  "strkdtmty" VARCHAR,
  "stmddatf" DOUBLE
);