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

[Stephen Woodbridge]

On 6/15/2014 2:16 PM, Miguel-Angel Manso-Callejo (UPM) wrote:
> 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?

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