2

I have a set of data with Lat/Lon co-ordinates taken from Google Earth, I've converted the co-ordinates into WKT using a short formula in a spreadsheet, converted to a csv and imported. Unfortunately Google presents its points as Lat/Lon whereas all the CRSs I usually use only seem to understand Lon/Lat. I thought there were conventions for this sort of thing so that GIS systems could talk to one another!

Anyway, does anyone know of a CRS that recognises Lat/Lon, in that order?

  • Thought it might be useful to give an example - co-ordinates come to me looking like this "50.698162325700466,-4.674852266907692, 50.69849212863936,-4.674183055758476" my formula converts them to this "MULTIPOINT ((50.698162325700466 -4.674852266907692) (50.69849212863936 -4.674183055758476)). The points are all in England, so you can see they are in Lat/Lon.
  • I've just thought that +axis=neu should work as a custom CRS, but it doen't seem to be translating correctly. It's turning the points around as required, but also shifting them about.
Improve this question
7
  • 1
    Why not do the reordering in your spreadsheet?
    – BradHards
    Commented May 24, 2016 at 10:02
  • Tried that, but with a multipoint, there's no way of getting a formula to 'see' which part is the easting and which the northing and swap them round. If it were only one point I could take the first 10 digits and the first ten after the comma and swap them, but not with a multipoint.
    – user39790
    Commented May 24, 2016 at 10:57
  • Ordering is somewhat arbitrary, but the stardard is {X,Y}. Well-Known Text is documented as requiring X,Y order. No translation is required, just correct ordering.
    – Vince
    Commented May 24, 2016 at 10:59
  • I understand the way WKT 'should' be ordered, but I'm having to deal with several dozen multipoints in the format "N,E N,E N,E". I can't manually turn them all round so was asking if there were any way to get QGIS to recognise that the WKT is in the format y,x not x,y
    – user39790
    Commented May 24, 2016 at 11:03
  • 2
    If you show the formula that you are using, perhaps someone can suggest a modification. (BTW: these aren't answers - they are clarifications on the question).
    – BradHards
    Commented May 24, 2016 at 11:29

1 Answer 1

Reset to default
2

+axis=neu does in fact work, I had an error in the datum I was using. To clarify; if bringing in WKT that is in the format y,x for whatever reason, using a custom CRS with the axes swapped seems to work.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.