Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Shapefiles can often contain geometries that have a large number of decimal places. There are examples of them going to 15 decimal places which, in metres, is getting into the atomic scale. PostgreSQL doesn’t support decimal places that far so to load them you need to provide an additional Additional parameter: -lco PRECISION=NO that tells OGR to ignore the decimal places beyond which PostgreSQL supports. It’s a common issue with moving shapefiles Shapefiles into PostgreSQL.

Step-by-step guide

  1. Open iShare Studio and locate the Shapefile task Task that has the issue.

  2. Add the additional parameter Tick the Show expert mode and then add the following into the Additional parameters -lco PRECISION=NO to your task Task as shown below.

...

3. Leave the task Task to be run as scheduled or run it manually and check the error is gone.