[Arches] Querying Arches database through QGIS

2017-08-07 Thread M Hobson
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

Re: [Arches] Querying Arches database through QGIS

2017-08-08 Thread M Hobson
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 > wrote: > >> Hello everyone, >> >> I have just joined a projec

Re: [Arches] Querying Arches database through QGIS

2017-08-08 Thread M Hobson
Hello again Adam, Apologies; I read your blog post on my way into work on the train and I missed the part that did indeed answer my original question. Thanks very much. I will try it out and get back to you. Matt -- -- To post, send email to archesproject@googlegroups.com. To unsubscribe, sen

Re: [Arches] Querying Arches database through QGIS

2017-08-11 Thread M Hobson
Just adding an update on this. Firstly, we are struggling to make any progress because an upgrade to Arches v4 is currently being considered by our project team. If that goes forward, it appears that this would be a non-starter as the database in v4 might be stored in such a peculiar way that i

Re: [Arches] Querying Arches database through QGIS

2018-01-17 Thread M Hobson
ld be a great way > to support read-access to Arches data for use in desktop GIS. > > Hope this helps, > > Dennis > > On Friday, August 11, 2017 at 3:35:20 AM UTC-7, M Hobson wrote: >> >> Just adding an update on this. >> >> Firstly, we are struggling to

[Arches] Numeric fields and querying

2018-01-17 Thread M Hobson
Dear all, Is it possible to use and to easily create and query numeric fields within ARCHES v3? I am working for a project at the moment that has been using ARCHES v3 for a number of years and all of the dating is handled as text fields e.g. 'Roman', 'Iron Age' etc. This is causing us problem

[Arches] Re: Numeric fields and querying

2018-01-22 Thread M Hobson
and query on incomplete > dates like -1100 (note the lack of day and month, which would make this a > true date), as well as the uncertainty associated with fuzzy dates. > > Hope this helps. > > Cheers, > > Dennis > > On Wednesday, January 17, 2018 at 1:17:10 AM UT

Re: [Arches] Querying Arches database through QGIS

2018-01-24 Thread M Hobson
We improved the format of our .shp export and implemented an advanced search bar within arches. It’s messy but it kind of works. I never managed to follow your solution because the IT people couldn’t pass the first step of editing the postgres config file to listen for my IP address. -- -- To