Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1056:299f4ba86090
extend docker envireoment to load geographical data of german comunities
| author | Michael Stanko <mstanko@bfs.de> |
|---|---|
| date | Wed, 28 Sep 2016 09:06:18 +0200 |
| parents | bc44dcda6f69 |
| children | 4ce4bd48c260 |
comparison
equal
deleted
inserted
replaced
| 1055:37952c111f71 | 1056:299f4ba86090 |
|---|---|
| 75 echo import stammdaten | 75 echo import stammdaten |
| 76 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql | 76 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql |
| 77 | 77 |
| 78 echo import lada test data | 78 echo import lada test data |
| 79 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_data.sql | 79 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_data.sql |
| 80 | |
| 81 echo create user $ROLE_NAME | |
| 82 psql $DB_CONNECT_STRING -d $DB_NAME --command "CREATE SCHEMA geo AUTHORIZATION $ROLE_NAME" | |
| 83 | |
| 84 TS="0101" | |
| 85 cd /tmp | |
| 86 curl -O http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip && \ | |
| 87 unzip vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" | |
| 88 cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/ | |
| 89 shp2pgsql VG250_GEM geo.gem_utm | psql $DB_CONNECT_STRING -d $DB_NAME | |
| 90 cd /tmp | |
| 91 rm -rf vg250_${TS}.utm32s.shape.ebenen* | |
| 80 fi | 92 fi |