Multiple attribute tables in winGRASS 6.4

4 messages Options
Embed this post
Permalink
sharon m-2

Multiple attribute tables in winGRASS 6.4

Reply Threaded More More options
Print post
Permalink
Hi all,

I've successfully used v.in.ogr to import a MID/MIF file into winGRASS
(winGRASS 6.4 r38537 windows binary on Windows XP) and create a vector
map called sla01 with it's associated attribute table (from the .MID
file) in layer 1 (has 124 categories). This uses the DBF database
driver. I now want to add a new attribute table (from a .csv file) - a
row for each category - which contains different information (e.g.
alternate name, population, economic indicators, etc), so a vector
thematic area map can be created using information from the new
attribute table.

Is it possible to have more than one attribute table associated with a
vector map in winGRASS when using the DBF format? If so, how do you do
this please?

So far I've used...
- v.in.ogr to import the MID/MIF file into winGRASS map=sla01 (with
associated table sla01)
- db.in.ogr to import .csv file (with associated .csvt file) to table
name sla01_tbl2. This table contains 124 rows in the same order as the
MID/MIF files. Columns in the new table sla01_tbl2 include "cat"
(created automatically during import), alt_name, idx_ord, pop,
econ_idx, etc
- how do you associate the new table with the vector map sla01?
- how do you then access the new table for producing a vector thematic area map

I've also tried...
- v.db.addtable to create a new table (new_tbl) into layer 2
- v.to.db to populate the new table in layer 2, with (e.g.) cat and
area data, however it won't allow me to query layer 1 (table sla01)
and write to "new_tbl" in layer 2

I'm concerned that I'm trying to do something that might not even be a
feature of winGRASS, so any help would be appreciated.

As an aside, I would use my local Oracle db, but I understand there is
no ODBC feature currently in winGRASS? Will this be a feature in
winGRASS 6.5? winGRASS 7?

Thanks in advance.

Sharon
_______________________________________________
grass-windows mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/grass-windows
Colin Nielsen

Re: [GRASS-user] Multiple attribute tables in winGRASS 6.4

Reply Threaded More More options
Print post
Permalink
I've just uploaded a new version (r38959) with ODBC support enabled.
Please test it out and let us know if it is working properly. I hope
this solves your issue Sharon. (Please remember that it can take up to
24 hours before the new updates make it to all the web mirrors).

-Colin

On Fri, Sep 4, 2009 at 2:54 AM, Sharon M<[hidden email]> wrote:

> Hi,
>
> I'm hoping the general GRASS mailing list community can help me.
>
> I'm using winGRASS 6.4 (r38875) on windows XP and using DBF files
> (oracle and ODBC is not currently supported in winGRASS).
>
> I'm able to connect an additional attribute table containing
> alternative names to a vector map. The cat columns in layer 1 and
> layer 2 are the same (numbers 1-25). e.g.
>
>> v.db.connect map=locn layer=2 key=cat table=locn_tbl2
>
> If I bring up the attribute window manager, I can see the new table is
> in layer 2.
>
>> v.info    reports that there are 2 db links.
>
>> v.info -c map=locn layer=2   reports list of columns in layer 2
>
> However, commands such as v.label, d.vect.thematic, d.vect, v.extract,
> etc are unable to access layer 2. Also, if using the windows which
> pop-up (instead of the command line) for any of these commands, you
> cannot change the layer option from "1" to "2" (or any other layer
> value).
>
> example output...
>> v.label labels=alt_nme map=locn col=othnme layer=2
> gives error...  "Sorry, <col=> is ambiguous"
>
> Does anyone have any ideas as to whether multiple layers works in winGRASS?
>
> Thanks in advance,
>
> Sharon
> _______________________________________________
> grass-user mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/grass-user
>
_______________________________________________
grass-windows mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/grass-windows
sharon m-2

Re: [GRASS-user] Multiple attribute tables in winGRASS 6.4

Reply Threaded More More options
Print post
Permalink
Hello Colin

I've downloaded and installed winGRASS r38959.

I used db.connect to define ODBC connection
Used db.login to define user
Ran db.tables -p
- this generates error with pop-up window appearing: odbc.exe has
encountered a problem and needs to close

Regards,

Sharon

On Sun, Sep 6, 2009 at 6:41 AM, Colin Nielsen<[hidden email]> wrote:

