<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="latin-charset" bgcolor="#FFFFFF"
text="#000000">
On 06/13/2012 03:28 PM, Moritz Lennert wrote:
<blockquote cite="mid:4FD88775.8050703@club.worldonline.be"
type="cite">On 12/06/12 23:21, Rich Shepard wrote:
<br>
<blockquote type="cite"> Two tables: 'sites' contains the ID and
geographic coordinates;
<br>
'waterchem' contains the ID and water chemistry data. The latter
table is a
<br>
sub-set of the former.
<br>
<br>
I want to display only those sites for which chemistry data are
available.
<br>
In postgres I write,
<br>
<br>
SELECT DISTINCT(w.site) FROM waterchem AS w
<br>
WHERE EXISTS (SELECT s.name FROM sites AS s
<br>
WHERE w.site = s.name);
<br>
<br>
Can I submit this same query within GRASS and have the returned
sites
<br>
displayed by location? If so, is there a preferred method for
doing so?
<br>
</blockquote>
<br>
Just use everything after the first WHERE as argument for the
'where' parameter of d.vect (or any other module with a where
parameter).
<br>
<br>
</blockquote>
<br>
<br>
Sorry to butt in...<br>
Can you have a where="" argument that references a table other than
the actual vector map's table?<br>
<br>
I tried with i.e. v.extract (to select records from a vector based
on a related column in another, separate table, and I wasn't
successful.<br>
?<br>
Is there any way to connect a vector map to a PG view ?<br>
<br>
Thanks,<br>
Micha<br>
<br>
<br>
<blockquote cite="mid:4FD88775.8050703@club.worldonline.be"
type="cite">Moritz
<br>
_______________________________________________
<br>
grass-user mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
<br>
<br>
This mail was received via Mail-SeCure System.
<br>
<br>
<br>
</blockquote>
<p><br>
</p>
</body>
</html>