Finding the longitude and latitude of a point
Finding the longitude and latitude of a point
It is possible to find the longitude and latitude of any point within the system, as long as it has a location point.
To find the longitude and latitude of a set of points:
Open a browse on the schema you want to find the Longitude and Latitude for by right clicking on it and selecting Open Browse
Right click in the browse and select Add Column
Type CENTRE_X(Set_coordsys( into the Expressions box
Double click on the Master table and select the Location/Point then click on Paste
Finish the expression with ,14))/1000000
The expression should look something like this:
CENTRE_X(Set_coordsys(MASTER.POSTCODE_POINT,14))/1000000
Click on Add then select OK
This will give you the Longitude. To find the Latitude:
Type CENTRE_Y(Set_coordsys( into the Expressions box
Double click on the Master table and select the Location/Point then click on Paste
Finish the expression with ,14))/1000000
The expression should look something like this:
CENTRE_Y(Set_coordsys(MASTER.POSTCODE_POINT,14))/1000000
Click on Add then select OK
Set_coordsys – sets the co-ordinates system to the value required which here is 14.
14 is how co-ordinate system WGS84 Latitude and Longitude is stored in InSite
Last updated