Re: [GRASS-user] Fresh eyes needed [RESOLVED]
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 ___ grass-user mailing list grass-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Fresh eyes needed
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 defined as double has only integer values Importing points... Populating table... Building topology for vector map ... 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 ___ grass-user mailing list grass-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Fresh eyes needed
On Fri, Aug 10, 2018 at 11:00 PM, 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: 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 defined as double has only integer values Importing points... 100% Populating table... Building topology for vector map ... 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 ___ grass-user mailing list grass-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-user
[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 ___ grass-user mailing list grass-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-user