[GRASS-user] re: Help with v.in.ogr DBMI-DBF driver error

[patrick dolan]

Hello,

I'm attempting to bring a vector shapefile into a mapset in GRASS and am
being confronted with the following problem, can anyone clarify a) what,
precisely, the error is and b) how to overcome it?

v.in.ogr -w dsn=/Users/.../Dated_Sites.shp output=Dated

Projection of input dataset and current location appear to match
Layer: Dated_Sites
Column name changed: 'ISHERITAGE' -> 'isheritage'
Column name changed: 'AREA' -> 'area'
Column name changed: 'LEN' -> 'len'
Column name changed: 'ID' -> 'id'
Column name changed: 'Province' -> 'province'
Column name changed: 'Site_Code' -> 'site_code'
Column name changed: 'Site_Name' -> 'site_name'
Column name changed: 'Marpole' -> 'marpole'
Column name changed: 'Marpole_Er' -> 'marpole_er'
Column name changed: 'Gulf_of_Ge' -> 'gulf_of_ge'
Column name changed: 'Gulf_Error' -> 'gulf_error'
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected $undefined,
expecting '(' processing '.'
in statement:
create table dbf.Dated (cat integer, mod_by varchar ( 10 ),
mod_on date, mod_using varchar ( 20 ), borden_num varchar (
13 ), borden_upp varchar ( 2 ), borden_low varchar ( 2 ),
borden_seq integer, create_dat date, form_user varchar ( 30
), form_recd date, reg_status varchar ( 20 ), doc_key
integer, parent_id integer, xx_arsi_id integer, isheritage
varchar ( 1 ), area double precision, len double precision,
id integer, province varchar ( 254 ), site_code varchar (
254 ), site_name varchar ( 254 ), marpole integer,
marpole_er integer, gulf_of_ge integer, gulf_error integer)
Error in db_execute_immediate()
ERROR: Unable to create table: 'create table dbf.Dated (cat integer, mod_by
varchar ( 10 ), mod_on date, mod_using varchar ( 20 ), borden_num varchar (
13 ), borden_upp varchar ( 2 ), borden_low varchar ( 2 ), borden_seq
integer, create_dat date, form_user varchar ( 30 ), form_recd date,
reg_status varchar ( 20 ), doc_key integer, parent_id integer, xx_arsi_id
integer, isheritage varchar ( 1 ), area double precision, len double
precision, id integer, province varchar ( 254 ), site_code varchar ( 254 ),
site_name varchar ( 254 ), marpole integer, marpole_er integer, gulf_of_ge
integer, gulf_error integer)'
(Tue Apr 27 10:42:25 2010) Command finished (0
sec)


Cheers,
Patrick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20100427/4289ff7c/attachment.html