# HG changeset patch # User Tom Gottfried # Date 1480706576 -3600 # Node ID 6692b3bdc49d9e669914dfef3a28b0b5658cd844 # Parent 4df70458164d1b44f1c32f49b2785eb7f9d895b4 Backout 2f9dfd292ff1 because it reverts d667092cc788. What it intended to fix should have been fixed already with 7f4c473e7856. diff -r 4df70458164d -r 6692b3bdc49d db_schema/setup-db.sh --- a/db_schema/setup-db.sh Fri Dec 02 20:13:12 2016 +0100 +++ b/db_schema/setup-db.sh Fri Dec 02 20:22:56 2016 +0100 @@ -121,12 +121,15 @@ 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