I'm wondering if there is a way to join aspatial Postgis tables to spatial ones in QGIS.
Target scenario: a spatial table of site locations a table of species observations at each location. In Postgis I can (obviously) create a view joining these two tables on location_id. 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. 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. 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. Is there a way to implement such a join (link?) in QGIS? Ideally using multiple attributes, just to make it more complicated :-) Thanks, Brent Wood
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
