[Incubator] Resolve overlap and gap in Simple feature by using Postgis Topology

Tue Jul 4 21:01:24 PDT 2023

Hi again.

I follow your idea and we connect them for now, since this may be most  easy way to promote Postgis Topology editing in the short run for those who have data stored as Simple Feature in Postgis Toplogy today and seem like quite a few 🙂 .

Sorry for being back and forth here.

We also some other dependencies like https://github.com/larsop/content_balanced_grid and some more, when I have time I will move this to https://gitlab.com/nibioopensource also.  This repos are just some helper repos  with a couple function used in many other projects at NIBIO.

Thanks .

Lars

________________________________
From: Jody Garnett <jody.garnett at gmail.com>
Sent: Tuesday, July 4, 2023 10:14 PM
To: Lars Aksel Opsahl <Lars.Opsahl at nibio.no>
Cc: incubator at lists.osgeo.org <incubator at lists.osgeo.org>
Subject: Re: [Incubator] Resolve overlap and gap in Simple feature by using Postgis Topology

Lars:

Okay I think you have answered my question; you are proposing two things that are not related in any way?

--
Jody Garnett

On Jul 4, 2023 at 4:50:00 PM, Lars Aksel Opsahl <Lars.Opsahl at nibio.no<mailto:Lars.Opsahl at nibio.no>> wrote:
Hi

Thank's the same, nice talking to you.

That's a good question about connecting this two applications. As today we are not there.

To get there we have to create config file compatible with this format https://gitlab.com/nibioopensource/pgtopo_update_sql/-/blob/develop/doc/APP_CONFIG.md and call function topo_update.app_CreateSchema .

I am not sure if we add to much functionality in to resolve_overlap and gap when doing that, so we may need to discuss where to place functionality like this .  Another option is also to have some kind  off reverse engineering  to make it more easy create app_config.file.

I also had chat when Even Roualt at Foss4g  where he mentioned that he and Sandro Santilli had chat about format for ogr2ogr and Postgis Topology some years ago.

So maybe we can make the connection you suggest at a later stage , when both this two applications are more stable and more set .  Then we also may know what role ogr2ogr can have here.

But for sure, as you suggest we need an easy way to enable the topology_update client for Postgis Topology data that already exists in the database.

Thanks.

Lars

________________________________
From: Jody Garnett <jody.garnett at gmail.com<mailto:jody.garnett at gmail.com>>
Sent: Tuesday, July 4, 2023 1:46 PM
To: Lars Aksel Opsahl <Lars.Opsahl at nibio.no<mailto:Lars.Opsahl at nibio.no>>
Cc: incubator at lists.osgeo.org<mailto:incubator at lists.osgeo.org> <incubator at lists.osgeo.org<mailto:incubator at lists.osgeo.org>>
Subject: Re: [Incubator] Resolve overlap and gap in Simple feature by using Postgis Topology

Lars,

It was a pleasure to meet you last week and thank you for submitting these projects.

I have a question? Can these projects work independently or do they each require each other?

Other projects in this situation (with a client and server half) presented themselves as a framework when being shared with the public:

See https://www.osgeo.org/projects/gc2-vidi/ as an example.

Would this be a suitable approach for resolve overlap and gap and topology_update  applications?
--
Jody Garnett

On Jun 30, 2023 at 7:20:56 PM, Lars Aksel Opsahl <Lars.Opsahl at nibio.no<mailto:Lars.Opsahl at nibio.no>> wrote:
Hi

Incubation committee:

I would like to ask permission to the list the project resolve-overlap-and-gap on the OSGeo website in order to share the work with more people!

In this project we clean up Simple Feature datasets by using Postgis Topology.

The repository is located here: https://gitlab.com/nibioopensource/resolve-overlap-and-gap released using GPL license.

My OSGeo userid is "laopsahl" and I will need permission to create a project page.

Thanks!

Lars

_______________________________________________
Incubator mailing list
Incubator at lists.osgeo.org<mailto:Incubator at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/incubator

________________________________
From: Jody Garnett <jody.garnett at gmail.com>
Sent: Tuesday, July 4, 2023 10:14 PM
To: Lars Aksel Opsahl <Lars.Opsahl at nibio.no>
Cc: incubator at lists.osgeo.org <incubator at lists.osgeo.org>
Subject: Re: [Incubator] Resolve overlap and gap in Simple feature by using Postgis Topology

Lars: