[mapserver-users] [EXTERNAL] Re: MapCache Time Dimensions Problem

[Michael Smith]

Stephan,

Yes, I've even used the value I have as the Default value which does fetch
things properly. 

I suppose it could be something in the specific branch I'm using. Its the
animation branch from RFC-111
(http://mapserver.org/development/rfc/ms-rfc-111.html) and
(https://github.com/jlarouche/mapcache/tree/animated-gif).

But I tried this also with master to test it non-animated and got the same
error.

Mike

-- 
Michael Smith

Remote Sensing/GIS Center
US Army Corps of Engineers



On 6/10/15,  8:28 AM, "Stephan Meißl" <stephan at meissl.name> wrote:

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Mike,
>
>strange, did you try a time interval or simply a "bigger" time e.g. a
>whole day like "TIME=2014-03-06"? Maybe you can narrow it down this way.
>
>cu
>Stephan
>
>
>On 06/10/2015 01:22 PM, Michael Smith wrote:
>> Stephan,
>> 
>> Yes I did run directly on the sqlite file and its got an absolute
>> path. I get all the responses back I think I should get
>> 
>> eg:
>> 
>> Select 
>> 
>>strftime('%Y-%m-%dT%H:%M:%SZ',start_time)||'/'||strftime('%Y-%m-%dT%H:%M:
>>%S
>>
>> 
>Z',end_time) from time where source_id='earthquakes';
>> 
>> .. 2014-03-03T23:41:21Z/2014-03-03T23:41:21Z
>> 2014-03-07T23:47:22Z/2014-03-07T23:47:22Z
>> 2014-03-07T00:53:09Z/2014-03-07T00:53:09Z
>> 2014-03-06T02:51:31Z/2014-03-06T02:51:31Z ...
>> 
>> 
>> and it all seems to work with default values. Its only when I try
>> to pass a TIME value on the URL that I get an error.
>> 
>> "GET 
>> 
>>/gridvm1mc/mapcache/?LAYERS=earthquakes&SERVICE=WMS&VERSION=1.1.1&REQUEST
>>=G
>>
>> 
>etMap&STYLES=&SRS=EPSG%3A3857&BBOX=-28119042.469324,-9960050.5336716,28119
>0
>> 42.469324,9960050.5336716&WIDTH=1437&HEIGHT=509 HTTP/1.1" 200
>> 34113 "GET 
>> 
>>/gridvm1mc/mapcache/?LAYERS=earthquakes&SERVICE=WMS&VERSION=1.1.1&REQUEST
>>=G
>>
>> 
>etMap&STYLES=&SRS=EPSG%3A3857&BBOX=-28119042.469324,-9960050.5336716,28119
>0
>> 
>>42.469324,9960050.5336716&WIDTH=1437&HEIGHT=509&TIME=2014-03-06T02:51:31Z
>>
>> 
>HTTP/1.1" 404 244
>> 
>> 
>> And the error is no matching entry for given TIME dimension "TIME"
>> in tileset "earthquakes"
>> 
>> ---- Michael Smith
>> 
>> US Army Corps Remote Sensing GIS/Center
>> michael.smith at usace.army.mil
>> 
>> 
>> 
>> 
>> 
>> -----Original Message----- From: Stephan Meißl
>> <stephan at meissl.name> Date: Tuesday, June 9, 2015 at 4:37 PM To:
>> "mapserver-users at lists.osgeo.org"
>> <mapserver-users at lists.osgeo.org> Subject: [EXTERNAL] Re:
>> [mapserver-users] MapCache Time Dimensions Problem Resent-From:
>> Michael Smith <michael.smith at usace.army.mil>
>> 
>> Hi Mike,
>> 
>> did you try running the query directly in sqlite substituting
>> :tileset, :start_timestamp, and :end_timestamp with actual values?
>> What schema does your sqlite database have? Is the path to the
>> dbfile absolute and readable?
>> 
>> I could send you a working example if you want. Let me know.
>> 
>> cu Stephan
>> 
>> 
>> On 06/07/2015 01:13 AM, Michael Smith wrote:
>>>>> I've created a timedimension tileset in MapCache and created
>>>>> the backend sqlite db that has the available times. The
>>>>> mapserver backend handles the WMS TIME requests without a
>>>>> problem.  And when I query mapcache without a &TIME=, I get
>>>>> my the default output.
>>>>> 
>>>>> However, if I specify a &TIME= parameter to MapCache (as a
>>>>> WMS or WMTS request), I get
>>>>> 
>>>>> no matching entry for given TIME dimension "TIME" in tileset
>>>>> "earthquakes"
>>>>> 
>>>>> I don't know what I need to change to get MapCache to
>>>>> recognize the TIME parameter. From the docs on RFC-96
>>>>> (http://mapserver.org/development/rfc/ms-rfc-96.html) I don't
>>>>> see what else to specify to set MapCache to understand TIME
>>>>> requests.
>>>>> 
>>>>> I can see MapCache making the backend requests to generate
>>>>> images from the time values in the sqlite DB but only with
>>>>> the default specified in the <timedimension>. It never
>>>>> understands new ranges passed with &TIME=.
>>>>> 
>>>>> My tileset looks like
>>>>> 
>>>>> <tileset name="earthquakes"> <source>earthquakes</source>
>>>>> <cache>sqlite</cache> <grid>GoogleMapsCompatible</grid>
>>>>> <format>PNG</format> <metatile>5 5</metatile>
>>>>> <metabuffer>10</metabuffer> <expires>3600</expires>
>>>>> <timedimension type="sqlite" default="2014-03-25T12Z" >
>>>>> <dbfile>/u02/mapcache/dbtime2.db</dbfile> <query>select
>>>>> 
>>>>> 
>>>>>strftime('%Y-%m-%dT%H:%M:%SZ',start)||'/'||strftime('%Y-%m-%dT%H:%M:%S
>>>>>Z',
>>>>>
>>>>> 
>end)
>>>>> from time where source_id=:tileset and
>>>>> start_time>=datetime(:start_timestamp,'unixepoch') and
>>>>> end_time<=datetime(:end_timestamp,'unixepoch') order by
>>>>> end_time </query> </timedimension> </tileset>
>
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1
>
>iQIcBAEBAgAGBQJVeC17AAoJEKNQXeNWi+qtuwQQAJUF2EFcQw1m7f6OjY4Nkx+e
>wy7HrtNdL0NjvFKgzXMRA88o19E4snr+KhelYLicDJY2vp26Dk5ctuuZRfEig+HK
>ZUyklvSyfuG7VZPs3/7VYMcHgF+DfkbqZohhDsLXN1ZobEAl1PlxdrZulexTbmG+
>O2p81d9p7qBFLgYDPT6WxW43lkLpuPIR1JYc2iT9CeBVvJ33QRF05taVVBkj+5ze
>mwJQdRBAT3GcK/cJSgVN1pxvUBkq4C40p84EulAERX7XTkQWnClSFSJBuyON+B3q
>KFnCWFxDip7zly2uwYyvJMJdkwLvJbp5UhJ/uYlDd82EODd+D4m1l//wAKsu5ZDZ
>f+olnKtkiMHUc2s7OwjwYYTIvYSvA9bwIHDgmAMVCyQLZEk/Wr5Jbgi8sLxid45s
>/A9j64nPSj/Ar9Kw9AbX+vyupT2iTiQyigKiA+OBhejX52d+rj6y4mEIS757NLTg
>hnBrbry1LoWQjr7/XAmdGahusCF/wp6mmb0YoWFoQI+cuFJ39iIPvWXScIvUkLG9
>Qj6iw4wj8WwZ2Fe2V4QbqPs5/kPY+iriZ3hTISaqdlNCP3ZWR4OSd/DcIIf68OEE
>WpTq4NxDR3NKFn5RKiekPixpppUcDtU7GnwYNPwNDVkhiVLEf6tmD32bBeXSrTG6
>8QZlOVjwUHAMAmxToXXP
>=uGbf
>-----END PGP SIGNATURE-----