Skip to main content
Solved

Convert Lat/long coordinates to EPSG:28992

  • June 5, 2020
  • 3 replies
  • 269 views

fme_hans
Contributor
Forum|alt.badge.img+5

Hi,

I have a csv file with some coordinates in the following form:

 

Cordinaten gps longitude ; Cordinaten gps latitude

 

4.438.469 ; 5.186.713

How can I convert this to EPSG:28992? I've already tried the Reprojector, AttribureReprojector and CsmapAttributeReprojector but that didn't help.

 

Thank you in advance.

 

Greetings, Hans

Best answer by redgeographics

Normally the AttributeReprojector would be the one to use but it looks like your coordinates are malformed (let me guess, they're coming out of Excel?)

Fortunately, knowing that EPSG:28992 is the Netherlands RD projection, we know that the longitudes are in single digit degrees (in this case 4) and the latitudes are in double digit degrees (51)

So what I would do is:

  1. StringReplacer to replace the . with an empty string, so you get 4438469 and 5186713
  2. AttributeManager to divide the longitude by 10 and the latitude by 100 so you get 4.438469 and 51.86713
  3. AttributeReprojector to reproject them from LL84 to EPSG:28992

And that should do the trick.

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

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • Best Answer
  • June 6, 2020

Normally the AttributeReprojector would be the one to use but it looks like your coordinates are malformed (let me guess, they're coming out of Excel?)

Fortunately, knowing that EPSG:28992 is the Netherlands RD projection, we know that the longitudes are in single digit degrees (in this case 4) and the latitudes are in double digit degrees (51)

So what I would do is:

  1. StringReplacer to replace the . with an empty string, so you get 4438469 and 5186713
  2. AttributeManager to divide the longitude by 10 and the latitude by 100 so you get 4.438469 and 51.86713
  3. AttributeReprojector to reproject them from LL84 to EPSG:28992

And that should do the trick.


virtualcitymatt
Celebrity
Forum|alt.badge.img+47

Normally the AttributeReprojector would be the one to use but it looks like your coordinates are malformed (let me guess, they're coming out of Excel?)

Fortunately, knowing that EPSG:28992 is the Netherlands RD projection, we know that the longitudes are in single digit degrees (in this case 4) and the latitudes are in double digit degrees (51)

So what I would do is:

  1. StringReplacer to replace the . with an empty string, so you get 4438469 and 5186713
  2. AttributeManager to divide the longitude by 10 and the latitude by 100 so you get 4.438469 and 51.86713
  3. AttributeReprojector to reproject them from LL84 to EPSG:28992

And that should do the trick.

What he said! ^


fme_hans
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • 44 replies
  • June 7, 2020

Thanks, I used the wrong projection. I thought it was Mercator but it is LL84. About the rest, you are right. I already made good coördinates with string replacer and divided then.

LL84 did the trick. Thanks.