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) .

  • 16 November 2019
  • 2 replies
  • 0 views

Badge

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

Userlevel 2
Badge +17

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?

Badge +2

@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