Skip to content

Latest commit

 

History

History
61 lines (53 loc) · 2.44 KB

program.md

File metadata and controls

61 lines (53 loc) · 2.44 KB
Raw

Dealing with Spatio-Temporal Data in Movement and Population Ecology: PROGRAM

0. Introduction to Data Management in Movement and Population Ecology (Cagnacci & Urbano)

  • 0.1 Introduction to spatial objects in animal ecology
  • 0.2 Introduction to Data Management and Spatial Database
  • 0.3 Installation of PostgreSQL/PostGIS and pgAdmin
  • 0.4 Connection to the database tracking_db
  • 0.5 Exploration of pgAdmin Interface

1. SQL and Spatial SQL (Urbano & Johannes De Groeve)

  • 1.1 Introduction to SQL
  • 1.2 Overview of the database used for the exercises
  • 1.3 Schemas, tables, data types
  • 1.4 SELECT, FROM, WHERE
  • 1.5 AND, OR, IN, !=, NULL
  • 1.6 ORDER BY, LIMIT, DISTINCT, CASE, CAST, COALESCE
  • 1.7 LIKE
  • 1.8 GROUP BY (COUNT, SUM, MIN, MAX, AVG, STDDEV)
  • 1.9 HAVING
  • 1.10 Joining multiple tables
  • 1.11 LEFT JOIN
  • 1.12 Subqueries used in FROM statement, WITH
  • 1.13 WINDOW functions
  • 1.14 INSERT, UPDATE, DELETE
  • 1.15 Temporal data (date, time, timezone), EXTRACT
  • 1.16 Spatial objects in PostGIS
  • 1.17 Create a point from coordinates
  • 1.18 Reference systems and projections
  • 1.19 Visualize spatial data in QGIS
  • 1.20 Create a line from ordered points (trajectory)
  • 1.21 Calculate distance between points and length of a trajectory
  • 1.22 Create a polygon from points (convex hull)
  • 1.23 Views

2. Movement Ecology Data Management with PostgreSQL/PostGIS (Urbano & Johannes De Groeve)

  • 2.1 Introduction to the goals and the datasets
  • 2.2 Create a db and import sensor data
  • 2.3 Create acquisition timestamps, indexes and permissions
  • 2.4 Managing and modelling information on animals and sensors
  • 2.5 From data to information: associating locations to animals
  • 2.6 Manage the location data in a spatial database
  • 2.7 From locations to trajectories and home ranges
  • 2.8 Integrating spatial ancillary information
  • 2.9 Data quality: how to detect and manage outliers
  • 2.10 Data export
  • 2.11 Backup and restore of the db created in Section 2
  • 2.12 Recap exercises
  • 2.13 Raster Data in PostGIS (demo)
  • 2.14 Functions and triggers (supplementary material)

3. Movement Ecology Data Analysis with R (Basille)

4. From Population Data to Spatial Modelling (Nilsen)

5. Resource Selection Analysis in Movement Ecology (Van Loon)

6. Special Topics

  • 6.1 The Ecological Context Built from Satellites, including Sentinel (Rocchini)
  • 6.2 Dealing with Acceleration Data (Berger)
  • 6.3 Data sharing and Data Standards for a Better Science (Davidson)