Mercurial > dive4elements > river
annotate etl/src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties @ 6048:caf9d989bd84
Fix waterlevel classes and change defaults for them.
If to is 0 then we create a class that goes to 9999
If step is 0 then we only have a single step >= 0
The defaults are now from 0, to 2m with a step of 0.5
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Fri, 17 May 2013 17:56:20 +0200 |
| parents | 5aa05a7a34b7 |
| children |
| rev | line source |
|---|---|
|
5258
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
1 next.gauge.id = \ |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
2 SELECT GAUGES_ID_SEQ.NEXTVAL AS gauge_id FROM DUAL |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
3 next.timeinterval.id = \ |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
4 SELECT TIME_INTERVALS_ID_SEQ.NEXTVAL AS time_interval_id FROM DUAL |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
5 next.discharge.id = \ |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
6 SELECT DISCHARGE_TABLES_ID_SEQ.NEXTVAL AS discharge_table_id FROM DUAL |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
7 next.discharge.table.values.id = \ |
|
da1e897c7224
Set the BFG_ID for current discharge tables in FLYS.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4108
diff
changeset
|
8 SELECT DISCHARGE_TABLE_VALUES_ID_SEQ.NEXTVAL AS discharge_table_values_id FROM DUAL |