Marker_DOV

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

Name	Marker_DOV
Entity Type	ObjectView
Description	Data Object View. Log correlation provides the definition of well markers or picks that delineate important zones in a borehole. The Marker DOV provides basic information about well markers.
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
Absolute_X	double	Plane_Angle deg	Longitude of the point as stored in the internal binary spatial representation.	No	NUMBER
Absolute_Y	double	Plane_Angle deg	Latitude of the point as stored in the internal binary spatial representation.	No	NUMBER
Application_Name	STRING64	NA	ID of the activity that was executing when the entity was created, for data created programmatically.	No	VARCHAR2(64)
Borehole_Id	Borehole		READ ONLY: Unique identifier for the Borehole.	No	NUMBER(38)
Borehole_Name	ENTITY_NAME	NA	The name given to any object or data item, e.g. Name of Well, Name of Field, etc.	No	VARCHAR2(255)
Conformity_Relationship	STRING64	NA	The classification system for this stratigraphic surface. For example, Bio, Chrono, Facies and Litho.	No	VARCHAR2(64)
Dip	double	Plane_Angle deg	The maximum vertical angle that a surface; e.g. a bedding or fault surface, makes with the horizontal, measured perpendicular to the strike direction of the structure. Dip may be computed in several ways, including from logs, from well-to-well correlation, fromgradients on interpreted time or depth surfaces (See Time_Dip and Depth_Dip), etc.	No	NUMBER
Dip_Azimuth	double	Plane_Angle deg	Azimuth of the direction of maximum dip of a surface; dip may be computed in several ways, including from logs, from well-to-well correlation, from gradients on interpreted time or depth surfaces, etc.	No	NUMBER
Id	ID	No_Unit	Unique identifier for this entity.	Yes	NUMBER(38)
Informal_Surface_Name	STRING255		Informal surface name.	No	VARCHAR2(255)
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)
Interpreter	STRING64		Name of the Business_Associate responsible for this entity"s E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User.	No	VARCHAR2(64)
Original_Absolute_X	double	No_Unit	X coordinate, or longitude, of the point in the cartographic system of the input dataset.	No	NUMBER
Original_Absolute_Y	double	No_Unit	Y coordinate, or latitude, of the point in the cartographic system of the input dataset.	No	NUMBER
Original_CRS	CODE	NA	READ ONLY: The code for the original projected or geographic coordinate system.	No	VARCHAR2(64)
Original_Coord_System_Id	Coordinate_System		Unique identifier for the coordinate system of the incoming (i.e., original) Position data, including cartographic, elevation and azimuth references.	No	NUMBER(38)
Original_Coord_System_Name	ENTITY_NAME	NA	READ ONLY: The name of the Original Coordinate System.	No	VARCHAR2(255)
Pick_Depth	double	Standard_Depth_Index m	Measured Depth of the borehole point.	Yes	NUMBER
Pick_Quality	STRING255	NA	Value for a QC attribute set for a particular external object instance	No	VARCHAR2(255)
Position_Id	Position		READ ONLY: Unique identifier for the Position.	No	NUMBER(38)
QC_Attribute_Id	QC_Attribute_Value		READ ONLY: Unique identifier of the Quality Context	No	NUMBER(38)
Remarks	REMARKS_STR	NA	Any type of remarks added to an entity instance.	No	VARCHAR2(999)
Shape	GEOMETRY	NA	Binary spatial representation of the position.	No	ST_GEOMETRY
Stratigraphic_Surface_Id	Stratigraphic_Surface		READ ONLY: Unique identifier for the Stratigraphic Surface.	No	NUMBER(38)
Surface_Name	STRING64		A code for the standard or formal geologic surface name.	Yes	VARCHAR2(64)
TVD_SS	double	Length m	Elevation of the Position relative to the Coordinate System elevation reference. Elevations are positive going away from the center of the earth and negative going into the earth.	No	NUMBER
UBHI	WELL_IDENTIFIER	NA	The Unique Identifier assigned to a borehole	Yes	VARCHAR2(64)

Refers To

