[GRASS-user] Can't use v.overlay on patched vector

[Jeshua Lacock]

Greetings,

I can’t seem to patch two vectors together with an attribute table then use the v.overlay command on the patched vector. I can use v.overlay if I don’t use v.patch's -e option, but I need the attribute table. Any way around this?

If I run these commands:

v.patch -e input=Road,Road2 output=RoadAll
v.overlay  ainput=RoadAll binput=bounds operator=and output=RoadAll_crop

I get these warnings and error:

WARNING: Database connection not defined for layer 1
WARNING: DBMI-DBF driver: column name 'a_PERMANENT_' truncated to
         'a_PERMANEN'
WARNING: DBMI-DBF driver: column name 'a_SOURCE_FEA' truncated to
         'a_SOURCE_F'
WARNING: DBMI-DBF driver: column name 'a_SOURCE_DAT' truncated to
         'a_SOURCE_D'
WARNING: DBMI-DBF driver: column name 'a_SOURCE_D00' truncated to
         'a_SOURCE_D'
DBMI-DBF driver error:
Column 'a_SOURCE_D' already exists (duplicate name)

DBMI-DBF driver error:
Unable to create table.Unable to execute statement.

DBMI-DBF driver error:
Unable to create table.Unable to execute statement.

ERROR: Unable to create table: 'create table RoadAll_crop (cat integer
       , a_cat integer, a_TEMP varchar(200), a_TNMFRC varchar(200),
       a_PERMANENT_ varchar(200), a_SOURCE_FEA varchar(200), a_SOURCE_DAT
       varchar(200), a_SOURCE_D00 varchar(200), a_SOURCE_ORI varchar(200),
       a_LOADDATE varchar(200), a_INTERSTATE varchar(200), a_INTERSTA00
       varchar(200), a_INTERSTA01 varchar(200), a_INTERSTA02 varchar(200),
       a_US_ROUTE varchar(200), a_US_ROUTE_A varchar(200), a_US_ROUTE_B
       varchar(200), a_US_ROUTE_C varchar(200), a_STATE_ROUT varchar(200),
       a_STATE_RO00 varchar(200), a_STATE_RO01 varchar(200), a_STATE_RO02
       varchar(200), a_COUNTY_ROU varchar(200), a_FEDERAL_LA varchar(200),
       a_STCO_FIPSC varchar(200), a_FULL_STREE varchar(200), a_MTFCC_CODE
       varchar(200), a_SHAPE_LENG varchar(200), b_cat integer )'


Thanks,

Jeshua Lacock
Founder/Engineer
<3DTOPO.com>
GlassPrinted.com