Mercurial > dive4elements > river
annotate etl/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 8653:dbec49147f54
(issue1755) Do not create interpolated themes and disable export of non interpolatable data.
Due to the fact that data can contain NaN's which will be filtered out
before creating the interpolator this requires the actual check
for interpolatable data when data is set in the ResultValue
| author | Andre Heinecke <andre.heinecke@intevation.de> |
|---|---|
| date | Wed, 01 Apr 2015 17:10:03 +0200 |
| parents | 5aa05a7a34b7 |
| children |
| rev | line source |
|---|---|
|
4775
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
1 select.abflusstafel = \ |
|
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
2 SELECT ABFLUSSTAFEL_NR, \ |
|
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
3 ABFLUSSTAFEL_BEZ, \ |
|
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
4 GUELTIG_VON, \ |
|
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
5 GUELTIG_BIS, \ |
|
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
6 PEGELNULLPUNKT, \ |
|
5480
7a68967ca72a
AFT/DIPS: Small fixes and workarounds for Oracle DB problems.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4775
diff
changeset
|
7 AT.BFG_ID \ |
|
7a68967ca72a
AFT/DIPS: Small fixes and workarounds for Oracle DB problems.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4775
diff
changeset
|
8 FROM ABFLUSSTAFEL AT \ |
|
4775
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
9 WHERE MESSSTELLE_NR LIKE :number |