I've a large text file of weather data. A sample row of data is:
station|name|lat|lon|elev|date|dapr|evap|mdpr|prcp|sn01|sn03|snow|snwd|sx01|sx03|wesd|wesf
USC00353770|Headworks Portland Water|45.4486|-122.1547|228.0|2005-01-01||||0.59|||0.0|0.0||||
The fourth column is longitude with values such as -122.1547. When I enter
this command:
in.ascii --overwrite \
in=/home/rshepard/projects/oregon/<project_name/data/precipitation/\
clackamas_co_weather_2005_2018.txt out=precip separator=pipe \
columns="station varchar, name varchar, y double precision, x double \
precision, elev double precision, date varchar, dapr double precision, \
evap double precision, sn01 double precision, sn03 double precision, \
snow double precision, snwd double precision, sx01 double precision, sx03 \
double precision, west double precision, wesf double precision" x=4 y=3 z=5
grass 7.5svn responds with this error:
Number of columns: 18
Number of rows: 113570
ERROR: 'x' column is not of number type
How do I specify west longitude without an initial '-' or an appended 'W'?
Rich
Don’t you need the “skip=1” parameter to skip the first header line of column names?
···
On 06/11/2018 08:55 PM, Rich Shepard wrote:
I’ve a large text file of weather data. A sample row of data is:
station|name|lat|lon|elev|date|dapr|evap|mdpr|prcp|sn01|sn03|snow|snwd|sx01|sx03|wesd|wesf
USC00353770|Headworks Portland Water|45.4486|-122.1547|228.0|2005-01-01||||0.59|||0.0|0.0||||
The fourth column is longitude with values such as -122.1547. When I enter
this command:
in.ascii --overwrite
in=/home/rshepard/projects/oregon/<project_name/data/precipitation/
clackamas_co_weather_2005_2018.txt out=precip separator=pipe
columns=“station varchar, name varchar, y double precision, x double
precision, elev double precision, date varchar, dapr double precision,
evap double precision, sn01 double precision, sn03 double precision,
snow double precision, snwd double precision, sx01 double precision, sx03
double precision, west double precision, wesf double precision” x=4 y=3 z=5
grass 7.5svn responds with this error:
Number of columns: 18
Number of rows: 113570
ERROR: ‘x’ column is not of number type
How do I specify west longitude without an initial ‘-’ or an appended ‘W’?
Rich
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user
--
Micha Silver
Ben Gurion Univ.
Sde Boker, Remote Sensing Lab
cell: +972-523-665918
On Mon, 11 Jun 2018, Micha Silver wrote:
Don't you need the "skip=1" parameter to skip the first header line of
column names?
Micha,
I thought the header was used for attribute names in the database table.
Now, I realize that the columms variable does that, so I should add 'skip=1'
to the command. Yep. That was the problem and I missed seeing it.
Toda raba,
Rich