I have a table containing data with UTM-location fields (x and y) that we need as lat/long .
I have made the conversion, but struggling with adding the calculated lat/long fields to the table.
This is what I have:
tmpGeoPos:
Load
RowNo() as $RowID
,X as X
,Y as Y
;
SQL SELECT DISTINCT X, Y FROM someTable;
let v_NoOfRows = NoOfRows('tmpGeoPos');
for v_RowCount = 1 to $(v_NoOfRows)
GeoPos:
load
X as X
,Y as Y
,Autonumber(X & '|' & Y) as $geopos
resident [tmpGeoPos]
where $RowID = '$(v_RowCount)';
//here is the calculation from UTM to to variables: latitude and longitude
?? -> how do I add add columns for latitude and longitude to the GeoPos table?
next v_RowCount
DROP table tmpGeoPos;