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