[postgis-users] shp2pgsql - reversing x,y coordinates?

[Peter Fay]

Hi,

I am trying to import a shapefile into postgis using shp2pgsql, and the
order of coordinates is getting reversed in the output of shp2pgsql.  (x,y)
becomes (y,x).  Does anyone have an answer?  And how does one get the output
to be (x,y)?

 

>shp2pgsql.exe -D -i -w -s 4326 -I -g line "gshhs_land.shp" public.shoreline
> shoreline.sql

 

 

The shapefile is from the NOAA:

http://www.ngdc.noaa.gov/mgg/shorelines/data/gshhs/version1.3/shapefiles/gsh
hs_land/

 

-Peter

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060801/c76e406e/attachment.html>