| 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 |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Absolute_X | double Plane_Angle |
Longitude of the point as stored in the internal binary spatial representation. | No |
NUMBER |
| Absolute_Y | double Plane_Angle |
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 |
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 |
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) |
| 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 |
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 |
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) |
| 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 |
CREATE OR REPLACE VIEW Marker_DOV(ID, UBHI, BOREHOLE_NAME, 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,
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,sds_spatial.position_x(po.Id,1)),po.Normal_Longitude) Absolute_X,
decode(sds_spatial.sde_enabled(),1,nvl(po.Normal_Latitude,sds_spatial.position_y(po.Id,1)),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(+)
|