update_cadastre_adresses.sh

#!/bin/bash

set -e

source config

cd $CADASTRE_CACHE_DIR
for dep in `cat $BANO_DIR/deplist.txt`
do
    echo 'Département '$dep
	wget -NS https://adresse.data.gouv.fr/data/adresses-cadastre/latest/csv/adresses-cadastre-$dep.csv.gz
    quoted_dep=\'$dep'%'\'
    $pgsql_OSM -c "DELETE FROM bal_cadastre WHERE commune_code LIKE $quoted_dep;"
    gunzip -c $CADASTRE_CACHE_DIR/adresses-cadastre-$dep.csv.gz| $pgsql_OSM -c "\copy bal_cadastre from stdin with csv header delimiter ';'"
    sleep 1
done