Mercurial > dive4elements > river

comparison flys-backend/ChangeLog @ 2877:f0a67bc0e777 2.7

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