CHANGELOG.md

Changelog

[Unreleased]

Added

• WMTS Services are now supported as custom user layers.
• Added data extraction API.
• Added support to extract coordinates from a borehole attachment.
• Show ChangedAt and ChangedBy information in borehole detail header.

Changed

• Updated the style of bulk edit form.
• Hide the help button in the navigation bar in read-only mode.
• Hide the original_name field in the borehole detail view in read-only mode.
• Updated the style of the location tab.
• Changes on the location tab are now saved by clicking the Save button, instead of immediately.

Fixed

• view-sync did not clean up unpublished boreholes.
• User permissions were not checked when detaching files from boreholes.
• The basemap selector buttons were not displayed correctly on hover.
• No scrollbar was displayed in the side drawer when many additional layers were added.
• There was no appropriate error message when the drawn box did not contain extractable coordinates.

v2.1.870 - 2024-09-27

Added

• Tooltips to main side navigation.
• Location hash for tabs in borehole detail view.
• Language dropdown in the header.
• Added health check endpoint for the .NET API.
• Added possibility to run the boreholes web application in read-only mode.
• New view-sync Docker image for syncing free/published boreholes from a source to a target database.

Changed

• Renamed technical attributes kind_id_cli to borehole_type_id, top_bedrock to top_bedrock_fresh and qt_top_bedrock to top_bedrock_weathered.
• Moved groundwater radio buttons in borehole form to the bottom.
• Made startTime and reliability optional for hydrogeology.
• Removed title from prompt dialog.
• Use standard prompt dialog for deleting boreholes.
• Updated standard alert.
• Updated styling of attachment upload button.
• It is now possible to restart a workflow from every publication status.
• Renamed codelist entries for casing type and casing material.
• Upgraded to PostgreSQL 15 and PostGIS 3.4.
• Removed unused IsViewer flag from user.
• Removed unused UserEvent from user.
• Migrated User API endpoints to .NET API.
• Disclaimer is now displayed at every login.
• Changed boreholes table design.
• Migrated Workgroup API endpoints to .NET API.
• Use filled style for form components.
• The borehole table now displays the attribute alternate_name instead of origianal_name in the Name column.
• Removed supplier_wgp column from workgroup table.
• Fixed typo in consistency codelist.
• Updated the style of various buttons.
• Map zoom level and center are now preserved when returning to the main map.
• Deactivated the possibility to select page size in borehole table pagination.

Fixed

• Attribute top_bedrock_weathered could not be imported.
• Badge with number of active filters on sidebar did not include polygon filter.
• Fixed label for water ingress menu item.
• Location precision filter caused an internal error.
• Base maps were loaded beyond their maximum zoom level.
• layer_depth_to was displayed in filter even though it was not selected in the filter settings.
• Users can now only import or add new boreholes to workgroups where they have an editor role.
• Label for description quality was wrong in lithology filter and settings.
• Boreholes could not be deleted in the detail view if the publication status was not Change in progess.
• Boreholes table loaded all boreholes instead of none when a filter combination with polygon was used that did not return any boreholes.
• Boreholes table reset scroll position when hovering over a row.
• When returning to the boreholes table from another page, the last scroll position was lost.
• Status filter labels were not displayed correctly.
• Order of groundwater level measurement attributes was incorrect.
• The Name attribute in the borehole form was not correctly updated when first navigating to the page.
• Fixed german translation for clay pellets and french translation for openBorehole.

v2.1.772 - 2024-06-27

Added

• Added borehole geometry panel.
• Added secondary header to borehole detail view.
• Added new codelist entries for casing_type and backfill_material.

Changed

