[Geoserver-devel] [JIRA] (GEOS-7641) Spatial filter missing from SQL when a rendering transform style is used

_Failed_to_Retrieve · July 18, 2016, 3:12pm

Simon Hartley created an issue

Spatial filter missing from SQL when a rendering transform style is used

Issue Type:	Bug
Affects Versions:	2.9.0
Assignee:	Unassigned
Attachments:	transform.sld
Created:	18/Jul/16 5:11 PM
Priority:	Medium
Reporter:	Simon Hartley

Here’s a SQL View PostGIS layer I’m calling “test”:

select * FROM (VALUES (ST_SetSRID(ST_MakePoint(0,0),4326), 20)) AS v(location, temperature)

Here’s the query I use to render it:

http://127.0.0.1:8080/geoserver/wms?LAYERS=test&TRANSPARENT=true&FORMAT=image%2Fpng8&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&SRS=EPSG%3A4326&BBOX=-2.6042569438678,30.62910527817,4.4915727783775,37.724935000415&WIDTH=256&HEIGHT=256

When I set the built-in “point” style to be the default, the following SQL is in the log as I expect:

SELECT encode(ST_AsBinary(CASE WHEN ST_HasArc(“location”) THEN “location” ELSE ST_Simplify(ST_Force2D(“location”), 0.02217446788201656) END),‘base64’) as “location” FROM (select * FROM (VALUES (ST_SetSRID(ST_MakePoint(0,0),4326), 20)) AS v(location, temperature)
) as “vtable” WHERE “location” && ST_GeomFromText(‘POLYGON ((-2.7151292832778826 30.518232938759922, -2.7151292832778826 37.83580733982508, 4.602445117787583 37.83580733982508, 4.602445117787583 30.518232938759922, -2.7151292832778826 30.518232938759922))’, 4326)

When I use my Rendering Transformation style (attached), I get the following SQL in the log (without a spatial filter):
SELECT encode(ST_AsEWKB(“location”),‘base64’) as “location”,“temperature” FROM (select * FROM (VALUES (ST_SetSRID(ST_MakePoint(0,0),4326), 20)) AS v(location, temperature)
) as “vtable”

I didn’t have this problem when I was using GeoServer 2.2.5 and the lack of spatial filter is slowing the transform hugely when I use a real-world SQL layer.

Add Comment

This message was sent by Atlassian JIRA (v1000.148.3#100005-sha1:53b5f3f)