[Qgis-user] libgsl0ldbl
Hi folk, and again, updating results in lost QGIS on Ubuntu/Mint with ubuntugis This time its complaining about libgsl0ldbl Anyone else facing this issue? Solutions? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Shapefile with file .cpg(codepage)
Hi Even, the encoding is often a source of confusion. I work in a mixed environment, me on Linux (so UTF-8 is the "System"-default), the rest is using on Windows (with Windows-1252 I assume) Transfering shapes often results in crippled data, and I have not found workflows/settings that this will not happen. Is there anything I can do about it, so we do not have to adjust things manually all the time, or first look if the codepage is correctly set ? Cheers Bernd Am 07.07.2016, 12:58 Uhr, schrieb Even Rouault : Le jeudi 07 juillet 2016 12:16:17, Andrea Peri a écrit : Hi, I have some shapefiles with an extra file having extension .cpg. The .cpg extension is a optional extension for declaration of Code-Page. Is this file knowed and supported from QGIS 2.14. ? I don't know if the qgis when loading a shapefile is using the ogr or instead is using an own shapefile provider, but however I don't know if gdal is knowing and using this .cpg file. Andrea, OGR does use the .cpg file when present (I'm just updating http://gdal.org/drv_shapefile.html since it only mentions the reading of the codepage byte in the DBF header, but the .cpg presence overrides that) and QGIS uses OGR to read shapefiles. But, in QGIS, the default behaviour is to make OGR *not* use the encoding detected by the OGR shapefile driver and use instead the user defined encoding in the GUI. Unless you go to Settings / Options / Data Sources and uncheck the "Ignore shapefile encoding declaration", in which case OGR will manage the transcoding itself. Even -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Problems with ubuntu-unstable again
Hi, some days ago, I updated to 2.16 from the repositories. Everything worked fine. Then yesterday, an update for saga came in. Checked today, saga is not working in the toolbox. Removing, reinstalling, fiddling, disabling/enabling ubuntu-unstable etc etc -> finally ending up again in a situation with no working grass and saga in the toolbox. Using Linux Mint 17 Anyone an idea how to solve this, or is it just again waiting till things get sorted out by itself in some weeks? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problems with ubuntu-unstable again
Hi Angelos, thanx for the information! Will the rebuilding be triggered automatically, or do I have to "trigger" someone to have a look at it ? Cheers Bernd Am 15.07.2016, 17:31 Uhr, schrieb Angelos Tzotsos : Hi Bernd, Yesterday, GDAL 2.1.0 landed on UbuntuGIS Unstable (Trusty), so packages on repositories depending on UbuntuGIS will need to be re-built. Best, Angelos On 07/15/2016 04:23 PM, Bernd Vogelgesang wrote: Hi, some days ago, I updated to 2.16 from the repositories. Everything worked fine. Then yesterday, an update for saga came in. Checked today, saga is not working in the toolbox. Removing, reinstalling, fiddling, disabling/enabling ubuntu-unstable etc etc -> finally ending up again in a situation with no working grass and saga in the toolbox. Using Linux Mint 17 Anyone an idea how to solve this, or is it just again waiting till things get sorted out by itself in some weeks? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problems with ubuntu-unstable again
Hi Jürgen, thanks for the reply. Ok, as I understood your words, I disabled ubuntugis and enabled instead: deb http://qgis.org/ubuntugis-nightly-release trusty main deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu trusty main But still, QGIS will not install: bernd@bernd-TERRA-PC ~ $ sudo apt-get install qgis Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: qgis : Depends: libgdal.so.1-1.11.2 Depends: libgdal1h (>= 1.8.0) but it is not going to be installed Depends: libqgis-analysis2.16.0 but it is not going to be installed Depends: libqgis-app2.16.0 but it is not going to be installed Depends: libqgis-core2.16.0 but it is not going to be installed Depends: libqgis-gui2.16.0 but it is not going to be installed Depends: libqgis-networkanalysis2.16.0 but it is not going to be installed Depends: python-qgis (= 1:2.16.0+git20160712+1b016e4+20trusty-ubuntugis) but it is not going to be installed Depends: qgis-providers (= 1:2.16.0+git20160712+1b016e4+20trusty-ubuntugis) but it is not going to be installed E: Unable to correct problems, you have held broken packages. Actually, I do not intend to have something "unstable" or exotic, but simply just the same flavour as when I use the OSGEO4W-installer on Windows. Even after years, I can't figure out from the help pages what all the stuff means and how things have to be handled in case something doesn't work (which happens actually at each change of version, but the way to resolve this seems to be different every time). Thankful for any hint Bernd Am 15.07.2016, 21:28 Uhr, schrieb Jürgen E. Fischer : Hi Bernd, On Fri, 15. Jul 2016 at 18:36:06 +0200, Bernd Vogelgesang wrote: Will the rebuilding be triggered automatically, or do I have to "trigger" someone to have a look at it ? No, the dependencies are not actively tracked and therefore no automatic rebuilds are triggered. But the nightlies are rebuilt with current dependencies whenever a commit (backport) has happened in the meantime. So you can resort to those for "unstable" distributions (ie. distributions that have changed between releases). The next regular rebuild is on 29.7. for the 2.14.1 and 2.16.1 point releases. Jürgen -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problems with ubuntu-unstable again
Hi all, now I enabled http://qgis.org/ubuntugis-ltr and I face the same problems as below, but only for 2.14 version now. Is there any way to install a recent QGIS with my beloved ubuntugis features from the repositories, or is this just a local problem? I need to get this up and running as I would like to do some work ... Cheers Bernd Am 16.07.2016, 15:11 Uhr, schrieb Bernd Vogelgesang : Hi Jürgen, thanks for the reply. Ok, as I understood your words, I disabled ubuntugis and enabled instead: deb http://qgis.org/ubuntugis-nightly-release trusty main deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu trusty main But still, QGIS will not install: bernd@bernd-TERRA-PC ~ $ sudo apt-get install qgis Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: qgis : Depends: libgdal.so.1-1.11.2 Depends: libgdal1h (>= 1.8.0) but it is not going to be installed Depends: libqgis-analysis2.16.0 but it is not going to be installed Depends: libqgis-app2.16.0 but it is not going to be installed Depends: libqgis-core2.16.0 but it is not going to be installed Depends: libqgis-gui2.16.0 but it is not going to be installed Depends: libqgis-networkanalysis2.16.0 but it is not going to be installed Depends: python-qgis (= 1:2.16.0+git20160712+1b016e4+20trusty-ubuntugis) but it is not going to be installed Depends: qgis-providers (= 1:2.16.0+git20160712+1b016e4+20trusty-ubuntugis) but it is not going to be installed E: Unable to correct problems, you have held broken packages. Actually, I do not intend to have something "unstable" or exotic, but simply just the same flavour as when I use the OSGEO4W-installer on Windows. Even after years, I can't figure out from the help pages what all the stuff means and how things have to be handled in case something doesn't work (which happens actually at each change of version, but the way to resolve this seems to be different every time). Thankful for any hint Bernd Am 15.07.2016, 21:28 Uhr, schrieb Jürgen E. Fischer : Hi Bernd, On Fri, 15. Jul 2016 at 18:36:06 +0200, Bernd Vogelgesang wrote: Will the rebuilding be triggered automatically, or do I have to "trigger" someone to have a look at it ? No, the dependencies are not actively tracked and therefore no automatic rebuilds are triggered. But the nightlies are rebuilt with current dependencies whenever a commit (backport) has happened in the meantime. So you can resort to those for "unstable" distributions (ie. distributions that have changed between releases). The next regular rebuild is on 29.7. for the 2.14.1 and 2.16.1 point releases. Jürgen -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problems with ubuntu-unstable again
Hi Angelos, thanx a lot for the hint. It works! This is now indeed the third variation of a working setup in a row. We already had to enable three repositories, then two, and now it's only one. Unfortunately the instructions on the download page never manage to reflect those changes. Cheers Bernd Am 17.07.2016, 21:36 Uhr, schrieb Angelos Tzotsos : Hi Bernd, This will get you to a working setup: 1. Please remove all previous installed versions with apt-get purge qgis 2. Enable only UbuntuGIS-Unstable and remove all other ppa's 3. apt-get install qgis. This will get you QGIS 2.14.3. I have several reports that this works fine. Best, Angelos On 07/17/2016 09:47 PM, Bernd Vogelgesang wrote: Hi all, now I enabled http://qgis.org/ubuntugis-ltr and I face the same problems as below, but only for 2.14 version now. Is there any way to install a recent QGIS with my beloved ubuntugis features from the repositories, or is this just a local problem? I need to get this up and running as I would like to do some work ... Cheers Bernd Am 16.07.2016, 15:11 Uhr, schrieb Bernd Vogelgesang : Hi Jürgen, thanks for the reply. Ok, as I understood your words, I disabled ubuntugis and enabled instead: deb http://qgis.org/ubuntugis-nightly-release trusty main deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu trusty main But still, QGIS will not install: bernd@bernd-TERRA-PC ~ $ sudo apt-get install qgis Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: qgis : Depends: libgdal.so.1-1.11.2 Depends: libgdal1h (>= 1.8.0) but it is not going to be installed Depends: libqgis-analysis2.16.0 but it is not going to be installed Depends: libqgis-app2.16.0 but it is not going to be installed Depends: libqgis-core2.16.0 but it is not going to be installed Depends: libqgis-gui2.16.0 but it is not going to be installed Depends: libqgis-networkanalysis2.16.0 but it is not going to be installed Depends: python-qgis (= 1:2.16.0+git20160712+1b016e4+20trusty-ubuntugis) but it is not going to be installed Depends: qgis-providers (= 1:2.16.0+git20160712+1b016e4+20trusty-ubuntugis) but it is not going to be installed E: Unable to correct problems, you have held broken packages. Actually, I do not intend to have something "unstable" or exotic, but simply just the same flavour as when I use the OSGEO4W-installer on Windows. Even after years, I can't figure out from the help pages what all the stuff means and how things have to be handled in case something doesn't work (which happens actually at each change of version, but the way to resolve this seems to be different every time). Thankful for any hint Bernd Am 15.07.2016, 21:28 Uhr, schrieb Jürgen E. Fischer : Hi Bernd, On Fri, 15. Jul 2016 at 18:36:06 +0200, Bernd Vogelgesang wrote: Will the rebuilding be triggered automatically, or do I have to "trigger" someone to have a look at it ? No, the dependencies are not actively tracked and therefore no automatic rebuilds are triggered. But the nightlies are rebuilt with current dependencies whenever a commit (backport) has happened in the meantime. So you can resort to those for "unstable" distributions (ie. distributions that have changed between releases). The next regular rebuild is on 29.7. for the 2.14.1 and 2.16.1 point releases. Jürgen -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Limiting File Choices
Hi, when you the click "Add vector" button, the file browser will first be defaulted to show all files in the folder. Once you change this in the drop-down at the bottom in "Files of type:" from "All files" to ESRI shapefiles", it will filter to show only .shp. The dialog will remember this setting. Cheers Bernd Am 17.07.2016, 23:02 Uhr, schrieb Michael Jabot : I am working with elementary students in using QGIS to develop spatial reasoning. I have created .shp files for them to use but when they go to the folder to add the .shp, all the supporting files are also present, >so we are struggling. Is there a way to set the settings so that only the .shp appears as an option to them? Thank you in advance for your help and I apologize if this is a silly question Mike Jabot -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Problems with ubuntu-unstable again
Hi Richard, Am 18.07.2016, 10:13 Uhr, schrieb Richard Duivenvoorde : On 17-07-16 22:42, Bernd Vogelgesang wrote: Hi Angelos, thanx a lot for the hint. It works! This is now indeed the third variation of a working setup in a row. We already had to enable three repositories, then two, and now it's only one. Unfortunately the instructions on the download page never manage to reflect those changes. I think they do, (or at least we try) but for Ubuntu/Debian there are just a lot of possible options, and trying to describe that clearly [0] apparently does not make it really easier, just because of all the possible options and/or combinations. The download page for debian/ubuntu reflects the coders motto: Minimize the code! But people who are not used to read code have really difficulties getting the picture there. 1. I am confident, that the biggest part of Ubuntu users would like to have a release with the same features as they have if using the installer on Windows. The offered release (http://qgis.org/debian) does not do this. This is not mentioned anywhere that it lacks features. People have to find out by themselves. 2. "Release with ubuntugis dependencies" is as cryptic as it can be. But it is simply the version most people expect to receive. A full sentence of what the differences between the repositories are would not let the page explode. Maybe mention that MrSID and ECW is not supported in contrary to Windows due to legal issues (and that you have to compile stuff to get it) 3. The instructions to add the ubuntugis functions are outdated for several releases already. I remember it worked with the ubuntugis-repository plus the ppa. The next version, I had to add as well the debian-repository. The next time, I had to remove debian again. Now it seems it works with the ubuntugis repository only, and no ppa. If you do not give those explanations, where should they come from then? Have mercy and simply add more text. Form follows function. If the function breaks the form of the page, then maybe change the design. I love QGIS and appreciate all your work! Bernd If somebody comes up with a better text, please do. Maybe split up Ubuntu and Debian in two different blocks? And as usual: not working (for you?) please provide a full better working alternative :-) we are happy to add information that would make it more clear. Regards, Richard Duivenvoorde [0] http://qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] EPSG of data from Manifold?
Hi, we just received some shapes accompanied by an xml and no prj. So far I was out of luck finding the proper projection for this, but I'm guessing that this stuff is from Manifold (my first contact with that) Can anyone tell me from the xml what would be the related EPSG code for this data? Orthographic World Geodetic 1984 (WGS84) Orthographic Meter 6.37813700e+006 8.1819190842621486e-002 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 1.e+000 3.17500700e+000 1.e+000 3.17500700e+000 0.e+000 4.393181425026e+006 0.e+000 5.437772499972e+006 0.e+000 0.e+000 Thanx a lot Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] EPSG of data from Manifold?
Am 19.07.2016, 21:19 Uhr, schrieb Nicolas Cadieux : Tried looking for it but no luck. It would help if you could say where the data is supposed to be. Then you could try to look in >www.epsg-registry.org . Nicolas Hi Nicolas, thanks a lot for trying. The shapes are situated around Gunzenhausen in Germany. Cheers Bernd On Jul 19, 2016 2:48 PM, "berndv. [via OSGeo.org]" <[hidden email]> wrote: Hi,we just received some shapes accompanied by an xml and no prj.So far I was out of luck finding the proper projection for this, but I'm guessing that this stuff is from Manifold (my first contact with that) Can anyone tell me from the xml what would be the related EPSG code for this data? Orthographic World Geodetic 1984 (WGS84) Orthographic Meter 6.37813700e+006 8.1819190842621486e-002 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 1.e+000 3.17500700e+000 1.e+000 3.17500700e+000 0.e+000 4.393181425026e+006 0.e+000 5.437772499972e+006 0.e+000 0.e+000 Thanx a lotBernd --Bernd VogelgesangSiedlerstraße 291083 Baiersdorf/IgelsdorfTel: 09133-825374___Qgis-user mailing listhref="/user/SendEmail.jtp?type=node&node=5277175&i=0">[hidden email]List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user If you reply to this email, your message will be added to the discussion below: http://osgeo-org.1560.x6.nabble.com/EPSG-of-data-from-Manifold-tp5277175.html To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.comTo unsubscribe from Quantum GIS - User, href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?>>macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click >>here. href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble>>%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace->>nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml->>send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML View this message in context: Re: EPSG of data from Manifold? Sent from the Quantum GIS - User mailing list archive at Nabble.com. -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] EPSG of data from Manifold?
Hi, the location, more or less North Latitude 49.17048 West Longitude 10.66154 South Latitude 49.06307 East Longitude 10.81879 Cheers Bernd Am 19.07.2016, 21:39 Uhr, schrieb Bernd Vogelgesang : Am 19.07.2016, 21:19 Uhr, schrieb Nicolas Cadieux : Tried looking for it but no luck. It would help if you could say where the data is supposed to be. Then you could try to look in >>www.epsg-registry.org . Nicolas Hi Nicolas, thanks a lot for trying. The shapes are situated around Gunzenhausen in Germany. Cheers Bernd On Jul 19, 2016 2:48 PM, "berndv. [via OSGeo.org]" <[hidden email]> wrote: Hi,we just received some shapes accompanied by an xml and no prj.So far I was out of luck finding the proper projection for this, but I'm guessing that this stuff is from Manifold (my first contact with that) Can anyone tell me from the xml what would be the related EPSG code for this data? Orthographic World Geodetic 1984 (WGS84) Orthographic Meter 6.37813700e+006 8.1819190842621486e-002 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 1.e+000 3.17500700e+000 1.e+000 3.17500700e+000 0.e+000 4.393181425026e+006 0.e+000 5.437772499972e+006 0.e+000 0.e+000 Thanx a lotBernd --Bernd VogelgesangSiedlerstraße 291083 Baiersdorf/IgelsdorfTel: 09133-825374___Qgis-user mailing listhref="/user/SendEmail.jtp?type=node&node=5277175&i=0">[hidden email]List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user If you reply to this email, your message will be added to the discussion below: http://osgeo-org.1560.x6.nabble.com/EPSG-of-data-from-Manifold-tp5277175.html To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.comTo unsubscribe from Quantum GIS - User, href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?>>>macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click >>>here. href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble>>>%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace->>>nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml->>>send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML View this message in context: Re: EPSG of data from Manifold? Sent from the Quantum GIS - User mailing list archive at Nabble.com. --Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] EPSG of data from Manifold?
Am 19.07.2016, 21:53 Uhr, schrieb Nicolas Cadieux : I imagine you have tried 5243 4839 31491 to 31495? No, I haven't till now, cause I had no idea of them (the first 2) 5243 is the only one which does not end up in the Atlantic Ocean, but has an offset of around 200 km to the north ! So this seems to be the right direction ... investigating ... Thanx a lot Bernd You could also look for Germany in https://epsg.io They have 129 CRS for Germany... On Jul 19, 2016 15:27, "berndv. [via OSGeo.org]" <[hidden email]> wrote: Am 19.07.2016, 21:19 Uhr, schrieb Nicolas Cadieux <href="/user/SendEmail.jtp?>>type=node&node=5277180&i=0">[hidden email]>: Tried looking for it but no luck. It would help if you could say where the data is supposed to be. >>>Then you could try to look in www.epsg-registry.org . Nicolas Hi Nicolas, thanks a lot for trying. The shapes are situated around Gunzenhausen in Germany. Cheers Bernd On Jul 19, 2016 2:48 PM, "berndv. [via OSGeo.org]" <href="/user/SendEmail.jtp?>>>type=node&node=5277178&i=0">[hidden email]> wrote: Hi,we just received some shapes accompanied by an xml and no prj.So far I was out of luck finding the proper projection for this, but I'm guessing that this stuff is from Manifold (my first contact with that) Can anyone tell me from the xml what would be the related EPSG code for this data? Orthographic World Geodetic 1984 (WGS84) Orthographic Meter 6.37813700e+006 8.1819190842621486e-002 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 1.e+000 3.17500700e+000 1.e+000 3.17500700e+000 0.e+000 4.393181425026e+006 0.e+000 5.437772499972e+006 0.e+000 0.e+000 Thanx a lotBernd --Bernd VogelgesangSiedlerstraße 291083 Baiersdorf/IgelsdorfTel: 09133-825374___Qgis-user mailing listhref="/user/SendEmail.jtp?type=node&node=5277175&i=0">[hidden >>>>email]List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user If you reply to this email, your message will be added to the discussion below: http://osgeo-org.1560.x6.nabble.com/EPSG-of-data-from-Manifold-tp5277175.html To start a new topic under Quantum GIS - User, email href="/user/SendEmail.jtp?>>>>type=node&node=5277180&i=1">[hidden email]To unsubscribe from Quantum GIS - User, href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?>>>>macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click >>>>here. href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?>>>>macro=macro_viewer&id=instant_html%21nabble>>>>%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace->>>>nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml->>>>instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML View this message in context: Re: EPSG of data from Manifold? Sent from the Quantum GIS - User mailing list archive at Nabble.com. --Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___Qgis-user mailing listhref="/user/SendEmail.jtp?type=node&node=5277180&i=2">[hidden email]List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user If you reply to this email, your message will be added to the discussion below: http://osgeo-org.1560.x6.nabble.com/EPSG-of-data-from-Manifold-tp5277175p5277180.html To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.comTo unsubscribe from Quantum GIS - User, href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?>>macro=unsubscribe_by_code&node=4
Re: [Qgis-user] EPSG of data from Manifold?
Hi folk, just caught the guy responsible for the data, and he said that they were wrongly exported from Manifold (seems to be quite tricky), so they still appear on place in Manifold, but not in other systems. Received new data that fit. Thanx for helping Bernd Am 19.07.2016, 21:05 Uhr, schrieb Bernd Vogelgesang : Hi, we just received some shapes accompanied by an xml and no prj. So far I was out of luck finding the proper projection for this, but I'm guessing that this stuff is from Manifold (my first contact with that) Can anyone tell me from the xml what would be the related EPSG code for this data? Orthographic World Geodetic 1984 (WGS84) Orthographic Meter 6.37813700e+006 8.1819190842621486e-002 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 0.e+000 1.e+000 3.17500700e+000 1.e+000 3.17500700e+000 0.e+000 4.393181425026e+006 0.e+000 5.437772499972e+006 0.e+000 0.e+000 Thanx a lot Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Open Layers Plugin crashes in QGIS 2.16
Hi, yes, simply remove OpenLayers plugin and forget about it forever. QuickMapServices-plugin is your friend now ;) Bernd Am 20.07.2016, 16:57 Uhr, schrieb Giacomo Fontanelli : Dear forum I use QGIS 2.16 with Lubuntu 16.04.64bit. Software crashes each time I try to use OpenLayerPlugin. The first time a message appeared with " Python Error: An error has occurred while executing Python code. See message log. I was not able to read the log. Now when I try to launch the OpenLayersPlugin Qgis automatically quit. Can you help me? Thank you -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Upgrading to 2.16 -> delete Processing in .qgis2 to get new version
Hi, I just upgraded from 2.14 to 2.16 on Linux Mint (after uninstalling everything). I had some strange behaviours with the Processing Toolbox, so I got the idea to delete the processing plugin folder from .qgis2/Python/plugins and restarted QGIS. Then there was a new link at the bottom of the toolbox, telling me that I can activate more providers. Actually I did not change anything in the settings, but when closing them, there was visible action on my hard disc. Afterwards, the quirks were gone. It seems that the new Processing is only working correctly when doing that(?) This may apply to Windows as well. Any comments from devs on that? In case this should be a general case when upgrading, shouldn't this be told somewhere prominently on the website? -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] GDAL warp not functional in 2.16
Hi, just realized that warp does not work anymore in my upgraded 2.16 on Linux Mint. Neither in a model that worked before, nor through the raster menu. The error shown there is ERROR 5: MINUSERPIXELVALUE must be specified. No idea what this means. Was not able to pick settings that would allow warp to run. Local issue? Any alternatives for warp (preferably working in a model)? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Making QGIS-Screencasts on Ubuntu/Mint
Hi, for the first time I try to make some screencasts to explain QGIS-features to customers etc. The problem there is, that when recording the screen or window with no matter which screencast software, the Map Canvas goes wild while moving the mouse over it. It pans and zooms in or out, so it's nearly impossible to explain something cause I always loose the focus on the features. The problem does not seem to be QGIS-specific. In Google Earth, the same moving and zooming happens. Did anyone already encounter this problem or does anyone have a working solution for this? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Openstreetmap offline with QGIS
Hi, I normally do it this way to have an offline basemap either for the mobile phone or the notebook: 1. Install QuickMapServices (an add contributed pack in the settings) for a variety of background layer. There are also different flavours of OSM, so pick your favourite. 2. Install the (tagged as experimental) QTiles plugin. Assuming you have to work in certain area at a time only, set your canvas to this are. In QTiles, you can choose between .zip and .mbtiles (but those mbtiles work within QGIS for already a while). Pick mbtiles for file creation. Choose your zoom level carefully. If you do not need too much detail, 15 will be enough. See http://gis.stackexchange.com/a/7443 for detail which zoom level represents which map scale. For me this setting resulted in 150MB file for an area of ca. 100 square kilometers. Higher zoom level or multiple zoom levels will let this grow exponentially. You will have to test a bit to find the right settings for your purpose. The creation of this mbtile will take a while cause it has to download all the tiles for the area one after another. So better test with a really small area before starting a big download. Hope this helps Bernd Am 28.07.2016, 00:02 Uhr, schrieb : Hi everyone, I use a laptop on my car where I have installed QGIS to follow the position over a map with a GPS. I can calibrate the >image taken from a 1:25000 detailed topographic map. I need to use QGIS with Openstreetmap offline to follow car GPS position. I have downloaded vector tiles form http://osm2vectortiles.org I am not able to open the MBTiles file with QGIS. Please be patient, this is not my work. I will be >grateful if you would suggest me how to do this job or if there is a tutorial available. Are vector tiles from OSM2VECTORTILES right files? Is this the right way to work offline? ++running QGIS Desktop 2.16.0 with Windows10 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Showing all items in attributes table
Hi, sounds like something really went wrong while digitizing. Try the GRASS function v.clean with "rmdupl" from the toolbox to get rid of the duplicates. Or try "Multipart to singleparts" also in the toolbox to create unique entries for your lines in the attributes table. Cheers Bernd Am 03.08.2016, 10:41 Uhr, schrieb simonc8 : I've digitised a shape file layer with several polylines. In the Attribute table it shows 8 items, but in the metadata for the file it states there are 14 features. If I open the shape file in another GIS programme it comes up with 17 polylines, some of which are duplicates of others. I would like to clean up the file in QGIS and remove the duplicates but if I can't get these to show up in the Attribute table I don't know how I can select them to delete them. Grateful for advice. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Showing-all-items-in-attributes-table-tp5279224.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Showing all items in attributes table
Am 03.08.2016, 13:25 Uhr, schrieb simonc8 : Thanks for this. The multipart to single part seemed to clean the file as well as show that one of my polylines existed in three separate segments. So the file now contains 8 features whether I open it in QGIS or other programmes. When I was digitising I wanted to use part of one line I'd already digitised in another line, so I made a copy, cut the line and must have incorrectly discarded the unwanted part, or inadvertently made a second copy. If I want to combine my line which is currently in three segments into a single feature how do I do that? Do the different segments have to have identical end points to join properly? (At the moment there are small gaps between the different segments.) Maybe now v.clean is the right tool. I love it ;) Select "snap" there and set the threshold for the estimated width of your gaps + x. If this doesn't work (documentation refers to vertices snapped to lines, not vertices to vertices), try the same, but leave the so threshold low that it will not trigger a snap, but go to the advanced settings and rise the threshold for snapping there. This is a different function in GRASS, where you can perform basic cleaning and snapping while importing the data set into GRASS. I think that you will then still have separate features, but spatially aligned. If your line segments have a common value or id, try "Line dissolve" from SAGA in the toolbox. Anyway, hard to give the proper hints without seeing the data. For me it's always a trial-and-error-game, too. Cheers Bernd -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Showing-all-items-in-attributes-table-tp5279224p5279248.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Label buffer rings
Hi, I'm searching for a convenient way to label buffer rings around a central point the way I like it. The standard layout looks like this in the screenshot. https://ibin.co/2qyymNujAt17.jpg I found no settings to get: - the lables be stacked vertically to the top, instead of the default horizontally to the left - the labels be positioned on the outer line of the buffer zone. I could live with the other numbers in the center of the ring, but the 1000 right on top of the center is nonsens. Dragging them manually to a position is still possible, but a "standard" way of doing this would be preferable. Any hints? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Label buffer rings
Hi Carlos, thanx for pointing me to this. My layer already contained a field "distance" with the buffer rings size. I added x and y fields to the layer, copied the center points x-value with the Info-tool and filled it in for x, and then copied the y-value and added the "distance" value to it in the field calculator. https://ibin.co/2qzJcy2eSDO0.png https://ibin.co/2qzJu8hn4d9A.jpg Anyway it would be nicer to somehow just tell QGIS to label into other directions than left. And then being able to align labels to their center would make the world nearly perfect. Cheers Bernd Am 09.08.2016, 17:42 Uhr, schrieb Carlos Cerdán : What about to set coordinates for your labels?. You would can calculate X and/or Y label coordinates as center coordinates plus >radius of buffer plus some aditional length acording your presentation scale. These values must be in a field and, on your label >menu, you must set Ubication as "Data defined". Even rotation can be controlled this way. Good luck Carlos Cerdán 2016-08-09 9:54 GMT-05:00 Bernd Vogelgesang : Hi, I'm searching for a convenient way to label buffer rings around a central point the way I like it. The standard layout looks like this in the screenshot. https://ibin.co/2qyymNujAt17.jpg I found no settings to get: - the lables be stacked vertically to the top, instead of the default horizontally to the left - the labels be positioned on the outer line of the buffer zone. I could live with the other numbers in the center of the ring, but the 1000 right on top of the center is nonsens. Dragging them manually to a position is still possible, but a "standard" way of doing this would be preferable. Any hints? Cheers Bernd --Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Recent Project, last used algorithm etc.
Hi, I'm wondering where those things like recent projects,last used algorithms, activated core plugins etc are stored? I completely removed 2.16 and the .qgis2 folder, and after reinstalling, all these settings and infos are still present. How is it possible to make a really CLEAN install? Using Linux Mint ubuntugis Chhers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Recent Project, last used algorithm etc.
Am 11.08.2016, 17:14 Uhr, schrieb Jürgen E. Fischer : Hi Bernd, On Thu, 11. Aug 2016 at 16:05:28 +0200, Bernd Vogelgesang wrote: I completely removed 2.16 and the .qgis2 folder, and after reinstalling, all these settings and infos are still present. ~/.config/QGIS/QGIS2.conf argh, how could I forget about this ... As a side-effect, renaming this also solved my "problem" with the doubled "Vector" menue items Thanx Bernd or in the registry HKCU\Software\QGIS\QGIS2 Jürgen -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Qgis 2.16.1 crashes when opening a processing tool (Ubuntu)
Hi Stéphane, did you already try to backup and remove your .qgis2 folder and QGIS2.conf in .config ? By this, you have real clean install. I also had several issues when upgrading from 2.14 and this solved some. If everything is fine afterwards, you could copy back your plugins manually and restore saved connections etc. from the config file Good luck Bernd Am 20.08.2016, 06:20 Uhr, schrieb Stéphane Henriod : PS: additional info: I just downgraded Qgis to 2.14 LTS, and the processing tools seem to now work but i would be happy to use the >last version if possible :-) Any hint welcome! Stéphane Le samedi 20 août 2016, Stéphane Henriod a écrit : Hello I have recently updated Qgis to 2.16.1 and Ubuntu to 16.04 LTS Since then, whenever I try to open a processing tool from the processing toolbox, Qgis crashes (no error message is shown). Has this happened to anyone? Is there a known bug or something? As far as I can tell, Qgis seems to be working properly >>otherwise. Thanks a lot i advance! Stéphane Henriod CIM-Expert for GIS and Green Economy Statistics Национальный статистический комитет Кыргызской Республики Кыргыз Республикасынын Улуттук статистика комитети National Statistical Committee of the Kyrgyz Republic 374 Фрунзе ул. / Frunze str. 720033 Бишкек / Bishkek T +996 778 46 99 02 (KG) T +49 176 280 11 050 (DE) Es...@henriod.info W http://www.stat.kg W3W: nightfall.into.bucket // запас.союз.дружный --Stéphane Henriod CIM-Expert for GIS and Green Economy Statistics Национальный статистический комитет Кыргызской Республики Кыргыз Республикасынын Улуттук статистика комитети National Statistical Committee of the Kyrgyz Republic 374 Фрунзе ул. / Frunze str. 720033 Бишкек / Bishkek T +996 778 46 99 02 (KG) T +49 176 280 11 050 (DE) Es...@henriod.info W http://www.stat.kg W3W: nightfall.into.bucket // запас.союз.дружный -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Correct data source encoding for labels
Hi, do you have this issue only with labels or do you have the same issue in the attribute table (assuming that labels derive from atributes)? I also have frequent issues with encoding. The only thing that worked for me (in some cases) was to check "Ignore shapefile encoding declaration" under Settings/Options/Data Sources/Data source handling. If you try this, you should maybe restart QGIS and/or at least remove and re-add the layer in question. Cheers Bernd Am 24.08.2016, 20:23 Uhr, schrieb Luciano La Sala : Hello QGIS users, I am using QGIS 2.14.0 Essen. I have a shapefile for which I need to display labels. All seems ok except that accents are displayed as a question a mark inside a diamond. I understand this is a data source encoding issue. Is there a practical way to solve it? Thank you. -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] "live" openstreetmap data in qgis
Hi, I can't give you any input on your question, but just would like to know from you what the use case/advantage for this kind of plugin/functionality is. Cheers Bernd Am 28.08.2016, 06:06 Uhr, schrieb Robin Paulson : at the moment there are various ways to add openstreetmap data to qgis. as far as i can tell, they all rely upon downloading a .osm/obf/pbf file in some semi-automated way and importing it. none of the existing tools allow for any existing data to be deleted and replaced with the new. what i would like to do is add a "live" layer to my qgis projects, such that any data is periodically and transparently re-downloaded and updated. for those of you who are familiar with JOSM, this would be similar to the "continuos download" [sic] plugin for that software. so, any suggestions? at present, the only solution i have is a script which runs every n minutes/hours to download the requisite area (based upon the boundary of the qgis project), deletes the contents of the existing .osm layer and then imports the new data. i'd like to know if anyone has other ideas or can point me to existing functionality/plugins. cheers -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Compare and the most value
Hi, I asked a simliar question 4 years ago on stackexchange http://gis.stackexchange.com/q/30708/8202 But it all depends on the use case and data. Cheers Bernd Am 30.08.2016, 14:21 Uhr, schrieb Bia : 2 questions: 1) in the field calculator as I can, for example, find the greatest value of a column? 2) Can I compare different tables (different shapfiles) to for example obtain a value of contamination >concentration in tables with different concentrations and dates? Tanks! 2016-08-30 9:20 GMT-03:00 Bia : 2 questions: 1) in the field calculator as I can, for example, find the greatest value of a column? 2) Can I compare different tables (different shapfiles) to for example obtain a value of contamination concentration in tables >>with different concentrations and dates? Tanks! 2016-08-30 8:55 GMT-03:00 Tyler Veinot : Bia; Compare in what way? You can export the sheets to CSV or DBF and add them to your project, from there you can join common data >>>types, use the field calculator to manipulate the data, display XY coordinates. On Tue, Aug 30, 2016 at 7:19 AM, Bia wrote: Good morning!Is there a way to compare different spreadsheets data in qgis? Tk u ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bea --Bea -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] updating printer composer
Hi Dave, yes it's possible. And it is quite easy: select your map frame in the composer -> select the "Item properties" tab -> Hit the "Update preview" button Cheers Bernd Am 30.08.2016, 22:07 Uhr, schrieb : Hi List, I am having run with the print composer :-( If I work on the main qgus window and create a map image the way that I want it, then open a print composer and drag an image of the map on to the print >compose. It looks rather nice. Then I discover that I have left off some vital feature, I go and edit the main map, but the print composer ignores the change. I >have to remove the map image from the print composer and re add it. Is there any way I can just get the composer to reload/refresh the image on the composer to match the main image on the qgis window with out having to readd >it ? Dave. -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Ubuntu updating instructions
Am 13.09.2016, 16:51 Uhr, schrieb Blumentrath, Stefan : And if I may add: Even if the users are aware of the fact that ubuntugis-unstable contains the current releases, it can be hard to impossible >to convince a GIS-ignorant system administrator that it is OK to install “unstable” packages. But this issue is not a QGIS issue I guess... Actually, this problem could be easily solved, if there was only a single line of explanation added next to each of the repositories in the install instructions, so the uneducated or doubtful can be told and convinced which package ships which flavour. And yes, I was told to change this myself and given privileges to do so a while ago, but I couldn't find the energy to fiddle myself into the system. And I am still confused myself, cause behaviour seems to change from release to release a bit. At the moment, I can hardly write cause my right hand is in plaster and writing and pushing a mouse is a nightmare. So could not some less handicapped and more literate guy add some explanations to the website? Cheers Bernd From: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Randal Hale Sent: 13. september 2016 16:45 To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Ubuntu updating instructions On 09/13/2016 10:23 AM, Jürgen E. Fischer wrote: Hi Randal, On Tue, 13. Sep 2016 at 00:21:21 -0400, Randal Hale wrote: It's a little bit confusing. There are like three repositories: stable, unstable, and testing. Testing you don't want (unless you want to test packages). Typically stable is a bit older. Unstable is current. Which doesn't really make sense - but that's the way it is. Not like it matters much in this case. We have packages in qgis.org/debian/ against the plain versions of the distributions (debian and **ubuntu**) and in qgis/ubuntugis/ packages against newer dependencies from - and only from - ubuntugis-unstable. Looks like it's hard for people to accept that there are also ubuntu packages in a directory called debian and that probably makes them jump on the other because it has ubuntu in it's name. I was thinking about it last night (and I was up way to late) and it is a bit confusing for the casual user. They've installed Ubuntu (or mint/debian/>xubuntu/etc) and they may not understand ubuntu is based off debian. So like you said - they see debian but want to use Ubuntu. They go to >UbuntuGIS and they see the repositories for UbuntuGIS and the choice is unstable (and no one likes unstable software) and stable (which doesn't >contain the newest software). So you end up going "Use Unstable because it's stable and current". Under my /etc/apt/sources.list.d directory I made a qgis.list file and put the following in there: deb http://qgis.org/debian xenial main deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu xenial main Why? That are the packages not based on ubuntugis with the dependencies from ubuntugis. Do I have this wrong? I thought I had the repositories for the install correct based off the directions on qgis.org. Which I could completely have it >wrong. With the above repos I'm getting QGIS 2.16.x and GDAL 2.1.x. Jürgen ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user --- Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com 423.653.3611 rjh...@northrivergeographic.com twitter:rjhale -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Composer Atlas: How get rid of the big red cross when there is no image?
Hi, I set up a neat atlas for displaying a row of 50 sample plots. On a second page, I want to show 2 pictures taken of these plots automatically with an expression including the path || @atlas_pagenumber || '_1.jpeg' or '_2.jpeg' to display up to two photos named e.g. 1_1.jpeg, 1_2.jpeg. This works really great! The problem is, that for some plots, we do not and have any picture or only one. In composer, these missing images are marked with a big red cross. Unfortunately, these red crosses are also exported, which looks quite shitty. Is there any clever way of forcing QGIS not to export these place holders but just not to print anything at this place? The only (boring) idea I came up with till now, was to create empty white images and name them accordingly to avoid the red crosses. Thanx Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Composer Atlas: How get rid of the big red cross when there is no image?
Hi Harrissou, thanx for the hint. I already saw the checkbox, but had no idea what to do with it. My problem now is, that I have really no idea what to put in the "case when" Maybe something like '/mypath/'|| @atlas_pagename ||'_1.jpeg' IS NULL or so? I do not know what is expected to be returned that this option will trigger. There seems not to be a boolean type or so. The documentation does not tell what to do there. Still confused, but there might be a solution... Bernd Am 26.10.2016, 22:19 Uhr, schrieb DelazJ : Hi, what about using the data-defined option near the "Exclude items from export" in the items properties --> Rendering (with a case when >expression)? http://docs.qgis.org/2.14/en/docs/user_manual/print_composer/composer_items/composer_items_options.html#rendering-mode HTH, Harrissou 2016-10-26 22:10 GMT+02:00 Bernd Vogelgesang : Hi, I set up a neat atlas for displaying a row of 50 sample plots. On a second page, I want to show 2 pictures taken of these plots >>automatically with an expression including the path || @atlas_pagenumber || '_1.jpeg' or '_2.jpeg' to display up to two photos >>named e.g. 1_1.jpeg, 1_2.jpeg. This works really great! The problem is, that for some plots, we do not and have any picture or only one. In composer, these >>missing images are marked with a big red cross. Unfortunately, these red crosses are also exported, which looks quite shitty. Is there any clever way of forcing QGIS not to export these place holders but just not to print anything at this place? The only (boring) idea I came up with till now, was to create empty white images and name them accordingly to avoid the red >>crosses. Thanx Bernd --Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Composer Atlas: How get rid of the big red cross when there is no image?
Arghh, sorry for the noise! When hovering over the data-driven input button not so hectically, I discovered the explanation that it expects a 0 or 1. So case when 'mypath'|| @atlas_pagename ||'_1.jpeg' IS NULL THEN 0 END did the trick! Just amazing!!! Thanx Bernd Am 26.10.2016, 22:19 Uhr, schrieb DelazJ : Hi, what about using the data-defined option near the "Exclude items from export" in the items properties --> Rendering (with a case when >expression)? http://docs.qgis.org/2.14/en/docs/user_manual/print_composer/composer_items/composer_items_options.html#rendering-mode HTH, Harrissou 2016-10-26 22:10 GMT+02:00 Bernd Vogelgesang : Hi, I set up a neat atlas for displaying a row of 50 sample plots. On a second page, I want to show 2 pictures taken of these plots >>automatically with an expression including the path || @atlas_pagenumber || '_1.jpeg' or '_2.jpeg' to display up to two photos >>named e.g. 1_1.jpeg, 1_2.jpeg. This works really great! The problem is, that for some plots, we do not and have any picture or only one. In composer, these >>missing images are marked with a big red cross. Unfortunately, these red crosses are also exported, which looks quite shitty. Is there any clever way of forcing QGIS not to export these place holders but just not to print anything at this place? The only (boring) idea I came up with till now, was to create empty white images and name them accordingly to avoid the red >>crosses. Thanx Bernd --Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Composer Atlas: How get rid of the big red cross when there is no image?
Am 26.10.2016, 22:57 Uhr, schrieb Nyall Dawson : On 27 Oct 2016 6:51 AM, "Bernd Vogelgesang" wrote: Arghh, sorry for the noise! When hovering over the data-driven input button not so hectically, I discovered the explanation that it expects a 0 or 1. So case when'mypath'|| @atlas_pagename ||'_1.jpeg' IS NULL THEN 0 END did the trick! This is odd... A null picture expression should be rendered empty, not as the red cross. The red cross is intended only as an >obnoxious, obvious indicator that a picture path was set but couldn't be found. The expression above would only result in 0 if @atlas_pagename is null. Nyall Well, yeah, I was too early to announce the solution. In fact this did not render the missing image, but also not the one which is there :( case when '/media/Daten/IVL_Projekte/2016024_Feldhamster_NEA/2_EINGANG_MA/Bernd/QGIS/Fotos/'|| @atlas_pagename ||'_1.jpeg' IS NULL THEN 1 ELSE 0 END This should do it. But now I am again where is started: When the image is there, it is rendered, when not, the red cross is exported as well. :( Bernd Just amazing!!! Thanx Bernd Am 26.10.2016, 22:19 Uhr, schrieb DelazJ : Hi, what about using the data-defined option near the "Exclude items from export" in the items properties --> Rendering (with a case >when expression)? http://docs.qgis.org/2.14/en/docs/user_manual/print_composer/composer_items/composer_items_options.html#rendering-mode HTH, Harrissou 2016-10-26 22:10 GMT+02:00 Bernd Vogelgesang : Hi, I set up a neat atlas for displaying a row of 50 sample plots. On a second page, I want to show 2 pictures taken of these plots >automatically with an expression including the path || @atlas_pagenumber || '_1.jpeg' or '_2.jpeg' to display up to two photos named >e.g. 1_1.jpeg, 1_2.jpeg. This works really great! The problem is, that for some plots, we do not and have any picture or only one. In composer, these >missing images are marked with a big red cross. Unfortunately, these red crosses are also exported, which looks quite shitty. Is there any clever way of forcing QGIS not to export these place holders but just not to print anything at this place? The only (boring) idea I came up with till now, was to create empty white images and name them accordingly to avoid the red >crosses. Thanx Bernd --Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Composer Atlas: How get rid of the big red cross when there is no image?
Am 27.10.2016, 00:12 Uhr, schrieb Nyall Dawson : On 27 Oct 2016 7:18 AM, "Bernd Vogelgesang" wrote: Am 26.10.2016, 22:57 Uhr, schrieb Nyall Dawson : On 27 Oct 2016 6:51 AM, "Bernd Vogelgesang" wrote: > > Arghh, sorry for the noise! > > When hovering over the data-driven input button not so hectically, I discovered the explanation that it expects a 0 or 1. > So > case when> 'mypath'|| @atlas_pagename ||'_1.jpeg' IS NULL > THEN > 0 > END > > did the trick! This is odd... A null picture expression should be rendered empty, not as the red cross. The red cross is intended only as an >obnoxious, obvious indicator that a picture path was set but couldn't be found. The expression above would only result in 0 if @atlas_pagename is null. Nyall Well, yeah, I was too early to announce the solution. In fact this did not render the missing image, but also not the one which is >there :( case when '/media/Daten/IVL_Projekte/2016024_Feldhamster_NEA/2_EINGANG_MA/Bernd/QGIS/Fotos/'|| @atlas_pagename ||'_1.jpeg' IS NULL THEN 1 ELSE 0 END This should do it. But now I am again where is started: When the image is there, it is rendered, when not, the red cross is >exported as well. That's because that expression is just testing whether the concatenated string itself is null, not whether the corresponding file >actually exists. My advice: make a small python custom function 'file_exists' which checks for the existence of a file. Then change your picture path >expression to something like: Case when file_exists( 'media/' ... Etc) then 'media/' ... Else null end That should get you the result you are after. Nyall Hi Nyall, unfortunately, I have still no clue of python. I now added blank images for the missing ones :( I think I will at least file a bug report for the red cross not being rendered. Thanx for your attention Bernd :( Bernd > > Just amazing!!!> > Thanx > Bernd > > Am 26.10.2016, 22:19 Uhr, schrieb DelazJ : > >> Hi, >> what about using the data-defined option near the "Exclude items from export" in the items properties --> Rendering (with a >case when expression)? >> http://docs.qgis.org/2.14/en/docs/user_manual/print_composer/composer_items/composer_items_options.html#rendering-mode >> >> HTH, >> Harrissou >> >> 2016-10-26 22:10 GMT+02:00 Bernd Vogelgesang : >>> >>> Hi, >>> I set up a neat atlas for displaying a row of 50 sample plots. On a second page, I want to show 2 pictures taken of these >plots automatically with an expression including the path || @atlas_pagenumber || '_1.jpeg' or '_2.jpeg' to display up to two photos >named e.g. 1_1.jpeg, 1_2.jpeg. >>> >>> This works really great! The problem is, that for some plots, we do not and have any picture or only one. In composer, these >missing images are marked with a big red cross. >>> Unfortunately, these red crosses are also exported, which looks quite shitty. >>> >>> Is there any clever way of forcing QGIS not to export these place holders but just not to print anything at this place? >>> >>> The only (boring) idea I came up with till now, was to create empty white images and name them accordingly to avoid the red >crosses. >>> >>> Thanx >>> Bernd >>> >>> -->>> Bernd Vogelgesang >>> Siedlerstraße 2 >>> 91083 Baiersdorf/Igelsdorf >>> Tel: 09133-825374 >>> ___ >>> Qgis-user mailing list >>> Qgis-user@lists.osgeo.org >>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user >>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user >> >> > > > > -- > Bernd Vogelgesang > Siedlerstraße 2 > 91083 Baiersdorf/Igelsdorf > Tel: 09133-825374 > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Plea for help with monochrome maps for publication
Have a look at http://colorbrewer2.org There you can check for grey-scale tones that are distinguishable and printer friendly, so you can set up a palette with those values. The downside of grey scales is, that there are not so many different tones available as when working with colours. Cheers Bernd Am 11.11.2016, 18:26 Uhr, schrieb David Addy : Most of us prepare our maps using colours for different outlines or different colour shades of fill for polygons. However, there are still occasions where maps produced for publication in books or magazines will end up as shades of grey to save the cost of colour printing. This is certainly the case for most of the local history texts for which I am often asked to make maps. This can result in greys which are fairly indistinguishable from each other, and traditionally this issue was approached by adding hatchings to the ‘colour’. This could end up as looking a mess and/or failing to adequately highlight an area of highest activity in distribution maps. Has anybody got any experience of, or advice for, successfully solving the problem of making monochrome maps look more attractive and useful? -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Plea-for-help-with-monochrome-maps-for-publication-tp5295385.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] field calculator and query: asking help for faster solution!!!
Sorry, I still have no idea what your data looks like and what you like to achieve. Cheers Bernd Am 15.11.2016, 21:51 Uhr, schrieb Azzurra Lentini : Dear all, I have an attribute table (associated to a shape file). One of the field is a string type field and his name is “DESCRIPTION” , I need this field as an INT number. The field “description” is formed by 25 different samples and around 350 records (so for every sample there are different records with the same >description). SO I create a new field “descriptionINT” and I would like to fill the field with 25 numbers (1, 2, 3, 25) associated to the 25 different sample and 350 >records. How I can do? Till now, I was first selecting the records related to the first sample and I was giving the number, for example 1 (with field calculator) to all the records >related to the same sample. But I am doing this one by one.. that means every time a do a new selection and I give a new number with field calculator. Do you know a faster way (query) to do this ? thanks A.L. --Dr. HydrogeologistAZZURRA LENTINI Expert of evaluation environmental hazards GIS applicationHaity Mobile Tel: 0050946057393 ++ Italy Mobile Tel.: **(39) 338 24 40 676 ++ SKYPE azzurrahydro ++ azzurralent...@gmail.com ++ *Par respect pour l'environnement,* *n'imprimez ce mail qu'en cas d'absolue nécessité* -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Can not edit some fields (2.14.8)
Hi, I encounter a strange problem when trying to edit fields in a layer. I have a polygon layer and a csv list of actions to be taken on these areas. So I joined the attributes with the toolbox to attach the actions to the polygons (NOT joining via properties) Now I have to edit some of the attached data, cause they are false positives (due to multiple matching ids). But some of the attached fields are now not editable, they are just greyed out on the form. When I look at the properties, they are just the same string fields as the others. I thought that this might be some of the ESRI-shape quirks, so I saved the layer to sqlite. There, I was able to edit one polygon (emtpy the attached fields). But after saving the changes, the effect was back again, some fields are greyed out in the form again. I never encountered such a problem before, and I'm quite clueless what to do, and of course I am in a big hurry. See attached screenshot of the fields. Anyone an idea what might be the problem or how to work around this? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] [SPAM] Atlas generation
Hi, this got reorganized and can now be found under "Variables" as "atlas_featureid"! Cheers Bernd Am 27.11.2016, 12:26 Uhr, schrieb Piotr Kania : I have found the answer (points 25-28): http://www.qgistutorials.com/en/docs/automating_map_creation.html But right now I have another question: in my qgis dev I don't have in expression string builder Group of Functions such as Atlas and Composer, like on that picture: http://www.qgistutorials.com/en/_images/27.png W dniu 2016-11-27 o 11:43, Piotr Kania pisze: Hi! Probably someone asked here about that (so sorry if I repeat topic or if my question is too trivial) - I create in qgis composer atlas. It's simple - on each page there is a point layer, that point layer is set as a coverage layer too. I would like to know what setting could make such effect - on single page of atlas there would be just one point, in the same way as if I set some expression in point layer's Properties/General/Query Builder. In other words - I just want to have on single page just one feature from those point layer. So if I browse page 1, 2, 3... of my atlas I will "jump" to the next and the next feature. Each point in my point's layer is a place, that I want to show in scale 1: 5000, underneath is wms layer. Each page in atlas is just a simple map that showed where on Earth is that place :). Sorry if my question is too trivial - I tried to use some settings in Composer but without luck. Thanks for any hints - Piotrek ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] [Qgis-developer] QGIS, Shapefiles, default encoding
Am 20.12.2016, 11:05 Uhr, schrieb Drexel Peter : Hi, please, can anyone tell me what default encoding QGIS uses when loading a Shapefile? In my QGIS 2.14.7 on Windows 7 64bit „Ignore shapefile encoding declaration“ is checked, so if I load a Shapefile with a corresponding utf-8-cpg-file using “drag and drop” it is encoded as >‘system’ and the encoding is wrong (what encoding is ‘system’?). If I load a Shapefile with a corresponding utf-8-cpg-file using “Add Vector Layer” it is encoded as >‘utf-8’ and the encoding is fine. In both cases I can change the data source encoding in the properties dialog. Is it possible to change the behavior of drag and drop to use utf-8 If I uncheck „Ignore shapefile encoding declaration“ and load the shapefile either using “Add Vector Layer” or drag and drop the cpg-file is interpreted >correctly and the encoding is set to utf-8. But now I cannot change the data source encoding in the properties dialog anymore. I think it should still be possible to change the encoding in the properties dialog. Peter Hi Peter, welcome to the Babylon of computer stone age ;) I think a lot of people share your confusion with codepages. Your "system" encoding is that of your Windows, so presumably (in Western Europe) windows-1252 or CP1252 or ISO 8859-15. On a Linux system, it is normally UTF-8. I often run into problems with the encoding on my Linux system when dealing with files from Windows systems and vice versa. Having files of mixed encodings in a project is a nightmare. Those problems also seem to derive from files like gpx, kml etc. which always seem to be generated using UTF-8. So even when I decide to handle everthing in Windows-style and convert files to windows-1252, those UTF-8 files bring in problems. Same with the processing toolbox, where some algos happily switch the output encoding. When unchecking „Ignore shapefile encoding declaration“, UTF-8 seems to be used internally (see https://hub.qgis.org/issues/11019). But I have problems understanding all this, and worse, QGIS seems to not understand all this as well all the time. P.s. Haven't touched ArcGIS for years. How does this handle different code pages in a project? -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] spatialjoin
layer (B) with the name of the owners of these lands . You see what i would ?... I would have these names transferred as attribut from B to A . For that , i think about a spatialjoin with a dynamic feature . So i have downloaded the two plugins "reffunction" and "spatialjoin". But i have certainly maked something wrong because i don't succeed ... Is it the good method ? And If yes , and if exist a doc about these plugins ...i'll take it :-)) regards Laurent ( pour les francophones ...je repère et saisis des points représentants des batiments construits et visibles par Google Map mais inconnus par le cadastre et donc les impôts ...je voudrais donc enrichir la couche de saisie par les références des parcelles et les noms des propriétaires par une jointure spatiale dynamique ..à chaque point saisi , "monte" cette référence ) ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- - Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com 423.653.3611 rjh...@northrivergeographic.com twitter:rjhale ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] spatialjoin
Am 22.12.2016, 09:26 Uhr, schrieb Laurent Bourlet : Hi at all i succeed !! thank's at all ...Andrew was right ... but i add an another thing ; i have indicated in the dialogue box , under >"default value" , in "relational value" the name of the layer B , the right field etc... and now it's ok ! one more time , thank's !! laurent Great! Now it would would be nice if you would post a little walk-trough, so "old-fashioned" people like me have a chance to benefit from this a well. Cheers Bernd Le 21/12/2016 à 23:32, Andrew a écrit : Regarding the default values option/limitations, I can add that if you try to use the default values expression dialog >>to build an expression using geomintersects() the dialog will evaluate the expression as invalid. Instead, build the >>expression in the field calculator and then copy/paste it into default value box and skip using the expression dialog. Andrew On Wed, Dec 21, 2016 at 1:32 PM, DelazJ wrote: Hi, Laurent, I can think about different ways you can test to tackle your issues, provided you have two spatial layers >>>that overlap (and without any intermediate layer creation): - recent QGIS introduce default values concept (http://docs.qgis.org/testing/en/docs/user_manual/working_with_vector/>>>vector_properties.html#common-settings) - i'm not really sure about its limitations though - add a virtual field (http://docs.qgis.org/2.14/en/docs/user_manual/working_with_vector/>>>attribute_table.html#editing-attribute-values) that you could later recalculate into a simple field - use the Autofields plugin (http://plugins.qgis.org/plugins/AutoFields/) - use the SpatialJoin plugin (http://plugins.qgis.org/plugins/spatialJoin/) Except the SpatialJoin plugin option (which is internally based on it), you'll need to write an expression likely >>>based on refFunctions plugin (e.g, geomintersects) someone mentioned above. HTH, Harrissou 2016-12-21 19:23 GMT+01:00 Laurent Bourlet : Hi, i thought it was more easy ... In fact , i don't use a GPS because these points don't need precision : they are only used to identify the parcels >>>>. And i would like to catch their identity ( a number for each parcel and the owner ) if possible with a dynamic >>>>spatialjoin... With booth data ( number of parcel and name of owner ) , i could talk with the fisc administration :-) Randy was right ...i didn't have the same EPSG for the two layers . It's now OK ! but without the feature >>>>"dynamic" . Indeed , i would avoid building many temporaries layers and i thought it existed a plugin for this " dynamic" >>>>feature. If no , i will ask my users to make spatialjoins some time to time ... Waiting , i will try the solution of Bernd... Thank you anyway ! laurent Le 21/12/2016 à 17:46, Bernd Vogelgesang a écrit : Hi, for me this sounds more like he is getting new points once in a while and wants to join those attributes to the new points "automatically" from the parcel layer. The biggest problem for users is to rethink the workflow from the end to the beginning and to know the limitations. The outcome should be a point layer with the polygons attributes. If those points (layer A) are from GPS as Randy assumes, they have to be reprojected to the parcels layer (layer B) before being able to join them spatially(layer C). The spatial join in the toolbox produces layer D. Most probably, the resulting layer D is going to to be edited in some way (adding notes about size, the progress, classifications, whatever), so you will have to find a way to preserve those new attribute while being able to add new points without much trouble. The processing toolbox is a good way to do these steps, though it produces a lot of temporary files cluttering the project. A better way for all those repetitive tasks, is to use the graphical modeller, to create a workflow which only has to be triggered once new points come in, and the resulting file can be saved as new a file e.g. with the current date in the name, so you have kind of an archive and do not overwrite previous files (and destroy your work in case something goes wrong). So I can imagine a model with input layer A (new points in WGS84 without attributes) and a parcel layer B (in >>>>>whatever projection). reproject layer A and C will be created as an intermediate step. Next input layer is the latest result layer D, reprojected and with attributes. Merge layer C and D -> E. Now delete all columns which are from layer B (from the last spatial join. >>>>>Unfortunately, you can only delete one field at a time in the modeller, so you'll will have to add the command >>>>>se
Re: [Qgis-user] How do you change floating values in a raster to integers
2) Have a look at http://gis.stackexchange.com/a/146551 I think this answer might still work. Found this easily with "QGIS raster round" as search string in google. Cheers Bernd Am 12.01.2017, 23:06 Uhr, schrieb Ernest Dunwoody : Hello Readers, I’m sure this has been asked before, and probably answered, but I cannot find a way to search the QGIS-user Archives for the answer. Any advice >on 1. How to search the QGIS user archive, and 2. How to convert floating raster values to integers (needed to create raster attribute tables) Would be very much appreciated. Thank you Ernest Dunwoody P O Box 420 Drayton North Qld 4350 Australia edunwoo...@gmail.com Ph. 0431 004 054 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Fwd: [R-sig-Geo] RQGIS release 0.2.0
Hi, just wanted to forward this email from the r-sig-geo mailing list about interfacing QGIS from R. Maybe it is of interest for some. --- Weitergeleitete Nachricht --- Von: "Jannes Münchow" An: r-sig-...@r-project.org Kopi Dear list members, today we are happy to announce a new version of RQGIS! RQGIS establishes an interface between R and QGIS, i.e. it allows the user to access the more than 1000 QGIS geoalgorithms from within R. The most important news is that you can run again the most recent QGIS releases (>=2.18.2) with RQGIS without having to modify Python source code. This modification became necessary due to a bug introduced in QGIS 2.16 (see https://github.com/jannes-m/RQGIS#rqgis-modifications-v-216-2181). This release fixes also several bugs which we detected thanks to user feedback. To learn more about these, please refer to https://github.com/jannes-m/RQGIS/releases/tag/v0.2.0. For more information on RQGIS, how to install it and examples how to use RQGIS, please refer to https://github.com/jannes-m/RQGIS and my https://jannesm.wordpress.com/category/r/. All the best, Jannes ___ R-sig-Geo mailing list r-sig-...@r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-geo -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Porblems with labeling Coordinate grid and the numbers-Change
Hi Stefan, I can't answer to your questions, cause I have real difficulties understanding your problems. I just can advise you to switch your QGIS language to English under "Settings/Options/Locale", so you are able to use the correct terminology in English when posting questions and searching for answers. It would always be good to have screen shots to be able to visualize the problems, but as the mailing list has a limit of 100kb for attachments, it's sometimes hard to do so. A better resource for help on such things IMHO is stackexchange. E.g. for your problems use http://gis.stackexchange.com/search?q=qgis+composer+coordinates to get a list of questions/answers that might cover your issues. Cheers Bernd Am 07.02.2017, 11:57 Uhr, schrieb Reist Stefan : Hi, Im using QGIS 2.14 and i have the following 2 Problems: Both Problems are in the Print Compilation: - How i can the labeling Coordinate move, that this are not on the Coordinate Line, >rather a little bit higher? - How i can change the Numbers on the side the map. Now it's beginns from top to bottom >with the numbers 10 to 1. But now i will change this chronology from top to bottom and beginns >with 1 to 10. Can someone help me? Thank you for the help! Steven -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] Join hangs in Las Palmas
Hi, did you already try to create a new joined layer with the processing toolbox instead of creating a "loose" join with Properties/Joins? I almost never do joins through the properties but instead create permanent joins with "Join attributes table" from the toolbox. It could be possible that your machine has not enough power/memory when non-permanently joining huge data sets. Good luck Bernd Am 06.02.2017, 21:16 Uhr, schrieb Holly Wilkie : Hi, I've noticed that when I try to do a Join, the software hangs and I have to close the App. Usually, the join works after I restart. However, I am >currently trying to join a table of parcel ownership data provided by a Texas county with a shapefile provided by the same county. The data type for the >columns is the same. They are both rather large files. When I set up the join, QGIS hangs and I am unable to get the join to work upon restarting. Has >anyone else noticed this issue? -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] Ubuntugis SAGA update to 2.31: Save to install?
Hi, just saw that there is now a SAGA update offered from 2.27 to 2.31 from ubuntugis. As I had almost always trouble with those updates, I now would like to ask beforehand if this will break again the functionalities of the toolbox, or if it is save to install. Or if there are workarounds in case it doesn't work? Am on Linux Mint 18 with QGIS 2.14.11 Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Ubuntugis SAGA update to 2.31: Save to install?
Hi Matteo, Am 13.02.2017, 19:27 Uhr, schrieb matteo : Hi Bernd, I have the ubuntugis unstable repositories activated but I still can only install SAGA 2.2.3 I'm also on a Linux Mint 18 (sara), what am I missing? no idea. I have deb http://qgis.org/ubuntugis-ltr xenial main and deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu xenial main activated. Cheers Bernd ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Importing layers into QGIS 2.18 on Win 7
Hi, do NOT use the openlayers plugin for basemaps but use QuickMapServices plugin and activate the "Contributed services" in the settings. Cheers Bernd Am 19.02.2017, 09:46 Uhr, schrieb Hernán De Angelis : Hi Try the openlayers plugin. H. söndag 19 februari 2017 skrev Pat Brown : Hi, Can someone please point me to some detailed instructions on how to import a layer such as from openstreetmaps or Google Maps? >>The instructions I have been able to find have assumed a level of knowledge greater than mine. (eg "Enter the URL of the service >>which you would like to use, replacing x, y and z parts with curly brackets substitution as can be seen below". I have no idea >>what the "xyz" stands for and what do I replace them with? Need something that explains the process from a very basic viewpoint. Thanks -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] Can you see me? (my e-mail)
YES, but I have no answers for your questions. Good luck Bernd Am 19.02.2017, 15:13 Uhr, schrieb Velizar Strumberger : I requested several ties for assistance but there was no answer. Therefore I can conclude on of the following: 1) my questions are >stupid and nobody wants to answer; 2) nobody knows the answer or 3) I am sending my emails to the wrong address. Will somebody please answer with a YES if you can read this e-mail. Thank you Strumbi -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] Importing layers into QGIS 2.18 on Win 7
Just have a google search about "qgis openlayers problems" and you will find multiple issues with openlayers. The rest of my answer is quite self-explanatory. Cheers Bernd Am 20.02.2017, 11:39 Uhr, schrieb Andreas Wicht : Hi, do NOT use the openlayers plugin for basemaps but use QuickMapServices plugin and activate the "Contributed services" in the settings. could you please elaborate on that or point me to a source describing that matter? I am interested in that as I am facing some problems with the OpenLayers plugin in certain scenarios. Cheers Andreas -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Question on Spatialite
Just out of curiosity: Maybe you could try it once with sqlite instead of SpaliaLite and see if there is a difference (If you have some spare 20 minutes ;) ). So you could maybe sort out if its really a SpatiaLite problem or that general OGR problem Nyall pointed to. Cheers Bernd Am 01.03.2017, 23:33 Uhr, schrieb Randal Hale : Attribute! Used Field Calculator to split an attribute to get the zipcode into a standalone column. I then hit save and watched the fun. And yes that seems to be it. Good, I'm not crazy (on this issue). Randy On 03/01/2017 05:23 PM, Nyall Dawson wrote: On 2 March 2017 at 08:08, Randal Hale wrote: I'm using 2.18.4 I'm working with Address point data. My typical process is to import the data into PostGIS/Postgresql and work with it. I decided to work with spatialite and do some data cleanup. I have 222519 points. I made a change to all of them and hit save. What change did you make? Attribute or geometry? How was this change made? It possibly relates to this ongoing work: https://github.com/qgis/QGIS/pull/4175 Nyall So for the next 20 minutes I watched a very small journal file appear and disappear and QGIS just locked up until it was done. QGIS returned to normal and I'm working along again. So my question is - Can I avoid this happening easily or is this just a "it's what happens with spatialite" problem? Am I missing a setting somewhere? Randy -- Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com 423.653.3611 rjh...@northrivergeographic.com twitter:rjhale http://about.me/rjhale http://www.northrivergeographic.com/introduction-to-quantum-gis https://www.facebook.com/NRGSInc ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Bugs
Hi, did you already try to backup your .qgis2 folder and then remove it? When restarting QGIS, this folder will be newly created, though your previously downloaded plugins have to be reinstalled then. Maybe somethings got confused there when updating versions? But it also looks like something is blocking you internet connection ... Do not use the OpenLayers plugin, but the better QuickMapServices plugin and download the "contributed pack" under Settings/More services. Cheers Bernd Am 07.03.2017, 15:43 Uhr, schrieb Youssra Inat : Hello, I contact you because i have currently many problems with qgis 2.18 and even qgis 2.14- The menu Processing disapper completly. - I have also another problem, I could no longer download plugins, and the statut of the official repository >is unvailable- last problem: i can't use the open layer plugin, before it worked correctly but not now it d'ont display any map >(Google, OSM...) Thank you for helping me. Best regards -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] Interpolation plugin error message
Hi, from my experiences longer ago, the interpolation plugin is not really easy to use and seems not to be maintained/enhanced for a long time. Maybe you can find a substitute for your interpolation tasks in the Processing toolbox? Cheers Bernd Am 08.03.2017, 00:23 Uhr, schrieb antonio scotti : Hi all, I am new to this forum and to QGIS I am trying to construct a DEM from contour lines by using QGIS 2.14.0. I am doing this by using a clip rectangle on top of the contour lines and interpolating, by using the interpolation plugin After I enter the data in the interpolation dialog and clic Save I get an exception (se attached file). Any help appreciated Best regards ===PermaCultura-es http://www.permacultura-es.org -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] Real Mask functionality in QGIS?
Am 08.03.2017, 21:08 Uhr, schrieb hilpers : Hello everyone, I regularly face the issue that I want to set masks for layers of my choice based on one layer´s geometry. I know there is a plugin available which handles labels *but not* the geometry of layers to be masked. In my oppinion a mask should make geometries / raster cells outside the specified mask disappear. The user should also be able to exclude layers from being masked. After searching for more than a year, I want to ask how you handle this pretty common scenario. Furthermore, four years after the last discussion about masks here on QGIS Nabble I also want to ask, whether developers are planning to incorporate this feature in V3. It would be great to have that masking capability option within the layer options or even the projects settings. Thanks you forgot to post the link to your feature request from yesterday ;) https://hub.qgis.org/issues/16315 a big +1 from me for such a feature. Cheers Bernd View this message in context: http://osgeo-org.1560.x6.nabble.com/Real-Mask-functionality-in-QGIS-tp5311464.html Sent from the QGIS - User mailing list archive at Nabble.com. ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Real Mask functionality in QGIS?
Am 09.03.2017, 08:28 Uhr, schrieb Neumann, Andreas : Hi Hilpers, Is this about label and symbol backgrounds? We have a QEP about that (see https://github.com/qgis/QGIS-Enhancement-Proposals/issues/63) and an offer from Oslandia. Can you please review this QEP and let us know if it matches your needs? If yes - would you be able to contribute financially? It is quite complex to implement this and I have to collect around 18k € to finance >it. So I would be interested in financial contributions. Thank you for your reply, Andreas Hi Andreas, as I understood the feature request, he means a "real" mask that is not only masking the display, but all features outside of the mask for any geoprocessing. I faintly rember this from ArcGIS which I didn't use for ages, so I have no idea how well this is working how its done technically. But the idea, that when working with numerous layers of different extent, not to have to crop them them each individually to fit into a window of interest, but just to assign a mask layer/bbox to them, sounds very good to me. Cheers Bernd On 2017-03-08 21:08, hilpers wrote: Hello everyone, I regularly face the issue that I want to set masks for layers of my choice based on one layer´s geometry. I know there is a plugin available which handles labels *but not* the geometry of layers to be masked. In my oppinion a mask should make geometries / raster cells outside the specified mask disappear. The user should also be able to exclude layers from being masked. After searching for more than a year, I want to ask how you handle this pretty common scenario. Furthermore, four years after the last discussion about masks here on QGIS Nabble I also want to ask, whether developers are planning to incorporate this feature in V3. It would be great to have that masking capability option within the layer options or even the projects settings. Thanks -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Real-Mask-functionality-in-QGIS-tp5311464.html Sent from the QGIS - User mailing list archive at Nabble.com. ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] API REQUIRED from OSM cycle map
Hi, is there a specific need for you to use the OpenLayers plugin? Maybe you could try to add the service to the QuickMapServices plugin more easily (under settings) Cheers Bernd Am 24.03.2017, 12:10 Uhr, schrieb Frederico dos Santos Soares : Hi everybody I'm having some problems with the OpenStreetMap's services in openlyers's plugin.In fact the problem is the 'API Require Key' in cyclemap.I did my login in Thunderforest and with the URL (with my token) given by Thunderforest's site, I substituted the URL in >OpenLyers's files (xml and html files). This is an exemple of URL that I used: https://{s}.tile.thunderforest.com/cycle/{z}/{x}/{y}.png?apikey=cc63d6d... I alredy tried remove the {s} from URL I'm using QGIS2.14. Someone had passed thru the same thing and solve the problem? Thanks. -- Frederico dos Santos Soares Geógrafo 55 61 8416 0105 fss...@gmail.com -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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 2.18.5 got deinstalled after updating ubuntugis dependencies
Hi again, had a running 2.18.4. Then an update to 2.18.5 came in. A day later, some dependencies got updated, but obviously QGIS itself got deinstalled and is conflicting with some dependencies. Shame on me that I was again so careless to just run the updates. Anyone knows what is going on and how to revert to a working QGIS with ubuntugis features on Linux Mint/Ubuntu xenial Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Any working geotag-plugin available?
Hi, for long time, I didn't have to import geotagged images into QGIS. Now that I try to, I seem to hit a dead end road, cause all plugins I tried crash or throw errors. Photo2shape crashes QGIS completely photo2kmz throws a python error: KeyError: 2 Traceback (most recent call last): File "/home/bernd/.qgis2/python/plugins/photo_to_kmz/photo_to_kmz.py", line 160, in run lat = [float(x)/float(y) for x, y in a['GPSInfo'][2]] KeyError: 2 geotag and import photos: OSError: [Errno 2] Datei oder Verzeichnis nicht gefunden Traceback (most recent call last): File "/home/bernd/.qgis2/python/plugins/geotagphotos/importphotosdialog.py", line 88, in selectPhotosDir self.loadTags(dirName) File "/home/bernd/.qgis2/python/plugins/geotagphotos/importphotosdialog.py", line 125, in loadTags with et: File "/home/bernd/.qgis2/python/plugins/geotagphotos/exiftool.py", line 179, in __enter__ self.start() File "/home/bernd/.qgis2/python/plugins/geotagphotos/exiftool.py", line 162, in start stderr=devnull) File "/usr/lib/python2.7/subprocess.py", line 711, in __init__ errread, errwrite) File "/usr/lib/python2.7/subprocess.py", line 1343, in _execute_child raise child_exception OSError: [Errno 2] Datei oder Verzeichnis nicht gefunden Using QGIS 2.18.5 on Linux Mint Any ideas how to solve this problem? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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 2.18
Hi Martin, as far as I remember, there was a discussion about the different modes of the toolbox, and most agreed that they were not really useful, so they got removed. Cheers Bernd Am 11.04.2017, 19:33 Uhr, schrieb Martin Bittens : Dear QGIS Community. I am using the QGIS versions 2.18 (32bit and 64bit). Recently I noticed that the panel with the processing toolbox does not show anymore the button which can be used to switch between the simplified and advanced view. As far as I remember after the first installation of QGIS, on the bottom of the panel appeared something (written in blue color) like '...add a new provider, simple view, or close'. I clicked on close, and then these options never came back. Does anybody know how to reactivate this settings? Thank you so much. Regards Martin ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Attribute Table
Am 22.04.2017, 16:12 Uhr, schrieb Anke zur Gölden : Hello is there a way to have more then 9 characters as a header for each colomn in the attribute table? Anke For or any modern format yes, but not for ancient ESRI Shape files. Try to use other formats like sqlite, SpatiaLite etc. Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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 Composer Rewrite and Layout Engine crowdfund – half, way there!
Am 22.05.2017, 11:52 Uhr, schrieb Neumann, Andreas : Hi Jonathan, One way to contribute smaller amounts is to donate to QGIS.ORG (see http://www.qgis.org/en/site/getinvolved/donations.html) - either >through wire transfer or PayPal and mention "QGIS composer rewrite" in the payment instructions. For Paypal, just forward your >payment confirmation to fina...@qgis.org and mention that you want to contribute this amount to the "QGIS composer rewrite" crowd >funding campaign. I'd be happy to aggregate such donations (marked as contributions and forward them to Nyall. The minimum amount is just to reduce >bureaucracy and the loss of payment fees (payments to Australia often come with a hefty payment fee - maybe not from the uk, but >from many other countries). QGIS.ORG would be happy to step in in this case and relieve Nyall from such bureaucracy. Thanks and greetings, Andreas Neumann QGIS.ORG treasurer Ahh, this could have been mentioned much earlier! Await my micro-donation ;) Cheers Bernd On 2017-05-22 11:35, Jonathan Webb wrote: I looked at the Crowdfund page & the minimum donation is 200 euros. Is there way local usergroups or some other method that could aggregate donations from smaller users that are below this threshold? Cheers, Jonathan --Jonathan WebbFreelance GIS Specialist07941 921905 http://www.jwebbgis.co.uk http://uk.linkedin.com/in/jwebbgis ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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 Composer Rewrite and Layout Engine crowdfund – half, way there!
Am 22.05.2017, 13:03 Uhr, schrieb Neumann, Andreas : Hi Bernd et al, I don't want to advertise the micro-donations too much. And please don't send 10 cents or so ;-) Seriously - the microdonations are fine and well-meant, but with micro-donations you can't finance 30k. At least this is fact from other >crowd funding campaigns in the past. BTW: at https://qgisblog.files.wordpress.com/2017/02/qgis-org-donationsandsponsorshipanalysis2016-2.pdf you can see the ratio of >donations and sponsorships. Donations make a little more than a quarter of the QGIS.ORG income - three quarters is from >sponsorships. However, we are very grateful for any contribution, no matter the size. Andreas Of course you are right. I will try and see if sth can be managed over the german user group to lift the work from you guys. Cheers Bernd On 2017-05-22 11:58, Bernd Vogelgesang wrote: Am 22.05.2017, 11:52 Uhr, schrieb Neumann, Andreas : Hi Jonathan, One way to contribute smaller amounts is to donate to QGIS.ORG (see http://www.qgis.org/en/site/getinvolved/donations.html) - >>>either through wire transfer or PayPal and mention "QGIS composer rewrite" in the payment instructions. For Paypal, just forward >>>your payment confirmation to fina...@qgis.org and mention that you want to contribute this amount to the "QGIS composer >>>rewrite" crowd funding campaign. I'd be happy to aggregate such donations (marked as contributions and forward them to Nyall. The minimum amount is just to >>>reduce bureaucracy and the loss of payment fees (payments to Australia often come with a hefty payment fee - maybe not from the >>>uk, but from many other countries). QGIS.ORG would be happy to step in in this case and relieve Nyall from such bureaucracy. Thanks and greetings, Andreas Neumann QGIS.ORG treasurer Ahh, this could have been mentioned much earlier! Await my micro-donation ;) Cheers Bernd On 2017-05-22 11:35, Jonathan Webb wrote: I looked at the Crowdfund page & the minimum donation is 200 euros. Is there way local usergroups or some other method that could aggregate donations from smaller users that are below this threshold? Cheers, Jonathan --Jonathan WebbFreelance GIS Specialist07941 921905 http://www.jwebbgis.co.uk http://uk.linkedin.com/in/jwebbgis ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] GRASS support lost (again) on Ubuntu/Mint
Am 26.09.2017, 10:40 Uhr, schrieb Patrick Dunford : There are some issues supporting xenial, are you able to test on a more recent version of Ubuntu or Debian, maybe in a virtual >machine. I am going to have a look at my 17.04 vm with the latest 2.18 to see. I wonder why xenial should have support issues, being the LTS-version. I would not recommend Mint - apart from being not an officially supported distro, the most recent version is based on what is now >relatively old Ubuntu xenial, because the Mint people are falling behind in development. I switched to Xubuntu to avoid the Unity >controversy. Mint also has updates, so I do not see the point switching to somewhere else. The main problem here is imho that ubuntugis-unstable and the qgis repositories are very often out of sync. But a QGIS without all the bells and whistles from ubuntugis is quite useless for me. Cheers Bernd On 26/09/17 21:36, Micha Silver wrote: After the recent update to QGIS 2.18.13, GRASS support is gone. No plugin and no provider. My apt sources includes: deb http://qgis.org/ubuntugis xenial main deb-src http://qgis.org/ubuntugis xenial main deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu xenial main deb-src http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu xenial main The packages are installed: $ dpkg -l | grep plugin-grass ii qgis-plugin-grass 1:2.18.13+24xenial-ubuntugis amd64GRASS plugin >>for QGIS ii qgis-plugin-grass-common 1:2.18.13+24xenial-ubuntugis all GRASS plugin >>for QGIS - architecture-independent data $ dpkg -l | grep provider-grass ii qgis-provider-grass 1:2.18.13+24xenial-ubuntugis amd64GRASS >>provider for QGIS More info: $ gdalinfo --version GDAL 2.2.1, released 2017/06/23 $ grass --version GRASS GIS 7.2.2 Running 'qgis --debug & ' does not show anything unusual. This is getting tiresome - every few months a routine system upgrade trashes GRASS support. Any suggestions are welcome, Thanks, Micha --Micha Silver Ben Gurion Univ. Sde Boker, Remote Sensing Lab cell: +972-523-665918 ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] ubuntugis-nightly: No providers for GRASS and SAGA in Processing?
Hi, just installed the development version on Ubuntu xenial from ubuntugis-nightly repository. In processing, there are only the qgis algos, but no grass nor saga. In the settings, there is nothing shown about them. Do I miss sth, or are the other providers not included yet? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] ubuntugis-nightly: No providers for GRASS and SAGA in Processing?
Hi Pattrick, sorry, but I do not understand what you are talking about. I'm running the nightlies of the development version and have the ubuntugis-unstable ppa activated. GRASS and SAGA are present in the ppa and are running individually without a problem. They are just not available through QGIS processing. As the nightlies are built frequently, any changes on ubuntugis should be adopted to within a short time. But there are still no providers for GRASS and SAGA. What does this have to do with the version of my OS? All necessary sources derive directly from qgis.org or ubuntugis-unstable, as far as I can see. Cheers Bernd Am 27.09.2017, 23:12 Uhr, schrieb Patrick Dunford : you can run masters up to 313ec55 (January 2017) without ubuntugis on xenial, I use this one all the time as it is stable and reliable while I am waiting for some bugs to be fixed in latest masters. I can see your problem if you want to use the latest master though. Mostly I take that option to avoid having to convert my project files back to 2.18 having been doing my real life projects on 2.99 since it first came out. On 28/09/17 09:57, Patrick Dunford wrote: Another thread we just talked about this, it's an issue with the units not being available in ubuntugis yet Only xenial and older require ubuntugis for the latest versions, if you are running 16.10 or later, or a later debian, these issues don't occur. On 28/09/17 04:14, Bernd Vogelgesang wrote: Hi, just installed the development version on Ubuntu xenial from ubuntugis-nightly repository. In processing, there are only the qgis algos, but no grass nor saga. In the settings, there is nothing shown about them. Do I miss sth, or are the other providers not included yet? Cheers Bernd ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] ubuntugis-nightly: No providers for GRASS and SAGA in Processing?
Hi Patrick, set up a VM with zesty and QGIS 2.99 from the debian-nightly repository WITHOUT ubuntugis. And ... tada ... no GRASS nor SAGA algos in processing again. So in which way is this a solution? Cheers Bernd Am 28.09.2017, 10:39 Uhr, schrieb Patrick Dunford : It's simply that you can eliminate the ubuntugis dependency as a later release of Ubuntu does not require it. Running Qgis in a Vm is also a viable option if you can't change the OS on your computer. I run Qgis now in VMs because I can doe 100% of the things that I could do natively and I have drawn hundreds of kilometres of production maps with the development masters running in Virtualbox desktop VMs. On 28/09/17 20:19, Bernd Vogelgesang wrote Hi Pattrick, sorry, but I do not understand what you are talking about. I'm running the nightlies of the development version and have the ubuntugis-unstable ppa activated. GRASS and SAGA are present in the ppa and are running individually without a problem. They are just not available through QGIS processing. As the nightlies are built frequently, any changes on ubuntugis should be adopted to within a short time. But there are still no providers for GRASS and SAGA. What does this have to do with the version of my OS? All necessary sources derive directly from qgis.org or ubuntugis-unstable, as far as I can see. Cheers Bernd Am 27.09.2017, 23:12 Uhr, schrieb Patrick Dunford : you can run masters up to 313ec55 (January 2017) without ubuntugis on xenial, I use this one all the time as it is stable and reliable while I am waiting for some bugs to be fixed in latest masters. I can see your problem if you want to use the latest master though. Mostly I take that option to avoid having to convert my project files back to 2.18 having been doing my real life projects on 2.99 since it first came out. On 28/09/17 09:57, Patrick Dunford wrote: Another thread we just talked about this, it's an issue with the units not being available in ubuntugis yet Only xenial and older require ubuntugis for the latest versions, if you are running 16.10 or later, or a later debian, these issues don't occur. On 28/09/17 04:14, Bernd Vogelgesang wrote: Hi, just installed the development version on Ubuntu xenial from ubuntugis-nightly repository. In processing, there are only the qgis algos, but no grass nor saga. In the settings, there is nothing shown about them. Do I miss sth, or are the other providers not included yet? Cheers Bernd ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] ubuntugis-nightly: No providers for GRASS and SAGA in Processing?
Hi Jürgen, thanks for the information! Bernd Am 11.10.2017, 00:00 Uhr, schrieb Jürgen E. Fischer : Hi Bernd, On Wed, 27. Sep 2017 at 17:14:22 +0200, Bernd Vogelgesang wrote: just installed the development version on Ubuntu xenial from ubuntugis-nightly repository. In processing, there are only the qgis algos, but no grass nor saga. In the settings, there is nothing shown about them. Do I miss sth, or are the other providers not included yet? Not a packaging issue. saga and grass7 are currently disabled processing providers (see https://github.com/qgis/QGIS/blob/master/python/plugins/processing/core/Processing.py#L57 ). Jürgen -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] 2.18.13: WMS caching deactivated?
Hi, im using the ubuntugis nightlies on Linux. For some time I have the impression, that WMS caching does not work anymore. My usual ortho image WMS I use takes ages to load, and normally it showed the numbers of tiles dowloaded/loaded from chache. This doesn't happen anymore. Is this a local problem or do others observe this as well? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Map tips: Show photos with HTML
Hi, I found several topics on the web how to display photos in a Map Tip of a layer, but all seem to have stopped working. My attributes hold the absolut path to the image, I enclose them with the necessary tags, but no images show up, whatever I try. I remember that this worked a while ago. At least in recent QGIS 2.18.13, not a single method seems to work anymore. Does anyone know what is going on there? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] How to create a spatial view with spatialite-gui?
Hi, I am trying to create a spatial view in spatialite-gui. The not funny thing is: It doesn't work. For you to test: Just import a layer from QGIS into a spatialite database. Connect to the database in spatialite-gui. Right-click on the DB and start the "Query/View Composer" Tab Main: Select your layer in "Main Table" an mark all displayed columns. Tab View: Just skip tother tabs and simply replicate you layer as a spatial view by selecting "Create Spatial View"[could be used as a GIS Layer". The input to select the geometry column (in my case "geom", which was also selected in the Main Tab) get active, so select it. Give a name to your new view, and the SQL statement should be ready by now. Click OK. Result: The created view lacks all spatial stuff and imports into QGIS as a dumb table. I remember having tried this years ago already, searching the web high and low for answers, but it hard to find a lot about spaialite at all. Is this all a bug or just a feature or am I just too stupid to see the obvious? Any hints and references to useful documtes highly appreciated! Cheers, Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Basic Help
Hi, Am 27.10.2017, 19:29 Uhr, schrieb Louise Duffy : I don't know if this is the correct format for asking these questions, so please re-direct me as needed. I am used ArcMap for many years to perform pretty basic stuff, but I am not finding QGIS to be as easy of a transition as I had hoped. I am now self->employed, doing some part time consulting for a few clients and I do not have the budget to buy ESRI products, especially when QGIS has such promise. QGIS is for free, but it will cost you sth neverthelless: Time (while ArcMap costs you money AND time) In the past, my normal use of GIS was to pretty focused on being able to connect dots from GPS data, digitize features using aerial photography and other >basemaps. Producing a variety of maps for projects that included exported tables of that data to show coordinates, lengths, area or other characteristics. I think this is what the majority of QGIS users do as well. I downloaded QGIS version 2.14.19-Essen. I am not familiar with programming languages, scripts or other behind the scenes stuff. When I have looked at >tutorials QGIS has, the screens do not match what I see or the process does not work as expected. I don't know if I am missing something with the install or >just need a friendly guide to point the way. QGIS has a very fast development, so resources often can't keep the pace and get outdated. But as Patrick mentioned, https://gis.stackexchange.com is good resource to find answers and learn, or even ask own questions (after proving that you could not find a suitable answer there). Right now, I specifically need help with four things: In some parts, QGIS workflows still require the use of plugins. add basemaps from external sources (aerial, street, usgs quad), For adding basemaps, install QuickkMapServices (which by default only ships a few basmaps, so you can extend it through the plugins settings: Settings/More services -> Get contributed pack) ArcMap folks tend to think that the ESRI-way is the only valid way to do things. QGIS does not "pollute" your attribute table with the informations you are used to have and now ask for, but you can add them quickly. calculate/display area of polygons in attribute table; Open attribute table, open field calculator, create new field "area", pick format/field length/precision. In the search field to the right, enter "area". The search shows you e.g. "$area" under "Geometry". Just double-click on $area", it shows up in the expression field -> OK add X,Y coordinates of existing points to attribute table; Do similar with a new x and y field: search for x, double-click $x (and have a look at all the other functions available) etc etc. Or even easier: Click Processing in the Menu bar, Activate the Toolbox, Search for "Add": Under QGIS geoalgorithms -> Vector table tools, you will find Export/Add geometry columns. This will not change your original dataset, but creates a new temporary copy (which you will have to make permanent later by "Save as...) search for and add points based on X,Y coordinates. Right-click somewhere in the Menu bar and activate the "Advanced digitizing panel" Make your point layer editable enable advanced digitizing tools (look at the popup-hints that show when hovering the symbols. The x and y fields get active. Enter your coordinates and lock them (with the lock symbol). You get a cross-hair showing the position. Digitizing toolbar: add feature. Click somewhere in the canvas, the new point will be created at the cross-hair position. Thanks! Louise Learn to search and use: Plugins Repository, Field calculator functions, Processing Toolbox functions! Did I miss sth? Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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 to Blender - Converter / free global elevation mesh dataset
Hi Michael, I installed the plugin an tried to test it. So far I got no results. I tried it with a clip of a DEM of 10km radius of the EUR_DEM Dataset. Seems it does not want to finish, the log sais for a while {"percent": 99.93917274939103, "status_desc": "Calculating row 821 of 822"} Maybe you could write some general recommendations about which sizes to use, caveats etc (aka a "little" help file ;)) Cheers Bernd Am 28.10.2017, 15:18 Uhr, schrieb Michael Nolde : Dear mailing list members, I'd like to announce 'geoTriMesh', a Python module I wrote to convert GIS data to the Blender 3D suite. It has full support for donut and multipolygons as well as coordinate systems. It works by creating a topological mesh by triangulating coordinate information from the polygon and merging it with elevation and color raster data. The result is written to X3D to be imported into Blender (or other 3D modelling environments). VTK unstructured grids for visulisation in ParaView are also supported. It's free (Apache License) and available as Python Module (installable via pip) as well as QGIS Plugin: https://github.com/flatpolar Also, I used the library to create a global elevation mesh dataset (spherical and flat projection), which can be downloaded here and used for private or commercial 3D modelling projects (CC-BY license): http://flatpolar.org/tocomee.html A detailed description of the dataset is available here: http://ijsdir.jrc.ec.europa.eu/index.php/ijsdir/article/view/455 I'm happy to receive feedback. Cheers, Michael ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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 to Blender - Converter / free global elevation mesh dataset
Hi Michael, besten Dank für die Infos. Pottenstein ... bist Du aus der Gegend? Grüße aus Baiersdorf Bernd Am 03.11.2017, 14:56 Uhr, schrieb Michael Nolde : Hi Bernd, Admittedly, geoTriMesh does get rather slow when using "larger" input datasets. So you either might want to test with some lower >resolution data, or use the tiling-option, which seperates the input data into smaller subsets. For testing purposes, I included some sample files within the download, you can find them in the plugin-directory (\geoTriMeshQGIS>\lib\geotrimesh\demodata). For a low resolution test run, you can use, for example: Bondaries: 'osm_2017_pottenstein_simple.shp' DEM: 'gtopo30_1996_clip_pottenstein.tif' Orthofoto: 'bmng_2004_clip_pottenstein.tif' It should not take longer than a couple of seconds. I totally agree that a little help file would be useful. I will see to writing some more documentation in the near future. Best regards, Michael Message: 3 Date: Sun, 29 Oct 2017 14:14:45 +0100 From: "Bernd Vogelgesang" To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] QGIS to Blender - Converter / free global elevation mesh dataset Message-ID: Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes Hi Michael, I installed the plugin an tried to test it. So far I got no results. I tried it with a clip of a DEM of 10km radius of the EUR_DEM Dataset. Seems it does not want to finish, the log sais for a while {"percent": 99.93917274939103, "status_desc": "Calculating row 821 of 822"} Maybe you could write some general recommendations about which sizes to use, caveats etc (aka a "little" help file ;)) Cheers Bernd -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374___ 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] Greek characters in attribute table
Hi, I downloaded some sample and there was a cpg-file (open in text editor) telling me UTF-8. That would be the other way round, from System to UTF-8 then. So best check for those cpg-files. Cheers Bernd Am 05.11.2017, 20:58 Uhr, schrieb Andre Joost : Am 05.11.2017 um 17:12 schrieb Tilemachos Moymoyris: Greetings from Greece,I would like to ask a very common question about greek and attribute table. I run win10 32bit and Qgis 2.18.14. When i download shapefiles from geodata.gov.gr i am not able to view names in attribute table in greek. I get only questionmarks. I have tried changing the encoding when opening the file and also i have tried to open the dbf file and change the encoding there. I cannot view neither in the dbf file the correct characters. In the layers properties, you have to change the encoding from "System" or "utf-8" to "Greek" or "ISO-8859-7". HTH, André Joost ___ 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 -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] ubuntugis: Broken after update to 2.18.14
Hi, update broke QGIS. Tested with ubuntugis-nigthly-release and ubuntugis on Xenial. Any ideas? Cheers Bernd Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: python-qgis : Depends: python-qgis-common (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Depends: libqgis-analysis2.18.14 but it is not going to be installed Depends: libqgis-server2.18.14 but it is not going to be installed qgis : Depends: gdal-abi-2-2-1 but it is not installable Depends: libqgis-analysis2.18.14 but it is not going to be installed Depends: libqgis-app2.18.14 but it is not going to be installed Depends: qgis-providers (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Depends: qgis-common (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Recommends: qgis-plugin-globe but it is not going to be installed qgis-plugin-grass : Depends: qgis-plugin-grass-common (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Depends: qgis-provider-grass (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Depends: libqgis-app2.18.14 but it is not going to be installed E: Unable to correct problems, you have held broken packages. -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] ubuntugis: Broken after update to 2.18.14
Am 24.11.2017, 20:11 Uhr, schrieb Angelos Tzotsos : Hi, We updated GDAL in UbuntuGIS yesterday so QGIS packages need to rebuild. Cheers, Angelos Hi Angelo, is there any chance that you could synchronize your efforts a little bit? It's really strange that shortly after the new QGIS point release, the dependencies get changed. If this would happen just once in a while, I wouldn't complain at all. But this feels more like coordinated chaos ;) Thanx for your work Bernd On 11/24/2017 06:14 PM, Bernd Vogelgesang wrote: Hi, update broke QGIS. Tested with ubuntugis-nigthly-release and ubuntugis on Xenial. Any ideas? Cheers Bernd Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: python-qgis : Depends: python-qgis-common (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Depends: libqgis-analysis2.18.14 but it is not going to be installed Depends: libqgis-server2.18.14 but it is not going to be installed qgis : Depends: gdal-abi-2-2-1 but it is not installable Depends: libqgis-analysis2.18.14 but it is not going to be installed Depends: libqgis-app2.18.14 but it is not going to be installed Depends: qgis-providers (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Depends: qgis-common (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Recommends: qgis-plugin-globe but it is not going to be installed qgis-plugin-grass : Depends: qgis-plugin-grass-common (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Depends: qgis-provider-grass (= 1:2.18.14+24xenial-ubuntugis) but 1:2.18.14+git20171123+10b34b9+24xenial-ubuntugis is to be installed Depends: libqgis-app2.18.14 but it is not going to be installed E: Unable to correct problems, you have held broken packages. -- Bernd Vogelgesang Siedlerstraße 2 91083 Baiersdorf/Igelsdorf Tel: 09133-825374 ___ 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] Re: QGIS disappears: Right Desktop?
> I have a problem with QGIS 'master' (OS ubuntu 11.10), ie, after the> run and appears Splash Screen 'QGIS Master' then there is no more (not> working). Please help. thanks>Maybe it's the same i experienced already in previous versions under ubuntu: qgis starts with the splash screen and after that, there is no program visible.In my case i found out, that qgis starts in the next desktop to the right from the desktop you started it.I do not know exactly how to solve this (editing the starting parameters manually i assume), but in the classic version, right-click qgis in the program window bar and select to move it to the next left desktop to have it again back to "normal".___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Win7 64bit: GRASS-plugin nearly nonfunctional (Bernd Vogelgesang)
Hi there, i tried really everything, but the grass plugin really gives me a hard time. First i used a fresh osgeo4w installer advanced: loading a layer is fine when not using advanced options, doing stuff like v.clean.bpol makes grass and qgis freeze in 80% of the time, mostly reporting that it can't delete a hist-file or other problems. Uninstalled everything and used the desktop version: same problems Unistalled that completely and used the standalone version: no luck I'm really desperate now. I have to clean up lots of messy polygons drawn by someone with google earth, and the grass plugin for me is the only way to solve that. Any ideas what might cause that problem on Win7? It seams to me that Grass is somehow not fully allowed to write/delete stuff there. This happens to me on 2 different Win7 64bit machines, so i assume i can't be the only one facing these problems! Cheers Bernd ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Annoying CRS-Problem with EPSG 31468 / 2167
Hi there, in Germany, we still quite often have Gauss-Krüger 4 projection for the source data from clients, formerly edited with ArcGIS. QGIS obviously has some problems with GK4 (EPSG:31468) When i import a shape with a .prj-file from ArcGIS, it doesn't promt for the crs, but immediately loads the shape. The tricky think is: if you do not check the crs manually every time, you run into chaos, cause QGIS always sets the crs to "Pulkovo 1942(83) / Gauss Krueger zone 4 (deprecated)" (EPSG:2167) which has quite an offset to the other crs. I'm quite confident that it's not a problem of the prj-file from ArcGIS, cause when i import a GK4-Layer into GRASS, there set the crs to GK4 as well, do my stuff and then send it back the result to QGIS, there the former EPSG 31468-Layer again is set to EPSG 2167 too !!! Has anyone an idea how to prevent this or what's the reason for this? It's really annoying and quite hard to explain to clients to check everytime the crs when they load a layer file. Greetz Bernd QGIS 1.74, osgeo4w on Win7 64bit ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Annoying CRS-Problem with EPSG 31468 / 2167: Conclusions?
So, the problem was now described thoroughly, but what are the conclusions now?I'm going to spread QGIS in my region in the next months, and it's quite hard to explain to the people, who to 99% work with EPSG 31468-data, that they can't ever rely on any data they produce and that they have to double-check each layer after creation for the right CRS, even if they set it correctly in each setting available?!?I'm not too familiar with all those packages involved handling the CRSs, so can someone please point me the way who to address with this problem?For novice QGIS-users, this "bug" is a real exclusion criterion for QGIS for they will only create crap with it!Again my findings:Options settings: new layers and projects are created with EPSG 31468, promting for CRS ist set.- EPSG 31468-Layers with a prj-file from ArcGIS get loaded as 2167 without promting for the CRS- EPSG 31468-Layers loaded into a EPSG 31468-Region in GRASS are handed back to QGIS as ... 2167- New Layers created in some plugins (like some ftools-plugins), added to the TOC, are in ... 2167 .. or even 3397What can i do? (And i really wonder what all those other german users do and why the don't complain...)Thanx for adviceBernd(QGIS 1.7.4, osgeo4w advanced install, Win7 64bit)___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Donations
I'm glad to tell you, that there is a growing interest of small businesses and even administration offices in getting involved with QGIS. I already had my second training-course for some biologists last weekend. My fees are still too low, but nevertheless i am planning to donate a fixed percentage of each course to the QGIS developers. QGIS made great steps forward in the last year, and i'm looking forward to the next versions to come, and i'm happy to be able to make at least some little financial contributions. (p.s. please consider investing some of my money into some better knowlege-management-platform ;) Mailing-lists may suit nerds, "ordinary" people may regard it as unreadable crap. The forum ... sorry ... sucks too. There are more modern and sustainable ways for exchanging knowledge and provide user interaction than this. Just my 2 cents, do not wanna insult anyone with this.) Message: 3 Date: Tue, 27 Mar 2012 11:58:30 +0200 From: Paolo Cavallini Subject: [Qgis-user] Donations To: qgis-user Message-ID:<4f718f46.4020...@faunalia.it> Content-Type: text/plain; charset=UTF-8; format=flowed Hi all. The next hackfest is approaching, and it is a pleasure seeing that the flow of small donations by happy users is increasing. This is much appreciated, as it is allowing us to support the participation of a number of developers, paving the way for yet another successful meeting. It is encouraging seeing these signs of appreciation. Please keep on helping us to help you. And of course, many thanks to our sponsors. Please All the best. http://qgis.org/en/sponsorship/sponsors.html http://qgis.org/en/sponsorship/donors.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Donations -> Knowledge mananagment platform
A.S: err ... only replied to Gary directly ... really don't know how to work with mailing lists:Hi Gary,hope my non-diplomatic style is not too embarrassing.Now, the mailing list here seems to be the place for the power users and developers, but how do i retrieve infos from that? i already store all those mails and try to do local text search in my mail client, to find answers. But here, the threads are scattered over several digests, and i can't see a way how to get a grip on that in more structured way.The forum seems to be mainly used by novice users, who get answers by a handful of advanced people.The default forum settings are set that you won't get an email notification when someone is answering, so a huge amount of threads die, because the thread-initiators and participants don't get aware that there is something going on. I already asked to change that, but to no avail so far.Then, there are only 3 really useful categories (from the users point of view): Help on using QGIS Build and Install questionsShare Tips, Tricks and Ideas Here most of the communication is done in the first.It's very hard to find threads about a special problem, cause all the topics are just stuffed into one big bucket and novice users often lack the terminology to do successful full-text search to find answers.Solved problems are mostly not marked as such, so you have to do a lot of reading and searching which ends up very often with no results.Then there is this wiki(http://hub.qgis.org/wiki/quantum-gis/How_do_I_do_that_in_QGIS), which is in a concurrence to the "Share Tips, Tricks and Ideas" and it seems that there is not a lot going on too.(besides, writing an article and writing an article in a wiki where you need just another account are two different things and which rejects a lot of people)What i propose is a platform with a single login, which combines all those functions of the forum, mailing lists and wikis.Posts of any kind should be able to be tagged with an activly developed hierachical taxonomy for easier retrieval and interconnection of different types of content.Especially the enormous modularity of QGIS with all its plugins needs a better and more structured way of getting informations of what this and that modules does, what which setting means, what bugs people found, how they found workarounds etc. All this could be accessible just by one taxonomy term with the name of the modul for example, spiced up with sorting for popularity, ratings or whatever.There should also be a group system for different audiences, projects, interests, languages (not everyone is a fluent english reader or writer) so people are able to pick the stuff that suits them and subscribe to certain groups, taxonomy terms, projects, events, working fields etc. and get notified in a structured way when something of their interest had occured.The easier the access to already produced knowledge, the more likely it will be that some people take the effort and collect the bits for own articles, tutorials, working examples etc.I never managed to build sth that i propose myself so far, but i invest quite a time investigating "better" ways to connect communities and generate and preserve knowledge.By doing so, i stumbled upon drupal some years ago, where i see a lot of tools (nearly too many) to build sth that would provide all means to develope a communication and knowledge management strategy.There maybe other platforms, but drupal is the only one i know enough about to be sure that it could solve a lot of issues with a modest investment in time and infrastructure.Thanks for your timeBerndAm 27.03.2012, 20:34 Uhr, schrieb Gary Sherman :>> On Mar 27, 2012, at 10:25 AM, Bernd Vogelgesang wrote:>>> There are more modern and sustainable ways for exchanging knowledge and >> provide user interaction than this. Just my 2 cents, do not wanna >> insult anyone with this.)>>>> Such as?>> -gary>> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=> Gary Sherman> GeoApt LLC> http://geoapt.com> Founder, Quantum GIS> Chair, QGIS PSC> Book:> http://geospatialdesktop.com> "We work virtually everywhere"> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=>>>>>>>>>-- Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: SEXTANTE for QGIS has been released
I know sextante from gvSIG already, and i think its main idea is, to provide a toolbox like in ArcGIS. The current plugin/functions management in QGIS is a bit "chaotic", in the 1.9-version, the plugins are much better sorted according to their scope already. But the sextante-concept seems to be even more user friendly from the start (with search function , functions sorted into trees, not having to fumble through menus and sub-menus when repeating functions) Of course, like with all software functions, you will have to learn how to use them by testing. I have really no idea whats technically behind it, and how good it will integrate into QGIS, or just represents a concurring concept, but i would prefer the sextante-way to become the default one in qgis. Ok, then QGIS will just look like another ArcGIS, but what ? ;) Having kind of model-builder coming with it will be also great news for a lot of people having to perform boring repetitive work all the time. In one word: GREAT ! ;) Bernd Hi Would it be possible to give a 10 000 mile overview of what Sextante does? There is quite a mixture of skill levels in this group and I for one am certainly not well versed into all the tools of the trade. I appreciate the announcement as it provides exposure to possible future tools that could be useful to me, but I believe that for the benefit of your tool/product it is in your interest to bring us less well versed people up to speed. This mailing list in some respects is like a tv channel with a thread like this being an advertisement. If I have to go and read about a product to understand what it does after having seen a tv advert then it has failed. I should not be doing reading to understand what the product does but should be reading to get a better understanding of how the product can be applicable to my specific problem. I did try to read the manual and view a few of the youtube videos in the sextante channel but am still non the wiser. Regards ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Closure of forum
Hi,I'm a bit shocked about what my small remark on maybe spending some donations on creating a knowledgebase for QGIS set loose.My observation is, that the acting people still focus on their prefered tools and ways of communication, and only want to make quick changes and maybe set another link here or there.The ones are happy with mailing lists, the others wanna move more to wikis and the next think that stackexchange is the solution.But my point was not about using existing stuff, but building something completely new, which really fits the needs and is not only a compromise of whats available and what is needed.A forum is no wiki, a wiki can't be used as a ticket system, a mailing list can't serve as "best practice" collection ...I understand, that you all don't want to waste much time on creating such things, but use already available services.And I'm 100% sure that developers shouldn't waste their valuable time on those things anyway, but do what they can do best: develop QGIS!From the users perspective (and i think thats the goal: to use the great things you all develop) this hole fragmented infrastructure has no "face" and it's really confusing.What is really missing is the "glue" between those tools, to make it easier for people to contribute.All this takes a lot of time to take care of, which most people don't have.Thats why i proposed to maybe spend donations for building a community platform, where all functions could be easily found and maintained.I can imagine that a lot of people don't like that idea for their reasons, but i think that's what QGIS really deserves!I'm just another ambitioned QGIS-user and no professional in this field, but i'm sure that if "WE" would decide to go that way, that other people are being found who can help bring things forward. At least we should try ...I myself will find the necessary infos sooner or later using google, but i'm sure that there are thousands of people outside who have no idea about QGIS's potential and value and who will get lost on their way to find answers ...ThanxBernd ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Default QGIS template for Windows users
Not all, or lets better say, nearly no Windows user really knows what the registry is and what to do there without crashing the system, so answers like "look in the registry" are not really helpful! The disappearance of toolbars is a quite common problem in qgis. I found http://osgeo-org.1560.n6.nabble.com/toolbars-which-are-moved-are-away-td4476255.html where is said, that you have to remove \HKEY_CURRENT_USER\Software\QuantumGIS\qgis\UI\state in the registry. When you restart qgis, the key is written again with the default state, and all toolbars are visible again. 1. Re: Default QGIS template for Windows users (Goyo) 2012/5/10 William G. Guthe : The Map Navigation toolbar has disappeared from my QGIS 1.7.4.  The toolbar can be turned on and off under View -> Toolbars, but nothing changes in the GUI. Logged into the same machine as a different user, the toolbar appears and can be managed under View -> Toolbars. I assume there’s a modified default .qgs file in one user’s C:\Users directory that isn’t there for the user who still has the toolbar.  I’ve emptied the .qgis directory for the problem user, but that hasn’t changed anything. Any suggestion on how to restore the default settings when they are inadvertently changed? Look for qgis related keys in the windows registry. Goyo ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] any ideas how to get data from attribute table out of qgis
I can highly recommend using spatialite databases! (postgis seems to be THE solution for all professionals, but spatialite has the charms that even noobs can do it!) QGIS handles "big" datasets from shape files quite inefficient and a lot of actions just lead to a frozen application. The same is valid for exporting data i fear. I found a workaround that is a bit complicated, but is much faster and more reliable than trying to do it with the core mechanisms. 1. create a spatialite database and import your shape: For this i use the spatialite-gui.exe (http://www.gaia-gis.it/gaia-sins/). Its faster and more reliable than the Qspatialite-plugin! With the Qspatialite-plugin, connect to the database-file and load your table as a layer into qgis. 2. Now you can do whatever you want with your attributes. Changes are saved directly into the sqlite database. 3. Export your data: In the spatialite-gui, right click on your table and export the data to txt, csv, dbf etc etc Before i'm able to use postgis in the future, i will for sure use spatialite for all my qgis-work, cause it saved me hours of pain and mostly did what i wanted (and i didn't even discover more than the obvious functionalities yet) -- Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Add table excel and categorize
Hi, 1. adding a csv is not the same like loading a shape. So you can't edit it. Loading as dbf should give you write permissions (OpenOffice/Libre Office still offer dbf support, while new Excel versions don't) 2. I assume you joined the csv to an existing layer? In QGIS 2.0, the joined columns are presented for classification, in 1.8 you will (i think) have to make the join permanent by saving the joined layer to a new one. Then, all attributes are editable as well. Hope I answered your questions Bernd Am 11.11.2013, 19:53 Uhr, schrieb labiancamaril...@libero.it : Dear all members of list, I have to add a table in excel that contains indices calculated for each municipality. I turned the sheet from excel to csv and added to the table of attributes as usual, but I have two problems: 1. Some data (indexes) when combined (the table with common code and other attributes) appear with the word "null", I can add them manually? When I try to add them by editing the appropriate line, but the program does not save the changes. 2. When I want to customize the style, ie I want to categorize the classified data (they are many) and I do not know how to reduce or customize intervals. When I try the option graduated the values joined (indices) to the table (municipalities) do not appear in the column.Thanks. -- Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] R: Re: Add table excel and categorize
Am 12.11.2013 16:01, schrieb labiancamaril...@libero.it: Hi, yes the file is a csv (which has numeric values). Check the csv properties within QGIS -> Fields Tab: See if your fields are really interpreted as integer/real values and NOT string! Cause when this is string, the values can't show up for classification. When you use 2.0 (at least), you might have better luck importing the csv through Layers -> Add delimited text file instead of drag-and-drop into the ToC. There QGIS tries to guess the field type. This might fail as well, cause your original excel sheet might have wrong data. A very popular bug are spaces in front or behind your numbers. You should search and delete them there. There is also the possibility to create an affiliated csvt-file (see http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/), in which you define the field type for the csv. But this is a very tiresome work when you have lots of fields. So, lots of speculations from my side. But we'll see ... Cheers Bernd The layer to add this csv is a shapefile (its table of attributes contains cod, name, lenghts of municipalities). I joined them and infact the table of attributes shows the name of municipalities, lenghts...and corresponding values. I saved it (ESRI Shapefile) and when I select the "Style" to graduate the values, the column shows only the cod. of municipalities, shape leng and area. Can you help me? Thanks a lot Messaggio originale Da: bernd.vogelges...@gmx.de Data: 11/11/2013 21.45 A: , "labiancamaril...@libero.it" Ogg: Re: [Qgis-user] Add table excel and categorize Hi, 1. adding a csv is not the same like loading a shape. So you can't edit it. Loading as dbf should give you write permissions (OpenOffice/Libre Office still offer dbf support, while new Excel versions don't) 2. I assume you joined the csv to an existing layer? In QGIS 2.0, the joined columns are presented for classification, in 1.8 you will (i think) have to make the join permanent by saving the joined layer to a new one. Then, all attributes are editable as well. Hope I answered your questions Bernd Am 11.11.2013, 19:53 Uhr, schrieb labiancamaril...@libero.it : Dear all members of list, I have to add a table in excel that contains indices calculated for each municipality. I turned the sheet from excel to csv and added to the table of attributes as usual, but I have two problems: 1. Some data (indexes) when combined (the table with common code and other attributes) appear with the word "null", I can add them manually? When I try to add them by editing the appropriate line, but the program does not save the changes. 2. When I want to customize the style, ie I want to categorize the classified data (they are many) and I do not know how to reduce or customize intervals. When I try the option graduated the values joined (indices) to the table (municipalities) do not appear in the column.Thanks. -- Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] R: Re: R: Re: Add table excel and categorize
Am 12.11.2013 19:03, schrieb labiancamaril...@libero.it: Excuse me. I forgot. I'm reading an manual, what about GRASS to load this data? Thanks. Boohaa. Never faced something less intuitive like GRASS handles data (Think that's something for the pros). But when you manage to do so successfully, the better. I think the normal way to import as text delimited file should do it, or use the before-mentioned option to save your xls as dbf and just drag and drop. P.S. Reading manuals is veeery good (I never do that ;) ) Messaggio originale Da: labiancamaril...@libero.it Data: 12/11/2013 19.00 A: , Ogg: R: Re: R: Re: [Qgis-user] Add table excel and categorize Hi, thanks a lot. I've solved the problem. CSV is indeed recognized as a string but I downloaded Quantum 2.0 and with some tricks, the system allows to graduate values . When I import CSV use " Custom delimiters " in this way successfully it loads the file. Thank you very much! Messaggio originale Da: bernd.vogelges...@gmx.de Data: 12/11/2013 16.35 A: "labiancamaril...@libero.it", user@lists. osgeo.org> Ogg: Re: R: Re: [Qgis-user] Add table excel and categorize Am 12.11.2013 16:01, schrieb labiancamaril...@libero.it: Hi, yes the file is a csv (which has numeric values). Check the csv properties within QGIS -> Fields Tab: See if your fields are really interpreted as integer/real values and NOT string! Cause when this is string, the values can't show up for classification. When you use 2.0 (at least), you might have better luck importing the csv through Layers -> Add delimited text file instead of drag-and-drop into the ToC. There QGIS tries to guess the field type. This might fail as well, cause your original excel sheet might have wrong data. A very popular bug are spaces in front or behind your numbers. You should search and delete them there. There is also the possibility to create an affiliated csvt-file (see http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns- for-use-in-qgis/), in which you define the field type for the csv. But this is a very tiresome work when you have lots of fields. So, lots of speculations from my side. But we'll see ... Cheers Bernd The layer to add this csv is a shapefile (its table of attributes contains cod, name, lenghts of municipalities). I joined them and infact the table of attributes shows the name of municipalities, lenghts...and corresponding values. I saved it (ESRI Shapefile) and when I select the "Style" to graduate the values, the column shows only the cod. of municipalities, shape leng and area. Can you help me? Thanks a lot Messaggio originale Da: bernd.vogelges...@gmx.de Data: 11/11/2013 21.45 A: , "labiancamaril...@libero.it" Ogg: Re: [Qgis-user] Add table excel and categorize Hi, 1. adding a csv is not the same like loading a shape. So you can't edit it. Loading as dbf should give you write permissions (OpenOffice/Libre Office still offer dbf support, while new Excel versions don't) 2. I assume you joined the csv to an existing layer? In QGIS 2.0, the joined columns are presented for classification, in 1.8 you will (i think) have to make the join permanent by saving the joined layer to a new one. Then, all attributes are editable as well. Hope I answered your questions Bernd Am 11.11.2013, 19:53 Uhr, schrieb labiancamaril...@libero.it : Dear all members of list, I have to add a table in excel that contains indices calculated for each municipality. I turned the sheet from excel to csv and added to the table of attributes as usual, but I have two problems: 1. Some data (indexes) when combined (the table with common code and other attributes) appear with the word "null", I can add them manually? When I try to add them by editing the appropriate line, but the program does not save the changes. 2. When I want to customize the style, ie I want to categorize the classified data (they are many) and I do not know how to reduce or customize intervals. When I try the option graduated the values joined (indices) to the table (municipalities) do not appear in the column.Thanks. -- Bernd Vogelgesang * Siedlerstrasse 2 * 91083 Baiersdorf * +49-9133-825374 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] One-to-many Spatial View in Spatialite. Attribute table doesn't show records as desired
Hi there, I have a polygon layer with an id and a table with multiple species observations on that same id(area) in spatialite I managed to create a spatial view and load it within QGIS. When I use the identification tool on a polygon, all species observations show up correctly in the info tool window, but for browsing these informations, this is not really the best representation. The attribute table on the other hand would be much better to read the infos, but here, all species entries connected with one feature are replaced by the first species data only (e.g. instead of 25 different birds, it shows one entry 25 times. Is this a bug or a feature or are there other tricks to get tabular data of all those entries i can see with the identification tool? The goal is to get a way for a collegue to select a polygon, and immedately see all species found there in a tabular form. Thanx for any help or hint Bernd ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Spatialite VIEW in QGIS question
Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not possible to do. I have a polygon layer in my spatialite database and a normal table with bird observations. There are many observation entries for each item in the polygons. They share the simple field "id". I created dozens of view, following strictly http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/sp-view.html (and i REALLY can't find any other tutorials). When i query "SELECT * FROM "test17"" in Spatialite GUI, it shows all the lines with different observation entries for each polygon id, when i load the VIEW in QGIS, it doesn't but duplicates the first matching observation for one polygon over and over. The idea is to quickly identify all observations when selecting a polygon, and then go to the attribute table to see which species are there. Is it possible to create a one-to-many spatial VIEW with Spatialite GUI ? if yes Whats the trick? if no Is QGIS just not able to show the views table correctly? if no Whats the trick? Wasted many days on that now, and time is running away. Please, someone, help Bernd ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Spatialite VIEW in QGIS question
Am 19.02.2014 16:55, schrieb Alex Mandel: On 02/18/2014 12:29 PM, Bernd Vogelgesang wrote: Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not possible to do. I have a polygon layer in my spatialite database and a normal table with bird observations. There are many observation entries for each item in the polygons. They share the simple field "id". I created dozens of view, following strictly http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/sp-view.html (and i REALLY can't find any other tutorials). When i query "SELECT * FROM "test17"" in Spatialite GUI, it shows all the lines with different observation entries for each polygon id, when i load the VIEW in QGIS, it doesn't but duplicates the first matching observation for one polygon over and over. The idea is to quickly identify all observations when selecting a polygon, and then go to the attribute table to see which species are there. Is it possible to create a one-to-many spatial VIEW with Spatialite GUI ? if yes Whats the trick? if no Is QGIS just not able to show the views table correctly? if no Whats the trick? Wasted many days on that now, and time is running away. Please, someone, help Bernd I usually cheat, and in making my View I do a left join to the attribute table with the geometries. It ends up duplicating the geometries for each match which can be inefficient on a large dataset but works perfectly reasonable most of the time. Then the regular info and select tools return multiple records. Thank you Alex for your answer. I think this combination was the only one I haven't tried yet. But ... the outcome is as depressing as all my other, or even worse. Instead of 37 features i now have 9725, and the attribute table has the same amount of entries instead of some 700. When loading the attribute table, there are only ERROR in the fields, and it took some minutes till I was able to switch to "show only selected". And ... surprise surprise, it again showed just the entry of the first species in all of the rows instead of all the individual observations. Guys, this is a very sad topic and I really can't understand how people can work with 1:n data even on the most basic level under these circumstances ... Or doesn't anyone work with 1:n data? Well, the the world I'm living in is full of that ... After nearly one week of trial and error, I am giving up now. Cheers Bernd I do see potential for a plugin that simply executes a filter on one table based on the selection in another table for a pre-defined relationship (maybe there is one already). Thanks, Alex ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Spatialite VIEW in QGIS question
Am 19.02.2014 19:14, schrieb Steve G: This does not directly answer your question about spatialite views, but you might be able to use relationships directly in QGIS in the near future (I think this is a 2.1 update). See: http://blog.vitu.ch/10112013-1201/qgis-relations -Steve Hi Steve, Actually I do not care by which means I reach my destination, but I had the, maybe wrong; impression that using a spatial database would do the trick. Anyway ... I already installed latest master cause I read about this relation manager thing a while ago ... but I was left quite clueless about how to use it. Searched the web for nearly an hour about any info but to no avail, so many thanks for sharing the link!! Will have a look at it ASAP, maybe thats kind of a solution. Cheers Bernd -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Spatialite-VIEW-in-QGIS-question-tp5104565p5104775.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Spatialite VIEW in QGIS question
Am 19.02.2014 20:06, schrieb Alex Mandel: On 02/19/2014 10:43 AM, Bernd Vogelgesang wrote: Am 19.02.2014 16:55, schrieb Alex Mandel: On 02/18/2014 12:29 PM, Bernd Vogelgesang wrote: Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not possible to do. I have a polygon layer in my spatialite database and a normal table with bird observations. There are many observation entries for each item in the polygons. They share the simple field "id". I created dozens of view, following strictly http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/sp-view.html (and i REALLY can't find any other tutorials). When i query "SELECT * FROM "test17"" in Spatialite GUI, it shows all the lines with different observation entries for each polygon id, when i load the VIEW in QGIS, it doesn't but duplicates the first matching observation for one polygon over and over. The idea is to quickly identify all observations when selecting a polygon, and then go to the attribute table to see which species are there. Is it possible to create a one-to-many spatial VIEW with Spatialite GUI ? if yes Whats the trick? if no Is QGIS just not able to show the views table correctly? if no Whats the trick? Wasted many days on that now, and time is running away. Please, someone, help Bernd I usually cheat, and in making my View I do a left join to the attribute table with the geometries. It ends up duplicating the geometries for each match which can be inefficient on a large dataset but works perfectly reasonable most of the time. Then the regular info and select tools return multiple records. Thank you Alex for your answer. I think this combination was the only one I haven't tried yet. But ... the outcome is as depressing as all my other, or even worse. Instead of 37 features i now have 9725, and the attribute table has the same amount of entries instead of some 700. When loading the attribute table, there are only ERROR in the fields, and it took some minutes till I was able to switch to "show only selected". And ... surprise surprise, it again showed just the entry of the first species in all of the rows instead of all the individual observations. Guys, this is a very sad topic and I really can't understand how people can work with 1:n data even on the most basic level under these circumstances ... Or doesn't anyone work with 1:n data? Well, the the world I'm living in is full of that ... After nearly one week of trial and error, I am giving up now. Cheers Bernd I rarely need to visually explore the 1:n without aggregation. What I love about spatial databases is that I can easily query whatever I want including 1:n but I don't need to click on an individual. What attribute about the second table do you need to know? How many, average x, or even just a list of ids? If you want the Birds per polygon check out the group concat from sqlite: CREATE View birdlists as SELECT group_concat(species), count(species) FROM table1 JOIN table2 ON table1.id = table2.id GROUP BY polygon This gives you the list of birds per polygon as a view of the polygon layer. Yes occasionally you want to click and get a list, I've done this in a web page where you take the id, then query the db to return the rows related. Like I mentioned before a python plugin should be able to do this. Thanks, Alex Hi Alex, we need to have the list of simply all birds that have once been observed there in the past. I need the info of each observation what species, how many of that , year of observation and breeding status ... in short again: all lines from the table that match the polygon id. Nothing to calculate, nothing to group. We need to have an overview what has happened in the past in these areas to be able to find "interesting" species/year/status-combinations to be able to decide about actions. Just tried to build some views manually within the GUI (so without the Query Composer) and these procedures here http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/sp-view.html do not work at all. Seem to be outdated or what, errors over errors and in the end I have geometryless geometries ... perfect. I simply can't believe that none on this planet ever decided to post a simple and working spatialite view creation script for 1:n somewhere in the web as a template. arrghh.. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Spatialite VIEW in QGIS question
Am 19.02.2014 20:02, schrieb Olivier Dalang: Dear Bernd, I encountered some similar problems with Spatialite views, but in the end I had it working (sometimes) both in 2.0 and in master... I used the manual method from the spatialite cookbook though (not the Spatialite GUI). I have no time to test now, but from what I recall, this does not work : CREATE VIEW AS SELECT name, geometry FROM table while this works : CREATE VIEW AS SELECT ROWID, name, geometry FROM table Maybe you want to give it a last try. I can testify I have some working spatialite views here. Let us know if this works, if not I may give it a better look when I have some time. Another method is running a SELECT query in the DB Manager in QGIS, and then choosing "Add to map canvas". This is not an actual sqlite view, but depending on what you need, it could be enough. Hi Olivier, added ROWID to the VIEW. Same result in QGIS. I also performed the select in the DB Manager as you proposed. When executed, it perfectly show the results i would like to see in the attribute table, but what "arrives" in the attribute table after loading as layer is again the duplication of the the first entry for ROWID of the polygon. So, this is my select: Anything important missing? SELECT "a"."ROWID" AS "ROWID", "a"."Geometry" AS "Geometry", "b"."zahl" AS "zahl", "b"."jahr" AS "jahr", "b"."art" AS "art", "b"."sta" AS "sta" FROM "ASK_VOEGEL" AS "a" JOIN "ask_art" AS "b" USING ("id") Thanx for your time Bernd Good luck ! Olivier 2014-02-19 19:54 GMT+01:00 Bernd Vogelgesang <mailto:bernd.vogelges...@gmx.de>>: Am 19.02.2014 19:14, schrieb Steve G: This does not directly answer your question about spatialite views, but you might be able to use relationships directly in QGIS in the near future (I think this is a 2.1 update). See: http://blog.vitu.ch/10112013-1201/qgis-relations -Steve Hi Steve, Actually I do not care by which means I reach my destination, but I had the, maybe wrong; impression that using a spatial database would do the trick. Anyway ... I already installed latest master cause I read about this relation manager thing a while ago ... but I was left quite clueless about how to use it. Searched the web for nearly an hour about any info but to no avail, so many thanks for sharing the link!! Will have a look at it ASAP, maybe thats kind of a solution. Cheers Bernd -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Spatialite-VIEW-in-QGIS-question-tp5104565p5104775.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org> http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Spatialite VIEW in QGIS question
Am 20.02.2014 18:13, schrieb Olivier Dalang: Bernd, Here's a procedure which works here on QGIS master : 1. Create a spatialite layer "countries" with fields "name" and a geometry column "geom" of type polygon. 2. Add some features to that layer. 3. In the DB manager, create the view: CREATE VIEW countries_influence AS SELECT rowid as rowid, name, Buffer(geom,1) as geom FROM countries 4. In the DB manager, register the view: INSERT INTO views_geometry_columns VALUES ('countries_influence','geom','rowid','countries','geom',1) 5. Reload the database in the DB manager and right-click : "add to the canvas" It does NOT work. 6. From the "layer" menu, choose "add a spatialite layer", navigate to your db, choose the view, and, tadaaam, it WORKS ! Let me know if it works... It seems the bugs comes from that "add to the canvas" function, which sets the source to path/SpatialiteView.sqlite' table="countries_influence" () sql= instead of path/SpatialiteView.sqlite' table="countries_influence" (geom) sql= Regards, Olivier Hi Olivier, thank you for trying to help, but, ermm, actually I do not see the point performing this. I have not really a problem creating views, but more making these functional in QGIS. Your example, as far as i understand, lacks a join-part completely, but thats the culprit I fear. I uploaded my testdb to dropbox. https://www.dropbox.com/s/8b1g97qu3us15tq/asktest3.sqlite There is only layer, a view and the table. Could anyone try it out? When you query the view with SELECT * FROM "Testview22" , I see the list of observation I would like also to see in the QGIS attribute table, but this just doesn't work. It also show 746 rows, but only 37 distinct sets of information. Cheers Bernd 2014-02-20 16:51 GMT+01:00 Bernd Vogelgesang <mailto:bernd.vogelges...@gmx.de>>: > > Am 19.02.2014 20:02, schrieb Olivier Dalang: > > Dear Bernd, > > I encountered some similar problems with Spatialite views, but in the end I had it working (sometimes) both in 2.0 and in master... I used the manual method from the spatialite cookbook though (not the Spatialite GUI). > > I have no time to test now, but from what I recall, this does not work : > CREATE VIEW AS SELECT name, geometry FROM table > while this works : > CREATE VIEW AS SELECT ROWID, name, geometry FROM table > > Maybe you want to give it a last try. I can testify I have some working spatialite views here. Let us know if this works, if not I may give it a better look when I have some time. > > Another method is running a SELECT query in the DB Manager in QGIS, and then choosing "Add to map canvas". This is not an actual sqlite view, but depending on what you need, it could be enough. > > > Hi Olivier, > added ROWID to the VIEW. Same result in QGIS. > > I also performed the select in the DB Manager as you proposed. When executed, it perfectly show the results i would like to see in the attribute table, but what "arrives" in the attribute table after loading as layer is again the duplication of the the first entry for ROWID of the polygon. > > So, this is my select: Anything important missing? > > SELECT "a"."ROWID" AS "ROWID", "a"."Geometry" AS "Geometry", > "b"."zahl" AS "zahl", "b"."jahr" AS "jahr", "b"."art" AS "art", > "b"."sta" AS "sta" > FROM "ASK_VOEGEL" AS "a" > JOIN "ask_art" AS "b" USING ("id") > > > Thanx for your time > Bernd > > > Good luck ! > > Olivier > > > > > > 2014-02-19 19:54 GMT+01:00 Bernd Vogelgesang mailto:bernd.vogelges...@gmx.de>>: >> >> Am 19.02.2014 19:14, schrieb Steve G: >> >>> This does not directly answer your question about spatialite views, but you >>> might be able to use relationships directly in QGIS in the near future (I >>> think this is a 2.1 update). See: >>> >>> http://blog.vitu.ch/10112013-1201/qgis-relations >>> >>> >>> -Steve >> >> >> Hi Steve, >> Actually I do not care by which means I reach my destination, but I had the, maybe wrong; impression that using a spatial database would do the trick. >> Anyway ... >> I already installed latest master cause I read about this relation manager thing a while ago ... but I was left quite clueless about how to use it. >> Searched the web for nearly an hour about any info but to no avail, so many thanks for shari
Re: [Qgis-user] Spatialite VIEW in QGIS question
Dear folks, thanks a lot for all who tried to help. I have a working solution now, which I will hopefuly be able to forge into some script, so all steps for many layers will run more automatic. I maybe had other working solutions before, but I made the mistake and didn't see that I had selected the "one object only" selection mode in QGIS ... so of course it only picked the most up laying polygon and couldn't show me more info than just one row in the attribute table ... too bad. Sandro Furieri was so kind to help me along as well https://mail.google.com/mail/u/0/?shva=1#inbox/144507c0ecb4c392 The things that were important: not to have a ROWID in the joined table, but rename it Creating a table instead of a view. ("... SQL VIEWs are rather extravagant and whimsical objects, and they could easily introduce many hard-to-be-solved undesired side effects. ...") So as a sample for one of my layers, it looks like this now: CREATE VIEW View_PUNKTE AS SELECT a.ROWID AS ROWID, a.Geometry AS Geometry, b.ora_nachweis_id AS ora_nachweis_id, b.zahl AS zahl, b.jahr AS jahr, b.art AS art, b.sta AS sta FROM ASK_PUNKTE AS a JOIN ask_art AS b USING (id); INSERT INTO views_geometry_columns (view_name, view_geometry, view_rowid, f_table_name, f_geometry_column, read_only) VALUES ('view_punkte', 'geometry', 'rowid', 'ask_punkte', 'geometry',1); CREATE TABLE Abfrage_PUNKTE AS SELECT rowid AS old_rowid, Geometry, ora_nachweis_id, zahl, jahr, art, sta FROM View_PUNKTE; SELECT RecoverGeometryColumn('Abfrage_PUNKTE', 'geometry', 31468, 'MULTIPOINT', 'XY'); SELECT CreateSpatialIndex('Abfrage_PUNKTE', 'geometry'); I have now finally realized/accepted, that there is NO WAY to avoid duplication of geometries (very very sad) for 1:n relations in QGIS, so this really bloats the layers ... but thats life. Maybe I could skip some of this and make a table directly from a select, but I'm happy with at least one working solution. Now i will try and put all this into a batch script that will generate me those layers automagically cause filling in all the separate commands for several layers is boring, time consuming an error prone. So thanx mates, Bernd Am 18.02.2014 21:29, schrieb Bernd Vogelgesang: Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not possible to do. I have a polygon layer in my spatialite database and a normal table with bird observations. There are many observation entries for each item in the polygons. They share the simple field "id". I created dozens of view, following strictly http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/sp-view.html (and i REALLY can't find any other tutorials). When i query "SELECT * FROM "test17"" in Spatialite GUI, it shows all the lines with different observation entries for each polygon id, when i load the VIEW in QGIS, it doesn't but duplicates the first matching observation for one polygon over and over. The idea is to quickly identify all observations when selecting a polygon, and then go to the attribute table to see which species are there. Is it possible to create a one-to-many spatial VIEW with Spatialite GUI ? if yes Whats the trick? if no Is QGIS just not able to show the views table correctly? if no Whats the trick? Wasted many days on that now, and time is running away. Please, someone, help Bernd ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Spatialite VIEW in QGIS question
Am 21.02.2014, 22:17 Uhr, schrieb Bo Victor Thomsen : Bernd - I think, that you have misunderstood some of the basic tenets of relational database technology: If you establish a straight 1:n relationships in a relational database (as SQLite, SpatiaLite or Postgres/PostGis) you'll get at least n rows in the resulting view; if you want it otherwise you'll have to use aggregate functions to group and aggregate your results If you want to select 1 row in a main table and afterwards have a look at n rows in a sub-table that's related to the main table by some common field(s) - that's the responsibility of the presentation layer meaning Access, Excel or QGIS . But QGIS hasn't this functionality before ver. 2.2 (which isn't released yet). If you want the above mentioned function in QGIS, you have to wait for QGIS 2.2 or download some bleeding edge QGIS like QGIS Weekly (http://qgis.org/downloads/weekly/) . Look at this article: http://blog.vitu.ch/10112013-1201/qgis-relations Hi Bo,yes, I misunderstood that obviously, or i was "hoping" that those things were already easier in the year of 2014 ;)Anyway, found a working solution my collegue is happy with. I also tested with master yesterday after reading the link about qgis relations, but trying this only crashed the system.But we all are awaiting a bright future with easy to establish 1:n relations, I'm sure of that, and then nothing will stop me ;)ThanxBernd Regards Bo Victor Thomsen Aestas-GIS Denmark Den 21-02-2014 18:23, Bernd Vogelgesang skrev: Dear folks, thanks a lot for all who tried to help. I have a working solution now, which I will hopefuly be able to forge into some script, so all steps for many layers will run more automatic. I maybe had other working solutions before, but I made the mistake and didn't see that I had selected the "one object only" selection mode in QGIS ... so of course it only picked the most up laying polygon and couldn't show me more info than just one row in the attribute table ... too bad. Sandro Furieri was so kind to help me along as well https://mail.google.com/mail/u/0/?shva=1#inbox/144507c0ecb4c392 The things that were important: not to have a ROWID in the joined table, but rename it Creating a table instead of a view. ("... SQL VIEWs are rather extravagant and whimsical objects, and they could easily introduce many hard-to-be-solved undesired side effects. ...") So as a sample for one of my layers, it looks like this now: CREATE VIEW View_PUNKTE AS SELECT a.ROWID AS ROWID, a.Geometry AS Geometry, b.ora_nachweis_id AS ora_nachweis_id, b.zahl AS zahl, b.jahr AS jahr, b.art AS art, b.sta AS sta FROM ASK_PUNKTE AS a JOIN ask_art AS b USING (id); INSERT INTO views_geometry_columns (view_name, view_geometry, view_rowid, f_table_name, f_geometry_column, read_only) VALUES ('view_punkte', 'geometry', 'rowid', 'ask_punkte', 'geometry',1); CREATE TABLE Abfrage_PUNKTE AS SELECT rowid AS old_rowid, Geometry, ora_nachweis_id, zahl, jahr, art, sta FROM View_PUNKTE; SELECT RecoverGeometryColumn('Abfrage_PUNKTE', 'geometry', 31468, 'MULTIPOINT', 'XY'); SELECT CreateSpatialIndex('Abfrage_PUNKTE', 'geometry'); I have now finally realized/accepted, that there is NO WAY to avoid duplication of geometries (very very sad) for 1:n relations in QGIS, so this really bloats the layers ... but thats life. Maybe I could skip some of this and make a table directly from a select, but I'm happy with at least one working solution. Now i will try and put all this into a batch script that will generate me those layers automagically cause filling in all the separate commands for several layers is boring, time consuming an error prone. So thanx mates, Bernd Am 18.02.2014 21:29, schrieb Bernd Vogelgesang: Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not possible to do. I have a polygon layer in my spatialite database and a normal table with bird obse