ST_Force2D in SQL Server alternative ? 3D loading problems from QGIS to Postgis

by Greg   Last Updated June 13, 2019 09:22 AM

I have problems loading 3D layer from MSSQL in QGIS to PostGIS databes with QGIS. PostGIS data loader in DB Manager and other import tools in QGIS have problems with 3D export to Postgis. Since I don't need Z component i wanted to remove it. PostGIS has ST_Force2D function. I can't find such function for SQL server. Help ? I don't want to use external etl tools.Any suggestions ?



Related Questions


Updated October 15, 2018 13:22 PM

Updated February 26, 2016 04:09 AM

Updated January 15, 2019 20:22 PM

Updated August 03, 2018 12:22 PM

Updated December 11, 2018 10:22 AM