Lars Aksel Opsahl
Sjefingeniør
(+47) 911 97 964
lars.opsahl@nibio.no
Sted
Ås - Bygg O43
Besøksadresse
Oluf Thesens vei 43, 1433 Ås (Varelevering: Elizabeth Stephansens vei 23)
Sammendrag
Rapporten dokumenterer et forslag til økosystemkart for Norge på oversiktsnivå, basert på en kombinasjon av arealressurskartet AR50 og utvalgte data fra topografisk kart (N50) og Fjordkatalogen. Klassifikasjonssystemet for økosystemkartet er basert på nivå 1 i Eurostats økosystemtypologi.
Sammendrag
Rapporten dokumenterer første utgave av hovedøkosystemkart for Norge. Kartet er basert på en kombinasjon av arealressurskartet AR50 og utvalgte data fra topografisk kart (N50). Klassifikasjons-systemet for økosystemkartet er basert på nivå 1 i Eurostats økosystemtypologi. Kartet er en videre-utvikling av testversjon (MVP) publisert i forsommeren 2023.
Foredrag – More correct maps/data with Postgis Topology rather then Simple Feature
Lars Aksel Opsahl
Forfattere
Lars Aksel OpsahlSammendrag
In Norway we now get more up-to-date maps for land resource map (AR5), because the domain experts on agriculture in the municipalities in Norway have got access to a easy to use client. This system includes a simple web browser client and a database built on Postgis Topology. In this talk we will focus on, what is it with Postgis Topology that makes it easier to build user friendly and secure tools for updating of land resource maps like AR5. We will also say a couple of words about advantages related to traceability and data security, when using Postgis Topology. In another project, where we do a lot ST_Intersection and ST_Diff on many big Simple Feature layers that covers all of Norway, we have been struggling with Topology exceptions, wrong results and performance for years. Last two years we also tested JTS OverlayNG, but we still had problems. This year we are switching to Postgis Topology and tests so far are very promising. We also take a glance on this project here in this talk. A Postgis Topology database modell has normalised the data related to borders and surfaces as opposed to Simple Feature where this is not the case. Simple Feature database modell may be compared to not using foreign keys between students and classes in a database model, but just using a standard spreadsheet model where each student name are duplicated in each class they attend. URL’s that relate this talk https://gitlab.com/nibioopensource/pgtopo_update_gui https://gitlab.com/nibioopensource/pgtopo_update_rest https://gitlab.com/nibioopensource/pgtopo_update_sql https://gitlab.com/nibioopensource/resolve-overlap-and-gap
