[OSM-dev] projection for calculating distances in PostGIS

[Emilie Laffray]

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.
>

+1
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>