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

strk at refractions.net strk at refractions.net
Sun Feb 5 17:28:51 PST 2006


On Sat, Feb 04, 2006 at 11:16:38PM -0800, Kevin Neufeld wrote:
> 
> > 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?

The arg to addGeometryColumn refers to 2D,3D,4D.
--strk;




More information about the postgis-users mailing list