comparison db_schema/setup-db.sh @ 1207:6692b3bdc49d

Backout 2f9dfd292ff1 because it reverts d667092cc788. What it intended to fix should have been fixed already with 7f4c473e7856.
author Tom Gottfried <tom@intevation.de>
date Fri, 02 Dec 2016 20:22:56 +0100
parents 2f9dfd292ff1
children ba47994c1665 512616ea3228
comparison
equal deleted inserted replaced
1206:4df70458164d 1207:6692b3bdc49d
119 echo create schema geo 119 echo create schema geo
120 psql $DB_CONNECT_STRING -d $DB_NAME --command "CREATE SCHEMA geo AUTHORIZATION $ROLE_NAME" 120 psql $DB_CONNECT_STRING -d $DB_NAME --command "CREATE SCHEMA geo AUTHORIZATION $ROLE_NAME"
121 121
122 echo downlaod and import german administrative borders 122 echo downlaod and import german administrative borders
123 TS="0101" 123 TS="0101"
124 cd /tmp
124 if [ ! -f vg250_${TS}.utm32s.shape.ebenen.zip ]; then 125 if [ ! -f vg250_${TS}.utm32s.shape.ebenen.zip ]; then
125 curl -O \ 126 curl -O \
126 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip 127 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip
127 fi 128 fi
128 unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" 129 unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*"
130 # cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/
129 shp2pgsql -s 25832:4326 vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME 131 shp2pgsql -s 25832:4326 vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME
132 # rm -rf vg250_${TS}.utm32s.shape.ebenen
130 133
131 echo fille stammdaten.verwaltungsgrenze 134 echo fille stammdaten.verwaltungsgrenze
132 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql 135 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql
133 136
134 if [ -f $DIR/lada_auth.sql ]; then 137 if [ -f $DIR/lada_auth.sql ]; then
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)