[mapserver-users] postgis layers don't show up

[Pedro Costa]

Yes, i confirmed that right now, its the bb but i don't understand the 
problem because in other server (with the same coordinates) this works fine.
i'm also confirmed the extent in qgis and its correct...


my mapfile top data:

EXTENT  88386.2 122329.41 91216.3 124022.08
UNITS meters
SIZE 500 500
SHAPEPATH "shape"
SYMBOLSET "../common/symbols/symbols-pmapper.sym"
FONTSET "../common/fonts/msfontset.txt"
RESOLUTION 96
IMAGETYPE png
INTERLACE OFF

PROJECTION
    "init=epsg:27493"

END



my layer:


LAYER
     NAME "ruas"
     STATUS DEFAULT
     DEBUG 5
     TYPE LINE
     CONNECTIONTYPE postgis
     PROCESSING "CLOSE_CONNECTION=DEFERl"
     CONNECTION "user=pedro password=****** dbname=norte host=localhost 
options='-c client_encoding=LATIN1'"
     DATA "the_geom from ruas using unique n_rua using srid=27493"
         TOLERANCE 3
     TOLERANCEUNITS pixels
     TEMPLATE void
         PROJECTION
     "init=epsg:27493"
    END
     METADATA
     "DESCRIPTION" "Ruas"
     "RESULT_FIELDS" "id"
     "RESULT_HEADERS" "id"

     "ows_title"      "Ruas "
         END  # Metadata
         CLASS
     Name 'ruas'
     COLOR 0 0 0
         END  # Class

   END














Em 13-03-2013 17:14, Stephen Woodbridge escreveu:
> 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 at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>>>
>>>>
>>>
>>>
>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users