[postgis-users] Converting From MULTILINESTRINGM to MULTILINESTRING

strk at refractions.net strk at refractions.net
Tue Mar 21 13:30:10 PST 2006

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


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

More information about the postgis-users mailing list