Quantcast

Problem to query a postgis layer

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Problem to query a postgis layer

Paolo Mangraviti
Hi ti all,
I have a problem with postgis layer in ka-map. Layer is viewed
correctly, but on query a point of that layer, ka-map notify me an error:

Fatal error: [MapServer Error]: msQueryByPoint(): No matching record(s)
found. in /var/www/webgis/ka-map/htdocs/map_query_float.php on line 234

If I omit the TEMPLATE directive, no query is performed.

Layer specification in map file is:
#-------------------------------------------------------------------------------------------------------------------------------------------------------
     LAYER # Punti di Interesse :: Fontane
         CONNECTIONTYPE postgis
         CONNECTION "user=webgis password=******** dbname=sentieri
host=127.0.0.1"
         DATA "wpt from punto"
         FILTER "tipologia = 'Fontana'"

         TYPE POINT
         TOLERANCE 5
         STATUS ON

         NAME "Fontane e Sorgenti"
         GROUP "Fontane"
         LABELITEM "titoloMappa"

         TEMPLATE "../sample.html"

         CLASS
             NAME "Fontane"
             STYLE
                 SYMBOL "fontana"
                 OUTLINECOLOR 0 0 0
             END
             LABEL
                 POSITION uc
                 SIZE 7
                 COLOR 0 0 0
                 BACKGROUNDCOLOR 228 253 18
                 TYPE truetype
                 FONT arial
             END
         END


         METADATA
             "wms_title"                 "Fontane e Sorgenti"
             "imageformat"               "GIF"
             "queryable"                 "true"
             "max_extents"               "auto"
             "tile_source"               "redraw"
             "fields"                    "denominazione:Nome,quota:mt"
             "searchfield"               "denominazione"
             "identificativoSentiero"    "none"
         END
         PROJECTION
             "proj=utm"
             "ellps=WGS84"
             "datum=WGS84"
             "zone=33"
             "units=m"
             "south"
             "no_defs"
         END
     END
#-------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks a lot for support,

paolo mangraviti
_______________________________________________
ka-Map-users mailing list
[hidden email]
http://lists.maptools.org/mailman/listinfo/ka-map-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Problem to query a postgis layer

Antonio García
I sorry, I work with MS4W. Your project in MS4W is OK, I can't help you in Linux. Sorry.


Saludos,
-----------
Antonio García Benlloch

Correo:
[hidden email]
[hidden email]

Web:
http://personales.alumno.upv.es/~angarben

Antes de imprimir este mensaje, asegúrese de que es necesario. Proteger el medio ambiente está en nuestra mano.

Este mensaje y sus archivos adjuntos son confidenciales. No está permitida su reproducción o distribución sin la autorización expresa de Antonio García. Si ha recibido este mensaje por error, por favor bórrelo e informe a [hidden email].





> From: [hidden email]
> Subject: ka-Map-users Digest, Vol 66, Issue 4
> To: [hidden email]
> Date: Wed, 15 Dec 2010 14:34:17 -0500
>
> Send ka-Map-users mailing list submissions to
> [hidden email]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.maptools.org/mailman/listinfo/ka-map-users
> or, via email, send a message with subject or body 'help' to
> [hidden email]
>
> You can reach the person managing the list at
> [hidden email]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of ka-Map-users digest..."
>
>
> Today's Topics:
>
> 1. Re: ka-Map-users Digest, Vol 66, Issue 2 (Paolo Mangraviti)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 15 Dec 2010 20:33:46 +0100
> From: Paolo Mangraviti <[hidden email]>
> Subject: Re: [ka-Map-users] ka-Map-users Digest, Vol 66, Issue 2
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> In the application there are other layer postgis (ie. Toponimi, quote
> ecc.), but only "Fontane" layer is queryable. The layer "Sentieri" with
> Shape file data is queryable correctly.
> If i change toponimi layer to queryable, the system notify me error.
> Error only with postgis layer in query mode.
> I attach the map_query_float.php
>
> Saluti, thanks
>
> paolo mangraviti
>
> On 15/12/2010 10:17, Antonio Garc?a wrote:
> > Can you do any query in other point layer? Is only in this layer or in
> > all the project?
> >
> > Send us you map_query_float.php
> >
> > Saludos,
> > -----------
> > Antonio Garc?a Benlloch
> >
> > *Correo:
> > *[hidden email]
> > [hidden email] <mailto:[hidden email]>
> >
> > *Web:
> > *http://personales.alumno.upv.es/~angarben
> >
> > Antes de imprimir este mensaje, aseg?rese de que es necesario.
> > Proteger el medio ambiente est? en nuestra mano.
> >
> > Este mensaje y sus archivos adjuntos son confidenciales. No est?
> > permitida su reproducci?n o distribuci?n sin la autorizaci?n expresa
> > de Antonio Garc?a. Si ha recibido este mensaje por error, por favor
> > b?rrelo e informe a [hidden email] <mailto:[hidden email]>.
> >
> >
> >
> >
> >
> > > From: [hidden email]
> > > Subject: ka-Map-users Digest, Vol 66, Issue 2
> > > To: [hidden email]
> > > Date: Tue, 14 Dec 2010 12:00:02 -0500
> > >
> > > Send ka-Map-users mailing list submissions to
> > > [hidden email]
> > >
> > > To subscribe or unsubscribe via the World Wide Web, visit
> > > http://lists.maptools.org/mailman/listinfo/ka-map-users
> > > or, via email, send a message with subject or body 'help' to
> > > [hidden email]
> > >
> > > You can reach the person managing the list at
> > > [hidden email]
> > >
> > > When replying, please edit your Subject line so it is more specific
> > > than "Re: Contents of ka-Map-users digest..."
> > >
> > >
> > > Today's Topics:
> > >
> > > 1. Problem to query a postgis layer (Paolo Mangraviti)
> > >
> > >
> > > ----------------------------------------------------------------------
> > >
> > > Message: 1
> > > Date: Tue, 14 Dec 2010 14:04:52 +0100
> > > From: Paolo Mangraviti <[hidden email]>
> > > Subject: [ka-Map-users] Problem to query a postgis layer
> > > To: [hidden email]
> > > Message-ID: <[hidden email]>
> > > Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> > >
> > > Hi ti all,
> > > I have a problem with postgis layer in ka-map. Layer is viewed
> > > correctly, but on query a point of that layer, ka-map notify me an
> > error:
> > >
> > > Fatal error: [MapServer Error]: msQueryByPoint(): No matching record(s)
> > > found. in /var/www/webgis/ka-map/htdocs/map_query_float.php on line 234
> > >
> > > If I omit the TEMPLATE directive, no query is performed.
> > >
> > > Layer specification in map file is:
> > >
> > #-------------------------------------------------------------------------------------------------------------------------------------------------------
> > > LAYER # Punti di Interesse :: Fontane
> > > CONNECTIONTYPE postgis
> > > CONNECTION "user=webgis password=******** dbname=sentieri
> > > host=127.0.0.1"
> > > DATA "wpt from punto"
> > > FILTER "tipologia = 'Fontana'"
> > >
> > > TYPE POINT
> > > TOLERANCE 5
> > > STATUS ON
> > >
> > > NAME "Fontane e Sorgenti"
> > > GROUP "Fontane"
> > > LABELITEM "titoloMappa"
> > >
> > > TEMPLATE "../sample.html"
> > >
> > > CLASS
> > > NAME "Fontane"
> > > STYLE
> > > SYMBOL "fontana"
> > > OUTLINECOLOR 0 0 0
> > > END
> > > LABEL
> > > POSITION uc
> > > SIZE 7
> > > COLOR 0 0 0
> > > BACKGROUNDCOLOR 228 253 18
> > > TYPE truetype
> > > FONT arial
> > > END
> > > END
> > >
> > >
> > > METADATA
> > > "wms_title" "Fontane e Sorgenti"
> > > "imageformat" "GIF"
> > > "queryable" "true"
> > > "max_extents" "auto"
> > > "tile_source" "redraw"
> > > "fields" "denominazione:Nome,quota:mt"
> > > "searchfield" "denominazione"
> > > "identificativoSentiero" "none"
> > > END
> > > PROJECTION
> > > "proj=utm"
> > > "ellps=WGS84"
> > > "datum=WGS84"
> > > "zone=33"
> > > "units=m"
> > > "south"
> > > "no_defs"
> > > END
> > > END
> > >
> > #-------------------------------------------------------------------------------------------------------------------------------------------------------
> > >
> > > Thanks a lot for support,
> > >
> > > paolo mangraviti
> > >
> > >
> > > ------------------------------
> > >
> > > _______________________________________________
> > > ka-Map-users mailing list
> > > [hidden email]
> > > http://lists.maptools.org/mailman/listinfo/ka-map-users
> > >
> > >
> > > End of ka-Map-users Digest, Vol 66, Issue 2
> > > *******************************************
> >
> >
> > _______________________________________________
> > ka-Map-users mailing list
> > [hidden email]
> > http://lists.maptools.org/mailman/listinfo/ka-map-users
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://lists.maptools.org/pipermail/ka-map-users/attachments/20101215/10ed9ab3/attachment.htm
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: map_query_float.php
> Type: application/x-httpd-php
> Size: 13367 bytes
> Desc: not available
> Url : http://lists.maptools.org/pipermail/ka-map-users/attachments/20101215/10ed9ab3/attachment.php
>
> ------------------------------
>
> _______________________________________________
> ka-Map-users mailing list
> [hidden email]
> http://lists.maptools.org/mailman/listinfo/ka-map-users
>
>
> End of ka-Map-users Digest, Vol 66, Issue 4
> *******************************************

_______________________________________________
ka-Map-users mailing list
[hidden email]
http://lists.maptools.org/mailman/listinfo/ka-map-users
Loading...