[postgis-users] Reducing geometry type's dimensions

[Fred Lehodey]

http://postgis.refractions.net/docs/ST_Force_2D.html

Fred


On Mon, Aug 29, 2011 at 7:51 PM, Aren Cambre <aren at arencambre.com> wrote:

> 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
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110829/e9a355c1/attachment.html>