<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Thank you Stephen<br>
<br>
At this moment i can send a GetObservation Request and get response
in O&M format but i can't understand why sos mapserv don't
recognize any procedure name or eventTime format.<br>
<br>
First: In order to do it i must change DATA sql to:<br>
<br>
DATA "pos from (select pos,fecha,vap from vaporcolumna where
id='MADR13407S012') as subquery using unique fecha using srid=4326"<br>
<br>
Then, when i request data GetObservation the answer is like:<br>
<br>
<div class="collapsible" id="collapsible2" style="color: rgb(0, 0,
0); font-family: monospace; font-size: 13px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: normal; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<div class="expanded">
<div class="line"><span class="webkit-html-tag"><om:member></span></div>
<div class="collapsible-content" style="margin-left: 1em;"><span
class="text"></span>
<div class="collapsible" id="collapsible3">
<div class="expanded">
<div class="line"><span class="button collapse-button"
style="-webkit-user-select: none; cursor: pointer;
display: inline-block; margin-left: -10px; width:
10px; vertical-align: bottom; height: 10px;
background-image: -webkit-canvas(arrowDown);
background-position: 0% 0%; background-repeat:
no-repeat;"></span><span class="webkit-html-tag"><om:Observation></span></div>
<div class="collapsible-content" style="margin-left: 1em;"><span
class="text"></span>
<div class="collapsible" id="collapsible4">
<div class="expanded">
<div class="line"><span class="button
collapse-button" style="-webkit-user-select:
none; cursor: pointer; display: inline-block;
margin-left: -10px; width: 10px; vertical-align:
bottom; height: 10px; background-image:
-webkit-canvas(arrowDown); background-position:
0% 0%; background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><om:samplingTime></span></div>
<div class="collapsible-content" style="margin-left:
1em;"><span class="text"></span>
<div class="collapsible" id="collapsible5">
<div class="expanded">
<div class="line"><span class="button
collapse-button"
style="-webkit-user-select: none; cursor:
pointer; display: inline-block;
margin-left: -10px; width: 10px;
vertical-align: bottom; height: 10px;
background-image:
-webkit-canvas(arrowDown);
background-position: 0% 0%;
background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><gml:TimeInstant></span></div>
<div class="collapsible-content"
style="margin-left: 1em;"><span class="text"></span>
<div class="line"><span
class="webkit-html-tag"><gml:timePosition></span><span
class="text">2014-01-29 04:00:00</span><span
class="webkit-html-tag"></gml:timePosition></span></div>
<span class="text"></span></div>
<div class="line"><span
class="webkit-html-tag"></gml:TimeInstant></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span class="webkit-html-tag"></om:samplingTime></span></div>
</div>
</div>
<span class="text"></span>
<div class="line"><span class="webkit-html-tag"><om:procedure<span
class="webkit-html-attribute"><span
class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">xlink:href</span>="<span
class="webkit-html-attribute-value"><b>urn:ogc:def:procedure</b>:2197.7</span>"</span>/></span></div>
<span class="text"></span>
<div class="collapsible" id="collapsible6">
<div class="expanded">
<div class="line"><span class="button
collapse-button" style="-webkit-user-select:
none; cursor: pointer; display: inline-block;
margin-left: -10px; width: 10px; vertical-align:
bottom; height: 10px; background-image:
-webkit-canvas(arrowDown); background-position:
0% 0%; background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><om:observedProperty></span></div>
<div class="collapsible-content" style="margin-left:
1em;"><span class="text"></span>
<div class="collapsible" id="collapsible7">
<div class="expanded">
<div class="line"><span class="button
collapse-button"
style="-webkit-user-select: none; cursor:
pointer; display: inline-block;
margin-left: -10px; width: 10px;
vertical-align: bottom; height: 10px;
background-image:
-webkit-canvas(arrowDown);
background-position: 0% 0%;
background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><swe:CompositePhenomenon<span
class="webkit-html-attribute"><span
class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">gml:id</span>="<span
class="webkit-html-attribute-value">vap</span>"</span><span
class="webkit-html-attribute"><span
class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">dimension</span>="<span
class="webkit-html-attribute-value">2</span>"</span>></span></div>
<div class="collapsible-content"
style="margin-left: 1em;"><span class="text"></span>
<div class="line"><span
class="webkit-html-tag"><gml:name></span><span
class="text">Vapor agua columna</span><span
class="webkit-html-tag"></gml:name></span></div>
<span class="text"></span>
<div class="line"><span
class="webkit-html-tag"><swe:component<span
class="webkit-html-attribute"><span
class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">xlink:href</span>="<span
class="webkit-html-attribute-value">urn:ogc:def:property:OGC-SWE:1:fecha</span>"</span>/></span></div>
<span class="text"></span>
<div class="line"><span
class="webkit-html-tag"><swe:component<span
class="webkit-html-attribute"><span
class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">xlink:href</span>="<span
class="webkit-html-attribute-value">urn:ogc:def:property:OGC-SWE:1:vap</span>"</span>/></span></div>
<span class="text"></span></div>
<div class="line"><span
class="webkit-html-tag"></swe:CompositePhenomenon></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span class="webkit-html-tag"></om:observedProperty></span></div>
</div>
</div>
<span class="text"></span>
<div class="line"><span class="webkit-html-tag"><om:featureOfInterest<span
class="webkit-html-attribute"><span
class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">xlink:href</span>="<span
class="webkit-html-attribute-value"><a class="moz-txt-link-freetext" href="http://138.100.61.23:90/cgi-bin/sos-mapserv?service=WFS&version=1.1.0&request=DescribeFeatureType&typename=test_sos_layer">http://138.100.61.23:90/cgi-bin/sos-mapserv?service=WFS&version=1.1.0&request=DescribeFeatureType&typename=test_sos_layer</a></span>"</span>/></span></div>
<span class="text"></span>
<div class="collapsible" id="collapsible8">
<div class="expanded">
<div class="line"><span class="button
collapse-button" style="-webkit-user-select:
none; cursor: pointer; display: inline-block;
margin-left: -10px; width: 10px; vertical-align:
bottom; height: 10px; background-image:
-webkit-canvas(arrowDown); background-position:
0% 0%; background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><om:result></span></div>
<div class="collapsible-content" style="margin-left:
1em;"><span class="text"></span>
<div class="collapsible" id="collapsible9">
<div class="expanded">
<div class="line"><span class="button
collapse-button"
style="-webkit-user-select: none; cursor:
pointer; display: inline-block;
margin-left: -10px; width: 10px;
vertical-align: bottom; height: 10px;
background-image:
-webkit-canvas(arrowDown);
background-position: 0% 0%;
background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><gml:featureMember></span></div>
<div class="collapsible-content"
style="margin-left: 1em;"><span class="text"></span>
<div class="collapsible" id="collapsible10">
<div class="expanded">
<div class="line"><span class="button
collapse-button"
style="-webkit-user-select: none;
cursor: pointer; display:
inline-block; margin-left: -10px;
width: 10px; vertical-align: bottom;
height: 10px; background-image:
-webkit-canvas(arrowDown);
background-position: 0% 0%;
background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><ms:test_sos_layer></span></div>
<div class="collapsible-content"
style="margin-left: 1em;"><span
class="text"></span>
<div class="collapsible"
id="collapsible11">
<div class="expanded">
<div class="line"><span
class="button collapse-button"
style="-webkit-user-select:
none; cursor: pointer;
display: inline-block;
margin-left: -10px; width:
10px; vertical-align: bottom;
height: 10px;
background-image:
-webkit-canvas(arrowDown);
background-position: 0% 0%;
background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><gml:boundedBy></span></div>
<div class="collapsible-content"
style="margin-left: 1em;"><span
class="text"></span>
<div class="collapsible"
id="collapsible12">
<div class="expanded">
<div class="line"><span
class="button
collapse-button"
style="-webkit-user-select:
none; cursor: pointer;
display: inline-block;
margin-left: -10px;
width: 10px;
vertical-align: bottom;
height: 10px;
background-image:
-webkit-canvas(arrowDown);
background-position: 0%
0%; background-repeat:
no-repeat;"></span><span
class="webkit-html-tag"><gml:Envelope<span
class="webkit-html-attribute"><span class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">srsName</span>="<span
class="webkit-html-attribute-value">urn:ogc:crs:epsg:4326</span>"</span><span
class="webkit-html-attribute"><span class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">srsDimension</span>="<span
class="webkit-html-attribute-value">2</span>"</span>></span></div>
<div
class="collapsible-content"
style="margin-left: 1em;"><span
class="text"></span>
<div class="line"><span
class="webkit-html-tag"><gml:lowerCorner></span><span
class="text">-4.249658
40.429163</span><span
class="webkit-html-tag"></gml:lowerCorner></span></div>
<span class="text"></span>
<div class="line"><span
class="webkit-html-tag"><gml:upperCorner></span><span
class="text">-4.249658
40.429163</span><span
class="webkit-html-tag"></gml:upperCorner></span></div>
<span class="text"></span></div>
<div class="line"><span
class="webkit-html-tag"></gml:Envelope></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span
class="webkit-html-tag"></gml:boundedBy></span></div>
</div>
</div>
<span class="text"></span>
<div class="collapsible"
id="collapsible13">
<div class="expanded">
<div class="line"><span
class="button collapse-button"
style="-webkit-user-select:
none; cursor: pointer;
display: inline-block;
margin-left: -10px; width:
10px; vertical-align: bottom;
height: 10px;
background-image:
-webkit-canvas(arrowDown);
background-position: 0% 0%;
background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><ms:msGeometry></span></div>
<div class="collapsible-content"
style="margin-left: 1em;"><span
class="text"></span>
<div class="collapsible"
id="collapsible14">
<div class="expanded">
<div class="line"><span
class="button
collapse-button"
style="-webkit-user-select:
none; cursor: pointer;
display: inline-block;
margin-left: -10px;
width: 10px;
vertical-align: bottom;
height: 10px;
background-image:
-webkit-canvas(arrowDown);
background-position: 0%
0%; background-repeat:
no-repeat;"></span><span
class="webkit-html-tag"><gml:Point<span
class="webkit-html-attribute"><span class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">srsName</span>="<span
class="webkit-html-attribute-value">urn:ogc:crs:epsg:4326</span>"</span><span
class="webkit-html-attribute"><span class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">srsDimension</span>="<span
class="webkit-html-attribute-value">2</span>"</span>></span></div>
<div
class="collapsible-content"
style="margin-left: 1em;"><span
class="text"></span>
<div class="line"><span
class="webkit-html-tag"><gml:pos></span><span
class="text">-4.249658
40.429163</span><span
class="webkit-html-tag"></gml:pos></span></div>
<span class="text"></span></div>
<div class="line"><span
class="webkit-html-tag"></gml:Point></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span
class="webkit-html-tag"></ms:msGeometry></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span
class="webkit-html-tag"></ms:test_sos_layer></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span
class="webkit-html-tag"></gml:featureMember></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span class="webkit-html-tag"></om:result></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span class="webkit-html-tag"></om:Observation></span></div>
</div>
</div>
<span class="text"></span></div>
<div class="line"><span class="webkit-html-tag"></om:member></span></div>
</div>
</div>
<span class="text" style="color: rgb(0, 0, 0); font-family:
monospace; font-size: 13px; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing: normal; line-height:
normal; orphans: auto; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;"></span>
<div class="collapsible" id="collapsible15" style="color: rgb(0, 0,
0); font-family: monospace; font-size: 13px; font-style: normal;
font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height: normal; orphans: auto; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<div class="expanded">
<div class="line"><span class="button collapse-button"
style="-webkit-user-select: none; cursor: pointer; display:
inline-block; margin-left: -10px; width: 10px;
vertical-align: bottom; height: 10px; background-image:
-webkit-canvas(arrowDown); background-position: 0% 0%;
background-repeat: no-repeat;"></span><span
class="webkit-html-tag"><om:member></span></div>
</div>
</div>
<br>
However procedure name don't appear in xml <span
class="webkit-html-tag"><om:procedure<span
class="webkit-html-attribute"><span
class="Apple-converted-space"> </span><span
class="webkit-html-attribute-name">xlink:href</span>="<span
class="webkit-html-attribute-value">urn:ogc:def:procedure:2197.7</span>"</span>/><br>
<br>
Then when i tryed to getObservation using parameter <i>&procedure=urn:ogc:def:procedure:</i></span>
mapserver SOS don't recognize any<br>
<br>
<br>
Second question are related to eventTime request parameter.<br>
<br>
I'm trying to use
&eventtime=2014-01-01T00:00:00+01/2014-01-31T00:00:00+01 and
an exception apear <span style="color: rgb(0, 0, 0); font-family:
monospace; font-size: 13px; font-style: normal; font-variant:
normal; font-weight: normal; letter-spacing: normal; line-height:
normal; orphans: auto; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline
!important; float: none;">msSOSGetObservation(): SOS server error.
Invalid time value given for the eventTime parameter<br>
<br>
</span>I must do request with XML FE format
&eventtime=%3Cogc:TM_Equals%3E%3Cgml:TimePeriod%3E%3Cgml:beginPosition%3E2014-01-01%3C/gml:beginPosition%3E%3Cgml:endPosition%3E2014-01-31%3C/gml:endPosition%3E%3C/gml:TimePeriod%3E%3C/ogc:TM_Equals%3E<br>
<br>
What are the correct ISO time format to operate without XML?<br>
<br>
Regards,<br>
Miguel A.<br>
<br>
<pre>><i> Dear all,
</i>><i>
</i>><i> I'm trying to config mapserver to offer through SOS data stored in two
</i>><i> tables joined by a view.
</i>><i>
</i>><i> I'm trying to offer in the first step only one time serial data and i'm
</i>><i> using this configuration:
</i>><i>
</i>><i> LAYER
</i>><i> NAME "test_sos_layer"
</i>><i> METADATA
</i>><i> "sos_procedure" "vaporcolumna" ## REQUIRED
</i>><i> "sos_procedure_item" "vap"
</i>><i> "sos_offering_id" "MADR13407S012" ## REQUIRED
</i>><i> "sos_timeitem" "fecha"
</i>><i> "sos_observedproperty_id" "vap"
</i>><i> "sos_observedproperty_name" "Vapor_agua_columna"
</i>><i> "sos_offering_timeextent" "2010/2014"
</i>><i> "sos_describesensor_url"
</i>><i> "<a href="http://138.100.61.23:90/sensorml/MADR13407S012.xml">http://138.100.61.23:90/sensorml/MADR13407S012.xml</a>" ## REQUIRED
</i>><i> "sos_offering_name" "GPS Station in Madrid 13407S012"
</i>><i> END
</i>><i> TYPE POINT
</i>><i> STATUS ON
</i>><i> CONNECTIONTYPE POSTGIS
</i>><i> CONNECTION "host=127.0.0.1 port=5432 dbname=example_postgis21
</i>><i> user=postgres password=postgres"
</i>><i> DATA "pos, vap from vaporcolumna where id='MADR13407S012' "
</i>><i>
</i>><i> PROJECTION
</i>><i> "init=epsg:4326"
</i>><i> END
</i>><i>
</i>><i> CLASS
</i>><i> NAME "vap"
</i>><i> STYLE
</i>><i> COLOR 255 0 0
</i>><i> SYMBOL "circle"
</i>><i> SIZE 8
</i>><i> END
</i>><i> END
</i>><i> END
</i>><i>
</i>><i>
</i>><i> View have this fields:
</i>><i> Id (pk), pos (geometry), vap (double), fecha (date)
</i>><i>
</i>><i> Can any one help me informing what i'm doing bad or how must i config in
</i>><i> order to do it?
</i>
You probably need to make sure pos is listed in the geometry_columns
table and associated with your view.
Turn on layer debugging and set DEBUG 5
try to use shp2img so see the log messages and any error messages.
-Steve W</pre>
<br>
</body>
</html>