[postgis-users] Converting From MULTILINESTRINGM to MULTILINESTRING

[strk at refractions.net]

update <yourtable> set <youcolumn> = force_2d(<yourcolumn>);

--strk;

On Tue, Mar 21, 2006 at 04:26:02PM -0500, Bertand Revenaz wrote:
> Hi All,
> 
> I have been struggling with some dirty data from arcview, specifically a lot
> of the shapefiles had a thrid dimension, but it conntained no useful data. I
> am using this data with geoserver and it doesn't like multilinestringm
> types. How would I go about stripping out the third dimension. is there a
> way to do it in postgis or do I have to export all the geometries as text
> and grep them?
> 
> Thanks,
> 
> Bert

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 
----------------------------------------------------------------------
State-collected Geographic Data is public property !
Reject the INSPIRE directive.
Sign the petition: http://petition.publicgeodata.org