[Gfoss] Problema con ST_Distance_Sphere in PostGIS

[Niccolo Rigacci]

On Thu, Nov 19, 2009 at 04:22:38PM +0100, Stefano Salvador wrote:
> dalla documentazione:
> 
> 	
> This function currently does not look at the SRID of a geometry and
> will always assume its in WGS 84 long lat. Prior versions of this
> function only support points.


Ecco, infatti! Mi era sfuggita la nota!

Però on-line io leggo "WGS 80", è un refuso?
http://postgis.refractions.net/docs/ST_Distance_Sphere.html


Grazie a tutti, rapidissimi e attenti.

Ecco il risultato corretto:

SELECT ST_Distance_Sphere(
    ST_Transform(ST_PointFromText('POINT(1626216 4855458)', 3003), 4326),
    ST_Transform(ST_PointFromText('POINT(1626216 4855459)', 3003), 4326)
);
 st_distance_sphere
--------------------
    1.0009418016345

-- 
Niccolo Rigacci
Firenze - Italy