I am using GeoKettle to transfer data from a WFS service to a Postgis DB. The projection of the geometries is WGS 84 :

GEOGCS["WGS 84", DATUM["World Geodetic System 1984", SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]], PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], UNIT["degree", 0.017453292519943295], AXIS["Longitude", EAST], AXIS["Latitude", NORTH], AUTHORITY["EPSG","4326"]]

In the data I have latitude/longitude touples. When it's imported into postgis, it appears as longitude/latitude.

I want to specify a CRS WKT parameter so that when data is imported into postgis, the geometries will appear where they should.

Is this even possible with an CRS conversion?

  • Odd WKT for the projection. It claims that it is EPSG:4326 but still that axis order is Longitude-Latitude. And you say that data use latitude-longitude. Something does not match. – user30184 Nov 13 '14 at 14:12
  • I know, I'm very confused. I managed to operate directly on the Database to change the axis order. There is a ST_FlipCoordinates procedure in Postgis that does the trick, even though it involves some work. Thanks – Mihai Serban Nov 13 '14 at 14:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.