[Previous] [Next] [Top]

Link	To Entity	Description	Implementation Technique	Required
Borehole	Borehole	READ ONLY: Unique identifier for the Borehole.	Cascade	No
Stratigraphic_Surface	Stratigraphic_Surface	READ ONLY: Unique identifier for the Stratigraphic Surface.	Cascade	No
Original_Coord_System	Coordinate_System	Unique identifier for the coordinate system of the incoming (i.e., original) Position data, including cartographic, elevation and azimuth references.	Cascade	No
QC_Attribute	QC_Attribute_Value	READ ONLY: Unique identifier of the Quality Context	Cascade	No
Position	Position	READ ONLY: Unique identifier for the Position.	Control	No

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW Marker_DOV(ID, UBHI, BOREHOLE_NAME, SURFACE_NAME, INFORMAL_SURFACE_NAME, INTERPRETER, PICK_DEPTH, PICK_QUALITY, APPLICATION_NAME, CONFORMITY_RELATIONSHIP, TVD_SS, SHAPE, ABSOLUTE_X, ABSOLUTE_Y, ORIGINAL_COORD_SYSTEM_ID, ORIGINAL_COORD_SYSTEM_NAME, ORIGINAL_CRS, ORIGINAL_ABSOLUTE_X, ORIGINAL_ABSOLUTE_Y, DIP_AZIMUTH, DIP, REMARKS, INSERT_DATE, INSERT_USER, BOREHOLE_ID, STRATIGRAPHIC_SURFACE_ID, POSITION_ID, QC_ATTRIBUTE_ID) AS SELECT
 bp.Id                        Id,
 bh.UBHI                      UBHI,
 bh.Name                      Borehole_Name,
 ss.standard_geologic_surface Surface_Name,
 ss.Name		      Informal_Surface_Name,
 bp.source                    Interpreter,
 bp.MD                        Pick_Depth,
 qc.Pick_List_Value           Pick_Quality,
 bp.produced_by               Application_Name,
 ss.strat_surface_type        Conformity_Relationship,
 po.elevation                 TVD_SS,
 po.shape                     Shape,
 
decode(sds_spatial.sde_enabled(),1,nvl(po.Normal_Longitude,SDE.ST_X(po.shape)),po.Normal_Longitude) Absolute_X,
 decode(sds_spatial.sde_enabled(),1,nvl(po.Normal_Latitude,SDE.ST_Y(po.shape)),po.Normal_Latitude) Absolute_Y,
 po.original_coord_system_id  Original_Coord_System_Id,
 cs.name                      Original_Coord_System_Name,
 cs.crs                       Original_CRS,
 po.original_x_longitude      Original_Absolute_X,
 po.original_y_latitude       Original_Absolute_Y,
 bp.dip_azimuth               Dip_Azimuth,
 bp.dip_angle                 Dip,
 bp.remarks                   Remarks,
 bp.insert_date               Insert_Date,
 bp.insert_user               Insert_User,
 bh.Id                        Borehole_Id,
 ss.Id                        Stratigraphic_Surface_Id,
 po.Id                        Position_Id,
 qc.Id                        QC_Attribute_Id
from borehole               bh,
     borehole_point         bp,
     stratigraphic_surface  ss,
     position               
po,
     qc_attribute_value     qc,
     qc_attribute_value_ref qcr,
     coordinate_system cs
where bp.borehole_id = bh.id
  and bp.well_marker_surface_id = ss.id
  and bp.marker_xyz_position_id = po.id(+)
  and bp.id = qcr.property_id(+)
  and qc.attribute_name_context(+) = 'Pick Quality'
  and qc.attribute_type(+) = 'Quality Class'
  and qc.external_object_type_contxt(+) = 'Marker'
  and qcr.entity_id = qc.id(+)
  and qcr.property_code(+) = 'Seabed_Obj_Instance_Context'
  and qcr.property_type(+) = 'Borehole_Point'
  and po.original_coord_system_id=cs.id(+)

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

Marker_DOV

Copyright © 2018 Schlumberger. All rights reserved.