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

PostGIS trac at osgeo.org
Fri Aug 7 06:38:17 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):

 Yah still have to pass it thru my torture tester.  By the way -- for the
 sampling of 4 parcels I did against the 15 neighborhoods (60 records)

  SELECT n.name, l.pid, ST_Distance(l.the_geom, n.the_geom) As dist
  from boston.nei As n CROSS JOIN boston.sample_land As l
  ORDER BY l.pid, n.name;

 Yours completes (1.5 with dist patch) in 47 ms
 The postgis 1.4 (no dist patch) completes in 593 ms and returns the same
 answer.

 So I'm pretty excited so far.  Well we will see after I test against every
 permutation of geometry types.  The above were just largish multipolygon
 against small polygon

 Thanks,
 Regina

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


More information about the postgis-devel mailing list