Hi all, I've just started using PostGIS as a datastore, importing shapefiles using shp2pgsql. I've attached the shapefiles I use to reproduce this issue: http://osgeo-org.1560.n6.nabble.com/file/n5000060/example.zip example.zip
If there is a problem with the geometry neither WMS nor WFS will work with WFS requests reporting: An exception occurred while parsing WKB data Points of LinearRing do not form a closed linestring This can be verified in PostGIS with the query: SELECT gid, st_isvalidreason(geom), st_summary(geom) FROM c1t3desertpavement WHERE st_isclosed(geom) is FALSE; After repairing the geometry in ArcMap, and importing into PostGIS, the above query no longer returns any rows. When the repaired data is published in GeoServer, WMS requests will work but WFS requests still report the same error. Any help is or suggestions are appreciated. Context: Centralising thousands of shapefiles for client use over WFS in ArcMap I've tried: Reloading the GeoServer cache and restarting GeoServer Cleaning up the data using GRASS (with minor damage to the polygons) which will fix WMS and WFS but Arc fails to show the features and just says "No Geometry" (no errors in the GeoServer logs) Additional notes: I can load the invalid geometry directly from PostGIS using QuantumGIS I am using: GeoServer 2.1.4 Postgres: 9.1.5.1 with PostGIS 2.0.1 using a 2.0 template. Windows Server 2008 -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Repaired-geometries-still-producing-WKB-errors-for-WFS-on-PostGIS-store-tp5000060.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
