Hi, Go to the settings of your PostGIS store, scroll near to the bottom and uncheck setting “Support on the fly geometry simplification”.
The option is documented in https://docs.geoserver.org/stable/en/user/data/database/postgis.html but it does not mention the possible negative effects of simplification. Not the positive one – being faster – either. -Jukka Rahkonen- Lähettäjä: Pierric de Laborie <[email protected]> Lähetetty: torstai 5. maaliskuuta 2020 12.56 Vastaanottaja: [email protected] Aihe: [Geoserver-users] Errors in WMS tiles for feature stored in PostGIS Hello, I have published a PostGIS multi-polygon layer in Geoserver but the resulting WMS layer seems to miss a lot of parts compared to its original version (stored in a PostGIS table). When exporting the feature from PostGIS to a shapefile using pgsql2shp and publishing the layer from the shapefile then it is working fine. On a shared folder, I included the shapefile and also the screenshots of previews for the : - PostGIS table in Pgadmin4 (all fine) - same polygon data published in Geoserver using the PostGIS table (missing a lot of "holes"/internal polygons) - same polygon layer published in Geoserver using the shapefile exported from PostGIS (all fine) shared folder : https://drive.google.com/drive/folders/1IGpe6OtYZUBOwXrgcYL1-GeU9WPdAJaD I would prefer to store that data in a Postgis table rather than in a shapefile. Thanks in advance for your help or suggestions! Best, Pierric
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
