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 <[email protected]> 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: >> [email protected] >> [mailto:[email protected]] 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: >>> [email protected] >>> [mailto:[email protected]] 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 [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>> >>> >> _______________________________________________ mapserver-users >> mailing list [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> _______________________________________________ mapserver-users >> mailing list [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
