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 2D 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 reprojections 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. "IHSEnergyData" 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 mostrecent 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 2D 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 reprojections from one map projection to another when they are both based on the same geographic coordinate system but use different projection parameters.  Restrict  No 