[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