[Qgis-user] Link tables

[Matt C]

In 1.6, Vector->Join creates a new shapefile with the data in it. The 
tab in 1.7 creates a dynamic join, which is preferable. If you use 
PostGIS or SpatiaLite as a backend, you can use a view to do a dynamic 
join in your spatial database, like so (in PostGIS):
CREATE VIEW geocode AS SELECT rooms.gid, rooms_centroids.room_no, 
rooms.bldglevel, rooms.msg_en, rooms_centroids.the_geom
    FROM rooms, rooms_centroids
   WHERE rooms.room_no = rooms_centroids.room_no;

This creates a new view that uses the room_no and geometry from 
rooms_centroids, and the gid, bldglevel and msg_en from rooms.
-Matt

On 05/10/2011 07:58 AM, Ramon Andinach wrote:
> On 10/05/2011, at 21:03 , Chris Buddenhagen wrote:
>
>> How can I link species occurrences with county names to the county shape file to display counties when I click or query a species?
>>
>> Chris Buddenhagen
> As the species occurrence list has county names, you could use a JOIN to link the two files together.
> In 1.6 it's in the vector menu list.
> In 1.7 it's a tab in the layer properties dialogue.
>
> QGIS is able to open non-spatial CSV or DBF format files through the Add Vector system.
>
> Does this help?
>
> -ramon._______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user