Wednesday, 26 October 2016
In this OpenEarth workshop, following the Earth Observation and Data Science symposium,
we will demonstrate the use of a relational (geo)database to deal with oceanographic data.
As an example, data from the ICES oceanographic database (International Council for the Exploration of the Sea, www.ices.dk) will be used, containing over a million stations with CTD profiles and bottle data.
Each session will start with a short introduction presentation, but most of the time is reserved for hands-on exercises. So, bring your own laptop (see also note on requirements below) and if possible also your own data to work with. In the morning we will start to install the software, then insert data into the database and finally structure it for optimal use. In the afternoon there is room to work in parallel sessions with a variety of applications to interact with the database.
- When using a relational database?
- Installing software (a.o. postgreSQL/postGIS)
- Inserting data into database
- The use of a data model
- Structuring data with a data model
Session 3+4 (afternoon, 2 parallel sessions)
- Reading, analyzing and visualizing data
- Python (iPython notebook)
- Extract-transform-load (ETL) tools
Please be aware of the following requirements:
- You will need admin rights for installation of the software during session 1
- For session 3+4 (afternoon): please make sure to have your preferred programming language installed
You might also be interested in:
- Symposium Earth Observation and Data Science,
- XBeach and Earth Observation course,
- Python Scripting in Delft3D Flexible Mesh.
Registration for events through My DSD-INT 2016: To sign up for courses, workshops and seminars, you need to register yourself for a My DSD account. Creating an account is free of charge and with no obligation to participate. Via My DSD, it is possible to view specific events and sign up to participate. Your My DSD account then provides an overview of all the events for which you are registered. You will also receive a confirmation e-mail for each registration.