Hello to everybody,

I'm a beginner in the study of db and right now I'm co-working with a team 
involved in wetlands. I would like to manage a qgis project of a swamp, joining 
to a shapefile of the sampling points a csv file containing the different 
species of algae found in each sample point and I would like to do in a simple 
way considering the few points and samples I have to manage.
The structure of the attributes table of the point shapefile is made of 2 
fields: "ID" and "Sample points"

ID    | Sample points
____|____________________
0     |  1
1     |  2
2     |  3

The structure of the csv file is made also of 2 fields: "Stations" and 
"Species".

Stations  |  Species
________|____________________
1            |   Barbula unguiculata
1            |   Bryum sp.
1            |  Funaria hygrometrica
3            |   Barbula unguiculata
3            |   Barbula unguiculata   

The field to join is "Sample points" and "Stations". 
From properties I made a Join, but the result I obtain is (the samples of point 
2 are missing dued to draught):

Sample point  |  Species
____________|___________________
1                   |  Barbula unguiculata
2                    |  NULL
3                   |  Barbula unguiculata   

Is there a way to include in the project all the species for each sampling 
point? In wich way the db may be structured and managed with qgis, maybe using 
Excel or Access or the equivalents of Open Office?
With many thanks in advance,
Giuseppe
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to