Skip to main content
Question

i have an excel which contain bulk coordinates in two formats, some of them in utm and others are geographic. The problem is some of them are wrong and some needs to b reverse ( x needs to be in y column and y needs to b in x column) .


mehar
Forum|alt.badge.img

i want a way to get the wrong coordinates (example : easting 3628623.38(7) digits and northing 4565105.96(7) digits to be comes as rejected output and the others which needs to b swap between x column and y column

2 replies

takashi
Evangelist
  • November 16, 2019

Hi @mehar, for example, you can use the AttributeCreator to swap two columns like this.

The problem is how you can determine rows in which the two columns should be swapped. How can you determine if the values of x, y are reversed?


Forum|alt.badge.img+2
  • November 18, 2019

@mehar There is also CoordinateSwapper. But as @takashi points out, the real problem is determining which coordinates to swap. Once you've determine that perhaps TestFilter and CoordinateSwapper will do what you want.


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