annotate backend/contrib/run_geo.sh @ 8943:71b17f731762

Same data types, precision and scale as in Oracle (as far as possible)
author mschaefer
date Tue, 13 Mar 2018 09:42:41 +0100
parents f7c49975cc15
children
rev   line source
7458
b2e167f193d7 run_geo.sh: allow logging as documented.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6815
diff changeset
1 #!/bin/bash
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
3 # Set this to your target database for Oracle
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 HOST=localhost
6658
89f856e24d27 Importer scripts: shpimporter needs backend name to play with Oracle.
Tom Gottfried <tom@intevation.de>
parents: 6651
diff changeset
5 BACKEND_NAME="XE"
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
6 USER=flys28
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
7 PASS=flys28
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
8 # Alternatively you can provide a direct connection string:
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
9 # OGR_CONNECTION="PG:dbname=flys host=localhost port=5432 user=flys password=flys"
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 # Optional
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12 VERBOSE=1
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 SKIP_AXIS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14 SKIP_KMS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15 SKIP_CROSSSECTIONS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16 SKIP_FIXPOINTS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17 SKIP_BUILDINGS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 SKIP_FLOODPLAINS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 SKIP_HYDR_BOUNDARIES=0
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
20 SKIP_HWS_LINES=0
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
21 SKIP_HWS_POINTS=0
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22 SKIP_UESG=0
5035
1f33012cc02a Add skip-dgm option to example run script
Andre Heinecke <aheinecke@intevation.de>
parents: 4996
diff changeset
23 SKIP_DGM=0
5353
d086ce6c13d3 Add jetties importer
Andre Heinecke <aheinecke@intevation.de>
parents: 5074
diff changeset
24 SKIP_JETTIES=0
5545
ed149d5d7fb7 Add floodmarks importer
Andre Heinecke <aheinecke@intevation.de>
parents: 5353
diff changeset
25 SKIP_FLOODMARKS=0
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
26
6651
8782ba5cb222 Importer scripts: add default encoding to correctly read gew-files
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
27 # Default encoding. Change here if necessary
8782ba5cb222 Importer scripts: add default encoding to correctly read gew-files
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
28 export LC_ALL=de_DE@euro
8782ba5cb222 Importer scripts: add default encoding to correctly read gew-files
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
29
5066
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
30 # There should be no need to change anything below this line
6805
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
31 GEW_FILE="$1"
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
32 RIVER_NAME=$(grep "Gew.sser" "$1" | sed 's/Gew.sser: //')
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
33
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
34 RIVER_PATH=$(grep "WSTDatei:" "$GEW_FILE" | awk '{print $2}')
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
35 RIVER_PATH=$(dirname "$RIVER_PATH")/../..
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
36 RIVER_PATH=$(readlink -f "$RIVER_PATH")
5066
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
37
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 DIR=`dirname $0`
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 DIR=`readlink -f "$DIR"`
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 exec python $DIR/shpimporter/shpimporter.py \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
42 --directory $RIVER_PATH \
5563
673f68bb19a4 Geo-importer: accept river names with white space
Tom Gottfried <tom@intevation.de>
parents: 5545
diff changeset
43 --river_name "$RIVER_NAME" \
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
44 --ogr_connection "$OGR_CONNECTION" \
6658
89f856e24d27 Importer scripts: shpimporter needs backend name to play with Oracle.
Tom Gottfried <tom@intevation.de>
parents: 6651
diff changeset
45 --host $HOST/$BACKEND_NAME \
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 --user $USER \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 --password $PASS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48 --verbose $VERBOSE \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49 --skip_axis $SKIP_AXIS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50 --skip_kms $SKIP_KMS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51 --skip_crosssections $SKIP_CROSSSECTIONS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52 --skip_fixpoints $SKIP_FIXPOINTS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
53 --skip_buildings $SKIP_BUILDINGS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
54 --skip_floodplains $SKIP_FLOODPLAINS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
55 --skip_hydr_boundaries $SKIP_HYDR_BOUNDARIES \
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
56 --skip_uesgs $SKIP_UESG \
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
57 --skip_hws_lines $SKIP_HWS_LINES \
5035
1f33012cc02a Add skip-dgm option to example run script
Andre Heinecke <aheinecke@intevation.de>
parents: 4996
diff changeset
58 --skip_hws_points $SKIP_HWS_POINTS \
5353
d086ce6c13d3 Add jetties importer
Andre Heinecke <aheinecke@intevation.de>
parents: 5074
diff changeset
59 --skip_dgm $SKIP_DGM \
5545
ed149d5d7fb7 Add floodmarks importer
Andre Heinecke <aheinecke@intevation.de>
parents: 5353
diff changeset
60 --skip_jetties $SKIP_JETTIES \
7458
b2e167f193d7 run_geo.sh: allow logging as documented.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6815
diff changeset
61 --skip_floodmarks $SKIP_FLOODMARKS \
b2e167f193d7 run_geo.sh: allow logging as documented.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6815
diff changeset
62 2>&1

http://dive4elements.wald.intevation.org