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