Mercurial > dive4elements > river

comparison backend/ChangeLog-before-20121018 @ 5838:5aa05a7a34b7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rename modules to more fitting names.
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 25 Apr 2013 15:23:37 +0200
parents flys-backend/ChangeLog-before-20121018@79878efbdf07
children
comparison
equal deleted inserted replaced
5837:d9901a08d0a6 5838:5aa05a7a34b7
1 2012-10-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2
3 * src/main/java/de/intevation/flys/importer/Config.java:
4 Added new flag 'flys.backend.skip.historical.discharge.tables'
5 to ignore the historical discharge tables during gauge import.
6
7 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
8 Ignore the historical discharge tables if flag is set.
9
10 * contrib/run_hydr_morph.sh: Adjusted shell script.
11 * doc/documentation/de/importer-hydr-morph.tex: Adjusted docu.
12
13 2012-09-30 Sascha L. Teichmann <sascha.teichmann@intevation.de>
14
15 * .hgignore: First hgignore
16
17 2012-09-28 Ingo Weinzierl <ingo@intevation.de>
18
19 * doc/schema/postgresql-spatial.sql,
20 doc/schema/oracle-spatial.sql: Changed the type of date columns to
21 VARCHAR. This is a quick fix to solve the concatination problem in
22 Oracle and PostgreSQL. Both aren't able to concatinate null values.
23 So, null values are not valid for those columns. Users can now decide
24 to fill these columns with correct values or an empty string.
25
26 * src/main/java/de/intevation/flys/utils/DgmSqlConverter.java: Set
27 year_from and year_to values to an empty string if no correct value is
28 specified.
29
30 2012-09-27 Felix Wolfsteller <felix.wolfsteller@intevation.de>
31
32 For issue862/1, fix parsing of year field of bed height csvs,
33 which sometimes contain non-year character.
34
35 * src/main/java/de/intevation/flys/importer/parsers/BedHeightParser.java:
36 Extend RE to parse year field of Bed Height data csv.
37
38 2012-09-27 Ingo Weinzierl <ingo@intevation.de>
39
40 * src/main/java/de/intevation/flys/model/RiverAxis.java:
41 Added new method to query a special kind of river axes.
42
43 2012-09-27 Felix Wolfsteller <felix.wolfsteller@intevation.de>
44
45 Backend-part for fix of issue863.
46
47 * src/main/java/de/intevation/flys/importer/parsers/BedHeightEpochParser.java:
48 Handle missing data points.
49
50 2012-09-27 Felix Wolfsteller <felix.wolfsteller@intevation.de>
51
52 * src/main/java/de/intevation/flys/importer/ImportBedHeightEpoch.java:
53 Doc.
54
55 2012-09-27 Felix Wolfsteller <felix.wolfsteller@intevation.de>
56
57 * src/main/java/de/intevation/flys/importer/parsers/BedHeightSingleParser.java:
58 Removed debug output.
59
60 2012-09-27 Felix Wolfsteller <felix.wolfsteller@intevation.de>
61
62 * src/main/java/de/intevation/flys/importer/parsers/BedHeightSingleParser.java:
63 Handle csv lines with just the km set ("gaps").
64
65 * src/main/java/de/intevation/flys/importer/parsers/BedHeightEpochParser.java:
66 Added TODO, as more changes towards fix for issue863 are necessary.
67
68 2012-09-27 Felix Wolfsteller <felix.wolfsteller@intevation.de>
69
70 * src/main/java/de/intevation/flys/importer/parsers/BedHeightParser.java,
71 src/main/java/de/intevation/flys/importer/ImportBedHeightSingleValue.java:
72 Cosmetics, docs.
73
74 2012-09-27 Felix Wolfsteller <felix.wolfsteller@intevation.de>
75
76 Towards fix for issue863 (data gaps in bed height single values).
77
78 * doc/schema/postgresql-minfo.sql,
79 doc/schema/oracle-minfo.sql:
80 Drop "NOT NULL" constraints on some single bed height value columns.
81
82 2012-09-27 Sascha L. Teichmann <sascha.teichmann@intevation.de>
83
84 * src/main/java/de/intevation/flys/model/BedHeightSingle.java:
85 Replaced labeled continue by a simple break.
86
87 * src/main/java/de/intevation/flys/utils/DgmSqlConverter.java,
88 src/main/java/de/intevation/flys/importer/ImportElevationModel.java:
89 Removed trailing whitespace.
90
91 2012-09-27 Ingo Weinzierl <ingo@intevation.de>
92
93 * doc/schema/postgresql-spatial.sql:
94
95 * doc/schema/import-dems.sql: Added more information to fullfil the schema
96 for dems.
97
98 * src/main/java/de/intevation/flys/utils/DgmSqlConverter.java: New converter
99 for CSV files with DGM information; results in a SQL file with INSERT
100 statements.
101
102 * pom.xml: Added dependency to OpenCSV for reading CSV files.
103
104 2012-09-24 Ingo Weinzierl <ingo@intevation.de>
105
106 * contrib/shpimporter/importer.py: Fixed method name for ERROR log
107 messages.
108
109 * doc/schema/postgresql-spatial.sql: Set geometry dim to '3' instead of
110 '4'.
111
112 2012-09-24 Ingo Weinzierl <ingo@intevation.de>
113
114 * src/main/java/de/intevation/flys/importer/ImportBedHeightEpoch.java,
115 src/main/java/de/intevation/flys/importer/ImportElevationModel.java:
116 Some minor bugfixes for MINFO import.
117
118 2012-09-24 Ingo Weinzierl <ingo@intevation.de>
119
120 * doc/schema/postgresql-spatial.sql: Adapted schema; added missing
121 relations.
122
123 * doc/schema/postgresql-drop-spatial.sql: SQL statements to drop an
124 existing FLYS postgresql schema.
125
126 2012-09-21 Björn Ricks <bjoern.ricks@intevation.de>
127
128 * src/main/java/de/intevation/flys/model/River.java,
129 src/main/java/de/intevation/flys/model/Gauge.java:
130 Remove fetchInfoURL methods. The info url will be generated in the
131 client.
132
133 2012-09-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
134
135 * doc/schema/postgresql.sql, doc/schema/oracle.sql:
136 Addes column 'official_number' to rivers table.
137 This should contain the 'Bundeswasserstrassen Identnummer'.
138
139 * src/main/java/de/intevation/flys/model/River.java:
140 Added new column to Hibernate model.
141
142 2012-09-21 Björn Ricks <bjoern.ricks@intevation.de>
143
144 * src/main/java/de/intevation/flys/model/River.java,
145 src/main/java/de/intevation/flys/model/Gauge.java:
146 Rename getInfoURL methods to fetchInfoURL until the values are fetched
147 from the db to statisfy hibernate.
148
149 2012-09-21 Björn Ricks <bjoern.ricks@intevation.de>
150
151 * src/main/java/de/intevation/flys/model/River.java,
152 src/main/java/de/intevation/flys/model/Gauge.java:
153 Add new methods to return a HTTP URL for additional information about the
154 river or gauge.
155
156 2012-09-19 Ingo Weinzierl <ingo@intevation.de>
157
158 * src/main/java/de/intevation/flys/importer/ImportSedimentDensity.java,
159 src/main/java/de/intevation/flys/importer/ImportWaterlevelDifference.java,
160 src/main/java/de/intevation/flys/importer/ImportBedHeightSingle.java,
161 src/main/java/de/intevation/flys/importer/ImportSedimentYield.java,
162 src/main/java/de/intevation/flys/importer/ImportBedHeightEpoch.java,
163 src/main/java/de/intevation/flys/importer/ImportWaterlevel.java,
164 src/main/java/de/intevation/flys/importer/ImportFlowVelocityMeasurement.java,
165 src/main/java/de/intevation/flys/importer/ImportMorphWidth.java,
166 src/main/java/de/intevation/flys/importer/ImportFlowVelocityModel.java,
167 src/main/java/de/intevation/flys/importer/ImportSQRelation.java: Store
168 values into database only if its peer has been successfully stored,
169 otherwise skip values.
170
171 2012-09-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
172
173 * src/main/java/de/intevation/flys/importer/ImportSedimentDensity.java,
174 src/main/java/de/intevation/flys/importer/parsers/SedimentDensityParser.java:
175 Removed trailing whitespace.
176
177 2012-09-18 Ingo Weinzierl <ingo@intevation.de>
178
179 * src/main/java/de/intevation/flys/model/BedHeightType.java: Accept
180 "Querprofil" as valid BedHeightType.
181
182 * src/main/java/de/intevation/flys/importer/parsers/SedimentYieldParser.java:
183 Added missing GrainFraction.TOTAL type to parser.
184
185 2012-09-18 Ingo Weinzierl <ingo@intevation.de>
186
187 * src/main/java/de/intevation/flys/importer/ImportSedimentDensity.java,
188 src/main/java/de/intevation/flys/importer/parsers/BedHeightParser.java,
189 src/main/java/de/intevation/flys/importer/parsers/SedimentDensityParser.java,
190 src/main/java/de/intevation/flys/importer/parsers/WaterlevelDifferencesParser.java:
191 Some litte logging improvements and be more tolerant with exceptions.
192
193 2012-09-17 Ingo Weinzierl <ingo@intevation.de>
194
195 Taggd RELEASE 2.9.1
196
197 2012-09-17 Ingo Weinzierl <ingo@intevation.de>
198
199 * src/main/java/de/intevation/flys/model/BedHeightEpoch.java:
200 Corrected broken loop to find epochs for river and km range.
201
202 * src/main/java/de/intevation/flys/model/BedHeightSingle.java:
203 Corrected broken loop to find singles for river and km range.
204
205 2012-09-12 Sascha L. Teichmann <sascha.teichmann@intevation.de>
206
207 * src/main/java/de/intevation/flys/importer/parsers/BedHeightParser.java:
208 Made code more robust.
209
210 2012-09-12 Sascha L. Teichmann <sascha.teichmann@intevation.de>
211
212 * src/main/java/de/intevation/flys/importer/Config.java:
213 Add system property 'flys.backend.importer.skip.default'
214 which enables the switching of the skipping default.
215 Very useful if you want only some sub systems by
216 setting this to 'true' and the sub systems to 'false'.
217
218 2012-09-12 Sascha L. Teichmann <sascha.teichmann@intevation.de>
219
220 * doc/schema/postgresql.sql: Indices on cross sections
221 were created too early (before the referenced tables
222 were created).
223
224 2012-09-12 Björn Ricks <bjoern.ricks@intevation.de>
225
226 * src/main/java/de/intevation/flys/model/River.java:
227 Add new method determineMinMaxQ to fetch the mimimum and maximum q values
228 from the database.
229
230 2012-09-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
231
232 * postgresql-minfo.sql: Added missing tables.
233 * oracle-minfo.sql: Fixed small typos.
234
235 2012-09-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
236
237 * pom.xml: Java 1.6 -> 1.6
238
239 * src/main/java/de/intevation/flys/utils/StringUtil.java:
240 Replaced german comment (with an ill encoded Umlaut).
241
242 2012-09-10 Christian Lins <christian.lins@intevation.de>
243
244 * src/main/java/de/intevation/flys/model/Gauge.java:
245 Remove obsolet method (#851).
246
247 2012-09-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
248
249 * src/main/java/de/intevation/flys/model/Gauge.java:
250 We need min/max Q, too.
251
252 2012-09-10 Björn Ricks <bjoern.ricks@intevation.de>
253
254 * src/main/java/de/intevation/flys/model/MinMaxWQ.java,
255 src/main/java/de/intevation/flys/model/Gauge.java:
256 Add method fetchMinMaxWQ to Gauge. This mehtod returns a new MinMaxWQ
257 instance that contains the fetched values for the gauge overview info.
258
259 2012-09-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
260
261 * src/main/java/de/intevation/flys/model/Gauge.java:
262 Moved some code over from flys-artifacts.
263
264 2012-09-07 Ingo Weinzierl <ingo@intevation.de>
265
266 Tagged module as '2.9'.
267
268 2012-09-07 Björn Ricks <bjoern.ricks@intevation.de>
269
270 * src/main/java/de/intevation/flys/model/Gauge.java:
271 Rename getDurationCurveData to fetchDurationCurveData to satisfy
272 hibernate.
273
274 2012-09-06 Björn Ricks <bjoern.ricks@intevation.de>
275
276 * src/main/java/de/intevation/flys/model/Gauge.java:
277 Move static getDurationCurveData method from flys-artifacts
278 MainValuesFactory class to a instance method in Gauge class.
279
280 2012-08-30 Felix Wolfsteller <felix.wolfsteller@intevation.de>
281
282 Attempt fix for issue821 (cross sections just till +/-500m).
283
284 * src/main/java/de/intevation/flys/model/CrossSectionLine.java:
285 Set max value for cross sections to 2500 instead of 500.
286
287 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
288
289 * contrib/run_geo.sh: New run script for the python based geo importer.
290
291 * contrib/run_hydr_morph.sh: New run script for the java based importer
292 for hydrological and morphological data.
293
294 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
295
296 * doc/documentation/de/overview.tex: Fixed typo.
297
298 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
299
300 * doc/documentation/de/importer-geodaesie.tex,
301 doc/documentation/de/importer-hydr-morph.tex: Corrected name of run
302 scripts.
303
304 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
305
306 * doc/documentation/de/importer-geodaesie.tex,
307 doc/documentation/de/importer-hydr-morph.tex,
308 doc/documentation/de/importer-manual.tex: Bugfixes and new geo error
309 description.
310
311 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
312
313 * contrib/shpimporter/importer.py: Fixed broken method call.
314
315 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
316
317 * doc/documentation/de/overview.tex: Hint to root permissions.
318
319 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
320
321 * contrib/shpimporter/importer.py: Set 'path' attribute for each feature.
322
323 * contrib/shpimporter/axis.py: Also accept shapes with 'achse' in its name.
324
325 * doc/schema/oracle-spatial.sql: Added 'path' attribute to each db
326 relation.
327
328 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
329
330 * doc/documentation/de/importer-geodaesie.tex: Bugfixes and added hint.
331
332 * doc/documentation/de/importer-manual.tex: Set document revision and
333 date.
334
335 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
336
337 * doc/documentation/de/importer-hydr-morph.tex: Added manual line breaks.
338
339 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
340
341 * doc/documentation/de/importer-hydr-morph.tex: Fixed bug during PDF
342 creation.
343
344 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
345
346 * doc/documentation/de/importer-hydr-morph.tex: Bugfixes.
347
348 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
349
350 * doc/documentation/de/overview.tex: Improved description of database
351 schema creation. Describe command to unpack importer tarball.
352
353 2012-08-30 Ingo Weinzierl <ingo@intevation.de>
354
355 * doc/documentation/de/importer-geodaesie.tex: Added further error message
356 if no connection to Oracle database could be established.
357
358 2012-08-29 Ingo Weinzierl <ingo@intevation.de>
359
360 * doc/documentation/de/importer-geodaesie.tex: Documented install steps
361 for Oracle Instantclient and python and gdal.
362
363 2012-08-27 Ingo Weinzierl <ingo@intevation.de>
364
365 * doc/documentation/de/importer-hydr-morph.tex: Describe Log4J
366 configuration; some smaller bugfixes.
367
368 2012-08-27 Ingo Weinzierl <ingo@intevation.de>
369
370 * doc/documentation/de/overview.tex: Added comment to directory structure
371 of a river.
372
373 * doc/documentation/de/importer-hydr-morph.tex: Describe import of
374 morphological files.
375
376 2012-08-27 Ingo Weinzierl <ingo@intevation.de>
377
378 * doc/documentation/de/title.tex,
379 doc/documentation/de/overview.tex,
380 doc/documentation/de/importer-hydr-morph.tex,
381 doc/documentation/de/importer-manual.tex: Smaller fixed and structural
382 changes.
383
384 2012-08-27 Ingo Weinzierl <ingo@intevation.de>
385
386 * doc/documentation/de/importer-hydr-morph.tex: Added documentation from
387 README.
388
389 2012-08-27 Sascha L. Teichmann <sascha.teichmann@intevation.de>
390
391 * doc/README.txt: Documented which hydrological files are taken into account.
392
393 2012-08-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
394
395 * doc/README.txt: Documented the classification of the annotations.
396
397 2012-08-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
398
399 * doc/README.txt: Documented the db credentials.
400
401 2012-08-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
402
403 * doc/README.txt: Completed the error messages (Puh!)
404
405 * src/main/java/de/intevation/flys/importer/ImportBedHeightSingle.java,
406 src/main/java/de/intevation/flys/importer/ImportWaterlevelDifference.java,
407 src/main/java/de/intevation/flys/importer/ImportBedHeightEpoch.java,
408 src/main/java/de/intevation/flys/importer/parsers/BedHeightParser.java,
409 src/main/java/de/intevation/flys/importer/parsers/BedHeightSingleParser.java,
410 src/main/java/de/intevation/flys/importer/parsers/AnnotationsParser.java,
411 src/main/java/de/intevation/flys/importer/parsers/MorphologicalWidthParser.java,
412 src/main/java/de/intevation/flys/importer/parsers/SedimentYieldParser.java,
413 src/main/java/de/intevation/flys/importer/parsers/AnnotationClassifier.java,
414 src/main/java/de/intevation/flys/importer/parsers/WstParser.java,
415 src/main/java/de/intevation/flys/importer/ImportSQRelation.java:
416 Made error messages identifiable.
417
418 2012-08-24 Ingo Weinzierl <ingo@intevation.de>
419
420 * doc/shapeimporter,
421 doc/shapeimporter/documentation.txt: Removed. The documentation is now
422 written in latex.
423
424 * doc/documentation,
425 doc/documentation/de: New. The place where the german documentation is
426 located.
427
428 * doc/documentation/de/title.tex,
429 doc/documentation/de/importer-geodaesie.tex,
430 doc/documentation/de/figures/bfg_logo.png,
431 doc/documentation/de/figures/intevation-logo.pdf,
432 doc/documentation/de/overview.tex,
433 doc/documentation/de/importer-hydr-morph.tex,
434 doc/documentation/de/importer-manual.tex: German documentation of the
435 importer and shape importer.
436
437 * doc/documentation/de/Makefile: Makefile to generate the documentation.
438
439 * doc/documentation/de/README: Instructions to generate the documentation.
440
441 2012-08-23 Sascha L. Teichmann <sascha.teichmann@intevation.de>
442
443 * doc/README.txt: Added warning messages. TODO: More warnings.
444
445 * src/main/java/de/intevation/flys/importer/parsers/PRFParser.java,
446 src/main/java/de/intevation/flys/importer/parsers/StaFileParser.java,
447 src/main/java/de/intevation/flys/importer/parsers/PegelGltParser.java,
448 src/main/java/de/intevation/flys/importer/parsers/AtFileParser.java,
449 src/main/java/de/intevation/flys/importer/ImportRiver.java:
450 Made warnings identifiable.
451
452 2012-08-23 Sascha L. Teichmann <sascha.teichmann@intevation.de>
453
454 * doc/README.txt: Added error messages.
455
456 * src/main/java/de/intevation/flys/importer/Importer.java,
457 src/main/java/de/intevation/flys/importer/parsers/PRFParser.java
458 src/main/java/de/intevation/flys/importer/parsers/HYKParser.java
459 src/main/java/de/intevation/flys/importer/ImportRiver.java:
460 Made errors identifiable.
461
462 2012-08-23 Sascha L. Teichmann <sascha.teichmann@intevation.de>
463
464 * doc/README.txt: Documentation for the importer (german).
465 TODO: db crendentials, warning & errors, annotation types.
466
467 2012-08-22 Ingo Weinzierl <ingo@intevation.de>
468
469 * contrib/shpimporter/run.sh: Moved 'SKIP_XXX' variables to the top of
470 the script.
471
472 2012-08-22 Ingo Weinzierl <ingo@intevation.de>
473
474 * contrib/shpimporter/axis.py: Use log methods of shpimporter and
475 removed print() calls.
476
477 * contrib/shpimporter/importer.py: Evaluate command line option 'dry_run'.
478 Do not commit database transaction if it is activated.
479
480 * contrib/shpimporter/shpimporter.py: Added new command line option
481 'dry_run' to supress database transactions.
482
483 2012-08-22 Ingo Weinzierl <ingo@intevation.de>
484
485 * contrib/shpimporter/shpimporter.py: Use OptionParse to read command line
486 options. Now, it is no longer necessary to adjust user specific settings
487 in python files. Users should adapt run.sh script for specific settings.
488
489 * contrib/shpimporter/catchments.py,
490 contrib/shpimporter/boundaries.py,
491 contrib/shpimporter/hws.py,
492 contrib/shpimporter/importer.py,
493 contrib/shpimporter/uesg.py,
494 contrib/shpimporter/axis.py,
495 contrib/shpimporter/km.py,
496 contrib/shpimporter/floodplains.py,
497 contrib/shpimporter/lines.py,
498 contrib/shpimporter/gauges.py,
499 contrib/shpimporter/buildings.py,
500 contrib/shpimporter/fixpoints.py,
501 contrib/shpimporter/crosssectiontracks.py: Added new method getName().
502
503 * contrib/shpimporter/utils.py: Use shpimporter functions to print debug
504 messages.
505
506 * contrib/shpimporter/run.sh: New shell script to run the shape importer
507 with a default configuration.
508
509 2012-08-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
510
511 * src/main/java/de/intevation/flys/model/FastAnnotations.java:
512 Added toString() to Annotation.
513
514 2012-07-27 Ingo Weinzierl <ingo@intevation.de>
515
516 Tagged module as '2.8.1'.
517
518 2012-07-18 Felix Wolfsteller <felix.wolfstellre@intevation.de>
519
520 * doc/schema/postgresql.sql, doc/schema/oracle.sql:
521 Adjusted the official_lines views to include wst column pos.
522
523 2012-07-16 Ingo Weinzierl <ingo@intevation.de>
524
525 * Tagged module as '2.8'.
526
527 2012-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
528
529 * src/main/java/de/intevation/flys/model/Gauge.java,
530 src/main/java/de/intevation/flys/backend/SpatialInfo.java:
531 Removed same package imports.
532
533 2012-07-12 Sascha L. Teichmann <sascha.teichmann@intevation.de>
534
535 * src/main/java/de/intevation/hibernate/MapResultTransformer.java:
536 Added static INSTANCE because its stateless.
537
538 2012-07-12 Sascha L. Teichmann <sascha.teichmann@intevation.de>
539
540 * src/main/java/de/intevation/hibernate/MapResultTransformer.java:
541 Strategy to directly transform native SQL results into Maps.
542
543 2012-07-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
544
545 Fix for flys/issue359
546
547 * src/main/java/de/intevation/flys/importer/parsers/PRFParser.java:
548 Removed extension from PRF descriptions.
549
550 2012-07-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
551
552 * doc/schema/postgresql.sql, doc/schema/oracle.sql:
553 Added indices for fasten access to cross section points.
554
555 2012-07-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
556
557 Partial fix for flys/issue697
558
559 * doc/schema/oracle.sql: Increased the decimal places of Ws, Qs and Kms to 5.
560
561 2012-07-03 Ingo Weinzierl <ingo@intevation.de>
562
563 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
564 Set correct connection provider class (its package has changed in the
565 last commit).
566
567 2012-07-03 Ingo Weinzierl <ingo@intevation.de>
568
569 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
570 Fixed broken package declaration.
571
572 2012-06-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
573
574 * doc/schema/postgresql.sql, doc/schema/oracle.sql:
575 Added views to access the 'Amtlichen Linien'.
576
577 2012-06-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
578
579 * src/main/java/de/intevation/**/*.java: Removed trailing whitespace.
580
581 2012-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
582
583 Make access to SedDB configurable over conf.xml and provide
584 access to sessions.
585
586 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
587 Moved FLYS specific stuff out into the concept of credential classes
588 which provides the user, password, dialect, driver, url and the
589 Hibernate classes to bind.
590
591 * src/main/java/de/intevation/flys/backend/Credentials.java: New.
592 Abstact class to provide the data needed for the SessionFactoryProvider.
593
594 * src/main/java/de/intevation/flys/backend/FLYSCredentials.java: New.
595 Extends Credentials to serve the FLYS specific stuff.
596
597 * src/main/java/de/intevation/flys/backend/SedDBCredentials.java: New.
598 Extends Credentials to serve the SedDB specific stuff. The parameters
599 are drawn from conf.xml in the form:
600
601 <artifact-database>
602 ...
603 <seddb-database>
604 <user>USER</user>
605 <password>PASSWORD</password>
606 <driver>DRIVER</driver>
607 <url>URL</url>
608 <dialect>DIALECT</dialect>
609 </seddb-database>
610 ...
611 </artifact-database>
612
613 If absent defaults are:
614 - user: seddb
615 - password: seddb
616 - driver: org.postgresql.Driver
617 - url: jdbc:postgresql://localhost:5432/seddb
618 - dialect: org.hibernate.dialect.PostgreSQLDialect
619
620 Defaults can be overwritten with system properties:
621 - user: flys.seddb.user
622 - password: flys.seddb.password
623 - driver: flys.seddb.driver
624 - url: flys.seddb.url
625 - dialect: flys.seddb.dialect
626
627 * src/main/java/de/intevation/flys/backend/SedDBSessionHolder.java: New.
628 Use this if you want to establish a session to the SedDB!
629 Works like the SessionHolder.
630
631 * src/main/java/de/intevation/flys/backend/SessionHolder.java:
632 Add Override annotation. This holder gives you a session
633 to the FLYS database.
634
635 * src/main/java/de/intevation/flys/App.java: Adjusted.
636
637 2012-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
638
639 * src/main/java/de/intevation/seddb/model/*.java: Hibernate access to
640 SedDB generated by Eclipse (ugly formatted, but compiles).
641
642 2012-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
643
644 * src/main/java/de/intevation/flys/importer/parsers/AnnotationsParser.java:
645 Re-establish cross platform compatibilty again.
646
647 2012-06-14 Ingo Weinzierl <ingo@intevation.de>
648
649 * src/main/java/de/intevation/flys/model/CrossSectionTrack.java: Added the
650 missing 'name' property and added a function that returns all
651 CrossSectionTracks of a specific river with a specific name.
652
653 2012-06-13 Ingo Weinzierl <ingo@intevation.de>
654
655 * doc/schema/oracle-minfo.sql,
656 doc/schema/oracle-drop-minfo.sql: Added missing river_id column to
657 sq_relation table and reordered the drop statements.
658
659 * src/main/java/de/intevation/flys/model/SQRelationValue.java,
660 src/main/java/de/intevation/flys/model/SQRelation.java: Added missing
661 constructors and fixed some minor bugs that occured during import test.
662
663 * src/main/java/de/intevation/flys/importer/ImportSQRelationValue.java,
664 src/main/java/de/intevation/flys/importer/ImportSQRelation.java:
665 Implemented code to store sq relations and values into db.
666
667 * src/main/java/de/intevation/flys/importer/parsers/SQRelationParser.java:
668 Override parse() to retrieve the filename.
669
670 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Implemented
671 code to store sq relations into db.
672
673 2012-06-13 Ingo Weinzierl <ingo@intevation.de>
674
675 * src/main/java/de/intevation/flys/importer/ImportSQRelationValue.java,
676 src/main/java/de/intevation/flys/importer/ImportSQRelation.java:
677 New classes used during the import process of MINFO sq relations.
678
679 * src/main/java/de/intevation/flys/importer/parsers/SQRelationParser.java:
680 New line parser that reads MINFO specifc sq relation files.
681
682 * src/main/java/de/intevation/flys/importer/Config.java: Added system
683 property to skip parsing sq relations.
684
685 "-Dflys.backend.importer.skip.sq.relation"
686
687 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Parse MINFO
688 sq relations.
689
690 2012-06-12 Ingo Weinzierl <ingo@intevation.de>
691
692 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Cleared some
693 irritating debug statements.
694
695 2012-06-12 Ingo Weinzierl <ingo@intevation.de>
696
697 * doc/annotation-types.xml: Added regex to match "Geschiebemesstellen" as
698 "Messstelle" type.
699
700 * src/main/java/de/intevation/flys/importer/parsers/AnnotationsParser.java:
701 Parse KM files in "../Morphologie/Streckendaten/". On Windows Systems,
702 this won't work!
703
704 2012-06-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
705
706 * src/main/java/de/intevation/flys/model/FastAnnotations.java:
707 Added Override annotation to new NameFilter.
708
709 2012-06-11 Raimund Renkert <raimund.renkert@intevation.de>
710
711 * src/main/java/de/intevation/flys/model/FastAnnotations.java:
712 Added filter for annotation names.
713
714 2012-06-08 Felix Wolfsteller <felix.wolfstellre@intevation.de>
715
716 * src/main/java/de/intevation/flys/model/FastAnnotations.java:
717 Fix comment.
718
719 2012-06-08 Felix Wolfsteller <felix.wolfstellre@intevation.de>
720
721 * src/main/java/de/intevation/flys/model/SQRelationValue.java:
722 Fix hibernaty annotation symptom (make it run again).
723
724 2012-06-07 Ingo Weinzierl <ingo@intevation.de>
725
726 * doc/schema/oracle-minfo.sql,
727 doc/schema/oracle-drop-minfo.sql: Schema additions for MINFO s/q
728 relation.
729
730 * src/main/java/de/intevation/flys/model/SQRelationValue.java,
731 src/main/java/de/intevation/flys/model/SQRelation.java: New model
732 classes for MINFO s/q relation.
733
734 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
735 Registered new model classes.
736
737 2012-06-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
738
739 * src/main/java/de/intevation/flys/model/GaugeLocation.java,
740 src/main/java/de/intevation/flys/importer/ImportRiver.java:
741 Removed superfluous imports.
742
743 2012-05-27 Ingo Weinzierl <ingo@intevation.de>
744
745 * Tagged module as '2.7'.
746
747 2012-05-18 Ingo Weinzierl <ingo@intevation.de>
748
749 * src/main/java/de/intevation/flys/model/BedHeightEpoch.java,
750 src/main/java/de/intevation/flys/model/BedHeightSingle.java: Added lower
751 and upper km to function that returns all singles and epochs for a given
752 river.
753
754 2012-05-18 Ingo Weinzierl <ingo@intevation.de>
755
756 * src/main/java/de/intevation/flys/model/BedHeightSingleValue.java: Fixed
757 a typo.
758
759 2012-05-18 Ingo Weinzierl <ingo@intevation.de>
760
761 * src/main/java/de/intevation/flys/model/BedHeightSingleValue.java,
762 src/main/java/de/intevation/flys/model/BedHeightEpochValue.java: Added
763 functions to retrieve single and epoch values based on its owner and km
764 range.
765
766 2012-05-18 Ingo Weinzierl <ingo@intevation.de>
767
768 * src/main/java/de/intevation/flys/model/BedHeightEpoch.java,
769 src/main/java/de/intevation/flys/model/BedHeightSingle.java: Added
770 functions to get singles and epochs by river and by id.
771
772 2012-05-15 Ingo Weinzierl <ingo@intevation.de>
773
774 * src/main/java/de/intevation/flys/model/FlowVelocityModel.java,
775 src/main/java/de/intevation/flys/model/FlowVelocityModelValue.java,
776 src/main/java/de/intevation/flys/model/DischargeZone.java: Added static
777 functions to retrieve data from database.
778
779 2012-05-15 Ingo Weinzierl <ingo@intevation.de>
780
781 * src/main/java/de/intevation/flys/model/DischargeZone.java: Added a
782 function getDischargeZones() that returns all DischargeZones for a given
783 river.
784
785 2012-05-10 Ingo Weinzierl <ingo@intevation.de>
786
787 * contrib/shpimporter/gauges.py: Search for field 'MPNAAM' and use its
788 value as name for the geometry.
789
790 * src/main/java/de/intevation/flys/model/GaugeLocation.java: New model
791 class for storing locations of gauges.
792
793 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
794 Registered GaugeLocation class.
795
796 2012-05-10 Ingo Weinzierl <ingo@intevation.de>
797
798 * src/main/java/de/intevation/flys/model/HydrBoundary.java,
799 src/main/java/de/intevation/flys/model/HydrBoundaryPoly.java: New.
800 Hydrological boundaries.
801
802 * src/main/java/de/intevation/flys/model/Line.java: Modified signature of
803 Line.getLines(). It now also takes the name of a line to retrieve more
804 specific lines.
805
806 * src/main/java/de/intevation/flys/model/Building.java: Modified signature
807 of Building.getBuildings(). It now also takes the name of a building to
808 retrieve more specific lines.
809
810 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
811 Registered HydrBoundary and HydrBoundaryPoly classes.
812
813 2012-05-10 Ingo Weinzierl <ingo@intevation.de>
814
815 * contrib/shpimporter/crosssectiontracks.py: Search for 'STATION' field in
816 shapefile to extract the current km.
817
818 2012-05-08 Ingo Weinzierl <ingo@intevation.de>
819
820 * src/main/java/de/intevation/flys/model/Hws.java: The getHws() function
821 got a further parameter 'name' to retrieve specific hws only.
822
823
824 2012-05-08 Ingo Weinzierl <ingo@intevation.de>
825
826 * src/main/java/de/intevation/flys/model/Catchment.java: The
827 getCatchments() function got a further parameter 'name' to retrieve
828 specific catchments only.
829
830 2012-05-08 Ingo Weinzierl <ingo@intevation.de>
831
832 * doc/schema/oracle-spatial_idx.sql: Set the geometry type of 'catchments'
833 to 'multipolygon'.
834
835 * src/main/java/de/intevation/flys/model/Catchment.java: The geometry
836 attribute in such instances is now from type 'Geometry'.
837
838 2012-05-08 Ingo Weinzierl <ingo@intevation.de>
839
840 * doc/schema/import-dems.sql: New. Insert statements to insert dems into
841 database.
842
843 2012-05-04 Ingo Weinzierl <ingo@intevation.de>
844
845 * doc/schema/oracle-drop-spatial.sql,
846 doc/schema/oracle-spatial.sql: New relation 'gauge_location' and some
847 bugfixes in the drop schema.
848
849 * contrib/shpimporter/catchments.py,
850 contrib/shpimporter/hws.py,
851 contrib/shpimporter/gauges.py: New importers.
852
853 * contrib/shpimporter/importer.py: Added a debug statement to improve the
854 visibility of the log output.
855
856 * contrib/shpimporter/shpimporter.py: Make use of the new importers.
857
858
859 2012-05-03 Ingo Weinzierl <ingo@intevation.de>
860
861 * doc/schema/oracle-drop-spatial.sql,
862 doc/schema/oracle-spatial.sql: Added new relations for hydrological
863 boundaries and appended a 'name' field to relations that had no such
864 field yet.
865
866 * contrib/shpimporter/floodplains.py,
867 contrib/shpimporter/boundaries.py: New importers for floodplain and
868 hydrological boundaries.
869
870 * contrib/shpimporter/lines.py,
871 contrib/shpimporter/buildings.py,
872 contrib/shpimporter/uesg.py,
873 contrib/shpimporter/fixpoints.py,
874 contrib/shpimporter/axis.py,
875 contrib/shpimporter/crosssectiontracks.py,
876 contrib/shpimporter/km.py: Set the 'name' attribute for new features.
877
878 * contrib/shpimporter/importer.py: Some bugfixes and improvements:
879 geometries are transformed into a destination coordinate system now.
880
881 * contrib/shpimporter/shpimporter.py: Use all importers and defined the
882 destination srs.
883
884 2012-05-02 Sascha L. Teichmann <sascha.teichmann@intevation.de>
885
886 * src/main/java/de/intevation/flys/model/FastCrossSectionLine.java,
887 src/main/java/de/intevation/flys/model/CrossSectionPoint.java,
888 src/main/java/de/intevation/flys/model/CrossSectionLine.java,
889 src/main/java/de/intevation/flys/importer/ImportCrossSectionLine.java,
890 src/main/java/de/intevation/flys/importer/ImportRiver.java:
891 Store meassure points of profiles as Doubles not as BigDecimal.
892 This should save a lot of memory during the import.
893
894 2012-04-27 Sascha L. Teichmann <sascha.teichmann@intevation.de>
895
896 * src/main/java/de/intevation/flys/importer/parsers/FlowVelocityMeasurementParser.java,
897 src/main/java/de/intevation/flys/importer/ImportWaterlevelDifferenceValue.java,
898 src/main/java/de/intevation/flys/importer/ImportWaterlevelDifferenceColumn.java:
899 Removed superfluous imports.
900
901 2012-04-27 Sascha L. Teichmann <sascha.teichmann@intevation.de>
902
903 * doc/schema/postgresql-minfo.sql: Adjusted PostgreSQL port
904 to match the Oracle schema.
905
906 2012-04-27 Ingo Weinzierl <ingo@intevation.de>
907
908 * doc/annotation-types.xml: Adapted annotation typed based on BfG wishes.
909
910 2012-04-27 Ingo Weinzierl <ingo@intevation.de>
911
912 * doc/schema/oracle-drop.sql: New SQL file to drop WINFO specific db
913 schema.
914
915 2012-04-27 Ingo Weinzierl <ingo@intevation.de>
916
917 * doc/schema/oracle.sql: Made SQL instructions upper case.
918
919 2012-04-27 Ingo Weinzierl <ingo@intevation.de>
920
921 * doc/schema/oracle-drop-spatial.sql: New statements to drop the whole
922 spatial schema.
923
924 2012-04-27 Ingo Weinzierl <ingo@intevation.de>
925
926 * contrib/shpimporter/lines.py,
927 contrib/shpimporter/buildings.py,
928 contrib/shpimporter/importer.py,
929 contrib/shpimporter/fixpoints.py,
930 contrib/shpimporter/axis.py,
931 contrib/shpimporter/crosssectiontracks.py,
932 contrib/shpimporter/km.py: New classes for importing specific
933 shapefiles. Each of this imports defines its target db tablename and a
934 directory path to the shapefiles it should import.
935
936 * contrib/shpimporter/uesg.py: Some modifications necessary to streamline
937 the import process of shapefiles.
938
939 * contrib/shpimporter/shpimporter.py: Use all available imports for the
940 import process.
941
942 2012-04-26 Ingo Weinzierl <ingo@intevation.de>
943
944 * doc/schema/oracle-spatial.sql: Repaired broken schema.
945
946 2012-04-26 Ingo Weinzierl <ingo@intevation.de>
947
948 * src/main/java/de/intevation/flys/importer/Config.java: Added a config
949 option to skip parsing MINFO waterlevel differences:
950
951 -Dflys.backend.importer.skip.waterlevel.differences=True
952
953 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Parse and
954 store MINFO specific waterlevel differences.
955
956 2012-04-26 Ingo Weinzierl <ingo@intevation.de>
957
958 * src/main/java/de/intevation/flys/importer/parsers/WaterlevelDifferencesParser.java:
959 New parser for MINFO specific waterlevel differences.
960
961 * src/main/java/de/intevation/flys/importer/ImportWaterlevelDifferenceValue.java,
962 src/main/java/de/intevation/flys/importer/ImportWaterlevelDifference.java,
963 src/main/java/de/intevation/flys/importer/ImportWaterlevelDifferenceColumn.java:
964 New importer classes used during the import process of MINFO specific
965 waterlevel differences.
966
967 2012-04-26 Ingo Weinzierl <ingo@intevation.de>
968
969 * doc/schema/oracle-minfo.sql,
970 doc/schema/oracle-drop-minfo.sql: Added a missing constraint to
971 'waterlevel_difference' relation. Remove that constraint in
972 oracle-drop-minfo.sql.
973
974 2012-04-25 Felix Wolfsteller <felix@intevation.de>
975
976 * src/main/java/de/intevation/flys/model/WaterlevelDifferenceValue.java:
977 (setValue, setValues): Change setter name to allow hibernate to recognize
978 it.
979
980 2012-04-24 Ingo Weinzierl <ingo@intevation.de>
981
982 * src/main/java/de/intevation/flys/model/WaterlevelDifferenceColumn.java,
983 src/main/java/de/intevation/flys/model/WaterlevelDifference.java,
984 src/main/java/de/intevation/flys/model/WaterlevelDifferenceValue.java:
985 New model classes for MINFO specific waterlevel differences.
986
987 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
988 Registered new model classes.
989
990 2012-04-24 Ingo Weinzierl <ingo@intevation.de>
991
992 * doc/schema/oracle-minfo.sql,
993 doc/schema/oracle-drop-minfo.sql: Improved the schema to store MINFO
994 specific waterlevel differences.
995
996 2012-04-24 Ingo Weinzierl <ingo@intevation.de>
997
998 * src/main/java/de/intevation/flys/model/WaterlevelValue.java: Renamed a
999 property ('qRange' -> 'qrange') because there have been problem during the
1000 import.
1001
1002 * src/main/java/de/intevation/flys/importer/parsers/WaterlevelParser.java:
1003 Filled the stub with code.
1004
1005 * src/main/java/de/intevation/flys/importer/ImportWaterlevelValue.java,
1006 src/main/java/de/intevation/flys/importer/ImportWaterlevelQRange.java,
1007 src/main/java/de/intevation/flys/importer/ImportWaterlevel.java: Some
1008 adaptions and missing methods which are required during the import.
1009
1010 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Use the
1011 correct directory to search for waterlevel files.
1012
1013 2012-04-24 Ingo Weinzierl <ingo@intevation.de>
1014
1015 * doc/schema/oracle-minfo.sql: Small type adaptions in the waterlevel_values
1016 relation.
1017
1018 * src/main/java/de/intevation/flys/importer/parsers/WaterlevelParser.java:
1019 First stub of a parser for MINFO specific waterlevel values.
1020
1021 * src/main/java/de/intevation/flys/importer/Config.java: Added a new config
1022 option to skip parsing MINFO specifc waterlevel_values:
1023
1024 -Dflys.backend.importer.skip.waterlevels=True
1025
1026 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Added code
1027 path to start parsing and storing MINFO specific waterlevel values.
1028
1029 2012-04-20 Ingo Weinzierl <ingo@intevation.de>
1030
1031 * src/main/java/de/intevation/flys/importer/ImportWaterlevelValue.java,
1032 src/main/java/de/intevation/flys/importer/ImportWaterlevelQRange.java,
1033 src/main/java/de/intevation/flys/importer/ImportWaterlevel.java: New
1034 importer classes used for MINFO specific waterlevel import.
1035
1036 2012-04-20 Ingo Weinzierl <ingo@intevation.de>
1037
1038 * src/main/java/de/intevation/flys/model/WaterlevelQRange.java,
1039 src/main/java/de/intevation/flys/model/WaterlevelValue.java,
1040 src/main/java/de/intevation/flys/model/Waterlevel.java: New model
1041 classes for MINFO specific waterlevel data.
1042
1043 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1044 Registered new model classes.
1045
1046 2012-04-20 Ingo Weinzierl <ingo@intevation.de>
1047
1048 * doc/schema/oracle-minfo.sql,
1049 doc/schema/oracle-drop-minfo.sql: Added relations for waterlevels
1050 specific to MINFO. Note: those waterlevel values are not stored in the
1051 WINFO specific relations!
1052
1053 2012-04-19 Ingo Weinzierl <ingo@intevation.de>
1054
1055 * doc/schema/oracle-minfo.sql,
1056 src/main/java/de/intevation/flys/importer/ImportSedimentYield.java,
1057 src/main/java/de/intevation/flys/model/SedimentYield.java: Added a
1058 column 'description' to the sediment_yield relation.
1059
1060 * src/main/java/de/intevation/flys/importer/parsers/SedimentYieldParser.java:
1061 New parser for sediment yield data.
1062
1063 * src/main/java/de/intevation/flys/model/GrainFraction.java: Added constants
1064 that represent the names of the grain fraction types.
1065
1066 * src/main/java/de/intevation/flys/importer/ImportGrainFraction.java: New
1067 constructor that takes a name only.
1068
1069 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Improved the
1070 process of parsing sediment yield files.
1071
1072 2012-04-19 Ingo Weinzierl <ingo@intevation.de>
1073
1074 * src/main/java/de/intevation/flys/importer/Config.java: Added new config
1075 option to skip parsing sediment yield data:
1076
1077 -Dflys.backend.importer.skip.sediment.yield=true
1078
1079 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Prepared the
1080 importer to parse sediment yield data.
1081
1082 * src/main/java/de/intevation/flys/importer/ImportSedimentYield.java:
1083 storeDependencies() now throws SQLExceptions and
1084 ConstraintViolationExceptions.
1085
1086 2012-04-19 Ingo Weinzierl <ingo@intevation.de>
1087
1088 * src/main/java/de/intevation/flys/importer/ImportGrainFraction.java,
1089 src/main/java/de/intevation/flys/importer/ImportSedimentYieldValue.java,
1090 src/main/java/de/intevation/flys/importer/ImportSedimentYield.java: New
1091 importer classes for importing sediment yield data.
1092
1093 2012-04-18 Ingo Weinzierl <ingo@intevation.de>
1094
1095 * src/main/java/de/intevation/flys/model/SedimentYield.java,
1096 src/main/java/de/intevation/flys/model/SedimentYieldValue.java,
1097 src/main/java/de/intevation/flys/model/GrainFraction.java: New model
1098 classes for sediment yield data.
1099
1100 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1101 Registered new model classes.
1102
1103 2012-04-18 Ingo Weinzierl <ingo@intevation.de>
1104
1105 * doc/schema/oracle-minfo.sql,
1106 doc/schema/oracle-drop-minfo.sql: Added missing river_id column to
1107 sediment_yield relation.
1108
1109 2012-04-18 Ingo Weinzierl <ingo@intevation.de>
1110
1111 * src/main/java/de/intevation/flys/model/Floodmaps.java,
1112 src/main/java/de/intevation/flys/importer/parsers/SedimentDensityParser.java,
1113 src/main/java/de/intevation/flys/importer/ImportDischargeZone.java:
1114 Removed superflous imports.
1115
1116 2012-04-18 Ingo Weinzierl <ingo@intevation.de>
1117
1118 * doc/schema/oracle-minfo.sql,
1119 doc/schema/oracle-drop-minfo.sql: Added relations for storing sediment
1120 yield values.
1121
1122 2012-04-18 Ingo Weinzierl <ingo@intevation.de>
1123
1124 * doc/schema/oracle-minfo.sql,
1125 doc/schema/oracle-drop-minfo.sql: The discharge_zone relation has no
1126 longer a reference to a named main value but stores a lower and upper
1127 discharge as string.
1128
1129 * src/main/java/de/intevation/flys/model/DischargeZone.java,
1130 src/main/java/de/intevation/flys/importer/ImportDischargeZone.java:
1131 Adapted the code to the changes in the db schema.
1132
1133 * src/main/java/de/intevation/flys/importer/parsers/FlowVelocityModelParser.java:
1134 This parser now reads the meta information properly.
1135
1136 * src/main/java/de/intevation/flys/importer/ImportFlowVelocityModelValue.java:
1137 Repaired broken HQL statement.
1138
1139 * src/main/java/de/intevation/flys/importer/ImportFlowVelocityModel.java:
1140 Log the number of flow velocity model values that have been written into
1141 database.
1142
1143 2012-04-17 Ingo Weinzierl <ingo@intevation.de>
1144
1145 * src/main/java/de/intevation/flys/importer/parsers/FlowVelocityMeasurementParser.java:
1146 New parser for flow velocity measurements.
1147
1148 * src/main/java/de/intevation/flys/importer/ImportFlowVelocityMeasurementValue.java,
1149 src/main/java/de/intevation/flys/importer/ImportFlowVelocityMeasurement.java,
1150 src/main/java/de/intevation/flys/importer/ImportFlowVelocityModelValue.java,
1151 src/main/java/de/intevation/flys/importer/ImportFlowVelocityModel.java:
1152 Fixed broken HQL statements.
1153
1154 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Store flow
1155 velocity measurements into database after parsing them.
1156
1157 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1158 Registered new model classes for flow velocity measurements.
1159
1160 2012-04-17 Ingo Weinzierl <ingo@intevation.de>
1161
1162 * src/main/java/de/intevation/flys/importer/ImportFlowVelocityMeasurementValue.java,
1163 src/main/java/de/intevation/flys/importer/ImportFlowVelocityMeasurement.java:
1164 New temp classes used during the import process of flow velocity
1165 measurements.
1166
1167 2012-04-17 Ingo Weinzierl <ingo@intevation.de>
1168
1169 * src/main/java/de/intevation/flys/model/FlowVelocityMeasurementValue.java,
1170 src/main/java/de/intevation/flys/model/FlowVelocityMeasurement.java: New
1171 model classes for storing flow velocity measurements.
1172
1173 2012-04-17 Ingo Weinzierl <ingo@intevation.de>
1174
1175 * doc/schema/oracle-minfo.sql,
1176 doc/schema/oracle-drop-minfo.sql: Added new relations for MINFO specific
1177 flow velocity measurements.
1178
1179 2012-04-17 Ingo Weinzierl <ingo@intevation.de>
1180
1181 * src/main/java/de/intevation/flys/importer/parsers/FlowVelocityModelParser.java:
1182 New. Parser for model files of MINFO specific flow velocity data.
1183
1184 * doc/schema/oracle-minfo.sql: Added a missing q column to
1185 flow_velocity_model_values relation.
1186
1187 * src/main/java/de/intevation/flys/importer/ImportFlowVelocityModelValue.java,
1188 src/main/java/de/intevation/flys/model/FlowVelocityModelValue.java:
1189 Added missing q column.
1190
1191 * src/main/java/de/intevation/flys/importer/ImportFlowVelocityModel.java:
1192 Added setter methods for meta data and an addValue() for adding new
1193 ImportFlowVelocityModelValues.
1194
1195 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Use
1196 FlowVelocityModelParser for parsing model data of flow velocity files.
1197
1198 2012-04-17 Ingo Weinzierl <ingo@intevation.de>
1199
1200 * src/main/java/de/intevation/flys/importer/ImportDischargeZone.java,
1201 src/main/java/de/intevation/flys/importer/ImportFlowVelocityModelValue.java,
1202 src/main/java/de/intevation/flys/importer/ImportFlowVelocityModel.java:
1203 Temp classes used during the import process of flow velocity data.
1204
1205 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Implemented
1206 the method that stores flow velocity model data.
1207
1208 2012-04-17 Ingo Weinzierl <ingo@intevation.de>
1209
1210 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Prepared for
1211 parsing flow velocity files.
1212
1213 * src/main/java/de/intevation/flys/importer/Config.java: Added a config
1214 option to skip parsing flow velocity files:
1215
1216 -Dflys.backend.importer.skip.flow.velocity=true
1217
1218 2012-04-17 Ingo Weinzierl <ingo@intevation.de>
1219
1220 * src/main/java/de/intevation/flys/model/FlowVelocityModel.java,
1221 src/main/java/de/intevation/flys/model/FlowVelocityModelValue.java,
1222 src/main/java/de/intevation/flys/model/DischargeZone.java: New model
1223 classes for MINFO specific database relations.
1224
1225 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1226 Registered the new model classes.
1227
1228 2012-04-16 Ingo Weinzierl <ingo@intevation.de>
1229
1230 * doc/schema/oracle-minfo.sql,
1231 doc/schema/oracle-drop-minfo.sql: Added new relations for MINFO specific
1232 flow velocity values.
1233
1234 2012-02-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1235
1236 * doc/schema/oracle-minfo.sql: Fixed column unit_id in table depths
1237 to match type of column id in table units.
1238
1239 * doc/schema/postgresql-minfo.sql: oracle-minfo.sql for a better DBMS.
1240
1241 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1242
1243 * src/main/java/de/intevation/flys/model/MorphologicalWidth.java: Added
1244 annotation for values.
1245
1246 * src/main/java/de/intevation/flys/importer/ImportMorphWidthValue.java:
1247 Removed debug output in getPeer() and storeDependencies().
1248
1249 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1250
1251 * src/main/java/de/intevation/flys/importer/parsers/MorphologicalWidthParser.java:
1252 New parser for morphological widths files.
1253
1254 * src/main/java/de/intevation/flys/importer/ImportMorphWidth.java: Throw
1255 constraint violation exceptions.
1256
1257 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Parse and
1258 store morphological widths.
1259
1260 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1261
1262 * src/main/java/de/intevation/flys/importer/Config.java: Added a config
1263 option to skip parsing morphological widths:
1264
1265 -Dflys.backend.importer.skip.morphological.width=true
1266
1267 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1268
1269 * doc/schema/oracle-minfo.sql: Added a description field to morphological
1270 width values.
1271
1272 * src/main/java/de/intevation/flys/model/MorphologicalWidthValue.java:
1273 Added new instance variable for descriptions.
1274
1275 * src/main/java/de/intevation/flys/importer/ImportMorphWidthValue.java,
1276 src/main/java/de/intevation/flys/importer/ImportMorphWidth.java: New
1277 temp classes used to store morphological width values during the import.
1278
1279 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1280
1281 * doc/schema/oracle-minfo.sql,
1282 doc/schema/oracle-drop-minfo.sql: Added new relations for MINFO specific
1283 morphological width.
1284
1285 * src/main/java/de/intevation/flys/model/MorphologicalWidth.java,
1286 src/main/java/de/intevation/flys/model/MorphologicalWidthValue.java: New
1287 model classes for morphological width.
1288
1289 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1290 Registered new model classes.
1291
1292 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1293
1294 * doc/schema/oracle-minfo.sql: Added a description field to table
1295 sediment_density.
1296
1297 * src/main/java/de/intevation/flys/model/SedimentDensityValue.java,
1298 src/main/java/de/intevation/flys/model/SedimentDensity.java: Some
1299 modifications based on the changes of the schema adaption in last commit.
1300
1301 * src/main/java/de/intevation/flys/importer/parsers/SedimentDensityParser.java:
1302 Override parse() of parent class to get the filename.
1303
1304 * src/main/java/de/intevation/flys/importer/ImportSedimentDensity.java,
1305 src/main/java/de/intevation/flys/importer/ImportDepth.java,
1306 src/main/java/de/intevation/flys/importer/ImportSedimentDensityValue.java:
1307 Implemented the methods storeDependencies() and getPeer() to save new
1308 instances into database.
1309
1310 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Save all
1311 ImportSedimentDensity objects to database.
1312
1313 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1314 Registered the new model classes.
1315
1316 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1317
1318 * doc/schema/oracle-minfo.sql,
1319 doc/schema/oracle-drop-minfo.sql: Modified the db schema specific to
1320 MINFO; replaced some columns.
1321
1322 * src/main/java/de/intevation/flys/importer/parsers/SedimentDensityParser.java:
1323 Implemented the method stubs: parse meta data and data values.
1324
1325 * src/main/java/de/intevation/flys/importer/ImportSedimentDensityValue.java,
1326 src/main/java/de/intevation/flys/importer/ImportSedimentDensity.java:
1327 Added and replaced some instance variables because the db schema has
1328 changed.
1329
1330 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1331
1332 * src/main/java/de/intevation/flys/importer/parsers/LineParser.java: New.
1333 An abstract parser that might be used to read a file and handle each
1334 line contained in the file seperatly.
1335
1336 * src/main/java/de/intevation/flys/importer/parsers/SedimentDensityParser.java:
1337 New. Subclasses LineParser. It is able to parse MINFO specific sediment
1338 density files. NOTE: currently just a stub.
1339
1340 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Prepared to
1341 read MINFO specific sediment density files.
1342
1343 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1344
1345 * src/main/java/de/intevation/flys/importer/Config.java: Added a new
1346 config option to skip parsing MINFO sediment density values:
1347
1348 -Dflys.backend.importer.skip.sediment.density=true
1349
1350 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1351
1352 * src/main/java/de/intevation/flys/importer/ImportSedimentDensity.java,
1353 src/main/java/de/intevation/flys/importer/ImportSedimentDensityValue.java,
1354 src/main/java/de/intevation/flys/importer/ImportDepth.java: New importer
1355 classes used during MINFO sediment density import.
1356
1357 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1358
1359 * doc/schema/oracle-minfo.sql,
1360 doc/schema/oracle-drop-minfo.sql: Improved the MINFO schema to store
1361 sediment density values specific to a river and depth.
1362
1363 * src/main/java/de/intevation/flys/model/SedimentDensityValue.java,
1364 src/main/java/de/intevation/flys/model/SedimentDensity.java,
1365 src/main/java/de/intevation/flys/model/Depth.java: New model classes
1366 used to store sediment density values specific to a river and depth.
1367
1368 2012-04-13 Ingo Weinzierl <ingo@intevation.de>
1369
1370 * src/main/java/de/intevation/flys/importer/parsers/BedHeightParser.java:
1371 New. An abstract super class for BedHeightSingleParser and
1372 BedHeightEpochParser. It implements methods for parsing meta data.
1373 Concrete subclasses need to implements the method for parsing data rows
1374 only.
1375
1376 * src/main/java/de/intevation/flys/importer/ImportBedHeight.java,
1377 src/main/java/de/intevation/flys/importer/ImportBedHeightValue.java: New.
1378 Interfaces that define some major methods which enables the BedHeightParser
1379 to parse both - single and epoch bed heights.
1380
1381 * src/main/java/de/intevation/flys/importer/parsers/BedHeightSingleParser.java:
1382 Moved the code for parsing meta data to BedHeightParser which is now the
1383 parent class.
1384
1385 * src/main/java/de/intevation/flys/importer/parsers/BedHeightEpochParser.java:
1386 New. A further subclass of BedHeightParser for parsing MINFO bed heights
1387 for epochs.
1388
1389 * src/main/java/de/intevation/flys/importer/ImportBedHeightSingleValue.java,
1390 src/main/java/de/intevation/flys/importer/ImportBedHeightEpochValue.java:
1391 Made them subclasses of ImportBedHeightValue.
1392
1393 * src/main/java/de/intevation/flys/importer/ImportBedHeightSingle.java,
1394 src/main/java/de/intevation/flys/importer/ImportBedHeightEpoch.java: Made
1395 them subclasses of ImportBedHeight.
1396
1397 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Some
1398 adjustments to store ImportBedHeight and ImportBedHeightValue instances
1399 instead of concrete subclasses.
1400
1401 2012-04-12 Ingo Weinzierl <ingo@intevation.de>
1402
1403 * doc/schema/oracle-minfo.sql: Added a link to the river to bed_height_epoch
1404 table.
1405
1406 * src/main/java/de/intevation/flys/model/BedHeightEpochValue.java,
1407 src/main/java/de/intevation/flys/model/BedHeightEpoch.java: New model
1408 classes for MINFO bed height epochs.
1409
1410 * src/main/java/de/intevation/flys/importer/Config.java: Splitted up the
1411 config option to skip parsing bed heights. Now, we are able to skip single
1412 and epoch bed heights using the following options:
1413
1414 -Dflys.backend.importer.skip.bed.height.single=true (skip singles)
1415 -Dflys.backend.importer.skip.bed.height.epoch=true (skip epochs)
1416
1417 * src/main/java/de/intevation/flys/importer/ImportBedHeightEpoch.java,
1418 src/main/java/de/intevation/flys/importer/ImportBedHeightEpochValue.java,
1419 src/main/java/de/intevation/flys/importer/ImportRiver.java: Implemented
1420 the whole stuff to parse those data.
1421
1422 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1423 Registered the new model classes.
1424
1425 2012-04-12 Ingo Weinzierl <ingo@intevation.de>
1426
1427 * doc/schema/oracle-minfo.sql,
1428 doc/schema/oracle-drop-minfo.sql: Schema adaptions specific to MINFO bed
1429 heights.
1430
1431 * src/main/java/de/intevation/flys/model/BedHeightSingleValue.java,
1432 src/main/java/de/intevation/flys/model/BedHeightType.java,
1433 src/main/java/de/intevation/flys/model/ElevationModel.java,
1434 src/main/java/de/intevation/flys/model/LocationSystem.java,
1435 src/main/java/de/intevation/flys/model/BedHeightSingle.java: New model
1436 classes for MINFO bed heights.
1437
1438 * src/main/java/de/intevation/flys/importer/parsers/BedHeightSingleParser.java:
1439 Some logging adjustments and a little bugfix: add BedHeightSingle objects
1440 after they were parsed; otherwise they are not saved to database.
1441
1442 * src/main/java/de/intevation/flys/importer/ImportBedHeightSingleValue.java,
1443 src/main/java/de/intevation/flys/importer/ImportBedHeightSingle.java,
1444 src/main/java/de/intevation/flys/importer/ImportElevationModel.java,
1445 src/main/java/de/intevation/flys/importer/ImportLocationSystem.java,
1446 src/main/java/de/intevation/flys/importer/ImportBedHeightType.java,
1447 src/main/java/de/intevation/flys/importer/ImportRiver.java: Implemented
1448 storeDependencies() and getPeer().
1449
1450 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1451 Registered model classes.
1452
1453 2012-04-11 Ingo Weinzierl <ingo@intevation.de>
1454
1455 * src/main/java/de/intevation/flys/importer/parsers/BedHeightSingleParser.java:
1456 Finished work on parsing meta information and data specific to single bed
1457 heights.
1458
1459 * src/main/java/de/intevation/flys/importer/ImportBedHeightSingleValue.java,
1460 src/main/java/de/intevation/flys/importer/ImportBedHeightSingle.java,
1461 src/main/java/de/intevation/flys/importer/ImportElevationModel.java,
1462 src/main/java/de/intevation/flys/importer/ImportLocationSystem.java,
1463 src/main/java/de/intevation/flys/importer/ImportBedHeightType.java: Some
1464 new and modified temp storages used during MINFO import.
1465
1466 2012-04-11 Ingo Weinzierl <ingo@intevation.de>
1467
1468 * doc/schema/oracle-minfo.sql,
1469 doc/schema/oracle-drop-minfo.sql: Some schema adaptions specific to bed
1470 heights in MINFO.
1471
1472 2012-04-11 Ingo Weinzierl <ingo@intevation.de>
1473
1474 * src/main/java/de/intevation/flys/importer/Config.java: Added new command
1475 line option to skip parsing bed heights (german "Sohlhoehen").
1476 Set "-Dflys.backend.importer.skip.bed.height=true" to skip parsing this
1477 file type.
1478
1479 * src/main/java/de/intevation/flys/importer/parsers/BedHeightEpochParser.java,
1480 src/main/java/de/intevation/flys/importer/parsers/BedHeightSingleParser.java:
1481 Initial checkin of parsers for bed heights (single and epoch).
1482
1483 * src/main/java/de/intevation/flys/importer/ImportBedHeightSingle.java,
1484 src/main/java/de/intevation/flys/importer/ImportBedHeightEpoch.java: Temp
1485 storage for bed heights data used during the import.
1486
1487 * src/main/java/de/intevation/flys/importer/Importer.java: Added an INFO
1488 statement that signals the start of parsing rivers.
1489
1490 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Collect and
1491 trigger parsing of bed heights files (placed in 'Morphologie/Sohlhoehen').
1492
1493 2012-04-11 Ingo Weinzierl <ingo@intevation.de>
1494
1495 * doc/schema/oracle-minfo.sql,
1496 doc/schema/oracle-drop-minfo.sql: MINFO specific DB schema and sql statements
1497 to drop MINFO specific stuff.
1498
1499 2012-03-29 Ingo Weinzierl <ingo@intevation.de>
1500
1501 * src/main/java/de/intevation/flys/importer/Config.java: Added a config
1502 option "flys.backend.importer.infogew.file" to set the path of an
1503 INFO.gew file.
1504
1505 * src/main/java/de/intevation/flys/importer/Importer.java: Read the path
1506 to the INFO.gew from the new config option and try to parse it.
1507
1508 2012-03-19 Ingo Weinzierl <ingo@intevation.de>
1509
1510 * doc/schema/oracle-spatial.sql: Set the type of 'lower' and 'upper' column
1511 of relation 'dem' to NUMBER(19,5).
1512
1513 2012-03-19 Ingo Weinzierl <ingo@intevation.de>
1514
1515 * src/main/java/de/intevation/flys/model/Floodmaps.java: Set geometry type
1516 to 'Geometry', because Oracle can save POLYGONS and MULTIPOLYGONS in the
1517 same relation; Hibernate seems unable to load both types.
1518
1519 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1520 Registered missing Floodmaps.
1521
1522 2012-03-16 Ingo Weinzierl <ingo@intevation.de>
1523
1524 * Tagged module as 'pre2.7-2012-03-16'.
1525
1526 2012-03-16 Ingo Weinzierl <ingo@intevation.de>
1527
1528 * doc/schema/oracle-spatial.sql: Repaired broken oracle db schema for
1529 relation 'floodmaps'.
1530
1531 2012-03-08 Ingo Weinzierl <ingo@intevation.de>
1532
1533 * src/main/java/de/intevation/flys/model/Floodmaps.java: New model class for
1534 'floodmaps'.
1535
1536 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1537 Registered the Floodmaps model class.
1538
1539 2012-03-07 Ingo Weinzierl <ingo@intevation.de>
1540
1541 * contrib/shpimporter/shpimporter.py,
1542 contrib/shpimporter/utils.py,
1543 contrib/shpimporter/uesg.py: A python based tool for importing
1544 shapefiles into a database. This tool is based on python because it
1545 makes use of GDAL OGR to read shapefiles and write features into
1546 database.
1547
1548 2012-03-07 Ingo Weinzierl <ingo@intevation.de>
1549
1550 * doc/schema/postgresql-spatial.sql: Adapted the PostgreSQL schema for
1551 floodmaps.
1552
1553 2012-03-06 Ingo Weinzierl <ingo@intevation.de>
1554
1555 * doc/schema/postgresql-spatial.sql,
1556 doc/schema/oracle-spatial.sql: Added new relations for existing
1557 floodmaps (currently tested for PostgreSQL only!).
1558
1559 2012-03-06 Ingo Weinzierl <ingo@intevation.de>
1560
1561 * src/main/java/de/intevation/flys/model/Wst.java: Adapted method call of
1562 Log4J logger 'warning()' -> 'warn()'.
1563
1564 2012-03-02 Felix Wolfsteller <felix.wolfsteller@intevation.de>
1565
1566 Fix or workaround flys/issue632 .
1567
1568 * src/main/java/de/intevation/flys/model/Wst.java: Avoid NPE when
1569 trying to get min/max q values.
1570
1571 2012-02-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1572
1573 * src/main/java/de/intevation/flys/model/DischargeTable.java:
1574 The list of DischargeTableValue is now sorted by Q.
1575
1576 2012-02-09 Ingo Weinzierl <ingo@intevation.de>
1577
1578 * src/main/java/de/intevation/flys/model/Gauge.java: Added a method
1579 getMasterDischargeTable() to retrieve the discharge table with kind 0.
1580
1581 2012-02-03 Felix Wolfsteller <felix.wolfsteller@intevation.de>
1582
1583 * src/main/java/de/intevation/flys/model/River.java
1584 (getGaugeDatumsKMs,queryGaugeDatumsKMs): renamed to avoid hibernate
1585 running into trouble finding db-mapping for type Map for
1586 what looks like a 'getter' of GaugeDatumsKMs.
1587
1588 2012-02-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1589
1590 * src/main/java/de/intevation/flys/model/River.java(getGaugeDatumsKMs):
1591 New method to build a map of gauge stattion km to
1592 the datums (PNP) of the gauge. Useful look if a km
1593 is a gauge station.
1594
1595 2012-01-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1596
1597 * src/main/java/de/intevation/flys/model/FastAnnotations.java:
1598 New. Fetches all informations of annotations in one go for
1599 a river. Useful to speed up annotation handling.
1600
1601 2012-01-18 Ingo Weinzierl <ingo@intevation.de>
1602
1603 * src/main/java/de/intevation/flys/model/Gauge.java: Added a function that
1604 returns a Gauge based on its official number.
1605
1606 2012-01-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1607
1608 * src/main/java/de/intevation/flys/model/FastCrossSectionLine.java:
1609 New. Cacheable representation of the cross section line.
1610
1611 * src/main/java/de/intevation/flys/model/CrossSectionLine.java:
1612 Add a new isValid() method.
1613
1614 * src/main/java/de/intevation/flys/model/CrossSection.java:
1615 Added method getFastLines() to fetch the lines (FastCrossSectionLines)
1616 directly with a single SQL statement and without expensive
1617 intermediate representations.
1618
1619 2012-01-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1620
1621 * src/main/java/de/intevation/flys/model/CrossSection.java(getLines):
1622 Added method to fetch the lines of a cross section in a given interval.
1623 Useful to have chunked access to the lines.
1624
1625 2012-01-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1626
1627 * src/main/java/de/intevation/flys/model/CrossSectionLine.java
1628 (fetchCrossSectionLinesPoints): Simplified and prevent reallocations.
1629
1630 2012-01-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1631
1632 * src/main/java/de/intevation/flys/importer/parsers/StaFileParser.java:
1633 Introduced boolean system property 'flys.backend.sta.parse.gauge.numbers'
1634 default: false. If set the official number is parsed out of
1635 the first line of the STA files. This leads to problems with the
1636 data of the Elbe river.
1637
1638 * src/main/java/de/intevation/flys/backend/SpatialInfo.java: Removed
1639 superfluous import.
1640
1641 2012-01-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1642
1643 * doc/schema/postgresql-spatial.sql: Fixed table hws.
1644
1645 2012-01-05 Ingo Weinzierl <ingo@intevation.de>
1646
1647 * src/main/java/de/intevation/flys/model/RiverAxis.java: The method
1648 getRiverAxis() now returns a list of RiverAxis objects. There is a
1649 modeling problem (see comment in the header of the class) which should
1650 be fixed!
1651
1652 * src/main/java/de/intevation/flys/backend/SpatialInfo.java: Adapted the
1653 code based on the modified signature in RiverAxis.
1654
1655 2012-01-03 Ingo Weinzierl <ingo@intevation.de>
1656
1657 * src/main/java/de/intevation/flys/model/Wst.java: Added a method
1658 determineMinMaxQFree() that determines the min/max Qs at a given
1659 kilometer.
1660
1661 2012-01-02 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1662
1663 * doc/schema/postgresql.sql: Remove 'NOT NULL' constraint from
1664 gauges.range_id because there are gauges which don't have
1665 a 'Gueltigkeitsbereich'
1666
1667 To adjust existing PostgreSQL databases use:
1668
1669 ALTER TABLE gauges ALTER COLUMN range_id DROP NOT NULL;
1670
1671 * src/main/java/de/intevation/flys/model/River.java: Handle
1672 null references to 'Gueltigkeitsbereiche'.
1673
1674 2011-12-28 Ingo Weinzierl <ingo@intevation.de>
1675
1676 * src/main/java/de/intevation/flys/model/Wst.java: Added a method
1677 determineMinMaxQ(double double) to be able to determine the Q range of a
1678 WST without having a Range object.
1679
1680 2011-12-19 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
1681
1682 * src/main/java/de/intevation/flys/importer/parsers/StaFileParser.java:
1683 Parse the official 'Pegelnummer' out of the STA files, too.
1684
1685 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
1686 Adjusted import model.
1687
1688 * src/main/java/de/intevation/flys/model/Gauge.java: Make the
1689 official gauge number accessible via Hibernate.
1690
1691 * doc/schema/postgresql.sql, doc/schema/oracle.sql: Added
1692 an official_number to the gauges table.
1693
1694 2011-11-30 Bjoern Schilberg <bjoern.schilberg@intevation.de>:
1695
1696 * doc/schema/oracle-spatial.sql: Adjust extent of germany to EPSG:31467
1697 (GK3) coordinates.
1698
1699 2011-11-30 Bjoern Schilberg <bjoern.schilberg@intevation.de>:
1700
1701 * doc/schema/oracle-spatial.sql: Adjust extent to the extent of germany
1702 and srs to 31467 in USER_SDO_GEOM_METADATA.
1703
1704 2011-11-29 Bjoern Schilberg <bjoern.schilberg@intevation.de>:
1705
1706 * doc/schema/oracle_create_user.sql: Fixed notation of the table in the
1707 alter statement.
1708
1709 2011-11-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
1710
1711 Fixed flys/issue415
1712
1713 * doc/schema/oracle.sql: Increased precision of a and b in ranges.
1714
1715 2011-11-10 Ingo Weinzierl <ingo@intevation.de>
1716
1717 * src/main/java/de/intevation/flys/model/Building.java,
1718 src/main/java/de/intevation/flys/model/Fixpoint.java: Added functions
1719 that return a list of Buildings/Fixpoints for a given river.
1720
1721 2011-11-10 Ingo Weinzierl <ingo@intevation.de>
1722
1723 * doc/schema/oracle-spatial.sql,
1724 doc/schema/postgresql-spatial.sql: Adapted the "kind" field of "lines"
1725 relation (Int -> Varchar).
1726
1727 * doc/schema/oracle-spatial_idx.sql: Added missing spatial index for
1728 "lines" relation.
1729
1730 * src/main/java/de/intevation/flys/model/Line.java: Added a function that
1731 returns all lines of a given river.
1732
1733 2011-11-09 Ingo Weinzierl <ingo@intevation.de>
1734
1735 * src/main/java/de/intevation/flys/model/Catchment.java: New. A model for
1736 the 'catchment' relation.
1737
1738 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1739 Registered the Catchment model.
1740
1741 2011-11-09 Ingo Weinzierl <ingo@intevation.de>
1742
1743 * doc/schema/postgresql-spatial.sql: Synced "hws" relation with oracle
1744 schema.
1745
1746 * src/main/java/de/intevation/flys/model/Hws.java: New. A model for the
1747 "hws" relation.
1748
1749 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1750 Registered the Hws model.
1751
1752 2011-11-09 Ingo Weinzierl <ingo@intevation.de>
1753
1754 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1755 Added methods that return information about the database connection used
1756 by a concrete SessionFactoryImpl.
1757
1758 2011-11-09 Ingo Weinzierl <ingo@intevation.de>
1759
1760 * src/main/java/de/intevation/flys/model/Floodplain.java: Changed the
1761 geometry type from MultiPolygon to Polygon.
1762
1763 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1764 Added a function that returns the db driver of a given
1765 SessionFactoryImpl instance.
1766
1767 2011-11-01 Ingo Weinzierl <ingo@intevation.de>
1768
1769 * src/main/java/de/intevation/flys/model/RiverAxisKm.java: New. Model class
1770 for 'river_axes_km' relation.
1771
1772 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1773 Added mapping for RiverAxisKm.
1774
1775 2011-10-25 Bjoern Schilberg <bjoern.schilberg@intevation.de>
1776
1777 * doc/schema/oracle_create_user.sql:
1778 Added explizit TABLESPACE definition for the user.
1779
1780 2011-10-25 Bjoern Schilberg <bjoern.schilberg@intevation.de>
1781
1782 * doc/schema/oracle_create_user.sql:
1783 Adjusted oracle_create_user.sql script. Added USER SQL snippet to change
1784 tablespace to users.
1785
1786 2011-10-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
1787
1788 * src/main/java/de/intevation/flys/utils/DateGuesser.java:
1789 New. Date guesser from desktop FLYS.
1790
1791 * src/main/java/de/intevation/flys/importer/parsers/WstParser.java:
1792 Try to parse the name of a WST column as a date and store
1793 the date into the database
1794
1795 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
1796 Added code to store the date of the column in the database.
1797
1798 2011-10-24 Bjoern Schilberg <bjoern.schilberg@intevation.de>
1799
1800 * doc/schema/postgresql-spatial.sql:
1801 Adjusted geometry type for floodplain and hws in AddGeometryColumn.
1802
1803 2011-10-19 Bjoern Schilberg <bjoern.schilberg@intevation.de>
1804
1805 * doc/schema/oracle.sql:
1806 Added missing views (wst_value_table,wst_w_values,wst_q_values).
1807
1808 2011-10-18 Bjoern Schilberg <bjoern.schilberg@intevation.de>
1809
1810 * doc/schema/oracle.sql:
1811 Removed all CREATE OR REPLACE TRIGGER statements.
1812
1813 2011-10-17 Bjoern Schilberg <bjoern.schilberg@intevation.de>
1814
1815 * doc/schema/oracle.sql:
1816 Adjusted NUMBER format for units, positions and cross_section_points tables.
1817
1818 2011-10-10 Bjoern Schilberg <bjoern.schilberg@intevation.de>
1819
1820 * doc/schema/oracle.sql:
1821 Fix errors.
1822
1823 2011-10-10 Bjoern Schilberg <bjoern.schilberg@intevation.de>
1824
1825 * doc/schema/oracle.sql:
1826 Adjust oracle schema [I382].
1827
1828 2011-10-10 Felix Wolfsteller <felix.wolfsteller@intevation.de>
1829
1830 * src/main/java/de/intevation/flys/importer/ImportWst.java,
1831 src/main/java/de/intevation/flys/importer/ImportUnit.java:
1832 Removed obsolete imports.
1833
1834 2011-10-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
1835
1836 * ChangeLog: Added database update statements.
1837
1838 To update existing databases:
1839
1840 BEGIN;
1841 CREATE SEQUENCE UNITS_ID_SEQ;
1842 CREATE TABLE units (
1843 id int PRIMARY KEY NOT NULL,
1844 name VARCHAR(32) NOT NULL UNIQUE
1845 );
1846 ALTER TABLE rivers ADD COLUMN wst_unit_id int REFERENCES units(id);
1847 INSERT INTO units (id, name) VALUES (nextval('UNITS_ID_SEQ'), 'NN + m');
1848 INSERT INTO units (id, name) VALUES (nextval('UNITS_ID_SEQ'), 'NHN + m');
1849 UPDATE rivers SET wst_unit_id = (SELECT id FROM units WHERE name = 'NHN + m') WHERE name = 'Elbe';
1850 UPDATE rivers SET wst_unit_id = (SELECT id FROM units WHERE name = 'NN + m') WHERE name <> 'Elbe';
1851 ALTER TABLE rivers ALTER COLUMN wst_unit_id SET NOT NULL;
1852 COMMIT;
1853
1854 2011-10-05 Ingo Weinzierl <ingo@intevation.de>
1855
1856 * contrib/dump-schema.sh: New. A small shell script that dumps the
1857 database schema of a given database to SQL.
1858
1859 * pom.xml: Added dependency for hibernate-spatial-oracle stuff.
1860
1861 2011-10-04 Ingo Weinzierl <ingo@intevation.de>
1862
1863 * doc/schema/postgresql.sql: Removed unit column from wsts; added a
1864 wst_unit_id column to rivers. We decided to support a single elevation
1865 model for the whole river.
1866
1867 * src/main/java/de/intevation/flys/model/River.java: Added a WstUnit
1868 column.
1869
1870 * src/main/java/de/intevation/flys/model/Wst.java: Removed the Unit
1871 column.
1872
1873 * src/main/java/de/intevation/flys/importer/ImportWst.java: Provide a
1874 getUnit() method that allows querying the elevation unit for this wst.
1875
1876 * src/main/java/de/intevation/flys/importer/ImportUnit.java: Removed
1877 storeDependencies().
1878
1879 * src/main/java/de/intevation/flys/importer/ImportRiver.java: Save the
1880 Unit of the wst file or a default one into database before all other
1881 dependencies as well as the river itself is saved to database.
1882
1883 2011-10-04 Ingo Weinzierl <ingo@intevation.de>
1884
1885 * doc/schema/postgresql.sql: Added a "units" table.
1886
1887 * src/main/java/de/intevation/flys/model/Unit.java: New. Model class that
1888 represents a unit.
1889
1890 * src/main/java/de/intevation/flys/importer/ImportUnit.java: New. Model
1891 class that is used to import units.
1892
1893 * src/main/java/de/intevation/flys/model/Wst.java: A Wst stores a Unit
1894 which references "units" table now.
1895
1896 * src/main/java/de/intevation/flys/importer/parsers/WstParser.java: Set
1897 units which have already been parsed on Wsts.
1898
1899 * src/main/java/de/intevation/flys/importer/ImportWst.java: Added setter
1900 method for Units and call storeDependencies() for ImportUnits.
1901
1902 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1903 Registered new model class Unit.
1904
1905 2011-10-04 Ingo Weinzierl <ingo@intevation.de>
1906
1907 flys/issue333 (W-INFO / Berechnung Wasserspiegellage, Zuordnung Bezugspegel)
1908
1909 * src/main/java/de/intevation/flys/model/River.java: Modified
1910 determination of gauge based on a km range. River.determineGauge(double,
1911 double) will now return the gauge which matches the start km.
1912
1913 2011-09-28 Felix Wolfsteller <felix.wolfsteller@intevation.de>
1914
1915 * src/main/java/de/intevation/flys/utils/StringUtil.java:
1916 (wWrap): New method (extracted from WaterlevelSelectState).
1917
1918 2011-09-28 Felix Wolfsteller <felix.wolfsteller@intevation.de>
1919
1920 * src/main/java/de/intevation/flys/utils/StringUtil.java:
1921 (unbracket): New method (extracted from WaterlevelSelectState).
1922
1923 2011-09-27 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1924
1925 * src/main/java/de/intevation/flys/model/CrossSectionLine.java:
1926 Moved some logic from cross section demo app to this model.
1927
1928 2011-09-26 Ingo Weinzierl <ingo@intevation.de>
1929
1930 * src/main/java/de/intevation/flys/model/CrossSectionTrack.java:
1931 Added new function that the nearest CrossSectionTrack of a river to a
1932 given kilometer.
1933
1934 2011-09-23 Bjoern Schilberg <bjoern@intevation.de>
1935
1936 * doc/schema/postgresql-spatial.sql:
1937 Added missing river_axes_km schema.
1938 * doc/schema/oracle-spatial.sql:
1939 Added missing dem and lines schema.
1940
1941 2011-09-22 Bjoern Schilberg <bjoern@intevation.de>
1942
1943 * doc/schema/postgresql-spatial.sql, doc/schema/oracle-spatial.sql:
1944 Harmonized oracle and postgresql spatial schema.
1945
1946 2011-09-22 Bjoern Schilberg <bjoern@intevation.de>
1947
1948 * doc/schema/oracle-spatial.sql: Harmonized Extent for Saar and Mosel. Some cleanups.
1949
1950 2011-09-22 Ingo Weinzierl <ingo@intevation.de>
1951
1952 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
1953 Added the possibility to enable JMX (/MBean) support for hibernate. By
1954 default, this support is NOT enabled. To enable JMX support for
1955 hibernate, set the system property "flys.backend.enablejmx=true".
1956
1957 2011-09-20 Bjoern Schilberg <bjoern@intevation.de>
1958
1959 * doc/schema/oracle_create_user.sql: Added right to create views.
1960
1961 2011-09-20 Bjoern Schilberg <bjoern@intevation.de>
1962
1963 * doc/schema/oracle-spatial.sql: Generalized oracle spatial schema.
1964
1965 2011-09-19 Ingo Weinzierl <ingo@intevation.de>
1966
1967 Tagged RELEASE 2.5
1968
1969 * Changes: Prepared changes for release.
1970
1971 2011-09-16 Ingo Weinzierl <ingo@intevation.de>
1972
1973 * src/main/java/de/intevation/flys/model/DGM.java: Added function to query
1974 a DGM by Id.
1975
1976 2011-09-15 Bjoern Schilberg <bjoern@intevation.de>
1977
1978 * pom.xml: Removed oracle dependency.
1979
1980 2011-09-15 Bjoern Schilberg <bjoern@intevation.de>
1981
1982 * doc/schema/oracle.sql: Added inital oracle schema.
1983
1984 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
1985
1986 * doc/schema/oracle-spatial_idx.sql: Added inital oracle-spatial_idx.sql
1987 script.
1988
1989 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
1990
1991 * doc/schema/oracle-spatial.sql: Deactivated spatial indexes.
1992
1993 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
1994
1995 * doc/schema/oracle_create_user.sql: Added inital oracle_create_user.sql
1996 script.
1997
1998 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
1999
2000 * doc/schema/oracle-spatial.sql: Added schema floodplain.
2001
2002 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
2003
2004 * doc/schema/oracle-spatial.sql: Added schema hws.
2005
2006 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
2007
2008 * doc/schema/oracle-spatial.sql: Added schema cross_section_tracks.
2009
2010 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
2011
2012 * doc/schema/oracle-spatial.sql: Added schema river_axes.
2013
2014 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
2015
2016 * doc/schema/oracle-spatial.sql: Added schema fixpoints.
2017
2018 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
2019
2020 * doc/schema/oracle-spatial.sql: Added schema buildings.
2021
2022 2011-09-14 Bjoern Schilberg <bjoern@intevation.de>
2023
2024 * doc/schema/oracle-spatial.sql: Fixed table river_axes_km.
2025
2026 2011-09-13 Bjoern Schilberg <bjoern@intevation.de>
2027
2028 * doc/schema/oracle-spatial.sql: Added initial oracle schemas.
2029
2030 2011-09-12 Bjoern Schilberg <bjoern@intevation.de>
2031
2032 * doc/schema/postgresql-spatial.sql: Added initial schemas for
2033 Hydrologie/Einzugsgebiete, Hydrologie/HW-Schutzanlagen, Hydrologie/Hydr.
2034 Grenzen/Linien, BfG/hauptoeff_*.shp, BfG/MNQ-*.shp,
2035 BfG/modellgrenze*.shp, BfG/uferlinie.shp, BfG/vorland_*.shp,
2036 Hydrologie/Streckendaten, Hydrologie/UeSG/Berechnung,
2037 Hydrologie/UeSG/Messung
2038
2039 2011-09-02 Ingo Weinzierl <ingo@intevation.de>
2040
2041 * doc/schema/postgresql-spatial.sql: Removed SERIALs from schema.
2042 Auto-Increment is realized through SERIALs now.
2043
2044 * src/main/java/de/intevation/flys/model/DGM.java: The table for dem has
2045 been renamed to 'dem' (before 'dgm').
2046
2047 2011-09-01 Hans Plum <hans@intevation.de>
2048
2049 * doc/schema/postgresql-spatial.sql:
2050 Hint for unifying table names: dgm -> dem
2051
2052 2011-09-01 Hans Plum <hans@intevation.de>
2053
2054 * doc/schema/postgresql-spatial.sql:
2055 Added mappings to existing data in file system (based on
2056 river Saar); added TODOs for missing tables/mappings
2057
2058 2011-08-31 Ingo Weinzierl <ingo@intevation.de>
2059
2060 * doc/schema/postgresql-spatial.sql: New relation for floodplains (german
2061 "Talaue").
2062
2063 * src/main/java/de/intevation/flys/model/Floodplain.java: New. Model class
2064 that represents a floodplain.
2065
2066 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2067 Registered the Floodplain mapping.
2068
2069 2011-08-31 Ingo Weinzierl <ingo@intevation.de>
2070
2071 * doc/schema/postgresql-spatial.sql: Added a relation for DGMs. Note, that
2072 no data of the DGM is stored in this relation, but only the file path to
2073 the DGM file.
2074
2075 * src/main/java/de/intevation/flys/model/DGM.java: New. This class provides
2076 information for a DGM (km range and file path).
2077
2078 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2079 Registered the DGM.
2080
2081 2011-08-30 Ingo Weinzierl <ingo@intevation.de>
2082
2083 * src/main/java/de/intevation/flys/model/CrossSectionTrack.java: New
2084 static function to retrieve all CrossSectionTracks of a specific river.
2085
2086 2011-08-25 Ingo Weinzierl <ingo@intevation.de>
2087
2088 * src/main/java/de/intevation/flys/utils/FileTools.java: Moved to
2089 artifacts-common module.
2090
2091 * src/main/java/de/intevation/flys/importer/parsers/PegelGltParser.java,
2092 src/main/java/de/intevation/flys/importer/parsers/PRFParser.java,
2093 src/main/java/de/intevation/flys/importer/parsers/HYKParser.java,
2094 src/main/java/de/intevation/flys/importer/parsers/AnnotationsParser.java,
2095 src/main/java/de/intevation/flys/importer/parsers/InfoGewParser.java,
2096 src/main/java/de/intevation/flys/importer/ImportRiver.java,
2097 src/main/java/de/intevation/flys/importer/ImportGauge.java: Adjusted
2098 imports of FileTools.
2099
2100 2011-08-25 Felix Wolfsteller <felix.wolfsteller@intevation.de>
2101
2102 * src/main/java/de/intevation/flys/model/Gauge.java (getMainValues)
2103 (setMainValues):
2104 New method and mapping to get/set MainValues of a Gauge. Essentially
2105 developed by Sascha L. Teichmann.
2106
2107 2011-08-22 Ingo Weinzierl <ingo@intevation.de>
2108
2109 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2110 Reverted the default db dialect to PostgreSQL - this has been changed to
2111 PostGIS by accident.
2112 Configure the dialect "org.hibernatespatial.postgis.PostgisDialect" to
2113 use the PostGIS stuff.
2114
2115 2011-08-22 Ingo Weinzierl <ingo@intevation.de>
2116
2117 * src/main/java/de/intevation/flys/model/RiverAxis.java: Added a function
2118 that returns the RiverAxis for a given River.
2119
2120 * src/main/java/de/intevation/flys/backend/SpatialInfo.java: Use the new
2121 function of RiverAxis to retrieve the RiverAxis.
2122
2123 2011-08-18 Ingo Weinzierl <ingo@intevation.de>
2124
2125 * doc/schema/postgresql-spatial.sql: The PostGIS database schema for
2126 FLYS spatial data.
2127
2128 * src/main/java/de/intevation/flys/model/CrossSectionTrack.java,
2129 src/main/java/de/intevation/flys/model/RiverAxis.java,
2130 src/main/java/de/intevation/flys/model/Line.java,
2131 src/main/java/de/intevation/flys/model/Building.java,
2132 src/main/java/de/intevation/flys/model/Fixpoint.java: Model classes that
2133 represent FLYS spatial data.
2134
2135 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2136 Registered model classes.
2137
2138 * pom.xml: Added dependencies to HibernateSpatial and PostGIS.
2139
2140 * src/main/java/de/intevation/flys/backend/SpatialInfo.java,
2141 contrib/spatial-info.sh: A small demo application that prints out some
2142 information about spatial data of specific rivers. Modify the system
2143 property -Dflys.backend.spatial.river to get information of a river of
2144 your choice.
2145
2146 2011-07-31 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2147
2148 Re-enabled Hibernate schema dumps.
2149
2150 * src/main/java/de/intevation/flys/App.java: Removed old code
2151 and use new SessionFactoryProvider infrastructure.
2152
2153 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2154 Added methods to create db configurations without opening them.
2155 Useful for introspection only purposes.
2156
2157 2011-07-31 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2158
2159 * pom.xml: Bumped Apache DBCP up to 1.4 to use the same version
2160 as artifact database.
2161
2162 2011-07-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2163
2164 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
2165 Make use of the LRU cache from artifacts common.
2166
2167 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2168
2169 * doc/schema/postgresql.sql: Added missing foreign key contraint on hyks table.
2170 To update existing databases:
2171
2172 ALTER TABLE hyks ADD CONSTRAINT hyks_river_id_fkey FOREIGN KEY (river_id) REFERENCES rivers(id);
2173
2174 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2175
2176 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java:
2177 Check if zone coordinates in HYKs are swapped and warn the user.
2178
2179 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2180
2181 * src/main/java/de/intevation/flys/model/HYK.java
2182 src/main/java/de/intevation/flys/importer/parsers/HYKParser.java,
2183 src/main/java/de/intevation/flys/importer/ImportHYKFormation.java,
2184 src/main/java/de/intevation/flys/importer/ImportHYKEntry.java,
2185 src/main/java/de/intevation/flys/importer/ImportHYK.java:
2186 Various small fixes and some extra logging.
2187
2188 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2189
2190 * src/main/java/de/intevation/flys/importer/Config.java: New.
2191 Central singleton to configure the Importer.
2192 Uses system properties by now:
2193
2194 flys.backend.importer.dry.run: boolean
2195 default false. true: don't write to database.
2196
2197 flys.backend.importer.annotation.types: String
2198 default unset. Filename of annotation type classifications.
2199
2200 flys.backend.importer.skip.gauges: boolean
2201 default: false. true: don't parse/store *.glt, *.sta files
2202
2203 flys.backend.importer.skip.annotations: boolean
2204 default: false. true: don't parse/store *.km files
2205
2206 flys.backend.importer.skip.prfs: boolean
2207 default: false. true: don't parse/store *.prf files
2208
2209 flys.backend.importer.skip.hyks: boolean
2210 default: false. true: don't parse/store *.hyk files
2211
2212 flys.backend.importer.skip.wst: boolean
2213 default: false. true: don't parse/store river wst files
2214
2215 flys.backend.importer.skip.extra.wsts: boolean
2216 default: false. true: don't parse/store extra *.zus, *.wst files
2217
2218 flys.backend.importer.skip.fixations: boolean
2219 default: false. true: don't parse/store fixation *.wst files
2220
2221 flys.backend.importer.skip.official.lines: boolean
2222 default: false. true: don't parse/store 'amtliche Linien' *.wst files
2223
2224 flys.backend.importer.skip.flood.water: boolean
2225 default: false. true: don't parse/store 'HW-Marken' *.wst files
2226
2227 flys.backend.importer.skip.flood.protection: boolean
2228 default: false. true: don't parse/store 'HW-Schutzanlagen' *.wst files
2229
2230 2011-07-18 Ingo Weinzierl <ingo@intevation.de>
2231
2232 * src/main/java/de/intevation/flys/model/HYKEntry.java: Fixed OrderBy
2233 clause.
2234
2235 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2236
2237 * src/main/java/de/intevation/flys/importer/ImportHYKFormation.java,
2238 src/main/java/de/intevation/flys/importer/ImportHYKFlowZone.java,
2239 src/main/java/de/intevation/flys/importer/ImportHYKEntry.java,
2240 src/main/java/de/intevation/flys/importer/ImportRiver.java,
2241 src/main/java/de/intevation/flys/importer/ImportHYK.java:
2242 Store HYK data structures to database. Needs testing.
2243
2244 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2245
2246 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
2247 Parse the HYKs from the importer. TODO: Store them in database.
2248
2249 2011-07-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2250
2251 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java:
2252 Create data structures while parsing.
2253
2254 * src/main/java/de/intevation/flys/importer/ImportHYKFormation.java,
2255 src/main/java/de/intevation/flys/importer/ImportHYK.java: Added
2256 getters/setters to ease model wiring.
2257
2258 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2259
2260 * src/main/java/de/intevation/flys/importer/ImportHYKFormation.java,
2261 src/main/java/de/intevation/flys/importer/ImportHYKFlowZone.java,
2262 src/main/java/de/intevation/flys/importer/ImportHYKEntry.java,
2263 src/main/java/de/intevation/flys/importer/ImportHYK.java: New.
2264 Importer models for HYKs.
2265
2266 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2267
2268 * doc/schema/postgresql.sql: Each entry in a HYK can have
2269 an optional 'Peilungsjahr' (measure) not only the whole HYK.
2270 To update existing databases:
2271 BEGIN;
2272 ALTER TABLE hyks DROP COLUMN measure;
2273 ALTER TABLE hyk_entries ADD COLUMN measure TIMESTAMP;
2274 COMMIT;
2275
2276 * src/main/java/de/intevation/flys/model/HYKEntry.java,
2277 src/main/java/de/intevation/flys/model/HYK.java:
2278 Adjusted Hibernate models.
2279
2280 2011-07-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2281
2282 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java:
2283 Added callback mechanism and recursive file search like in the PRF parser.
2284 All BfG-HYK files seem to parse correctly now. TODO: Build the data structures.
2285
2286 * src/main/java/de/intevation/flys/importer/parsers/PRFParser.java:
2287 Added x.canRead() before accepting files for parsing.
2288
2289 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2290
2291 * src/main/java/de/intevation/flys/importer/parsers/HYKParser.java:
2292 Initial version of the HYK parser. Not ready, yet.
2293
2294 * src/main/java/de/intevation/flys/importer/ImportHYKFlowZoneType.java:
2295 Importer model for HYK flow zone types.
2296
2297 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2298
2299 * doc/schema/postgresql.sql: Argh! Added distance_{vl|hf|vr} to
2300 wrong table.
2301 To update existing databases:
2302 BEGIN;
2303 ALTER TABLE hyk_entries DROP COLUMN distance_vl;
2304 ALTER TABLE hyk_entries DROP COLUMN distance_hf;
2305 ALTER TABLE hyk_entries DROP COLUMN distance_vr;
2306 ALTER TABLE hyk_formations ADD COLUMN distance_vl NUMERIC NOT NULL;
2307 ALTER TABLE hyk_formations ADD COLUMN distance_hf NUMERIC NOT NULL;
2308 ALTER TABLE hyk_formations ADD COLUMN distance_vr NUMERIC NOT NULL;
2309 COMMIT;
2310
2311 * src/main/java/de/intevation/flys/model/HYKFormation.java,
2312 src/main/java/de/intevation/flys/model/HYKEntry.java:
2313 Adjusted Hibernate models.
2314
2315 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2316
2317 * src/main/java/de/intevation/flys/utils/FileTools.java: Added method
2318 walkTree() to traverse a directory tree. To be reused in HYK parser.
2319
2320 * src/main/java/de/intevation/flys/importer/parsers/PRFParser.java:
2321 Uses the FileTools.walkTree() method now to find all PRF file.
2322
2323 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2324
2325 * doc/schema/postgresql.sql: Added missing columns.
2326 To update existing databases:
2327 BEGIN;
2328 ALTER TABLE hyks ADD COLUMN measure TIMESTAMP;
2329 ALTER TABLE hyk_entries ADD COLUMN distance_vl NUMERIC NOT NULL;
2330 ALTER TABLE hyk_entries ADD COLUMN distance_hf NUMERIC NOT NULL;
2331 ALTER TABLE hyk_entries ADD COLUMN distance_vr NUMERIC NOT NULL;
2332 COMMIT;
2333
2334 * src/main/java/de/intevation/flys/model/HYKEntry.java,
2335 src/main/java/de/intevation/flys/model/HYK.java:
2336 Adjusted Hibernate models.
2337
2338 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2339
2340 * src/main/java/de/intevation/flys/importer/parsers/*.java:
2341 New package. Moved the file parsers (*.gew, *.sta, *.at, *.glt, *.prf, *.km, *.wst)
2342 into this package.
2343
2344 * src/main/java/de/intevation/flys/importer/*.java: Adjusted the imports.
2345
2346 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2347
2348 * src/main/java/de/intevation/flys/model/HYKFormation.java,
2349 src/main/java/de/intevation/flys/model/HYKEntry.java,
2350 src/main/java/de/intevation/flys/model/HYKFlowZone.java,
2351 src/main/java/de/intevation/flys/model/HYKFlowZoneType.java,
2352 src/main/java/de/intevation/flys/model/HYK.java: New. The hibernate models
2353 for the HYK structures.
2354
2355 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2356 Registered new models.
2357
2358 * src/main/java/de/intevation/flys/model/CrossSection.java: Added
2359 'order by' annotation for fetching the cross section lines.
2360
2361 2011-07-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2362
2363 * doc/schema/postgresql.sql: Added structures for HYKs "Hydraulische Kenngroessen"
2364 To update existing databases:
2365
2366 BEGIN;
2367 CREATE SEQUENCE HYKS_ID_SEQ;
2368 CREATE TABLE hyks (
2369 id int PRIMARY KEY NOT NULL,
2370 river_id int NOT NULL,
2371 description VARCHAR(256) NOT NULL
2372 );
2373
2374 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ;
2375 CREATE TABLE hyk_entries (
2376 id int PRIMARY KEY NOT NULL,
2377 hyk_id int NOT NULL REFERENCES hyks(id),
2378 km NUMERIC NOT NULL,
2379 UNIQUE (hyk_id, km)
2380 );
2381
2382 CREATE SEQUENCE HYK_FORMATIONS_ID_SEQ;
2383 CREATE TABLE hyk_formations (
2384 id int PRIMARY KEY NOT NULL,
2385 formation_num int NOT NULL DEFAULT 0,
2386 hyk_entry_id int NOT NULL REFERENCES hyk_entries(id),
2387 top NUMERIC NOT NULL,
2388 bottom NUMERIC NOT NULL,
2389 UNIQUE (hyk_entry_id, formation_num)
2390 );
2391
2392 CREATE SEQUENCE HYK_FLOW_ZONE_TYPES_ID_SEQ;
2393 CREATE TABLE hyk_flow_zone_types (
2394 id int PRIMARY KEY NOT NULL,
2395 name VARCHAR(50) NOT NULL UNIQUE,
2396 description VARCHAR(256)
2397 );
2398
2399 CREATE SEQUENCE HYK_FLOW_ZONES_ID_SEQ;
2400 CREATE TABLE hyk_flow_zones (
2401 id int PRIMARY KEY NOT NULL,
2402 formation_id int NOT NULL REFERENCES hyk_formations(id),
2403 type_id int NOT NULL REFERENCES hyk_flow_zone_types(id),
2404 a NUMERIC NOT NULL,
2405 b NUMERIC NOT NULL,
2406 CHECK (a <= b)
2407 );
2408 COMMIT;
2409
2410 2011-07-13 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2411
2412 * pom.xml: Bumped Hibernate up to 3.6.5.
2413
2414 2011-07-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2415
2416 * src/main/java/de/intevation/flys/utils/FileTools.java: Argh!
2417 Forget to call the file hashing so only the file lengths were
2418 compared.
2419
2420 2011-07-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2421
2422 * src/main/java/de/intevation/flys/utils/FileTools.java:
2423 Added a class HashedFile to compare files by there length
2424 and a message digest. Digest can be set with system property
2425 "flys.backend.file.cmp.digest" and defaults to MD5. Useful to
2426 detect file duplicates.
2427
2428 * src/main/java/de/intevation/flys/importer/PRFParser.java: Added
2429 method prfAccept(File) to callback to check if a found PRF file
2430 should be parsed. Useful to prevent parsing file duplicates.
2431
2432 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
2433 Use the HashedFile and the PRFParser.Callback to prevent
2434 parsing of PRF duplicates.
2435
2436 2011-07-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2437
2438 * doc/schema/postgresql.sql: Misspelled sequence.
2439 To update existing databases:
2440
2441 DROP SEQUENCE CROSS_SECTION_LINES_SEQ;
2442 CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ;
2443
2444 * src/main/java/de/intevation/flys/importer/ImportCrossSection.java:
2445 Added some logging because importing is slow.
2446
2447 * src/main/java/de/intevation/flys/importer/ImportCrossSectionLine.java:
2448 Prevent NPE if a cross section line from db has no points.
2449
2450 2011-07-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2451
2452 Parse all PRFs in all subfolders of a river and store them
2453 as cross sections into the database. Needs testing!
2454
2455 * src/main/java/de/intevation/flys/importer/ImportCrossSection.java,
2456 src/main/java/de/intevation/flys/importer/ImportCrossSectionLine.java:
2457 New. Importer models for cross sections.
2458
2459 * src/main/java/de/intevation/flys/importer/XY.java:
2460 New. Made top level class from inner PRFParser.XY.
2461
2462 * src/main/java/de/intevation/flys/importer/PRFParser.java:
2463 Moved out XY class. Renamed callback.
2464
2465 * src/main/java/de/intevation/flys/model/CrossSection.java,
2466 src/main/java/de/intevation/flys/model/CrossSectionLine.java,
2467 src/main/java/de/intevation/flys/model/CrossSectionPoint.java,
2468 src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
2469 Added convinience constructors.
2470
2471 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
2472 Parse and store cross sections into database.
2473
2474 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2475
2476 * doc/schema/postgresql.sql: Introduced a new table cross_section_line
2477 holding the km of a set of points.
2478
2479 * src/main/java/de/intevation/flys/model/CrossSectionLine.java:
2480 New. Model for a single line of a "Querprofil".
2481
2482 * src/main/java/de/intevation/flys/model/CrossSection.java: Removed
2483 'km' and 'points' they are part of the line now.
2484
2485 * src/main/java/de/intevation/flys/model/CrossSectionPoint.java:
2486 They reference to the containing line now.
2487
2488 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2489 Registered new model.
2490
2491 To update existing databases:
2492 BEGIN;
2493 DROP SEQUENCE CROSS_SECTIONS_ID_SEQ;
2494 DROP SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
2495 DROP TABLE cross_section_points;
2496 DROP TABLE cross_sections;
2497 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ;
2498 CREATE TABLE cross_sections (
2499 id int PRIMARY KEY NOT NULL,
2500 river_id int NOT NULL REFERENCES rivers(id),
2501 time_interval_id int REFERENCES time_intervals(id),
2502 description VARCHAR(256)
2503 );
2504 CREATE SEQUENCE CROSS_SECTION_LINES_SEQ;
2505 CREATE TABLE cross_section_lines (
2506 id int PRIMARY KEY NOT NULL,
2507 km NUMERIC NOT NULL,
2508 cross_section_id int NOT NULL REFERENCES cross_sections(id),
2509 UNIQUE (km, cross_section_id)
2510 );
2511 CREATE SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
2512 CREATE TABLE cross_section_points (
2513 id int PRIMARY KEY NOT NULL,
2514 cross_section_line_id int NOT NULL REFERENCES cross_section_lines(id),
2515 col_pos int NOT NULL,
2516 x NUMERIC NOT NULL,
2517 y NUMERIC NOT NULL,
2518 UNIQUE (cross_section_line_id, col_pos)
2519 );
2520 COMMIT;
2521
2522 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2523
2524 * doc/schema/postgresql.sql: Dropped constraint that enforces the
2525 uniqueness of km and river. This is violated because there are
2526 more than one sounding in different year at the same km of a river.
2527 Added column 'description' to the cross section table to make it
2528 human readable.
2529
2530 To update existing databases:
2531
2532 ALTER TABLE cross_sections DROP CONSTRAINT cross_sections_km_key;
2533 ALTER TABLE cross_sections ADD COLUMN description VARCHAR(256);
2534
2535 * src/main/java/de/intevation/flys/model/CrossSection.java:
2536 Added the description column to the Hibernate model.
2537
2538 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2539
2540 * doc/schema/postgresql.sql: Dropped constraint that enforces the
2541 uniqueness of x in a "Querprofil-Spur". There are vertical lines
2542 in the soundings so this constraint is violated.
2543
2544 To update existing databases:
2545
2546 ALTER TABLE cross_section_points DROP CONSTRAINT cross_section_points_cross_section_id_key2;
2547
2548 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2549
2550 * src/main/java/de/intevation/flys/importer/PRFParser.java:
2551 Added a callback to be called from parsePRFs() if
2552 a PRF was parsed successfully. Useful to scan whole
2553 sub directories for PRF files.
2554
2555 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2556
2557 * src/main/java/de/intevation/flys/importer/PRFParser.java:
2558 Extract the year of sounding from file names. If not found
2559 from the name of th containing directory. Description is made
2560 of file name and parent directory file name.
2561
2562 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2563
2564 * src/main/java/de/intevation/flys/importer/PRFParser.java:
2565 Extracted the data. All BfG PRFs are parsed correctly, now.
2566
2567 2011-07-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2568
2569 * src/main/java/de/intevation/flys/importer/PRFParser.java:
2570 Extract km from lines. TODO: extract data.
2571
2572 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2573
2574 * src/main/java/de/intevation/flys/importer/PRFParser.java: New.
2575 Parser for PRF files. TODO extra data and station from data lines.
2576
2577 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2578
2579 * src/main/java/de/intevation/flys/model/Point3d.java: Deleted.
2580 Not needed (braindead).
2581
2582 * src/main/java/de/intevation/flys/model/CrossSectionPoint.java:
2583 Directly store the x/y values now.
2584
2585 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2586 Removed registration of Point3d.
2587
2588 To update existing databases:
2589
2590 BEGIN;
2591 ALTER TABLE cross_section_points DROP COLUMN point3d_id;
2592 DROP SEQUENCE POINTS3D_ID_SEQ;
2593 DROP TABLE points3d;
2594 ALTER TABLE cross_section_points ADD COLUMN x NUMERIC NOT NULL;
2595 ALTER TABLE cross_section_points ADD COLUMN y NUMERIC NOT NULL;
2596 ALTER TABLE cross_section_points ADD CONSTRAINT
2597 cross_section_points_cross_section_id_key2 UNIQUE (cross_section_id, x);
2598 COMMIT;
2599
2600 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2601
2602 * src/main/java/de/intevation/flys/model/CrossSection.java,
2603 src/main/java/de/intevation/flys/model/CrossSectionPoint.java:
2604 New. Hibernate models for cross-sections and their forming points.
2605
2606 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2607 Registered the new models.
2608
2609 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2610
2611 * src/main/java/de/intevation/flys/model/Point3d.java: New. point3d model
2612 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2613 Registered point3d model.
2614
2615 2011-07-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2616
2617 * doc/schema/postgresql.sql: Add relations for cross sections.
2618 To update existing databases:
2619 BEGIN;
2620
2621 CREATE SEQUENCE CROSS_SECTIONS_ID_SEQ;
2622 CREATE TABLE cross_sections (
2623 id int PRIMARY KEY NOT NULL,
2624 km NUMERIC NOT NULL,
2625 river_id int NOT NULL REFERENCES rivers(id),
2626 time_interval_id int REFERENCES time_intervals(id),
2627 UNIQUE (km, river_id)
2628 );
2629
2630 CREATE SEQUENCE POINTS3D_ID_SEQ;
2631 CREATE TABLE points3d (
2632 id int PRIMARY KEY NOT NULL,
2633 x NUMERIC NOT NULL,
2634 y NUMERIC NOT NULL,
2635 z NUMERIC NOT NULL
2636 );
2637
2638 CREATE SEQUENCE CROSS_SECTION_POINTS_ID_SEQ;
2639 CREATE TABLE cross_section_points (
2640 id int PRIMARY KEY NOT NULL,
2641 cross_section_id int NOT NULL REFERENCES cross_sections(id),
2642 point3d_id int NOT NULL REFERENCES points3d(id),
2643 col_pos int NOT NULL,
2644 UNIQUE (cross_section_id, point3d_id, col_pos),
2645 UNIQUE (cross_section_id, col_pos)
2646 );
2647
2648 COMMIT;
2649
2650 2011-06-28 Ingo Weinzierl <ingo@intevation.de>
2651
2652 Tagged RELEASE 2.4
2653
2654 2011-06-27 Ingo Weinzierl <ingo@intevation.de>
2655
2656 * Changes: Prepared changes for the upcoming release.
2657
2658 2011-06-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2659
2660 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java,
2661 src/main/java/de/intevation/flys/importer/AnnotationClassifier.java,
2662 src/main/java/de/intevation/flys/importer/AtFileParser.java,
2663 src/main/java/de/intevation/flys/importer/ValueKey.java,
2664 src/main/java/de/intevation/flys/importer/WstParser.java:
2665 Removed trailing whitespace.
2666
2667 2011-06-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2668
2669 * src/main/java/de/intevation/flys/importer/AnnotationClassifier.java:
2670 Removed superfluous imports.
2671
2672 2011-06-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2673
2674 * src/main/java/de/intevation/flys/model/River.java:
2675 Added a method maxOverlap to determine the gauge which has
2676 the max common length to a given interval. This is for
2677 numerical stability in slightly overlapping gauge ranges.
2678
2679 2011-06-26 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2680
2681 * src/main/java/de/intevation/flys/model/River.java: When
2682 looking up a gauge by km containment use precision of 1e-6.
2683
2684 2011-06-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2685
2686 * src/main/java/de/intevation/flys/model/River.java:
2687 Added method to find gauge by its name.
2688
2689 2011-06-19 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2690
2691 * doc/annotation-types.xml: Fixed some rules.
2692
2693 * src/main/java/de/intevation/flys/importer/Importer.java,
2694 src/main/java/de/intevation/flys/importer/InfoGewParser.java,
2695 src/main/java/de/intevation/flys/importer/ImportRiver.java:
2696 Call the right constructors now.
2697
2698 * src/main/java/de/intevation/flys/importer/ImportAnnotationType.java:
2699 Added getter/setter for name property.
2700
2701 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
2702 Print duplicated at WARN level not as DEBUG.
2703
2704 * src/main/java/de/intevation/flys/importer/AnnotationClassifier.java:
2705 Fixed XPath expression to build the internal lookup structures
2706 correctly.
2707
2708 2011-06-19 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2709
2710 Added classification of annotation types. Needs testing!
2711
2712 * doc/annotation-types.xml: New. Rules to classify the different
2713 types of annotations. The classification works like this:
2714
2715 There are unique types like 'Bruecke', 'Pegel' and so on.
2716 They are defined in the /annotation/type section and
2717 identified by their name. One of the types can be set
2718 as the default type if no rule applies.
2719
2720 In the /annotation/pattern section are two types of pattern.
2721
2722 1 - file pattern: If a KM file is opened its filename is
2723 matched against the regular expressions of these
2724 patterns. If a match is found the corresponding type
2725 is used as the default type in the open file.
2726 If no match is found the global default type is used
2727 as the default type.
2728
2729 2 - line patterns: For each line of an open KM file these
2730 patterns are applied to find a match. If a match is
2731 found the corresponding type is used as the type of
2732 the annotation. If no match is found the default
2733 file default is assumed to be the right type. For
2734 the file default see 1.
2735
2736 * src/main/java/de/intevation/flys/importer/Importer.java:
2737 To activate the annotation type classification set
2738 the system property
2739
2740 'flys.backend.importer.annotation.types'
2741
2742 to the path of a XML looking like the annotation-types.xml
2743 file. If the system property is not set no classification
2744 is done.
2745
2746 * src/main/java/de/intevation/flys/importer/AnnotationClassifier.java:
2747 New. Implements the classification.
2748
2749 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java,
2750 src/main/java/de/intevation/flys/importer/InfoGewParser.java,
2751 src/main/java/de/intevation/flys/importer/ImportRiver.java:
2752 Looped through the annotation type classification.
2753
2754 2011-06-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2755
2756 * src/main/java/de/intevation/flys/model/River.java:
2757 Added method to find gauge by a position lying in its range.
2758
2759 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2760
2761 First part of flys/issue18
2762
2763 * doc/schema/postgresql.sql: Add new table 'annotation_types'.
2764 To update existing databases:
2765 BEGIN;
2766 CREATE SEQUENCE ANNOTATION_TYPES_ID_SEQ;
2767 CREATE TABLE annotation_types (
2768 id int PRIMARY KEY NOT NULL,
2769 name VARCHAR(256) NOT NULL UNIQUE
2770 );
2771 ALTER TABLE annotations ADD COLUMN type_id int REFERENCES annotation_types(id);
2772 COMMIT;
2773
2774 * doc/schema/postgresql-cleanup.sql: Removed. Hopeless out-dated.
2775
2776 * src/main/java/de/intevation/flys/model/AnnotationType.java:
2777 New. Hibernate model to access the type.
2778
2779 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2780 Register the new backend type.
2781
2782 * src/main/java/de/intevation/flys/model/Annotation.java:
2783 References the annotation type.
2784
2785 * src/main/java/de/intevation/flys/importer/ImportAnnotationType.java:
2786 New. Model to help import the annotation type.
2787
2788 * src/main/java/de/intevation/flys/importer/ImportAnnotation.java:
2789 Uses the import type.
2790
2791 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
2792 Set the annotation type to 'null'. TODO: Do the classification!
2793
2794 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2795
2796 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
2797 Fix for flys/issue110. start index was shifted by one.
2798
2799 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2800
2801 * src/main/java/de/intevation/flys/importer/ImportAnnotation.java:
2802 Forgot to store reference to edge.
2803
2804 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2805
2806 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
2807 Register backend model.
2808
2809 * src/main/java/de/intevation/flys/importer/ImportEdge.java: New. Model
2810 for importing the edges.
2811
2812 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
2813 Parses the edges of an annotation, too.
2814
2815 2011-06-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2816
2817 * doc/schema/postgresql.sql: Added table edges to model 'Kanten' of an annotation.
2818 To update existing databases:
2819 BEGIN;
2820 CREATE SEQUENCE EDGES_ID_SEQ;
2821 CREATE TABLE edges (
2822 id int PRIMARY KEY NOT NULL,
2823 top NUMERIC,
2824 bottom NUMERIC);
2825 ALTER TABLE annotations ADD COLUMN edge_id int REFERENCES edges(id);
2826 COMMIT;
2827
2828 * src/main/java/de/intevation/flys/model/Edge.java: New. A 'Kanten'-Model.
2829 * src/main/java/de/intevation/flys/model/Annotation.java: References the
2830 edges.
2831
2832 2011-06-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2833
2834 * src/main/java/de/intevation/flys/model/River.java:
2835 Added method to find gauge only by station position.
2836
2837 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2838
2839 * src/main/java/de/intevation/flys/model/River.java:
2840 Make search for gauges independent of from/to order.
2841
2842 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2843
2844 * doc/schema/postgresql.sql: Added a new view to select qs of a WST.
2845 To update existing databases:
2846
2847 CREATE VIEW wst_q_values AS
2848 SELECT wc.position AS column_pos,
2849 wqr.q AS q,
2850 r.a AS a,
2851 r.b AS b,
2852 wc.wst_id AS wst_id
2853 FROM wst_column_q_ranges wcqr
2854 JOIN wst_q_ranges wqr ON wcqr.wst_q_range_id = wqr.id
2855 JOIN ranges r ON wqr.range_id = r.id
2856 JOIN wst_columns wc ON wcqr.wst_column_id = wc.id
2857 ORDER BY wc.position, wcqr.wst_column_id, r.a;
2858
2859 2011-05-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2860
2861 * doc/schema/postgresql.sql: Added a new view to select ws of a WST.
2862 To update existing databases:
2863
2864 CREATE VIEW wst_w_values AS
2865 SELECT wcv."position" AS km,
2866 wcv.w AS w,
2867 wc."position" AS column_pos,
2868 w.id AS wst_id
2869 FROM wst_column_values wcv
2870 JOIN wst_columns wc ON wcv.wst_column_id = wc.id
2871 JOIN wsts w ON wc.wst_id = w.id
2872 ORDER BY wcv."position", wc."position";
2873
2874 2011-05-23 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2875
2876 flys/issue76
2877
2878 * src/main/java/de/intevation/flys/importer/WstParser.java:
2879 Close gaps between q ranges.
2880
2881 2011-05-20 Ingo Weinzierl <ingo@intevation.de>
2882
2883 Tagged RELEASE 2.3.1
2884
2885 2011-05-13 Ingo Weinzierl <ingo@intevation.de>
2886
2887 Tagged RELEASE 2.3
2888
2889 2011-05-13 Ingo Weinzierl <ingo@intevation.de>
2890
2891 * Changes: Changes for release 2.3 - see Changes file to get to know about
2892 the version numbers of this software.
2893
2894 2011-05-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2895
2896 * doc/schema/postgresql.sql: Added a column which tells
2897 if a river counts its km up or downwards.
2898 To update existing databases:
2899
2900 ALTER TABLE rivers ADD COLUMN km_up BOOLEAN NOT NULL DEFAULT true;
2901
2902 * src/main/java/de/intevation/flys/model/River.java:
2903 Adjust Hibernate mapping of new column.
2904
2905 2011-05-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2906
2907 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
2908 Fixed flys/issue11 and flys51.
2909
2910 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2911
2912 * src/main/java/de/intevation/flys/importer/ValueKey.java:
2913 Add some unsharp comparison (eps = 1e-6) to avoid
2914 numerical problems.
2915
2916 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
2917 Removed. Not need any longer.
2918
2919 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
2920 Use unsharp lookup.
2921
2922 * src/main/java/de/intevation/flys/importer/ImportWst.java,
2923 src/main/java/de/intevation/flys/importer/ImportRiver.java:
2924 Flush more often. Hopefully this reduces hibernate sync
2925 problems?!
2926
2927 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2928
2929 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
2930 Fixed silly bug. Set flush mode back to auto because
2931 manual flushing causes some undetermined problems.
2932
2933 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2934
2935 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
2936 Do not load _all_ values from discharge tables and
2937 wst columns. This is extremly slow and will lead
2938 to OOM if more rivers are imported. Now only the
2939 last 20 columns und discharge tables are cached.
2940
2941 * src/main/java/de/intevation/flys/importer/ValueKey.java:
2942 New. Key for caching discharge table values and wst
2943 column values.
2944
2945 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
2946 Fixed bug in equals().
2947
2948 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
2949 Removed too eloquent debug output.
2950
2951 2011-05-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2952
2953 * src/main/java/de/intevation/flys/importer/IdValueKey.java:
2954 Use BigDecimals as representation for the numeric components
2955 which prevents running into unique constraint problems
2956 caused by imprecision.
2957
2958 * src/main/java/de/intevation/flys/importer/ImportRange.java,
2959 src/main/java/de/intevation/flys/importer/ImporterSession.java:
2960 Ranges are now cached globally, too.
2961
2962 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
2963 Improved logging.
2964
2965 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java:
2966 Removed superfluous imports.
2967
2968 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2969
2970 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
2971 Only accept main value types 'Q', 'W', 'D' and 'T' by default.
2972 '-' is not handled any more because it causes too much constraint
2973 problems. You can overwrite the imported type with the
2974 system property flys.backend.main.value.types" (default "QWTD")
2975
2976 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
2977 Set session flush mode to manual. Hopefully this improves the
2978 performance a bit.
2979
2980 * src/main/java/de/intevation/flys/importer/ImportWst.java,
2981 src/main/java/de/intevation/flys/importer/ImportGauge.java,
2982 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
2983 src/main/java/de/intevation/flys/importer/ImportRange.java,
2984 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
2985 Improved logging.
2986
2987 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
2988
2989 * src/main/java/de/intevation/flys/importer/WstColumnValueKey.java: Deleted
2990 * src/main/java/de/intevation/flys/importer/IdValueKey.java: Reinserted
2991 here in a more generalized form.
2992
2993 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
2994 Cache the discharge table value, too.
2995
2996 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java:
2997 Use the global cache.
2998
2999 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3000
3001 * src/main/java/de/intevation/flys/importer/ImporterSession.java:
3002 New. Centralized caching in the thread local context. Importing
3003 the Elbe leads to OOM because the column values of the
3004 WST files where loaded separately for every file.
3005
3006 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
3007 src/main/java/de/intevation/flys/importer/Importer.java,
3008 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
3009 src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
3010 src/main/java/de/intevation/flys/importer/ImportWst.java,
3011 src/main/java/de/intevation/flys/importer/ImportMainValue.java,
3012 src/main/java/de/intevation/flys/importer/ImportMainValueType.java,
3013 src/main/java/de/intevation/flys/importer/ImportNamedMainValue.java,
3014 src/main/java/de/intevation/flys/importer/ImportRiver.java,
3015 src/main/java/de/intevation/flys/importer/ImportGauge.java,
3016 src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java,
3017 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
3018 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
3019 src/main/java/de/intevation/flys/importer/ImportRange.java,
3020 src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java,
3021 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java,
3022 src/main/java/de/intevation/flys/importer/ImportAttribute.java,
3023 src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
3024 Adjusted to use the new global context.
3025
3026 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3027
3028 * doc/schema/postgresql.sql: Dropped constraint which
3029 forces discharge tables to have a unique time interval
3030 for a given gauge and kind.
3031
3032 There are AT files (historical Mosel/Perl/Perl/1967-1981.at
3033 and Mosel/Perl/1967-1981-1.at) which violate this
3034 constraint. Its a technical question to the customer
3035 how to handle these cases.
3036
3037 To adjust existing databases:
3038
3039 ALTER TABLE discharge_tables DROP CONSTRAINT discharge_tables_gauge_id_key;
3040
3041 2011-05-08 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3042
3043 * src/main/java/de/intevation/flys/importer/WstParser.java:
3044 There are wst files where column names are not unique.
3045 Make them unique by appending (1), (2) and so on.
3046
3047 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3048
3049 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3050 Import the "HW-Schutzanlagen", too.
3051
3052 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3053
3054 Make import of historical discharge tables work.
3055
3056 * doc/schema/postgresql.sql: Added forgotten column 'description'.
3057
3058 !!! You have to drop your database !!!
3059
3060 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
3061 src/main/java/de/intevation/flys/model/DischargeTable.java:
3062 Add the forgotten description property.
3063
3064 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
3065 Fixed problems with date recognition.
3066
3067 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
3068 Prefix the description of the historical discharge tables
3069 with "Histor.Abflusstafeln".
3070
3071 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
3072 Fixed silly programming error.
3073
3074 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3075
3076 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
3077 Inject 'kind' attribute.
3078
3079 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
3080 Traverse the "Histor.Abflusstafeln" for the historical
3081 discharge tables. too. TODO: Store them in the database.
3082
3083 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
3084 Added convinience constructor to set the kind of the
3085 discharge table.
3086
3087 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3088
3089 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3090 Prefix "Zusätzliche Längsschnitte" with "Zus.Längsschnitte"
3091 in description.
3092
3093 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3094
3095 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3096 Import 'Hochwasser-Marken', too.
3097
3098 * src/main/java/de/intevation/flys/importer/WstParser.java:
3099 Removed superfluous import.
3100
3101 2011-05-05 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3102
3103 * src/main/java/de/intevation/flys/importer/WstParser.java:
3104 Ignore lines that contain km positions which were found
3105 before in the same file.
3106
3107 2011-05-05 Ingo Weinzierl <ingo@intevation.de>
3108
3109 * src/main/java/de/intevation/flys/model/River.java: Added a method that
3110 returns all gauges of the river intersected by a given start and end
3111 point.
3112
3113 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3114
3115 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
3116 Forgot to fetch peer from result set.
3117
3118 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3119
3120 * src/main/java/de/intevation/flys/importer/ImportTimeInterval.java:
3121 New. Importer model help fetching the database peer.
3122
3123 * src/main/java/de/intevation/flys/model/TimeInterval.java:
3124 Add convinience constructor with start and stop time.
3125
3126 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
3127 Attach a time interval to a discharge table if we find one.
3128
3129 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
3130 Store the reference to the importer model of the
3131 time interval of the discharge table.
3132
3133 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3134
3135 * src/main/java/de/intevation/flys/importer/AtFileParser.java:
3136 Try to extract time ranges from at files.
3137
3138 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3139
3140 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3141 Parse and store "amtliche Linien" wst files.
3142
3143 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3144
3145 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3146 Parse and store fixation wst files as well.
3147
3148 2011-05-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3149
3150 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3151 Parse the "zusaetzliche Laengsschnitte", too.
3152
3153 * src/main/java/de/intevation/flys/importer/ImportWst.java:
3154 Add getter/setter for column 'kind'.
3155
3156 2011-05-02 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3157
3158 * src/main/java/de/intevation/flys/importer/WstParser.java:
3159 Fixed flys/issue19: Do not take km column in wst file as a water level.
3160
3161 2011-05-02 Ingo Weinzierl <ingo@intevation.de>
3162
3163 * src/main/java/de/intevation/flys/model/Gauge.java: Introduced a 'scale'
3164 that is used to adjust the range of min/max W values.
3165
3166 2011-05-01 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3167
3168 * src/main/java/de/intevation/flys/importer/WstParser.java:
3169 Removed superfluous import.
3170
3171 2011-04-20 Ingo Weinzierl <ingo@intevation.de>
3172
3173 * src/main/java/de/intevation/flys/importer/WstColumnValueKey.java:
3174 New. This class is used as distinct key of a WstColumnValue - e.g. as
3175 key in a map.
3176
3177 * src/main/java/de/intevation/flys/importer/ImportWst.java: A
3178 WstColumnValue cache is build up while initialization. This cache
3179 contains all WstColumnValues that exist in the database.
3180
3181 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java: New
3182 constructor that takes the WstColumnValues cache. It is used to
3183 initialize new ImportWstColumnValue objects.
3184
3185 * src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java:
3186 Speedup: A ImportWstColumnValue has a WstColumnValues cache that
3187 contains all WstColumnValues existing in the database. This makes it
3188 unnecessary to call an sql statement for each WstColumnValue to
3189 determine its existence in the database.
3190
3191 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3192
3193 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
3194 Added a view 'wst_value_table' which aggregates the data
3195 to build w/q value tables.
3196
3197 To update existing databases:
3198
3199 BEGIN;
3200 CREATE VIEW wst_value_table AS
3201 SELECT wcv.position AS position,
3202 w,
3203 (SELECT q
3204 FROM wst_column_q_ranges wcqr
3205 JOIN wst_q_ranges wqr
3206 ON wcqr.wst_q_range_id = wqr.id
3207 JOIN ranges r
3208 ON r.id = wqr.range_id
3209 WHERE wcqr.wst_column_id = wc.id
3210 AND wcv.position BETWEEN r.a AND r.b) AS q,
3211 wc.position AS column_pos,
3212 w.id AS wst_id
3213 FROM wst_column_values wcv
3214 JOIN wst_columns wc
3215 ON wcv.wst_column_id = wc.id
3216 JOIN wsts w
3217 ON wc.wst_id = w.id
3218 ORDER BY wcv.position ASC,
3219 wc.position DESC;
3220 COMMIT;
3221
3222 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3223
3224 * src/main/java/de/intevation/flys/model/Wst.java:
3225 Add forgotten one to many relation Wst -> WstColumn.
3226
3227 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3228
3229 * src/main/java/de/intevation/flys/importer/ImportWst.java,
3230 src/main/java/de/intevation/flys/importer/WstParser.java:
3231 Import of q ranges of wst files was totally broken. :-/
3232 You have to reimport all your data.
3233
3234 2011-04-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3235
3236 * src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
3237 Forgot kind parameter in peer fetching query.
3238
3239 2011-04-18 Ingo Weinzierl <ingo@intevation.de>
3240
3241 * src/main/java/de/intevation/flys/model/River.java::
3242 Added a new method to determine the gauge based on a given start and end
3243 point of the river.
3244
3245 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3246
3247 * doc/schema/postgresql.sql: Added 'position' column to wst_columns
3248 to allow order them by there column position in the original
3249 wst file.
3250
3251 Update existing database with:
3252
3253 BEGIN;
3254 ALTER TABLE wst_columns ADD COLUMN position int;
3255 UPDATE wst_columns w SET
3256 position = id - (SELECT min(id) FROM wst_columns WHERE wst_id = w.wst_id);
3257 ALTER TABLE wst_columns ADD CONSTRAINT wst_columns_wst_id_position_key
3258 UNIQUE (wst_id, position);
3259 COMMIT;
3260
3261 * src/main/java/de/intevation/flys/model/Wst.java,
3262 src/main/java/de/intevation/flys/model/WstColumn.java:
3263 Adjusted models.
3264
3265 * src/main/java/de/intevation/flys/importer/ImportWst.java,
3266 src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
3267 Adjusted importer.
3268
3269 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3270
3271 * doc/schema/postgresql.sql: Forget ',' in schema.
3272
3273 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3274
3275 * src/main/java/de/intevation/flys/model/Wst.java (determineMinMaxQ):
3276 Fixed index problem when an empty list is returned.
3277
3278 2011-04-15 Ingo Weinzierl <ingo@intevation.de>
3279
3280 * src/main/java/de/intevation/flys/model/Wst.java: A Wst is now able to
3281 return its min and max Q values.
3282
3283 * src/main/java/de/intevation/flys/model/Gauge.java: A Gauge is now able
3284 to return its min and max W values.
3285
3286 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3287
3288 * doc/schema/postgresql.sql: Added new column 'kind' in
3289 discharge tables and wst to distinguish between different
3290 kinds like 'Haupt-WST', 'zusaetzliche Laengsschnitte',
3291 'amtliche Daten' and so on.
3292
3293 Update existing databases with:
3294 BEGIN;
3295 ALTER TABLE discharge_tables ADD COLUMN kind int NOT NULL DEFAULT 0;
3296 ALTER TABLE wsts ADD COLUMN kind int NOT NULL DEFAULT 0;
3297 COMMIT;
3298
3299 * src/main/java/de/intevation/flys/model/DischargeTable.java
3300 src/main/java/de/intevation/flys/model/Wst.java,
3301 src/main/java/de/intevation/flys/importer/ImportWst.java,
3302 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java:
3303 Adjusted the models.
3304
3305 2011-04-15 Ingo Weinzierl <ingo@intevation.de>
3306
3307 * src/main/java/de/intevation/flys/backend/SessionHolder.java: Moved to
3308 this module from flys-artifacts. This is necessary to get access to the
3309 current session in this module as well.
3310
3311 2011-04-14 Ingo Weinzierl <ingo@intevation.de>
3312
3313 * src/main/java/de/intevation/flys/model/River.java: Added a method that
3314 returns the min and max distance of a river.
3315
3316 2011-04-03 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3317
3318 * src/**/*.java: Removed trailing whitespace.
3319
3320 2011-03-30 Ingo Weinzierl <ingo@intevation.de>
3321
3322 Tagged RELEASE 0.1
3323
3324 2011-03-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3325
3326 * src/main/java/de/intevation/flys/model/Range.java:
3327 Forgot to save the last change before commit.
3328
3329 2011-03-28 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3330
3331 * src/main/java/de/intevation/flys/model/Range.java:
3332 Added methods to find out if two ranges intersects.
3333
3334 2011-03-24 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3335
3336 * src/main/java/de/intevation/flys/model/Gauge.java:
3337 Added an one to many relation to the discharge tables of a gauge.
3338
3339 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3340
3341 Finished import of WSTs.
3342
3343 TODO 1: Speed it up! It takes on a high end machine over 7(!)
3344 minutes only for the data of the Saar.
3345 TODO 2: Double precision floating point representations produced
3346 by the the parsers leed to unique constraint violations
3347 in the backend on a second run. So the import is currently
3348 only working on freshly initialized data bases.
3349 More consequent working with BigDecimal and some
3350 rounding may be of help here.
3351
3352 * src/main/java/de/intevation/flys/model/WstColumnValue.java:
3353 Added convinience constructors.
3354
3355 * src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java:
3356 Added getPeer() method.
3357
3358 * src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
3359 Add a list of the ImportWstColumnValues produced by the WST parser.
3360
3361 * src/main/java/de/intevation/flys/importer/WstParser.java: Add
3362 the (km, w) values to the ImportWstColumns.
3363
3364 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3365
3366 * src/main/java/de/intevation/flys/importer/WstParser.java:
3367 Build models for wsts, wst columns and q ranges and
3368 store them in the backend. TODO: store the w values.
3369
3370 * src/main/java/de/intevation/flys/model/WstQRange.java
3371 src/main/java/de/intevation/flys/model/Wst.java,
3372 src/main/java/de/intevation/flys/model/Range.java,
3373 src/main/java/de/intevation/flys/model/WstColumnQRange.java,
3374 src/main/java/de/intevation/flys/model/WstColumn.java:
3375 Added convinience constructors.
3376
3377 * src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
3378 src/main/java/de/intevation/flys/importer/ImportWst.java,
3379 src/main/java/de/intevation/flys/importer/ImportRiver.java,
3380 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
3381 src/main/java/de/intevation/flys/importer/ImportWstColumn.java,
3382 src/main/java/de/intevation/flys/importer/ImportRange.java:
3383 Added getPeer() methods.
3384
3385 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3386
3387 * src/main/java/de/intevation/flys/importer/WstParser.java:
3388 The unit extraction in the WST parser of desktop FLYS
3389 is broken! Add a hack here to repair this for our
3390 importer. Desktop FLYS needs a fix, too!
3391
3392 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3393
3394 * src/main/java/de/intevation/flys/importer/WstParser.java:
3395 Ported some stuff ver from WSTSource.java of desktop flys to
3396 parse WST files. TODO: create instances of the import models.
3397
3398 * src/main/java/de/intevation/flys/utils/StringUtil.java:
3399 Copied from desktop flys. Used for some string operations
3400 in WST parser.
3401
3402 * src/main/java/de/intevation/flys/importer/Importer.java:
3403 Added system property 'flys.backend.importer.dry.run'.
3404 Set to true only the parsing is done and no writing
3405 to the backend. Default: false.
3406
3407 * src/main/java/de/intevation/flys/App.java,
3408 src/main/java/de/intevation/flys/model/MainValueType.java:
3409 Removed needless imports.
3410
3411 2011-03-22 Ingo Weinzierl <ingo@intevation.de>
3412
3413 * src/main/java/de/intevation/flys/model/DischargeTableValue.java,
3414 src/main/java/de/intevation/flys/model/DischargeTable.java: Added new
3415 constructors.
3416
3417 * src/main/java/de/intevation/flys/importer/AtFileParser.java: New. This
3418 parser is used to '*.at' files.
3419
3420 * src/main/java/de/intevation/flys/importer/ImportGauge.java: Added code to
3421 import discharge tables.
3422
3423 * src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java,
3424 src/main/java/de/intevation/flys/importer/ImportDischargeTable.java: New.
3425 Helper models for import discharge tables.
3426
3427 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3428
3429 * src/main/java/de/intevation/flys/importer/WstParser.java,
3430 src/main/java/de/intevation/flys/importer/ImportRiver.java:
3431 Added stub for WST parser.
3432
3433 2011-03-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3434
3435 * src/main/java/de/intevation/flys/importer/ImportWstQRange.java,
3436 src/main/java/de/intevation/flys/importer/ImportWst.java,
3437 src/main/java/de/intevation/flys/importer/ImportWstColumnValue.java,
3438 src/main/java/de/intevation/flys/importer/ImportWstColumnQRange.java,
3439 src/main/java/de/intevation/flys/importer/ImportWstColumn.java:
3440 Added importer helper model stubs for WST imports.
3441
3442 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3443
3444 Second part of parsing/storing main values. Should be finished now.
3445
3446 * src/main/java/de/intevation/flys/importer/ImportNamedMainValue.java,
3447 src/main/java/de/intevation/flys/importer/ImportMainValue.java:
3448 New. Helper models for import main values,
3449
3450 * src/main/java/de/intevation/flys/model/MainValue.java,
3451 src/main/java/de/intevation/flys/model/NamedMainValue.java:
3452 Added convinience constructors.
3453
3454 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
3455 Write main values to backend, too.
3456
3457 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
3458 Build importer models for main values.
3459
3460 * src/main/java/de/intevation/flys/importer/ImportMainValueType.java:
3461 Data was called 'value'. Now it is 'name' to fit the
3462 schema.
3463
3464 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3465
3466 * doc/schema/postgresql.sql: Fixed wrong unique constraint.
3467
3468 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3469 Added some logging when storing gauges.
3470
3471 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3472
3473 * src/main/java/de/intevation/flys/model/Gauge.java:
3474 Add forgotten column river_id.
3475
3476 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
3477 Small HQL fix.
3478
3479 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3480
3481 * src/main/java/de/intevation/flys/model/Gauge.java:
3482 Added convinience contructor.
3483
3484 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
3485 Fixed getPeer() method.
3486
3487 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
3488 Fixed parsing of STA files.
3489
3490 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3491
3492 * src/main/java/de/intevation/flys/importer/ImportRiver.java,
3493 src/main/java/de/intevation/flys/importer/ImportGauge.java:
3494 Propagate river into storing of gauges.
3495
3496 2011-03-21 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3497
3498 * src/main/java/de/intevation/flys/importer/Importer.java:
3499 Added code to store rivers not only annotations.
3500
3501 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3502 Added stub code to write gauges.
3503
3504 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3505
3506 First part of parsing main values.
3507
3508 * src/main/java/de/intevation/flys/App.java: Commented out
3509 creation of dummy rivers.
3510
3511 * src/main/java/de/intevation/flys/model/NamedMainValues.java:
3512 Moved to NamedMainValue.
3513
3514 * src/main/java/de/intevation/flys/model/NamedMainValue.java:
3515 New. Formerly NamedMainValues.
3516
3517 * src/main/java/de/intevation/flys/model/MainValue.java:
3518 New. Forgotten part of the model.
3519
3520 * src/main/java/de/intevation/flys/model/MainValueType.java:
3521 Data is String not BigDecimal
3522
3523 * src/main/java/de/intevation/flys/model/Range.java: Removed
3524 contructor with double arguments. Using BigDecimal now.
3525
3526 * src/main/java/de/intevation/flys/importer/PegelGltParser.java:
3527 Propagate BigDecimal usage.
3528
3529 * src/main/java/de/intevation/flys/importer/Importer.java:
3530 Removed needless import. Added TODO
3531
3532 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3533 Parse the dependencies of the gauges, too.
3534
3535 * src/main/java/de/intevation/flys/importer/StaFileParser.java:
3536 New. Parser for STA files.
3537
3538 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
3539 Call STA file parser.
3540
3541 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java,
3542 src/main/java/de/intevation/flys/importer/ImportRange.java:
3543 Uses BigDecimal now.
3544
3545 * src/main/java/de/intevation/flys/importer/ImportAttribute.java:
3546 Fixed wrong type cast in equals.
3547
3548 * src/main/java/de/intevation/flys/importer/ImportMainValueType.java:
3549 New. Helper model for importing main value types.
3550
3551 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
3552 Register forgotten MainValue model.
3553
3554 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3555
3556 Store annotations in backend.
3557
3558 * src/main/java/de/intevation/flys/model/Annotation.java:
3559 New convinience constructor.
3560
3561 * src/main/java/de/intevation/flys/model/River.java:
3562 Added toString() method.
3563
3564 * src/main/java/de/intevation/flys/model/Range.java:
3565 Fixed nasty mistake in @OneToOne annotatation.
3566 New convinience constructors.
3567
3568 * src/main/java/de/intevation/flys/importer/ImportPosition.java
3569 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
3570 src/main/java/de/intevation/flys/importer/ImportRange.java
3571 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
3572 Make storing to backend work. It's a bit too slow. :-/
3573
3574 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3575 Fetch peer from backend. Added method to store annotations.
3576 * src/main/java/de/intevation/flys/importer/Importer.java:
3577 Stored annotations into backend. More eloquent SQL exception
3578 handling.
3579
3580 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3581
3582 * src/main/java/de/intevation/flys/model/Attribute.java,
3583 src/main/java/de/intevation/flys/model/Position.java:
3584 Added convinience constructors.
3585
3586 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
3587 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
3588 Bound them to there backend peers.
3589
3590 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3591
3592 * src/main/java/de/intevation/flys/importer/AnnotationsParser.java:
3593 New. Added parser to read *.KM files.
3594
3595 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
3596 src/main/java/de/intevation/flys/importer/PegelGltParser.java,
3597 src/main/java/de/intevation/flys/importer/ImportRiver.java,
3598 src/main/java/de/intevation/flys/importer/ImportAnnotation.java,
3599 src/main/java/de/intevation/flys/importer/ImportRange.java,
3600 src/main/java/de/intevation/flys/importer/InfoGewParser.java,
3601 src/main/java/de/intevation/flys/importer/ImportAttribute.java:
3602 Adjusted to load the annotations from *.KM files.
3603
3604 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3605
3606 * src/main/java/de/intevation/flys/importer/ImportPosition.java,
3607 src/main/java/de/intevation/flys/importer/ImportRange.java,
3608 src/main/java/de/intevation/flys/importer/ImportAttribute.java,
3609 src/main/java/de/intevation/flys/importer/ImportAnnotation.java:
3610 New helper models for import.
3611
3612 * src/main/java/de/intevation/flys/importer/PegelGltParser.java,
3613 src/main/java/de/intevation/flys/importer/ImportGauge.java:
3614 Use new models.
3615
3616 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3617
3618 * src/main/java/de/intevation/flys/importer/PegelGltParser.java:
3619 New. Parser for PEGEL.GLT files.
3620
3621 * src/main/java/de/intevation/flys/importer/ImportGauge.java:
3622 New. Import model for gauges.
3623
3624 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
3625 Removed needless imports.
3626
3627 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3628 Added method to parse the gauges.
3629
3630 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
3631 Trigger pegel glt file parsing.
3632
3633 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3634
3635 * src/main/java/de/intevation/flys/importer/Importer.java:
3636 Used thread local pattern to make sharing of session easier.
3637
3638 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3639
3640 * src/main/java/de/intevation/flys/importer/Importer.java:
3641 Fixed error in HQL statement.
3642
3643 2011-03-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3644
3645 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
3646 Commented out a debug block because it leaks the db password.
3647
3648 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3649
3650 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
3651 Expose imported rivers.
3652
3653 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
3654 Store imported rivers into database. Needs testing!
3655
3656 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3657
3658 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
3659 Default connection parameters are now overwritable with
3660 system properties (defaults in brackets):
3661 - user name: flys.backend.user (flys)
3662 - user password: flys.backend.password (flys)
3663 - db dialect: flys.backend.dialect (org.hibernate.dialect.PostgreSQLDialect)
3664 - db driver: flys.backend.driver (org.postgresql.Driver)
3665 - db url: flys.backend.url (jdbc:postgresql://localhost:5432/flys)
3666
3667 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3668
3669 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
3670 Expose createSessionFactory() as public to be usable without
3671 a artifact database running.
3672
3673 2011-03-16 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3674
3675 * src/main/java/de/intevation/flys/utils/FileTools.java:
3676 Tools for handling with filenames. Currently there is
3677 a repair(File) method with repairs letter case errors
3678 which is useful when reading windows filenames on a
3679 un*x platform.
3680
3681 * src/main/java/de/intevation/flys/importer/Importer.java:
3682 Standalone app to read data from the file system and
3683 store it in a database. Currently it does not store
3684 anything. It only loads info gew files.
3685
3686 * src/main/java/de/intevation/flys/importer/InfoGewParser.java:
3687 Info gew parser.
3688
3689 * src/main/java/de/intevation/flys/importer/ImportRiver.java:
3690 Helper model of a river used produced by parsing the
3691 info gew files.
3692
3693 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3694
3695 * src/main/java/de/intevation/flys/backend/SessionFactoryProvider.java:
3696 New. SessionFactoryProvider.getSessionFactory() provides a
3697 SessionFactory to use the Hibernate O/R mapper for the FLYS backend.
3698
3699 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3700
3701 * pom.xml: Added dependency to artifacts-commons to
3702 be able to use the global configuration of the artifact database.
3703
3704 2011-03-15 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3705
3706 * src/main/java/de/intevation/flys/App.java: Wire all POJOs
3707 to corresponding factory.
3708
3709 * src/main/java/de/intevation/flys/model/*.java: Generate
3710 all foreign key constraints. TODO: name them correctly
3711 because the machine generated names are ugly and do
3712 not fit the PostgreSQL names.
3713
3714 * doc/schema/postgresql.sql: Small quantifier fix in descriptions
3715 of wst columns.
3716
3717 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3718
3719 * doc/schema/postgresql.sql: Fixed wrong spelled
3720 column references in foreign keys introduces with
3721 last change.
3722
3723 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3724
3725 * src/main/java/de/intevation/flys/model/*.java: Added
3726 column annotations for simple fields. TODO: foreign keys.
3727
3728 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3729
3730 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
3731 Fixed inconsistent table names.
3732
3733 * src/main/java/de/intevation/flys/model/*.java: Added
3734 entity and id annotations.
3735
3736 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3737
3738 * doc/schema/postgresql.sql, doc/schema/postgresql-cleanup.sql:
3739 Added missing sequences.
3740
3741 * doc/schema/sqlite.sql: Deleted. Not longer supported.
3742
3743 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3744
3745 * doc/schema/postgresql-cleanup.sql: Forgot to add.
3746
3747 * src/main/java/de/intevation/flys/App.java: Use
3748 Apache Commons DBCP as Hibernate connection provide.
3749
3750 * src/main/java/de/intevation/flys/model/River.java:
3751 Added a constructor with string argument. Set the
3752 sequence increment to 1 (eat up 100 at a time before).
3753
3754 * pom.xml: Added PostgreSQL 8.4 driver as runtime dependency.
3755
3756 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3757
3758 * doc/schema/postgresql-cleanup.sql: New. Tear down schema
3759 for a postgres database.
3760
3761 * doc/schema/postgresql.sql: Added squence for
3762 auto generating ids in river table. Cleaned up schema.
3763
3764 * src/main/java/de/intevation/flys/App.java: Simple
3765 test app to interact with hibernate. Needs to be removed
3766 because its only a toy.
3767
3768 * src/main/java/de/intevation/flys/utils/DBCPConnectionProvider.java:
3769 New. Binds Apache Commons to Hibernate.
3770
3771 * pom.xml: Added dependencies to log4j, commons dbcp,
3772 JPA of hibernate.
3773
3774 * src/main/java/de/intevation/flys/model/River.java: Added
3775 JPA annotations.
3776
3777 * src/main/java/de/intevation/flys/model/*.java: Replaced
3778 Long with Integer because column ids are only four bytes wide.
3779
3780 2011-03-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3781
3782 * doc/schema/sqlite.sql, doc/schema/postgresql.sql: Fixed
3783 smaller issues in ddl.
3784
3785 * src/main/java/de/intevation/flys/model/*.java: Added POJOs
3786 of to be mapped. TODO: Map them!
3787
3788 * pom.xml: Added plugin config for hibernate.
3789
3790 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3791
3792 * pom.xml: Added dependency (and corresponding repository) to
3793 Hibernate Core 3.6.1 Final
3794
3795 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3796
3797 * pom.xml, src/**: Created a new empty maven project:
3798 $ mvn archetype:create \
3799 -DgroupId=de.intevation.flys \
3800 -DartifactId=flys-backend
3801
3802 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3803
3804 * README: New. Some setup instructions.
3805
3806 * doc/schema/postgresql.sql: New. Schema converted to PostgreSQL
3807
3808 * doc/schema/sqlite.sql: Fixed defect foreign key constraints.
3809
3810 2011-03-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3811
3812 * doc/schema/sqlite.sql: Factorized time intervals out into
3813 a separated table.
3814
3815 2011-01-22 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3816
3817 * contrib/import-kms.py, contrib/import-gew.py: Initial scripts
3818 to import data into SQLite database. They still need some work.
3819
3820 2011-02-10 Sascha L. Teichmann <sascha.teichmann@intevation.de>:
3821
3822 * doc/schema/sqlite.sql: Added initial schema for
3823 FLYS database.
http://dive4elements.wald.intevation.org