Re: [postgis-users] Problem with postgis querybypoint in mapserver-php
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 :
> 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@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > - Fin del mensaje reenviado -
> >
> >
> >
> > ___
> > postgis-users mailing list
> > postgis-users@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Problem with postgis querybypoint in mapserver-php
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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> - Fin del mensaje reenviado -
>
>
>
> ___
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Problem with postgis querybypoint in mapserver-php
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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
- Fin del mensaje reenviado -
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Problem with postgis querybypoint in mapserver-php
Hi,
first, I would like to apologize for possible confussions with my english or my
limitated knowledge of programming and the explanations on this.
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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
