Hi Justin,
Your proposal looks a lot like what I did in the 'JoiningQuery' class in
app-schema.
The difference is though that this supports joining on custom filters
while my implementation only allows to joining field expressions to be
specified (so there is always a "=" comparison).
I think some of my code can be re-used, have a look at it.
This would have huge implications for app-schema though, the joining
extensions would need to be rewritten for a great part when geotools
supports joining (something I won't be around for anymore...)
Questions are, though, which kind of join is performed: inner/left outer
? And what Rob said, what will you do with multiple rows being joined to
the same parent feature? Return multiple times the same feature with
different joined features, or allow multiple joined features of the same
type in one feature?
It seems to me that you need some form of complex features as data model
to cover all this.
Regards,
Niels
On 21/06/11 07:35, Justin Deoliveira wrote:
Hi all,
The past couple of weeks i have been working on adding joins to the
geotools query api in support of joins in wfs 2. The work goes well
and i have a working implementation for the jdbc modules that has been
tested with postgis, h2, and oracle.
The proposal is here:
http://docs.codehaus.org/display/GEOTOOLS/Join+Support
Review and feedback welcome. The referenced jira issue has a patch.
I would like to *note* though, this proposal is only for the api
changes and does not include the jdbc implementation. I plan to treat
that as a separate issue/change. There is also some more testing and
cleanup that needs to occur there before a presentable patch can emerge.
Thanks folks.
-Justin
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
*Niels Charlier*
Software Engineer
CSIRO Earth Science and Resource Engineering
Phone: +61 8 6436 8914
Australian Resources Research Centre
26 Dick Perry Avenue, Kensington WA 6151
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
