Hello,
we have a large Multipolygon Shapefile and try to load it from QGIS into
PostGIS via the SPIT-Plugin. The file is recognized only as MULTINULL while it
should be MULTIPOLYGON.
SELECT AddGeometryColumn('public','PA-Prop','the_geom',32617,'MULTINULL',2)
ERROR: Invalid type name - valid ones are:
GEOMETRY, GEOMETRYCOLLECTION, POINT,
MULTIPOINT, POLYGON, MULTIPOLYGON,
LINESTRING, MULTILINESTRING,
GEOMETRYCOLLECTIONM, POINTM,
MULTIPOINTM, POLYGONM, MULTIPOLYGONM,
LINESTRINGM, or MULTILINESTRINGM
CONTEXT: SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 ,
$6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at select into variables
There might be some error with Geometry, though the file works fine in QGIS and
ArcGIS. Anyone had this problem before and might know something about it?
We are using:
PostGIS
Library: 1.1.6
Scripts: 1.1.6
GEOS: 3.0.0-CAPI-1.4.1
Proj: Rel. 4.6.0, 21 Dec 2007
PostgreSQL 8.1.19 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20061115
(prerelease) (Debian 4.1.1-21)
Thank you very much!
Florian
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
