<p dir="ltr">Ciao Giuseppe,<br>
Il motivo per cui il link alla stazione 2 ti da null è che se tu linki al csv, dove la classe 2 esiste, ai punti dove non è contemplata il 2 corrispondente al link diventa null!<br>
In altre parole puoi linkare esclusivamente classi di valore corrispondente! 1 e 1, 2 e 2, ecc.<br>
Spero di essere stato chiaro<br>
Antonio </p>
<div class="gmail_quote">Il giorno 12/set/2013 18:11, "venerio giuseppe anardu" <<a href="mailto:anardu.geol@yahoo.it">anardu.geol@yahoo.it</a>> ha scritto:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:10pt;font-family:arial,helvetica,sans-serif">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> | </span>Sample points<br><span>____|____________________</span><br>0<span> | 1</span><br>
1<span> | 2</span><br>2<span> | 3</span><br><br>The structure of the csv file
is made also of 2 fields: "Stations" and "Species".<br><br>Stations<span> | </span><span> S</span><span>pecies<br>________|____________________<br>1 </span><span> </span><span> </span><span> | </span><span> </span><span> Barbula unguiculata<br>
1 </span><span> </span><span> </span><span> | </span><span> </span><span> Bryum sp.<br>1 </span><span> </span><span> </span><span> |</span><span> </span><span> Funaria hygrometrica<br>3 </span><span> </span><span> </span><span> | </span><span> </span><span> </span><span> Barbula unguiculata<br>
3</span><span> </span><span> </span><span> </span><span> | </span><span> </span><span> Barbula unguiculata</span><span> </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> | </span>Species<br>____________|___________________<br>1<span> </span><span> </span><span> </span><span> </span><span> </span><span> | Barbula unguiculata<br>
2</span><span> </span><span> </span><span> </span><span> </span><span> | </span><span>NULL<br>3</span><span> </span><span> </span><span> </span><span> </span><span> </span><span> </span><span> | </span><span>Barbula unguiculata</span><span> <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></div><br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div>