[GRASS-user] Fresh eyes needed

   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.

Puzzled,

Rich

On Fri, Aug 10, 2018 at 11:00 PM, Rich Shepard <rshepard@appl-ecosys.com> 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:

GRASS 7.4.2svn (nc_spm_08_grass7):~ > v.in.ascii in=bla.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
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...
100%
Populating table...
Building topology for vector map <precip@user1>...
Registering primitives...
One primitive registered
One vertex registered
Building areas...
100%
0 areas built
0 isles built
Attaching islands...
Attaching centroids...
100%
Number of nodes: 0
Number of primitives: 1
Number of points: 1
Number of lines: 0
Number of boundaries: 0
Number of centroids: 0
Number of areas: 0
Number of isles: 0

Works nicely.
Maybe any spurious hidden char at the end of row 1 or row 2?

Markus

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.

Puzzled,

Rich
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user

--
Markus Neteler, PhD
http://www.mundialis.de - free data with free software
http://grass.osgeo.org
http://courses.neteler.org/blog

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@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

On Sat, 11 Aug 2018, Markus Neteler wrote:

Works nicely.
Maybe any spurious hidden char at the end of row 1 or row 2?

Markus/Helmut,

   I found the cause: a wrong character (-) in the source and output file
names. Those hyphens need to be underscores (_). This was difficult to find
because the error message pointed to a problem with the file contents (for
some reason) and not to an illegal filename character.

Thanks, both of you,

Rich