Survey_2D_Dataset_Line

[Columns] [Composed Of] [Referenced By] [Refers To]

Name	Survey_2D_Dataset_Line
Entity Type	ObjectView
Description	PSS 2013.1 Survey_2D_Dataset_Line DOV
Submodel	Data_Object
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations
Specializations

Columns

[Previous] [Next] [Top]

Name	Value Domain	Property / Storage Unit	Description	Required / Default	Type
ACQUISITION_2D_ID	NUMBER2	NA	_	No	NUMBER(2)
ALTERNATIVE_NAVIGATION_ID	NUMBER2	NA	_	Yes	NUMBER(2)
BOREHOLE_SEISMIC_SURVEY_ID	NUMBER2	NA	_	No	NUMBER(2)
CDP_INCREMENT	NUMBER2	NA	_	No	NUMBER(2)
COORDINATE_SYS	STRING64	NA	_	No	VARCHAR2(64)
COORDINATE_SYS_UNIT	STRING64	NA	_	No	VARCHAR2(64)
EXISTENCE_KIND	STRING64	NA	_	Yes	VARCHAR2(64)
FIRST_CDP	NUMBER2	NA	_	No	NUMBER(2)
FIRST_SHOTPOINT	NUMBER2	NA	_	No	NUMBER(2)
FOREIGN_REPOSITORY_SYSTEM	STRING64	NA	_	No	VARCHAR2(64)
FOREIGN_REP_OBJECT_ID	STRING255	NA	_	No	VARCHAR2(255)
GUID	STRING128	NA	_	No	VARCHAR2(128)
ID	NUMBER2	NA	_	Yes	NUMBER(2)
INSERT_DATE	DATE	NA	_	No	DATE
INSERT_USER	STRING64	NA	_	No	VARCHAR2(64)
INTERNAL_REFERENCE	STRING64	NA	_	No	VARCHAR2(64)
LAST_CDP	NUMBER2	NA	_	No	NUMBER(2)
LAST_SHOTPOINT	NUMBER2	NA	_	No	NUMBER(2)
LINE_GEOMETRY_ID	NUMBER2	NA	_	No	NUMBER(2)
LINE_INDEX_TYPE	STRING64	NA	_	No	VARCHAR2(64)
LINE_RANK	NUMBER2	NA	_	No	NUMBER(2)
NAME	STRING255	NA	_	No	VARCHAR2(255)
NOMINAL_LINE_LENGTH	NUMBER2	NA	_	No	NUMBER(2)
NOMINAL_SHOT_INTERVAL	NUMBER2	Length m	_	No	NUMBER(2)
ORIGINAL_SOURCE	STRING64	NA	_	No	VARCHAR2(64)
POINT_TYPE	STRING64	NA	_	No	VARCHAR2(64)
PRODUCED_BY	STRING64	NA	_	No	VARCHAR2(64)
PROJECT	STRING32	NA	_	No	VARCHAR2(32)
PROPRIETARY_FLAG	NUMBER2	NA	_	No	NUMBER(2)
PURCHASED_FLAG	NUMBER2	NA	_	No	NUMBER(2)
PURE_LINE_NUMBER	NUMBER2	NA	_	No	NUMBER(2)
REMARKS	STRING2000	NA	_	No	VARCHAR2(2000)
SDAT_LABEL	NUMBER2	NA	_	No	NUMBER(2)
SEISMIC_DATASET_NAME	STRING255	NA	_	No	VARCHAR2(255)
SEISMIC_LINE_STYLE	STRING64	NA	_	No	VARCHAR2(64)
SEISMIC_LINE_TYPE	STRING64	NA	_	No	VARCHAR2(64)
SEISMIC_LINE_UNIQUE_LOCATOR	STRING2000	NA	_	No	VARCHAR2(2000)
SHOT_BULK_ARRAY_ID	NUMBER2	NA	_	No	NUMBER(2)
SHOT_DIVISOR	NUMBER2	NA	_	No	NUMBER(2)
SHOT_INCREMENT	NUMBER2	NA	_	No	NUMBER(2)
SOURCE	STRING64	NA	_	No	VARCHAR2(64)
SOURCE_POINT_COUNT	NUMBER2	NA	_	No	NUMBER(2)
SURVEY_2D_ID	NUMBER2	NA	_	No	NUMBER(2)
SURVEY_3D_ID	NUMBER2	NA	_	No	NUMBER(2)
UPDATE_DATE	DATE	NA	_	No	DATE
UPDATE_USER	STRING64	NA	_	No	VARCHAR2(64)
VERSION	STRING255	NA	_	Yes	VARCHAR2(255)

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW Survey_2D_Dataset_Line(INSERT_DATE, INSERT_USER, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, EXISTENCE_KIND, GUID, ID, VERSION, NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, ACQUISITION_2D_ID, BOREHOLE_SEISMIC_SURVEY_ID, CDP_INCREMENT, COORDINATE_SYS, COORDINATE_SYS_UNIT, FIRST_CDP, FIRST_SHOTPOINT, FOREIGN_REP_OBJECT_ID, FOREIGN_REPOSITORY_SYSTEM, INTERNAL_REFERENCE, LAST_CDP, LAST_SHOTPOINT, LINE_GEOMETRY_ID, LINE_INDEX_TYPE, LINE_RANK, NOMINAL_LINE_LENGTH, NOMINAL_SHOT_INTERVAL, PROJECT, PROPRIETARY_FLAG, PURCHASED_FLAG, PURE_LINE_NUMBER, SEISMIC_LINE_STYLE, SEISMIC_LINE_TYPE, SEISMIC_LINE_UNIQUE_LOCATOR, SHOT_BULK_ARRAY_ID, SHOT_DIVISOR, SHOT_INCREMENT, SOURCE_POINT_COUNT, SURVEY_2D_ID, SURVEY_3D_ID, SEISMIC_DATASET_NAME, ALTERNATIVE_NAVIGATION_ID, POINT_TYPE) AS (
  select distinct SEISMIC_LINE.INSERT_DATE,
                  SEISMIC_LINE.INSERT_USER,
				  SEISMIC_LINE.PRODUCED_BY,
				  SEISMIC_LINE.SDAT_LABEL,
				  SEISMIC_LINE.UPDATE_DATE,
				  
SEISMIC_LINE.UPDATE_USER,
				  SEISMIC_LINE.EXISTENCE_KIND,
				  SEISMIC_LINE.GUID,
				  SEISMIC_LINE.ID,
				  SEISMIC_LINE.VERSION,
				  SEISMIC_LINE.NAME,
				  SEISMIC_LINE.ORIGINAL_SOURCE,
				  SEISMIC_LINE.REMARKS,
				  SEISMIC_LINE.SOURCE,
				  SEISMIC_LINE.ACQUISITION_2D_ID,
				  SEISMIC_LINE.BOREHOLE_SEISMIC_SURVEY_ID,
				  SEISMIC_LINE.CDP_INCREMENT,
				  SEISMIC_LINE.COORDINATE_SYS,
				  SEISMIC_LINE.COORDINATE_SYS_UNIT,
				  SEISMIC_LINE.FIRST_CDP,
				  SEISMIC_LINE.FIRST_SHOTPOINT,
				  SEISMIC_LINE.FOREIGN_REP_OBJECT_ID,
				  SEISMIC_LINE.FOREIGN_REPOSITORY_SYSTEM,
				  SEISMIC_LINE.INTERNAL_REFERENCE,
				  SEISMIC_LINE.LAST_CDP,
				  SEISMIC_LINE.LAST_SHOTPOINT,
				  SEISMIC_LINE.LINE_GEOMETRY_ID,
				  SEISMIC_LINE.LINE_INDEX_TYPE,
				  SEISMIC_LINE.LINE_RANK,
				  SEISMIC_LINE.NOMINAL_LINE_LENGTH,
				  SEISMIC_LINE.NOMINAL_SHOT_INTERVAL,
				  SEISMIC_LINE.PROJECT,
				  SEISMIC_LINE.PROPRIETARY_FLAG,
				  SEISMIC_LINE.PURCHASED_FLAG,
				  
SEISMIC_LINE.PURE_LINE_NUMBER,
				  SEISMIC_LINE.SEISMIC_LINE_STYLE,
				  SEISMIC_LINE.SEISMIC_LINE_TYPE,
				  SEISMIC_LINE.SEISMIC_LINE_UNIQUE_LOCATOR,
				  SEISMIC_LINE.SHOT_BULK_ARRAY_ID,
				  SEISMIC_LINE.SHOT_DIVISOR,
				  SEISMIC_LINE.SHOT_INCREMENT,
				  SEISMIC_LINE.SOURCE_POINT_COUNT,
				  SEISMIC_LINE.SURVEY_2D_ID,
				  SEISMIC_LINE.SURVEY_3D_ID,
				  SEISMIC_DATASET_2D.NAME SEISMIC_DATASET_NAME,
				  SEISMIC_DATASET_2D.ALTERNATIVE_NAVIGATION_ID,
				  NULL POINT_TYPE
  from SEISMIC_DATASET_2D,
       SEISMIC_LINE
  where SEISMIC_DATASET_2D.SEISMIC_LINE_ID = SEISMIC_LINE.ID
  UNION
  select distinct ALTERNATIVE_NAVIGATION.INSERT_DATE,
                  ALTERNATIVE_NAVIGATION.INSERT_USER,
				  ALTERNATIVE_NAVIGATION.PRODUCED_BY,
				  ALTERNATIVE_NAVIGATION.SDAT_LABEL,
				  ALTERNATIVE_NAVIGATION.UPDATE_DATE,
				  ALTERNATIVE_NAVIGATION.UPDATE_USER,
				  ALTERNATIVE_NAVIGATION.EXISTENCE_KIND,
				  ALTERNATIVE_NAVIGATION.GUID,
				  
ALTERNATIVE_NAVIGATION.ID,
				  ALTERNATIVE_NAVIGATION.VERSION,
				  ALTERNATIVE_NAVIGATION.NAME,
				  ALTERNATIVE_NAVIGATION.ORIGINAL_SOURCE,
				  ALTERNATIVE_NAVIGATION.REMARKS,
				  ALTERNATIVE_NAVIGATION.SOURCE,
				  SEISMIC_LINE.ACQUISITION_2D_ID,
				  SEISMIC_LINE.BOREHOLE_SEISMIC_SURVEY_ID,
				  NULL CDP_INCREMENT,
				  SEISMIC_LINE.COORDINATE_SYS,
				  SEISMIC_LINE.COORDINATE_SYS_UNIT,
				  NULL FIRST_CDP,
				  ALTERNATIVE_NAVIGATION.FIRST_POINT,
				  SEISMIC_LINE.FOREIGN_REP_OBJECT_ID,
				  SEISMIC_LINE.FOREIGN_REPOSITORY_SYSTEM,
				  SEISMIC_LINE.INTERNAL_REFERENCE,
				  NULL LAST_CDP,
				  ALTERNATIVE_NAVIGATION.LAST_POINT,
				  ALTERNATIVE_NAVIGATION.LINE_GEOMETRY_ID,
				  SEISMIC_LINE.LINE_INDEX_TYPE,
				  ALTERNATIVE_NAVIGATION.LINE_RANK,
				  SEISMIC_LINE.NOMINAL_LINE_LENGTH,
				  NULL NOMINAL_SHOT_INTERVAL,
				  SEISMIC_LINE.PROJECT,
				  SEISMIC_LINE.PROPRIETARY_FLAG,
				  SEISMIC_LINE.PURCHASED_FLAG,
				  SEISMIC_LINE.PURE_LINE_NUMBER,
				  
SEISMIC_LINE.SEISMIC_LINE_STYLE,
				  SEISMIC_LINE.SEISMIC_LINE_TYPE,
				  SEISMIC_LINE.SEISMIC_LINE_UNIQUE_LOCATOR,
				  SEISMIC_LINE.SHOT_BULK_ARRAY_ID,
				  NULL SHOT_DIVISOR,
				  ALTERNATIVE_NAVIGATION.POINT_INCREMENT,
				  SEISMIC_LINE.SOURCE_POINT_COUNT,
				  SEISMIC_LINE.SURVEY_2D_ID,
				  SEISMIC_LINE.SURVEY_3D_ID,
				  SEISMIC_DATASET_2D.NAME SEISMIC_DATASET_NAME,
				  SEISMIC_DATASET_2D.ALTERNATIVE_NAVIGATION_ID,
				  ALTERNATIVE_NAVIGATION.POINT_TYPE
  from SEISMIC_DATASET_2D,
       ALTERNATIVE_NAVIGATION,
	   SEISMIC_LINE
  where SEISMIC_DATASET_2D.ALTERNATIVE_NAVIGATION_ID = ALTERNATIVE_NAVIGATION.ID
        AND SEISMIC_LINE.ID = ALTERNATIVE_NAVIGATION.SEISMIC_LINE_ID)

[Seabed Objects] [Entities in Schema Seabed] [Index]

Survey_2D_Dataset_Line

Copyright © 2018 Schlumberger. All rights reserved.