samedi 29 novembre 2014

Diverse values to one field for soil analysis


I have soil analysis data in an exel table. There are for one analysis point three depths. I want to transform these data into gis-data. What is the common way, to add three values in an field of one row or similar.


Example (exel table): point depth pH-value 1 0-20 4 1 20-40 5 1 40-60 7 2 ....


This could look like this in a shape file: point depth pH-value 1 0-20;20-40;40-60 4;5;7


I think this is not nice for doing queries. But when I make one column for each depth and soil value the table would have about 120 columns :(


Any common way to do so?





Aucun commentaire:

Enregistrer un commentaire