On Wednesday, 19 March 2025, 10:10:20 CET Stewart Galloway via QGIS-User 
wrote:
> I have data stored on a municipal server.Can I have two users, each on their
> own computer, access the same .QGS project file (as well as the same data
> on the municipal server)?

How is the data stored? Is it in a database already? Is it in a GDB from 
ArcGIS, is it a folder of shapefiles? If it's already in a database, there are 
spatial extensions for quite a few of them, alternatively, you can always 
store the geometry data as WKB or WKT in a 'geometry' column.

If it's in some ESRI/ArcGIS database or a folder of shapefiles, don't touch 
it, these formats are not made for network access and you will eventually 
corrupt all the data!

> Is that what a GeoPackage is for?  Or is
> Geopackage just for the data and not for the project file (QGS)? Or do I
> use PostgreSQL?

Geopackage is built on top of SQLite, a *single* user, embedded database, 
similar to Spatialite, but with a different scope. It is very well suited for 
data exchange, a million times better than shape files. It is mainly for 
storing the data, but you can save the QGIS project file as an extra layer/
table in the database. I use that, when I want to give customers a cleaned up 
QGIS project with all their data in it. You just drag and drop the single 
geopackage into QGIS and the whole project will load with all styles and 
calculations.

I've used it on projects where I was the only one digitizing and editing. 
Multiple users can access it simultaneously, but then it should be read only. 
You can also split up areas in work packages, the 2 users work on it at the 
same time, can see the updates of the other and when you're done, you join the 
layers again.

But, seriously, that is all a crutch. One small mistake and the work of hours 
is gone or, even worse, the whole geopackage is corrupted. For this use case 
you really really want a multi user, relational database with versioning. 
Fortunately, we already have that, it's PostgreSQL with the PostGIS extension! 

Talk to your IT have them set it up for you. If they complain, talk to their 
superior, show them how much money the organization could potentially lose if 
you waste one workday of two employees. 

Best regards
-- 
Tobias A Schula
Forestry Expert

geospat...@schula.org

Attachment: signature.asc
Description: This is a digitally signed message part.

_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to