Hi Jochem. Thanks for sharing the fabulous post. I have a question that you could perhaps help me understand. I would like to create a spatial type in MySQL with 3 coordinate values (Northing, Easting, and Elevation). However, my understanding is the POINT data type is based off of 2 coordinates (X andY) which I suppose would work for the Northing and Easting values but how would I incorporate the Elevation value? I don’t necessarily think any type of multi-point is appropriate since it is just one location with a Northing, Easting, and elevation.

While I have a solid understanding of SQL (MySQL and Postgres) spatial database concepts are still foreign to me… Any advice, tips, or suggestions for documentation you have would be greatly appreciated.

Thanks again for the great article.