I apologize for these emails, but I think that we need to get v.in.ascii running because it is a core module
(there is no use for all the other great GRASS modules if you cannot import your data).
There was a change in in.c implemented 4 weaks ago see
http://freegis.org/cgi-bin/viewcvs.cgi/grass6/vector/v.in.ascii/
Could this have broken the example shown by Hamish?
His test runs if the data are read as 3d coordinates x,y,z but not if the third column is read as attribute
GRASS 6.0.cvs (wakestate):~/grasscvs6 > echo "1|2|3" |~/grasscvs6/grass-6.1.cvs/bin/v.in.ascii -zt out=test4561z z=3
Maximum input row length: 6
Maximum number of columns: 3
Minimum number of columns: 3
Building topology ...
1 primitives registered
Building areas: 100%
0 areas built
0 isles built
Attaching islands:
Attaching centroids: 100%
Topology was built.
Number of nodes : 1
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
GRASS 6.0.cvs (wakestate):~/grasscvs6 > echo "1|2|3" |~/grasscvs6/grass-6.1.cvs/bin/v.in.ascii out=test4561c
Maximum input row length: 6
Maximum number of columns: 3
Minimum number of columns: 3
column: 1 type: integer
column: 2 type: integer
column: 3 type: integer
DBMI-DBF driver error:
Incompatible value type.
Error in db_execute_immediate()
ERROR: Cannot insert values: insert into test4561c values ( 1, '1', '2',
'3')
On Jun 22, 2005, at 12:32 AM, Helena Mitasova wrote:
I was indeed running an old version - with 6.1 I get the same error with your example, but my data read OK,
(this is unrelated to the memory leak which starts to cause problems with 3milion+ points)
Helena
GRASS 6.0.cvs (wakestate):~/grasscvs6/grass-6.1.cvs/bin > echo "1|2|3" | ./v.in.ascii out=test4561
Maximum input row length: 6
Maximum number of columns: 3
Minimum number of columns: 3
column: 1 type: integer
column: 2 type: integer
column: 3 type: integer
DBMI-DBF driver error:
Incompatible value type.
Error in db_execute_immediate()
ERROR: Cannot insert values: insert into test4561 values ( 1, '1', '2',
'3')
GRASS 6.0.cvs (wakestate):~/lgrass > ~/grasscvs6/grass-6.1.cvs/bin/v.in.ascii -zt nclidcc.ptstestxyz out=test61 fs=space z=3
Maximum input row length: 28
Maximum number of columns: 3
Minimum number of columns: 3
Building topology ...
16075 primitives registered
Building areas: 100%
0 areas built
0 isles built
Attaching islands:
Attaching centroids: 100%
Topology was built.
Number of nodes : 16075
Number of primitives: 16075
Number of points : 16075
Number of lines : 0
Number of boundaries: 0
Number of centroids : 0
Number of areas : 0
Number of isles : 0
GRASS 6.0.cvs (wakestate):~/lgrass > head nclidcc.ptstestxyz
2091304.41 730008.93 412.05
2091325.21 730001.13 411.08
2091345.45 730003.65 410.18
On Jun 22, 2005, at 12:03 AM, Helena Mitasova wrote:
Hamish,
I just updated GRASS6 from cvs and for me your example runs:
(looking at your prompt GRASS:6.1-cvs and mine GRASS 6.0.cvs am I using
a different version of GRASS? - I will check with Markus tomorrow).
Can somebody else run the same thing as shown below?
Helena
GRASS 6.0.cvs (wakestate):~/lgrass > echo "1|2|3" | v.in.ascii out=test456
Maximum input row length: 6
Maximum number of columns: 3
Minimum number of columns: 3
column: 1 type: integer
column: 2 type: integer
column: 3 type: integer
Building topology ...
1 primitives registered
Building areas: 100%
0 areas built
0 isles built
Attaching islands:
Attaching centroids: 100%
Topology was built.
Number of nodes : 1
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
On Jun 21, 2005, at 9:23 PM, Hamish wrote:
That v.in.ascii problem is a big one for me -- I suppose it's the same
problem I'm having trying to bring in point data. Are there any work
arounds in the mean time?
Can you describe again the problem you are seeing?
Failure to import more than 50,000 points in 6.0.0? (out of memory)
Failure to import more than 3,000,000 points in 6.1-cvs? (out of memory)
Failure to import any points in 6.1-cvs? (see below)
Right now, I'm getting this. (fresh & latest CVS, in a new mapset)
GRASS:6.1-cvs > echo "1|2|3" | v.in.ascii out=test654
Maximum input row length: 6
Maximum number of columns: 3
Minimum number of columns: 3
column: 1 type: integer
column: 2 type: integer
column: 3 type: integer
DBMI-DBF driver error:
Incompatible value type.
Error in db_execute_immediate()
ERROR: Cannot insert values: insert into test654 values ( 1, '1', '2', '3')
GRASS:6.1-cvs > db.connect -p
driver:dbf
database:$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
schema:(null)
group:(null)
thanks,
Hamish
_______________________________________________
grass5 mailing list
grass5@grass.itc.it
http://grass.itc.it/mailman/listinfo/grass5
Helena Mitasova
Dept. of Marine, Earth and Atm. Sciences
1125 Jordan Hall, NCSU Box 8208,
Raleigh NC 27695
http://skagit.meas.ncsu.edu/~helena/
_______________________________________________
grass5 mailing list
grass5@grass.itc.it
http://grass.itc.it/mailman/listinfo/grass5
Helena Mitasova
Dept. of Marine, Earth and Atm. Sciences
1125 Jordan Hall, NCSU Box 8208,
Raleigh NC 27695
http://skagit.meas.ncsu.edu/~helena/
Helena Mitasova
Dept. of Marine, Earth and Atm. Sciences
1125 Jordan Hall, NCSU Box 8208,
Raleigh NC 27695
http://skagit.meas.ncsu.edu/~helena/