[GRASSLIST:665] Re: borehole database question

[Jaime Carrera]

Hi Patricio,
 
 AFAIK in order to link one vector file (e.g. location of boreholes) with an attribute table (e.g. lithology data) you need an unique identifier on both. Thus it is not possible to link the id of table 1 with the id of table 2 as id2 is not unique. 
 What I do to overcome this is to use the psql terminal to query the database.
  
 HTH
 
 Jaime

Patricio Antonio Toledo Peña <patricioantoniotoledo at gmail.com> escribió: 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 

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/ 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20060411/31755137/attachment.html