Point Database Derive Datum Shift

To Derive a Datum Shift from a point database file you will need to:

1. Create a new Point Database Derive Datum Shift job by going to File>New>Job>Point Database Derive Datum Shift. You can also select the job from the Start Page and use the option to 'Create Job' or right-click in the Project Manager to select Create New Job > Point Database Derive Datum Shift.
   

2. Load a point database file by clicking the Browse (...) button in the Input Data area at the top of the job window. You can load data into the table from a file, or from an ODBC database connection.  Note that the extension of any custom text file scheme that you have defined will appear within the file type filter list.

3. Select your Input and Output coordinate systems. For the Point Database Derive Datum Shift, the left-hand coordinate system is the system of your source coordinates and the right-hand coordinate system is for your target coordinates.

4. Use the Format buttons to select the display format for your input and output coordinates. This is very important for angular units.

5. Use the Source and Target fields to define the columns of data needed for the Datum Shift.

   Input Settings
   

   Source Coordinates - These values should point to the column containing the Latitude and Longitude of your source coordinate system.

   Target Coordinates - These values should point to the column containing the Latitude and Longitude of the target coordinate system.

   

   Point Use Flag - This is a boolean value that determines whether the point is used in the Derive Datum Shift job (any non-zero value), or is only a reference point. If this column does not exist, a new column can be added to the grid with the Add button.  When added, each row in this column will populate with a "1" value.
   

   Name - This is the name of the Datum Shift that will be generated in the datasource.
   

   Transform Method - This will define the type of shift that should be generated when the job is run

   
   

   • Geocentric Transform - This will create a three parameter datum shift from the Source system to the Target system.
     
   • Coordinate Frame Rotation - This will create a 7 parameter datum shift from the Source system to the Target system. This is equivalent to a Position Vector Rotation but will have the opposite sign.
     
   • Position Vector Rotation - This will create a 7 parameter datum shift from the Source system to the Target system. This is equivalent to a Coordinate Frame Rotation but will have the opposite sign.

   Note: Some software packages require either Coordinate Frame Rotation or Position Vector Rotation. Please make sure you are using the correct shift method.
   

   Output Settings
   

   Adjusted Coordinates - These are the calculated target points after the source points have been run through the conversion. These should closely match your target points in a well defined system but are not likely to perfectly match.
   

   Geocentric Residuals- The least squares residual for the control points.

   

6. Once all the necessary columns are set in the Conversion Settings dialog, click OK to close the dialog.  

7. Click the Process button to complete the Derive Datum Shift calculation. Clicking on the Error Plot tab will display a graph showing the residual errors created in the transformation process.

   Error Plot
   

   The Error Plot can be used to graphically assess the fit of individual points within the model.  The relative locations of each control point will be displayed as a point.

   

   The vectors coming off the points are exaggerated by the factor shown at the bottom of the screen.  This is to assist you by drawing your attention to points that do not fit: the longer the vector, the worse the fit.  To see the actual error associated with a point simply click on that point.  The RMSE (Root Mean Square Error) is the overall accuracy of the fit based on the control points included in the fit.

8. If necessary, remove control pairs from the model by changing the value in the Point Use Flag column to a character other than 1.  You can then click Calculate again, to generate a new datum shift.  Repeat this as needed to adjust the fit model.

9. Organize your new Datum Shift by going to Datasource>Datum Transformation Definitions.  All new Datum Shifts will be located at the top level of the Datum Transformations category in the tree view.  You can drag and drop individual definitions to an appropriate subcategory or create a new subcategory to put the systems in.  When you close the dialog, be sure to click Save to save your changes or they will be lost when you close the Calculator.

To create a Batch of the Point Database Derive Datum Shift job, right-click on the job in the Project Manager and select the 'Batch Add' option. Columns will need to be uniformly formatted in each Point Database to add them to a batch job.