[mapserver-users] GetFeatureInfo from PostGis database

["SAEZ Laurent - CETE Méditerr./DI/ETER"]

Hi,

I've tried to use the gid column, but the getfeatureinfo reports me an 
error :
"Postgresql reports the error as 'ERREUR:  la colonne «gid» 
n'existe pas
'"
The error tells me that the gid column doesn't exist. You can trust me, 
I have a field called gid.

Thanks

Le 30/06/2008 19:49, > Bart van den Eijnden (OSGIS) (par Internet) a 
écrit  :
> 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
>>
>>
>
>