MySQL Forums
Forum List  »  GIS

Three Dimensional Points
Posted by: Pierre Herman
Date: September 01, 2007 02:16PM


I am pilot and I would like (just for myself) to get the data from my GPS and to store it in a mysql database for later analysis.

I was wondering if it is possible to define a point in three dimensions (latitude, longitude, altitude) with MySQL?

I am now storing the data in two different columns. The first one is of datatype DECIMAL(8,2) and contains the altitude in meters and the second column is of datatype POINT and contains the latitude and longitude.

Since my knowledge of the spatial functions is limited to the basics, please forgive me if I said (or will say) anything meaningless or stupid :)

Thanks in advance for your help.

Edited 2 time(s). Last edit at 09/01/2007 02:19PM by Pierre Herman.

Options: ReplyQuote

Written By
Three Dimensional Points
September 01, 2007 02:16PM

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.