Welcome to datapool’s documentation!

The Datapool is the EAWAG data warehouse package designed for storing sensor data and provides for a series of functionalities in order to add, modify and delete data sources.

How are you going to use the datapool?

1. If you want to work with data stored in the datapool, read Instructions for data users.

2. If you want to load sensor measurements in the datapool, read Instructions for data provider.

Content:

• Instructions for data users
  • First steps with the Datapool
  • Connect to the Datapool
  • Python
  • R
  • Example SQL queries
• Instructions for data provider
  • System Architecture
  • General workflow
  • Add Raw Data to Existing Source
  • Add Site
  • Add or Modify Parameters
  • Add a new Source Type
  • Add and Modify Projects
  • Add Source Instance
• Instructions for Admin
  • Installation on Ubuntu 20.04
  • Update Datapool
  • Access to log files
  • Further Tips
  • Clean Up tmp Files in Datapool Container
  • Backup and Restore Database
  • Adding Packages to R, Python, Julia
  • Migrating Datapool_1 to Datapool_2
• Database layout
  • Tables:
  • Design principles
• Usage Examples
  • Renaming
  • Deletion
• Command references
• How to contribute to documentation
  • Initialization
  • Typical workflow
• Obsolete documentation
  • Run server in test mode
  • Workflow example
  • Deprecated (DP1 to DP1): Data Migration to another Datapool Instance

The datapool source code can be found here.