http://postgis.refractions.net/docs/ST_Force_2D.html
Fred On Mon, Aug 29, 2011 at 7:51 PM, Aren Cambre <a...@arencambre.com> wrote: > Did I stump everybody? :-) > > Aren > > > On Sun, Aug 28, 2011 at 3:05 PM, Aren Cambre <a...@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 >> > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
