| Name | R_Coordinate_Ref_System |
|---|---|
| Entity Type | Table |
| Description | The coordinate reference system used in project scope. This will include ESRI coordinate reference systems accessible with the projection engine as well as other well known local, legacy, or proprietary coordinate reference systems that need to be shared. Coordinate reference system definitions should come from ESRI for use with the SDE projection engine. If additions are made, they are expected to integrate with the use of the projection engine and therefore should follow the extension guidelines provided by ESRI. For more information see the Web page, http://arcsdeonline.esri.com/index.htm and follow the links, Developer Interfaces> C API> C API Concepts> Coordinate Systems and Projections> Using persistent user defined objects. |
| Submodel | Spatial |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Active_Flag | boolean NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes 1 |
NUMBER(1) |
| Area_Of_Use | STRING255 NA |
Region of CRS applicability | No |
VARCHAR2(255) |
| Base_Geographic_Ref_Sys | R_Coordinate_Ref_System |
The parent geographic coordinate reference system that this projected coordinate reference system is based upon. An example is projected CRS 'WGS 84 / UTM zone 33N' is projected from WGS 84 (code = 4326). | No |
VARCHAR2(64) |
| CRS_Namespace | R_CRS_Namespace |
The namespace for the cartographic package that controls this coordinate reference system | No |
VARCHAR2(64) |
| Code | CODE NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | Yes |
VARCHAR2(64) |
| Description | STRING2000 NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| EPSG_Alias | CODE NA |
Short name of the CRS in the EPSG namespace (WGS-84) | No |
VARCHAR2(64) |
| Linear_Unit | STRING255 NA |
The unit of measurement on a plane or a projected coordinate system, often meters or feet. (ESRI GIS Dictionary) | No |
VARCHAR2(255) |
| Name | CODE NA |
The spelled-out name of the reference value. | No |
VARCHAR2(64) |
| OpenGIS_Well_Known_Text | STRING2000 NA |
Text string which specifies the projection parameters according to the OpenGIS standard. | No |
VARCHAR2(2000) |
| Original_Source | STRING255 NA |
The original source of this coordinate reference system. Many ESRI Codes are attributed to EPSG. Another example is when the CRS is an extension to an out of the box ESRI coordinate reference system. Then SOURCE is the group making the addition and the ORIGINAL SOURCE is the provider of the new coordinate reference system. | No |
VARCHAR2(255) |
| Revision_Date | DATE NA |
Date CRS parameters were last revised | No |
DATE |
| Source | CODE NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |
| Source_Version | CODE NA |
The version number assigned by the Source. For example, if the Source is ESRI this will be the version number of the software used to produce or modify the data. | No |
VARCHAR2(64) |
| Type | CODE NA |
Coordinate reference systems (CRS) are classified as geographic or projected. A 3D geographic CRS has axes of latitude, longitude and ellipsoidal height. GPS receivers indicate location in this manner. A 2D geographic CRS has axes of latitude and longitude and it is the horizontal subset of a 3D geographic CRS. A projected CRS is a Cartesian 2D system with axes of easting and northing. The axes are referred to as E and N or X and Y, in any order. Projected coordinates result from the conversion of geographic 2D coordinates through a map projection. | 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Coordinate_System | CRS | 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 |
| Project_Recommended_CRS | CRS | Coordinate reference system that is fit for use in the project. | Restrict | Yes |
| R_CSMap | ESRI_CRS | The ESRI (system) coordinate system that is equivalent to the matched coordinate system. | Restrict | Yes |
| R_CSMap | Match_CRS | The matched coordinate system that is equivalent to the ESRI (system) coordinate system. | Restrict | Yes |
| R_Carto_Transform | From_Geographic_CRS | The "From" geographic coordinate reference system involved in this transformation. | Restrict | No |
| R_Carto_Transform | To_Geographic_CRS | The "To" geographic coordinate reference system involved in this transformation. | Restrict | No |
| R_Coordinate_Ref_System | Base_Geographic_Ref_Sys | The parent geographic coordinate reference system that this projected coordinate reference system is based upon. An example is projected CRS 'WGS 84 / UTM zone 33N' is projected from WGS 84 (code = 4326). | Restrict | No |
| Study | Cartographic_System_Code | The cartographic system in which the X and Y measurements for the Study bounding box are described. | Restrict | No |
| Study_3D_Horizon_Interp | Original_Coordinate_System | The coordinate system in which the grid was originally created. | Restrict | No |
| Study_Grid | Original_Coordinate_System | The coordinate system in which the grid was originally created. | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| CRS_Namespace | R_CRS_Namespace | The namespace for the cartographic package that controls this coordinate reference system | Restrict | No |
| Base_Geographic_Ref_Sys | R_Coordinate_Ref_System | The parent geographic coordinate reference system that this projected coordinate reference system is based upon. An example is projected CRS 'WGS 84 / UTM zone 33N' is projected from WGS 84 (code = 4326). | Restrict | No |