• Added outcrop to codelist borehole_type.
• Made boreholes table on the map page collapsible.
• Changed sidebar layout and design.
• Moved form to add a borehole from modal to sidepanel.
• Removed fields Inclination InclinationDirection and QtInclinationDirectionId from borehole.
• Removed filter by map functionality.
• Moved icon to handle custom layers to sidebar.
• Show more entries on the boreholes table when screensize is smaller than 1200px.
• Calculate TVD values in General panel using the geometry of the borehole.
• Moved logout to header and improved header style.
• Removed entries drilling_date,drilling_diameter,drilling_method_id,spud_date and cuttings_id from the borehole import.
• Removed entries inclination,inclination_direction and qt_inclination_direction_id from the borehole import.
• Removed settings for codelist translations and identifiers from admin settings.
• Removed entries total_depth_tvd, and qt_total_depth_tvd_id from the borehole import.
• Renewed lithology codelists in schema custom.lithology_top_bedrock.
• Moved publication status in detail view to separate tab.
• Published boreholes cannot be edited anymore.

Fixed

• Fixed precisions where not correctly displayed for imported coordinates.
• When editing lithology layers, the view would always scroll to the bottom of the layer stack when finished.
• Added missing foreign key constraints on borehole_files composite primary keys.

v2.0.687 - 2024-04-19

Added

• Added borehole sections panel.
• Added new basemap selector in maps.

Changed

• Disabled viewer mode, moved map settings from viewer settings to editor settings.
• Renamed codelist custom.qt_top_bedrock to depth_precision.
• Placed casing_elements inputs on two lines for better readability.
• Sorted common.json files alphabetically and removed unused entries.
• Removed public field in publication workflow.
• Removed developer debug functionality.
• Removed unneeded scroller component.
• Remove fields from borehole that are now part of sections.
• Renamed spud_date to drilling_start_date.
• Adapted map icons to match common style of swissgeol applications.
• New casing element's top depths is set to the previous casing element's bottom depth by default.
• Set minimal resolution to 0.1 for open layer maps.
• Renamed table borehole_codelist to borehole_identifiers_codelist.
• Changed order of menu items in borehole detail view.
• Split generic join table hydrotest_codelists into 3 separate join tables for each many to many relationship between hydrotest and codelist.

Fixed

• Fixed direct navigation to nested urls.
• Fixed hash routing for completion tabs.
• When copying a borehole completions, hydrogeological observations and borehole sections were not copied.
• Updated favicon for help.
• Fixed zoom level when loading detail map.
• Fixed authorization exception for users who have not yet been assigned to a role or workgroup.

v2.0.644 - 2024-03-22

Added

• Reusable form components.
• Quality attribute for stratigraphy.
• Support Amazon Cognito logout flow.
• IsOpenBorehole option for instrumentation and backfill.
• Support adding multiple field measurement results in hydrogeology.
• Show prompt for unsaved changes when switching data card or completion tabs.
• Add entry resin to codelist backfill_material and entries U-probe and double U-probe to codelist casing_type.
• Show prompt before deleting data card.

Changed

• Updated layer management to use the .NET API.
• Update stratigraphy management to use the .NET API.
• Hide outer ring for disabled radio buttons.
• Handle Authentication with a OpenID Connect.
• Improved input behavior for various input fields. E.g. stratigraphy name.
• Increased editing lock timeout to 60 minutes.
• Administrators are always allowed to edit all boreholes.
• Removed the functionality to add new users since they are now managed by the IAM.
• Removed the functionality to edit user details (first name, surname and password) since they are now managed by the IAM.
• Removed middle name from user details because it was not used until now.
• Disable inputs of the editor view's borehole tab, when editing mode is not active or borehole status does not allow editing.
• Simplified and restructured the completion section (database, API, UI).
• Link hydrogeology observations to new completion casing.
• Use always m MD as unit for borehole depth.
• Use reusable form components for hydrogeology.
• Replaced label for layer description quality.
• Reduced number of seeded boreholes for development from 10'000 to 3'000.
• Use reusable card components for hydrogeology.
• Renamed various codelists to have more evocative names (e.g. location_precision instead of qt_location, plasticity instead of mlpr101, …)
• Remove stratigraphy kind.
• Split generic join table layer_codelists into 6 separate join tables for each many to many relationship between layer and codelist.
• Replaced create-react-app (react-scripts) with vite for frontend tooling.
• Included typescript configuration.
• Prevent typing dates in profile and filter, only allow selecting date in datepicker.
• Split table casing into tables casing and casing_element.
• Store precision of coordinates, to be able to display zeros after the decimal points in coordinate inputs.
• Link casing to backfill.
• Removed square brackets from m MD in chronostratigraphy and lithostratigraphy.
• Implemented a validation to check the user's role and the lock status of the borehole before performing any data manipulations on child tables in the .NET API.
• Include completion in casing name for hydrogeological observations.
• Removed property isLast from ChronostratigraphyLayer, LithostratigraphyLayer, LithologicalDescription and FaciesDescription.
• Removed feedback functionality.
• Included new swissgeol boreholes logo and icon.
• Removed completed checkbox from hydrogeology observations and added option open hole to completion name.
• Removed the configurable welcome message on the login overlay.
• Login is performed automatically on page visit.
• Use a non-root user to run the boreholes web application.

