Skip to main content
Question

How to convert excel Gauss Kruger coordinates to UTM?


Hi, not sure where else to ask this (first time poster).

I have a large amount of coordinate data (only know the coordinates in Gauss-Kruger and the zone (zone 3)). Is there any way I can mass convert these coordinates to UTM?

 

I've been researching this all day and have came across a few helpful research articles and one finished with a website that was created by a team of researchers using R and Shiny software, but the link was dead and I don't have time to recreate their work.

I do not need to put them into a GIS, this data is being recorded in an rdb for analysis purposes, but is still very reliant on LOCIIDs.

3 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • April 24, 2020

Read the Excel spreadsheet in FME.

Then connect an AttributeReprojector transformer to the input, using these settings:

Pick the X and Y attributes from the spreadsheet.

The source is Gauss Zone 3

The destination UTM (in meters) zone 3.

Hope this helps.


virtualcitymatt
Celebrity
Forum|alt.badge.img+35
erik_jan wrote:

Read the Excel spreadsheet in FME.

Then connect an AttributeReprojector transformer to the input, using these settings:

Pick the X and Y attributes from the spreadsheet.

The source is Gauss Zone 3

The destination UTM (in meters) zone 3.

Hope this helps.

This is the way to go - if you're not happy with the result then try the CSMapAttributeReprojector as an alternative.


erik_jan wrote:

Read the Excel spreadsheet in FME.

Then connect an AttributeReprojector transformer to the input, using these settings:

Pick the X and Y attributes from the spreadsheet.

The source is Gauss Zone 3

The destination UTM (in meters) zone 3.

Hope this helps.

Trying today! Thanks a heap.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings