[GRASS5] v.in.ascii

[Helena Mitasova]

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 at 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 at 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/