[postgis-users] Reducing geometry type's dimensions

Aren Cambre aren at arencambre.com
Mon Aug 29 18:56:43 PDT 2011


Thank you!

Aren

On Mon, Aug 29, 2011 at 2:14 PM, Fred Lehodey <lehodey at gmail.com> wrote:

> 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
>>
>>
>
> _______________________________________________
> 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/37e53808/attachment.html>


More information about the postgis-users mailing list