BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.osgeo.org//foss4g-europe-2024//speaker//WJXMV7
BEGIN:VTIMEZONE
TZID:EET
BEGIN:STANDARD
DTSTART:20000101T000000
RRULE:FREQ=YEARLY;BYMONTH=1;UNTIL=20001231T220000Z
TZNAME:EET
TZOFFSETFROM:+0200
TZOFFSETTO:+0200
END:STANDARD
BEGIN:STANDARD
DTSTART:20021027T050000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
TZNAME:EET
TZOFFSETFROM:+0300
TZOFFSETTO:+0200
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20020331T040000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
TZNAME:EEST
TZOFFSETFROM:+0200
TZOFFSETTO:+0300
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-foss4g-europe-2024-F7A7PZ@talks.osgeo.org
DTSTART;TZID=EET:20240703T143000
DTEND;TZID=EET:20240703T150000
DESCRIPTION:This presentation is intended to introduce a project completed 
 at the end of 2023\, during which the Lithuanian National River and Lake C
 adastre (https://uetk.biip.lt/) has been modernized by transferring GIS (a
 nd not only) solutions from commercial software to open source and by exte
 nding automated GIS data processing solutions. During the presentation\, w
 e will share not only the technological solutions we have adopted\, but al
 so our experience in changing the attitude of GIS specialists with experie
 nce of working with commercial GIS software towards open source.\n\nThe ma
 in technological components of the project included the development of a d
 ata management system using PostGIS and QGIS\, the development of a map br
 owser using openlayers and Vue JS (available as an open source project - h
 ttps://github.com/AplinkosMinisterija/biip-maps-web)\, and the development
  of a service publishing solution based on QGIS Server. The project used D
 ocker technology and GitHub action-based continuous deployment (CD) soluti
 ons\, which should also be relevant to the audience.\n\nMany of us know th
 at building a system from the ground up is often much easier than upgradin
 g an existing system that has been in place for a long time but has not be
 en updated. This was the case for the National River and Lakes Cadastre as
  well. This process is particularly challenging when it comes to the moder
 nisation of national information systems and cadastres\, which are often s
 ubject to quite strict legislative control. There are also a number of cha
 llenges at the technical level: 1) old and outdated software that cannot b
 e upgraded without overhauling the system\, 2) integrations with other sys
 tems\, 3) old infrastructure\, 4) code that is closed and unmanageable by 
 the organization\, and 5) users who are working with the data\, who are ch
 allenged by the new solutions. This is exactly the same set of problems th
 at awaited the modernisation of the Lithuanian National Cadastre of Rivers
  and Lakes\, managed by the Environmental Protection Agency.\n\nThe Lithua
 nian National Cadastre of Rivers and Lakes is a system for collecting\, or
 ganizing and making available to other information systems and to the publ
 ic data on rivers\, lakes\, ponds\, as well as hydraulic engineering struc
 tures such as hydroelectric power plants\, overflow culverts\, fish ladder
 s\, fish passes\, research stations\, etc. The cadastre consists of three 
 major components: the administration of GIS data\, the publishing and view
 ing of online map services\, and the provision of e-services (extracts\, s
 tatistics). This cadastre is of particular importance as it is not only es
 sential for the monitoring of the hydrographic network\, but also for the 
 protection of these features and the restriction of agricultural activitie
 s.\n\n\nThe digital cadastre of rivers and lakes was launched almost 10 ye
 ars ago\, and at that time it was one of the largest GIS projects in Lithu
 ania. The cadastre was implemented using only commercial software: ArcGIS 
 (ArcMap\, ArcGIS Server\, ArcGIS JS api)\, Oracle\, Alfresco (document man
 agement system)\, etc. Over time\, the Environment Agency has been unable 
 to upgrade the software of these systems due to licensing costs\, and has 
 lost support as a result. The system soon showed its weaknesses: the syste
 m's availability was unacceptable (the load time of web map was 1 minute a
 t peak times)\, the incorrectly implemented database structure led to a la
 rge number of errors\, as the data was administered using a programmed plu
 g-in in the ArcMap environment\, any changes were difficult to implement a
 nd in practice were difficult to support due to the old code and outdated 
 versions of ArcMap software.\n\nWe came into the modernisation project wit
 h the basic idea of migrating the core functionality to open source soluti
 ons\, i.e. migrating exactly what is being used and not bloated with legac
 y software solutions. In this presentation\, we will share these insights 
 from the project:\n- Use of PostGIS for automated data filling\, e.g. auto
 mated analysis of river tributaries\, lengths\, distances to parent river 
 headwaters\, etc. All of this is realized with the help of PostGIS functio
 ns\;\n- Database structure and use to ensure data integrity\;\n- Creating 
 a map browser using OpenLayers and Vue JS as a reusable component that now
  serves also for other informational systems\;\n- Use of QGIS server and D
 ocker\;\n- GitHub and continuous deployment to dev\, staging and productio
 n environments.
DTSTAMP:20260722T144332Z
LOCATION:GEOCAT (301)
SUMMARY:Modernizing the National River and Lakes Cadastre by Transition to 
 FOSS4G - Andrius Balciunas
URL:https://talks.osgeo.org/foss4g-europe-2024/talk/F7A7PZ/
END:VEVENT
END:VCALENDAR