<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt">Hello to everybody,<br><br>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.<br>The structure of the attributes table of the point shapefile is made of 2 fields: "ID" and "Sample points"<br><br>ID<span class="tab"> | </span>Sample points<br><span class="tab">____|____________________</span><br>0<span class="tab"> | 1</span><br>1<span class="tab"> | 2</span><br>2<span class="tab"> | 3</span><br><br>The structure of the csv file
is made also of 2 fields: "Stations" and "Species".<br><br>Stations<span class="tab"> | </span><span class="tab"> S</span><span class="tab">pecies<br>________|____________________<br>1 </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> | </span><span class="tab"> </span><span class="tab"> Barbula unguiculata<br>1 </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> | </span><span class="tab"> </span><span class="tab"> Bryum sp.<br>1 </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> |</span><span class="tab"> </span><span class="tab"> Funaria hygrometrica<br>3 </span><span class="tab"> </span><span
class="tab"> </span><span class="tab"> | </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> Barbula unguiculata<br>3</span><span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> | </span><span class="tab"> </span><span class="tab"> Barbula unguiculata</span><span class="tab"> </span><br><br>The field to join is "Sample points" and "Stations". <br>From properties I made a Join, but the result I obtain is (the samples of point 2 are missing dued to draught):<br><br>Sample point<span class="tab"> | </span>Species<br>____________|___________________<br>1<span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span
class="tab"> </span><span class="tab"> | Barbula unguiculata<br>2</span><span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> | </span><span class="tab">NULL<br>3</span><span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> </span><span class="tab"> | </span><span class="tab">Barbula unguiculata</span><span class="tab"> <br><br>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?<br>With many
thanks in advance,<br>Giuseppe<br></span><div><br></div></div></body></html>