<!DOCTYPE html><html><head><title></title><style type="text/css">
p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi Michał,<br></div><div><br></div><div>Looking at the code, I think this is an error in the documentation - time ranges in WCS 1.0 do not seem to be supported. There are no tests that cover time ranges either. <br></div><div><br></div><div>You could use runtime substitution to create your own queries with custom parameters e.g. START_DATE=2022-03-10&END_DATE=2022-04-10 <br></div><div><br></div><div>The section at <a href="https://mapserver.org/ogc/wcs_server.html#spatio-temporal-indexes">https://mapserver.org/ogc/wcs_server.html#spatio-temporal-indexes</a> recommends using a TILEINDEX for the layer. <br></div><div><br></div><div>Seth<br></div><div><br></div><div id="sig62266145"><div class="signature">--<br></div><div class="signature">web:<a href="https://geographika.net">https://geographika.net</a> & <a href="https://mapserverstudio.net">https://mapserverstudio.net</a><br></div><div class="signature">twitter: @geographika<br></div></div><div><br></div><div>On Fri, Feb 16, 2024, at 4:31 PM, Michał Bojko via MapServer-users wrote:<br></div><blockquote type="cite" id="qt" style=""><div class="qt-elementToProof" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);">Hello,<br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">I am trying to build WCS service with usage of postgis database, but now I am unable to
pass timerange in request to server. In my postgis database I have specified column for geometry and timestamp and request that use BBOX and TIME (single value) work fine. The problem is I cannot pass multiple dates or date range. When providing TIME in such
manner, I receive this error message: "WCS server error. Temporal ranges are not supported, only individual values". In official documentation it is stated that it's possible to pass at least two TIME parameters at once in version 1.0.0, but it doesn't work
for me (<a href="https://mapserver.org/pl/ogc/wcs_server.html#test-with-a-getcoverage-request" id="qt-LPlnk183589">https://mapserver.org/pl/ogc/wcs_server.html#test-with-a-getcoverage-request</a>). Is there specified way to pass timeranges/timelist (I didn't
find any information about it)? Or maybe it isn't possible to pass multiple values? But when I look into mapserver logs I see that postgis query searches for records that are between selected one day, so why wouldn't it be possible to pass two days and search for
records between them? Below I will paste some request and queries:</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">Request with single TIME value that's working for me:</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"><a href="http://localhost/cgi-bin/mapserv?map=/var/www/my_wcs.map&SERVICE=WCS&VERSION=1.0.0&REQUEST=GetCoverage&coverage=T36SVD&CRS=EPSG:3857&RESX=10&RESY=10&FORMAT=GTiff&BBOX=3572705,6277219,3637743,6334339&TIME=2022-03-10/2022-03-15">http://localhost/cgi-bin/mapserv?map=/var/www/my_wcs.map&SERVICE=WCS&VERSION=1.0.0&REQUEST=GetCoverage&coverage=T36SVD&CRS=EPSG:3857&RESX=10&RESY=10&FORMAT=GTiff&BBOX=3572705,6277219,3637743,6334339&TIME=2022-03-10</a></span></span></span><br></div><div class="qt-elementToProof"><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">Request with two TIME values that isn't working for me and error message:</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"><a href="http://localhost/cgi-bin/mapserv?map=/var/www/my_wcs.map&SERVICE=WCS&VERSION=1.0.0&REQUEST=GetCoverage&coverage=T36SVD&CRS=EPSG:3857&RESX=10&RESY=10&FORMAT=GTiff&BBOX=3572705,6277219,3637743,6334339&TIME=2022-03-10,2022-03-15" id="qt-LPlnk277815">http://localhost/cgi-bin/mapserv?map=/var/www/my_wcs.map&SERVICE=WCS&VERSION=1.0.0&REQUEST=GetCoverage&coverage=T36SVD&CRS=EPSG:3857&RESX=10&RESY=10&FORMAT=GTiff&BBOX=3572705,6277219,3637743,6334339&TIME=2022-03-10,2022-03-15</a></span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">WCS server error. Temporal lists are not supported, only individual values.</span></span></span><br></div><div class="qt-elementToProof"><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">Request with TIME range that also isn't working for me and error message:</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"><a href="http://localhost/cgi-bin/mapserv?map=/var/www/my_wcs.map&SERVICE=WCS&VERSION=1.0.0&REQUEST=GetCoverage&coverage=T36SVD&CRS=EPSG:3857&RESX=10&RESY=10&FORMAT=GTiff&BBOX=3572705,6277219,3637743,6334339&TIME=2022-03-10/2022-03-15" id="qt-LPlnk425389">http://localhost/cgi-bin/mapserv?map=/var/www/my_wcs.map&SERVICE=WCS&VERSION=1.0.0&REQUEST=GetCoverage&coverage=T36SVD&CRS=EPSG:3857&RESX=10&RESY=10&FORMAT=GTiff&BBOX=3572705,6277219,3637743,6334339&TIME=2022-03-10/2022-03-15</a></span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">WCS server error. Temporal ranges are not supported, only individual values.</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"></span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">Postgis query from mapserver logs when request contains only one TIME value:</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">select "timestamp"::text,"cloudless_10"::text,"epsg"::text,ST_AsBinary(("geometry"),'NDR')
as geom,"unique_id"::text from (select * from mrc where maxcc <= 100 AND (pid = '-1' OR '-1' = '-1') AND (tile = '-1' OR '-1' = '-1') order by maxcc desc) as subquerry where ST_Intersects("geometry", ST_GeomFromText('POLYGON((3572710 6277224,3572710 6334334,3637738
6334334,3637738 6277224,3572710 6277224))',3857)) and ("timestamp" between date_trunc('day',date '2022-03-10') and date_trunc('day',date '2022-03-10') + interval '1 day' - interval '1 second')</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"></span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">So, is there any possibility to use multiple TIME values in one GetCoverage request?</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">Best regards,</span></span></span><br></div><div class="qt-elementToProof"><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;">Michał</span></span></span><br></div><div id="qt-Signature"><table style="margin-top:30px;margin-bottom:30px;width:95%;"><tbody><tr><td><br></td></tr><tr><td><span style="color:rgb(255, 130, 38);"><span class="font" style="font-family:"Open Sans Bold", sans-serif;"><span class="size" style="font-size:17px;"><b>Michał Bojko</b></span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"><br> </span></span></span><span style="color:rgb(71, 71, 71);"><span class="font" style="font-family:"Open Sans", sans-serif;"><span class="size" style="font-size:13px;">Trainee</span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"> <br> </span></span></span><span style="color:rgb(71, 71, 71);"><span class="font" style="font-family:"Open Sans", sans-serif;"><span class="size" style="font-size:13px;">CloudFerro S.A.</span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"></span></span></span></td></tr><tr><td><span style="color:rgb(71, 71, 71);"><span class="font" style="font-family:"Open Sans", sans-serif;"><span class="size" style="font-size:12px;">office: Fabryczna 5</span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"> </span></span></span><span style="color:rgb(71, 71, 71);"><span class="font" style="font-family:"Open Sans", sans-serif;"><span class="size" style="font-size:12px;"> <b>m:</b> </span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"></span></span></span><span style="color:rgb(102, 102, 102);"><span class="font" style="font-family:"Open Sans", sans-serif;"><span class="size" style="font-size:12px;">502
705 120</span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"><br> </span></span></span><span style="color:rgb(102, 102, 102);"><span class="font" style="font-family:"Open Sans", sans-serif;"><span class="size" style="font-size:12px;">00-446 Warszawa, Poland</span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"> </span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:"Open Sans", sans-serif;"><span class="size" style="font-size:12px;"> <b>e:</b></span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"> </span></span></span><span style="color:rgb(0, 125, 197);"><span class="font" style="font-family:Arial, Helvetica, sans-serif;"><span class="size" style="font-size:12px;">mbojko@cloudferro.com</span></span></span><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"></span></span></span></td></tr><tr><td><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"><div><a href="https://cloudferro.com/" id="qt-OWA99fb685b-dc6c-76e5-a978-275bc69b26ae" class="qt-OWAAutoLink"><img src="https://i.imgur.com/XRnmHDu.png"></a><br></div></span></span></span></td></tr></tbody></table><div><span style="color:rgb(0, 0, 0);"><span class="font" style="font-family:Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif;"><span class="size" style="font-size:12pt;"></span></span></span><br></div></div><div>_______________________________________________<br></div><div>MapServer-users mailing list<br></div><div><a href="mailto:MapServer-users@lists.osgeo.org">MapServer-users@lists.osgeo.org</a><br></div><div><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div><div><br></div></blockquote><div><br></div></body></html>