Yep, sounds good using {bbox}
At the moment I have the problem with tons of views in my database. The
virtual table concept could be a solution for this. If you like I would try
to deploy virtual tables in Geoserver 2.x
Is there anything preventing the patch to be applied to gt-2.6.x ?.
Is there anything preventing virtual tables to work with geoserver 2.x ?
Otherwise I would try a "real world" deployment.
Andrea Aime writes:
> Christian Müller ha scritto:
>> Hmmmmmm
>> And how do you rewrite a query if the bbox param is missing ?
>> e.g
>> where st_area($bbox) > 100000
>> or
>> where anAttr = aValue or <bbox expresion>
>> or
>> where anAttr = aValue and <bbox expresion>
>> ?
>
> That's why I enclosed the part with the bbox in { } and
> said "We allow the user to add a special part of the definition query
> that is actually expanded only if a bbox filter can be extracted
> from the original gt2 query"
>
> So if there is no bbox
>
> select id, name, url,
> ST_SetSRID(ST_Point(longitude, latitude),4326) as location
> from non_spatial_table
> {where longitude >= $bbox.minx and longitude <= $bbox.maxx
> and latitude >= $bbox.miny and latitude <= $bbox.maxy}
>
> becomes just:
>
> select id, name, url,
> ST_SetSRID(ST_Point(longitude, latitude),4326) as location
> from non_spatial_table
>
> In fact using just { } is probably a poor choice.
>
> If we use minx, miny, max, maxy, srid instead of passing down a fully
> encoded envelope and use the {bbox} as the way to mark the
> special portion of the query:
>
> select id, name, url,
> ST_SetSRID(ST_Point(longitude, latitude),4326) as location
> from non_spatial_table
> {bbox} where longitude >= $minx and longitude <= $maxx
> and latitude >= $miny and latitude <= $maxy {bbox}
>
> and
>
> select id, st_buffer(geometry, 1500), name
> from my_spatial_table
> where flow > 143
> {bbox}
> and geometry && st_buffer(ST_MakeEnvelope($minx, $miny, $maxx, $maxy,
> $srid), 1500) {bbox}
>
> If you don't want to add the optimization you just don't add the
> {bbox}...{bbox} portion.
>
> How does it look?
>
> Cheers
> Andrea
>
>
>
> --
> Andrea Aime
> OpenGeo - http://opengeo.org
> Expert service straight from the developers.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
