| Name | R_Carto_Transform |
|---|---|
| Entity Type | Table |
| Description | Datum transforms from one geographic coordinate reference system to another. Datum transformation 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 | DESCRIPTION_STR NA |
Region of the datum transformation applicability | No |
VARCHAR2(999) |
| 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) |
| From_Geographic_CRS | R_Coordinate_Ref_System |
The "From" geographic coordinate reference system involved in this transformation. | No |
VARCHAR2(64) |
| 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 transformation. Many ESRI Codes are attributed to EPSG. Another example is when the transform is an extension to an out of the box ESRI transform. Then SOURCE is the group making the addition and the ORIGINAL SOURCE is the provider of the new transformation method. | No |
VARCHAR2(255) |
| Preferred_Transform_Flag | boolean NA |
A flag indicating that this transform between a given pair of "To" and "From" geographic coordinate systems is preferred for general use at this site: Y = 1 or N = 0. | No |
NUMBER(1) |
| Reversible_Flag | boolean NA |
Flag to indicate if the transformation is reversible. The flag is set to 1 if true and 0 if false. Several classes of transformation methods are non-reversible, including multiple regressions, polynomial transformations and affine transforms. The primary authority for reversibility is the EPSG. This information is for reference only and does not imply any specific behavior in the GIS software application. The ESRI SDE projection engine understands all supported transformations to be reversible. | No |
NUMBER(1) |
| 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 transform data. | No |
VARCHAR2(64) |
| To_Geographic_CRS | R_Coordinate_Ref_System |
The "To" geographic coordinate reference system involved in this transformation. | No |
VARCHAR2(64) |
| Type | CODE NA |
Datum transformations are classified according to the method used to change from one datum to another. An incomplete set of example transformation types include, Geocentric translations, Complex polynomial (4th-order), Position Vector 7-param. transformation and NADCON. | 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 | Carto_Transform | The datum 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. Datum 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 |
| Project_Recommended_Xform | Transformation_Method | The recommended datum transformation method used with this combination of "From" and "To" geographic coordinate systems. There should only be one method for a given pair of "From" and "To" coordinate systems. | Restrict | Yes |
| R_CSMap | Carto_Transform | The datum transform method used to convert from one geographic coordinate system to another. | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| To_Geographic_CRS | R_Coordinate_Ref_System | The "To" geographic coordinate reference system involved in this transformation. | Restrict | No |
| From_Geographic_CRS | R_Coordinate_Ref_System | The "From" geographic coordinate reference system involved in this transformation. | Restrict | No |