[GRASS-user] v.out.ogr performance

I don't want to beat a dead horse, and I know that this has been covered
to a degree on this list before, but is there any way to speed up the
export of a large vector layer (points in this case) to a shapefile? I
have 750,000 points and it looks like it will take a few hours to export.
This is with the attribute data stored in a PostgreSQL database.

I did build an index on the category field in the database, and I think it
helped to a degree, but I can't be certain that GRASS is even using the
index.

David Mahoney

David Mahoney wrote:

I don't want to beat a dead horse, and I know that this has been
covered to a degree on this list before, but is there any way to
speed up the export of a large vector layer (points in this case) to
a shapefile? I have 750,000 points and it looks like it will take a
few hours to export. This is with the attribute data stored in a
PostgreSQL database.

I did build an index on the category field in the database, and I
think it helped to a degree, but I can't be certain that GRASS is
even using the index.

v.out.ascii.db + ogr2ogr CSV -> Shapefile?
(wiki add-ons)

Some profiling is needed to understand why/where v.out.ogr is so very
slow to export to a shapefile.

Hamish

Hamish wrote:

David Mahoney wrote:
  

I don't want to beat a dead horse, and I know that this has been
covered to a degree on this list before, but is there any way to
speed up the export of a large vector layer (points in this case) to
a shapefile? I have 750,000 points and it looks like it will take a
few hours to export. This is with the attribute data stored in a
PostgreSQL database.

I did build an index on the category field in the database, and I
think it helped to a degree, but I can't be certain that GRASS is
even using the index.
    
v.out.ascii.db + ogr2ogr CSV -> Shapefile?
(wiki add-ons)

Some profiling is needed to understand why/where v.out.ogr is so very
slow to export to a shapefile.

Hamish
  

It seems that ogr2ogr can't create geometry from a csv file. gen2shp works really well though.

Dave