SQL & python

This recipe implements the GeoPackage Good Practice for Soil Data by converting a sample soil database to GeoPackage based on the INSPIRE Soil Model using SQL statements from a Python environment.

REQUIREMENTS - basic understanding of python and sql concepts - running environment python, pip, virtualenv (or alternative)

Setup a python environment

virtualenv soildata
cd soildata
. bin/activate

Clone the workshop environment and install python requirements

git clone 
pip install -r requirements.txt

As a soil database we use the SOTER database of Cuba which is available as Microsoft Access mdb as well as SQLite.