<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19170"></HEAD>
<BODY>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>Hi
List,</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>I am new to the list
and have been trying to setup MapServer's SOS Server to serve some observation
data. I have created a map file and managed to have GetCapabilities
working. But when trying out the GetObservation, I am confused...
not much helpful documentation around and have found this discussion from the
old SOS User forum : <A
href="http://osgeo-org.1803224.n2.nabble.com/SOS-disconnect-td1992064.html">http://osgeo-org.1803224.n2.nabble.com/SOS-disconnect-td1992064.html</A>.
However, still confused on how to map a database column to SOS output
!?!?</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>Metadata for the
layer in my map file :</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial> METADATA<BR> "sos_value_alias" "value_test"
## value is the name of the db clumn<BR> "sos_value_componenturl" "<A
href="http://test.org#value_test">http://test.org#value_test</A>"<BR> "sos_procedure" "unknown"
<BR> "sos_offering_id" "waterstorage"<BR> "sos_offering_description" "value_test"<BR> "sos_observedproperty_id" "9"
<BR> "sos_describesensor_url" "<A
href="http://localhost/TEST123.xml">http://localhost/TEST123.xml</A>"
<BR> "sos_srs" "init=epsg:4283"
<BR> "sos_offering_timeextent" "1900/2010" </FONT></SPAN></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=376551808-17012012></SPAN><SPAN
class=376551808-17012012></SPAN><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>The database
connection is successful and the GetCapabilities return the following sos
information :</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>-
<sos:Contents><BR>- <sos:ObservationOfferingList><BR>-
<sos:ObservationOffering gml:id="waterstorage"><BR>
<gml:description>value_test</gml:description> <BR>- <!-- WARNING:
Optional metadata "sos_offering_name" missing for gml:name<BR> -->
<BR> <gml:srsName>EPSG:4326</gml:srsName> <BR>- <!--
WARNING: Optional metadata "sos_offering_intendedapplication" missing for
sos:intendedApplication<BR> --> <BR>- <sos:time><BR>-
<gml:TimePeriod><BR>
<gml:beginPosition>1900</gml:beginPosition> <BR>
<gml:endPosition>2010</gml:endPosition> <BR>
</gml:TimePeriod><BR> </sos:time><BR> <sos:procedure
xlink:href="urn:ogc:def:procedure:unknown" /> <BR>-
<sos:observedProperty><BR>- <swe:CompositePhenomenon gml:id="9"
dimension="7"><BR> <swe:component
xlink:href="urn:ogc:def:property:OGC-SWE:1:feature" /> <BR>
<swe:component xlink:href="urn:ogc:def:property:OGC-SWE:1:identifier" />
<BR> <swe:component xlink:href="urn:ogc:def:property:OGC-SWE:1:ftype"
/> <BR> <swe:component
xlink:href="urn:ogc:def:property:OGC-SWE:1:value_test" /> <BR>
<swe:component xlink:href="urn:ogc:def:property:OGC-SWE:1:type" />
<BR> <swe:component
xlink:href="urn:ogc:def:property:OGC-SWE:1:description" /> <BR>
<swe:component xlink:href="urn:ogc:def:property:OGC-SWE:1:yearofcompletion"
/> <BR> </swe:CompositePhenomenon><BR>
</sos:observedProperty><BR> <sos:featureOfInterest
xlink:href="urn:ogc:def:feature:OGC-SWE:3:transient" /> <BR>
<sos:responseFormat>text/xml;
subtype="om/1.0.0"</sos:responseFormat> <BR>
<sos:resultModel>om:Observation</sos:resultModel> <BR>
<sos:resultModel>om:Measurement</sos:resultModel> <BR>
<sos:responseMode>inline</sos:responseMode> <BR>
</sos:ObservationOffering><BR>
</sos:ObservationOfferingList><BR>
</sos:Contents><BR></FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>GetObservation (<A
href="http://localhost/cgi-bin/mapserv.exe?map=C:/ms4w/apps/sos/sos_test.map&Request=GetObservation&service=SOS&OFFERING=waterstorage&observedproperty=9&version=1.0.0&responseFormat=text/xml">http://localhost/cgi-bin/mapserv.exe?map=C:/ms4w/apps/sos/sos_test.map&Request=GetObservation&service=SOS&OFFERING=waterstorage&observedproperty=9&version=1.0.0&responseFormat=text/xml</A>;
subtype="om/1.0.0") return the following :</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial> <?xml
version="1.0" encoding="ISO-8859-1" ?> <BR>- <om:ObservationCollection
xmlns:gml="<A href="http://www.opengis.net/gml">http://www.opengis.net/gml</A>"
xmlns:ows="<A
href="http://www.opengis.net/ows/1.1">http://www.opengis.net/ows/1.1</A>"
xmlns:swe="<A
href="http://www.opengis.net/swe/1.0.1">http://www.opengis.net/swe/1.0.1</A>"
xmlns:xlink="<A
href="http://www.w3.org/1999/xlink">http://www.w3.org/1999/xlink</A>"
xmlns:xsi="<A
href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</A>"
xmlns:sos="<A
href="http://www.opengis.net/sos/1.0">http://www.opengis.net/sos/1.0</A>"
xmlns:ms="<A
href="http://mapserver.gis.umn.edu/mapserver">http://mapserver.gis.umn.edu/mapserver</A>"
xmlns:om="<A
href="http://www.opengis.net/om/1.0">http://www.opengis.net/om/1.0</A>"
gml:id="waterstorage" xsi:schemaLocation="<A
href="http://www.opengis.net/om/1.0">http://www.opengis.net/om/1.0</A> <A
href="http://schemas.opengis.net/om/1.0.0/om.xsd">http://schemas.opengis.net/om/1.0.0/om.xsd</A>
<A
href="http://mapserver.gis.umn.edu/mapserver">http://mapserver.gis.umn.edu/mapserver</A>
<A
href="http://127.0.0.1/cgi-bin/mapserv.exe?map=c:/ms4w/apps/sos/sos_test.map&service=WFS&version=1.1.0&request=DescribeFeatureType&typename=test_sos_layer">http://127.0.0.1/cgi-bin/mapserv.exe?map=c:/ms4w/apps/sos/sos_test.map&service=WFS&version=1.1.0&request=DescribeFeatureType&typename=test_sos_layer</A>"><BR>
<gml:description xmlns:gml="<A
href='http://www.opengis.net/gml">value_test</gml:description'>http://www.opengis.net/gml">value_test</gml:description</A>>
<BR> </om:ObservationCollection></FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>My quesions are
:</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>1) How do I map a db
clumn to a sos output ?? Do i have to create "sos_dbColumn_alias"
for each column ?</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>2) What's the
purpose of "sos_dbColumn_componenturl" ? Do I need to create this for each
dbColumn ?</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>3) I have map
the "sos_offering_description" "value_test", why does the
getCapabilities and getObservation return "value_test" as a constant rather then
retrieving data from the database ?</FONT></SPAN></DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=376551808-17012012><FONT size=2 face=Arial>Appreciave if
someone could point out what is the problem of the map file or point me to some
useful documentation or tutorial on set up SOS in MapServer.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR> </DIV></FONT></SPAN>
<DIV><SPAN class=376551808-17012012></SPAN><FONT size=2 face=Arial><SPAN
class=376551808-17012012>Thanks & Regards,</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV class=Section1>
<P style="FONT-FAMILY: arial; FONT-SIZE: 9pt; sans-serif: " align=left><SPAN
style="COLOR: #0099cc; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></SPAN><STRONG><FONT
color=#0099cc size=2>Florence Tan</FONT></STRONG><BR>Research Projects Officer
<SPAN style="COLOR: #bed600; FONT-WEIGHT: bold">|</SPAN> ASRDC<BR>CSIRO Earth
Science and Resource Engineering</P>
<P style="FONT-FAMILY: arial; FONT-SIZE: 9pt; sans-serif: ">Phone:
+61 8 6436 8802<SPAN
style="COLOR: #bed600; FONT-WEIGHT: bold"> | </SPAN>Fax:
+61 8 6436 8559 <BR><SPAN style="COLOR: #0099cc"><A
href="mailto:florence.tan@csiro.au">florence.tan@csiro.au</A></SPAN> <SPAN
style="COLOR: #bed600; FONT-WEIGHT: bold">|</SPAN> <SPAN
style="COLOR: #0099cc">www.csiro.au</SPAN> <BR>Address: <SPAN
style="COLOR: #999999">Australian Resources Research Centre, 26 Dick Perry
Avenue, Kensington WA 6151</SPAN><BR><BR><B>PLEASE NOTE</B><BR>The information
contained in this email may be confidential or privileged. Any unauthorised use
or disclosure is prohibited. If you have received this email in error, please
delete it immediately and notify the sender by return email. Thank you. To
the extent permitted by law, CSIRO does not represent, warrant and/or guarantee
that the integrity of this communication has been maintained or that the
communication is free of errors, virus, interception or interference. </P>
<P
style="FONT-FAMILY: arial; COLOR: #666666; FONT-SIZE: 9pt; FONT-WEIGHT: bold; sans-serif: ">Please
consider the environment before printing this email.</P></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV></BODY></HTML>