Re: [postgis-users] parallel-processing multiple similar query tasks - any example?
I think you need to provide more information as parallel queries in a database can be done in many ways. You could look at CitusDB, which supports PostGIS if you are trying to do parallel queries. PostgreSQL also supports workers. https://www.postgresql.org/docs/current/how-parallel-query-works.html On Wed, Apr 27, 2022 at 6:33 PM Shaozhong SHI wrote: > multiple similar query tasks are as follows: > > select * from a_table where country ='UK' > select * from a_table where country='France' > and so on > > How best to parallel-processing such types of multiple similar query tasks? > > Any example available? > > Regards, > > David > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
Re: [postgis-users] PG Feat Serv and OGC API
The functions endpoint in pg_featureserv is non-standard, so it's not surprising that client libraries don't support it. So you will have to manually build a URL for the request. pg_featureserv now has CQL filtering: https://github.com/CrunchyData/pg_featureserv/blob/master/hugo/content/usage/cql.md This includes temporal filter support. If you can build the latest code, you might want to look at this as an alternative to functions. It saves writing and deploying functions, and it is much more flexible. On Thu, Apr 28, 2022 at 5:49 AM Rory Meyer wrote: > Afternoon all, > > I've got a PG Featureserv docker container running on a server and a > couple of collections and functions published on it. The data that I'm > querying is better suited for functions. It's mostly time series stuff and > it's nice to give it a start/stop time and a couple other filter > parameters. > > I'm looking at OWSlib to build a python client that consumes off the > server but it doesn't seem like the "functions" are recognised in OGC; " > myserver.org/collections/my_data" is easily called in OWSlib with: > > ``` > from owslib.ogcapi.features import Features > api = Features('http://myserver.org/') > ``` > but there doesn't seem to be a "myserver.org/functions/my_func" > equivalent. > > Am I missing it? Is the best way to do function queries just to build up > the URL in python and do a simple request? > > Regards, > Rory > > ___ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
[postgis-users] PG Feat Serv and OGC API
Afternoon all, I've got a PG Featureserv docker container running on a server and a couple of collections and functions published on it. The data that I'm querying is better suited for functions. It's mostly time series stuff and it's nice to give it a start/stop time and a couple other filter parameters. I'm looking at OWSlib to build a python client that consumes off the server but it doesn't seem like the "functions" are recognised in OGC; "myserver.org/collections/my_data" is easily called in OWSlib with: ``` from owslib.ogcapi.features import Features api = Features('http://myserver.org/') ``` but there doesn't seem to be a "myserver.org/functions/my_func" equivalent. Am I missing it? Is the best way to do function queries just to build up the URL in python and do a simple request? Regards, Rory ___ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users