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

[Andy Colson]

On 7/15/2010 9:47 AM, Guillaume Sueur wrote:
> 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

I think this is already done for you.  You should enable PG statement 
logging and watch the sql its running.  I've done this before and pretty 
sure any time mapserver queried a postgis layer it included the BBOX in 
the where clause.

-Andy