# HG changeset patch # User Michael Stanko # Date 1480685373 -3600 # Node ID 2f9dfd292ff12e48ab17f725022f5c5bb0e01e5c # Parent 61106ead36fc2b789b2858ce191bf97fa6ecc270 fix bug in setup-db.sh diff -r 61106ead36fc -r 2f9dfd292ff1 db_schema/setup-db.sh --- a/db_schema/setup-db.sh Thu Dec 01 16:36:04 2016 +0100 +++ b/db_schema/setup-db.sh Fri Dec 02 14:29:33 2016 +0100 @@ -121,15 +121,12 @@ echo downlaod and import german administrative borders TS="0101" - cd /tmp if [ ! -f vg250_${TS}.utm32s.shape.ebenen.zip ]; then curl -O \ http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip fi unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" -# cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/ shp2pgsql -s 25832:4326 vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME -# rm -rf vg250_${TS}.utm32s.shape.ebenen echo fille stammdaten.verwaltungsgrenze psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql