NDR 3dseis

North Sea Transition Authority

@ukgov.ndr_3dseis3

Table List

1 table(74.25 KB)

Table 1

@ukgov.ndr_3dseis3.table_1

74.25 KB
779 rows
18 columns

reclength RECLENGTH	shape_area Shape, Area	shape_length Shape, Length	objectid OBJECTID	surveyid SURVEYID	cs9name CS9NAME	surveyname SURVEYNAME	surveytype SURVEYTYPE	surveyenv SURVEYENV	recentered RECENTERED	recupdated RECUPDATED	currowner CURROWNER	origoper ORIGOPER	contractor CONTRACTOR	startdate STARTDATE	enddate ENDDATE	relrule RELRULE	reldate RELDATE
	0.0155726993719475	0.581691842335285	1	2376404	RA883F0001	ANGLIA	3D	MARINE	2000/07/16 00:00:00+00	2008/06/17 00:00:00+00	ITHACA	RANGER	SSL	Wed May 04 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 30 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Fri Jan 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)
	0.020296645968359	0.655517200866974	2	2376456	SH803F0001	TERN	3D	MARINE	2000/07/16 00:00:00+00	2009/10/22 00:00:00+00	TAQA	SHELL UK EXPLORATION AND PRODUCTION LTD	UNKNOWN	Tue Jul 01 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jul 01 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)
	0.0127209184631665	0.597576447700705	3	2376469	SH813F0001	CENTRAL CORMORANT	3D	MARINE	2000/07/16 00:00:00+00	2009/10/22 00:00:00+00	TAQA	SHELL UK EXPLORATION AND PRODUCTION LTD	UNKNOWN	Wed Jul 01 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 01 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Wed Jan 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)
	0.01121855866309	0.587721609428201	4	2376482	SH813F0002	EIDER PHASE 1	3D	MARINE	2000/07/16 00:00:00+00	2009/10/22 00:00:00+00	TAQA	SHELL	WESTERN GEOPHYSICAL	Thu Jan 01 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 01 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Wed Jan 01 1986 00:00:00 GMT+0000 (Coordinated Universal Time)
6	0.0620902636743165	1.23219867892742	5	2376495	SH823F0001	E528 PUFFIN 3D	3D	MARINE	2000/07/16 00:00:00+00	2008/02/20 00:00:00+00	SHELL	SHELL UK EXPLORATION AND PRODUCTION LTD	GSI	Sat Jun 05 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 22 1982 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Thu Jan 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)
6	0.0354644813227269	0.971477773651149	6	2376508	SH833F0001	P501 GANNET CENTRAL 3D	3D	MARINE	2000/07/16 00:00:00+00	2008/02/20 00:00:00+00	SHELL	SHELL UK EXPLORATION AND PRODUCTION LTD	GSI	Sun Apr 17 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 09 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Fri Jan 01 1988 00:00:00 GMT+0000 (Coordinated Universal Time)
5	0.0093798224455844	0.4328885441776	7	2376521	SH833F0002	P502 KITTIWAKE 1983 3D	3D	MARINE	2000/07/16 00:00:00+00	2008/02/20 00:00:00+00	SHELL	SHELL	SSL	Sat Aug 20 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Nov 19 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Fri Jan 01 1988 00:00:00 GMT+0000 (Coordinated Universal Time)
6	0.0174015366247336	0.65356158464922	8	2376534	SH833F0003	P507 GANNET SOUTH 3D	3D	MARINE	2000/07/16 00:00:00+00	2008/02/20 00:00:00+00	SHELL	SHELL UK EXPLORATION AND PRODUCTION LTD	GSI	Sun Jul 10 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Aug 11 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Fri Jan 01 1988 00:00:00 GMT+0000 (Coordinated Universal Time)
	0.0368444267481771	0.986200525675108	9	2376547	SH833F0004	EIDER PHASE 2	3D	MARINE	2000/07/16 00:00:00+00	2009/10/22 00:00:00+00	TAQA	SHELL UK EXPLORATION AND PRODUCTION LTD	UNKNOWN	Fri Jul 01 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jul 01 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Fri Jan 01 1988 00:00:00 GMT+0000 (Coordinated Universal Time)
4	0.012685562689679	0.488288747379778	10	2376560	SH843F0001	P84002 SOLEPIT 1984 3D	3D	MARINE	2000/07/16 00:00:00+00	2008/02/20 00:00:00+00	SHELL	SHELL UK EXPLORATION AND PRODUCTION LTD	PRAKLA-SEISMOS AG	Sun Jul 08 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 31 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Sun Jan 01 1989 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE table_1 (
  "reclength" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "objectid" BIGINT,
  "surveyid" BIGINT,
  "cs9name" VARCHAR,
  "surveyname" VARCHAR,
  "surveytype" VARCHAR,
  "surveyenv" VARCHAR,
  "recentered" VARCHAR,
  "recupdated" VARCHAR,
  "currowner" VARCHAR,
  "origoper" VARCHAR,
  "contractor" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "relrule" VARCHAR,
  "reldate" TIMESTAMP
);