Fixed

• Ensure hydrogeology components are loaded properly when refreshed.
• Fix translations for new buttons.
• Fixed delete behavior for non-nullable foreign keys of type Codelist.
• Fixed height reference system display.
• Fixed hydrotest kind display.

v2.0.506 - 2023-12-21

Added

• Table and controller for completion.

Changed

• Use numeric input instead of dropdown for top bedrock quality fields.
• Proxy requests to legacy api through .NET API with authentication.
• Disable inputs of the editor view's borehole location tab, when editing mode is not active or borehole status does not allow editing.
• Remove obsolete database view completness.
• Use a non-root user in the .NET Docker image.

v2.0.476 - 2023-12-08

Changed

• Upgraded to OpenLayers 8.
• Upgraded to .NET 8.
• Upgraded to Node 20.

v2.0.452 - 2023-07-05

Added

• Added new field national_interest to borehole table.
• Added support for ID boreholes.swissgeol.ch as a filter ID type.
• Added filter for chronostratigraphy.
• Added filter for lithostratigraphy.

Changed

• Removed lithostratigraphy_id from import.
• Renamed stratigraphy filter to lithology filter.

Fixed

• Fixed bug where value for debris lithology was not displayed.

v2.0.441 - 2023-06-12

Added

• Added new symbols for borehole types 'virtual borehole' and 'other'.
• Panel to edit lithostratigraphy layers.

Changed

• Updated the lithostratigraphy codelist table.
• Upgraded to OpenLayers 7.
• Removed lithostratigraphy and chronostratigraphy from lithology.
• Removed obsolete columns facies_description_lay and lithological_description_lay from layer table.

Fixed

• Fixed bug where empty strings were displayed instead of unknown in the casing dropdown when adding water ingresses, hydrotests, groundwater measurements or field measurements.
• Fixed label and setting for lithology top bedrock attribute of layer.
• Fixed bug where normal user had no permission to create hydrotests.

v2.0.422 - 2023-06-02

Added

• Lithology csv import.
• Table and controller for lithostratigraphy.

Changed

• The hydrotest input mask now supports selecting multiple hydrotest kinds.
• Enable all file types as borehole attachments.
• Improved appearance of import UI.
• Increased maximum of displayed validation errors during borehole import to 1000.

Fixed

• Fixed italian translation for completionFinished.
• Workgroup dropdown in the import menu was not scrollable.
• Ensure duplicated boreholes are detected during borehole import.
• When the application was set to German, an issue occurred where the term 'keine_Angabe' was unecessarily displayed in the lithology subtitle.
• Ensure copied stratigraphy is not primary.
• Ensure borehole attachments can be managed by any user role.
• Enable upload of borehole attachments with a size of up to 200 Mb.
• Show message when borehole import takes longer than 30 seconds.

v2.0.400 - 2023-05-24

