MetaCatalog Data Loader

This is a containerized Python tool to use MetaCatalog, a metadata and data source catalog to download data. The data is requested for a spatial and temporal extent, as specified in the metadata catalog, to be consistent across scales. An implementation for this tool is the V-FOR-WaTer platform.

This tool follows the Tool Specification for reusable research software using Docker.

Description

MetaCatalog stores metadata about internal and external datasets along with information about the data sources and how to access them. Using this tool, one can request datasets (called entries in MetaCatalog) by their id. Additionally, an area of interest is supplied as a GeoJSON feature, called reference area.

The database of the connected MetaCatalog instance is queried for the dataset_ids. The data-files are reuqested for the temporal extent of start_date and end_date if given, while the spatial extent is requested for the bounding box of reference_area. MetaCatalog entires without either of the scales defined are loaded entierly. Finally, the spatial extent is clipped by the reference_area to match exactly. Experimental parameters are not yet exposed, but involve:

- `netcdf_backend`, which can be either `'CDO'` or `'xarray'` (default) can switch the software used for the clip
of NetCDF data sources, which are commonly used for spatio-temporal datasets.

All processed data-files for each source are then saved to /out/datasets/, while multi-file sources are saved to child repositories. The file (or folder) names are built like: <variable_name>_<entry_id>.

Parameters

| Parameter | Description | | --- | --- | | datasetids | An array of integers referencing the IDs of the dataset entries in MetaCatalog. | | referencearea | A valid GeoJSON POLYGON Feature. Areal datasets will be clipped to this area. | | startdate | The start date of the dataset, if a time dimension applies to the dataset. | | enddate | The end date of the dataset, if a time dimension applies to the dataset. | | cell_touches | Specifies if an areal cell is part of the reference area if it only touches the geometry. |

Development and local run

New database

Either for development or local usage of this container, there is a docker-compose.yml file in there. It starts a PostgreSQL / PostGIS database, which persists its data into a local pg_data folder. The loader service will run the tool, with the local ./in and ./out mounted into the tool container and the database correctly connected. That means, you can adjust the examples in ./in and run the container using docker compose:

docker compose up -d

Obviously, on first run, there won't be a metacatalog initialized. There are examples at /examples/, which load different datasets into the same database instance, which can then be used. Alternatively, you can populate the database by hand. To create the necessary database structure, you can run the loader service but overwrite the default container command with a python console:

docker compose run --rm -it loader python

Then run:

python from metacatalog import api session = api.connect_database() api.create_tables(session) api.populate_defaults(session) exit()

Existing database

If you want to run the tool on an existing database, change the METACATALOG_URI in the docker-compose.yml. Remember, that this will still spin up the database service, thus, for production, you should either remove the database service from the docker-compose.yml, or use docker without docker compose, like:

docker build -t vfw_loader . docker run --rm -it -v /path/to/local/in:/in -v /path/to/local/out:out -v /path/to/local/datafiles:/path/to/local/datafiles -e METACATALOG_URI="postgresql..." vfw_loader

Structure

This container implements a common file structure inside container to load inputs and outputs of the tool. it shares this structures with the Python template, R template, NodeJS template and Octave template, but can be mimiced in any container.

Each container needs at least the following structure:

/ |- in/ | |- inputs.json |- out/ | |- ... |- src/ | |- tool.yml | |- run.py | |- CITATION.cff

• inputs.json are parameters. Whichever framework runs the container, this is how parameters are passed.
• tool.yml is the tool specification. It contains metadata about the scope of the tool, the number of endpoints (functions) and their parameters
• run.py is the tool itself, or a Python script that handles the execution. It has to capture all outputs and either print them to console or create files in /out
• CITATION.cff Citation file providing bibliographic information on how to cite this tool.

Does run.py take runtime args?:

Currently, the only way of parameterization is the inputs.json. A parameterization via arguments will likely be added in the future.

How to build the image?

You can build the image from within the root of this repo by docker build -t vfw_loader .

The images are also built by a GitHub Action on each release.