[GRASS-user] importing a vector, problem with duplicate column name: cat_

[Markus Metz]

On Thu, Aug 4, 2016 at 9:24 AM, Margherita Di Leo <diregola at gmail.com> wrote:
> Hi,
>
> importing a vector either using v.import GUI or v.in.ogr, it tries to rename
> the column <cat> into <cat_>, but both already exist and it throws out an
> error.
>
> [..]
> Check if OGR layer <pt599000_4414000_class1> contains polygons...
> Column name <cat> renamed to <cat_>
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> duplicate column name: cat_
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> duplicate column name: cat_
> ERROR: Unable to create table: 'create table pt599000_4414000_class1 (cat
> integer, cat_ integer, cat_ integer, NDVI double precision)'
> ERROR: Unable to import [..]
>
> Is there a way to overcome this?

you can overcome this with the columns option of v.in.ogr.

Markus M

>
> Thank you for any suggestion
> Cheers,
>
> --
> Margherita Di Leo
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user