[GRASS-user] Fresh eyes needed

[Helmut Kudrnovsky]

Rich Shepard wrote
> I'm about to give up for today, but perhaps fresh eyes will see what I'm
> not seeing.
> 
> Input data fragment:
> 
> name,lon,lat,elev,sampdate,prcp
> Headworks Portland
> Water,2370575.38427211,199337.634652112,228,2005-01-01,0.59
> 
>    Six fields comma separated.
> 
> Command:
> 
> v.in.ascii in=$HOME/projects/data/precipitation/rainfall.csv skip=1
> out=precip sep=comma columns='name varchar, lon double precision, lat
> double
> precision, elev double precision, sampdate varchar, prcp double precision'
> x=2
> y=3 z=4 --o
> 
>    Six columns defined.
> 
> What grass reports:
> 
> Scanning input for column types...
> Number of columns: 7
> Number of rows: 113570
> ERROR: 'x' column is not of number type
> 
>    I just do not see where grass finds that seventh column that shifts 'x'
> out of position. No name has a comma within it.

tested here with a simple copy/paste from your example

the content of input.txt

name,lon,lat,elev,sampdate,prcp
Headworks Portland
Water,2370575.38427211,199337.634652112,228,2005-01-01,0.59

v.in.ascii input=D:\temp\atlas_druck\input.txt output=testinput
separator=comma skip=1 columns=name varchar, lon double precision, lat
double precision, elev double precision, sampdate varchar, prcp double
precision x=2 y=3 z=4
Scanning input for column types...
Number of columns: 6
Number of rows: 2
WARNING: Column number 4 <elev> defined as double has only integer values
Importing points...
Populating table...
Building topology for vector map <testinput at data>...
Registering primitives...
(Sat Aug 11 11:50:43 2018) Command finished (0 sec) 

>ERROR: 'x' column is not of number type 

does rainfall.csv looks like your Input data fragment?



-----
best regards
Helmut
--
Sent from: http://osgeo-org.1560.x6.nabble.com/Grass-Users-f3884509.html