log schema/gemma.sql @ 4093:c1c6a375305f historization_ng

age author description
Thu, 25 Jul 2019 17:39:40 +0200 Sascha Wilde Merged default historization_ng
Thu, 25 Jul 2019 16:45:07 +0200 Sascha L. Teichmann Added time zones to import queue tables.
Thu, 25 Jul 2019 13:20:32 +0200 Sascha Wilde Merged default historization_ng
Thu, 25 Jul 2019 12:36:07 +0200 Sascha Wilde Fixed c&p errors in gemma schema. historization_ng
Thu, 25 Jul 2019 12:33:19 +0200 Sascha Wilde Adapted references to bottlenecks from fairway_availability in DB schema. historization_ng
Thu, 25 Jul 2019 08:16:34 +0200 Tom Gottfried date_info has to be provided by the data source
Wed, 24 Jul 2019 16:15:21 +0200 Sascha Wilde WIP: Remove references to bottleneck validity in DB schema. historization_ng
Wed, 24 Jul 2019 13:29:31 +0200 Sascha Wilde Added trigger constraints to ensure matching gauges for gauge measurements. historization_ng
Wed, 24 Jul 2019 13:00:37 +0200 Sascha Wilde WIP: Finished remove references to gauge validity in DB schema. historization_ng
Wed, 24 Jul 2019 11:16:38 +0200 Sascha Wilde Merged historization_ng
Tue, 23 Jul 2019 13:10:51 +0200 Sascha Wilde WIP: Started to remove references to gauge validity. historization_ng
Tue, 23 Jul 2019 16:59:43 +0200 Sascha L. Teichmann Schema: delete only import entry that are for deletion.
Tue, 23 Jul 2019 13:16:41 +0200 Sascha L. Teichmann Import queue: Added a column to the tracking table to delete entries on stage done.
Fri, 19 Jul 2019 14:30:14 +0200 Tom Gottfried Optimize index setup a bit
Thu, 18 Jul 2019 19:57:10 +0200 Tom Gottfried Speed up time based filtering of gauge measurements and predictions
Wed, 17 Jul 2019 16:48:26 +0200 Sascha Wilde Schema: Use SQL instead of PLPGSQL for get_schema_version().
Wed, 17 Jul 2019 12:05:06 +0200 Sascha Wilde Added database schema versioning and db update script.
Tue, 16 Jul 2019 12:38:44 +0200 Sascha L. Teichmann Reworked password reset to be single mailed. pwreset-rework
Thu, 04 Jul 2019 16:30:19 +0200 Sascha Wilde Add wwname to import of virtual distance marks.
Mon, 24 Jun 2019 16:25:17 +0200 Sascha Wilde Fixed typo in gemma schema.
Mon, 24 Jun 2019 16:13:05 +0200 Sascha Wilde Added check trigger to sounding results to ensure they intersect the bn-area.
Sat, 15 Jun 2019 14:36:50 +0200 Tom Gottfried Align bottleneck validity at gauges
Sat, 15 Jun 2019 09:24:28 +0200 Tom Gottfried Use database triggers to move referencing objects to new versions
Thu, 13 Jun 2019 19:13:42 +0200 Tom Gottfried Ensure sounding results are associated to matching bottleneck version
Wed, 12 Jun 2019 18:26:26 +0200 Tom Gottfried Avoid empty validity time ranges
Wed, 12 Jun 2019 18:21:14 +0200 Tom Gottfried Fixup accidental change in rev. 02951a62e8c6
Wed, 12 Jun 2019 17:11:15 +0200 Tom Gottfried 'Historicise' bottlenecks on import
Wed, 05 Jun 2019 18:50:54 +0200 Sascha Wilde Allow same values for depth_reference in SR as in gauges
Wed, 29 May 2019 18:41:35 +0200 Tom Gottfried Prevent non-erased gauge version to have empty validity range
Wed, 29 May 2019 18:14:20 +0200 Tom Gottfried Improve error messages if no matching gauge version found
Wed, 29 May 2019 16:43:26 +0200 Tom Gottfried Improve validation of gauge temporal validity
Thu, 23 May 2019 15:33:56 +0200 Tom Gottfried Make revisiting time of a bottleneck optional
Thu, 23 May 2019 12:27:14 +0200 Tom Gottfried Fix adaptation of gauge temporal validity
Wed, 22 May 2019 16:44:13 +0200 Tom Gottfried Fix constraints on relationship between gauges and measurements/predictions
Wed, 22 May 2019 16:17:18 +0200 Tom Gottfried Remove obsolete DEFAULT values
Fri, 17 May 2019 11:28:20 +0200 Markus Kottlaender added sections_geoserver view, renamed stretch column to section in schema sections-backend
Thu, 16 May 2019 18:41:43 +0200 Tom Gottfried 'Historicise' gauges on import
Wed, 15 May 2019 19:42:21 +0200 Tom Gottfried Avoid storing of NtS messages other than water level
Wed, 15 May 2019 19:08:49 +0200 Tom Gottfried Disentangle gauge measurements and predictions
Thu, 09 May 2019 12:08:02 +0200 Sascha L. Teichmann Added template types "map", "diagram", "report".
Wed, 08 May 2019 10:37:47 +0200 Sascha L. Teichmann Schema: Added type column for users.templates. TODO: Add backend code to filter by it.
Mon, 06 May 2019 18:18:17 +0200 Tom Gottfried Handle failing INSERTs gracefully during gauge measurements import
Mon, 06 May 2019 16:36:03 +0200 Sascha L. Teichmann Sections import: Added a sections import. Derived from the stretches import w/o the countries.
Thu, 11 Apr 2019 12:01:27 +0200 Tom Gottfried Separate view definitions for GeoServer from general schema definition
Wed, 10 Apr 2019 18:50:20 +0200 Tom Gottfried Cleanup VIEW definition
Wed, 10 Apr 2019 16:44:30 +0200 Sascha L. Teichmann Bottleneck import: Import riverbed materials, too.
Fri, 29 Mar 2019 12:07:09 +0100 Thomas Junk merge
Fri, 29 Mar 2019 12:07:00 +0100 Thomas Junk merge
Fri, 29 Mar 2019 12:02:33 +0100 Thomas Junk gemma.sql fixed: Index creation extracted and put after schmema creation
Fri, 29 Mar 2019 12:02:22 +0100 Tom Gottfried Fix syntax error in schema
Fri, 29 Mar 2019 11:27:01 +0100 Thomas Junk gemma.sql removing trailing comma
Thu, 28 Mar 2019 16:40:02 +0100 Sascha Wilde Preserve old predictions on raw gauge measurement import.
Tue, 26 Mar 2019 13:02:12 +0100 Markus Kottlaender added responsible_country to bottleneck_overview
Fri, 22 Mar 2019 14:35:32 +0100 Tom Gottfried Prevent duplicate waterway axis and area geometries
Fri, 22 Mar 2019 11:25:09 +0100 Sascha Wilde Handle the case of missing depth references for bottlenecks gracefully.
Thu, 21 Mar 2019 18:55:52 +0100 Sascha Wilde BT import: allow for rb and lb to be null.
Wed, 13 Mar 2019 16:26:51 +0100 Sascha L. Teichmann Import log: Add filter for log entries with warnings only: GET /api/imports?warnings=true
Mon, 11 Mar 2019 18:46:09 +0100 Sascha L. Teichmann Morphological differences: Add SRID to cast in ios-lines view.
Fri, 08 Mar 2019 13:22:32 +0100 Bernhard Reiter schema: fix bottleneck_overview's project
Thu, 07 Mar 2019 15:55:25 +0100 Sascha L. Teichmann Schema: Added caching schema containing the sounding differences.