I am using GeoKettle to transfer data from a WFS service to a PostGIS database.

The projection of the geometries is EPSG:4326 :

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

In the data I have latitude/longitude tuples. 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.