Hi Matt, This will depend greatly on what version of Arches you are using. v3 held all geometries for the entire database in a single postgis table, I've connected to that table in QGIS before to make edits just to test, but I think you would want to make some db views that would bring in some extra resource attributes (like name, etc.) and make that single table a little more user-friendly (instead of just a lot of shapes). I wrote this blog post a while ago related to this idea. http://legiongis.com/ using-qgis-geoserver-and-postgis-to-make-and-maintain-arches-overlays.html
In Arches v4, geometries are actually stored along with all other business data in a table of "Tiles". You can see this in the Data Model https://github.com/archesproject/arches/wiki/Data-Model, and the geometries themselves are stored as json objects. So the process of connecting with QGIS would be trickier because there isn't any single postgis table that holds all the feature geometries. Hopefully others from the development team can chime in on this. As far as I can tell, you would have to write some SQL to pull geometries out of the TileInstance table and populate proper geometry tables with them, which you could then connect to with QGIS. Adam On Mon, Aug 7, 2017 at 5:25 AM, M Hobson <[email protected]> wrote: > Hello everyone, > > I have just joined a project that uses Arches for its main database. I am > interested in connecting to the database through QGIS's DB Manager. The > previous project I worked for used this functionality in QGIS very > successfully with a relational SQL database. The project team were able to > write SQL queries and import the results as layers directly into QGIS. > These layers updated automatically when data in the database altered. > > Does anybody have any experience of doing this with an Arches database? Is > it easy to set up? Are there any reading materials about how to write > queries for the Arches database? > > Many thanks in advance for any advice or information offered. > > Matt H > > -- > -- To post, send email to [email protected]. To unsubscribe, > send email to [email protected]. For more > information, visit https://groups.google.com/d/forum/archesproject?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Arches Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
