[GRASS-user] Error using v.in.ogr to load a shapefile: any clue?

Corrado ct529 at york.ac.uk
Tue Mar 11 06:11:07 EDT 2008


Dear Tom,

your analysis was absolutely right. I modified the name of the field using 
cname, and it worked.

Thanks a lot!

On Monday 10 March 2008 16:25:33 Tom Russo wrote:
> I think the problem here is the field named "UPDATE" --- the GRASS SQL
> driver cries when you try to use field names that are reserved words in
> SQL.  The same happens for fields named "DATE" or "TIME" that are commonly
> used in shapefiles.  I believe that UPDATE is a reserved word.
>
> You'll have to use the "cnames=" option of v.in.ogr to rename the columns
> to get around that.
>
> Unfortunately, cnames requires that you give a name to *all* the columns up
> to the one you want to change, and your "UPDATE" field is the last one.  So
> you'd have to use:
>  
> cnames=cat,AREA,PERIMETER,SSI_,SSI_ID,CARTO_CODE,OVERLAP_CO,SITE_NAME,SITE_
>HA,NOTIFIED,COUNCIL,TYPE,MIDAS_NUM,whateveryouwanttocallUPDATEinstead


Best Regards
-- 
Corrado Topi

Global Climate Change and Biodiversity
Area 18,Department of Biology
University of York, York, YO10 5YW, UK
Phone: + 44 (0) 1904 328645, E-mail: ct529 at york.ac.uk


More information about the grass-user mailing list