This repository is a collection of bash and python scripts for query, download and upload (to local postgresql db) of Sentinel 2 images in the scope of my Master Thesis

Processing steps

• query (with awsdownload)
• download (with sentinelhub)
• (optional) atmospheric correction (sen2cor)
• conversion to .tif (with GDAL)
• upload to PostgreSQL+PostGIS

clone repository

git clone https://github.com/MarcCoru/S2preprocessing.git

satellite data query

https://github.com/kraftek/awsdownload/releases/download/1.7/ProductDownload-1.7

satellite data download

https://github.com/sentinel-hub/sentinelhub-py

sh query.sh sites/munich.site

creates $queryfile containing product names

sh download.sh sites/munich.site

python delGranules.py sites/munich.site

Dry run flag -d only simulates deletion

python delGranules.py sites/munich.site -d

the config file must include a granules variable e.g.

granules="32UPU 32UQU 33UTP 33UUP"

Here is an online tool to determine Granules

sh sen2cor.sh sites/munich.site

The Sentinel 2 atomspheric correction config file L2A_GIPP.xml is by default stored in the project root directory. However, the location can be changed in the config file using the L2A_GIPP_path variable

Add a "is evaluate" column to a polygon dataset

sh addEvalField.sh sites/bavaria.site tiles eval "0.8" ""

Add a "is train" column to a polygon dataset (eval=1 are excluded)

sh addEvalField.sh sites/bavaria.site tiles train "0.75" "where eval=0"

enable gdal drivers via (as sudo user: $sudo -u postgres -d <database>)

SET postgis.gdal_enabled_drivers = 'ENABLE_ALL';
ALTER SYSTEM SET postgis.gdal_enabled_drivers TO 'GTiff PNG JPEG';
SELECT pg_reload_conf();

test if drivers are enabled via

SELECT short_name, long_name FROM ST_GDALDrivers();