[postgis-users] ESRI shapefiles

Hugues François hugues.francois at irstea.fr
Fri Mar 8 11:28:00 PST 2019

I think the man page is pretty clear: https://man.cx/shp2pgsql
You should precise the srid corresponding to your data using the -s option. And connection information can also be useful (host, port and user name). It is optional but you could add a spatial index with the -I option. 
Don't forget to give the path to the shapefile and its name without any extension. 
ogr2ogr can be use instead of shp2pgsql. 
Le 8 mars 2019 8:08 PM, "Pinto, Naiara (334F)" <naiara.pinto at jpl.nasa.g
Hi all,

Is there a way to convert shapefiles into geometry records? I don’t see shapefiles on this list (see 9.4):

My shapefiles are polygon type. I think this could be accomplished with shp2pgsq, does anyone have any examples you can share with me?

Thank you,


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190308/5f6bff8b/attachment.html>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190308/5f6bff8b/attachment-0001.html>
-------------- next part --------------
postgis-users mailing list
postgis-users at lists.osgeo.org

More information about the postgis-users mailing list