| 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 | Property / Storage Unit | 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 | STRING2000 | NA |
Region of CRS applicability | No |
VARCHAR2(2000) |
| 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) |
| 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 | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| OpenGIS_Well_Known_Text | STRING4000 | NA |
Text string which specifies the projection parameters according to the OpenGIS standard. | No |
VARCHAR2(4000) |
| 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 | R_CRS_Type |
|
The code or mnemonic that identifies the type of coordinate reference system. The list of CRS types includes: Compound, Engineering, Geocentric, Geographic2D, Geographic3D, Projected, Vertical, Compound Proj + Vertical, and Compound Geog2D + Vertical. | Yes |
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. | Cascade | 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 |
|---|---|---|---|---|
| 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 |
| Type | R_CRS_Type | The code or mnemonic that identifies the type of coordinate reference system. The list of CRS types includes: Compound, Engineering, Geocentric, Geographic2D, Geographic3D, Projected, Vertical, Compound Proj + Vertical, and Compound Geog2D + Vertical. | Restrict | Yes |
| Linear_Unit | R_Unit | The unit of measurement on a plane or a projected coordinate system, often meters or feet. (ESRI GIS Dictionary) | Nullify | No |
| CRS_Namespace | R_CRS_Namespace | The namespace for the cartographic package that controls this coordinate reference system | Restrict | No |