<html>
<head>
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
my humble suggestion is inline.<br>
I have done WMS Time successfully for PostGIS.<br>
<br>
Den 14.10.2011 13:55, skrev Katharina Sambs:
<blockquote cite="mid:4E982344.6010001@BfS.de" type="cite">Hi list,
<br>
<br>
I would like to visualize spatial *mySQL* data through a wms-time
service.
<br>
*It is possible to visualize the data without the time
parameters.*
<br>
But as soon as I add the following parameters to the mapfile, my
result contains only a white picture:
<br>
LAYER
<br>
....
<br>
METADATA
<br>
....
<br>
WMS_TIMEEXTENT "2010-01-10T00:00:00Z"
<br>
WMS_TIMEITEM "column_name"
<br>
WMS_TIMEDEFAULT "2010-01-10T00:00:00Z"
<br>
<br>
There is no error message.
<br>
*The same request works fine, while I use a shapefile as data
source.*
<br>
<br>
My second question:
<br>
Shouldn't be there a 'where'-clause in the database selection,
which contain the time parameter?
<br>
</blockquote>
I don't think so,<br>
<br>
<blockquote cite="mid:4E982344.6010001@BfS.de" type="cite">Or works
the wms-time like a Filter, which always ask all data from the
database.
<br>
Only in the second step, the data is filtered for the desired
time?
<br>
<br>
</blockquote>
This filter should be added by Mapserver automagically when you have
WMS_TIME* in METADATA field.
<blockquote cite="mid:4E982344.6010001@BfS.de" type="cite">Did
anyone has an idea?
<br>
<br>
</blockquote>
You extent should maybe be more "wide". <br>
From <a class="moz-txt-link-freetext" href="http://mapserver.org/ogc/wms_time.html">http://mapserver.org/ogc/wms_time.html</a><br>
<em>value</em> - a single value. This is not directly supported in
MapServer but
there is an easy workwound by specifying the same value as min and
max.<br>
<br>
I have always used extents similar to the example in the docs:<br>
<pre><span class="s">"wms_timeextent"</span> <span class="s">"2004-01-01/2004-02-01"
</span></pre>
<span class="s"></span>If this is not helping, you should attach
(important parts of) mapfile and URL request.<br>
<span class="s"><br>
kind regards<br>
Jørn Vegard Røsnes<br>
</span><br>
<br>
<blockquote cite="mid:4E982344.6010001@BfS.de" type="cite">The type
of the time data in the mySQL database is "DATETIME".
<br>
<br>
mysql.log
<br>
111014 13:27:45 4 Connect user@server on database
<br>
4 Query DESCRIBE `table`
<br>
4 Query SELECT type, coord_dimension FROM geometry_columns
WHERE f_table_name='table'
<br>
4 Query SELECT srid FROM geometry_columns WHERE f_table_name
= 'table'
<br>
4 Query SELECT column1, column2 FROM table
<br>
4 Query SELECT type FROM geometry_columns WHERE
f_table_name='table'
<br>
4 Query SELECT srid FROM geometry_columns WHERE f_table_name
= 'table'
<br>
4 Query SELECT column1, column2 FROM table
<br>
4 Quit
<br>
<br>
mapserv.log:
<br>
[Fri Oct 7 16:05:42 2011].982953 CGI Request 1 on process 18953
<br>
[Fri Oct 7 16:05:42 2011].983461 msWMSLoadGetMapParams():
enabling non-square pixels.
<br>
[Fri Oct 7 16:05:42 2011].990638 msDrawMap(): kicking into
non-square pixel preserving mode.
<br>
[Fri Oct 7 16:05:42 2011].991160
msOGRFileOpen(MYSQL:tabelle,host=host,user=user,password=passwort,port=port)...<br>
[Fri Oct 7 16:05:42 2011].991205
OGROPen(MYSQL:tabelle,host=host,user=readonly,password=readonly,port=port)<br>
[Fri Oct 7 16:05:43 2011].20413
msConnPoolRegister(layer,MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)<br>
[Fri Oct 7 16:05:43 2011].67656
msOGRLayerClose(MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port).<br>
[Fri Oct 7 16:05:43 2011].67662
msOGRFileClose(MYSQL:tabelle,host=host,user=readonly,password=readonly,port=port,-1).<br>
[Fri Oct 7 16:05:43 2011].67672
msConnPoolRelease(layer,MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)<br>
[Fri Oct 7 16:05:43 2011].67675
msConnPoolClose(MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)<br>
[Fri Oct 7 16:05:43 2011].67849 msDrawMap(): Layer 2 (layer),
0.077s
<br>
[Fri Oct 7 16:05:43 2011].67867 msDrawMap(): Drawing Label Cache,
0.000s
<br>
[Fri Oct 7 16:05:43 2011].67871 msDrawMap() total time: 0.084s
<br>
[Fri Oct 7 16:05:43 2011].170031 msSaveImage() total time: 0.102s
<br>
[Fri Oct 7 16:05:43 2011].170228 mapserv request processing time
(msLoadMap not incl.): 0.187s
<br>
[Fri Oct 7 16:05:43 2011].170234 msFreeMap(): freeing map at
0x4f6cf30.
<br>
<br>
getCapabilities:
<br>
<Layer queryable="0" opaque="0" cascaded="0">
<br>
<Name>layer</Name>
<br>
<Title>title</Title>
<br>
<Abstract>abstract</Abstract>
<br>
<CRS>EPSG:4326</
<br>
<EX_GeographicBoundingBox>
<br>
<westBoundLongitude>5.18808</westBoundLongitude>
<br>
<eastBoundLongitude>15</eastBoundLongitude>
<br>
<southBoundLatitude>46.5582</southBoundLatitude>
<br>
<northBoundLatitude>55.8653</northBoundLatitude>
<br>
</EX_GeographicBoundingBox>
<br>
<BoundingBox CRS="EPSG:4326" minx="46.5582" miny="5.18808"
maxx="55.8653" maxy="15"/>
<br>
<Dimension name="time" units="ISO8601"
default="2010-01-10T00:00:00Z"
nearestValue="0">2010-01-10T00:00:00Z</Dimension>
<br>
</Layer>
<br>
<br>
<br>
mysql version: 5.5.10-log
<br>
MapServer version 5.6.5
<br>
<br>
<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
vennlig hilsen
Jørn-Vegard Røsnes</pre>
</body>
</html>