> I've just uploaded a new version (r38959) with ODBC support enabled.
> Please test it out and let us know if it is working properly. I hope
> this solves your issue Sharon. (Please remember that it can take up to
> 24 hours before the new updates make it to all the web mirrors).
>
> -Colin
>
> On Fri, Sep 4, 2009 at 2:54 AM, Sharon M<[hidden email]> wrote:
>> Hi,
>>
>> I'm hoping the general GRASS mailing list community can help me.
>>
>> I'm using winGRASS 6.4 (r38875) on windows XP and using DBF files
>> (oracle and ODBC is not currently supported in winGRASS).
>>
>> I'm able to connect an additional attribute table containing
>> alternative names to a vector map. The cat columns in layer 1 and
>> layer 2 are the same (numbers 1-25). e.g.
>>
>>> v.db.connect map=locn layer=2 key=cat table=locn_tbl2
>>
>> If I bring up the attribute window manager, I can see the new table is
>> in layer 2.
>>
>>> v.info    reports that there are 2 db links.
>>
>>> v.info -c map=locn layer=2   reports list of columns in layer 2
>>
>> However, commands such as v.label, d.vect.thematic, d.vect, v.extract,
>> etc are unable to access layer 2. Also, if using the windows which
>> pop-up (instead of the command line) for any of these commands, you
>> cannot change the layer option from "1" to "2" (or any other layer
>> value).
>>
>> example output...
>>> v.label labels=alt_nme map=locn col=othnme layer=2
>> gives error...  "Sorry, <col=> is ambiguous"
>>
>> Does anyone have any ideas as to whether multiple layers works in winGRASS?
>>
>> Thanks in advance,
>>
>> Sharon
>> _______________________________________________
>> grass-user mailing list
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/grass-user
>>
>
_______________________________________________
grass-windows mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/grass-windows
Sebastian_2009

Re: [GRASS-user] Multiple attribute tables in winGRASS 6.4

Reply Threaded More More options
Print post
Permalink
Hi,

Has this issue been fixed?  I have a very similar problem.  v.db.addtable does not work when I try to add an attribute table to layer 2 as described by the previous poster.  Howvere, I get an empty shell prompt and no pop-up.

I downloaded what purported to be r39626 (27-Oct-2009, currently available from the download site).  However, when I open WinGrass and get the help info it reports that it is version r37101 (2009-05-10).  Either the release that is linked in as the current download is incorrect and points to an old version or the 'About' blurb has not been updated.

Can you confirm that I have the most up to date version and whether the v.db.addtable bug has been fixed?

Many thanks




sharon m-2 wrote:
Hello Colin

I've downloaded and installed winGRASS r38959.

I used db.connect to define ODBC connection
Used db.login to define user
Ran db.tables -p
- this generates error with pop-up window appearing: odbc.exe has
encountered a problem and needs to close

Regards,

Sharon

On Sun, Sep 6, 2009 at 6:41 AM, Colin Nielsen<colin.nielsen@gmail.com> wrote:
> I've just uploaded a new version (r38959) with ODBC support enabled.
> Please test it out and let us know if it is working properly. I hope
> this solves your issue Sharon. (Please remember that it can take up to
> 24 hours before the new updates make it to all the web mirrors).
>
> -Colin
>
> On Fri, Sep 4, 2009 at 2:54 AM, Sharon M<morrisxs09@gmail.com> wrote:
>> Hi,
>>
>> I'm hoping the general GRASS mailing list community can help me.
>>
>> I'm using winGRASS 6.4 (r38875) on windows XP and using DBF files
>> (oracle and ODBC is not currently supported in winGRASS).
>>
>> I'm able to connect an additional attribute table containing
>> alternative names to a vector map. The cat columns in layer 1 and
>> layer 2 are the same (numbers 1-25). e.g.
>>
>>> v.db.connect map=locn layer=2 key=cat table=locn_tbl2
>>
>> If I bring up the attribute window manager, I can see the new table is
>> in layer 2.
>>
>>> v.info    reports that there are 2 db links.
>>
>>> v.info -c map=locn layer=2   reports list of columns in layer 2
>>
>> However, commands such as v.label, d.vect.thematic, d.vect, v.extract,
>> etc are unable to access layer 2. Also, if using the windows which
>> pop-up (instead of the command line) for any of these commands, you
>> cannot change the layer option from "1" to "2" (or any other layer
>> value).
>>
>> example output...
>>> v.label labels=alt_nme map=locn col=othnme layer=2
>> gives error...  "Sorry, <col=> is ambiguous"
>>
>> Does anyone have any ideas as to whether multiple layers works in winGRASS?
>>
>> Thanks in advance,
>>
>> Sharon
>> _______________________________________________
>> grass-user mailing list
>> grass-user@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/grass-user
>>
>
_______________________________________________
grass-windows mailing list
grass-windows@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-windows