Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/model/BedHeight.java @ 9706:299c1c61d8ef

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
zu 1.1. Sohlhöhen-Überlappung
author dnt_bjoernsen <d.tironi@bjoernsen.de>
date Fri, 22 Jan 2021 12:28:58 +0100
parents 3f4215ddd6b4
children
rev   line source
5844
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
2 * Software engineering by Intevation GmbH
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
3 *
5992
4c3ccf2b0304 Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
4 * This file is Free Software under the GNU AGPL (>=v3)
5844
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
5992
4c3ccf2b0304 Removed trailing whitespace.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5844
diff changeset
6 * documentation coming with Dive4Elements River for details.
5844
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
7 */
4dd33b86dc61 Added header to river backend.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5838
diff changeset
8
5829
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
9 package org.dive4elements.river.model;
2809
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 import java.io.Serializable;
9246
c08d5cfa4981 some hibernate queries on bedheigts for salix
gernotbelger
parents: 9245
diff changeset
12 import java.util.ArrayList;
2809
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 import java.util.List;
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14
8975
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
15 import javax.persistence.Column;
2809
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16 import javax.persistence.Entity;
8975
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
17 import javax.persistence.GeneratedValue;
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
18 import javax.persistence.GenerationType;
2809
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 import javax.persistence.Id;
8975
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
20 import javax.persistence.JoinColumn;
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
21 import javax.persistence.OneToMany;
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
22 import javax.persistence.OneToOne;
2809
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23 import javax.persistence.SequenceGenerator;
8975
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
24 import javax.persistence.Table;
2872
bcfdaa3a5bfc Added functions to BedHeightSingle and BedHeightEpoch to get instances from db by id or river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2809
diff changeset
25
5829
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
26 import org.dive4elements.river.backend.SessionHolder;
8975
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
27 import org.hibernate.Query;
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
28 import org.hibernate.Session;
2872
bcfdaa3a5bfc Added functions to BedHeightSingle and BedHeightEpoch to get instances from db by id or river.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 2809
diff changeset
29
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
30 import com.vividsolutions.jts.util.Assert;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
31
2809
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 @Entity
8560
6fcf4717605f Meta-data on sounding width associated to bed heights is redundant to real data associated to values.
"Tom Gottfried <tom@intevation.de>"
parents: 5992
diff changeset
33 @Table(name = "bed_height")
6fcf4717605f Meta-data on sounding width associated to bed heights is redundant to real data associated to values.
"Tom Gottfried <tom@intevation.de>"
parents: 5992
diff changeset
34 public class BedHeight implements Serializable {
2809
f283212966e8 Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
36 private Integer id;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
37 private Integer year;
8975
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
38
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
39 private String evaluationBy;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
40 private String description;
8975
a0a0a7f912ab Added new columns bed_height.comment and sounding_width_info; extended the bed height parser for the new meta data and the min/max_height columns
mschaefer
parents: 8942
diff changeset
41
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
42 private River river;
9246
c08d5cfa4981 some hibernate queries on bedheigts for salix
gernotbelger
parents: 9245
diff changeset
43
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
44 private BedHeightType type;
9246
c08d5cfa4981 some hibernate queries on bedheigts for salix
gernotbelger
parents: 9245
diff changeset
45
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
46 private LocationSystem locationSystem;
9246
c08d5cfa4981 some hibernate queries on bedheigts for salix
gernotbelger
parents: 9245
diff changeset
47
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
48 private ElevationModel curElevationModel;
9246
c08d5cfa4981 some hibernate queries on bedheigts for salix
gernotbelger
parents: 9245
diff changeset
49
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
50 private ElevationModel oldElevationModel;
9246
c08d5cfa4981 some hibernate queries on bedheigts for salix
gernotbelger
parents: 9245
diff changeset
51
9706
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
52 private Range range;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
53
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
54 private String sounding_width_info;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
55 private String notes;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
56
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
57 private List<BedHeightValue> values;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
58
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
59 public static BedHeight copyPojoFrom(BedHeight b, double from, double to) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
60 List<BedHeightValue> values2 = b.getValues();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
61 List<BedHeightValue> copyValueList = new ArrayList<>();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
62
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
63 BedHeight copy = new BedHeight(b.getRiver(), b.getYear(), b.getType(), b.getLocationSystem(),
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
64 b.getCurElevationModel(), b.getOldElevationModel(), new Range(from, to, b.getRange().getRiver()),
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
65 b.getEvaluationBy(), b.getDescription(), b.getSoundingWidthInfo(), b.getNotes());
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
66
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
67 for (BedHeightValue val : values2) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
68 Double station = val.getStation();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
69 if (station >= from && station <= to)
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
70 copyValueList.add(val);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
71 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
72
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
73 copy.setValues(copyValueList);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
74 return copy;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
75 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
76
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
77 public BedHeight() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
78 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
79
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
80 public BedHeight(final River river, final Integer year, final BedHeightType type,
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
81 final LocationSystem locationSystem, final ElevationModel curElevationModel, final Range range) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
82 this(river, year, type, locationSystem, curElevationModel, null, range, null, null, null, null);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
83 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
84
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
85 public BedHeight(final River river, final Integer year, final BedHeightType type,
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
86 final LocationSystem locationSystem, final ElevationModel curElevationModel,
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
87 final ElevationModel oldElevationModel, final Range range, final String evaluationBy,
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
88 final String description, final String sounding_width_info, final String notes) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
89 this.river = river;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
90 this.year = year;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
91 this.type = type;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
92 this.locationSystem = locationSystem;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
93 this.curElevationModel = curElevationModel;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
94 this.oldElevationModel = oldElevationModel;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
95 this.range = range;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
96 this.evaluationBy = evaluationBy;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
97 this.description = description;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
98 this.sounding_width_info = sounding_width_info;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
99 this.notes = notes;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
100 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
101
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
102 @Id
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
103 @SequenceGenerator(name = "SEQUENCE_BED_HEIGHT_ID_SEQ", sequenceName = "BED_HEIGHT_ID_SEQ", allocationSize = 1)
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
104 @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_BED_HEIGHT_ID_SEQ")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
105 @Column(name = "id")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
106 public Integer getId() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
107 return this.id;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
108 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
109
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
110 public void setId(final Integer id) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
111 this.id = id;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
112 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
113
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
114 @OneToOne
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
115 @JoinColumn(name = "river_id")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
116 public River getRiver() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
117 return this.river;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
118 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
119
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
120 public void setRiver(final River river) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
121 this.river = river;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
122 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
123
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
124 @Column(name = "year")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
125 public Integer getYear() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
126 return this.year;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
127 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
128
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
129 public void setYear(final Integer year) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
130 this.year = year;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
131 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
132
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
133 @OneToOne
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
134 @JoinColumn(name = "type_id")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
135 public BedHeightType getType() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
136 return this.type;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
137 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
138
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
139 public void setType(final BedHeightType type) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
140 this.type = type;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
141 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
142
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
143 @OneToOne
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
144 @JoinColumn(name = "location_system_id")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
145 public LocationSystem getLocationSystem() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
146 return this.locationSystem;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
147 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
148
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
149 public void setLocationSystem(final LocationSystem locationSystem) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
150 this.locationSystem = locationSystem;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
151 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
152
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
153 @OneToOne
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
154 @JoinColumn(name = "cur_elevation_model_id")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
155 public ElevationModel getCurElevationModel() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
156 return this.curElevationModel;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
157 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
158
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
159 public void setCurElevationModel(final ElevationModel curElevationModel) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
160 this.curElevationModel = curElevationModel;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
161 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
162
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
163 @OneToOne
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
164 @JoinColumn(name = "old_elevation_model_id")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
165 public ElevationModel getOldElevationModel() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
166 return this.oldElevationModel;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
167 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
168
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
169 public void setOldElevationModel(final ElevationModel oldElevationModel) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
170 this.oldElevationModel = oldElevationModel;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
171 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
172
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
173 @OneToOne
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
174 @JoinColumn(name = "range_id")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
175 public Range getRange() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
176 return this.range;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
177 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
178
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
179 public void setRange(final Range range) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
180 this.range = range;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
181 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
182
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
183 @Column(name = "evaluation_by")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
184 public String getEvaluationBy() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
185 return this.evaluationBy;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
186 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
187
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
188 public void setEvaluationBy(final String evaluationBy) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
189 this.evaluationBy = evaluationBy;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
190 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
191
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
192 @Column(name = "description")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
193 public String getDescription() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
194 return this.description;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
195 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
196
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
197 public void setDescription(final String description) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
198 this.description = description;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
199 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
200
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
201 @Column(name = "sounding_width_info")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
202 public String getSoundingWidthInfo() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
203 return this.sounding_width_info;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
204 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
205
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
206 public void setSoundingWidthInfo(final String sounding_width_info) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
207 this.sounding_width_info = sounding_width_info;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
208 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
209
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
210 @Column(name = "notes")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
211 public String getNotes() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
212 return this.notes;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
213 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
214
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
215 public void setNotes(final String notes) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
216 this.notes = notes;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
217 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
218
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
219 @OneToMany
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
220 @JoinColumn(name = "bed_height_id")
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
221 public List<BedHeightValue> getValues() {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
222 return this.values;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
223 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
224
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
225 public void setValues(final List<BedHeightValue> values) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
226 this.values = values;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
227 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
228
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
229 public static List<BedHeight> getBedHeights(final River river, final double kmLo, final double kmHi) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
230 return getBedHeights(river, kmLo, kmHi, false);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
231 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
232
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
233 /**
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
234 * Fetch the soundings with values in a river km range, optionally only those
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
235 * that also have field 01 etc. values
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
236 */
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
237 public static List<BedHeight> getBedHeights(final River river, final double startKm, final double endKm,
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
238 final boolean withHeightFieldsOnly) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
239
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
240 final Session session = SessionHolder.HOLDER.get();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
241
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
242 final String fieldsClause = withHeightFieldsOnly ? " AND (height01 IS NOT NULL)" : "";
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
243 final Query query = session.createQuery(
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
244 "FROM BedHeight" + " WHERE (river=:river)" + " AND (id IN (SELECT bedHeight.id FROM BedHeightValue"
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
245 + " WHERE (station BETWEEN :kmfrom - 0.0001 AND :kmto + 0.0001)" + fieldsClause
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
246 + " GROUP BY bed_height_id))");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
247 query.setParameter("river", river);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
248 query.setParameter("kmfrom", startKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
249 query.setParameter("kmto", endKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
250
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
251 final List<BedHeight> singles = query.list();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
252
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
253 return ((singles != null) && !singles.isEmpty()) ? singles : null;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
254 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
255
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
256 public static BedHeight getBedHeightById(final int id) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
257 final Session session = SessionHolder.HOLDER.get();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
258
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
259 final Query query = session.createQuery("from BedHeight where id=:id");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
260
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
261 query.setParameter("id", id);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
262
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
263 final List<BedHeight> singles = query.list();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
264
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
265 return ((singles != null) && !singles.isEmpty()) ? singles.get(0) : null;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
266 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
267
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
268 public static BedHeight getBedHeightByDescription(final River river, final String description, final double startKm,
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
269 final double endKm) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
270
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
271 final Session session = SessionHolder.HOLDER.get();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
272
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
273 final Query query = session
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
274 .createQuery("FROM BedHeight" + " WHERE (TRIM(description)=:description) AND river=:river"
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
275 + " AND id IN (SELECT bedHeight.id FROM BedHeightValue"
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
276 + " WHERE station BETWEEN :kmfrom AND :kmto" + " GROUP BY bedHeight.id)");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
277 query.setParameter("river", river);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
278 query.setParameter("description", description);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
279 query.setParameter("kmfrom", startKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
280 query.setParameter("kmto", endKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
281
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
282 final List<BedHeight> singles = query.list();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
283
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
284 return ((singles != null) && !singles.isEmpty()) ? singles.get(0) : null;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
285 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
286
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
287 public static List<BedHeight> getBedHeightEpochs(final River river, final double startKm, final double endKm) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
288
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
289 final Session session = SessionHolder.HOLDER.get();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
290 final String description = "epoch";
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
291 final Query query = session.createQuery("FROM BedHeight" + " WHERE lower(description) LIKE :description AND "
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
292 + "river=:river" + " AND id IN (SELECT bedHeight.id FROM BedHeightValue"
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
293 + " WHERE station BETWEEN :kmfrom AND :kmto" + " GROUP BY bedHeight.id)");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
294 query.setParameter("river", river);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
295 query.setParameter("description", "%" + description + "%");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
296 query.setParameter("kmfrom", startKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
297 query.setParameter("kmto", endKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
298
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
299 final List<BedHeight> singles = query.list();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
300
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
301 return ((singles != null) && !singles.isEmpty()) ? singles : null;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
302 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
303
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
304 public static List<BedHeight> getBedHeightYear(final River river, final double startKm, final double endKm) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
305
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
306 final Session session = SessionHolder.HOLDER.get();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
307 final String description = "epoch";
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
308 final Query query = session
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
309 .createQuery("FROM BedHeight" + " WHERE lower(description) NOT LIKE :description AND " + "river=:river"
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
310 + " AND id IN (SELECT bedHeight.id FROM BedHeightValue"
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
311 + " WHERE station BETWEEN :kmfrom AND :kmto" + " GROUP BY bedHeight.id)");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
312 query.setParameter("river", river);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
313 query.setParameter("description", "%" + description + "%");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
314 query.setParameter("kmfrom", startKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
315 query.setParameter("kmto", endKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
316
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
317 final List<BedHeight> singles = query.list();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
318
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
319 return ((singles != null) && !singles.isEmpty()) ? singles : null;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
320 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
321
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
322 public static Range getRangeFromBedHeights(final BedHeight bh) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
323 final List<Range> ranges = new ArrayList<>();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
324
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
325 final Session session = SessionHolder.HOLDER.get();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
326
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
327 final Query query = session.createQuery("FROM Range" + " WHERE id=:range_id)");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
328 query.setParameter("range_id", bh.getRange().getId());
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
329
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
330 final List<Range> singles = query.list();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
331
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
332 return ((singles != null) && !singles.isEmpty()) ? singles.get(0) : null;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
333 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
334
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
335 public static List<BedHeight> getBedHeightYearEpoch(final boolean isEpoch, final Integer year, final River river,
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
336 final double lowerKm, final double upperKm) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
337
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
338 final Session session = SessionHolder.HOLDER.get();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
339 final String description = "epoch";
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
340
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
341 final StringBuilder builder = new StringBuilder();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
342 builder.append("FROM BedHeight");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
343 if (isEpoch) {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
344 builder.append(" WHERE lower(description) LIKE :description ");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
345 } else {
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
346 builder.append(" WHERE lower(description) NOT LIKE :description ");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
347 }
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
348 builder.append(" AND year =:year");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
349
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
350 builder.append(
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
351 " AND river=:river AND id IN (SELECT bedHeight.id FROM BedHeightValue WHERE station BETWEEN :kmfrom AND :kmto GROUP BY bedHeight.id )");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
352 final Query query = session.createQuery(builder.toString());
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
353 query.setParameter("river", river);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
354 query.setParameter("year", year);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
355 query.setParameter("description", "%" + description + "%");
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
356 query.setParameter("kmfrom", lowerKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
357 query.setParameter("kmto", upperKm);
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
358
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
359 final List<BedHeight> singles = query.list();
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
360
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
361 return ((singles != null) && !singles.isEmpty()) ? singles : null;
299c1c61d8ef zu 1.1. Sohlhöhen-Überlappung
dnt_bjoernsen <d.tironi@bjoernsen.de>
parents: 9447
diff changeset
362 }
9211
aca5a7a57a3a SINFO-TKH: definition der standard sohlhöhen jetzt mit Gültigkeitsstrecke. Definitionsdateien aufgeteilt in eine pro Gewässer.
gernotbelger
parents: 9098
diff changeset
363 }
http://dive4elements.wald.intevation.org