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