[mapserver-users] Re: Re: WMS-TIME with mysql-database
Stephan Holl
stephan.holl at intevation.de
Mon Oct 17 03:24:37 PDT 2011
Hello Katharina,
Katharina Sambs <KSambs at BfS.de>, [20111017 - 11:03:58]
> 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?
I would guess it has something in common with the (somewhat limited)
MySQL-support of OGR. I had problems with the MySQL-driver of OGR too
so I decided skipping it. I would digg into that area for further
investigation, enabling OGRs DEBUG-output etc...).
Best
Stephan Holl
>
> 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 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
> > >
> > >
> >
--
Stephan Holl <stephan.holl at intevation.de> | Tel.: +49 (0)541-33 508 3663
Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998
Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111017/52506a32/attachment.sig>
More information about the MapServer-users
mailing list