[Qgis-developer] ogr2ogr vs shp2pgsql?

Gary Sherman sherman at mrcc.com
Wed Aug 1 09:48:08 EDT 2007

Hash: SHA1

On Jul 31, 2007, at 11:25 PM, Paolo Cavallini wrote:

> Hi all.
> AFAICU, the spit plugin uses ogr2ogr to convert shapefiles in  
> pg_dumps.
> This often throws errors, whereas the equivalent shp2pgsl (from  
> postgis)
> performs much better.
It doesn't use ogr2ogr, but rather the OGR libraries directly.

> I understand using ogr2ogr is much more general, and it could allow
> conversion between many different formats, but I believe the  
> efficiency
> improvement could justify this switch.
> Any thoughts?
SPIT was written as part of a student project and has never been  
revisited, although I made a few improvements to it. It could be  
worked on, or just turned into a front-end for shp2pgsql, although  
that tends to get messy when dealing with process calls for multiple  
platforms. My hunch is that it wouldn't take too much to solve the  
problems and make it more robust.

- -gary

- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
Gary Sherman
Chair, QGIS Project Steering Committee
Micro Resources: http://mrcc.com
   *Geospatial Hosting
   *Web Site Hosting
"We work virtually everywhere"
- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-

Version: GnuPG v1.4.7 (Darwin)


More information about the Qgis-developer mailing list