[postgis-users] Confusing Distance

Paul Ramsey pramsey at cleverelephant.ca
Wed Dec 17 13:30:59 PST 2008


Yeah, north polar stereographic, not an optimal choice for Brazil :)

P

On Wed, Dec 17, 2008 at 12:53 PM, David William Bitner
<david.bitner at gmail.com> wrote:
> How did you chose to use 32661?  You should use an SRID that uses a
> projection that works well for the area that you are working in.
>
> On Wed, Dec 17, 2008 at 2:34 PM, sub3 <steve at subwest.com> wrote:
>>
>> Hi,
>> I was trying to calculate the distance (in NM) from two points.  I've
>> found
>> a method using distance_spheroid, but I am curious why my original method
>> didn't work correctly:
>>
>> select distance (
>>  transform( GeomFromText('Point(-76.29145663 -45.9229366415 )', 4269),
>> 32661),
>>  transform( GeomFromText('Point(-76.42922377 -45.2098919078 )', 4269),
>> 32661)
>> ) / 1852
>>
>> gives me 297 NM, but it is really a lot closer.  I thought distance()
>> would
>> return the number of meters, then I divide by the number of meters in a
>> NM.
>>
>> Thanks for any help.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Confusing-Distance-tp21060820p21060820.html
>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> --
> ************************************
> David William Bitner
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



More information about the postgis-users mailing list