[QGIS-trac] Re: [Quantum GIS] #3641: Bug in ShapeFile to postgis import Tool

[Quantum GIS]

#3641: Bug in ShapeFile to postgis import Tool
----------------------------------------+-----------------------------------
   Reporter:  mickael1                  |              Owner:               
       Type:  bug                       |             Status:  new          
   Priority:  minor: annoyance          |          Milestone:  Version 1.7.0
  Component:  Vectors                   |            Version:  Trunk        
   Keywords:  shapefile postigs import  |   Platform_version:  windows seven
   Platform:  Windows                   |           Must_fix:  No           
Status_info:  0                         |  
----------------------------------------+-----------------------------------

Comment(by mayeulk):

 Hi,
 I opened the dxf with TatukGIS viewer and I saw that it seems to be  a mix
 of polygons and linestring. Can you confirm this? You cannot combine these
 with AddGeometryColumn() under postgis, except on one condition. If I'm
 correct, the only way is with the
 GEOMETRYCOLLECTION type.

 But according to this: http://jira.codehaus.org/browse/GEOS-3726
 "Geometry collections cannot be stored in shapefiles, it's a limit of the
 file format".
 Can you share the shape file as well and detail exactly which geometry
 type you want to import?
 Does the shapefile display well under qgis?

 The version of the function used here is the one with 7 parameters:
 AddGeometryColumn(varchar catalog_name, varchar schema_name, varchar
 table_name, varchar column_name, integer srid, varchar type, integer
 dimension);

 The 6th one "$5" was 'NULL' (should contain the geometry type). Could that
 be related to the following?  "Geometry Collection class [...] Currently
 only implements empty collections" as seen in Java doc here:
 http://postgis.refractions.net/documentation/javadoc/org/postgis/GeometryCollection.html

-- 
Ticket URL: <http://trac.osgeo.org/qgis/ticket/3641#comment:2>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats