>
>> In the extreme case I can see that the user might specify an entirely
>> different query in the SQLView for WMS usage. That's a bit extreme and
>> error prone, though. So dialing that back a bit we get closer to what
>> we're talking about - where various parts of the query can be altered for
>> WMS usage. So far we've just talked about the filter part, but I think it
>> might be nice to allow the geometry column to be manipulated as well - i.e.
>> by substituting an entirely new expression for it. This would subsume the
>> current PostGIS simplify capability, but in a much more general way. For
>> example, a query could convert the geometry to a point, or simplify it
>> using a custom function (e.g. decimation), etc.
>>
>> This might look like:
>>
>> select %GEOM( GEOMETRY, {SDO_GEOM.SDO_CENTROID(GEOMETRY, 1) GEOMETRY }
>> from CUT_BLOCK_SP
>>
>> Note that the %QUERY_GEOM% parameter is not needed here, because the
>> transformed geometry has the same name as the original, so it's fine to use
>> the default GeoServer-generated filter.
>>
>
>
> Erk - I just realized that the %BBOX% parameter is still needed, because
otherwise Oracle will realize there is no index on the computed expression
(because it has the same name as the underlying GEOMETRY, and so that is
the value bound to the GEOMETRY in the spatial filter emitted by GeoServer.
Maybe a better name for %BBOX% would be something like %VIEW_FILTER% or
%USER_FILTER%? Assuming the change is made to substitute $minx, $maxx,
etc.
Hmmm... would this provide a way to create a spatial view on top of an XY
table?! E.g.:
SELECT SDO_GEOMETRY(2001, srid, SDO_POINT_TYPE(x, y, NULL), NULL, NULL))
FROM tablexy WHERE true AND %BBOX{ x >= $ minx AND x <= $maxx AND y >=
$miny AND y <= $maxy }%
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
