Is there an option in OGR2OGR to repair geometry when importing data to PostGIS?

by Pil Kwon   Last Updated December 07, 2017 10:22 AM

this is related to one of my questions here Invalid Geometry in PostGIS but Valid in FGDB

If I could, I want to repair geometry while I am importing my data to PostGIS. So I wrote this code below on OSgeo4W Shell

ogr2ogr -overwrite -progress -f "PostgreSQL" PG:"host=localhost port=5432 dbname=test user=test password=test" D:\FGDB_Edit\OCEAN.gdb -lco GEOMETRY_NAME=shape -t_srs EPSG:3857 -nln ocean_repair -dialect sqlite -sql "select ST_MakeValid(Shape) as geometry, * from ocean_boundary"

and it gives me this error enter image description here

have you experienced this before? and have any solutions?

Related Questions

ogr2ogr CAD file to postgres

Updated June 12, 2017 13:22 PM

Loading GML data into Postgres - No geom!

Updated March 31, 2017 14:22 PM

Ogr2ogr: ERROR 1: Unable to find driver `PostgreSQL'

Updated November 17, 2017 10:22 AM