<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div id="yiv0127511160"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:12pt;"><div id="yiv0127511160yui_3_7_2_78_1378812973096_85"><br></div><div id="yiv0127511160yui_3_7_2_78_1378812973096_86">I'm wondering if there is a way to join aspatial Postgis tables to spatial ones in QGIS.</div><div id="yiv0127511160yui_3_7_2_78_1378812973096_93"><br id="yiv0127511160yui_3_7_2_78_1378812973096_98"></div><div style="color:rgb(0, 0, 0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;" id="yiv0127511160yui_3_7_2_78_1378812973096_95">Target scenario: <br id="yiv0127511160yui_3_7_2_78_1378812973096_104"></div><div id="yiv0127511160yui_3_7_2_78_1378812973096_101" style="color:rgb(0, 0,
0);font-size:16px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;">a spatial table of site locations<br></div><div class="yiv0127511160yui_3_7_2_78_1378812973096_60" id="yiv0127511160yui_3_7_2_78_1378812973096_61" style="font-family:times new roman, new york, times, serif;font-size:12pt;"><div id="yiv0127511160yui_3_7_2_78_1378812973096_73" class="yiv0127511160yui_3_7_2_78_1378812973096_64" style="font-family:times new roman, new york, times, serif;font-size:12pt;">a table of species observations at each location.<br><br>In Postgis I can (obviously) create a view joining these two tables on location_id.<br> </div> </div> <span id="yiv0127511160yui_3_7_2_78_1378812973096_113"><br>However, this means that if I have 40 species observed at a location, I get 40 copies of the same point, each with one species. This is NOT what I want.<br><br>What I want to do is retain the one point representing the
location, but when clicking on it, retrieve the 40 species that have the ID. <br><br>I had a brief try at running this as an action, passing in the required parameters to psql, but getting a passworded connection to work from the command line, & escaping all the embedded quotes put this in the too
hard basket. Maybe run it via a shell script? This is also likely to be feasible for me running Linux, but more problematic under Windows (most other users), and not a simple, generic solution. <br><br>Is there a way to implement such a join (link?) in QGIS? Ideally using multiple attributes, just to make it more complicated :-)<br><br><br>Thanks,<br><br> Brent Wood<br></span><div></div></div></div></div></div></body></html>