Hi,<br><br>Right now, I need to do some testing on the SQL commands, to be sure that all possibilities are coded.&nbsp; I'll keep you in the loop.<br><br>Denis<br><br><div><span class="gmail_quote">2006/10/6, Steve Lime &lt;<a href="mailto:Steve.Lime@dnr.state.mn.us">
Steve.Lime@dnr.state.mn.us</a>&gt;:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">We need to get WCS time support and WMS time support in sync. Please
<br>include me on the bug...<br><br>Steve<br><br>&gt;&gt;&gt; Yewondwossen Assefa &lt;<a href="mailto:assefa@DMSOLUTIONS.CA">assefa@DMSOLUTIONS.CA</a>&gt; 10/04/06 2:54 PM &gt;&gt;&gt;<br>Denis,<br><br>&nbsp;&nbsp;Sorry for the delay.
<br><br>&nbsp;&nbsp;Please enter a bug (WMS Server module) and code contribution and I<br>will integrate it in mapserver.<br><br>Thanks.<br><br>Denis Nadeau wrote:<br>&gt; Hi,<br>&gt;<br>&gt; I would like to change some of the&nbsp;&nbsp;code in 
mappostgis.c to reflect C<br>&gt; 5.2 Nearest Value instructions found in&nbsp;&nbsp;WMS 1.1.1 specifications for<br>&gt; &quot;TIME&quot; parameter.<br>&gt;<br><a href="http://portal.opengeospatial.org/files/?artifact_id=1081&amp;version=1&amp;format=pdf">
http://portal.opengeospatial.org/files/?artifact_id=1081&amp;version=1&amp;format=pdf</a><br><br>&gt;<br>&lt;<a href="http://portal.opengeospatial.org/files/?artifact_id=1081&amp;version=1&amp;format=pdf">http://portal.opengeospatial.org/files/?artifact_id=1081&amp;version=1&amp;format=pdf
</a>&gt;<br>&gt;<br>&gt; Here what it says in the WMS 1.1.1 doc.<br>&gt;<br>&gt; &quot;If a request does includes an imprecise dimensional value, and<br>nearest<br>&gt; value behavior has been declared, then the server shall compute and
<br>send<br>&gt; the nearest available value. The value shall be rounded, not merely<br>&gt; truncated.&quot;<br>&gt;<br>&gt; Right now, mapserver is using date_trunc function to allow the user to<br><br>&gt; specify months, days, hours or minutes.&nbsp;&nbsp;I think this could be
<br>enhanced<br>&gt; to get the nearest time value in Postgres.&nbsp;&nbsp;For example,&nbsp;&nbsp;NASA GES has<br>3<br>&gt; hourly data.&nbsp;&nbsp;If the user&nbsp;&nbsp;specify 2006-09-28T02:00&nbsp;&nbsp;a blank image is<br>&gt; return, the user needs to be exact 2006-09-28T03:00.&nbsp;&nbsp;Same thing with
<br>&gt; 10-day data,&nbsp;&nbsp;2006-09-03 will&nbsp;&nbsp;return a&nbsp;&nbsp;blank image.&nbsp;&nbsp;User have to<br>hit<br>&gt; the right date 2006-08-10, 2006-08-20, 2006-08-31, 2006-09-10,....<br>&gt;<br>&gt; Example<br>&gt; Tropical Rain data 3B42_V6_10_DAY:
<br>&gt;<br><a href="http://g0hep12u.ecs.nasa.gov/mapserv-bin/wms_ogc?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=Getmap&amp;layers=bluemarble,TRMM_3B42_V6_10_DAY&amp;BBOX=-180,-50,180,50&amp;TIME=2005-08-20">http://g0hep12u.ecs.nasa.gov/mapserv-bin/wms_ogc?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=Getmap&amp;layers=bluemarble,TRMM_3B42_V6_10_DAY&amp;BBOX=-180,-50,180,50&amp;TIME=2005-08-20
</a><br><br>&gt;<br>&lt;<a href="http://g0hep12u.ecs.nasa.gov/mapserv-bin/wms_ogc?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=Getmap&amp;layers=bluemarble,TRMM_3B42_V6_10_DAY&amp;BBOX=-180,-50,180,50&amp;TIME=2005-08-20">http://g0hep12u.ecs.nasa.gov/mapserv-bin/wms_ogc?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=Getmap&amp;layers=bluemarble,TRMM_3B42_V6_10_DAY&amp;BBOX=-180,-50,180,50&amp;TIME=2005-08-20
</a>&gt;<br>&gt;<br>&gt; blank image<br>&gt;<br><a href="http://g0hep12u.ecs.nasa.gov/mapserv-bin/wms_ogc?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=Getmap&amp;layers=bluemarble,TRMM_3B42_V6_10_DAY&amp;BBOX=-180,-50,180,50&amp;TIME=2005-08-20T04:00">
http://g0hep12u.ecs.nasa.gov/mapserv-bin/wms_ogc?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=Getmap&amp;layers=bluemarble,TRMM_3B42_V6_10_DAY&amp;BBOX=-180,-50,180,50&amp;TIME=2005-08-20T04:00</a><br><br>&gt;<br>&lt;<a href="http://g0hep12u.ecs.nasa.gov/mapserv-bin/wms_ogc?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=Getmap&amp;layers=bluemarble,TRMM_3B42_V6_10_DAY&amp;BBOX=-180,-50,180,50&amp;TIME=2005-08-20T04:00">
http://g0hep12u.ecs.nasa.gov/mapserv-bin/wms_ogc?SERVICE=WMS&amp;VERSION=1.1.1&amp;REQUEST=Getmap&amp;layers=bluemarble,TRMM_3B42_V6_10_DAY&amp;BBOX=-180,-50,180,50&amp;TIME=2005-08-20T04:00</a>&gt;<br>&gt;<br>&gt;<br>&gt; Let me know if this make sense to you.&nbsp;&nbsp;I would be happy to contribute
<br><br>&gt; some coding for this.<br>&gt;<br>&gt;<br>&gt; Denis<br>&gt;<br>&gt;<br><br><br>--<br>----------------------------------------------------------------<br>Assefa Yewondwossen<br>Software Analyst<br><br>Email: <a href="mailto:assefa@dmsolutions.ca">
assefa@dmsolutions.ca</a><br><a href="http://www.dmsolutions.ca/">http://www.dmsolutions.ca/</a><br><br>Phone: (613) 565-5056 (ext 14)<br>Fax:&nbsp;&nbsp; (613) 565-0925<br>----------------------------------------------------------------
<br></blockquote></div><br>