Data handling in WOSIS

Course title: Introduction to databases and WOSIS
Course code:  
Subject areas (Curriculum): Database Design, Data manipulation and Access
Duration: 0.5 day
Short description: Module teaches an introduction to databases and general soil database design, outlines problems of data standardisation and harmonisation and concludes with some practical sessions on these issues.
Moderators: Dr JS (Jorge) Mendes de Jesus
Target audience: MSc and PhD level students working primarily with soil data. DSM teams and project participants.
Requirements: Knowledge of SQL is benificial

Programme:

  1. Introduction to realtional  and spatial databases
  2. Introduction to soil data modeling in databases
  3. WOSIS structure
  4. Practicals for data access query and manipulation

Objective:

Enable users to undestand database usage, design and access

Enable users to understand how soil data is modeled in databases

Software / materials:

NA

Case studies:

NA

Literature:

WOSIS Presentation

https://docs.google.com/document/d/1FKNs1zWd7FxKjU2w0nbZc0tPLdiZjpIazXguP7pvFSw/edit?usp=sharing

WOSIS Exercises

https://gsif.googlecode.com/svn/trunk/WOSIS/WOSIS_examples.R