---
title: "Auto Grid Transformations and Auto Grid Setup for DS5 Clients on MDS466"
canonical: "https://servicedesk.maxgeo.com/space/DS/2468249601/Auto%20Grid%20Transformations%20and%20Auto%20Grid%20Setup%20for%20DS5%20Clients%20on%20MDS466"
format: markdown
---
For DS5 clients on MDS466 there is no front-end option for Grid Transformations. All transformations will have to be done in the backend.

 

To set up Autogrid the below scripts need to be run on the database.

·       usp_AutoGridTransform_v2.1.sql

·       CORRECT_Update_DS4_GridTransformation_GDA2020_Script.sql

** **

**Grid Systems**

Table **tblSYSSRSCoordinateSystem** contains all the grid systems. Check this table to find the grids to transform from and to.

If you need to add new grid systems, they can be added in Datashed 5 Admin in the database menu -> Spatial Reference.

** **

**Grid Transformations**

Table **tblSYSSRSCoordinateSystemTx** contains all the grid transformation setup.

**Tx_Name** is the name given to the transformation.

**TxType** is the type of transformation.

·       Null - is a transformation from a defined grid to a defined grid.

·       1P – A single point rotation usually used in azimuth transformations.

·       2P – Two-point transformation from the conversion of two known points in both grids.

**From_Grid_ID **is the grid to convert from. i.e.  MGA94_51

**To_Grid_ID **is the grid to convert to.

**P1 and P2 fields** are for the from and to grid coordinates for a P2 transformation.

**From_North_Var** is the Northing field to convert from. i.e. Orig_North

**From_East_Var** is the Easting field to convert from. i.e. Orig_East

**From_Rl_Var** is the RL field to convert from. i.e. Orig_RL

**From_Azim_Var** is the Azimuth survey field to convert from. i.e. Orig_Azimuth. This would only be used with collar and azimuth only transformations.

**To_X_Var** is the same as the From_X_Var fields above but the location the transformation results are sent to.

**Theta **is the angle of difference between P2 transformations.

**SF **is the scale factor between P2 transformations.

**TrlX, TrlY, and TrlZ** are the X, Y, and Z difference between P2 transformations.

**From_Grid_Var **DH Collar table from grid ID location. i.e. Orig_Grid_ID.

**To_Grid_Var **DH Collar table to grid ID location. i.e. Nat_Grid_ID.

**From_SGrid_Var and To_SGRid_Var **Same as X_Grid_Var above except for Site tables. Only fill in the grid fields required for either collars or sites.

**Decimal_Places **the number of decimal points in the transformation, generally use 5 for transformations into meter grids (MGA), use 7 for transformations into Lat Long degree grids (WGS), generally use 3 for transformations into meter grids (MGA) from the same meter grid (this will fix any minor transformation errors), and use 2 for azimuth only conversions.

** **

**Auto Grid Transformations**

The information for the autogrid transformations in the **tblSYSAutoGridTransformation** table.

**TX_NAME** is the name of the transformation from tblSYSSRSCoordinateSystemTx.

**DataSet** is for the dataset this transformation will affect. (Remember to set one up for each required DataSet).

**Sort** is the order the transformations will be performed. This means if you have a transformation which relies on a grid being populated then it is useful to have that transformation further down the list. i.e. if the transformation of Lat long data is coming from national grids, then it is best to do all the transformations to national grids first.

**Table_Prefix **is for which table the transformation is to be run on eg. DH, PT.

 

 

**Note:** Coordinate sets for downhole coordinates are required to have North, East, and RL populated. Transformations will not run where any of the values are null.