# HG changeset patch
# User Raimund Renkert <raimund.renkert@intevation.de>
# Date 1480431288 -3600
# Node ID 00323d9e642cc25cf078a3402a7932655ea510d7
# Parent  d667092cc7880f454f06a73a792d47ae3cd7f581
Import german administrative borders using EPSG:4326.

diff -r d667092cc788 -r 00323d9e642c db_schema/setup-db.sh
--- a/db_schema/setup-db.sh	Tue Nov 29 15:51:17 2016 +0100
+++ b/db_schema/setup-db.sh	Tue Nov 29 15:54:48 2016 +0100
@@ -93,7 +93,7 @@
     fi
     unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*"
 #    cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/
-    shp2pgsql vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME
+    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
@@ -104,3 +104,5 @@
         psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_auth.sql
     fi
 fi
+
+exec /opt/lada_sql/alter_owner.sh