Andrea Aime created GEOT-4051:
---------------------------------
Summary: ArcSDE store does not properly handle or-ed spatial
filters
Key: GEOT-4051
URL: https://jira.codehaus.org/browse/GEOT-4051
Project: GeoTools
Issue Type: Bug
Components: arcsde plugin
Affects Versions: 2.7.4
Reporter: Andrea Aime
Assignee: Gabriel Roldán
Fix For: 2.7.5
Attachments: GEOT-4051-notests.patch
The ArcSDE store fails to properly handle two or more or-ed spatial filters,
since it's building them as-is into the sde query, which apparently can only
handle and-ed filters instead: the query takes a list of spatial filters
without any way to specify how to combine them.
Combining spatial filters in OR is not very common, but it's importat to deal
with geometries and map displays around the international dateline, where the
typical query looks something like "geometries in this area just before
longitude 180, or geometries in that area right after -180".
One obvious way to solve the issue is to stop declaring support for OR in the
filter capabilities of GeometryEncoderSDE, but that would make it stop using
any kind of spatial filtering across the dateline, which is bad. So I went for
a different solution that tries to rework the list of or-ed spatial filters
into a single spatial filter instead, playing with geometry manipulations.
The bbox filters are not merged togheter into a single large bbox because the
bboxes in the above case span the entire globe, so I preferred to go for a
intersection test with a multipolygon.
I'm going to attach a patch that should be complete code wise, but still lacks
tests, tomorrow I'll attach tests, but if in the meantime you want to review
the logic and point out any mistake/incompatibility with the current gt-sde
module design, that would be appreciated
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://jira.codehaus.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
