[Qgis-user] Suggestions to make a simple db

[Antonio Viscomi]

Ciao Giuseppe,
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!
In altre parole puoi linkare esclusivamente classi di valore
corrispondente! 1 e 1, 2 e 2, ecc.
Spero di essere stato chiaro
Antonio
Il giorno 12/set/2013 18:11, "venerio giuseppe anardu" <anardu.geol at yahoo.it>
ha scritto:

> 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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130912/405e2290/attachment.html>