The polygon is the bounding box of the image that you requested.
Mapserver only needs the geometries the cross of the map image and this
is what the where clause is doing.
Why do you thin this is not correct? What does the top of you mapfile
look like and what does this LAYER definition look like?
-Steve W
On 3/13/2013 1:12 PM, Pedro Costa wrote:
Thanks to all.
The problem is the query.despite don't give me any error returns 0
features...
This happens because the 'where with the polygon' [1]...
Anybody knows the origin of that polygon?
select encode(ST_AsBinary(ST_Force_2D("the_geom"),'NDR'),'hex') as
geom,"n_rua"
from ruas
where the_geom && GeomFromText('POLYGON((88071.2044330519
122184.53,88071.2044330519 124022.08,91531.2955669481
124022.08,91531.2955669481 122184.53,88071.2044330519 122184.53))',27492)
Em 13-03-2013 16:54, Carlo Pelliconi escreveu:
I think like others that the problem could be in srid definition.
Remember that you need to define an srid for the mapfile and an srid
for each layer in the mapfile.
When using postgis connectiontype I also put "using
srid=yourPostGisLayerSrid" in the DATA sql statement of the layer
(mandatory? I don't know, but it works)
Hope this helps.
Best Regards, Carlo
Il 13/03/2013 12:40, Pedro Costa ha scritto:
Hi guys,
I have one mapfile with conections to postgis layers and one raster.
My problem is that the layers from postgis don't show up...If i make
the request without the raster i got only white images...
I have the debug level in 5 and I got no erros in all logs (including
apache)...
The permissions of the database are correct because I tried accessing
with qgis and it worked fine. I'm also try specified the projection
("using srid = 27493") but without sucess...
I'm also tried add one of the Iayers of db but from a shape and
worked fine...
Furthermore, very strange is that when I try to run mapfile with
pmapper, I can search for attributes and zoom to the correct areas
(despite can't see geometries) ...
Anybody have an idea?
Thanks
SO: Ubuntu server
MapServer version 6.0.1
_______________________________________________
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
