[postgis-users] changing a non spatial table to a spatial talble

Kevin Neufeld kneufeld at refractions.net
Sat Feb 4 23:16:38 PST 2006


> Kirk R. Wythers wrote:
> > 3. ok... 3 questions, what does the 2 at the end of the select statement
> > refer to? Is that x and y?
> 
> The 2 means dimension = 2, ie X,Y. This is all documented in the postGIS
> reference manual which can be found on the postGIS site.
> 

Hmmmmm, according to the PostGIS documentation, "dimension" has nothing to
do with 2D, 3D, or 4D. Rather the dimension is the type of geometry, i.e. 0
for point, 1 for linear, 2 for polygonal.
http://postgis.refractions.net/docs/ch06.html#id2790699

And yet, the "Avoiding dimension conversion" section,
(http://postgis.refractions.net/docs/ch05.html#id2789845) talks about
dimension(...) in the context of 2D, 3D or 4D. 

So which is it?

Cheers,
Kevin





More information about the postgis-users mailing list