<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12pt;"><div style="font-family : Verdana, Arial, Helvetica, sans-serif; font-size : 12pt;"><div>Hello,<br></div><div><br></div><div>We love QGIS, and have been using it for years, but from a standpoint of a single user developing maps that we share as PDFs, etc. For our production maps, we are using PostGreSQL (without PostGIS) for data, mapping layers via queries to that DB in umap, a middleware project that then displays those layers in Open Street Maps. It's been working pretty well for us despite some bugs (<a href="https://prod.chicommons.coop" target="_blank">https://prod.chicommons.coop</a>), but we want to introduce other views, write articles that point out specific analysis, etc. Also, we want multiple people to have access to the data and map project(s) to produce these views and articles. Here's the use case:<br></div><ul dir="ltr"><li>Use PostGreSQL/PostGIS to store the data (we're finalizing a normalized DB architecture that will be robust enough to capture the information on which we want to focus)<br></li><li>We have an application that allows crowd-sourcing of the data, combined with curation by an admin to ensure that it meets our standards and fits our criteria.<br></li><li>Use QGIS to develop layers querying the DB and views that we want to publish. Ideally, it must allow<br></li><ul><li>Multiple users to be editing the database concurrently<br></li><li>Multiple users to be working on the QGIS project concurrently.<br></li><li>Versioning retaining authority for the master version.<br></li></ul><li>Use QGIS with the leaflet plugin (and potentially other plugins, to be researched and implemented) to publish the views<br></li></ul><div>Our question is how to set up QGIS Server, Desktop, and PostGreSQL/PostGIS to meet these goals.<br></div><ol dir="ltr"><li><div>Should we have individual workers <br></div><ol style="list-style-type : lower-alpha;"><li>use their desktop version and connect to stored projects and shape files in PostGreSQL/PostGIS?<br></li><li>Use their desktop version and connect to QGIS Server?<br></li><li>Use their web browser and connect to the QGIS Server?<br></li></ol></li></ol><div>Thanks for your pointers.<br></div><div><br></div><div class="x_953418240zmail_signature_below"><div id=""><div><span class="size" style="font-size:16px">Steve Ediger<br></span></div><div><span class="size" style="font-size:16px"><br></span></div><div><span class="size" style="font-size:16px">Founding Worker-Owner, ChiCommons LWCA<br></span></div><div><a href="http://www.chicommons.coop" target="_blank"><span class="size" style="font-size:16px">www.chicommons.coop</span></a><span class="size" style="font-size:16px"><br></span></div><div><br></div></div></div><div><br></div></div><br></div><br></body></html>