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