[mapserver-users] GetFeatureInfo from PostGis database

[Bart van den Eijnden (OSGIS)]

You shouldn't use the geometry column as the unique column (USING UNIQUE 
X).

Try an integer type column for that.

Best regards,
Bart

SAEZ Laurent - CETE Méditerr./DI/ETER wrote:
> Hi list,
>
> I'm trying to access data fields using getfeatureinfo from a PostGIS 
> database.
> I've read some articles about it, but it seems that I'm a newbie.
> I've no problem with data access when I do some getmap requests.
>
> Here is a part of my mapfile :
>
>    LAYER
>        NAME                        "bdparcellaire_numero"
>        TYPE                        annotation
>        STATUS ON
>        DUMP TRUE
>        TEMPLATE "blank.html"
>        MINSCALE 100
>        MAXSCALE 10000
>        CONNECTIONTYPE    postgis
>        CONNECTION            "user=toto password=toto 
> dbname=bdparcellaire_2007 host=172.23.208.134 port=5432"
>        DATA            "the_geom FROM (select numero, feuille, 
> the_geom FROM localisant) as foo USING UNIQUE the_geom USING SRID=27582"
>        LABELITEM                "numero"
>        CLASS
>              LABEL
>                TYPE TRUETYPE
>                WRAP "#"
>                COLOR 0 0 0
>                OUTLINECOLOR 254 254 254
>                FONT arial
>                SIZE 9
>                POSITION CC
>                FORCE false
>                PARTIALS false
>              END
>         END
>        METADATA
>            WMS_TITLE "Numéros de parcelle (Données BD Parcellaire® - 
> Copyright IGN)"
>            wms_abstract "Visible entre les échelles 1/100 et 1/10 
> 000"                wms_srs "EPSG:27582 EPSG:27581 EPSG:27583 
> EPSG:27584 EPSG:27591 EPSG:27592 EPSG:27593 EPSG:27594 EPSG:2154 
> EPSG:23030 EPSG:23031 EPSG:23032 EPSG:32630 EPSG:32631 EPSG:32632 
> EPSG:4326"
>            wms_extent "47650 1620400 1197850 2677450"                
> WMS_ENCODING "UTF-8"
>            GML_INCLUDE_ITEMS "all"
>        END
>    END
>
> When I try this getfeatureinfo request, the XML returned is not 
> complete :
>
> The request : 
> http://myIP/cgi-bin/mapserv?map=/data/carto/ref/bdparcellaire/bdparcellaire_2007_direct.map&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetFeatureInfo&SRS=EPSG%3A27582&WIDTH=600&HEIGHT=400&BBOX=643470,1743572,643590,1743652&LAYERS=bdparcellaire_numero&STYLES=&FORMAT=image%2Fpng&QUERY_LAYERS=bdparcellaire_numero&X=167&Y=175&INFO_FORMAT=application%2Fvnd.ogc.gml&FEATURE_COUNT=999 
>
>
> The entire XML :
> <?xml version="1.0" encoding="UTF-8"?>
>
> <msGMLOutput
>     xmlns:gml="http://www.opengis.net/gml"
>     xmlns:xlink="http://www.w3.org/1999/xlink"
>     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
>    <bdparcellaire_numero_layer>
>
>
> Why it doesn't work ?
> I know that it should be in my DATA object in my mapfile, but I don't 
> know what exactly...
>
> Thanks a lot...
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>


-- 
Bart van den Eijnden
OSGIS, Open Source GIS
bartvde at osgis.nl
http://www.osgis.nl