[postgis-users] help setting up postgis

[Nicolas Ribot]

> Thank you Edward. It worked.
>
> Which now leads me to another question. I have datasets of the form "x y z".
> Which are location x,location y and elevation z to describe different
> bathymetries . What is the smartes way to store them so they can be easily
> worked with?
>
> Regards,
> Jan
>

Hi,

A 3D point seems to be the candidate.
You could also keep x, y, z as numeric columns to perform some
computation on the altitude, as postgis does not support 3d geometries
in all its functions.

You will be able to build the points using the st_makePoint(...) function.

Nicolas