Added

• Added link to online help in import dialog.
• Upload borehole attachments using borehole import feature.
• Added boreholes.swissgeol.ch id to details view.
• Added import_id as required field for borehole import.
• Added functionality to add, edit and delete hydrotests, which belong to the hydrogeology observations of a borehole.
• Added functionality to add, edit and delete field measurement, which belong to the hydrogeology observations of a borehole.
• Added csv export for current codelist table.
• Added the fields qt_location, qt_elevation, reference_elevation_qt and reference_elevation_type to bulk editing.

Changed

• Changed style of the inputs when editing lithological_descriptions and facies_descriptions to outlined.
• Borehole duplicates are only identified within the same workgroup when importing boreholes.
• Filter contents are shown directly below the filter group without reordering.
• Harmonized labels for from_depth and to_depth fields across the application.
• The duplicate checks for a borehole's original_name and alternate_name have been removed. Duplicate names are now allowed.
• Improve chronostratigraphy edit, change the stratigraphy selection to a simple dropdown.
• Hide overlapping chronostratigraphy layer depth labels and add depth scale.

Fixed

• Fixed and extended chronostratigraphy geolcodes.
• Fixed login with passwords containing : and other non ASCII characters.
• Fixed label of completion_finished in hydrogeological observations, which used to be always in german.
• The chronostratigraphy edit panel shows progress indicator when no stratigraphies or lithologies exist.
• Copy and delete buttons not visible when editing lithology.
• Show stratigraphy with empty name as unknown.
• Chronostratigraphy fields were not translated.
• Lithology layers not sorted by depth in viewer.

v2.0.298 - 2023-04-18

Added

• Defined borehole csv import fields original_name, location_x and location_y as required.
• Added validation for required borehole csv import fields.
• Added online help.
• Added validation for duplicated boreholes during the cvs import.
• Added functionality to add, edit and delete wateringresses, which belong to the hydrogeology observations of a borehole.
• Use .NET API for managing borehole files.

Changed

• Changed all db attributes of type date to timestamp with timezone.
• Support ID Kernlager (drill core storage facility ID) in csv import.
• Removed clone and delete icons in chronostratigraphy header.
• Made csv import validation error modal content scrollable.
• Replaced csv import validation messages with more specific messages.
• Updated csv borehole upload endpoint to additionally handle list of PDF's.

Fixed

• Fixed scrolling behaviour for lithological_descriptions and facies_descriptions.
• Fixed missing datapoints on map zoom after filtering by map extent.
• Fixed table was reset to page 1 when returning to borehole list from detail with appearance Map & List|Details and List|Details & Map.
• Fixed search filters were not applied to points on map.
• Fixed scrolling behaviour for lithology_layers.
• Fixed error when repeatedly sorting by "original name" that caused the application to crash under special circumstances.

v2.0.273 - 2023-04-04

Added

• Added functionality to edit facies description seperately from lithology.
• Added functionality to scroll to newly created lithology layer.
• Added separate panel to edit chronostratigraphy layers.
• Added minimal csv-import for boreholes.
• Added option to edit workgroup in bulk edit dialog.

Changed

• Memorized table and map state when navigating through the application.
• When leaving settings page, correctly navigate back to the previously selected mode (viewer or editor).
• Display loader icon when fetching data for stratigraphy or users.
• Removed lithological description and facies description from lithology layer in viewer mode, editor mode and in settings.
• Removed set manually from resolving options when deleting a lithology layer.
• Display lithology layer details in lithology column in editor mode.
• Immediately delete layers in casing and backfill columns, without showing a delete dialog.
• Removed export functionality.
• Removed blue info button of displayed maps in map settings.
• Updated Chronostratigraphy Codelist entries.
• Made Lithology a sub-menu of Stratigraphy.
• Display chronostratigraphy colors in chronostratigraphy editor.
• Migrated chronostratigraphy Middle Jurassic undifferenciated to Middle Jurassic.
• Removed height reference system column from editor view list.
• Removed import settings from administrator settings.
• Enabled editor mode settings for all user types.
• Replaced csv import coordinates related columns by location_x and location_y.
• Auto detect the provided coordinate reference system in the csv import and calculate the coordinates for the not provided reference system.

