Laura
I cannot reproduce your problem using p.mapper 4.2, MS 6.0.1 and
Postgres 9. Everything's ok with the Postgis layer and identify/select.
I use a data definition like
DATA "the_geom from (select * from cities1000) \
AS foo USING UNIQUE geonameid using SRID=4326"
But I doubt that the subselect has any influence.
Maybe somebody else had similar problems and discovered the reason for
it. I don't know if setting the DEBUG in the map file produces helpful
output.
Best regards
Armin
On 07/10/2011 20:16, Laura Larghero wrote:
> Hello Armin, sorry for sending this mail to your personal email, I
> emailed it yesterday to 'pmapper-users@lists.sourceforge.net', but don’t
> know if it worked.
>
> I’m using Ubuntu, MapServer 6, p.mapper 4.2.0, PostgreSQL 8.4
>
> Identify function is not working for a layer defined as CONNECTIONTYPE
> POSTGIS.
>
> When I pick an element, it shows the popup window with the correct field
> names (RESULT_HEADERS) and the correct number of rows, but always shows
> the first rows defined in the PostGIS table. This is the “departamentos”
> layer.
>
> The PostGIS field names are defined in lowercase letters.
>
> It woks fine with a shape layer. This is the “ejes_pl_total” layer.
>
> What’s wrong in my mapfile?
>
> I would appreciate any help!!
>
> Thank you, Laura
>
> ********************************************************************************************************************************
>
>
> HERE IS MY MAPFILE
>
> ********************************************************************************************************************************
>
>
> MAP
>
> NAME siiasgis
>
> EXTENT 366582.247191515 6127918.53905545 858252.132029213 6671738.39330106
>
> SIZE 400 300
>
> SHAPEPATH "../../../pmapper_demodata"
>
> SYMBOLSET "../common/symbols/siiasgis.sym"
>
> FONTSET "../common/fonts/fonts.txt"
>
> CONFIG "PROJ_LIB" "/usr/share/proj"
>
> CONFIG "MS_ERRORFILE" "/var/log/mapserver/mapserver.log"
>
> CONFIG "CPL_DEBUG" "OFF"
>
> CONFIG "PROJ_DEBUG" "OFF"
>
> IMAGETYPE png
>
> INTERLACE OFF
>
> LEGEND
>
> IMAGECOLOR -1 -1 -1
>
> LABEL
>
> FONT "vera"
>
> ANGLE FOLLOW
>
> COLOR 0 0 0
>
> ENCODING "UTF-8"
>
> TYPE truetype
>
> SIZE 8
>
> END
>
> STATUS ON
>
> TRANSPARENT ON
>
> END
>
> DEBUG 2
>
> OUTPUTFORMAT
>
> NAME png
>
> DRIVER "GD/PNG"
>
> MIMETYPE "image/png"
>
> IMAGEMODE RGB
>
> FORMATOPTION INTERLACE=OFF
>
> TRANSPARENT OFF
>
> END
>
> OUTPUTFORMAT
>
> NAME png8
>
> DRIVER "GD/PNG"
>
> MIMETYPE "image/png"
>
> IMAGEMODE PC256
>
> FORMATOPTION INTERLACE=OFF
>
> TRANSPARENT OFF
>
> END
>
> OUTPUTFORMAT
>
> NAME GTiff
>
> DRIVER "GDAL/GTiff"
>
> MIMETYPE "image/tiff"
>
> IMAGEMODE RGB
>
> END
>
> OUTPUTFORMAT
>
> NAME imagemap
>
> MIMETYPE "text/html"
>
> FORMATOPTION SKIPENDTAG=OFF
>
> DRIVER imagemap
>
> END
>
> #
>
> # Start of web interface definition
>
> #
>
> WEB
>
> TEMPLATE "map.html"
>
> IMAGEPATH "/var/tmp/mapserver/"
>
> IMAGEURL "/ms_tmp/"
>
> METADATA
>
> "wms_encoding" "UTF-8"
>
> "wms_title" "Mapserver WMS SIIAS"
>
> "wms_abstract" ""
>
> "wms_srs" "EPSG:32721"
>
> "wms_onlineresource"
> "http://localhost:80/cgi-bin/mapserv?map=/var/www/siiasgis/siiasgis.map";
>
> END
>
> END # Web
>
> REFERENCE
>
> EXTENT 366582.28125 6127927.0 858252.0625 6671738.5
>
> IMAGE "../../images/uruguay.jpg"
>
> SIZE 149 149
>
> COLOR -1 -1 -1
>
> OUTLINECOLOR 255 0 0
>
> END # Reference
>
> PROJECTION
>
> "init=epsg:32721"
>
> END
>
> #================== START OF LAYER SECTION =====================#
>
> LAYER
>
> NAME "ejes_pl_total"
>
> STATUS ON
>
> TYPE LINE
>
> DATA "ejes_pl_total"
>
> DUMP TRUE
>
> SIZEUNITS pixels
>
> PROJECTION
>
> "init=epsg:32721"
>
> END
>
> TOLERANCE 5
>
> TOLERANCEUNITS pixels
>
> CLASS
>
> STYLE
>
> OUTLINECOLOR 102 102 102
>
> WIDTH 2
>
> END
>
> NAME "Calles"
>
> TEMPLATE void
>
> END
>
> METADATA
>
> "description" "Calles"
>
> "wms_title" "ejes_pl_total"
>
> "wms_abstract" "ejes_pl_total"
>
> "wms_extent" "366582.290141166 6127927.10038269 858252.0151745
> 6671738.21181725"
>
> "gml_include_items" "all"
>
> "RESULT_FIELDS" "CODLOC,NOMBLOC,NOMBRE_INE,NOMBRE,DEPTO,COD_NOMBRE"
>
> "RESULT_HEADERS" "Codigo,Localidad,Nombre INE,Cod
> Departamento,Departamento"
>
> END
>
> END # Layer
>
> LAYER
>
> NAME "departamentos"
>
> STATUS ON
>
> TYPE POLYGON
>
> DATA "the_geom from departamentos USING UNIQUE id USING SRID=32721"
>
> CONNECTIONTYPE POSTGIS
>
> CONNECTION "user=xxxx password=xxxxx host=localhost port=5432 dbname=xxxx"
>
> DUMP TRUE
>
> OPACITY 100
>
> SIZEUNITS pixels
>
> TOLERANCE 5
>
> TOLERANCEUNITS pixels
>
> PROJECTION
>
> "init=epsg:32721"
>
> END
>
> CLASS
>
> STYLE
>
> OUTLINECOLOR 102 102 102
>
> WIDTH 3
>
> END
>
> NAME "Departamentos"
>
> TEMPLATE void
>
> END
>
> METADATA
>
> "description" "Departamentos"
>
> "wms_title" "departamentos"
>
> "wms_abstract" "departamentos"
>
> "wms_extent" "366582.290141166 6127927.10038269 858252.0151745
> 6671738.21181725"
>
> "gml_include_items" "all"
>
> "RESULT_FIELDS" "id,descripcion"
>
> "RESULT_HEADERS" "id,descripcion"
>
> END
>
> END # Layer
>
> END #Map
>
> ********************************************************************************************************************************
>
>
>
> Advertencia: Confidencialidad.- Este e-mail y todo archivo adjunto
> contiene información confidencial para un destinatario y con un
> propósito específico. La transmisión de esta información es privada y
> está protegida por ley. Si Usted no es el destinatario, o si duda que la
> información le haya sido enviada voluntariamente, queda de esta forma
> notificado que está estrictamente prohibida su difusión, copia o
> distribución. Sírvase abstenerse de la toma de cualquier acción basada
> en el contenido de esta información, excepto por la eliminación en forma
> permanente de este e-mail y todo archivo adjunto de su sistema, previo
> aviso al remitente, que desde ya se agradece.
>
> Warning: Confidentiality.- This e-mail, and any file transmitted with
> it, contains confidential information intended solely for the addressee
> and with a specific purpose. The privacy of this information and its
> transmission is protected by law. If you are not the addressee, or if
> you doubt that the information has been willfully sent, you are hereby
> notified that any disclosure, copy or distribution of it is strictly
> forbidden. Please refrain from taking any action based on the contents
> of this information, and after notifying the sender, delete permanently
> from your system this e-mail and any attached file.
------------------------------------------------------------------------------
All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-d2dcopy2
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
