Hi, Mapserver seems to rely on this list of coordinate systems with reversed axis order: https://github.com/mapserver/mapserver/blob/master/mapaxisorder.csv
Because TinyOWS lives so close to Mapserver perhaps they could utilize the same list? It would be nice if Mapserver WFS and TinyOWS WFS would have the same understanding about the axis order. -Jukka- Rahkonen Jukka wrote: Hi Olivier, Sorry for the late response. I analyzed finally what axis order alternatives the srs_wkt field in the spatial_ref_sys table contains and the situation is a bit more complicated than you have believed. This is the result of a SELECT DISTINCT query 1) AXIS[""Easting"",EAST],AXIS[""Northing"",NORTH]]" 2) AXIS[""X"",EAST],AXIS[""Y"",NORTH]]" 3) AXIS[""Northing"",NORTH],AXIS[""Easting"",EAST]]" 4) AXIS[""X"",NORTH],AXIS[""Y"",EAST]]" 5) AXIS[""Y"",EAST],AXIS[""X"",NORTH]]" 6) AXIS[""X"",SOUTH],AXIS[""Y"",WEST]]" 7) AXIS[""Y"",NORTH],AXIS[""X"",EAST]]" 8) AXIS[""E(X)"",EAST],AXIS[""N(Y)"",NORTH]]" 9) AXIS[""x"",NORTH],AXIS[""y"",EAST]]" 10) AXIS[""Easting"",UNKNOWN],AXIS[""Northing"",UNKNOWN]]" 11) AXIS[""none"",NORTH],AXIS[""none"",EAST]]" 12) AXIS[""X"",UNKNOWN],AXIS[""Y"",UNKNOWN]]" 13) AXIS[""Northing"",UNKNOWN],AXIS[""Easting"",UNKNOWN]]" My conclusions: Must not be flipped: 1, 2, 8 Must be flipped: 3, 4, 9 Probably should not be flipped: 10, 12 Probably should be flipped: 11, 13 No idea: 5, 6, 7 The most important system for me is EPSG:3067 and it has the WKT as in alternative 1: AXIS[""Easting"",EAST],AXIS[""Northing"",NORTH]]" -Jukka Rahkonen- Lähettäjä: mapserver-users-boun...@lists.osgeo.org<mailto:mapserver-users-boun...@lists.osgeo.org> [mailto:mapserver-users-boun...@lists.osgeo.org] Puolesta Olivier Courtin Lähetetty: 18. joulukuuta 2012 9:10 Vastaanottaja: Mapserver-Users (mapserver-users@lists.osgeo.org<mailto:mapserver-users@lists.osgeo.org>) Aihe: Re: [mapserver-users] [TinyOWS] TinyOWS 1.1.0 and the old good axis order trouble On Mon, Dec 17, 2012 at 11:16 AM, Rahkonen Jukka <jukka.rahko...@mmmtike.fi<mailto:jukka.rahko...@mmmtike.fi>> wrote: Hi Jukka, Nice to see you again here :) I have been running TinyOWS r558 for quite a long time because it is dealing almost right with the axis order of the projections I am commonly using. Now I had a fast try with the current TinyOWS 1.1.0 version but unfortunately I realized that it is doing wrong thing by flipping the axis with urn:ogc:def:crs:EPSG::3067. On this topic we will not make any progress, without a regression test. (OGC CITE don't cover this issue) Could you provide from a single point stored in the database, requests and answers awaited ? I could also try to write it by myself too, but will definitly need you to read it back, for all eastern stuff... What is the logic that TinyOWS is using when it decides whether the axis should be flipped or not for WFS 1.1.0? Mainly 2 factors, as i recall: - if it's SRS or CRS (meaning EPSG:xxxx or urn:ogc:def:crs:EPSG::xxxx) - if SRTEXT contain both AXIS["X",NORTH]] and AXIS["Easting",EAST]] -- Olivier
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
