[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