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 time. You can easily try out yourself, but see my next point.
Whether that is a smart thing to do is another point. Depending on how
you set up your GRASS database, you might end up having layers with the
same name in different mapsets or locations. In that case, you will run
into trouble; you can't have more then one table with the same name in
your SQLite database. I would therefore recommend having one SQLite
database per mapset. There are also plans for a SQLite database per
layer. I am not sure what would be the advantage of that though.
I am not sure about your second question, but GRASS 7 uses the SQLite
database by default.
Paulo
On 04/09/2012 09:04 AM, Micha Silver wrote:
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 its own sqlite db file?
I'm pretty sure it's per mapset.
Have a look at this nice summary blog post about db connections (from
2009, but still accurate)
http://casoilresource.lawr.ucdavis.edu/drupal/node/733
Currently, I'm using v6.4.2 which uses DBF by default. Is there a command
that can switch the installation to using SQLite as the default, so that
mapsets in subsequently created locations will use Sqlite? Or I need to
reconfigure the installation (i.e., the ./configure options prior to
make/make install)?
Thanks,
Richard
--
View this message in
context:http://osgeo-org.1560.n6.nabble.com/getting-from-DBF-to-SQLite-tp4657601p4715248.html
Sent from the Grass - Users mailing list archive at Nabble.com.
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
This mail was received via Mail-SeCure System.
--
Micha Silver
052-3665918
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
