File tree Expand file tree Collapse file tree 2 files changed +5
-5
lines changed
Expand file tree Collapse file tree 2 files changed +5
-5
lines changed Original file line number Diff line number Diff line change 33DIR=$( echo $( dirname $0 ) )
44cd $DIR
55
6- month=" 06 "
6+ month=" 12 "
77year_end=" 2022"
88
99sudo -u postgres psql -c " DROP DATABASE IF EXISTS dvf_${year_end}${month} ;"
@@ -15,7 +15,7 @@ sudo -u postgres psql -d dvf_${year_end}${month} -f "create_table.sql"
1515DATADIR=" data"
1616mkdir -p $DATADIR
1717
18- for YEAR in {2017 ..2022}
18+ for YEAR in {2018 ..2022}
1919do
2020 [ ! -f $DATADIR /full_$YEAR .csv.gz ] && wget -r -np -nH -N --cut-dirs 5 https://files.data.gouv.fr/geo-dvf/latest/csv/$YEAR /full.csv.gz -O $DATADIR /full_$YEAR .csv.gz
2121done
@@ -24,7 +24,7 @@ find $DATADIR -name '*.gz' -exec gunzip -f '{}' \;
2424
2525# Chargement des données dans postgres
2626DATAPATH=$( cd $DATADIR ; pwd -P )
27- for YEAR in {2017 ..2022}
27+ for YEAR in {2018 ..2022}
2828do
2929 sudo -u postgres psql -d dvf_$year_end$month -c " COPY dvf FROM '$DATAPATH /full_$YEAR .csv' delimiter ',' csv header encoding 'UTF8';"
3030done
Original file line number Diff line number Diff line change @@ -24,8 +24,8 @@ vue.$watch('fold_left', function () {
2424
2525// Définition des variables globales
2626
27- var MIN_DATE = '2017-07 -01'
28- var MAX_DATE = '2022-06-30 '
27+ var MIN_DATE = '2018-01 -01'
28+ var MAX_DATE = '2022-12-31 '
2929
3030var map = null ;
3131var mapLoaded = false ;
You can’t perform that action at this time.
0 commit comments