comparison flys-backend/ChangeLog @ 3800:69d19995bc3c 2.9.1

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

http://dive4elements.wald.intevation.org