I have CAD-data which I transformed to shapefiles. Currently after the transformation the objects still have a
Z value which is useless to me.
My question is: How do I convert a
MultiLineStringZ-object to a
There is a ST_Force2d function in PostGIS which does the job. A new table should be created with 2D geometry and use an insert statement with select to populate the new table:
insert into new_table (geom, col1, col2, col3) select ST_Force2D(geom), col1, col2, col2 from old_table;
You should substitute your real column names into col1, col2, ... You can query the table structure with in psql
or you can use pgadmin with GUI.
drop z values algorithm from the QGIS processing toolbox