[mapserver-users] GetFeatureInfo from PostGis database

[Guillaume Sueur]

add gid to the SQL string :

DATA  "the_geom FROM (select gid, numero, feuille,
 the_geom FROM localisant) as foo USING UNIQUE gid USING SRID=27582"

and try to use EPSG:27572 as 27582 is deprecated.

Regards,
GUillaume



SAEZ Laurent - CETE Méditerr./DI/ETER a écrit :
> 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"
>>>        
>>>        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
>>>
>>>
>>
>>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users