how would one expose 2 (or more) linked datasets in pygeoapi

[pvgenuchten]

Is your feature request related to a problem? Please describe.

linking attribute data to a dataset providing a geometry is a common case in GEO, often people join the 2 datasets and publish it as a new dataset. however i would like to see alternatives to that approach, can pygeoapi facilitate it?

I think this makes a perfect case for the diving-into-geopython workshop

Would like to hear your thoughts on this idea

Describe the solution you'd like

• [ ] define a dataset without geometry field
• [ ] in config define a linkage between 2 datasets, the linkage between a geometry record to a number of attribute records, using the feature.link section
• [ ] could pygeoapi derive reverse linkage if a link exists from A to B, pygeoapi (backend) could derive also the reverse linkage?
• [ ] a query mechanism (CQL) exists which is able to travers the link and apply a combined filter to both datasets (A.name like 'AR%' and B.geom within 'xxx'? Queries on data structures is suggested in the filter part3

[ksonda]

We explored and implemented an adjacent idea here: https://github.com/geopython/pygeoapi/pull/690