Thanks, Adam. I'm on it. Martha
On Friday, April 26, 2019 at 7:52:54 AM UTC-7, Adam Cox wrote: > > 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 <[email protected] <javascript:>> > 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 <[email protected] >> <javascript:>> 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] <javascript:>. To >>> unsubscribe, send email to [email protected] <javascript:>. >>> 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] <javascript:>. >>> 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.
