| Name | R_Carto_Transform |
|---|---|
| Entity Type | Table |
| Description | Coordinate transforms from one geographic coordinate reference system to another. Coordinate 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 | 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 |
The name or description of the Region in which the coordinate transformation applies. | No |
VARCHAR2(2000) |
| Carto_Transform_Rule | R_Carto_Transform_Rule |
|
The identifier of the type of rule to be applied for a cartographic transform. Most transforms are Simple. Other transforms are more complex including: Concatenated - a sequential set of transforms, executed in sequence, Location - transforms based on the location of the object associated with the CRS, and Fallback - transforms to be applied as an alternate to the base transform. | 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) |
| From_Geographic_CRS | R_Coordinate_Ref_System |
|
The "From" geographic coordinate reference system involved in this transformation. | 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) |
| 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. Note that complex transforms have blank OpenGIS_Well_Known_Text. If OpenGIS_Well_Known_Text is needed, navigate to the associated Simple R_Carto_Transforms. | No |
VARCHAR2(4000) |
| 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. If the value of the flag is True (1) then this transform is the preferred one. If the value of this flag is False (0) then it is not. | 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 |
The date on which the 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 |
Coordinate 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 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 |
| 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 coordinate transform method used to convert from one geographic coordinate system to another. | Restrict | No |
| R_Carto_Transform_Member | Member_Carto_Transform | Identifier of the member transform, i.e., the transform that is a step in a multi-step Concatenated transform within the Base transform, or in the case of an Alternate transform, this is one of the alternates to the Base transform. | Cascade | Yes |
| R_Carto_Transform_Member | Base_Carto_Transform | The identifier of the base transform. For Concatenated transforms this is the containing transformation for which the member transforms are performed in sequence to achieve. For Alternate transforms, this is the original transform to which the alternate is an alternate. | Cascade | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| From_Geographic_CRS | R_Coordinate_Ref_System | The "From" geographic coordinate reference system involved in this transformation. | Restrict | No |
| To_Geographic_CRS | R_Coordinate_Ref_System | The "To" geographic coordinate reference system involved in this transformation. | Restrict | No |
| Carto_Transform_Rule | R_Carto_Transform_Rule | The identifier of the type of rule to be applied for a cartographic transform. Most transforms are Simple. Other transforms are more complex including: Concatenated - a sequential set of transforms, executed in sequence, Location - transforms based on the location of the object associated with the CRS, and Fallback - transforms to be applied as an alternate to the base transform. | Restrict | No |