[GRASS-user] v.what.strds error creating column with @ name

[Ken Mankoff]

Hi List,

I'm trying to sample an STRDS at some vector points.

My points are generated (from lines in another mapset) with:

v.to.points input=ex1 at gates type=line output=points dmax=100

My STRDS is generated in the current mapset (named vel), and then when I run

v.what.strds input=points strds=vx,vy output=test

I get the following error:

DBMI-SQLite driver error:
Error in sqlite3_prepare():
near "@vel_2007_09_07": syntax error

ERROR: Error while executing: 'ALTER TABLE test_points_1 ADD COLUMN vy_2007_09_07_2008_04_23 at vel_2007_09_07 DOUBLE PRECISION'
ERROR: Unable to add column <vy_2007_09_07_2008_04_23 at vel_2007_09_07 DOUBLE PRECISION>.
ERROR: Unable to add column vy_2007_09_07_2008_04_23 at vel_2007_09_07 DOUBLE PRECISION to vector map <test> 


'@' is not a valid character name in a DB column. Am I doing something wrong that v.what.strds is trying to generate this column name?

Thanks,

  -k.