Hi Justin, part of the semantics of a SQL join is that it may return multiple rows per "feature" (row in joined table) - one for each possible join. The examples dont cover this case, because of disjoint nature of parks, but if you had for example parks within parks then you would get multiple hits for POIs.
How would this be covered? The proposal needs a discussion on this aspect I feel. Arguably its not the API's problem - and perhaps cant be handled without complex features being built from such responses. Also the API implementation takes functions from the SQL and maps them to named (pre-defined) methods in the code, but SQL is more flexible allowing users to define functions. The API, IMHO, ought to support user defined functions - does the case of a Function argument cover this case , and if so could an example be included? Rob On Tue, Jun 21, 2011 at 9:35 AM, Justin Deoliveira <[email protected]> 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. > > ------------------------------------------------------------------------------ > 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 > > ------------------------------------------------------------------------------ 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
