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 |