Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Medium
-
Resolution: Fixed
-
Affects Version/s: 2.9.0
-
Fix Version/s: 2.10-beta
-
Component/s: None
-
Labels:None
Description
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:
—
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.