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

[Stephen Woodbridge]

On 3/13/2013 1:49 PM, Pedro Costa wrote:
> Em 13-03-2013 17:39, Stephen Woodbridge escreveu:
>> So What do you get in pgadmin or psql with:
>>
>> select count(*)
>>      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);
>
> nothing...count = 0...

This means there is some kind of disconnect between the data in the 
database and how you have it defined in the mapfile.

>>
>> select st_astext(st_extents(st_collect(the_geom))) from ruas;
>
> Previously i have compared the result of 'st_extent' with extent in
> mapfile and its the same....
> Your query with st_collects give me an error (ERROR:  aggregate function
> calls cannot be nested)....

Try:

select st_astext(st_extents(the_geom)) from ruas;

Once you get this you will have the min and max extents of the data in 
the database and you can compare that to the polygon above and see if it 
overlaps.

-Steve


>>
>> -Steve
>>
>>
>>
>> On 3/13/2013 1:22 PM, Pedro Costa wrote:
>>> 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
>>>
>>> _______________________________________________
>>> 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