POLYGON layer from PostGIS renders white tiles

Description

In PostGIS is stored a table of simple, valid POLYGON. Each POLYGON is like a square grid cell, there are no overlapping POLYGON. I believe this same same rendered in Geoserver 2.3x, but no longer have the machine to test (this is the same upgraded server)

One table is aprox. 1400 cells by 1200 cells.

From Geoserver, choose the OpenLayers Preview for the layer. Choose any SLD style, including stock POLYGON, LINE and POINT sld, or a custom SLD with values.

Notice that the cells render correctly close up ("high" zoom levels) but when zooming out ("low" zoom level) to the last two values, Geoserver renders an image, or tiles, as white with no error msg.

WMS in QGis shows the same behavior.. in one case, 1:160,000 renders correctly, but 1:250,000 shows white only.

Environment

None

Activity

Show:
codehaus
April 10, 2015, 3:56 PM

CodeHaus Comment From: darkblueb - Time: Wed, 30 Jul 2014 18:32:54 -0500
---------------------
<p>data -

ct dot light42 dot com slash uf_ba_pop.sql.bz2</p>

codehaus
April 10, 2015, 3:56 PM

CodeHaus Comment From: jgarnett - Time: Wed, 30 Jul 2014 19:38:45 -0500
---------------------
<p>You may want to attach screen shots of working vs not working. Also if you have a log please attach to the issue.</p>

<p>Andrea I spent some time on IRC with Brian going over the usual reasons why a layer won't draw when zoomed out:</p>

<ul class="alternate" type="square">
<li>style related (say scale denominator)? No - same issue found when reverting to the out of the box polygon style.</li>
<li>renderer tripping up on an invalid geometry? No - Brian checked PostGIS</li>
<li>Performance timeout? Perhaps but the empty tiles seem to get returned faster than that ...</li>
</ul>

codehaus
April 10, 2015, 3:56 PM

CodeHaus Comment From: aaime - Time: Thu, 31 Jul 2014 04:24:52 -0500
---------------------
<p>Is this not rendering when zooming out a lot? If so, it might be due to postgis st_simplify killing the polygon fully, and you can fix it by disabling the simplification flag in the postgis store configuration.

See <a href="http://jira.codehaus.org/browse/GEOT-4737" class="external-link" rel="nofollow">http://jira.codehaus.org/browse/GEOT-4737</a>, the issue is actually in postgis though: <a href="http://trac.osgeo.org/postgis/ticket/2093" class="external-link" rel="nofollow">http://trac.osgeo.org/postgis/ticket/2093</a></p>

codehaus
April 10, 2015, 3:56 PM

CodeHaus Comment From: darkblueb - Time: Thu, 31 Jul 2014 11:44:14 -0500
---------------------
<p>Simplify option on the PostGIS Store - that was it</p>

Andrea Aime
February 15, 2017, 11:48 AM

Mass closing all resolved issues not modified in the last 4 weeks

Assignee

Unassigned

Reporter

codehaus

Triage

None

Fix versions

Affects versions

Components

Priority

Medium
Configure