log schema/gemma.sql @ 3423:6592396f5061

age author description
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.
Wed, 06 Mar 2019 17:51:58 +0100 Sascha L. Teichmann SR import: Use own triangulation and clipping when importing sounding results.
Fri, 01 Mar 2019 16:28:24 +0100 Sascha Wilde Added gauges layer.
Fri, 01 Mar 2019 12:24:37 +0100 Sascha Wilde depth_reference in sounding data must be more permissive.
Wed, 27 Feb 2019 16:20:22 +0100 Tom Gottfried Using a table in a view before it is created is not possible
Wed, 27 Feb 2019 14:02:28 +0100 Sascha Wilde Don't hard code the available water level ref. systems.
Fri, 22 Feb 2019 18:02:23 +0100 Tom Gottfried Validate country and hectometre in ISRS code
Thu, 21 Feb 2019 14:43:45 +0100 Sascha L. Teichmann Schema: Dropped wrong constraints in gauges.geodref.
Thu, 21 Feb 2019 10:46:38 +0100 Sascha L. Teichmann Print templates: Removed primary key from templates table and add a unique constraint to template name and country instead to make possible that different countries can use templates with same name.
Tue, 19 Feb 2019 17:27:35 +0100 Sascha Wilde Added geoserver config for stretches layer.
Tue, 19 Feb 2019 13:45:39 +0100 Bjoern Schilberg schema/gemma.sql: Added to gm_waterlevel bottlenecks_geoserver view.
Mon, 18 Feb 2019 19:38:48 +0100 Tom Gottfried Warn on import of unknown reference level codes
Mon, 18 Feb 2019 18:45:12 +0100 Tom Gottfried Cleanup schema for reference water levels
Mon, 18 Feb 2019 12:12:12 +0100 Sascha Wilde Use distance marks from wamos db in map.
Fri, 15 Feb 2019 14:08:42 +0100 Bjoern Schilberg schema/gemma.sql: Added fairway_availability.critical and date_info to bottlenecks_geoserver view.
Thu, 14 Feb 2019 15:11:00 +0100 Sascha L. Teichmann Ajjusted RLS for user templates.
Wed, 13 Feb 2019 10:52:14 +0100 Tom Gottfried Remove debris and associate templates to country
Fri, 08 Feb 2019 17:55:42 +0100 Sascha Wilde Removed trigger to update date_info on gauge_measurements.
Fri, 08 Feb 2019 16:20:26 +0100 Sascha Wilde Fixed de-duplication (primary geoserver id) for virt dist marks.
Fri, 08 Feb 2019 12:50:42 +0100 Sascha Wilde Changed geoserver primary key for distance_marks_geoserver to 'id'.
Fri, 08 Feb 2019 11:02:05 +0100 Sascha L. Teichmann Print templates: Stubbed endpoints under /api/templates/print/{name}
Thu, 07 Feb 2019 12:23:05 +0100 Tom Gottfried Waterway profiles have to match a distance mark
Wed, 06 Feb 2019 15:42:32 +0100 Tom Gottfried Fix constraints on waterway profiles
Wed, 06 Feb 2019 15:35:30 +0100 Tom Gottfried Flatten location code in distance marks view
Thu, 31 Jan 2019 17:22:19 +0100 Sascha Wilde Changed bottlenecks_geoserver view and added config to prevent duplications.
Thu, 31 Jan 2019 16:32:18 +0100 Sascha L. Teichmann Waterway profiles import: Restructured code a bit in preparation of downloading Profile geometries from WFS first (needs to be done).
Thu, 31 Jan 2019 12:40:54 +0100 Tom Gottfried Fix exclusion constraint for waterway profiles
Wed, 30 Jan 2019 17:26:51 +0100 Tom Gottfried Add missing NOT NULL constraints
Wed, 30 Jan 2019 17:11:10 +0100 Sascha L. Teichmann Waterway profile import: Added import stub and changed database.
Wed, 30 Jan 2019 10:01:45 +0100 Sascha L. Teichmann Merged default into branch. unify_imports
Tue, 29 Jan 2019 12:36:45 +0100 Tom Gottfried Fix column type to match referenced column unify_imports
Fri, 25 Jan 2019 16:07:09 +0100 Sascha L. Teichmann This breaks this branch!!!! Starting to remove the old persistent layer for configured imports. unify_imports