Mercurial > dive4elements > river
comparison artifacts/src/main/java/org/dive4elements/river/artifacts/model/map/HWSFactory.java @ 8856:5e38e2924c07 3.2.x
Fix code style.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 18 Jan 2018 20:12:01 +0100 |
| parents | e4606eae8ea5 |
| children | 0a5239a1e46e |
comparison
equal
deleted
inserted
replaced
| 8855:d7c005e12af0 | 8856:5e38e2924c07 |
|---|---|
| 32 | 32 |
| 33 private static final int HWS_LINES = 0; | 33 private static final int HWS_LINES = 0; |
| 34 private static final int HWS_POINTS = 1; | 34 private static final int HWS_POINTS = 1; |
| 35 | 35 |
| 36 public static final String SQL_SELECT_LINES = | 36 public static final String SQL_SELECT_LINES = |
| 37 "SELECT hl.name, hl.geom, hl.id, hl.kind_id, hl.official, fs.name AS fed, hl.description " + | 37 "SELECT hl.name, hl.geom, hl.id, hl.kind_id, hl.official, " + |
| 38 " fs.name AS fed, hl.description " + | |
| 38 " FROM hws_lines hl" + | 39 " FROM hws_lines hl" + |
| 39 " JOIN rivers r ON hl.river_id = r.id" + | 40 " JOIN rivers r ON hl.river_id = r.id" + |
| 40 " LEFT JOIN fed_states fs ON hl.fed_state_id = fs.id" + | 41 " LEFT JOIN fed_states fs ON hl.fed_state_id = fs.id" + |
| 41 " WHERE r.name = :river"; | 42 " WHERE r.name = :river"; |
| 42 | 43 |
| 43 public static final String SQL_SELECT_POINTS = | 44 public static final String SQL_SELECT_POINTS = |
| 44 "SELECT hp.name, hp.geom, hp.id, hp.kind_id, hp.official, fs.name AS fed, hp.description " + | 45 "SELECT hp.name, hp.geom, hp.id, hp.kind_id, hp.official, " + |
| 46 " fs.name AS fed, hp.description " + | |
| 45 " FROM hws_points hp" + | 47 " FROM hws_points hp" + |
| 46 " JOIN rivers r ON hp.river_id = r.id" + | 48 " JOIN rivers r ON hp.river_id = r.id" + |
| 47 " LEFT JOIN fed_states fs ON hp.fed_state_id = fs.id" + | 49 " LEFT JOIN fed_states fs ON hp.fed_state_id = fs.id" + |
| 48 " WHERE r.name = :river"; | 50 " WHERE r.name = :river"; |
| 49 | 51 |