Skip to main content
12 events
when toggle format what by license comment
May 24, 2016 at 21:14 history edited PolyGeo CC BY-SA 3.0
deleted 56 characters in body
May 24, 2016 at 11:50 answer added user39790 timeline score: 2
May 24, 2016 at 11:29 comment added BradHards 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).
May 24, 2016 at 11:22 comment added user39790 I appreciate your support for the WKT format, but this is a question/answer forum. As I have said, manually translating what would amount to nearly 100 co-ordinates for each project is not an option. If you do have a solution (i.e a formula that could do as you suggest), I'd be very grateful to hear it, but simply saying that I 'can' reverse the order without specifying how is not very helpful.
May 24, 2016 at 11:17 history edited user39790 CC BY-SA 3.0
added 245 characters in body
May 24, 2016 at 11:12 comment added Vince "Well-Known" is just that. There's no reason for any software to handle reversed order. You certainly can reverse the order in your function; in fact, you must.
May 24, 2016 at 11:03 comment added user39790 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
May 24, 2016 at 10:59 comment added Vince 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.
May 24, 2016 at 10:57 comment added user39790 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.
May 24, 2016 at 10:02 comment added BradHards Why not do the reordering in your spreadsheet?
May 24, 2016 at 9:08 history edited user39790 CC BY-SA 3.0
Added example
May 24, 2016 at 8:48 history asked user39790 CC BY-SA 3.0