-
-
Notifications
You must be signed in to change notification settings - Fork 17
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Database Locks on specific workflows with GeoPackage #843
Comments
Thanks for your input. I agree that in this use case one can assume that people want to digitize first the streetaxis (geometrylayer) and then the street. I tested with QGIS 3.28 if I can not reproduce your problem with the Those issues are not directly connected with INTERLIS or Model Baker but with OGR or QGIS. In INTERLIS models and their physical implementations, there are just often lots of relations used, that could lead to issues. PostgreSQL is more stable. An information maybe lacking in the documentation is the one with the transaction mode. This is automatically activated in PostgreSQL and means, that all the changes are commited in one transaction. In GeoPackage this is not activated per default, because in the past it leaded to the issue you describe. If it's not activated you have to save changes on every layer individually. But here you need to be aware that you have to save first the parent features (street) and then the children (steetaxis). Otherwise you get FK errors: Then there is a third possiblity: Buffered Transaction Groups Maybe you can test those modes and give me feedback if there are still problems or not. And don't forget the QGIS version because this is relevant for us. |
Maybe related #807 |
Dear @signedav. Because I am still in education (Geography at UZH) I dont have the background to set up a PostgreSQL Database. I am sure, I can learn this in further semester ^^. In this QGIS version, the Regarding the I try to get a reproducable example that works for most machines. I will get in touch with you in the next days when I found a good way. Thank you again for your fast answer. It is great to have people that take care of their community. |
Dear OpenGISch Team,
Thank you for the great plugin!
I am currently working on a newly created database based on a Interlis file (according to this guide: https://www.opengis.ch/de/2021/12/07/model-baker-6-7-noch-nie-wars-so-einfach/). I use the roads simple from https://www.interlis.ch/downloads/testdatensaetze. I've encountered a bit of a roadblock when it comes to adding points and geometries to an existing Interlis database.
I did not find any good guide how to add points / geometries in an existing interlis database. There seem to be different approaches how to do it:
But when I want to save the current layer, the following error occurs:
Now I am able to save the layers.
I'm wondering if approach number 2 is the recommended way to add points/geometries to an Interlis database. It worked for my current setup, but I'm not sure if it's suitable for more complex Interlis structures.
If this approach makes sense, I'd be happy to contribute to the Model Baker plugin by putting together a tutorial on modifying and creating loaded GeoPackage (gpkg) databases in Interlis format. It seems like there's a bit of a gap in documentation for these processes, and a tutorial could be really helpful for others.
Thanks for your time, and I hope to hear your thoughts soon.
The text was updated successfully, but these errors were encountered: