[postgis-users] Problem with postgis querybypoint in mapserver-php

[Guillermo Tamburini Beliveau]

Thank you very much!

I have tried a lot of thigs, but I will test your ideas. And as I said, nobody
responded me in the Mapserver list.

Relly thank you for you response!

Guillermo

Mensaje citado por Ben Madin <lists at remoteinformation.com.au>:

> Guillermo,
>
> MapServer is the proper list for this question, but you haven't given much
> information on what is a complex issue... and I can't help you directly with
> it I'm sorry, but it might help if you gave a bit more information.
>
> Are you getting a map? Is the data correctly displayed? You could get
> attribute data either from the data in your query (use * in the format below
> if in doubt) or if you take the gid and look it up separately.
>
> The MapServer Docs at http://mapserver.org/input/vector/postgis.html show an
> example of a query:
>
> CONNECTIONTYPE POSTGIS
> CONNECTION "dbname=yourdatabasename user=yourdbusername"
> DATA "the_geom from (select g.gid, g.the_geom, a.attr1, a.attr2 from geotable
> g join attrtable a on g.gid = a.aid) as subquery unique gid using srid=4326"
>
> A common mistake is a mismatch between the projection systems - are they both
> displayed?
>
> Have you been logging the php and MapServer output (DEBUG level 1 or more) to
> see what is happening when you click on a point?
>
> Having said that, I notice you have suppressed any error messages on
>
> >   @$qlayer->queryByPoint($point, MS_MULTIPLE, $radius);
>
> so you may not get much help from the php log.
>
> hopefully someone else might be able to help, good luck.
>
> cheers
>
> Ben
>
>
>
> On 17/05/2010, at 15:09 , Guillermo Tamburini Beliveau wrote:
>
> >
> > Hi,
> >
> > first, I would like to apologize for possible confussions with my english
> or my
> > limitated knowledge of programming and the explanations on this.
> >
> > And second, sorry if I insist, but I trided two times in the mapserver list
> and
> > now, the second time in this, and nobody responds me. please, if somebody
> knows
> > anything about my question, please say something. Thank you.
> >
> > I would ask to the list if someone knows the reason of a problem that I'm
> > having with the php-mapscript methods for the query methods in the postgis
> > layers.
> >
> > Indistinctly for querybypoint or querbyrectangle, my code (different
> versions of
> > it), works perfectly with shapes, but it always fails with the postgis
> layers.
> > When calling to the shapeindex member of the ResultCacheMemberObj obtained,
> it
> > always returns 0, as is contrary to what happens with the shapes, where it
> > always returns the correct shapeindex. Then, it is impossible to acces to
> the
> > desidered feature, and as you know, this are usal and simple actions.
> >
> > May I have to add more columns to the select of the .map file for getting
> the
> > features atributes like in the example (I don't think so)?
> >
> >    DATA "geom FROM puntos using unique gid"
> > #    DATA "geom FROM (select gid , nombre, tramo, geom from puntos) as foo
> using
> > unique geom"
> > #    DATA "geom FROM (select * from puntos) as foo using unique gid"
> >
> > Or there is some paramter in the configuration files of mapserver or php
> that I
> > have to change.
> >
> > There is the code of the function:
> >
> > function CercaPunto($point,$map,$radius) {
> >
> >      $qlayer = $map->getLayerByName('trazado');
> >     $qlayer->set("tolerance",$radius);
> >     @$qlayer->queryByPoint($point, MS_MULTIPLE, $radius);
> >     $numResults = $qlayer->getNumResults();
> >     if ($numResults != 0) {
> >          for ($i = 0; $i < $numResults; $i++) {
> >              $query_result = $qlayer->getResult($i);
> >               $Lista_ele[$i] = $query_result->shapeindex; // Here is the
> error
> > with postgres
> >          }
> >     } else {
> >          $valido =0;
> >          $Lista_ele = "";
> >     }
> >     return $Lista_ele;
> > } // end CercaPunto
> >
> >
> > Thank you very much.
> >
> > Guillermo Tamburini
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > ----- Fin del mensaje reenviado -----
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>