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

[Veronica Andreo]

Hi Ken,

Were you able to solve the problem or find its cause? Could you create a
reproducible example with the NC dataset? It seems really strange, if the
mapset is named vel why would it add the date to it too?

Cheers,
Vero

El mar, 23 ene 2024 a las 14:48, Ken Mankoff via grass-user (<
grass-user at lists.osgeo.org>) escribió:

> 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.
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user
>


-- 
Dra. Verónica Andreo
Investigadora Adjunta de CONICET
Instituto Gulich (CONAE - UNC)
Centro Espacial Teófilo Tabanera (CETT)
Falda del Cañete - Córdoba, Argentina
+54 3547 400000 int. 1153
https://veroandreo.gitlab.io/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20240202/9fcc7ffb/attachment.htm>