<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Dear Till<br>
<br>
I'm trying to publish real time steam data computed on a permanent
network of GPS stations and stored on a PostGIS DataBase.<br>
This network have 300 stations and i want to publish individual
observation as a procedure result.<br>
<br>
As i have informed this morning to the list, i have gotten to
start the service and made that the response to GetObservarion
request offer the O&M result.<br>
<br>
To enable the service use in the same postgis data table to handle
several columns (observed variables) i have used
sos_procedure_item as set assefa
(<a class="moz-txt-link-freetext" href="http://trac.osgeo.org/mapserver/ticket/2050">http://trac.osgeo.org/mapserver/ticket/2050</a>)<br>
<br>
Then to solve problem to access postgis data filtering to one of
the gps station, i have put:<br>
DATA "pos from (select pos,fecha,vap from vaporcolumna where
id='MADR13407S012') as subquery using unique fecha using
srid=4326"<br>
<br>
In order to enable time filtering to procedure values, i have put:<br>
"sos_timeitem" "fecha"
<br>
<br>
Then mu questions now are:<br>
<br>
1º.- <span class="webkit-html-tag">when i tryed to do request
getObservation using parameter <i>&procedure=urn:ogc:def:procedure</i></span>:XXX
SOS don't recognize any procedure. <br>
How can i do to enable a procedure name in mafile
configuration?<br>
<br>
2º.- when i tryed to do a request getObservation using
&eventtime=2014-01-01T00:00:00+01/2014-01-31T00:00:00+01 SOS
don't recognize this timestamp format <br>
How must be set the time period to eventTime paramenter?<br>
<br>
Regards,<br>
<br>
Miguel A<br>
<br>
<br>
El 16/06/2014 14:09, Till Adams escribió:<br>
</div>
<blockquote cite="mid:539EDE85.5000700@terrestris.de" type="cite">Dear
Miguel,
<br>
<br>
it is not clear, where exactly your problem is as you do not tell
the list, what is going wrong.
<br>
<br>
Did you check the sos-howto documentation-site:
<a class="moz-txt-link-freetext" href="http://mapserver.org/ogc/sos_server.html">http://mapserver.org/ogc/sos_server.html</a> ?
<br>
<br>
There are some more definitnions in the mapfile header required.
<br>
<br>
Another problem - are you sure, that your DATA-request really
delivers some data? For the first step it's always clever to
ensure, that the surrounding really works, so you can focus on the
main problem, which is configuring the sos-layer.
<br>
<br>
Regards, Till
<br>
<br>
<br>
<br>
Am 15.06.2014 20:16, schrieb Miguel-Angel Manso-Callejo (UPM):
<br>
<blockquote type="cite">Dear all,
<br>
<br>
I'm trying to config mapserver to offer through SOS data stored
in two
<br>
tables joined by a view.
<br>
<br>
I'm trying to offer in the first step only one time serial data
and i'm
<br>
using this configuration:
<br>
<br>
LAYER
<br>
NAME "test_sos_layer"
<br>
METADATA
<br>
"sos_procedure" "vaporcolumna" ## REQUIRED
<br>
"sos_procedure_item" "vap"
<br>
"sos_offering_id" "MADR13407S012" ## REQUIRED
<br>
"sos_timeitem" "fecha"
<br>
"sos_observedproperty_id" "vap"
<br>
"sos_observedproperty_name" "Vapor_agua_columna"
<br>
"sos_offering_timeextent" "2010/2014"
<br>
"sos_describesensor_url"
<br>
<a class="moz-txt-link-rfc2396E" href="http://138.100.61.23:90/sensorml/MADR13407S012.xml">"http://138.100.61.23:90/sensorml/MADR13407S012.xml"</a> ## REQUIRED
<br>
"sos_offering_name" "GPS Station in Madrid 13407S012"
<br>
END
<br>
TYPE POINT
<br>
STATUS ON
<br>
CONNECTIONTYPE POSTGIS
<br>
CONNECTION "host=127.0.0.1 port=5432
dbname=example_postgis21
<br>
user=postgres password=postgres"
<br>
DATA "pos, vap from vaporcolumna where id='MADR13407S012' "
<br>
<br>
PROJECTION
<br>
"init=epsg:4326"
<br>
END
<br>
<br>
CLASS
<br>
NAME "vap"
<br>
STYLE
<br>
COLOR 255 0 0
<br>
SYMBOL "circle"
<br>
SIZE 8
<br>
END
<br>
END
<br>
END
<br>
<br>
<br>
View have this fields:
<br>
Id (pk), pos (geometry), vap (double), fecha (date)
<br>
<br>
Can any one help me informing what i'm doing bad or how must i
config in
<br>
order to do it?
<br>
<br>
Regards,
<br>
Miguel A.
<br>
_______________________________________________
<br>
mapserver-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
<br>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>