#!/bin/bash
# SET SOME VARIABLES
TOPICS=4

TOPIC_1="te"
VERSION_TOPIC_1="habitats_and_biotopes.ecoregions2017_oneearth_clean"
FID_TOPIC_1="eco_id"

TOPIC_2="fe"
VERSION_TOPIC_2="habitats_and_biotopes.freshwater_ecoregions"
FID_TOPIC_2="eco_id"

TOPIC_3="me"
VERSION_TOPIC_3="habitats_and_biotopes.meow"
FID_TOPIC_3="first_level_code"

TOPIC_4="pe"
VERSION_TOPIC_4="habitats_and_biotopes.ppow"
FID_TOPIC_4="first_level_code"

# GRID SIZE IN DEGREES, INTEGER SUBMULTIPLE OF 180
GS=1 #DEFAULT is 1 DEGREE

# CELL SIZE IN ARCSEC, INTEGER SUBMULTIPLE OF 3600
CS=1 #DEFAULT is 1 ARCSEC

# FOLDER TO KEEP EXTRA SQL
SQL="sql"

## database parameters
HOST=
USER=
DB=
SCH="ecoregions_2024"
PO=

# DO NOT TOUCH THE FOLLOWING VALUES
dbpar1="host=${HOST} user=${USER} dbname=${DB} port=${PO}"
dbpar2="-h ${HOST} -U ${USER} -d ${DB} -p ${PO}"
RWS=$((180/GS)) # NUMBER OF ROWS IN THE GRID
CLS=$((360/GS)) # NUMBER OF COLUMNS IN THE GRID
RCC=$((3600/CS)) # NUMBER OF ROWS/COLUMNS FOR CELL
RCCT=$((RCC*GS)) # NUMBER OF ROWS/COLUMNS FOR TILE