[postgis-devel] [PostGIS] #231: New distance-calculations proposal

PostGIS trac at osgeo.org
Sun Oct 18 22:53:49 PDT 2009


#231: New distance-calculations proposal
--------------------------+-------------------------------------------------
  Reporter:  nicklas      |       Owner:  robe         
      Type:  enhancement  |      Status:  assigned     
  Priority:  medium       |   Milestone:  postgis 1.5.0
 Component:  postgis      |     Version:               
Resolution:               |    Keywords:               
--------------------------+-------------------------------------------------
Comment (by robe):

 Interesting SQL Server also agrees with our original distance calculation.
 I was really expecting the last set of digits to be different just because
 I assume their algorithm most be slightly differnt.  Hmm -- I really
 should get my Oracle box up.  I thought these things would be different in
 the last digits unless everyone in the world has decided on a standard way
 of calculating these things.

 SELECT Geometry::STGeomFromText('POINT(774983.955351382
 2949487.72566304)',2249).STDistance(Geometry::STGeomFromText('LINESTRING(775212.698335966
 2948028.5564237,775121.04258857 2950068.84568561)',2249));

 Gives:
 163.028426002135


 But Like you said nicklas -- those numbers at the end are kind of
 irrelevant.  I'm not up with IEEE stuff so can't comment on what either of
 you are saying.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/231#comment:20>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS


More information about the postgis-devel mailing list