[mapserver-users] Question about config Mapserver to provide SOS service from postgis table/view

[Miguel-Angel Manso-Callejo (UPM)]

Dear all,

I'm trying to config mapserver to offer through SOS data stored in two 
tables joined by a view.

I'm trying to offer in the first step only one time serial data and i'm 
using this configuration:

   LAYER
     NAME "test_sos_layer"
     METADATA
       "sos_procedure"  "vaporcolumna" ## REQUIRED
       "sos_procedure_item" "vap"
       "sos_offering_id" "MADR13407S012" ## REQUIRED
       "sos_timeitem" "fecha"
       "sos_observedproperty_id" "vap"
       "sos_observedproperty_name" "Vapor_agua_columna"
       "sos_offering_timeextent" "2010/2014"
       "sos_describesensor_url" 
"http://138.100.61.23:90/sensorml/MADR13407S012.xml" ## REQUIRED
       "sos_offering_name"    "GPS Station in Madrid 13407S012"
     END
     TYPE POINT
     STATUS ON
     CONNECTIONTYPE POSTGIS
     CONNECTION "host=127.0.0.1 port=5432 dbname=example_postgis21 
user=postgres password=postgres"
     DATA "pos, vap from vaporcolumna where id='MADR13407S012' "

     PROJECTION
       "init=epsg:4326"
     END

     CLASS
       NAME "vap"
       STYLE
         COLOR 255 0 0
         SYMBOL "circle"
         SIZE 8
       END
     END
   END


View have this fields:
  Id (pk), pos (geometry), vap (double), fecha (date)

Can any one help me informing what i'm doing bad or how must i config in 
order to do it?

Regards,
Miguel A.