Multiuser Editing with QGIS and PostGIS in an Enterprise Environment

Multiuser editing is a fundamental requirement for an enterprise GIS and it is easily achievable with an open source GIS stack. In its simplest form, multiuser editing includes the ability to define various users or groups within an organization and grant certain types of permissions for each, such as read-only, editing, or administration rights. It is a way to control how data are accessed and maintained within the organization, and therefore it is critical to maintaining the integrity of mission critical data. Combining QGIS and PostGIS gives GIS administrators the ability to configure a robust, scalable multiuser environment that includes all of these capabilities. This webinar will introduce viewers to the following concepts and features:
- User and group role management in PostgreSQL;
- Schema, table, and field permissions;
- Row-level security in a multiuser environment;
- Default permissions in PostgreSQL;
- Centralized QGIS symbology and projects;
- Data auditing;
For more webinars, visit lunageo.com/we...

[@Davidkiania]

This is super awesome and I love the walk through, know exactly where to start. Much apprectiated.

[@mandata143]

Shhhessh. I didn't know this might be useful in all forms of databases.

[@MounkailaGarba-kl6rq]

merci

[@geoplandigital2640]

Great job! Whats important to know when DBMS lets say PgAdmin is used in a multyuser environment? are there any other programs that need to be installed or is it just as simple as installing DBMS on a shared server (and obviously instead of localhost entering a path to a server location for every single connection). Thanks!

[@mandata143]

Question: If happens that you have a whole cadastral plan in CAD as dwg file and you purposely wanted to integrate it inside the QGIS as part of database. You need to import it one by one or you just need the description to run?

[@NeverTakeNoShortcuts]

Can you use PostGIS as the foundation of a large scale enterprise GIS, yes. Should you? Well, that's a VERY different question.

[@lunageospatial]

The answer is yes! We deploy PostgreSQL/PostGIS databases and cloud-based servers to clients of various sizes, from small teams (

[@NeverTakeNoShortcuts]

@@lunageospatial 100 GIS transactional postGIS long-transaction users ? (viewer don't count) Can you name the organizations?
Of course it could be done, but skills and educational/documentation collateral for supporting an enterprise openGIS are just not there. Also, many many corporate CISOs refuse to allow QGIS on desktops (or QGIS Server) It's just a fact.

[@lunageospatial]

​@@NeverTakeNoShortcuts We talk a lot about the various myths of open source GIS. One of the biggest myths is that there is a lack of documentation, support, and training for enterprise clients. Not only is there exceptional documentation for most mature GIS software (e.g. QGIS, PostGIS, Geoserver), there is also a wealth of other resources out there -- books, training courses, professional support. One thing we do at LunaGeo is help clients migrate to open source GIS by offering implementation consultation, training for basic and advanced end users, and ongoing support. However, if a company flat out refuses to consider open source GIS, it is simply their loss. If big cities like Toronto can use open source GIS and many governments, including various branches of the Canadian, US, NZ, Austrialan governments, it not out of reach for any company.