I was trying to import Comunas.shp to PostgreSQL 9.4 by PostGIS Shapefile and DBF loader 2.1. I configured all like SRID (Argentina_GKBsAs -> 8333) and options like "create spatial index automatically after load", "Load data using COPY rather than INSERT" and "Generate simple geometries instead of MULTI geometries".
So, I ran it but appeared the following error:
Importing with configuration: comunas, public, geom, C:\Juan\Data_GIS_Shape\Nueva\comunas.shp, mode=c, dump=1, simple=1, geography=0, index=1, shape=1, srid=833Shapefile type: PolygonPostGIS type: POLYGON[2]Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;SET STANDARD_CONFORMING_STRINGS TO ON;BEGIN;CREATE TABLE "public"."comunas" (gid serial,"barrios" varchar(250),"perimetro" numeric,"area" numeric,"comunas" float8);ALTER TABLE "public"."comunas" ADD PRIMARY KEY (gid);S"Failed in pgui_exec(): ERROR: AddGeometryColumn() - invalid SRIDCONTEXT: sentencia SQL: «SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6,$7)»funci
أكثر...
So, I ran it but appeared the following error:
Importing with configuration: comunas, public, geom, C:\Juan\Data_GIS_Shape\Nueva\comunas.shp, mode=c, dump=1, simple=1, geography=0, index=1, shape=1, srid=833Shapefile type: PolygonPostGIS type: POLYGON[2]Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;SET STANDARD_CONFORMING_STRINGS TO ON;BEGIN;CREATE TABLE "public"."comunas" (gid serial,"barrios" varchar(250),"perimetro" numeric,"area" numeric,"comunas" float8);ALTER TABLE "public"."comunas" ADD PRIMARY KEY (gid);S"Failed in pgui_exec(): ERROR: AddGeometryColumn() - invalid SRIDCONTEXT: sentencia SQL: «SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6,$7)»funci
أكثر...