[postgis-users] What dimension number should be used when using AddGeometryColumn?

Sandro Santilli strk at keybit.net
Tue Sep 27 08:16:15 PDT 2011


On Tue, Sep 27, 2011 at 09:08:35AM -0600, Kenneth Xu wrote:

> The PostGIS document says the dimension number can be 2, 3, 4.
> 2 is for 2D like Point(x,y).
>  
> If I want to create a table for pointm (x,y,m), what number should be used? 2, or 3?
> If I want to create a table for point (x,y,z), what dimension number should be used? 3?

You use dimension number 3 for both, and the type would distinguish
(eg: POINT vs POINTM)

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html



More information about the postgis-users mailing list