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