NDR SDS 2D Lines

North Sea Transition Authority

@ukgov.ndr_sds_2d_lines3

Table List

1 table(1.24 MB)

Table 1

@ukgov.ndr_sds_2d_lines3.table_1

1.24 MB
32356 rows
18 columns

first_shot FIRST SHOT	last_shotp LAST SHOTP	shape_length Shape, Length	objectid OBJECTID	survey_nam SURVEY NAM	line_name LINE NAME	dataset_id DATASET ID	cs9_name CS9 NAME	alt_survey ALT SURVEY	current_ow CURRENT OW	origoper ORIGOPER	contractor CONTRACTOR	startdate STARTDATE	enddate ENDDATE	relrule RELRULE	reldate RELDATE	verif_stat VERIF STAT	id ID
76.6666717529	414.3332519531	0.0512599003253581	1	BP862D1001	BP86-172	261606038	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952409
76.6666717529	414.3332519531	0.0512599003253581	2	BP862D1001	BP86-172	261608041	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952409
76.6666717529	414.3332519531	0.0512599003253581	3	BP862D1001	BP86-172	261610005	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952409
76.6666717529	414.3332519531	0.0512599003253581	4	BP862D1001	BP86-172	261611969	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952409
76.6666717529	414.3332519531	0.0512599003253581	5	BP862D1001	BP86-172	261613933	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952409
76.6666717529	414.3332519531	0.0512599003253581	6	BP862D1001	BP86-172	261615897	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952409
76.6666717529	414.3332519531	0.0512599003253581	7	BP862D1001	BP86-172	71957814	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952409
	405	0.0511709204747194	8	BP862D1001	BP86-174	71957829	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952413
66.6666412354	402.3332519531	0.050848022001527	9	BP862D1001	BP86-176	71957833	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952417
66.6666412354	341.3332519531	0.0405644166753802	10	BP862D1001	BP86-192	71957822	BP862D1001	Perenco UK1712: BP86-LINES OVER 98/6 1986 2D, LINES 131 TO 198	PERENCO	BP EXPLORATION OPERATING COMPANY LIMITED	HORIZON GEOPHYSICAL	Fri Apr 04 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	PROPRIETARY	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Y	71952449


CREATE TABLE table_1 (
  "first_shot" DOUBLE,
  "last_shotp" DOUBLE,
  "shape_length" DOUBLE,
  "objectid" BIGINT,
  "survey_nam" VARCHAR,
  "line_name" VARCHAR,
  "dataset_id" BIGINT,
  "cs9_name" VARCHAR,
  "alt_survey" VARCHAR,
  "current_ow" VARCHAR,
  "origoper" VARCHAR,
  "contractor" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "relrule" VARCHAR,
  "reldate" TIMESTAMP,
  "verif_stat" VARCHAR,
  "id" BIGINT
);