Hello,
I am trying to perform 'GetFeature' request with JOIN operation i.e. "typeName" attribute for "<Query>" element contains more than one feature type name:
...
<Query typeName="myns:CONNECTION,myns:CARRIER">
...
and refers fields from both features types in "<Filter>" (according to "Web Feature Service Implementation Specification, Reference number OGC 04-094
Version: 1.1.0", Chapter 9). Unfortunately, I am getting error: "Could not locate {http://…}CONNECTION,myns:CARRIER in catalog." It seems that GeoServer expects only one name here. Does GeoServer support such type of (JOIN) queries? If so, what is wrong with my "typeName" attribute?
I am using GeoServer 1.7.3.
Thank you,
Ralf Wagner
Ralf Wagner ha scritto:
Hello,
I am trying to perform 'GetFeature' request with JOIN operation i.e. "typeName" attribute for "<Query>" element contains more than one feature type name:
...
<Query typeName="myns:CONNECTION,myns:CARRIER">
...
Despite the schema the WFS 1.1 standard does not support joining.
Joining has been under discussion for quite a few releases and
each time it has been baked out of the official standard near
the end of the spec process, this time they forgot to fix
the schema.
I've seen the WFS 2.0 and Filter 2.0 specification and in those
it seems they added optional support for join along with more
than a dozen new filters specifically thought to express
join conditions in the classic, spatial and temporal domains.
For the time being I suggest you create a joining view in
your database, register it in the spatial metadata columns
of your database as if it was a spatial table and use that
as the feature type in GeoServer, that will work fine
if the relationship is 1-1. If it's 1-n you'll need complex
feature support, that no stable release of GeoServer has,
whilst GeoServer 2.0 beta2 should have initial support
for that cas as well (to be released within the month)
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
Hi Ralf,
I am using a wfs:getFeature with multiple Query elements to get some
kind of join functionality. This works for me at last.
Might be of help for you too.
If you need a code example I will try to provide it
Cheers Kris
-----Original Message-----
From: Andrea Aime [mailto:aaime@anonymised.com]
Sent: Monday, May 25, 2009 3:56 PM
To: Ralf Wagner
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and 'GetFeature' request with
JOIN query
Ralf Wagner ha scritto:
Hello,
I am trying to perform 'GetFeature' request with JOIN operation i.e.
"typeName" attribute for "<Query>" element contains more than one
feature type name:
...
<Query typeName="myns:CONNECTION,myns:CARRIER">
...
Despite the schema the WFS 1.1 standard does not support joining.
Joining has been under discussion for quite a few releases and
each time it has been baked out of the official standard near
the end of the spec process, this time they forgot to fix
the schema.
I've seen the WFS 2.0 and Filter 2.0 specification and in those
it seems they added optional support for join along with more
than a dozen new filters specifically thought to express
join conditions in the classic, spatial and temporal domains.
For the time being I suggest you create a joining view in
your database, register it in the spatial metadata columns
of your database as if it was a spatial table and use that
as the feature type in GeoServer, that will work fine
if the relationship is 1-1. If it's 1-n you'll need complex
feature support, that no stable release of GeoServer has,
whilst GeoServer 2.0 beta2 should have initial support
for that cas as well (to be released within the month)
Cheers
Andrea
--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.
------------------------------------------------------------------------
------
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