Hi to all guys!
For my italian gis wiki ( http://www.freegis-wiki.it ) i am adding to the FAQ
section the question that i found on the international ML (the italian one is
not so populated ). I notice that a lot are having issue with importing txt
file as vector one, so i decided to do some resarch in this direction.
I toke this example from v.in.ascii manual:
cat points3d.dat | v.in.ascii -z z=3 cat=0 out=mypoints3D \
columns='x double, y double, z double, label_cz
varchar(20), label_en varchar(20)'
But got this output:
Maximum input row length: 25
Maximum number of columns: 3
Minimum number of columns: 0
ERROR: x column number > minimum last column number
What am i missing?
Thx
Luca
--
GIS for GENTOO Developer
gtalk: luca.casagrande@gmail.com
skype : thedoktor78
On Wed, Nov 09, 2005 at 04:39:21PM +0100, Luca Casagrande wrote:
Hi to all guys!
For my italian gis wiki ( http://www.freegis-wiki.it ) i am adding to the FAQ
section the question that i found on the international ML (the italian one is
not so populated ). I notice that a lot are having issue with importing txt
file as vector one, so i decided to do some resarch in this direction.
I toke this example from v.in.ascii manual:
cat points3d.dat | v.in.ascii -z z=3 cat=0 out=mypoints3D \
columns='x double, y double, z double, label_cz
varchar(20), label_en varchar(20)'
But got this output:
Maximum input row length: 25
Maximum number of columns: 3
Minimum number of columns: 0
ERROR: x column number > minimum last column number
What am i missing?
Luca,
are you using the sqlite driver (db.connect -p)?
I tried, it fails for me with sqlite, apparently
db_set_column_length() returns -1 for string columns/sqlite.
With e.g. DBF driver it works. We'll have to fix this.
Alle 12:52, giovedì 10 novembre 2005, Markus Neteler ha scritto:
On Wed, Nov 09, 2005 at 04:39:21PM +0100, Luca Casagrande wrote:
> Hi to all guys!
> For my italian gis wiki ( http://www.freegis-wiki.it ) i am adding to the
> FAQ section the question that i found on the international ML (the
> italian one is not so populated ). I notice that a lot are having issue
> with importing txt file as vector one, so i decided to do some resarch in
> this direction. I toke this example from v.in.ascii manual:
>
> GRASS 6.0.1 (spearfish60):~ > cat points3d.dat
> 593493.1|4914730.2|123.1|studna|well
> 591950.2|4923000.5|222.3|kadibudka|closet
> 589860.5|4922000.0|232.3|hruska|pear
> 590400.5|4922820.8|143.2|mysi dira|mouse hole
> 593549.3|4925500.7|442.6|mineralni pramen|mineral spring
> 600375.7|4925235.6|342.2|kozi stezka|goat path
>
> and then run:
>
> cat points3d.dat | v.in.ascii -z z=3 cat=0 out=mypoints3D \
> columns='x double, y double, z double, label_cz
> varchar(20), label_en varchar(20)'
>
> But got this output:
> Maximum input row length: 25
> Maximum number of columns: 3
> Minimum number of columns: 0
> ERROR: x column number > minimum last column number
>
> What am i missing?
Luca,
are you using the sqlite driver (db.connect -p)?
I tried, it fails for me with sqlite, apparently
db_set_column_length() returns -1 for string columns/sqlite.
With e.g. DBF driver it works. We'll have to fix this.
Markus
Hi Markus and thx for your answer,
i am not yet an expert in db command (still focusing on other things...).
I just opened the spearfish PERMANENT dataset and did the command...
Hope to be usefull
cat points3d.dat | v.in.ascii -z z=3 cat=0 out=mypoints3D \
columns='x double, y double, z double, label_cz
varchar(20), label_en varchar(20)'
But got this output:
Maximum input row length: 25
Maximum number of columns: 3
Minimum number of columns: 0
ERROR: x column number > minimum last column number