[GeoNetwork-devel] Anyone has (any) good example of a join query in CSW?

Hi all,

Reading the CSW specifications, there's mention of (optional) support for joins in queries. Now, there's just one incomplete example in the document (in fact, the actual query is lacking :wink: ) and I can't think of many examples of queries that require a join. The obvious one I can come up with is a join between contact person and metadata record, something like "find all records describing data on 'soils' with organization name 'FAO'".

Am I missing something obvious here? Anyone has some good examples of queries a user might expect to see answered by a catalog that require these type of queries? Are they just a few that you would reasonably expect, or should such functionality be implemented in a generic manner?

Hoping for some good feedback here.
Ciao,
Jeroen

Jeroen Ticheler wrote:

Hi all,

Reading the CSW specifications, there's mention of (optional) support for joins in queries. Now, there's just one incomplete example in the document (in fact, the actual query is lacking :wink: ) and I can't think of many examples of queries that require a join. The obvious one I can come up with is a join between contact person and metadata record, something like "find all records describing data on 'soils' with organization name 'FAO'".
  

Um I remember wanting to do a join; I forget which metadata model it was (either ebRIM or ISO profile); but I wanted
to figure out which wfs was serving a particular feature type; and then join it up with a styles for that feature type.

Basically; what styles work with this data; it was a hard query because I needed to do a join; and I also needed to
go up the feature type heirarchy asking the question again and again; until I reached "Feature".

Am I missing something obvious here? Anyone has some good examples of queries a user might expect to see answered by a catalog that require these type of queries?

I often make queries (or make assumptions) to figure out what services publish out the same information (ie same data published via WMS and WFS); does that require a join?

Are they just a few that you would reasonably expect, or should such functionality be implemented in a generic manner?Hoping for some good feedback here.
  

Not sure if the above counts as good feedback :slight_smile:
Jody