Fixed

• Creating, editing or deleting lithological descriptions was not allowed for non-admin users.
• When creating and locating a new borehole, each click added a new point on the map.
• Added missing translations when editing a locked borehole, giving feedback or deleting an ID type.
• Fixed internal error when adding a backfill with no casing.
• Fixed internal error in viewer/editor settings for Stratigraphy fields when clicking Select all.
• Fixed error when downloading a borehole profile.
• Fixed bug where a facies description with a height of 0 could be created.
• Fixed broken layout of lithological description and facies description columns when a gap of more than one layer was created in the lithology column.
• Fixed bug where lithological descriptions where not copied when copying boreholes or stratigraphies.
• Fixed bug where coordinates were not updated when pasted in the coordinate input.
• Empty text or numeric fields are always displayed as - in the detail sections of the viewer mode.
• Enabled translation of transparency label in map settings.
• Removed unnecessary Italian text in publish confirmation modal.
• Added status submit message in all languages.
• Allowed uploading the same file for different boreholes.
• Display an error message if a file is already uploaded for a particular borehole.
• Resolved error when selecting Instrumentation with no EDIT role and no stratigraphy defined for borehole.
• Fixed and improve flaky Instrumentation tests.
• Improved rendering of Instrumentations.
• Removed unnecessary borehole property date from csv import as well as in the database.

v2.0.186 - 2023-02-13

Added

• Added new location migration endpoint in order to be able to manually update location information (country_bho, canton_bho and municipality_bho).

v2.0.183 - 2023-02-10

Added

• Added functionality to edit lithological description seperately from lithology.

Changed

• Replaced all generic browser alerts with styled alerts.

Fixed

• Fixed bug where selecting the location filter as viewer or editor caused the application to crash.
• When copying a borehole, layer properties with multiple values (i.e. USCS3) were ignored and not copied.
• Copying a borehole was not allowed as non-admin user.

v2.0.169 - 2023-02-07

Added

• Added new data migration endpoint to recalculate the coordinates depending on whether the original spatial reference system is LV03 or LV95 based.

Changed

• Get Municipality, Canton, Country from geo.admin.ch service. Removed obsolete Canton / Municipality tables.
• Removed unnecessary units from various labels.
• Reused styles in map component.
• Removed unnecessary JSON attributes when loading borehole geometries.
• Placed original_lithology field after lithology in viewer/editor settings for Stratigraphy fields.
• Empty text or numeric fields are always displayed as - in the detail sections of the viewer mode.
• Added workgroup filter to viewer.
• Removed unused table bdms.geodin_files from database.

Fixed

• Fixed partly unresponsive UI by avoiding unnecessary data loading on startup.
• Fixed bug where setting or changing the borehole location on the map in editor mode caused the application to freeze.
• Disabled possibility to draw and move point in detail map when borehole is not locked.
• When copying a stratigraphy, layer properties with multiple values (i.e. USCS3) were ignored and not copied.

v2.0.133 - 2023-01-19

Added

• Added db constraints for table layer_codelist.
• Display original_lithology field in viewer and editor mode.

Changed

• Use REST API v2 to display layer in viewer mode.

v2.0.131 - 2023-01-16

Added

• Added possibility to add a casing layer (CasingId) to an instrument.
• Added new columns in borehole table for LV03 coordinates.
• Added inputs for entering coordinates in LV03 as well as LV95. The coordinates in the coordinate system that were not entered by the user, are automatically transformed and completed.
• Added search filter for reference systems (LV03 and LV95).
• Added cluster layer for displaying points on map while maintaining application performance.
• Added input field to codelist translation UI, that is used to change the order of the codelist.
• Added filter in editor mode for registration details creation date and user.
• Added db constraints for stratigraphy.fill_casng_id_sty_fk and layer.gradation_id_cli.
• Added new db field original_lithology to layer table. The new field contains english text values of unconrocks_id_cli and lithok_id_cli.

