Good morning,
thank you, for your answer!
I set up a wms-time service with a PostGIS database, too.
It works fine, as well as the shapefile service.
Only with the mySQL database I get a *white* result.
Does anyone know if there is a general problem with wms-time and spatial mySQL
data?
Unfortunately, the wider extent doesn´t help.
My request:
http:...&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=46.556819,5.188080,55.865300,15.000000&CRS=EPSG:4326&WIDTH=1017&HEIGHT=963&
LAYERS=layer&STYLES=&FORMAT=image/png&DPI=96&TRANSPARENT=TRUE
My mapfile:
MAP
NAME "name"
STATUS ON
EXTENT -180 -90 180 90
UNITS METERS
INCLUDE "debug.map"
SYMBOLSET "symbols.sym"
FONTSET "fonts.list"
INCLUDE "encryption.map"
INCLUDE "projection_4326.map"
WEB
INCLUDE "image_parameter.map"
METADATA
OWS_ENABLE_REQUEST "*"
WMS_ONLINERESOURCE "..."
WMS_TITLE "..."
WMS_FEATURE_INFO_MIME_TYPE "text/html"
WMS_ABSTRACT "..."
INCLUDE "standard_extent_europa.map"
INCLUDE "standard_proj.map"
#INCLUDE "standard_metadata.map"
END
END
INCLUDE "outputformat_agg.map"
INCLUDE "legend.map"
LAYER
NAME "layer"
TYPE POINT
STATUS ON
INCLUDE "debug_layer.map" #2 Zeilen
DUMP TRUE
TOLERANCE 3
PROCESSING "CLOSE_CONNECTION=DEFER"
CONNECTIONTYPE OGR
CONNECTION
"MYSQL:test,host=host,user=user,password=passwort,port=port,tables=tabelle"
DATA "SELECT column1, column2 FROM tabelle"
CLASS
STYLE
OUTLINECOLOR 100 100 100
END
END
METADATA
WMS_TITLE "title"
WMS_TIMEEXTENT "2011-10-13T00:00:00Z/2011-10-14T00:00:00Z"
WMS_TIMEITEM "column1"
WMS_TIMEDEFAULT "2011-10-13T00:00:00Z"
WMS_ABSTRACT "..."
INCLUDE "standard_extent.map"
LAYER_TITLE "..."
LAYER_DESC_STATUS "on"
LAYER_DESC "..."
gml_include_items "all"
END
END #LAYER
END #MAP
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@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
>
>
--
Mit freundlichen Grüßen
Katharina Sambs
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
