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" <[email protected]> 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 >> [email protected] >> >> >> >> >> >> -----Original Message----- From: Stephan Meißl >> <[email protected]> Date: Tuesday, June 9, 2015 at 4:37 PM To: >> "[email protected]" >> <[email protected]> Subject: [EXTERNAL] Re: >> [mapserver-users] MapCache Time Dimensions Problem Resent-From: >> Michael Smith <[email protected]> >> >> 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----- _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
