You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
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
The text was updated successfully, but these errors were encountered:
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
The text was updated successfully, but these errors were encountered: