[mapserver-users] PostGIS Layer : get only objects WITHIN view

[Paul Ramsey]

Use the PostGIS !BOX! hack. It's described on the postgis mapserver page.

http://mapserver.org/input/vector/postgis.html

P

On Tue, Jul 20, 2010 at 5:46 PM, Stephen Woodbridge
<woodbri at swoodbridge.com> wrote:
> Maybe something like this would work for you:
> http://trac.osgeo.org/mapserver/ticket/2129
>
> I did this a few years ago for a client but it was between Oracle developers
> and never got put in the trunk code. I don't work with an Oracle instance at
> the moment but there is a patch and you might be able to adapt it to your
> needs.
>
> -Steve W
>
> Lime, Steve D (DNR) wrote:
>>
>> Nope, that's the issue, there's no magic variable for the map extent
>> nor is there a processing option. I suspect this would be lightly
>> used (since it's never been asked for before). Runtime subs may be
>> your best option. Depends on how accurate your extent is when it's
>> passed, that is, does MapServer have to adjust it. You could probably
>> hack this easily, pass the hack along so it gets to 6.0.
>>
>> Steve
>>
>> -----Original Message----- From:
>> mapserver-users-bounces at lists.osgeo.org
>> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of
>> Guillaume Sueur Sent: Thursday, July 15, 2010 6:31 PM To:
>> Mapserver-users Subject: Re: [mapserver-users] PostGIS Layer : get
>> only objects WITHIN view
>>
>> Hi Steve,
>>
>> Ok for the CONTAINS thing, but what is supposed to contain my geom
>> field ? Is there a magic variable like %MAP_EXTENT% usable in the
>> mapfile ?
>>
>> Regards
>>
>> Guillaume
>>
>> Le 15/07/2010 21:40, Lime, Steve D (DNR) a écrit :
>>>
>>> I'd think you'd need to use one of the spatial operators like
>>> "contains" in your data statement. However, you'd need access to
>>> the computed map extent to be able to do so. There's another thread
>>> related to this topic but with the computed scale.
>>>
>>> Steve
>>>
>>> -----Original Message----- From:
>>> mapserver-users-bounces at lists.osgeo.org
>>> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of
>>> Guillaume Sueur Sent: Thursday, July 15, 2010 9:48 AM To:
>>> Mapserver-users Subject: [mapserver-users] PostGIS Layer : get only
>>> objects WITHIN view
>>>
>>> Hi list,
>>>
>>> I was wondering if there was an efficient way to display only
>>> objects fully included inside the map viewport. I could mess around
>>> with runtime substitution, but as bbox is already sent, I think
>>> there is a way to use it inside my DATA string.
>>>
>>> Thanks for your clues
>>>
>>> Guillaume _______________________________________________ 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
>