Three Dimensional Points

[Pierre Herman]

Hi,

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.