Martha, I just reread that blog post and realized that I mischaracterized it in my comments above. I was thinking of it as if it was about Arches data geometries, not overlay geometries. I'd say that by and large the entire post is relevant to v4, though I'm not sure off the top of my head if there is an aux schema still, or everything is just in the public schema.
Indeed, the biggest difference is probably the last step, because adding overlays is completely different in v4. Refer to the geoserver example in here: https://github.com/legiongis/arches4-geo-examples#using-the-tileserver-to-cascade-a-wms Adam On Fri, Apr 26, 2019 at 9:43 AM Adam Cox <mr.adam...@gmail.com> wrote: > 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 <martha.se...@lacity.org> 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 <matthew...@gmail.com> 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 arches...@googlegroups.com. To unsubscribe, >>>> send email to arches...@googlegroups.com. 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 arches...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> -- To post, send email to archesproject@googlegroups.com. To >> unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. >> 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 archesproject+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > -- -- To post, send email to archesproject@googlegroups.com. To unsubscribe, send email to archesproject+unsubscr...@googlegroups.com. 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 archesproject+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
