[postgis-devel] [PostGIS] #231: New distance-calculations proposal
PostGIS
trac at osgeo.org
Sat Oct 17 09:20:03 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):
For what its worth. The above example is using Mass State Plane feet (not
meters), so from my perspective the difference is even less significant.
An the exercise I did this on (150,000 parcel distance from a line, I
think this accounted for 25000 records. The others were exactly the same).
I suspect it will change from platform to platform and possibly even the
GCC version you compile with.
I think any regress test we do will take into consideration some sort of
tolerance and we'll need to decide what that is. I was thinking to judge
the rightness of each, we should probably run the same test against
another spatial database like SQL Server or Oracle or IBM DB2 (preferably
all 3) and see what their distance measurements come up with.
I can try the same exercise loading the data into SQL Server and possibly
Oracle to see how far those are from these. I'm curious myself to see how
far our distance calculations compare to other databases.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/231#comment:14>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS
More information about the postgis-devel
mailing list