[postgis-users] Problem importing SHP polygons

[Mark Cave-Ayland]

On 10/03/15 14:48, Conrad Bielski wrote:

> Hi,
> I'm having a curious issue importing a polygon SHP file into PostGIS.
> I'll describe the procedure that I'm using and the problem that I'm
> having and hopefully somebody has had this issue in the past and fixed it.
> 
> So the procedure is that I use GRASS to produce a vector from a raster
> output: (r.to.vect input=MASK output=vecMap feature=area)  and then
> export to SHP file (v.out.ogr -c -e input=vecMap dsn=fname
> format=ESRI_Shapefile type=area).
> 
> Now when this SHP file is imported into PostGIS, the type is changed to
> multistring for some reason. Then when checking the topology, there is a
> 'ring self-intersection' error. This PostGIS db is then imported into
> GeoServer, where lines are connecting between different parts of the
> largest polygon (this should not be happening). If I fix this typology
> problem, then the largest polygon in the db disappears.
> 
> The strange thing is the following:
> 1. Opening the SHP file in QGIS doesn't have this problem
> 2. Importing the SHP file directly into GeoServer, doesn't generate this
> problem either.
> 
> Why is PostGIS having an issue importing this file?
> 
> Any ideas how to fix this?
> 
> Thanks in advance for your help,
> Conrad

Hi Conrad,

Have you tried disabling the MULTI conversion code in shp2pgsql (add -S
option to the command line) to see if that helps?


ATB,

Mark.