Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1203:2f9dfd292ff1
fix bug in setup-db.sh
| author | Michael Stanko <mstanko@bfs.de> |
|---|---|
| date | Fri, 02 Dec 2016 14:29:33 +0100 |
| parents | 7f4c473e7856 |
| children | 6692b3bdc49d |
comparison
equal
deleted
inserted
replaced
| 1202:61106ead36fc | 1203:2f9dfd292ff1 |
|---|---|
| 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 | |
| 125 if [ ! -f vg250_${TS}.utm32s.shape.ebenen.zip ]; then | 124 if [ ! -f vg250_${TS}.utm32s.shape.ebenen.zip ]; then |
| 126 curl -O \ | 125 curl -O \ |
| 127 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip | 126 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip |
| 128 fi | 127 fi |
| 129 unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" | 128 unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" |
| 130 # cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/ | |
| 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 | 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 |
| 132 # rm -rf vg250_${TS}.utm32s.shape.ebenen | |
| 133 | 130 |
| 134 echo fille stammdaten.verwaltungsgrenze | 131 echo fille stammdaten.verwaltungsgrenze |
| 135 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql | 132 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql |
| 136 | 133 |
| 137 if [ -f $DIR/lada_auth.sql ]; then | 134 if [ -f $DIR/lada_auth.sql ]; then |