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

[Stephen Woodbridge]

I should be able to get the SQL query that mapserver is sending to 
postgresql. I would copy and paste is into pgadmin sql window and try it 
there. Then you can play with the sql to see what is going on.

More than likely you have the wrong projection so something else 
similar. I use this in a lot of my mapfiles as do others so it is not a 
bug in the code. Also make sure you have not flipped long-lat to 
lat-long or something like that.

-Steve

On 3/13/2013 11:20 AM, Yves Jacolin (Free) wrote:
> Hum, are you sure about your projection or the bbox requested?
>
> MapServer send the request to Postgresql but get 0 record.
>
> Y.
> Le mercredi 13 mars 2013 14:50:01 Pedro Costa a écrit :
>> Ok, i got some information [1]....
>>
>> I can see that mapserver tried get the layers....But no errors, i think...
>>
>>
>> [1] http://pastebin.com/fmnBLWcw
>>
>> Em 13-03-2013 12:53, Yves Jacolin (Free) escreveu:
>>> Hello,
>>>
>>> Could you try to add:
>>> DEBUG 5
>>>
>>> in the LAYER object. You can find some useful information in the mapserver
>>> log and see the request sent by MapServer.
>>>
>>> Regards,
>>>
>>> Y.
>>>
>>> Le mercredi 13 mars 2013 12:26:31 Pedro Costa a écrit :
>>>> Hi,
>>>>
>>>> Yes, sure...
>>>> No, nothing about the table....
>>>>
>>>> Thanks
>>>>
>>>>
>>>> LAYER
>>>>
>>>>        NAME "ruas"
>>>>        STATUS DEFAULT
>>>>        TYPE LINE
>>>>        CONNECTIONTYPE postgis
>>>>        PROCESSING "CLOSE_CONNECTION=DEFER"
>>>>        CONNECTION "user=pedro password=****** dbname=norte host=localhost
>>>>
>>>> options='-c client_encoding=LATIN1'"
>>>>
>>>>        DATA "the_geom from ruas using unique n_rua using srid=27492"
>>>>
>>>>            TOLERANCE 3
>>>>
>>>>        TOLERANCEUNITS pixels
>>>>        TEMPLATE void
>>>>
>>>>            PROJECTION
>>>>
>>>>        "init=epsg:27492"
>>>>
>>>>       END
>>>>
>>>>        METADATA
>>>>        "DESCRIPTION" "Ruas"
>>>>        "RESULT_FIELDS" "n_rua"
>>>>        "RESULT_HEADERS" "ID"
>>>>
>>>>          "ows_title"      "Ruas"
>>>>
>>>>            END  # Metadata
>>>>            CLASS
>>>>
>>>>        Name 'ruas'
>>>>        COLOR 0 0 0
>>>>
>>>>            END  # Class
>>>>
>>>>      END
>>>>
>>>> Em 13-03-2013 12:21, Yves Jacolin (Free) escreveu:
>>>>> Hello,
>>>>>
>>>>> Could you post you layer object from your mapfile?
>>>>>
>>>>> Does the log says something about  your postgis table?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Y.
>>>>>
>>>>> Le mercredi 13 mars 2013 11:40:29 Pedro Costa a écrit :
>>>>>> 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
>