<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hello,</div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">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="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></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Request with single TIME value that's working for me:</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><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></div>
<div class="elementToProof"><br>
</div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Request with two TIME values that isn't working for me and error message:</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><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="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></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">WCS server error. Temporal lists are not supported, only individual values.</span></div>
<div class="elementToProof"><br>
</div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Request with TIME range that also isn't working for me and error message:</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><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="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></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">WCS server error. Temporal ranges are not supported, only individual values.</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Postgis query from mapserver logs when request contains only one TIME value:</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">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></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">So, is there any possibility to use multiple TIME values in one GetCoverage request?</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Best regards,</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">Michał</span></div>
<div id="Signature">
<table style="margin-top: 30px; margin-bottom: 30px; width: 95%;">
<tbody>
<tr>
<td></td>
</tr>
<tr>
<td><span style="font-family: "Open Sans Bold", sans-serif; font-size: 17px; color: rgb(255, 130, 38);"><b>Michał Bojko</b></span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span><span style="font-family: "Open Sans", sans-serif; font-size: 13px; color: rgb(71, 71, 71);">Trainee</span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</span><span style="font-family: "Open Sans", sans-serif; font-size: 13px; color: rgb(71, 71, 71);">CloudFerro S.A.</span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</span></td>
</tr>
<tr>
<td><span style="font-family: "Open Sans", sans-serif; font-size: 12px; color: rgb(71, 71, 71);">office: Fabryczna 5</span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</span><span style="font-family: "Open Sans", sans-serif; font-size: 12px; color: rgb(71, 71, 71);">
<b>m:</b> </span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"></span><span style="font-family: "Open Sans", sans-serif; font-size: 12px; color: rgb(102, 102, 102);">502
705 120</span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span><span style="font-family: "Open Sans", sans-serif; font-size: 12px; color: rgb(102, 102, 102);">00-446 Warszawa, Poland</span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</span><span style="font-family: "Open Sans", sans-serif; font-size: 12px; color: rgb(0, 0, 0);"> <b>e:</b></span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</span><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(0, 125, 197);">mbojko@cloudferro.com</span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</span></td>
</tr>
<tr>
<td><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><a href="https://cloudferro.com/" id="OWA99fb685b-dc6c-76e5-a978-275bc69b26ae" class="OWAAutoLink"><img src="https://i.imgur.com/XRnmHDu.png"></a>
<map><area shape="rect" coords="602,96,621,117" href="https://twitter.com/CloudFerro" title="Twitter" alt="Twitter" target="_blank"><area shape="rect" coords="629,98,650,117" href="https://www.facebook.com/cloudferro/" title="Facebook" alt="Facebook" target="_blank"><area shape="rect" coords="658,98,678,117" href="https://www.linkedin.com/company/clfr/" title="Linkedin" alt="Linkedin" target="_blank"></map></span></td>
</tr>
</tbody>
</table>
<span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
</body>
</html>