Hi Martha, yes, here is the link: https://www.legiongis.com/blog/using-qgis-geoserver-and-postgis-to-make-and-maintain-arches-overlays
As you imply, it's out of date and not directly applicable to Arches 4, which doesn't have a table of geometries. To use a strategy like this with Arches 4 you would need to make a new view in postgres which collects the geometries and puts them in a spatial table. However, I believe that would be a read-only situation, so it's really a diminished utility as compared to what is in the blog post for v3. Adam On Thu, Apr 25, 2019 at 7:08 PM Martha S <[email protected]> wrote: > Adam, > > The > https://www.legiongis.com/using-qgis-geoserver-and-postgis-to-make-and-maintain-arches-overlays.html > link is no longer valid; do you have a replacement? I'd like to read this > for background, even though we will be working with v4.4.1. > > Thank you, > Martha > > On Monday, August 7, 2017 at 8:05:32 AM UTC-7, Adam Cox wrote: >> >> 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. > -- -- 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.
