[postgis-users] Reducing geometry type's dimensions

[Aren Cambre]

Did I stump everybody? :-)

Aren

On Sun, Aug 28, 2011 at 3:05 PM, Aren Cambre <aren at arencambre.com> wrote:

> I was trying to copy a geometry data type from one table to another, but I
> got a *enforce_dims_the_geom* error.
>
> I looked at the *geometry_columns* table, and turns out the source table
> has a 4-dimensional field and the destination table has a 2-dimensional
> field. Both fields have srid 3081, and they are both of type point.
>
> The source table is an import from a SHP using shp2pgsql, so I guess the
> 4-dimensionality was created at import time? I don't know why it's 4
> dimensions; all its points only exist in a 2-dimensional plane.
>
> How can I remove the two extraneous dimensions while I copy this geometry
> object from one table to another?
>
> Aren
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110829/39bfae9f/attachment.html>