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

[Kirk R. Wythers]

Thank you Moritz. I just stumbled to the fact that the help documents 
on the web 
(http://grass.itc.it/grass60/manuals/html60_user/v.in.ogr.html) are 
more detailed (including additional information concerning v.in.ogr 
options) than those that are generated from the build and install 
process. I will look on the web in the future.

Kirk


On Mar 28, 2005, at 12:14 PM, Moritz Lennert wrote:

> 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
>>
>>
>
>