Mercurial > lada > lada-server
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 |