[postgis-users] Problem importing SHP polygons

[Stephen Woodbridge]

On 3/10/2015 10:48 AM, 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).

What does ogrinfo say about the shapefile? I would start here to make 
sure the shapefile is really a polygon and not and arc type.

-Steve

> 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
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>