[Qgis-developer] ogr2ogr vs shp2pgsql?

[Gary Sherman]

-----BEGIN PGP SIGNED MESSAGE-----
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"
- -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (Darwin)

iD8DBQFGsI8Y1zKuzV6goTgRAlh9AKCvvhMGHbcMr4RR5RA0PbFKUwauSwCgieWz
pMNk/1m2QqvqHrSX/OzdCWM=
=OXtq
-----END PGP SIGNATURE-----