[GRASS-user] Overcoming Error in v.in.e00

[Rich Shepard]

   If I read the command history correctly, GRASS truncated column names and
ended up with two columns with the same name so it bailed out on me. This is
a 1999-vintage hydrography file (but nothing's changed in the topography and
waterbodies since then). I don't know what to do to over come this error.
Advice wanted.

   Command history:

(Tue Mar 20 09:31:58 2012) 
v.in.e00 -v --overwrite file=/home/rshepard/GIS/data/Washington/hydrography/kettle_river/b7020002.e00 type=area vect=kettle_river_waterbodies
An error may appear next which will be ignored...
E00 Compressed ASCII found. Will uncompress first...
...converted to Arc Coverage in current directory
Importing areas...
Vector map <kettle_river_waterbodies> already exists and will be overwritten
Over-riding projection check
Vector map <kettle_river_waterbodies> already exists and will be overwritten
Table <kettle_river_waterbodies> linked to vector map <kettle_river_waterbodies> does not exist
Vector map <kettle_river_waterbodies_tmp> already exists and will be overwritten
Layer: LAB
Column name changed: 'B7020002#' -> 'B7020002_'
Column name changed: 'B7020002-ID' -> 'B7020002_ID'
DBMI-DBF driver: column name 'B7020002_ID' truncated to 'B7020002_I'
DBMI-DBF driver: column name 'WTRBDY_TYPE_CD' truncated to 'WTRBDY_TYP'
Counting polygons for 47 features...
Importing map 47 features...
Layer: ARC
Column name changed: 'B7020002#' -> 'B7020002_'
Column name changed: 'B7020002-ID' -> 'B7020002_ID'
DBMI-DBF driver: column name 'B7020002_ID' truncated to 'B7020002_I'
DBMI-DBF driver: column name 'WTRBDY_SL_LWR_AD' truncated to 'WTRBDY_SL_'
DBMI-DBF driver: column name 'WTRBDY_SL_UPR_AD' truncated to 'WTRBDY_SL_'
DBMI-DBF driver error:
Column 'WTRBDY_SL_' already exists (duplicate name)
Cannot create table.
Error in db_execute_immediate()
ERROR: Unable to create table: 'create table kettle_river_waterbodies_2 (cat integer, UserId integer, FNODE_ integer, TNODE_ integer, LPOLY_ integer, RPOLY_ integer, LENGTH double precision, B7020002_ integer, B7020002_ID integer, WTRBDY_NR varchar ( 13 ), WTRBDY_SL_LWR_AD double precision, WTRBDY_SL_UPR_AD double precision, WTRBDY_SL_TYP_CD integer)'
ERROR: An error occurred. Halting.
(Tue Mar 20 09:31:59 2012) Command finished (0 sec)

Rich