Re: [Qgis-user] Using expression dialog to access attributes from a relation.
Hi Andrew, you can use the relation_aggregate expression to concatenate the child items, something like: relation_aggregate('my_relation','concatenate', "child_attribute", concatenator:=',') just see the help for relation_aggregate in the expression builder. bests regards Stefan --- Mit freundlichen Grüßen Stefan Giese Projektleiter/Consultant *** Where2B Konferenz 2018 13. Dezember 2018 im Universitätsclub Bonn Anmeldung & Infos: https://where2b-conference.com/ *** WhereGroup GmbH & Co. KG Schwimmbadstr. 2 79100 Freiburg Germany Fon: +49 (0)761 / 519 102 - 61 Fax: +49 (0)761 / 519 102 - 11 stefan.gi...@wheregroup.com www.wheregroup.com Amtsgericht Bonn, HRA 6788 --- Komplementärin: WhereGroup Verwaltungs GmbH vertreten durch: Olaf Knopp, Peter Stamm --- Am 2018-12-13 17:11, schrieb Andrew Bell: I have spatial layer and non-spatial layer set up as a relation QGIS 3.4. The non-spatial layer is the child. I'm trying create a display pop-up for the spatial layer that sources attributes and values from the relation layer. I can see the relation is an option in the expression dialog but at the moment I cannot see how I'm going to bring through field names and values from this other table. Has anyone done this and have any pointers they could share? Many thanks Andrew ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS 3.4.2 still very slow to work in Windows 10
Hi, I'm using QGIS on Windows a lot and cannot confirm issues with slow startup in 3.4. The Windows version is consistently on par with the Linux version. (Notable exceptions in version 2 were the globe extension and R support which I couldn't get to work back then.) The incorrect description of the current node tool behavior unfortunately slipped by Andrew and me when updating Learning QGIS. We're very sorry about that. We're working with the publisher to get a correction out. Regards Anita ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS 3.4.2 still very slow to work in Windows 10
As far as I know, development is done mainly in Linux The Windows and Mac editions are ports off this. I am sure the developers and port teams do their best but you can run into issues that are platform specific and are hard to resolve. Particularly as it is dependent on third party libraries that again may be less well supported on all the platforms. I haven't used Qgis on Windows in a number of years, this is why I would suggest virtualisation of a Linux environment as an option, the virtual machines when I ran them could do 99% of what you could expect in a native installation and were pretty solid as a working environment. You would probably find that to be a more stable way of running Qgis 3 on Windows, if that were an option for you. On 14/12/18 5:40 AM, David Addy wrote: Hi Patrick, Thanks for your comments. It all helps to encourage me. I have now discovered that the User Manual (development version) emphasises the fact that there are changes to the node tool in version 3, and how the dragging of the old method is now replaced by two clicks. Anita's book does not mention this, so I was still trying to move a node in the "old way". Like you I do not want to go back to 2.18, and I believe in learning the new workflows of version 3 ASAP. So now I have edited my polygons, but when I come to save the changes I am still getting a long pause when nothing happens, then I get "QGIS is not responding", then it comes back to life again and finishes the save. It must still be an issue with the latest QT 5.11.2, n'est ce pas? I have had a look at the QT website and I note that there are a few users complaining about unfixed bugs that go back for ages. -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Using expression dialog to access attributes from a relation.
Yeah, You can do this with the relation_aggregate function. It aggregates values from all related records using a field or expression. Ive only used the "concatenate" aggregate for returning strings from the related table but there are other options if you want to return an average, sum, string length, etc. I think the help covers the use pretty well, but if you run into trouble I can give more specific help, Andrew ‐‐‐ Original Message ‐‐‐ On Thursday, December 13, 2018 8:11 AM, Andrew Bell wrote: > I have spatial layer and non-spatial layer set up as a relation QGIS 3.4. > The non-spatial layer is the child. > > I'm trying create a display pop-up for the spatial layer that sources > attributes and values from the relation layer. > > I can see the relation is an option in the expression dialog but at the > moment I cannot see how I'm going to bring through field names and values > from this other table. > > Has anyone done this and have any pointers they could share? > > Many thanks > > Andrew___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS 3.4.2 still very slow to work in Windows 10
Hi Patrick, Thanks for your comments. It all helps to encourage me. I have now discovered that the User Manual (development version) emphasises the fact that there are changes to the node tool in version 3, and how the dragging of the old method is now replaced by two clicks. Anita's book does not mention this, so I was still trying to move a node in the "old way". Like you I do not want to go back to 2.18, and I believe in learning the new workflows of version 3 ASAP. So now I have edited my polygons, but when I come to save the changes I am still getting a long pause when nothing happens, then I get "QGIS is not responding", then it comes back to life again and finishes the save. It must still be an issue with the latest QT 5.11.2, n'est ce pas? I have had a look at the QT website and I note that there are a few users complaining about unfixed bugs that go back for ages. -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Using expression dialog to access attributes from a relation.
I have spatial layer and non-spatial layer set up as a relation QGIS 3.4. The non-spatial layer is the child. I'm trying create a display pop-up for the spatial layer that sources attributes and values from the relation layer. I can see the relation is an option in the expression dialog but at the moment I cannot see how I'm going to bring through field names and values from this other table. Has anyone done this and have any pointers they could share? Many thanks Andrew___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS SERVER 3.4.2 - download WFS GetFeature result as Shapefile
Alessandro Pasotti-2 wrote > On Thu, Dec 13, 2018 at 3:02 PM umbertofilippo < > umbertofilippo@ > > > wrote: > >> umbertofilippo wrote >> > Is it possible to do it somewhere in the server >> > configurations, or should I implement it myself? >> >> Replying myself with some findings. >> I guess, if it is not feasible QGIS Server side, I can implement it with >> ogr2ogr, or maybe use something already done (like >> https://github.com/3liz/qgis-wfsOutputExtension, although this probably >> won't work for version 3.x?). >> >> Any hints is more than welcome! >> > > > That's he way to go: a server plugin will do just fine. > > If it doesn't work for 3.x it shouldn't be hard to port it. > > -- > Alessandro Pasotti > w3: www.itopen.it > > ___ > Qgis-user mailing list > Qgis-user@.osgeo > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user Thanks Alessandro, another thing I found which look really promising is this one: https://gis.stackexchange.com/a/181598/9518 https://www.gdal.org/drv_wfs.html Basically, ogr2ogr can connect to a OGC WFS server and export direclty into an output like shapefile. Will probably test one of the two options and will report back my results if I'm successful. -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS SERVER 3.4.2 - download WFS GetFeature result as Shapefile
On Thu, Dec 13, 2018 at 3:02 PM umbertofilippo wrote: > umbertofilippo wrote > > Is it possible to do it somewhere in the server > > configurations, or should I implement it myself? > > Replying myself with some findings. > I guess, if it is not feasible QGIS Server side, I can implement it with > ogr2ogr, or maybe use something already done (like > https://github.com/3liz/qgis-wfsOutputExtension, although this probably > won't work for version 3.x?). > > Any hints is more than welcome! > That's he way to go: a server plugin will do just fine. If it doesn't work for 3.x it shouldn't be hard to port it. -- Alessandro Pasotti w3: www.itopen.it ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS SERVER 3.4.2 - download WFS GetFeature result as Shapefile
umbertofilippo wrote > Is it possible to do it somewhere in the server > configurations, or should I implement it myself? Replying myself with some findings. I guess, if it is not feasible QGIS Server side, I can implement it with ogr2ogr, or maybe use something already done (like https://github.com/3liz/qgis-wfsOutputExtension, although this probably won't work for version 3.x?). Any hints is more than welcome! -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS SERVER 3.4.2 - download WFS GetFeature result as Shapefile
Hello All, I am trying to find a way to download the features from a WFS coming from a QGIS SERVER I own as Shapefile format. The Capabilities are these: https://www.wondermap.it/cgi-bin/qgis_mapserv.fcgi?&map=/home/ubuntu/qgis/projects/Demo_sci_WMS/demo_sci.qgs&SERVICE=WFS&VERSION=1.1.0&REQUEST=GetCapabilities. From those, I can see the "outputFormat" of the "GetFeature" request looks like this: text/xml; subtype=gml/2.1.2text/xml; subtype=gml/3.1.1application/vnd.geo+json , so I guess I cannot do something like "&outputFormat=Shapefile". Is there a way I can retrieve my data as Shapefile (most likely downloading it as a zipped file)? Is it possible to do it somewhere in the server configurations, or should I implement it myself? Any help would be very appreciated. Thanks! Umberto -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] FW: associate images with a shape file
From: Philip Barlow Sent: 13 December 2018 09:09 To: 'Dave Ormerod' Subject: RE: associate images with a shape file Hi David, You can achieve the opening and previewing of images from within a feature form in QGIS. Head over to the properties of your layer, select "attributes form" and select the field that has your image path in. From the "widget type" drop down on the right select "attachement". Now scroll to the bottom of the widget box and you'll see "integrated document viewer", choose image. This will provide a preview of the image in the feature form. Just above "integrated document viewer" you will see a tick box that says "user hyperlink for document path", tick that. Now you will have a feature form that has a hyperlink users can click to open the image as well as a preview of the image. Hope that helps Phil From: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Dave Ormerod Sent: 13 December 2018 00:25 To: qgis-user@lists.osgeo.org Subject: [Qgis-user] associate images with a shape file Hi I want to associate images with a shape file which I can then open. I am trying to use actions to do this but am not getting anywhere. I have a field with the file location as a text field. I have tried an open file and also tried running an application neither of which seem to produce a result. It works on a Mac but not on Windows 10? I am running version 3.4. Thanks David Mae'r Awdurdod yn hapus i gyfathrebu yn Gymraeg neu yn Saesneg The Authority is happy to communicate in Welsh or English *** Website www.pembrokeshirecoast.org.uk Follow us on Twitter Join us on Facebook Watch us on Youtube Look at us on Flickr This email and any attached files should only be read by those persons to whom they are addressed and be used by them only for their intended purpose. If you are not the intended recipient please destroy all copies and inform the sender by return email. Please note that the contents of this email may be subject to public disclosure under the Freedom of Information Act 2000 and therefore the confidentiality of this message and any reply cannot be guaranteed. Click here to view PCNPA Privacy Notice Keeping your Information Safe For further information on the PCNPA please visit our website at www.pembrokeshirecoast.org.uk Please consider the environment before printing this email. Dim ond y personau hynny yr anfonwyd yr e-bost hwn atynt ac unrhyw ffeiliau sydd ynghlwm ddylid eu darllen, a dim ond hwy ddylid eu defnyddio at y diben y bwriadwyd hwy. Os nad y chi yw'r person y bwriadwyd eu derbyn a fyddech gystal â dinistrio pob copi a rhoi gwybod i'r anfonwr gyda throad yr e-bost. Noder os gwelwch yn dda y gall cynnwys yr e-bost hwn orfod cael ei ddatgelu i'r cyhoedd o dan Deddf Rhyddid Gwybodaeth 2000 ac felly ni ellir gwarantu cyfrinachedd y neges hon nac unrhyw ateb. Cliciwch yma i weld Hysbysiad Preifatrwydd APCAP - Cadw eich Gwybodaeth yn Ddiogel Am ragor o wybodaeth am APCAP ymwelwch â'n gwefan ar www.arfordirpenfro.org.uk Ystyrier yr amgylchedd cyn argraffu'r e-bost hwn os gwelwch yn dda. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user