[postgis-users] Optimizing DATA queries

Pavel Iacovlev iacovlev.pavel at gmail.com
Thu Dec 11 09:13:23 PST 2008


Good day all

At the moment I use the following logic for LINES::
I have the pixel width and pixel height in meters and I check if the
perimeter of the geometry bbox is greater then the pixel perimeter, on each
MAP request.

POLYGONS:
st_simplify and check if the geom perimeter is greater then a pixel on map ?

POINTS
Only 1 point in X radius, any example for such a query ?

Can you share any other ways to reduce the INPUT data to mapserver taking in
consideration you know the scale ?

-- 
http://iap.md, The future is open
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081211/02aba6ac/attachment.html>


More information about the postgis-users mailing list