[mapserver-users] WMS-TIME with mysql-database

[Jørn-Vegard Røsnes]

Hi,

my humble suggestion is inline.
I have done WMS Time successfully for PostGIS.

Den 14.10.2011 13:55, skrev Katharina Sambs:
> Hi list,
>
> I would like to visualize spatial *mySQL* data through a wms-time 
> service.
> *It is possible to visualize the data without the time parameters.*
> But as soon as I add the following parameters to the mapfile, my 
> result contains only a white picture:
> LAYER
> ....
>    METADATA
>    ....
>        WMS_TIMEEXTENT   "2010-01-10T00:00:00Z"
>        WMS_TIMEITEM   "column_name"
>        WMS_TIMEDEFAULT   "2010-01-10T00:00:00Z"
>
> There is no error message.
> *The same request works fine, while I use a shapefile as data source.*
>
> My second question:
> Shouldn't be there a 'where'-clause in the database selection, which 
> contain the time parameter?
I don't think so,

> Or works the wms-time like a Filter, which always ask all data from 
> the database.
> Only in the second step, the data is filtered for the desired time?
>
This filter should be added by Mapserver automagically when you have 
WMS_TIME* in METADATA field.
> Did anyone has an idea?
>
You extent should maybe be more "wide".
 From http://mapserver.org/ogc/wms_time.html
/value/ - 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.

I have always used extents similar to the example in the docs:

"wms_timeextent"  "2004-01-01/2004-02-01"


If this is not helping, you should attach (important parts of) mapfile 
and URL request.

kind regards
Jørn Vegard Røsnes


> The type of the time data in the mySQL database is "DATETIME".
>
> mysql.log
> 111014 13:27:45     4 Connect  user at server on database
>      4 Query DESCRIBE `table`
>      4 Query SELECT type, coord_dimension FROM geometry_columns WHERE 
> f_table_name='table'
>      4 Query SELECT srid FROM geometry_columns WHERE f_table_name = 
> 'table'
>      4 Query SELECT column1, column2 FROM table
>      4 Query SELECT type FROM geometry_columns WHERE f_table_name='table'
>      4 Query SELECT srid FROM geometry_columns WHERE f_table_name = 
> 'table'
>      4 Query SELECT column1, column2 FROM table
>      4 Quit
>
> mapserv.log:
> [Fri Oct  7 16:05:42 2011].982953 CGI Request 1 on process 18953
> [Fri Oct  7 16:05:42 2011].983461 msWMSLoadGetMapParams(): enabling 
> non-square pixels.
> [Fri Oct  7 16:05:42 2011].990638 msDrawMap(): kicking into non-square 
> pixel preserving mode.
> [Fri Oct  7 16:05:42 2011].991160 
> msOGRFileOpen(MYSQL:tabelle,host=host,user=user,password=passwort,port=port)...
> [Fri Oct  7 16:05:42 2011].991205 
> OGROPen(MYSQL:tabelle,host=host,user=readonly,password=readonly,port=port)
> [Fri Oct  7 16:05:43 2011].20413 
> msConnPoolRegister(layer,MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)
> [Fri Oct  7 16:05:43 2011].67656 
> msOGRLayerClose(MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port).
> [Fri Oct  7 16:05:43 2011].67662 
> msOGRFileClose(MYSQL:tabelle,host=host,user=readonly,password=readonly,port=port,-1).
> [Fri Oct  7 16:05:43 2011].67672 
> msConnPoolRelease(layer,MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)
> [Fri Oct  7 16:05:43 2011].67675 
> msConnPoolClose(MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)
> [Fri Oct  7 16:05:43 2011].67849 msDrawMap(): Layer 2 (layer), 0.077s
> [Fri Oct  7 16:05:43 2011].67867 msDrawMap(): Drawing Label Cache, 0.000s
> [Fri Oct  7 16:05:43 2011].67871 msDrawMap() total time: 0.084s
> [Fri Oct  7 16:05:43 2011].170031 msSaveImage() total time: 0.102s
> [Fri Oct  7 16:05:43 2011].170228 mapserv request processing time 
> (msLoadMap not incl.): 0.187s
> [Fri Oct  7 16:05:43 2011].170234 msFreeMap(): freeing map at 0x4f6cf30.
>
> getCapabilities:
> <Layer queryable="0" opaque="0" cascaded="0">
> <Name>layer</Name>
> <Title>title</Title>
> <Abstract>abstract</Abstract>
> <CRS>EPSG:4326</
> <EX_GeographicBoundingBox>
> <westBoundLongitude>5.18808</westBoundLongitude>
> <eastBoundLongitude>15</eastBoundLongitude>
> <southBoundLatitude>46.5582</southBoundLatitude>
> <northBoundLatitude>55.8653</northBoundLatitude>
> </EX_GeographicBoundingBox>
> <BoundingBox CRS="EPSG:4326" minx="46.5582" miny="5.18808" 
> maxx="55.8653" maxy="15"/>
> <Dimension name="time" units="ISO8601" default="2010-01-10T00:00:00Z" 
> nearestValue="0">2010-01-10T00:00:00Z</Dimension>
> </Layer>
>
>
> mysql version: 5.5.10-log
> MapServer version 5.6.5
>
>


-- 
vennlig hilsen
Jørn-Vegard Røsnes

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111014/b671539a/attachment.html