I'm trying to import a shapefile into a PostGIS database using the graphical importer. I just installed PostgreSQL, and PostGIS.
The error:
Shapefile type: Polygon
PostGIS type: POLYGON[2]
We have a Multipolygon with 2 parts, can't use -S switch!
Shapefile import failed
After testing that my database worked, I chose the shapefile that I wanted to upload, and then received a message that it had failed to import.
Are there any good tutorials or instructions about how to do this?
I would recommend you to read this shp2pgsql_usage and this tutorial about loading spatial data.
As you see, -S key would try to generate simple geometries instead of MULTI geometries. BUT Will only succeed if all the geometries are actually single. Your case is multipolygon with 2 parts, so do not use -S.
When trying to import Multigeometries, I usually check Generate simple geometries instead of MULTI geometries in the Options (subsection 6 in the tutorial) so import is successful.
