search

geopython / pygeoapi

pygeoapi is a Python server implementation of the OGC API suite of standards. The project emerged as part of the next generation OGC API efforts in 2018 and provides the capability for organizations to deploy a RESTful OGC API endpoint using OpenAPI, GeoJSON, and HTML. pygeoapi is open source and released under an MIT license.
https://pygeoapi.io
MIT License
499 stars 262 forks source link

Enable datetime / sortby / properties queries for Postgres provider #687

Closed KoalaGeo closed 10 months ago

KoalaGeo commented 3 years ago

Is your feature request related to a problem? Please describe. We have a lot of data in Postgres, it'd be great to connect this to pygeoapi with the full query functionality the same as an elastic search or mongodb provides

Describe the solution you'd like When using Postgres as a provider for OA-Features be able to query datetime, sortby and properties

Describe alternatives you've considered None

Additional context None

ksonda commented 3 years ago

@webb-ben @dblodgett-usgs we are probably going to need to do this for the global river runner anyway.

webb-ben commented 3 years ago

I've added to the select_properties, skip_geometry, and sortby to the postgres provider when tinkering around for river runner. I don't know if this is still relevant @ksonda but figured I would loop back to this.