[mapserver-users] getFeatureInfo from Postgis
Hi, I can't get the information (getFeatureInfo) of the features from Postgis with EPSG:23030, but the same request from a shapefile gives me the info. I can get info from another layer with EPSG:4326, but not with EPSG:23030. Is it some bug in MapServer? Thanks! -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] getFeatureInfo from Postgis
Does the PostGIS layer Map correctly? From: Iratxe Lejarreta iratxe.lejarr...@axios.es To: mapserver-users@lists.osgeo.org Sent: Fri, October 23, 2009 5:34:44 AM Subject: [mapserver-users] getFeatureInfo from Postgis Hi, I can't get the information (getFeatureInfo) of the features from Postgis with EPSG:23030, but the same request from a shapefile gives me the info. I can get info from another layer with EPSG:4326, but not with EPSG:23030. Is it some bug in MapServer? Thanks! -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] getFeatureInfo from Postgis
On Friday 23 October 2009 12:34:44 pm Iratxe Lejarreta wrote: Hi, I can't get the information (getFeatureInfo) of the features from Postgis with EPSG:23030, but the same request from a shapefile gives me the info. I can get info from another layer with EPSG:4326, but not with EPSG:23030. Is it some bug in MapServer? Thanks! Hi, I solved my problem. I tried with another layer with the same proyection and I can get the info. Maybe my data have errors in database... Thanks! -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetFeatureInfo from PostGis database
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 NAMEbdparcellaire_numero TYPEannotation STATUS ON DUMP TRUE TEMPLATE blank.html MINSCALE 100 MAXSCALE 1 CONNECTIONTYPEpostgis CONNECTIONuser=toto password=toto dbname=bdparcellaire_2007 host=172.23.208.134 port=5432 LABELITEMnumero 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 000wms_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.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoSRS=EPSG%3A27582WIDTH=600HEIGHT=400BBOX=643470,1743572,643590,1743652LAYERS=bdparcellaire_numeroSTYLES=FORMAT=image%2FpngQUERY_LAYERS=bdparcellaire_numeroX=167Y=175INFO_FORMAT=application%2Fvnd.ogc.gmlFEATURE_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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] GetFeatureInfo from PostGis database
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 NAMEbdparcellaire_numero TYPEannotation STATUS ON DUMP TRUE TEMPLATE blank.html MINSCALE 100 MAXSCALE 1 CONNECTIONTYPEpostgis CONNECTIONuser=toto password=toto dbname=bdparcellaire_2007 host=172.23.208.134 port=5432 DATAthe_geom FROM (select numero, feuille, the_geom FROM localisant) as foo USING UNIQUE the_geom USING SRID=27582 LABELITEMnumero 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.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoSRS=EPSG%3A27582WIDTH=600HEIGHT=400BBOX=643470,1743572,643590,1743652LAYERS=bdparcellaire_numeroSTYLES=FORMAT=image%2FpngQUERY_LAYERS=bdparcellaire_numeroX=167Y=175INFO_FORMAT=application%2Fvnd.ogc.gmlFEATURE_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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetFeatureInfo from PostGis database
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 NAMEbdparcellaire_numero TYPEannotation STATUS ON DUMP TRUE TEMPLATE blank.html MINSCALE 100 MAXSCALE 1 CONNECTIONTYPEpostgis CONNECTIONuser=toto password=toto dbname=bdparcellaire_2007 host=172.23.208.134 port=5432 DATAthe_geom FROM (select numero, feuille, the_geom FROM localisant) as foo USING UNIQUE the_geom USING SRID=27582 LABELITEMnumero 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 000wms_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.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoSRS=EPSG%3A27582WIDTH=600HEIGHT=400BBOX=643470,1743572,643590,1743652LAYERS=bdparcellaire_numeroSTYLES=FORMAT=image%2FpngQUERY_LAYERS=bdparcellaire_numeroX=167Y=175INFO_FORMAT=application%2Fvnd.ogc.gmlFEATURE_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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetFeatureInfo from PostGis database
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 NAMEbdparcellaire_numero TYPEannotation STATUS ON DUMP TRUE TEMPLATE blank.html MINSCALE 100 MAXSCALE 1 CONNECTIONTYPEpostgis CONNECTIONuser=toto password=toto dbname=bdparcellaire_2007 host=172.23.208.134 port=5432 LABELITEMnumero 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 000wms_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.mapSERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoSRS=EPSG%3A27582WIDTH=600HEIGHT=400BBOX=643470,1743572,643590,1743652LAYERS=bdparcellaire_numeroSTYLES=FORMAT=image%2FpngQUERY_LAYERS=bdparcellaire_numeroX=167Y=175INFO_FORMAT=application%2Fvnd.ogc.gmlFEATURE_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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users