[GRASS-user] v.out.ascii bug with where=
Micha Silver
micha at arava.co.il
Wed Mar 20 06:01:45 PDT 2013
I need some guidance here. I have a point vector, created using
v.to.points. Trying to select out some of the points using v.out.ascii
with a "where=" clause, but I'm getting a few points which do NOT match
the where condition. Using v.db.select with the same condition works as
expected.
Here's what I get:
GRASS:grass-hecras > g.version
GRASS 7.0.svn (2013)
GRASS:grass-hecras > v.info -c n_xsect_pts
Displaying column types/names for database connection of layer <1>:
INTEGER|cat
INTEGER|reach
INTEGER|station_id
GRASS:grass-hecras > v.info -c n_xsect_pts layer=2
Displaying column types/names for database connection of layer <2>:
INTEGER|cat
INTEGER|lcat
DOUBLE PRECISION|along
GRASS:grass-hecras > v.db.select n_xsect_pts where="reach=1259"
cat|reach|station_id
47|1259|1259001
48|1259|1259002
49|1259|1259003
50|1259|1259004
51|1259|1259005
52|1259|1259006
53|1259|1259007
54|1259|1259008
55|1259|1259009
56|1259|1259010
57|1259|1259011
GRASS:grass-hecras > v.out.ascii n_xsect_pts where="reach=1259"
columns=reach,station_id layer=1
Fetching data...
east|north|cat|reach|station_id
194816.2781556|391418.14073617|15|1338|1338009 <<-----
194785.2522622|391271.38449631|15|1338|1338009
194969.45079367|391550.93984055|16|1338|1338010
195013.09512544|391407.42965867|16|1338|1338010
195056.73945721|391263.91947679|16|1338|1338010
195859.29153025|391864.89133855|17|1729|1729001 <<----
195865|391715|17|1729|1729001
195870.70846975|391565.10866145|17|1729|1729001
196110.07342651|391851.71960973|18|1729|1729002
196060.83217701|391710.0322802|18|1729|1729002
196011.59092752|391568.34495067|18|1729|1729002
192978.12160181|391913.80105547|47|1259|1259001
193055|391785|47|1259|1259001
193131.87839819|391656.19894453|47|1259|1259001
193285.50571827|391994.23318538|48|1259|1259002
193239.36927725|391851.50467102|48|1259|1259002
193193.23283624|391708.77615667|48|1259|1259002
...... (lots more correctly matching rows)
Note the first 10 or so rows above do NOT match the where condition!?? I
tried with several other reach numbers and each time I get a few
NON-matching rows in the result.
Tearing my hair out....
Any ideas are certainly welcome,
Micha
More information about the grass-user
mailing list