[GRASS-dev] v.in.ogr broken (\w shp)

Maciej Sieczka tutey at o2.pl
Mon Sep 4 12:09:53 EDT 2006


Hamish wrote:
> Brad Douglas wrote:
>> Is there an easy fix for this?  I'm trying to import a shapefile and
>> I'm not terribly familiar with this part of the GRASS architecture.
>>
>> GRASS 6.3.cvs (hamilton):~/hamilton > v.in.ogr dsn=. output=roads
>> layer=17
>> Projection of input dataset and current location appear to match.
>> Proceeding with import...
>> Layer: 17
>> DBMI-DBF driver error:
>> Column 'ADMIN_CLAS' already exists (duplicate name)
>> Cannot create table.
>> Error in db_execute_immediate()
>>
>> ERROR: Cannot create table: create table roads (cat integer, PREFIX
>> varchar
>>        ( 2 ), NAME varchar ( 30 ), TYPE varchar ( 4 ), SUFFIX varchar
>> ( 2
>>        ), FCC varchar ( 3 ), FIPS varchar ( 11 ), ID integer,
>>        FULL_NAME varchar ( 40 ), ADMIN_CLAS varchar ( 40 ), CATEGORY
>>        integer, ST_CNTY_FI varchar ( 11 ), RD_CLASS varchar ( 4 ),
>>        RTE_NUM1
>> varchar
>>        ( 4 ), RTE_NUM2 varchar ( 4 ), ADMIN_CLAS integer, AREA double
>>        precision, LEN double precision)
>> GRASS 6.3.cvs (hamilton):~/hamilton >

> DBF limits column names to 10 chars;

Brad,

Just curious:

Hamish is right. And you are importing a shapefile, correct? So how
could a column name longer than 10 chars be in the dbf shipped with
that shapefile?

?

Maciek




More information about the grass-dev mailing list