[GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-04-09 Thread Glynn Clements
RichardC wrote: > Is it is possible to set a single SQLite database for the entire GRASS GIS > database or each mapset requires its own sqlite db file? It is possible, but then you have to worry about name collisions. Some vector commands will try to create a table with the same name as the map,

Re: [GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-04-09 Thread Rich Shepard
On Sun, 8 Apr 2012, RichardC wrote: Is it is possible to set a single SQLite database for the entire GRASS GIS database or each mapset requires its own sqlite db file? No. You can have multiple tables in each SQLite database. Currently, I'm using v6.4.2 which uses DBF by default. Is there

Re: [GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-04-09 Thread Paulo van Breugel
You can define the SQLite database yourself with db.connect. The database does only contain the attribute data, no geometric information, so you could define the same SQLite database for different mapsets and even locations. I tried this actually out some time ago, and it worked for me at the t

Re: [GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-04-09 Thread Micha Silver
On 09/04/2012 09:47, RichardC wrote: Hi, I'm also planning to move from the DBF to SQLite database, and was wondering if you might be able to help with the following. Is it is possible to set a single SQLite database for the entire GRASS GIS database or each mapset requires

[GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-04-08 Thread RichardC
Hi, I'm also planning to move from the DBF to SQLite database, and was wondering if you might be able to help with the following. Is it is possible to set a single SQLite database for the entire GRASS GIS database or each mapset requires its own sqlite db file? Currently, I'm using v6.4.2 which

[GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-03-26 Thread Michael Barton
This worked. I must have specified it incorrectly the first time. Thanks On Mar 26, 2012, at 11:27 AM, Martin Landa wrote: > 2012/3/26 Michael Barton : >> GRASS 6.4.3svn (Spain_utm_ed50z30):~ > db.connect driver=sqlite > > you need to define also database (file). Typically > `$GISDBASE/$LOCATIO

Re: [GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-03-26 Thread Rich Shepard
On Mon, 26 Mar 2012, Michael Barton wrote: I thought I did that, but will try again with your line copied exactly. Thanks Michael, You can locate the database anywhere you want. When you run db.connect pass it the driver and database name, then ensure that you're logged it to use it via db.

[GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-03-26 Thread Michael Barton
I thought I did that, but will try again with your line copied exactly. Thanks Michael On Mar 26, 2012, at 11:27 AM, Martin Landa wrote: > 2012/3/26 Michael Barton : >> GRASS 6.4.3svn (Spain_utm_ed50z30):~ > db.connect driver=sqlite > > you need to define also database (file). Typically > `$GIS

[GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-03-26 Thread Martin Landa
2012/3/26 Michael Barton : > GRASS 6.4.3svn (Spain_utm_ed50z30):~ > db.connect driver=sqlite you need to define also database (file). Typically `$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db` Martin -- Martin Landa * http://geo.fsv.cvut.cz/~landa ___ gr

[GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-03-26 Thread Michael Barton
On Mar 26, 2012, at 11:15 AM, Martin Landa wrote: > 2012/3/26 Michael Barton : >> I thought I could just set db.connect to sqlite and copy the vectors, but >> that doesn't seem to work. > > in which sense it doesn't work? Thanks Martin, Here is what happens. Perhaps this does not work in GRASS

[GRASS-user] Re: [GRASS-dev] getting from DBF to SQLite

2012-03-26 Thread Martin Landa
2012/3/26 Michael Barton : > I thought I could just set db.connect to sqlite and copy the vectors, but > that doesn't seem to work. in which sense it doesn't work? Martin -- Martin Landa * http://geo.fsv.cvut.cz/~landa ___ grass-user mailing list gra