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

TOPIC_1="get_major"
VERSION_TOPIC_1="iucn_get_last.iucn_get_major"
FID_TOPIC_1="cn"

TOPIC_2="get_minor"
VERSION_TOPIC_2="iucn_get_last.iucn_get_minor"
FID_TOPIC_2="cn"

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

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

# FOLDER TO KEEP EXTRA SQL
SQL="sql"

## database parameters
HOST="x"
USER="x"
DB="x"
SCH="iucn_get_flat"
PO=x

# 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