Seismic_Line_DOV

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

Name	Seismic_Line_DOV
Entity Type	ObjectView
Description	Data Object View. The Seismic Line DOV describes an individual line from a seismic survey.
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
CDP_Increment	double	No_Unit	Common Depth Point (CDP) increment associated with this line.	No	NUMBER
First_CDP	double	No_Unit	First common depth point associated with this line.	No	NUMBER
First_Shotpoint	double	No_Unit	First Shot point number associated with this line.	No	NUMBER
Foreign_Rep_Object_Id	ID	No_Unit	Unique identifier for this entity.	No	NUMBER(38)
Id	ID	No_Unit	Unique identifier for this entity.	Yes	NUMBER(38)
Insert_Date	DATE	NA	Date the entity was created in the repository	No	DATE
Insert_User	STRING64	NA	The name of the user responsible for the creation of this entity in the repository.	No	VARCHAR2(64)
Last_CDP	double	No_Unit	Last common depth point associated with this line.	No	NUMBER
Last_Shotpoint	double	No_Unit	Last Shot point number associated with this line.	No	NUMBER
Line_Geometry_Id	Line		Line locations represented by spatial geometry.	No	NUMBER(38)
Line_Name	ENTITY_NAME	NA	The name given to any object or data item, e.g. Name of Well, Name of Field, etc.	Yes	VARCHAR2(255)
Line_Rank	int	No_Unit	Number to describe the order of the line in 2D survey.	No	NUMBER(10)
Nominal_Line_Length	double	Length m	Nominal value representing the length of 2D line	No	NUMBER
Nominal_Shot_Interval	double	Length m	Nominal distance between consecutive shotpoints.	No	NUMBER
Remarks	REMARKS_STR	NA	Any type of remarks added to an entity instance.	No	VARCHAR2(999)
Seismic_Line_Type	CODE		Refers to line type to indicate whether this is part of the survey or selection.	No	VARCHAR2(64)
Seismic_Line_Unique_Locator	FILE_NAME_STR	NA	Unique identifier to locate interpretation application project 2D line.	No	VARCHAR2(999)
Shape	GEOMETRY	NA	Binary spatial representation of the position.	No	ST_GEOMETRY
Shot_Divisor	double	No_Unit	Used to define value used in licensing 2D line at Western Geco.	No	NUMBER
Shot_Increment	double	No_Unit	Shot point increment associated with this line.	No	NUMBER
Survey_2D_Id	Survey_2D		READ ONLY: Unique identifier for the 2D survey.	No	NUMBER(38)
Survey_Name	ENTITY_NAME	NA	The name given to any object or data item, e.g. Name of Well, Name of Field, etc.	Yes	VARCHAR2(255)

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Line_Geometry	Line	Line locations represented by spatial geometry.	Control	No
Survey_2D	Survey_2D	READ ONLY: Unique identifier for the 2D survey.	Nullify	No

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW Seismic_Line_DOV(ID, SURVEY_NAME, LINE_NAME, SEISMIC_LINE_TYPE, FIRST_CDP, LAST_CDP, CDP_INCREMENT, FIRST_SHOTPOINT, LAST_SHOTPOINT, SHOT_INCREMENT, LINE_RANK, NOMINAL_LINE_LENGTH, NOMINAL_SHOT_INTERVAL, SEISMIC_LINE_UNIQUE_LOCATOR, SHOT_DIVISOR, FOREIGN_REP_OBJECT_ID, REMARKS, SHAPE, INSERT_DATE, INSERT_USER, SURVEY_2D_ID, LINE_GEOMETRY_ID) AS select  sl.Id                           Id,
        s2.Name                         Survey_Name,
        sl.Name                         Line_Name,
        sl.Seismic_Line_Type            Seismic_Line_Type,
        sl.First_CDP                    First_CDP,
        sl.Last_CDP                     Last_CDP,
        sl.CDP_Increment                CDP_Increment,
        sl.First_Shotpoint              First_Shotpoint,
        sl.Last_Shotpoint               Last_Shotpoint,
        sl.Shot_Increment               Shot_Increment,
        sl.Line_Rank                    Line_Rank,
        sl.Nominal_Line_Length          
Nominal_Line_Length,
        sl.Nominal_Shot_Interval        Nominal_Shot_Interval,
        sl.Seismic_Line_Unique_Locator  Seismic_Line_Unique_Locator,
        sl.Shot_Divisor                 Shot_Divisor,
        sl.Foreign_Rep_Object_Id        Foreign_Rep_Object_Id,
        sl.Remarks                      Remarks,
        l.Shape                         Shape,
        sl.Insert_Date                  Insert_Date,
        sl.Insert_User                  Insert_User,
        sl.Survey_2D_Id                 Survey_2D_Id,
        l.Id                            Line_Geometry_Id
from Seismic_Line sl,
     Line l,
     Survey_2D s2
where sl.Line_Geometry_Id = l.id (+)
  and sl.Survey_2D_Id = s2.Id (+)

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

Seismic_Line_DOV

Copyright © 2018 Schlumberger. All rights reserved.