Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1193:00323d9e642c
Import german administrative borders using EPSG:4326.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Tue, 29 Nov 2016 15:54:48 +0100 |
| parents | d667092cc788 |
| children | fffd66b6ee8a |
comparison
equal
deleted
inserted
replaced
| 1192:d667092cc788 | 1193:00323d9e642c |
|---|---|
| 91 curl -O \ | 91 curl -O \ |
| 92 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip | 92 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip |
| 93 fi | 93 fi |
| 94 unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" | 94 unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" |
| 95 # cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/ | 95 # cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/ |
| 96 shp2pgsql vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME | 96 shp2pgsql -s 25832:4326 vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME |
| 97 # rm -rf vg250_${TS}.utm32s.shape.ebenen | 97 # rm -rf vg250_${TS}.utm32s.shape.ebenen |
| 98 | 98 |
| 99 echo fille stammdaten.verwaltungsgrenze | 99 echo fille stammdaten.verwaltungsgrenze |
| 100 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql | 100 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql |
| 101 | 101 |
| 102 if [ -f $DIR/lada_auth.sql ]; then | 102 if [ -f $DIR/lada_auth.sql ]; then |
| 103 echo load private auth configuration | 103 echo load private auth configuration |
| 104 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_auth.sql | 104 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_auth.sql |
| 105 fi | 105 fi |
| 106 fi | 106 fi |
| 107 | |
| 108 exec /opt/lada_sql/alter_owner.sh |