[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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] PostGIS Layer : get only objects WITHIN view
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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
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-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users