Wed, 19 May 2021 16:48:04 +0200 |
Sascha L. Teichmann |
Added new ZPG exception column to sounding result table.
zpg-exception
|
Tue, 31 Mar 2020 18:59:28 +0200 |
Tom Gottfried |
Keep historic data of fairway dimensions
|
Tue, 31 Mar 2020 12:50:30 +0200 |
Tom Gottfried |
Prevent equal axis geometries with intersecting validity
|
Fri, 27 Mar 2020 12:24:25 +0100 |
Tom Gottfried |
Merge default into queued-stage-done
queued-stage-done
|
Thu, 26 Mar 2020 14:41:23 +0100 |
Tom Gottfried |
Prioritize review jobs on selection
queued-stage-done
|
Tue, 24 Mar 2020 12:53:45 +0100 |
Sascha L. Teichmann |
Added new reviewed state.
queued-stage-done
|
Wed, 25 Mar 2020 18:10:02 +0100 |
Tom Gottfried |
Prevent duplicate fairway areas
|
Wed, 18 Mar 2020 19:19:09 +0100 |
Tom Gottfried |
Improve feedback if geometry cannot be stored
|
Wed, 18 Mar 2020 18:42:30 +0100 |
Tom Gottfried |
Store fairway dimensions as MultiPolygon
|
Fri, 13 Mar 2020 17:34:59 +0100 |
Tom Gottfried |
Keep historic data of waterway axis
|
Wed, 11 Mar 2020 17:11:23 +0100 |
Tom Gottfried |
Store axis as MultiLinestring
|
Wed, 11 Mar 2020 11:24:20 +0100 |
Tom Gottfried |
Amend trigger function
wmst-config
|
Fri, 06 Mar 2020 11:48:11 +0100 |
Sascha L. Teichmann |
Added support for WMS-Time in configuring the GeoServer.
wmst-config
|
Fri, 28 Feb 2020 18:35:07 +0100 |
Tom Gottfried |
Add index to speed up fairway marks imports a bit
fairway-marks-import
|
Fri, 28 Feb 2020 16:18:44 +0100 |
Tom Gottfried |
Follow-up of rev. 1b309a8e7673 for DAYMAR
fairway-marks-import
|
Fri, 28 Feb 2020 13:50:50 +0100 |
Tom Gottfried |
Fixup rev. 1b309a8e7673
fairway-marks-import
|
Fri, 28 Feb 2020 13:43:52 +0100 |
Tom Gottfried |
Follow-up of rev. 1b309a8e7673 for BOYLAT
fairway-marks-import
|
Thu, 27 Feb 2020 21:05:09 +0100 |
Tom Gottfried |
Distinguish more clearly between BCNLAT HYDRO and IENC features
fairway-marks-import
|
Wed, 26 Feb 2020 12:18:15 +0100 |
Tom Gottfried |
Keep the history of fairway marks
fairway-marks-import
|
Mon, 17 Feb 2020 18:38:45 +0100 |
Tom Gottfried |
Add missing fairway mark types
fairway-marks-import
|
Fri, 14 Feb 2020 17:31:17 +0100 |
Sascha L. Teichmann |
Added database models for group layers.
fairway-marks-import
|
Fri, 14 Feb 2020 13:01:45 +0100 |
Tom Gottfried |
Add missing BOYCAR attribute
fairway-marks-import
|
Fri, 14 Feb 2020 12:14:36 +0100 |
Tom Gottfried |
Add import for fairway marks of type BOYLAT
fairway-marks-import
|
Fri, 14 Feb 2020 07:41:43 +0100 |
Sascha L. Teichmann |
Geo styles as ZIP: Forgot to change the schema itself.
fairway-marks-import
|
Mon, 10 Feb 2020 18:47:27 +0100 |
Tom Gottfried |
Add import for fairway marks of type BOYCAR
fairway-marks-import
|
Mon, 10 Feb 2020 18:11:52 +0100 |
Tom Gottfried |
Fix handling of attribute dirimp
fairway-marks-import
|
Mon, 10 Feb 2020 14:56:43 +0100 |
Tom Gottfried |
Use table inheritance to define common fairway marks attributes
fairway-marks-import
|
Fri, 31 Jan 2020 16:53:06 +0100 |
Tom Gottfried |
Merge branch default into fairway-marks-import
fairway-marks-import
|
Fri, 24 Jan 2020 17:37:41 +0100 |
Tom Gottfried |
Merge branch default into fairway-marks-import
fairway-marks-import
|
Tue, 14 Jan 2020 18:24:51 +0100 |
Tom Gottfried |
Prevent importing non-distinct fairway marks
fairway-marks-import
|
Tue, 14 Jan 2020 15:01:42 +0100 |
Tom Gottfried |
Draft implementation of fairway marks import
fairway-marks-import
|
Fri, 31 Jan 2020 15:48:52 +0100 |
Tom Gottfried |
Backout changesets 5c12b7cdc58c and 8a4c98b80fbd
|
Fri, 24 Jan 2020 17:33:12 +0100 |
Tom Gottfried |
Make constraint trigger work in sessions with empty search_path
|
Fri, 24 Jan 2020 16:48:59 +0100 |
Tom Gottfried |
Make CHECK constraint work in sessions with empty search_path
|
Wed, 04 Dec 2019 13:35:34 +0100 |
Sascha Wilde |
Allow "Measured" and "Forecast" values to coexist for the same time and gauge.
|
Thu, 14 Nov 2019 14:53:15 +0100 |
Tom Gottfried |
Explaining comment on constraint triggers
|
Fri, 18 Oct 2019 17:55:12 +0200 |
Tom Gottfried |
Hide sys_admin accounts to waterway admins
|
Fri, 18 Oct 2019 15:45:48 +0200 |
Tom Gottfried |
Generally disallow the same section name for different countries
|
Fri, 18 Oct 2019 15:34:34 +0200 |
Sascha L. Teichmann |
Added a 'changed' column to the import.imports table.
|
Fri, 18 Oct 2019 12:04:04 +0200 |
Tom Gottfried |
Authorize sections based on country of creator
|
Thu, 17 Oct 2019 18:56:59 +0200 |
Tom Gottfried |
Avoid creating user profiles without matching role
|
Thu, 17 Oct 2019 16:36:58 +0200 |
Tom Gottfried |
Remove obsolete comment
|
Thu, 17 Oct 2019 13:08:49 +0200 |
Tom Gottfried |
Backed out changeset 9279fdb7a422
|
Thu, 17 Oct 2019 12:55:13 +0200 |
Tom Gottfried |
Ensure unique names of sections and stretches
|
Tue, 15 Oct 2019 15:59:38 +0200 |
Tom Gottfried |
Fix identifiers in layers generated from SQL views
|
Sun, 13 Oct 2019 19:22:36 +0200 |
Sascha L. Teichmann |
Started with conversion tool.
stree-experiment
|
Thu, 10 Oct 2019 17:10:14 +0200 |
Sascha L. Teichmann |
Fill single and multi into survey type table.
|
Wed, 09 Oct 2019 16:40:18 +0200 |
Tom Gottfried |
Merge default into geoserver_sql_views
geoserver_sql_views
|
Fri, 04 Oct 2019 16:40:04 +0200 |
Tom Gottfried |
Merge default into geoserver_sql_views
geoserver_sql_views
|
Fri, 20 Sep 2019 15:35:16 +0200 |
Tom Gottfried |
Merge default into geoserver_sql_views
geoserver_sql_views
|
Mon, 09 Sep 2019 17:24:07 +0200 |
Tom Gottfried |
Merge default into geoserver_sql_views
geoserver_sql_views
|
Fri, 06 Sep 2019 11:58:03 +0200 |
Tom Gottfried |
Add possibility to configure SRS for GeoServer SQL view
geoserver_sql_views
|
Thu, 05 Sep 2019 11:33:01 +0200 |
Tom Gottfried |
Separate schema and table name
geoserver_sql_views
|
Tue, 03 Sep 2019 18:00:50 +0200 |
Tom Gottfried |
Do not try to execute NULL as a subquery
geoserver_sql_views
|
Mon, 02 Sep 2019 18:45:15 +0200 |
Tom Gottfried |
Add field for GeoServer SQL view definition
geoserver_sql_views
|
Tue, 08 Oct 2019 13:02:21 +0200 |
Sascha L. Teichmann |
Adjusted templating for iso areas.
iso-areas
|
Tue, 08 Oct 2019 12:10:55 +0200 |
Sascha L. Teichmann |
Removed old contours from backend and database.
iso-areas
|
Mon, 07 Oct 2019 12:37:17 +0200 |
Sascha L. Teichmann |
Added caching table for iso areas of sounding differences.
iso-areas
|
Wed, 02 Oct 2019 16:43:34 +0200 |
Sascha L. Teichmann |
Added table to to store iso areas of sounding results.
iso-areas
|
Mon, 23 Sep 2019 12:59:48 +0200 |
Sascha Wilde |
Changed fa data to accept "position" as strings, not a 2char "position_code"
|
Fri, 20 Sep 2019 13:22:45 +0200 |
Tom Gottfried |
Fix forecast accuracy values and improve performance
|
Thu, 12 Sep 2019 18:13:47 +0200 |
Sascha Wilde |
Use stretches as areas of responsibility.
stretches-for-responsibility
|
Mon, 09 Sep 2019 16:13:26 +0200 |
Tom Gottfried |
Remove VIEW columns ignored by GeoServer
|
Wed, 21 Aug 2019 16:17:46 +0200 |
Bernhard Reiter |
Remove unused systemconf.feature_colours from backend
|
Wed, 07 Aug 2019 10:27:11 +0200 |
Tom Gottfried |
Enable faster access to import logs
|
Mon, 05 Aug 2019 16:45:48 +0200 |
Tom Gottfried |
Schema qualify tables in function body
|
Thu, 01 Aug 2019 19:12:47 +0200 |
Sascha Wilde |
Enable better error handling for referenced gauges/bottlenecks constraints.
|
Thu, 01 Aug 2019 17:07:01 +0200 |
Sascha Wilde |
Merged default
request_hist_bns
|
Thu, 01 Aug 2019 17:02:09 +0200 |
Tom Gottfried |
Bulk-delete tracked entries per table
|
Tue, 30 Jul 2019 13:14:47 +0200 |
Sascha Wilde |
Change constraints for bottlenecks to include staging_done flag.
request_hist_bns
|
Fri, 26 Jul 2019 16:49:54 +0200 |
Sascha Wilde |
Merged default
historization_ng
|
Fri, 26 Jul 2019 10:50:22 +0200 |
Sascha L. Teichmann |
Merged default into timezone branch.
timezone
|
Fri, 26 Jul 2019 10:38:24 +0200 |
Sascha L. Teichmann |
Fixed broken schema statement.
|
Fri, 26 Jul 2019 09:57:29 +0200 |
Sascha L. Teichmann |
Reapplied timezone patch to database schema.
timezone
|
Thu, 25 Jul 2019 18:19:24 +0200 |
Sascha Wilde |
Merged default
historization_ng
|
Thu, 25 Jul 2019 18:12:14 +0200 |
Sascha L. Teichmann |
Reverted 4160:419f28898db0 in default.
|
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.
|
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
|
Mon, 08 Oct 2018 14:29:59 +0200 |
Sascha L. Teichmann |
Merged default into geo-style branch.
geo-style
|
Mon, 08 Oct 2018 13:04:30 +0200 |
Tom Gottfried |
Add categories of CEMT class and directions of impact
|
Mon, 08 Oct 2018 10:54:50 +0200 |
Sascha L. Teichmann |
Merged default into geo-style branch.
geo-style
|
Thu, 04 Oct 2018 16:32:47 +0200 |
Tom Gottfried |
Store contour lines in 2D
|
Thu, 04 Oct 2018 12:45:25 +0200 |
Tom Gottfried |
Fix nullability in sounding results
|
Thu, 04 Oct 2018 12:28:09 +0200 |
Tom Gottfried |
Remove obsolete unused table
|
Sun, 30 Sep 2018 20:09:02 +0200 |
Sascha L. Teichmann |
The XSLT stuff is not need (Puh!).
geo-style
|
Sun, 30 Sep 2018 11:49:23 +0200 |
Sascha L. Teichmann |
More on uploading styles to gemma.
geo-style
|
Thu, 27 Sep 2018 23:59:36 +0200 |
Sascha Wilde |
Extended schema to save feature style information.
|
Thu, 27 Sep 2018 18:32:55 +0200 |
Tom Gottfried |
Add view to help geoserver serve contour lines
|
Mon, 24 Sep 2018 11:24:42 +0200 |
Sascha L. Teichmann |
Fixed problem with unique constraint for countour lines.
|
Sun, 23 Sep 2018 16:01:04 +0200 |
Sascha L. Teichmann |
Added table for contour lines of sounding results.
|
Fri, 21 Sep 2018 17:36:00 +0200 |
Sascha L. Teichmann |
octree: write SQL insert statements for octree indices.
octree
|
Thu, 20 Sep 2018 16:13:35 +0200 |
Bernhard Reiter |
schema: fix view distance_marks_geoserver
|
Thu, 20 Sep 2018 14:15:32 +0200 |
Bernhard Reiter |
Schema: Add view for waterway axis
|
Mon, 17 Sep 2018 16:25:44 +0200 |
Bernhard Reiter |
schema: disable sfcgal
|
Fri, 14 Sep 2018 17:45:42 +0200 |
Tom Gottfried |
Add PostgreSQL extension for 3D processing
|
Fri, 14 Sep 2018 16:57:12 +0200 |
Tom Gottfried |
Fix syntax error in schema script
|
Fri, 14 Sep 2018 16:31:07 +0200 |
Sascha L. Teichmann |
Fixed syntax error in schema definition.
|
Fri, 14 Sep 2018 16:21:44 +0200 |
Sascha L. Teichmann |
Cross sections: Commit data model for fast cross section calculation.
|
Tue, 11 Sep 2018 16:37:46 +0200 |
Tom Gottfried |
Remove test data from schema
|
Mon, 10 Sep 2018 17:32:51 +0200 |
Sascha L. Teichmann |
Sounding result: Write simple SQL insert dumper. Not deterministic, yet.
|
Mon, 10 Sep 2018 16:20:32 +0200 |
Sascha L. Teichmann |
Sounding results: C&P error ... too much brackets.
|
Mon, 10 Sep 2018 12:51:04 +0200 |
Sascha L. Teichmann |
Sounding results: We store the raw data as point clouds.
|
Fri, 07 Sep 2018 17:27:01 +0200 |
Tom Gottfried |
Ensure published service is based on existing table
|
Thu, 06 Sep 2018 16:27:17 +0200 |
Tom Gottfried |
Remove worthless attribute
|
Thu, 06 Sep 2018 16:15:38 +0200 |
Tom Gottfried |
Ensure gauges are identified by appropriate ISRS location code
|
Wed, 05 Sep 2018 19:13:37 +0200 |
Tom Gottfried |
Backed out changeset f3452ce5c056
|
Wed, 05 Sep 2018 11:05:58 +0200 |
Tom Gottfried |
Add function to construct isrs from text
|
Tue, 04 Sep 2018 21:41:45 +0200 |
Tom Gottfried |
Make table writable for data import
|
Thu, 23 Aug 2018 16:41:44 +0200 |
Tom Gottfried |
Purge password reset role
|
Wed, 22 Aug 2018 12:37:34 +0200 |
Tom Gottfried |
Remove unnecessary schema qualifiers
|
Tue, 21 Aug 2018 20:43:42 +0200 |
Sascha L. Teichmann |
Removed the command line option to publish tables with GeoServer.
|
Mon, 20 Aug 2018 18:10:55 +0200 |
Sascha L. Teichmann |
Added two tables to configure the WFS/WMS services of gemma.
|
Fri, 10 Aug 2018 18:44:15 +0200 |
Tom Gottfried |
Let all tables have a PRIMARY KEY again
|
Thu, 09 Aug 2018 17:21:12 +0200 |
Tom Gottfried |
Do not create B-Tree indexes on potentially large spatial data
|
Thu, 09 Aug 2018 15:45:16 +0200 |
Tom Gottfried |
Store spatial data as geography
|
Thu, 09 Aug 2018 15:19:56 +0200 |
Tom Gottfried |
Populate levels_of_service
|
Wed, 08 Aug 2018 16:31:23 +0200 |
Tom Gottfried |
Enforce PostgreSQL identifier length on username
|
Mon, 06 Aug 2018 15:19:05 +0200 |
Tom Gottfried |
Add staging feature to more tables
|
Thu, 02 Aug 2018 17:22:10 +0200 |
Sascha L. Teichmann |
If sys_admin renames user with pending password request update the pending requests, too.
|
Thu, 02 Aug 2018 15:14:38 +0200 |
Sascha L. Teichmann |
Added new table password_reset_requests to schema pw_reset.
|
Thu, 02 Aug 2018 13:06:39 +0200 |
Tom Gottfried |
Add special role for password reset
|
Mon, 30 Jul 2018 11:38:09 +0200 |
Tom Gottfried |
Make user_profiles table invisible for users
|
Thu, 26 Jul 2018 15:10:22 +0200 |
Tom Gottfried |
Allow using the same email-address for multiple users
|
Thu, 26 Jul 2018 15:02:19 +0200 |
Tom Gottfried |
Fix spelling
|
Wed, 25 Jul 2018 18:26:54 +0200 |
Tom Gottfried |
Add database function to update role and user profile
|
Mon, 23 Jul 2018 17:41:31 +0200 |
Tom Gottfried |
Make map extent mandatory
|
Mon, 23 Jul 2018 16:45:27 +0200 |
Tom Gottfried |
Make responsibility area mandatory
|
Mon, 23 Jul 2018 16:14:36 +0200 |
Tom Gottfried |
Remove obsolete TODO comment
|
Fri, 20 Jul 2018 17:28:16 +0200 |
Tom Gottfried |
Introduce database schemas as privilege-based namespaces
|
Thu, 19 Jul 2018 16:32:27 +0200 |
Tom Gottfried |
Remove language code from user profiles
|
Wed, 18 Jul 2018 16:48:27 +0200 |
Tom Gottfried |
Beautify SQL
|
Tue, 17 Jul 2018 16:50:16 +0200 |
Tom Gottfried |
Make schema for templates more realistic
|
Fri, 29 Jun 2018 11:56:34 +0200 |
Sascha Wilde |
Schema: Make responsibility_areas multi polygons.
|
Tue, 26 Jun 2018 16:20:04 +0200 |
Sascha L. Teichmann |
s/wamos/gemma/g on database schema.
base
schema/wamos.sql@150a5dc16ddd
|