[postgis-users] Geographic Coordinates

[pcreso at pcreso.com]

pgsql2shp -s 4326 -I <shapefile> <mytable> | psql -d <mydb>

where 
<shapefile> is the name of your shapefile, eg: myfile.shp
<mytable> is the name of the POstgis table to create & populate
<mydb> is the name of od the Postgis database (Postgres with Postgis installed)

"-s 4326" tells pgsql to create a table for a shapefile with lat/long geometries, as in
http://www.spatialreference.org/ref/epsg/4326/

HTH,

 Brent Wood

--- On Sat, 12/31/11, Daniel Montenegro <dmontenegro84 at gmail.com> wrote:

From: Daniel Montenegro <dmontenegro84 at gmail.com>
Subject: [postgis-users] Geographic Coordinates
To: "postgis-users" <postgis-users at postgis.refractions.net>
Date: Saturday, December 31, 2011, 4:57 PM

Hi there! How can I import a shape file with geographic coordinates to PostGIS via shp2pgsql? Thanks Daniel

-----Inline Attachment Follows-----

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111230/af88fccf/attachment.html>