Re: [mapserver-users] GetFeatureInfo from PostGis database

SAEZ Laurent - CETE Méditerr./DI/ETER Mon, 30 Jun 2008 23:29:45 -0700

Hi Guillaume,

You're right. A friend of mine has told me the same thing this morning.It works goo ! Youpi !


Thank you very much for your help

Regards

Le 01/07/2008 07:53, > Guillaume Sueur (par Internet) a écrit  :

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 &#39;ERREUR:  la colonne «gid»
n&#39;existe pas
&#39;"
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] GetFeatureInfo from PostGis database

Reply via email to