Skip to main content
Question

How to convert excel Gauss Kruger coordinates to UTM?

  • April 24, 2020
  • 3 replies
  • 517 views
B

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

erik_jan
Contributor
Forum|alt.badge.img+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • 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+47
  • virtualcitymattCelebrity
  • Celebrity
  • 2000 replies
  • 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.

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

B
  • boringhannah5
  • Author
  • 1 reply
  • April 27, 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.

Trying today! Thanks a heap.

Community Stats

32,076
Posts
121,794
Replies
39,702
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.