[mapserver-users] MapCache Time Dimension

[coastalrocket]

Hi Stephen

Thanks for taking a look. Here's the entire mapcache.xml below. As i say,
without the dimensions element mapcache is happy to cache the WMS.

<?xml version="1.0" encoding="UTF-8"?>
<mapcache>
	<metadata>
		<title>MapCache for Random Crime WMS-T</title>
		<abstract></abstract>
	</metadata>

	<cache name="time_disk_cache" type="disk">
		
		
		<base>E:/ms4w/tmp/ms_tmp/cache/</base>
	</cache>	

	<cache name="time_sqlite_cache" type="sqlite3">
	   <dbfile>E:/ms4w/tmp/ms_tmp/cache/{tileset}-{dim}.db</dbfile>
	   <detect_blank />
	</cache>
	
   <cache name="disk" type="disk">
      <base>E:/ms4w/tmp/ms_tmp/cache</base>
      
   </cache>
   
   <cache name="berkeley" type="bdb">
      <base>E:/ms4w/tmp/ms_tmp/cache</base>
      
   </cache>  
   
   <cache name="tiff" type="tiff">
     
<template>E:/ms4w/tmp/ms_tmp/cache/{tileset}/{grid}/L{z}/R{inv_y}/C{x}.tif</template>
      <xcount>64</xcount>
     <ycount>64</ycount>
     
   </cache> 
   
   <cache name="sqlitetemplate" type="sqlite3">
      <dbfile>E:/ms4w/tmp/ms_tmp/cache/sqlitefile.db</dbfile>
      <pragma name="max_page_count">10000000</pragma>
   </cache> 	

	<source name="random_crime_wms" type="wms">
		<getmap>
			<params>
				<FORMAT>image/png</FORMAT>
				<LAYERS>random_crime</LAYERS>
				<TRANSPARENT>true</TRANSPARENT>
				
			</params>
		</getmap>
		<http>
		
<url>http://localhost:8080/cgi-bin/mapserv.exe?map=e:\\isharedata\\live\\_mapserverConfig\\mapcache.map</url>
		</http>
	</source>
   
	<tileset name="random_crime">
		<source>random_crime_wms</source>	
		<dimensions>
			<assembly_type>stack</assembly_type>
			<store_assemblies>true</store_assemblies>
			<subdimensions_read_only>false</subdimensions_read_only>		
			<dimension name="time" default="2011" type="time">
				<dbfile>E:\\ms4w\\tmp\\random_crime.db</dbfile>
				<query>
					SELECT strftime("%Y-%m-%dT%H:%M:%SZ",the_date) FROM random_crime_time
WHERE the_date >= datetime(:start_timestamp,"unixepoch") AND the_date
<= datetime(:end_timestamp,"unixepoch")  ORDER BY the_date DESC;
				</query>
			</dimension>
		</dimensions>
		<cache>time_disk_cache</cache>
		<format>png_best</format>
		<grid>bng_grid</grid>
		<metatile>5 5</metatile>
		<metabuffer>10</metabuffer>
		<expires>3600</expires>		
	</tileset>	
	
	<grid name="bng_grid">
		<metadata>
			<title>this is a grid suitable for BNG mapping</title>
		</metadata>
		<srs>EPSG:27700</srs>
		<srsalias>BNG</srsalias>
		<size>256 256</size>
		
		<extent>1 1 700000 1300000</extent>
		<units>m</units>
		<resolutions>204094.5984 107716.59359999998 70866.18000000001
47243.952699999994 22677.1776 15000.235999999999 10000.970800000001 6000.309
3000.9148399999995 1417.3236 708.6618 354.3309 200 72 38 25 16.6666076469763
8 5.29174706467881 3.52811834926054 2.11677453194175 1.05865549688159 0.5
0.25 0.125</resolutions>
	</grid>  

	<default_format>JPEG</default_format>
	
	<format name="png_best" type ="PNG">
		<compression>best</compression>	
	</format>
	
	<service type="wms" enabled="true"/>
	<service type="wms" enabled="true"/>

	<errors>report</errors> 
   
   


	<lock_dir>E:/ms4w/tmp/ms_tmp/cache</lock_dir>
  
	
	<threaded_fetching>true</threaded_fetching>
      
	
	<log_level>info</log_level> 
	<auto_reload>true</auto_reload> 

</mapcache>




--
Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html