[GRASS-user] DBMI-DBF driver error with v.in.ogr grass 6.2.2 (worked with older grass)

GRASS GRASS user
1

Hi;
    I'm trying to re-import some shape files that I had originally imported in fall 2007 with an older version of grass (not sure which one) but I now get a DBMI-DBF driver error with grass 6.2.2. How can I fix this? (Hopefully grass will at some point maintain backward compatibility)

Specifically:

GRASS 6.2.2 > v.in.ogr dsn=/u1/wrk/GIS/EAdatoct07.dir/ layer=Time19_NEW2 out=EA7o19kbb
Projection of input dataset and current location appear to match.
Proceeding with import...
Layer: Time19_NEW2
DBMI-DBF driver error:
SQL parser error in statement:
create table EA7o19kbb (cat integer, ID1 integer, Time integer)
Error in db_execute_immediate()
ERROR: Cannot create table: create table EA7o19kbb (cat integer, ID1
        integer, Time integer)

GRASS 6.2.2 > v.db.connect -p map=EA7o19kbb
WARNING: coor files of vector 'EA7o19kbb@lev' is larger than it should be
         (14 bytes excess).
Vector map <EA7o19kbb> is connected by:
layer <1> table <EA7o19kbb> in database </u1/wrk/GIS/EAmg7/lev/dbf/> through driver <dbf> with key <cat>

The old file gives:

GRASS 6.2.2 > v.db.connect -p map=EA7o19k
Vector map <EA7o19k> is connected by:
layer <1> table <EA7o19k> in database </u1/wrk/GIS/EAmg7/lev/dbf/> through driver <dbf> with key <cat>

------------
details from files in /home/u1/wrk/GIS/EAmg7/lev/vector/EA7o19k

hist:
COMMAND: v.in.ogr -o dsn="/u1/wrk/GIS/EAdatoct07.dir/" output="EA7o19k" layer="Time19_NEW2" min_area=0.0001 snap=-1
GISDBASE: /u1/wrk/GIS
LOCATION: EAmg7 MAPSET: lev USER: lev DATE: Mon Nov 12 14:25:21 2007

dbln:
1 EA7o19k cat $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/ dbf

------------
projection, PERMANENT files:

GRASS 6.2.2 > g.proj -p
XY location (unprojected)

VAR:
DB_DRIVER: dbf
DB_DATABASE: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/

PROJ_INFO:
name: Lambert Azimuthal Equal Area
proj: laea
ellps: wgs84
a: 6378137.0000000000
es: 0.0066943800
f: 298.2572235630
lat_0: 60.0000000000
lon_0: 20.0000000000

The input files are:
-rw-r--r-- 1 lev lev 130 2007-11-01 11:05 /u1/wrk/GIS/EAdatoct07.dir/Time19_NEW2.dbf
-rw-r--r-- 1 lev lev 109892 2007-11-01 11:05 /u1/wrk/GIS/EAdatoct07.dir/Time19_NEW2.shp
-rw-r--r-- 1 lev lev 116 2007-11-01 11:05 /u1/wrk/GIS/EAdatoct07.dir/Time19_NEW2.shx

Lev
                 email: lev{at]mun(dot)ca

2

On Mon, Apr 27, 2009 at 4:57 PM, Lev Tarasov <lev@mun.ca> wrote:

Hi;
I'm trying to re-import some shape files that I had originally imported in
fall 2007 with an older version of grass (not sure which one) but I now get
a DBMI-DBF driver error with grass 6.2.2. How can I fix this? (Hopefully
grass will at some point maintain backward compatibility)

(it does)

Specifically:

GRASS 6.2.2 > v.in.ogr dsn=/u1/wrk/GIS/EAdatoct07.dir/ layer=Time19_NEW2
out=EA7o19kbb
Projection of input dataset and current location appear to match.
Proceeding with import...
Layer: Time19_NEW2
DBMI-DBF driver error:
SQL parser error in statement:
create table EA7o19kbb (cat integer, ID1 integer, Time integer)
Error in db_execute_immediate()
ERROR: Cannot create table: create table EA7o19kbb (cat integer, ID1
integer, Time integer)

The problem is that you use a reserved SQL keyword as
column name ("time"). This won't work...
You need to rename the column, with the "cnames" option of
v.in.ogr you can do that on the fly while importing.

Markus