Coordinate Converter Form

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Forms > EarthSoft Standard Forms >

Coordinate Converter Form

Form Name: Coordinate Converter Form

File Name: EarthSoft.Forms.Library.71938.dll

Software: EQuIS Professional

Source: EQuIS Professional install

 

Description: The Coordinate Converter Form allows you to convert coordinates stored in DT_COORDINATE from one COORD_TYPE to another. This form is found in the forms section in the Open window.

 

Installation Instructions: The Coordinate Converter Form is included with the EQuIS Professional installer. No additional steps are necessary.

 

Overview:

 

Note: Prior to making changes with the Coordinate Converter form, we strongly encourage users to create a database backup. Changes made by the form are permanent and irreversible alterations to records in DT_COORDINATE.

 

Do not use the filter within the form's data grid. It results in the error shown below when the 'Add New' or 'Replace Existing' button is clicked.

 

Index was outside the bounds of the array.

  at Infragistics.Shared.SparseArray.ValidateIndex(Int32 index)

  at Infragistics.Shared.SparseArray.GetItem(Int32 index, ICreateItemCallback createItemCallback)

  at Infragistics.Win.UltraWinGrid.RowsCollection.get_Item(Int32 index)

  at EarthSoft.Forms.Library._71938.CoordinateConverter.DoConversion()

  at EarthSoft.Forms.Library._71938.CoordinateConverter.btnDoConversion_Click(Object sender, EventArgs e)

 

 

 

30323-Open

 

Note: ALS users must have Edit or Owner permissions for the facility to run and save conversions.

 

Data Section

 

The data section pulls from tables and data that is already in your database. This section is where you tell the Coordinate Converter Form what coord type that you want to convert from.

 

coordinate_source_target

 

Source

 

Select the source Coord Type and Identifier (both required) for conversion.

 

The Coord Type drop-down lists the available coord types from RT_COORD_TYPE, where the SRID field is populated with a Well-Known ID published by ESRI. Other coord types (i.e., non-ESRI or missing valid SRID) are not supported for conversion.

The source Identifier drop-down is populated from DT_COORDINATE.

 

The source Coord Type and Identifier selections filter the grid at the bottom of the form for review of records ready for conversion.

 

The clear filter buttons will clear the individual filter selections.

 

Note: ESRI Well-Known IDs are listed on the ArcGIS Resources webpage http://resources.arcgis.com/en/help/arcgis-rest-api/index.html#/Projected_coordinate_systems/02r3000000vt000000/.

 

Target

 

Select the target Coord Type and Identifier (both required).

 

The Coord Type drop-down lists the available coord types from RT_COORD_TYPE, where the SRID field is populated with a Well-Known ID published by ESRI. Other coord types (i.e., non-ESRI or missing valid SRID) are not supported for conversion.

The source Identifier drop-down is populated from DT_COORDINATE. The add identifier button allows you to add a new identifier to the converted result.

 

Convert Coordinates

 

Once the source and target inputs are populated, the grid will be filtered and available for row selection to run the conversion on.

 

Use the Select All button or click rows in the grid to select individually.

 

30323-SelectAll

 

30323_selection

 

Click Add New to create new records of the converted coordinates in DT_COORDINATE. The grid will update to show the pendiing new records in light blue.

 

Click Replace Existing to replace the selected records with the converted coordinates in DT_COORDINATE. The grid will update to show the pending new records in light blue, along with the records that will be replaced shown in red.

 

For both conversion options, a validation process is run on the input fields to make sure that none are null or empty.

 

Conversions can only be completed if the value of the ESRI geometry server referenced in the ST_CONFIG table (GeometryServerURL) is valid. By default, the geometry server chooses the best transformation based on the input data and spatial references.

 

The OBSERVATION_DATE field is populated with the current date, and the remark field of the converted row is populated with a "Generated by Converting Coord Type: 'COORD_TYPE_CODE' Identifier: 'identifer' to Coord Type: 'COORD_TYPE_CODE' Identifier: 'identifer'" statement.

 

Note: Elevations are not converted.

 

Once the validation completes, the Back arrow_left_08(1) and Save SaveAs toolbar options are enabled.

 

Review the highlighted rows to ensure expected output.

 

Select the Back button to change inputs or selected rows.

 

Select the Save button to complete the conversion process. This will append the converted values in new records or replace the original coordinates with the converted values in the database (for add New or Replace Existing button selection, respectively). A confirmation window will display how many records were saved.

 

30323-Saved

 

After the Save process, the Coordinate Converter Form is refreshed with all the new data from DT_COORDINATE.