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

[Pedro Costa]

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...


>
> 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)....


>
> -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