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