Mercurial > gemma

log schema/gemma.sql @ 3423:6592396f5061

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
less more | (0) -120 tip
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
Tue, 29 Jan 2019 12:36:45 +0100 Tom Gottfried Fix column type to match referenced column
Thu, 24 Jan 2019 12:56:31 +0100 Tom Gottfried Move import queue to its own database namespace
Wed, 23 Jan 2019 17:59:15 +0100 Sascha L. Teichmann Merged.
Wed, 23 Jan 2019 17:58:57 +0100 Sascha L. Teichmann Imports: Made retries and the waiting between the attempts configurable.
Wed, 23 Jan 2019 17:46:50 +0100 Tom Gottfried Ensure geometries in database are valid OGC simple features
Wed, 23 Jan 2019 16:25:43 +0100 Tom Gottfried Fix area generation from multipolygon input
Wed, 23 Jan 2019 11:20:14 +0100 Sascha L. Teichmann Imports: Added the new state 'unchanged' which can be issued by the imports to indicate that the database is not modified by the particular imports.
Tue, 22 Jan 2019 18:22:57 +0100 Sascha Wilde Added view for publishing bottlenecks
Mon, 21 Jan 2019 11:44:31 +0100 Sascha L. Teichmann Better suited GeoServer view for waterway.stretches.
Fri, 18 Jan 2019 17:13:12 +0100 Sascha L. Teichmann Stretch import: Added forgotten source file.
Fri, 18 Jan 2019 12:00:59 +0100 Sascha L. Teichmann Schema: Replaced sections_stretches table with a pure stretches table.
Thu, 17 Jan 2019 13:15:22 +0100 Raimund Renkert Adjusted database schema for distance marks importer.
Wed, 16 Jan 2019 17:20:19 +0100 Tom Gottfried Remove superfluous schema qualifiers in definition of the schema itself
Wed, 16 Jan 2019 12:56:54 +0100 Sascha L. Teichmann Schema: Adjust gauges once again to be in sync with RIS index.
Wed, 16 Jan 2019 12:42:34 +0100 Sascha L. Teichmann Backed out changeset 332e42a2088d (no staging needed).
Wed, 16 Jan 2019 12:42:19 +0100 Sascha L. Teichmann Backed out changeset f1351a58da35 (no staging needed)
Wed, 16 Jan 2019 11:31:36 +0100 Sascha L. Teichmann SQL: typo fix.
Wed, 16 Jan 2019 11:28:33 +0100 Sascha L. Teichmann DB schema: Made primary key of waterway.gauges an integer for staging purposes.
Wed, 16 Jan 2019 10:36:22 +0100 Sascha Wilde Removed all unique geohash indexes as they prevent updates of data.
Fri, 11 Jan 2019 18:32:59 +0100 Sascha L. Teichmann Gauge measurements: Add an unique constraint so there could only
Fri, 11 Jan 2019 16:48:14 +0100 Sascha L. Teichmann (Approved) gauge measurement import: Fixed row level security.
Fri, 11 Jan 2019 12:10:23 +0100 Sascha L. Teichmann Gauge measurement import: Added reference_code column.
Thu, 10 Jan 2019 17:21:51 +0100 Sascha L. Teichmann Import queue: Removed auto_accept from imports table, too.
Thu, 10 Jan 2019 16:19:26 +0100 Sascha L. Teichmann Import queue: Auto acceptance is now a property of the import kind itself and is not configurable any more.
Tue, 08 Jan 2019 13:35:44 +0100 Sascha L. Teichmann Imports: Made imports re-runnable if they fail.
Mon, 07 Jan 2019 13:23:39 +0100 Sascha L. Teichmann Import configuration: [WIP] Added table for extra configuration attributes.
Thu, 27 Dec 2018 23:23:36 +0100 Sascha L. Teichmann Waterway axis: Removed unique geohash index.
Fri, 21 Dec 2018 15:56:28 +0100 Raimund Renkert Implemented first version of fairway availability import.
Thu, 20 Dec 2018 13:45:32 +0100 Sascha L. Teichmann Import queue: Implemented auto-accept and email sending.
Thu, 20 Dec 2018 12:05:30 +0100 Raimund Renkert Updated database schema for gauge meaurement imports.
Thu, 13 Dec 2018 18:37:35 +0100 Sascha L. Teichmann Added GET to /api/imports/scheduler.
Wed, 12 Dec 2018 19:21:02 +0100 Sascha L. Teichmann Made bottleneck primary key an int. Attention: This may break something!
Mon, 10 Dec 2018 15:55:10 +0100 Sascha L. Teichmann Add table to store import configuration.
Thu, 06 Dec 2018 15:37:06 +0100 Sascha Wilde Fixed date of latest measurement in bottlenecks list.
Fri, 30 Nov 2018 15:56:34 +0100 Sascha Wilde Add configuration of primary key metadata used by geoserver.
Wed, 28 Nov 2018 09:52:34 +0100 Sascha L. Teichmann Imports: An Import (e.g. a sounding result import) can now write a 'summary' of a successful import. This is done if the import switches to to state 'pending'.
Mon, 26 Nov 2018 17:14:56 +0100 Sascha L. Teichmann Removed bad trigger ... works in wrong direction.
Mon, 26 Nov 2018 15:21:34 +0100 Sascha L. Teichmann Added missing rights and fixed trigger function.
Mon, 26 Nov 2018 09:01:21 +0100 Fadi Abbud merges
Fri, 23 Nov 2018 13:46:47 +0100 Fadi Abbud add headers for licensing to some schema files
Sat, 24 Nov 2018 16:22:28 +0100 Sascha L. Teichmann Added missing copyright headers and authors in schema related files.
Fri, 23 Nov 2018 10:35:39 +0100 Fadi Abbud add headers for licensing to some schema files
Fri, 23 Nov 2018 09:35:10 +0100 Fadi Abbud add headers for licensing to some schema files
Thu, 22 Nov 2018 12:25:01 +0100 Tom Gottfried Accept only well-formed XML documents as style in database
Sun, 18 Nov 2018 18:29:25 +0100 Sascha L. Teichmann Added a signer who makes the final decison on an import.
Fri, 16 Nov 2018 18:35:09 +0100 Sascha L. Teichmann Implemented the db stuff of the review process. Needs testing.
Fri, 16 Nov 2018 12:15:51 +0100 Sascha L. Teichmann The imort queue has now six states:
Wed, 14 Nov 2018 13:12:41 +0100 Sascha L. Teichmann Propagate deletion of imports through the track_imports table.
Wed, 14 Nov 2018 12:23:10 +0100 Sascha L. Teichmann Track successfull imports in a separate table to be able to remove them later.
Wed, 07 Nov 2018 18:13:02 +0100 Tom Gottfried Delete contour lines with their sounding result
Wed, 07 Nov 2018 17:54:50 +0100 Tom Gottfried Store octrees along with sounding results
Mon, 29 Oct 2018 10:44:51 +0100 Sascha L. Teichmann Added waterway.bottleneck_overview view to database schema.
Tue, 23 Oct 2018 11:32:47 +0200 Sascha L. Teichmann Fixed schema definition of import queue.
Mon, 22 Oct 2018 16:54:34 +0200 Sascha L. Teichmann Persist job queue in database. WIP. persistent-import-queue
Mon, 22 Oct 2018 13:03:38 +0200 Sascha L. Teichmann Added tables for importer queue and respective logging. persistent-import-queue
Sat, 13 Oct 2018 14:26:40 +0200 Tom Gottfried Store virtual and physical distance marks separately
Wed, 10 Oct 2018 00:16:31 +0200 Sascha L. Teichmann Merged default into geo-style branch. geo-style
Mon, 08 Oct 2018 15:18:26 +0200 Tom Gottfried Add categories of distance marks
Mon, 08 Oct 2018 14:48:58 +0200 Sascha L. Teichmann Merged default into geo-style branch. geo-style
Mon, 08 Oct 2018 14:41:56 +0200 Tom Gottfried Remove obsolete comments
less more | (0) -120 tip