[GRASSLIST:664] borehole database question

[Patricio Antonio Toledo Peña]

Dear grasslist

Suppose i do have a data base with two tables.

The first table with geographic information of boreholes: east,
west, and elevation coordinates an id and some other information
like quality and observations.

id    | east    | west    | elev    | quality
-----------------------------------------------
1    | xx1      | yy1      | zz1      | blah blah
2    | xx2      | yy2      | zz2      | blah blah

The second table is the log information of the boreholes. For each id
(each borehole) it has multiple records with, let's say, stratigraphic
information: top level, base level a geological description, maybe some
rock type classification and so on.

id     | cat     | top     | bottom     | log
-----------------------------------------------
1      | 1        | z11    | z12           | rock
1      | 2        | z21    | z22           | another rock
1      | 3        | z31    | z32           | soil
2      | 4        | z41    | z42           | rock

The question is:

if i have loaded the borehole table into grass with v.in.db.
Which is the method to connect the log table with the borehole
vector, indeed how do i display the borehole data and query the
log table over a borehole point?

d.vect borehole
d.what.vect -t log ?

--
Patricio Toledo Peña
Dpto. de Geofísica - Universidad de Chile
Blanco Encalada 2002-Casilla 2777
Santiago-Chile
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20060411/d62ded83/attachment.html