[QGIS-trac] Re: [Quantum GIS] #747: importing 3D geom into PostGIS via SPIT plugin

[Quantum GIS]

#747: importing 3D geom into PostGIS via SPIT plugin
----------------------------------------------------+-----------------------
        Reporter:  pcavallini                       |         Owner:  nobody               
            Type:  bug                              |        Status:  new                  
        Priority:  minor: annoyance or enhancement  |     Milestone:  Version 1.2.0        
       Component:  SPIT                             |       Version:  HEAD                 
      Resolution:                                   |      Keywords:  PostGIS 3D shapefiles
Platform_version:                                   |      Platform:  All                  
        Must_fix:  No                               |   Status_info:  0                    
----------------------------------------------------+-----------------------
Changes (by lutra):

 * cc: pcav (added)
  * milestone:  Version 1.0.3 => Version 1.2.0

Comment:

 I made a quick test with the data available here

 http://download.gfoss.it/Merano/

 and this is the result:


 SPIT fails to export this 3d shapes to postgis with the following error


 {{{
 Problem inserting features from file:
 /home/gio/Desktop/f05aa_UTM/f05aa_UTM.shp
 The database gave an error while executing this SQL:
 INSERT INTO "public"."f05aa_UTM" VALUES(0,'
 51108','3','11','2003/09/06','10','1000','
 405353','21051',NULL,NULL,NULL,NULL,'          0','0',... (rest of SQL
 trimmed)
 The error was:
 ERROR:  date/time field value out of range: "0000/00/00"
 HINT:  Perhaps you need a different "datestyle" setting.
 }}}


 Postgis Manager is able to export to Postgis without errors just one one
 of these four shapfiles.

 With the other three the error that is returned is

 {{{
 geometry contains non-closed rings
 }}}

 Beside this error, two layers do appear in postgis (but with missing
 features).

 All the three layers that are imported totally or partially in Postgis can
 be visualized by qgis.

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