Changes between Version 1 and Version 2 of UsersWikiNewbieDistanceMeasurement


Ignore:
Timestamp:
Apr 15, 2009, 8:04:18 AM (15 years ago)
Author:
pracine
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiNewbieDistanceMeasurement

    v1 v2  
    3131
    3232{{{
    33 SELECT ST_Distance_Spheroid(
    34        ST_GeomFromText('POINT(5.0 52.0)', 4326),
    35        ST_GeomFromText('POINT(6.0 56.0)', 4326),
    36          'SPHEROID[wiki:UsersWiki"WGS 84",6378137,298.257223563 "WGS 84",6378137,298.257223563]'
    37      );
     33SELECT  ST_Distance_Spheroid(
     34        ST_GeomFromText('POINT(5.0 52.0)', 4326),
     35        ST_GeomFromText('POINT(6.0 56.0)', 4326),
     36         'SPHEROID["WGS 84",6378137,298.257223563]'
     37     ) ;
    3838
    39 SELECT ST_Distance_Spheroid(t1.the_geom, t2.the_geom,  'SPHEROID[wiki:UsersWiki"WGS 84",6378137,298.257223563 "WGS 84",6378137,298.257223563]')
     39SELECT ST_Distance_Spheroid(t1.the_geom, t2.the_geom,  'SPHEROID["WGS 84",6378137,298.257223563]')
    4040FROM t1 INNER JOIN t2 ON t1.somefield1 = t2.somefield2;
    4141