Re: [GRASS-user] Can't dissolve based on column?

2008-01-17 Thread nikos . alexandris
Sorry for typo's! On Thu, 17 Jan 2008 13:02:54 +0100 [EMAIL PROTECTED] wrote: I just wonder how was the tile-patching and dissolving (of CORINE shapefile(s)) done, as described in v.dissolve's help text? Were the file's CODE_00 column different than TEXT ? But anyway is good to make things

[GRASS-user] Can't dissolve based on column?

2008-01-16 Thread nikos . alexandris
All I try to do is a dissolve... and for: v.dissolve input=clc00_clean output=clc00_dissolved col=CODE_00 I get: DBMI-SQLite driver error: Cannot step: SQL logic error or missing database ERROR: Cannot fetch data ERROR: Unable to open vector map [EMAIL PROTECTED] on topology level 2

RE: [GRASS-user] Can't dissolve based on column?

2008-01-16 Thread Patton, Eric
: [GRASS-user] Can't dissolve based on column? Well... I suspected it had to do with the field type of the column CODE_00. Indeed... the column was TEXT. After Daniels (Victoria) indications for a similar problem a change to integer (using sqlitebrowser) solved the problem. I suggest

RE: [GRASS-user] Can't dissolve based on column?

2008-01-16 Thread Nikos Alexandris
be of type integer, and *only* integer? ~ Eric. -Original Message- From: [EMAIL PROTECTED] on behalf of Nikos Alexandris Sent: Wed 1/16/2008 3:41 PM To: grass-user@lists.osgeo.org Subject: Re: [GRASS-user] Can't dissolve based on column? Well... I suspected it had to do

Re: [GRASS-user] Can't dissolve based on column?

2008-01-16 Thread Martin Landa
Hi, 2008/1/16, Nikos Alexandris [EMAIL PROTECTED]: My column CODE_00 was identified as TEXT, not varchar. So maybe this was the problem (?) I merged the tiles outside of GRASS with ogr2ogr -update -append... etc. I did not try to merge with v.patch the tiles. Is there a difference? yes,

Re: [GRASS-user] Can't dissolve based on column?

2008-01-16 Thread Nikos Alexandris
I just changed to varchar the same data (column) and I get... : GRASS 6.3.0RC4 (Peloponnese_HGRS87):~ v.dissolve input=clc00_clean output=clc00_final_v layer=1 column=CODE_00 DBMI-SQLite driver error: Cannot step: SQL logic error or missing database ERROR: Cannot fetch data ERROR: Unable to

Re: [GRASS-user] Can't dissolve based on column? -- Merging tiles with unequal column number with v.patch (?)

2008-01-16 Thread Martin Landa
areas... (not tested v.dissolve) Martin ~ Eric. -Original Message- From: [EMAIL PROTECTED] on behalf of Nikos Alexandris Sent: Wed 1/16/2008 3:41 PM To: grass-user@lists.osgeo.org Subject: Re: [GRASS-user] Can't dissolve based

Re: [GRASS-user] Can't dissolve based on column?

2008-01-16 Thread Nikos Alexandris
Are there plans to change the TEXT problem with respect to v.dissolve (v.extract)? I need to know, if it possible, due to some documentation I am preparing. Thank you! On Wed, 2008-01-16 at 22:08 +0100, Martin Landa wrote: Hi, 2008/1/16, Nikos Alexandris [EMAIL PROTECTED]: My column