Changed

• Migrated existing LV95 coordinates into LV03 coordinates using 'shift' method. Preserve original LV95 coordinates for some selected boreholes (e.g. Bülach-1-1, ...).
• Points on the overview map are now displayed as clusters depending on zoom level.
• Ordered codelists in translation UI by order column instead of by geolcode.
• Coordinates, elevations diameters and depths in inputs and texts are now displayed with thousand separators.
• Removed mentions functionality in workflow comments.
• Removed unused columns from database: borehole.import_id, borehole.tecto_id_cli, stratigraphy.import_id, layer.import_id, layer.tectonic_unit_id_cli, layer.symbol_id_cli, layer.soil_state_id_cli, layer.kirost_id_cli.
• Removed unused table bdms.statigraphy_codelist from database.
• Removed layer.unconrocks_id_cli and layer.lithok_id_cli from database.
• Changed cardinality of uscs3 field on bdms.layer to m:n.

Fixed

• Fixed sending feedback e-mail.
• Display lithology_top_bedrock, lithostratigraphy_top_bedrockand chronostratigraphy_top_bedrock as domain trees in bulk edit.
• Added space above the instrument list.
• Fixed bug where casing IDs could be selected, even though the name of completion was No casing.
• Fixed bug where filtering by identifier led to bugs in bulk edit.
• Fixed bug where points with spatial reference system LV03 were not correctly displayed on detail map.
• Fixed bug where groundwater radio buttons were not displayed.
• Correctly display number of boreholes, independently of map appearance.
• Disabled possibility to draw and move point in detail map when borehole is not locked.
• Fixed layout of comments in publication workflow.
• Immediately update tickboxes in admin user role UI.
• Display dropdown with values from schema qt_top_bedrock for attribute qt_depth to streamline all qt drowpdowns
• Display Filter by map in Editor when appearance is Large Map.
• Fixed bug where clicks on clusters or points have been ignored on viewer map.
• Fixed bug where updating of qt_depth led to error.

v2.0.65 - 2022-11-04

Added

• Added this changelog.
• Added new .NET REST API (v2).
• Added new API endpoint (/v2/version).
• Added stable Docker image tags for testing environment.
• Added UI for updating translations of codelists in editor settings.
• Added fake data for development.
• Added version/environment information in feedback e-mail.
• Added version number in web client.
• Added functionality to add instruments without casing.
• Added a new about page in settings containing license information.
• Added automatic release notes for newly created GitHub releases.

Changed

• Updated Dokumentation page in settings.
• Standardized messages for empty profiles, empty casing and missing stratigraphy.
• Updated the app title in the top left to show the new boreholes.swissgeol.ch name including the correct environment.
• Removed Enter as viewer login option.

Fixed

• Added missing option Keine Angabe for layer_striae.
• Fixed blank screen in viewer mode.
• Added missing package to fix Docker health check in production.
• Fixed broken total_depth attribute reference in table.
• Improved stratigraphy viewer.
• Fixed terms of service.
• Always show up to date login screen text.
• Fixed filter dropdowns not updating.
• Fixed appearance setting label.
• Fixed error highlight of identifier fields.
• Fixed bulk edit.
• Fixed sorting in borehole tables in viewer and editor mode.
• Fixed text displayed in backfill tab, when no backfill is available.
• Fixed text displayed in instrument tab, when no instrument is available.
• Fixed dialog message when enabling user.
• Fixed creation of user with admin role.
• Added missing translations when publishing new welcome messages.
• Fixed copying of boreholes.
• Added missing checks for contributions when deleting users.
• Removed obsolete borehole.contact_id column.
• Always displays Show all button when editing instruments.