comparison flys-backend/ChangeLog @ 3689:c938e568c4a2 2.9

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

http://dive4elements.wald.intevation.org