Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Posgresql returns in response all products in database, even if BBOX parameter is passed #7023

Open
bojas144 opened this issue Feb 13, 2024 · 0 comments

Comments

@bojas144
Copy link

bojas144 commented Feb 13, 2024

Expected behavior and actual behavior.

I've build WCS service with MapServer using Postgresql database (with PostGIS extension) and s3 bucket containing actual data. In mapfile I've created layer and tileindex with query to database. Tileindex should find products in database that corespond with BBOX in reuqest to MapServer and serve them to Layer. Unfortunatly, it seems that database is searching for far more items that don't match the spatial condtition - searched BBOX doesn't contain their geometry.With one request it takes more than 10 minutes for obtaining one coverage. I tried passing wcs_timedefault as product's date and passing TIME parameter in request, but it didn't help (actually, when providing TIME in reuqest I've got response that "Temporal lists are not supported, only individual values."). Is there any option to pass TIME parameter in request or solution for postgres to not search for all items, but just for one?

Steps to reproduce the problem.

http://localhost/cgi-bin/mapserv?map=/var/www/my_wcs.map&SERVICE=WCS&VERSION=1.0.0&REQUEST=GetCoverage&coverage=T36SVD&CRS=EPSG:3857&WIDTH=10980&HEIGHT=10980&FORMAT=GTiff&BBOX=1815829.0,5914796.0,1981802.0,6081258.0
This is my request to MapServer.

mapfile.txt
This is my MapServer code. In tileindex layer I use postgres query - it returns column cloudless_10 (as defined in Layer "T36SVD") from mrc table, based on geometry. Instead of one record, it returns hundreds.

mapserver_logs.txt
As you can see, postgres is searching for many products, that don't match searched product. The product I wanna get is in commented parameter DATA in Layer "T36SVD". As stated before, I tried passing wcs_timedefault with product's date, but it didn't work.

MapServer version and installation method

Ubuntu 22.04, MapServer version 7.6.4

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant