<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Guillaume,<br>
<br>
You're right. A friend of mine has told me the same thing this morning.
It works goo ! Youpi !<br>
<br>
Thank you very much for your help<br>
<br>
Regards<br>
<br>
Le 01/07/2008 07:53, > Guillaume Sueur (par Internet) a écrit :
<blockquote cite="mid4869C677.3080001@neogeo-online.net" type="cite">
<pre wrap="">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 :
</pre>
<blockquote type="cite">
<pre wrap="">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 :
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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 :
<a class="moz-txt-link-freetext" href="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">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</a>
The entire XML :
<?xml version="1.0" encoding="UTF-8"?>
<msGMLOutput
xmlns:gml=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/gml">"http://www.opengis.net/gml"</a>
xmlns:xlink=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/1999/xlink">"http://www.w3.org/1999/xlink"</a>
xmlns:xsi=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema-instance">"http://www.w3.org/2001/XMLSchema-instance"</a>>
<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
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">_______________________________________________
mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>