[GRASSLIST:6271] Re: v.in.ogr error

[Moritz Lennert]

On Mon, March 28, 2005 19:23, Kirk R. Wythers said:
> What is implied by the error:
>
> GRASS 6.0.0 (arrowhead_utm):~ > v.in.ogr -o
> dsn=/Users/kirkw/projects/wrf/grids/ layer=forties output=forties
> Over-riding projection check.
> Proceeding with import...
> Layer: forties
> DBMI-DBF driver error:
> Column 'PLS_FORTYP' already exists (duplicate name)
> Cannot create table.
> Error in db_execute_immediate()
>
> ERROR: Cannot create table: create table forties_grid (cat integer, AREA
>         double precision, PERIMETER double precision, PLS_FORTYP integer,
>         PLS_FORTYP integer, COUN integer, TOWN integer, RDIR integer,
> RANG
>         integer, SECT integer, FORT integer, GLOT integer, PARC integer,
>         FORT_DESC varchar ( 40 ), GLOTMATCH integer, GEOPARC integer,
>         GEOGLOT integer, GEOFORT integer, GEOSECT integer, GEORANG
> integer,
>         HECTARES double precision)
>

The problem is that your dbf file contains two columns with exactly the same
name (PLS_FORTYP) which is unacceptable for the database driver. Change one of
the column names in the table before using v.in.ogr or use the cnames option
of v.in.ogr.

Moritz


> I am trying to import some shape files into utm location in grass6.0.
> The shape files have the naming scheme:
> forties.dbf
> forties.sbn
> forties.sbx
> forties.shp
> forties.shx
>
> Thanks,
>
> Kirk
>
>