Hello,
Is there a CQL filter equivalent to the SQL OVERLAPS function? I have a Postgres/PostGIS database of geometry events, which have a start and an end time and I would like to be able to filter them to ones which occurred during a user defined time period. My start time and end time are both attributes in the WMS layer.
Thanks.
bw
Brian Walawender
Technique Development Meteorologist
Scientific Services Division - Central Region Headquarters
816-268-3114 - Office
816-805-6497 - Cell
Brian,
I just did a quick search to confirm what OVERLAPS actually does and according to MSDN it is,
EXISTS (expression INTERSECT expression)
So you should be able to just use that in CQL.
Below is also the CQL spec for temporal predicates so you may be able to use it instead.
/* This set of productions define temporal predicates */
::= <attribute_name> BEFORE
| <attribute_name> BEFORE OR DURING
| <attribute_name> DURING
| <attribute_name> DURING OR AFTER
| <attribute_name> AFTER
<date-time expression ::= |
Hope this helps,
-Chris
On Fri, May 22, 2009 at 2:56 PM, Brian Walawender <Brian.Walawender@anonymised.com> wrote:
Hello,
Is there a CQL filter equivalent to the SQL OVERLAPS function? I have a Postgres/PostGIS database of geometry events, which have a start and an end time and I would like to be able to filter them to ones which occurred during a user defined time period. My start time and end time are both attributes in the WMS layer.
Thanks.
bw
Brian Walawender
Technique Development Meteorologist
Scientific Services Division - Central Region Headquarters
816-268-3114 - Office
816-805-6497 - Cell
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users