[GRASS-user] simple way to join some attribute data w/o geometries

[Markus Neteler]

Benjamin,

On Jan 8, 2008 9:58 AM, Benjamin Ducke <benjamin.ducke at ufg.uni-kiel.de> wrote:
...
> So the problem is that an optimal solution is not so
> much about performance or flexibility (which can be
> had with SQLite, no doubt) but showing people that
> there are straight-forward solutions for doing things
> in GRASS that they are accustomed to in ArcGIS.

Well, with SQLite it is straightforward (nothing to learn, just
use it instead of DBF).

> The solution for this needs to be simple and should
> not involve too much data conversion or the use of
> external tools and drivers that may not be present
> in the GRASS/QGIS download bundle ...

The simple steps are
- install SQLite (it does not need setup but works out of
  the box)
- set the DBMI settings with db.connect (see manual page
  for copy-paste example)
- use v.db.join
- use g.copy or db.copy to easily transform from DBF (or whatever
  to SQLite). These two modules do all the work.

Markus