Thank you! Aren
On Mon, Aug 29, 2011 at 2:14 PM, Fred Lehodey <leho...@gmail.com> wrote: > 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 > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
