[OSM-dev] projection for calculating distances in PostGIS

Emilie Laffray emilie.laffray at gmail.com
Wed May 19 16:39:22 BST 2010

On 19 May 2010 16:29, Stephen Cavilia <ailivac at gmail.com> wrote:

> This is what I would do. Calculate a rough lat-lon bounding box that
> approximates the area you want, filter any features that intersect that
> box, then reproject just those into UTM for calculating the actual
> distances. Or a more accurate geodesic/great circle distance, but UTM
> will be close enough over relatively small areas.

Else I would strongly suggest you have a look at Postgis 1.5 and the
geography type.

Emilie Laffray
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20100519/d2c5ceb7/attachment.html>

More information about the dev mailing list