[postgis-devel] [PostGIS] #137: ST_ShortestLine, ST_LongestLine, ST_max_distance, ST_DFullyWithin

PostGIS trac at osgeo.org
Mon Jul 20 23:08:32 PDT 2009


#137: ST_ShortestLine, ST_LongestLine, ST_max_distance, ST_DFullyWithin
------------------------------------+---------------------------------------
  Reporter:  post... at jordogskog.no  |       Owner:  robe         
      Type:  enhancement            |      Status:  assigned     
  Priority:  medium                 |   Milestone:  postgis 1.5.0
 Component:  postgis                |     Version:               
Resolution:                         |    Keywords:               
------------------------------------+---------------------------------------
Comment (by robe):

 Update -- I mustered enough patience to wait

  --yields  -- 745222.745755735 meters - 90407ms
    SELECT a.state As st_a, b.state As st_b, ST_Distance(a.the_geom,
 b.the_geom) As dist_m
   FROM states AS a
                 CROSS JOIN states AS b
  WHERE a.state = 'California' and b.state = 'Texas';

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


More information about the postgis-devel mailing list