MySQL Forums
Forum List  »  GIS

Re: New openGIS functionality in MySQL available for testing
Posted by: Lenz Grimmer
Date: September 15, 2008 05:18AM

Hi Daniel,

sorry for the late reply.

Daniel Zburivsky Wrote:

> I'm testing new GIS functionality and would like
> to know how the DISTANCE function is currently
> implemented. Particularly, does it calculate
> distance on the Earth's surface?

It does not - DISTANCE() only works on flat surfaces. (As pointed out by John already). However, there now is a new UDF that implements what you are looking for - please take a look at my Blog posting for more info:



Lenz Grimmer - MySQL Community Relations Manager -
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten, DE
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels
Vorsitz d. Aufsichtsrates: Martin Haering AG Muenchen: HRB161028

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.