Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/model/HydrBoundaryPoly.java @ 8813:8abe94270f32

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Do not filter cross section points for display. Filtering coordinates outside an extent probably aimed at omitting outliers from the diagram. This is obsolete and had the side effect of filtering the important point at x = 0.
author Tom Gottfried <tom@intevation.de>
date Fri, 28 Apr 2017 19:03:56 +0200
parents 4c3ccf2b0304
children 5e38e2924c07
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;
2868
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 import java.io.Serializable;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12 import java.util.List;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14 import javax.persistence.Column;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15 import javax.persistence.Entity;
5098
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
16 import javax.persistence.GeneratedValue;
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
17 import javax.persistence.GenerationType;
2868
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 import javax.persistence.Id;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 import javax.persistence.JoinColumn;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 import javax.persistence.OneToOne;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21 import javax.persistence.Table;
5098
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
22 import javax.persistence.SequenceGenerator;
2868
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24 import org.hibernate.Session;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
25 import org.hibernate.Query;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
26 import org.hibernate.annotations.Type;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 import com.vividsolutions.jts.geom.Geometry;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29
5829
18619c1e7c2a Repaired internal references.
Sascha L. Teichmann <teichmann@intevation.de>
parents: 5828
diff changeset
30 import org.dive4elements.river.backend.SessionHolder;
2868
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 @Entity
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 @Table(name = "hydr_boundaries_poly")
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35 public class HydrBoundaryPoly
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
36 implements Serializable
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 private Integer id;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 private String name;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40 private River river;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 private Geometry geom;
5062
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
42 private SectieKind sectie;
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
43 private SobekKind sobek;
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
44 private BoundaryKind kind;
2868
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 public HydrBoundaryPoly() {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50 @Id
5098
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
51 @SequenceGenerator(
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
52 name = "SEQUENCE_HYDR_BOUNDARIES_POLY_ID_SEQ",
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
53 sequenceName = "HYDR_BOUNDARIES_POLY_ID_SEQ",
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
54 allocationSize = 1)
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
55 @GeneratedValue(
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
56 strategy = GenerationType.SEQUENCE,
a2600507761e Add sequences to the new tables that use sequences
Andre Heinecke <aheinecke@intevation.de>
parents: 5089
diff changeset
57 generator = "SEQUENCE_HYDR_BOUNDARIES_POLY_ID_SEQ")
2868
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
58 @Column(name = "id")
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
59 public Integer getId() {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
60 return id;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
61 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
62
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
63
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
64 public void setId(Integer id) {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
65 this.id = id;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
66 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
67
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
68
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
69 @OneToOne
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70 @JoinColumn(name = "river_id")
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
71 public River getRiver() {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
72 return river;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
73 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
74
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
75
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76 public void setRiver(River river) {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
77 this.river = river;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
78 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
79
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
80
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
81 @Column(name = "name")
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
82 public String getName() {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
83 return name;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
84 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
85
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
86
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
87 public void setName(String name) {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
88 this.name = name;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
89 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
90
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
91
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
92 @Column(name = "geom")
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
93 @Type(type = "org.hibernatespatial.GeometryUserType")
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
94 public Geometry getGeom() {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
95 return geom;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
96 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
97
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
98
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
99 public void setGeom(Geometry geom) {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
100 this.geom = geom;
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
101 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
102
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
103
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
104 public static List<HydrBoundaryPoly> getHydrBoundaries(int riverId, String name) {
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
105 Session session = SessionHolder.HOLDER.get();
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
106
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
107 Query query = session.createQuery(
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
108 "from HydrBoundaryPoly where river.id =:river_id and name=:name");
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
109 query.setParameter("river_id", riverId);
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
110 query.setParameter("name", name);
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
111
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
112 return query.list();
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
113 }
5062
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
114
5515
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
115 public static List<HydrBoundaryPoly> getHydrBoundaries(int riverId,
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
116 int kind, int sectie, int sobek) {
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
117 Session session = SessionHolder.HOLDER.get();
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
118
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
119 String filter = " where river.id =:river_id";
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
120
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
121 if (kind != -1) {
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
122 filter += " and kind = " + kind;
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
123 }
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
124 if (sectie != -1) {
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
125 filter += " and sectie = " + sectie;
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
126 }
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
127 if (sobek != -1){
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
128 filter += " and sobek = " + sobek;
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
129 }
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
130
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
131 Query query = session.createQuery("from HydrBoundaryPoly" + filter);
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
132 query.setParameter("river_id", riverId);
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
133 return query.list();
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
134 }
87dab419b924 Properly handle hydr_boundaries and hydr_boundaries_poly in datacage
Andre Heinecke <aheinecke@intevation.de>
parents: 5098
diff changeset
135
5062
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
136 /**
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
137 * Get sectie.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
138 *
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
139 * @return sectie as SectieKind.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
140 */
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
141 @OneToOne
5089
4e03f3976d4b Fix column decorator for sectie
Andre Heinecke <aheinecke@intevation.de>
parents: 5062
diff changeset
142 @JoinColumn(name = "sectie")
5062
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
143 public SectieKind getSectie()
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
144 {
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
145 return sectie;
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
146 }
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
147
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
148 /**
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
149 * Set sectie.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
150 *
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
151 * @param sectie the value to set.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
152 */
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
153 public void setSectie(SectieKind sectie)
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
154 {
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
155 this.sectie = sectie;
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
156 }
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
157
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
158 /**
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
159 * Get sobek.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
160 *
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
161 * @return sobek as SobekKind.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
162 */
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
163 @OneToOne
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
164 @JoinColumn(name = "sobek")
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
165 public SobekKind getSobek()
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
166 {
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
167 return sobek;
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
168 }
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
169
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
170 /**
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
171 * Set sobek.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
172 *
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
173 * @param sobek the value to set.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
174 */
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
175 public void setSobek(SobekKind sobek)
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
176 {
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
177 this.sobek = sobek;
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
178 }
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
179
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
180 /**
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
181 * Get kind.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
182 *
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
183 * @return kind as BoundaryKind.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
184 */
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
185 @OneToOne
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
186 @JoinColumn(name = "kind")
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
187 public BoundaryKind getKind()
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
188 {
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
189 return kind;
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
190 }
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
191
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
192 /**
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
193 * Set kind.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
194 *
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
195 * @param kind the value to set.
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
196 */
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
197 public void setKind(BoundaryKind kind)
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
198 {
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
199 this.kind = kind;
bafc655ee630 Add kind, sectie and sobek to HydrBoundary class
Andre Heinecke <aheinecke@intevation.de>
parents: 2868
diff changeset
200 }
2868
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
201 }
b6f94c5db89e Added HydrBoundary and HydrBoundaryPoly and adapted method signatures of Line and Building.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
202 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
http://dive4elements.wald.intevation.org