| Name | Coordinate_System |
|---|---|
| Entity Type | Table |
| Description | Class for all coordinate systems, per the Spatial Strategy Document. This class defines the lateral and vertical datum to which all Seabed positions are relative. Coordinate_System is needed in project to support local coordinate systems, elevation references, azimuth references, and unknowns. |
| Submodel | Spatial |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | Entity , IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Azimuth_Reference_Id | Azimuth_Reference |
|
Azimuth reference for the Position. | No |
NUMBER(38) |
| CRS | R_Coordinate_Ref_System |
|
The projected or geographic coordinate system code. Many coordinate systems are "local". They combine 2-D map coordinates referenced from this CRS attribute with a depth reference provided by R_Vertical_Reference. | No |
VARCHAR2(64) |
| CRS_Unique_Locator | STRING4000 | NA |
Unique identifier to locate external system references for this coordinate reference system. For example, this may be the OpenSpirit internal default coordinate system Identifier string. | No |
VARCHAR2(4000) |
| Carto_Transform | R_Carto_Transform |
|
The coordinate transform method used to convert the FROM_COORD_SYS_ID coordinate system to this coordinate system. This is a transformation from one geographic coordinate system to another. Coordinate transforms do not refer to re-projections from one map projection to another when they are both based on the same geographic coordinate system but use different projection parameters. | No |
VARCHAR2(64) |
| Coordinate_System_Type | COORD_SYS_TYPE | NA |
The high level or general type of Coordinate System: Local, Projection, Geodetic. | No |
VARCHAR2(32) |
| Elevation_Unit | R_Unit |
|
The identifier of the unit of measure in which the original elevation is expressed. | No |
VARCHAR2(64) |
| Existence_Kind | REF_EXISTENCE_KIND | NA |
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. | Yes Actual |
VARCHAR2(64) |
| From_Coord_Sys_Id | Coordinate_System |
|
This coordinate system is defined with respect to another Local, Projection, or Geodetic System | No |
NUMBER(38) |
| GUID | STRING128 | NA |
Globally Unique IDentifier for an instance of a class. USAGE NOTES: There are two cases: 1) GUID is not populated or used; and 2) it is populated with a value that is globally unique. If the GUID is populated there are two means of doing so for a given project: 2a) Seabed automatically generates and populates the GUID when an instance is created (valid only on Oracle based systems); and 2b) the GUID is generated and populated by an application (other than Seabed) on instance creation. Whether Seabed automatically generates GUIDs for a project is determined by the Auto_GUID flag in SDS_Account. Note that techniques 2a and 2b can coexist in the same project. When GUIDs are automatically generated an application can override the automatically generated GUID with its own GUID by simply supplying the GUID value. Applications that generate their own GUIDs and populate the GUID column will function correctly on projects which have automatic GUID generation turned on. | No |
VARCHAR2(128) |
| 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) |
| Linear_Unit | R_Unit |
|
The unit of measurement on a plane or a projected coordinate system, often meters or feet. (ESRI GIS Dictionary) | No |
VARCHAR2(64) |
| 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) |
| Original_Source | STRING64 | NA |
The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15" | No |
VARCHAR2(64) |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| Remarks | STRING2000 | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(2000) |
| Rotation_X | double | Plane_Angle deg |
Rotation about the X or "transverse" axis of the current system relative to the From_Coordinate_System. Clockwise is positive. Rotation_X is one of the "six degrees of freedom" for motion, or change in position, and is often referred to as "pitch". This attribute is only used with "Local" coordinate systems. | No |
NUMBER |
| Rotation_Y | double | Plane_Angle deg |
Rotation about the Y or "longitudinal" axis of the current system relative to the From_Coordinate_System. Clockwise is positive. Rotation_Y is one of the "six degrees of freedom" for motion, or change in position, and is often referred to as "roll". This attribute is only used with "Local" coordinate systems. | No |
NUMBER |
| Rotation_Z | double | Plane_Angle deg |
Rotation about the Z or "vertical" axis of the current system relative to the From_Coordinate_System. Clockwise is positive. Rotation_Z is one of the "six degrees of freedom" for motion, or change in position, and is often referred to as "yaw". This attribute is only used with "Local" coordinate systems. | No |
NUMBER |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Source | STRING64 | NA |
Name of the person or organization responsible for this entitys 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) |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| Version | STRING255 | NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| Vertical_Reference | R_Vertical_Reference |
|
The code or mnemonic that identifies the elevation reference types, e.g., KB, DF, etc. The vertical reference provides the zero measurement point for the vertical axis of the coordinate system. For instance a measured depth coordinate system will have a depth equal to zero at it"s KB, the vertical reference. | No |
VARCHAR2(64) |
| X_Offset | double | Length m |
Lateral offset of the Coordinate System in the Easterly or decreasing Longitude direction from the From_Coordinate_System. If the current coordinate system is East of the original coordinate system, the offset is positive. If the current coordinate system is West of the original coordinate system, the offset is negative. X_Offset is one of the "six degrees of freedom" for motion, or change in position, and is often referred to as "sway". This attribute is only used with "Local" coordinate systems. | No |
NUMBER |
| Y_Offset | double | Length m |
Lateral offset of the Coordinate System in the Northern or positive Latitude direction from the From_Coordinate_System. If the current coordinate system is North of the original coordinate system, the offset is positive. If the current coordinate system is South of the original coordinate system, the offset is negative. Y_Offset is one of the "six degrees of freedom" for motion, or change in position, and is often referred to as "surge". This attribute is only used with "Local" coordinate systems. | No |
NUMBER |
| Z_Offset | double | Length m |
Vertical offset of the current Coordinate System and the From_Coordinate_System. Z offsets are measured as a depth system with values increasing in a downward direction. If the current coordinate system is below the original coordinate system, the offset is positive. If the current coordinate system is above the original coordinate system, the offset is negative. Z_Offset is one of the "six degrees of freedom" for motion, or change in position, and is often referred to as "heave". This attribute is only used with "Local" coordinate systems. | No |
NUMBER |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Alternate_Elevation | Coordinate_System | The coordinate system that represents the elevation reference to which these refer. | Cascade | Yes |
| Application_Project | Project_CRS | The identifier of the coordinate reference system which provides the spheroid, datum and projection for the interpretation project. | Restrict | No |
| Area | Original_Coord_System | Coordinate system of the incoming Area data, including cartographic, elevation and azimuth references. | Restrict | No |
| Borehole | Working_Coord_System | The working coordinate system defined for the borehole | Restrict | No |
| Borehole_Summary_DOV | Working_Coord_System | READ ONLY: Unique identifier for the working coordinate system. | Cascade | No |
| Borehole_Summary_DOV | Original_Coord_System | Unique identifier for the coordinate system of the incoming (i.e., original) Position data, including cartographic, elevation and azimuth references. | Cascade | No |
| Checkshot_Survey | Depth_Vertical_Reference | The coordinate system in which the checkshot depth datum is defined as the vertical reference. | Restrict | Yes |
| Checkshot_Survey | Time_Vertical_Reference | The coordinate system in which the time datum is defined as the vertical reference. This is an elevation not a time value. | Restrict | Yes |
| Coordinate_System | From_Coord_Sys | This coordinate system is defined with respect to another Local, Projection, or Geodetic System | Cascade | No |
| Deviation_Survey | Coordinate_System | An Association to define the Coordinate System for a Deviation Survey | Restrict | Yes |
| Deviation_Survey_Point | Coordinate_System | An association to define the Coordinate System for a Deviation Survey Point | Restrict | No |
| Deviation_Survey_Proc_DOV | Coordinate_System | READ ONLY: Unique identifier for the coordinate system. | Cascade | No |
| Deviation_Survey_Raw_DOV | Coordinate_System | Unique identifier for the coordinate system. | Cascade | Yes |
| Drill_Target | Coordinate_System | The identifier of the coordinate reference system in which this drill target is expressed. | Restrict | Yes |
| Export_Job | Output_CRS | The coordinate system in which the data is to be exported. | Restrict | No |
| Feature_Representation | Time_Vertical_Reference | The identifier of the coordinate reference system which provides Time Vertical Reference to Interpretation Objects. | Restrict | No |
| Line | Original_Coord_System | Coordinate system of the incoming line data, including cartographic, elevation and azimuth references. | Restrict | No |
| Log_Channel_Set | Time_Vertical_Reference | The coordinate system in which the time datum is defined as the vertical reference. This is an elevation not a time value. | Restrict | No |
| Log_Channel_Set | Reference_Datum | The vertical coordinate system that specifies the reference, or working, datum providing the zero reference point from which vertical distances are measured. A common example is Kelly Bushing. | Restrict | Yes |
| Marker_DOV | Original_Coord_System | Unique identifier for the coordinate system of the incoming (i.e., original) Position data, including cartographic, elevation and azimuth references. | Cascade | No |
| Multipoint | Original_Coord_System | Coordinate system of the incoming point set data, including cartographic, elevation and azimuth references. | Restrict | No |
| Position | Original_Coord_System | Coordinate system of the incoming Position data, including cartographic, elevation and azimuth references. | Restrict | No |
| Position | Coordinate_System | The coordinate system appropriate to the Position, including normalized cartographic, elevation and azimuth references. | Restrict | No |
| Project_Default | Storage_Coord_Sys | Coordinate system for storing project data. This value is set at project creation time and cannot be changed. | Restrict | No |
| Reservoir_Analysis | Depth_Datum | Reference depth of the reservoir so that zone information can be compared across wells. | Restrict | No |
| Seismic_Dataset | Time_Vertical_Reference | The identifier of the coordinate reference system which provides Time Vertical Reference to Seismic Dataset | Restrict | No |
| Seismic_Survey | Survey_CRS | The identifier of the coordinate reference system which provides the spheroid, datum and projection for the survey | Restrict | No |
| Seismic_Survey_2D_DOV | Survey_CRS | Unique identifier for the coordinate system | Nullify | No |
| Seismic_Survey_3D_DOV | Survey_CRS | Unique identifier for the coordinate system | Nullify | No |
| Spatial_Correlation | Coordinate_System | The coordinate system that the Spatial_Correlation is defined in. | Restrict | No |
| Velocity_Set | Vertical_Reference | The coordinate system in which the velocity set is defined. This coordinate system or one of the coordinate systems in the coordinate system hierarchy contains the vertical references for the velocity set. | Restrict | Yes |
| Well | Permanent_Coord_System | The permanent coordinate system defined for the well | Restrict | No |
| Well_Summary_DOV | Storage_Coordinate_System | READ ONLY: Unique identifier for the storage coordinate system. | Cascade | No |
| Well_Summary_DOV | Permanent_Coord_System | READ ONLY: Unique identifier for the permanent coordinate system. | Cascade | No |
| Well_Summary_DOV | Original_Coord_System | Unique identifier for the coordinate system of the incoming (i.e., original) Position data, including cartographic, elevation and azimuth references. | Cascade | No |
| Work_Order_Output | Output_CRS | The coordinate system in which the data is to be output. | Nullify | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Vertical_Reference | R_Vertical_Reference | The code or mnemonic that identifies the elevation reference types, e.g., KB, DF, etc. The vertical reference provides the zero measurement point for the vertical axis of the coordinate system. For instance a measured depth coordinate system will have a depth equal to zero at it"s KB, the vertical reference. | Restrict | No |
| Azimuth_Reference | Azimuth_Reference | Azimuth reference for the Position. | Restrict | No |
| CRS | R_Coordinate_Ref_System | The projected or geographic coordinate system code. Many coordinate systems are "local". They combine 2-D map coordinates referenced from this CRS attribute with a depth reference provided by R_Vertical_Reference. | Restrict | No |
| Linear_Unit | R_Unit | The unit of measurement on a plane or a projected coordinate system, often meters or feet. (ESRI GIS Dictionary) | Restrict | No |
| Elevation_Unit | R_Unit | The identifier of the unit of measure in which the original elevation is expressed. | Restrict | No |
| From_Coord_Sys | Coordinate_System | This coordinate system is defined with respect to another Local, Projection, or Geodetic System | Cascade | No |
| Carto_Transform | R_Carto_Transform | The coordinate transform method used to convert the FROM_COORD_SYS_ID coordinate system to this coordinate system. This is a transformation from one geographic coordinate system to another. Coordinate transforms do not refer to re-projections from one map projection to another when they are both based on the same geographic coordinate system but use different projection parameters. | Restrict | No |