Re: [Qgis-user] Excel Prep to how one line per location
Hi Sasa, Would use excel to do the manipulation: ·Add 2 columns to original sheet with rownumber number of locations ·Create second sheet that recreates a new list based on lookups/index formulas ·Copy second sheet as values into CSV file Have created simple example file (attached). Hope it works. Frank Van: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] Namens Sasa Sullivan Verzonden: 03 November 2014 20:20 Aan: qgis-user@lists.osgeo.org Onderwerp: [Qgis-user] Excel Prep to how one line per location Hi All, I need to prep an Excel spreadsheet. Thousands of names and each name with multiple locations (some with as few as 3 and others with over 30 locations). Is there a way to make a line item for the name (which is only listed once initially) based on each location? So If I have Bob Smith row with columns that show his 12 locations can I do something to automate my spreadsheet to show Bob Smith with each location on a separate line? There are also other columns that need to be duplicated but those would remain the same with each line item, only the location would be made a new line item. Thanks much in advance Best Regards, Sasa ExcelExample.xlsx Description: MS-Excel 2007 spreadsheet ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Python script to iterate through attributes and then refresh the canvas - doesn't show any map....
Hi, Am completely stuck with a QGIS project in Python and tried everything but nothing seems to work. The python script does work as such BUT the canvas never shows the map and therefor the exported maps are empty…. What I’m trying to achieve: * Create a Python script that iterates through a series of ca. 2500 polygons based on attribute value, zoom to layer extend and save the canvas for each attribute as an image file. * I then use the image files in other documents The issue is that while manually I get the canvas to reload and display the map, this doesn’t happen when running the python script. Have tried couple of ways: 1. Don’t load the project each time and just change the filter 2. Add sleep timers to give the canvas time to refresh etc. 3. Tried different QGIS versions (2.2, 2.4 2.6 on Win 64x) But all to no avail…. Hope somebody’s got a great idea how to solve it. Regards, Frank Python code: # File location specifications PROJECTPATH = 'C:/Users/Frank/Documents /Targetting/Kaarten/' PROJECTFILE = 'C:/Users/Frank/Documents /Targetting/TargettingkaartV26qgs.qgs' EXTSNAPSHOTS = '.jpg' EXTSNAPSHOTS2 = '.png' SUFFIX = '65Plus_v1' last_id = 1 while last_id 5: # Clear map canvas QgsMapLayerRegistry.instance().removeAllMapLayers() qgis.utils.iface.mapCanvas().refresh() # Open QGIS project QgsProject.instance().setFileName(PROJECTFILE) QgsProject.instance().read() qgis.utils.iface.mapCanvas().refresh() time.sleep(30) canvas = qgis.utils.iface.mapCanvas() acl = canvas.layer(0) qgis.utils.iface.mapCanvas().layer(0).selectAll() selection = 'RijNo = ' + str(last_id) acl.setSubsetString( selection ) acl.triggerRepaint canvas.layer(1).triggerRepaint time.sleep(5) qgis.utils.iface.setActiveLayer(acl) # Zoom in and out to refresh potential issues with OpenLayer canvas.zoomByFactor(3) canvas.zoomByFactor(0.5) qgis.utils.iface.zoomToActiveLayer() qgis.utils.iface.mapCanvas().refresh() time.sleep(10) # Save project p=QgsProject.instance() p.setFileName(PROJECTFILE) p.write() # Save content of map canvas as image p = str(last_id) + 'kaart_' qgis.utils.iface.mapCanvas().saveAsImage(PROJECTPATH+ p + SUFFIX + EXTSNAPSHOTS) last_id = last_id +1 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Download link for QGIS 2.4 Win standalone?
Hi, As I need to support older QGIS versions in my administration I am now looking for a standalone QGIS 2.4 win 64 installer, because OSGeo4W is now at version 2.6. Unfortunately it turns out it is not easy to find the older versions of the windows standalone installers. I came to http://qgis.org/downloads/ - but it does not contain the 2.4 installers. Can you help me to find the correct download? Thanks a lot, Andreas ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] pansharpening i.pansharpening
For rapid band combinations and pan-sharpening of the latest Landsat-8 satellite imagery, you may take a look at the free and advanced image fusion software from GeoSage. The software with 2 simple button clicks: http://www.geosage.com/highview/features_landsat8.html If you have the latest QGIS installed, click the 3rd button for GeoTFF - KMZ conversion. Hope this helps. On Mon, Oct 20, 2014 at 2:56 AM, Daniel S. dafreshma...@gmx.de wrote: Hello I try to do a pansharpening with some Landsat 8 images. I found this instructions http://planet.qgis.org/planet/tag/landsat/ http://planet.qgis.org/planet/tag/landsat/ but I didn´t find this tool in my QGis 2.4 Grass Gis 7 Toolbox. Someone knows where I can find it? -- View this message in context: http://osgeo-org.1560.x6.nabble.com/pansharpening-i-pansharpening-tp5168267.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] Download link for QGIS 2.4 Win standalone?
Hi Andreas, On Tue, 04. Nov 2014 at 09:45:19 +0100, Andreas Neumann wrote: As I need to support older QGIS versions in my administration I am now looking for a standalone QGIS 2.4 win 64 installer, because OSGeo4W is now at version 2.6. Unfortunately it turns out it is not easy to find the older versions of the windows standalone installers. I came to http://qgis.org/downloads/ - but it does not contain the 2.4 installers. Well, now it's there. But the downloading http://qgis.org/downloads/QGIS-OSGeo4W-2.4.0-1-Setup-x86.exe or http://qgis.org/downloads/QGIS-OSGeo4W-2.4.0-1-Setup-x86_64.exe would still have worked and triggered the redirects even without the files in place. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS release manager (PSC) GermanyIRC: jef on FreeNode signature.asc Description: Digital signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] edit spatialite with db manager
Hi I'm trying to e.g. rename a column of a spatialite layer with db manager. But in the Table properties window the Edit Column and Delete Column buttons are greyed out. Did I miss some depencies or something like that? I'm on QGIS master and Ubuntu 14.04. regards Stefan Freundliche Grüsse Stefan Ziegler Kantonsgeometer Amt für Geoinformation Amtliche Vermessung Rötistrasse 4 4500 Solothurn Telefon +41 32 627 75 96 Telefax +41 32 627 75 98 stefan.zieg...@bd.so.ch http://www.so.ch ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Download link for QGIS 2.4 Win standalone?
Thanks a lot! Andreas On 04.11.2014 09:52, Jürgen E. Fischer wrote: Hi Andreas, On Tue, 04. Nov 2014 at 09:45:19 +0100, Andreas Neumann wrote: As I need to support older QGIS versions in my administration I am now looking for a standalone QGIS 2.4 win 64 installer, because OSGeo4W is now at version 2.6. Unfortunately it turns out it is not easy to find the older versions of the windows standalone installers. I came to http://qgis.org/downloads/ - but it does not contain the 2.4 installers. Well, now it's there. But the downloading http://qgis.org/downloads/QGIS-OSGeo4W-2.4.0-1-Setup-x86.exe or http://qgis.org/downloads/QGIS-OSGeo4W-2.4.0-1-Setup-x86_64.exe would still have worked and triggered the redirects even without the files in place. Jürgen ___ 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] edit spatialite with db manager
Hi Stefan, That's a limitation of sqlite and not of the db-manager. There's a workaround to it http://stackoverflow.com/questions/805363/how-do-i-rename-a-column-in-a-sqlite-database-table Matthias On 04.11.2014 10:04, Ziegler Stefan wrote: Hi I'm trying to e.g. rename a column of a spatialite layer with db manager. But in the Table properties window the Edit Column and Delete Column buttons are greyed out. Did I miss some depencies or something like that? I'm on QGIS master and Ubuntu 14.04. regards Stefan Freundliche Grüsse Stefan Ziegler Kantonsgeometer Amt für Geoinformation Amtliche Vermessung Rötistrasse 4 4500 Solothurn Telefon +41 32 627 75 96 Telefax +41 32 627 75 98 stefan.zieg...@bd.so.ch http://www.so.ch ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Help getting QGIS to the next level of quality before November 15! http://blog.vitu.ch/10102014-1046/crowdfunding-initiative-automated-testing ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Node tool: could not snap to a segment on the current layer
I found the solution The parameter in Options|Digitizing|Snapping Search radius for vertex edits has to be non zero... With zero value Node tool gives the reported message. http://osgeo-org.1560.x6.nabble.com/file/n5171069/sna.jpg -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Node-tool-could-not-snap-to-a-segment-on-the-current-layer-tp5170898p5171069.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
Re: [Qgis-user] Python script to iterate through attributes and then refresh the canvas - doesn't show any map....
Why not use atlas generation in the print composer? Seems to me this corresponds with your „what i’m trying to achieve” grts Joris Op 4-nov.-2014, om 09:14 heeft Frank van Baar fr...@van-baar.com het volgende geschreven: Hi, Am completely stuck with a QGIS project in Python and tried everything but nothing seems to work. The python script does work as such BUT the canvas never shows the map and therefor the exported maps are empty…. What I’m trying to achieve: · Create a Python script that iterates through a series of ca. 2500 polygons based on attribute value, zoom to layer extend and save the canvas for each attribute as an image file. · I then use the image files in other documents The issue is that while manually I get the canvas to reload and display the map, this doesn’t happen when running the python script. Have tried couple of ways: 1. Don’t load the project each time and just change the filter 2. Add sleep timers to give the canvas time to refresh etc. 3. Tried different QGIS versions (2.2, 2.4 2.6 on Win 64x) But all to no avail…. Hope somebody’s got a great idea how to solve it. Regards, Frank Python code: # File location specifications PROJECTPATH = 'C:/Users/Frank/Documents /Targetting/Kaarten/' PROJECTFILE = 'C:/Users/Frank/Documents /Targetting/TargettingkaartV26qgs.qgs' EXTSNAPSHOTS = '.jpg' EXTSNAPSHOTS2 = '.png' SUFFIX = '65Plus_v1' last_id = 1 while last_id 5: # Clear map canvas QgsMapLayerRegistry.instance().removeAllMapLayers() qgis.utils.iface.mapCanvas().refresh() # Open QGIS project QgsProject.instance().setFileName(PROJECTFILE) QgsProject.instance().read() qgis.utils.iface.mapCanvas().refresh() time.sleep(30) canvas = qgis.utils.iface.mapCanvas() acl = canvas.layer(0) qgis.utils.iface.mapCanvas().layer(0).selectAll() selection = 'RijNo = ' + str(last_id) acl.setSubsetString( selection ) acl.triggerRepaint canvas.layer(1).triggerRepaint time.sleep(5) qgis.utils.iface.setActiveLayer(acl) # Zoom in and out to refresh potential issues with OpenLayer canvas.zoomByFactor(3) canvas.zoomByFactor(0.5) qgis.utils.iface.zoomToActiveLayer() qgis.utils.iface.mapCanvas().refresh() time.sleep(10) # Save project p=QgsProject.instance() p.setFileName(PROJECTFILE) p.write() # Save content of map canvas as image p = str(last_id) + 'kaart_' qgis.utils.iface.mapCanvas().saveAsImage(PROJECTPATH+ p + SUFFIX + EXTSNAPSHOTS) last_id = last_id +1 ___ 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
[Qgis-user] Android Camera App with compass bearing
Hi, I need to do a field trip and take some photos. I've been googling around, but cannot find an app that will burn both GPS position _and compass bearing_ into either the image, or just the exif data for that image. Anyone got any experience in this need? Thanks regards, Zoltan -- === Zoltan Szecsei PrGISc [PGP0031] Geograph (Pty) Ltd. GIS and Photogrammetric Services P.O. Box 7, Muizenberg 7950, South Africa. Mobile: +27-83-6004028 Fax:+27-86-6115323 www.geograph.co.za === ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Python script to iterate through attributes and then refresh the canvas - doesn't show any map....
Hi Joris, Thanks for your suggestion - didn't realize atlas worked this way. It however does not completely do what I want to do - the layer which it changes the filter for also has specific formatting to highlight the region etc. AND the OSM layer doesn't always display right. Any other suggestions anyone? Frank Van: Joris Hintjens [mailto:joris...@gmail.com] Verzonden: 04 November 2014 11:27 Aan: Frank van Baar CC: Qgis-user@lists.osgeo.org Onderwerp: Re: [Qgis-user] Python script to iterate through attributes and then refresh the canvas - doesn't show any map Why not use atlas generation in the print composer? Seems to me this corresponds with your what i'm trying to achieve grts Joris Op 4-nov.-2014, om 09:14 heeft Frank van Baar fr...@van-baar.com het volgende geschreven: Hi, Am completely stuck with a QGIS project in Python and tried everything but nothing seems to work. The python script does work as such BUT the canvas never shows the map and therefor the exported maps are empty.. What I'm trying to achieve: . Create a Python script that iterates through a series of ca. 2500 polygons based on attribute value, zoom to layer extend and save the canvas for each attribute as an image file. . I then use the image files in other documents The issue is that while manually I get the canvas to reload and display the map, this doesn't happen when running the python script. Have tried couple of ways: 1. Don't load the project each time and just change the filter 2. Add sleep timers to give the canvas time to refresh etc. 3. Tried different QGIS versions (2.2, 2.4 2.6 on Win 64x) But all to no avail.. Hope somebody's got a great idea how to solve it. Regards, Frank Python code: # File location specifications PROJECTPATH = 'C:/Users/Frank/Documents /Targetting/Kaarten/' PROJECTFILE = 'C:/Users/Frank/Documents /Targetting/TargettingkaartV26qgs.qgs' EXTSNAPSHOTS = '.jpg' EXTSNAPSHOTS2 = '.png' SUFFIX = '65Plus_v1' last_id = 1 while last_id 5: # Clear map canvas QgsMapLayerRegistry.instance().removeAllMapLayers() qgis.utils.iface.mapCanvas().refresh() # Open QGIS project QgsProject.instance().setFileName(PROJECTFILE) QgsProject.instance().read() qgis.utils.iface.mapCanvas().refresh() time.sleep(30) canvas = qgis.utils.iface.mapCanvas() acl = canvas.layer(0) qgis.utils.iface.mapCanvas().layer(0).selectAll() selection = 'RijNo = ' + str(last_id) acl.setSubsetString( selection ) acl.triggerRepaint canvas.layer(1).triggerRepaint time.sleep(5) qgis.utils.iface.setActiveLayer(acl) # Zoom in and out to refresh potential issues with OpenLayer canvas.zoomByFactor(3) canvas.zoomByFactor(0.5) qgis.utils.iface.zoomToActiveLayer() qgis.utils.iface.mapCanvas().refresh() time.sleep(10) # Save project p=QgsProject.instance() p.setFileName(PROJECTFILE) p.write() # Save content of map canvas as image p = str(last_id) + 'kaart_' qgis.utils.iface.mapCanvas().saveAsImage(PROJECTPATH+ p + SUFFIX + EXTSNAPSHOTS) last_id = last_id +1 ___ Qgis-user mailing list mailto:Qgis-user@lists.osgeo.org Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user 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
[Qgis-user] QGIS Analytical combinations
Hi! My name is Ferran and I'm new to QGIS, I think that's as great GIS and I love Python, so, I learning it. My first steps was prettty straigthforward until now. I'm stucked. I'm sure my doubt will be trivial, but I'm searching on the net last few hours and I cannot get it. I'll tell you my case: -I have a point based shape with an attribute (population) -I have created a grid with the QGIS tools. I want to get all the points inside each cell of the grid, sum the population and store this data (the sum of the popultion of all points of each cell) in a new grid attribute So, I'll get a grid with a new atribute with the aggregate population of all the points inside each cell. I'm going mad to do that... I cannot see how... If anyone can help I'll be s thankfull Thanks in advance, *Ferran* ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] edit spatialite with db manager
Thanks for the clarification. Stefan -Ursprüngliche Nachricht- Von: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] Im Auftrag von Saber Razmjooei Gesendet: Dienstag, 4. November 2014 10:11 An: qgis-user@lists.osgeo.org Betreff: Re: [Qgis-user] edit spatialite with db manager It is SQLite limitation!!: http://hub.qgis.org/issues/2423 Cheers, Saber -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Ziegler Stefan Sent: 04 November 2014 09:04 To: 'qgis-user@lists.osgeo.org' Subject: [Qgis-user] edit spatialite with db manager Hi I'm trying to e.g. rename a column of a spatialite layer with db manager. But in the Table properties window the Edit Column and Delete Column buttons are greyed out. Did I miss some depencies or something like that? I'm on QGIS master and Ubuntu 14.04. regards Stefan Freundliche Grüsse Stefan Ziegler Kantonsgeometer Amt für Geoinformation Amtliche Vermessung Rötistrasse 4 4500 Solothurn Telefon +41 32 627 75 96 Telefax +41 32 627 75 98 stefan.zieg...@bd.so.ch http://www.so.ch ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Whilst reasonable care has been taken to avoid virus transmission, no responsibility for viruses is taken and it is your responsibility to carry out such checks as you feel appropriate. If this email contains a quote or offer to sell products, carry out work or perform services then our standard terms and conditions (which can be found at http://www.lutraconsulting.co.uk/downloads/Lutra%20Consulting%20Standard%20Ter ms%20and%20Conditions.pdf shall apply unless explicitly stated otherwise. Saber Razmjooei and Peter Wells trading as Lutra Consulting. ___ 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] QGIS Analytical combinations
I suggest you to put everything in spatialite database and, assuming that 1) GRID is the polygon layer with grid definition 2) POINTS is the point layer with population data 3) POINTS has a field pop with population data 4) both layers have a keyfield named id 5) both layer have geom as geometries field Run the following query with dbmanager: SELECT DISTINCT GRID.id, SUM(POINTS.pop) AS POPxGRID FROM POINTS INNER JOIN GRID ON ST_Within(POINTS.Geometry,GRID.geom) GROUP BY GRID.ID you will get a table with a reference to a grid feature ID and the sum of the population of the points that are within the grid feature I hope this help you. Enrico Ferreguti -- View this message in context: http://osgeo-org.1560.x6.nabble.com/QGIS-Analytical-combinations-tp5171127p5171139.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
Re: [Qgis-user] QGIS Analytical combinations
Thanks! That make sense, I'll try and I will let you know. El mar., 4 de noviembre de 2014 15:26, enricofer enrico...@gmail.com escribió: I suggest you to put everything in spatialite database and, assuming that 1) GRID is the polygon layer with grid definition 2) POINTS is the point layer with population data 3) POINTS has a field pop with population data 4) both layers have a keyfield named id 5) both layer have geom as geometries field Run the following query with dbmanager: SELECT DISTINCT GRID.id, SUM(POINTS.pop) AS POPxGRID FROM POINTS INNER JOIN GRID ON ST_Within(POINTS.Geometry,GRID.geom) GROUP BY GRID.ID you will get a table with a reference to a grid feature ID and the sum of the population of the points that are within the grid feature I hope this help you. Enrico Ferreguti -- View this message in context: http://osgeo-org.1560.x6. nabble.com/QGIS-Analytical-combinations-tp5171127p5171139.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
[Qgis-user] (no subject)
Hi, I am trying to install and use Open Layers Plugin in QGIS version 2.4.0 The following message comes up: The plugin is broken. Python said: 'QPyNullVariant' object has no attribute'_getitem_' Could you help please? What do i need to do? (Ps I am working on a MAC) Thanks, Laura ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] (no subject)
Il 04/11/2014 16:43, laura guy ha scritto: Hi, I am trying to install and use Open Layers Plugin in QGIS version 2.4.0 Laura: first of all, please upgrade to qgis 2.6 and see if the problem persist. all the best. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Selection color in the print composer
Hi, is it possible to use the defined Selection Color (from Options - Canvas Legend) also in the print composer for a selected line feature? Thanks Otto ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] CASE WHEN .... Field Calculator.
Hi. I'm spanish user, sorry for my English. I'm using Google translator. I have a .shp points file with attribute table. Like this... -- A -- -- B -- -- C -- QString DoubleDoubleData type 30STH400500 130 30STH400500 130 30STH400500 130 30STH400500 130 ...... ... ...... ... 30STH400500 210 30STH400500 210 30STH400500 210 30STH400500 210 ...... ...... 30STH400500 320 30STH400500 320 30STH400500 320 30STH400500 320 ...... ...... 30STH450450 110 ... ... I have 50 different valuesv of A field. And now, I want a new field, D (Data type, double) like this in field calculator: WHEN A='30STH400500' THEN *D = 30 + 20 + 10 = 50* I don't know if I have explained it. I've tried using CASE WHEN A. THEN ELSE but I don't get it. I think that with plugin Fieldpyculator, but I don't know python Please, help me. Thanks. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] CASE WHEN .... Field Calculator.
Both CASE WHEN A like '30STH400500' THEN (30 + 20 + 10) ELSE 0 END and CASE WHEN A = '30STH400500' THEN (30 + 20 + 10) ELSE 0 END should work. If you want to assign this to D, you must specify D in Output field name. Håvard On 04. nov. 2014 20:29, Matías Taborda Barroso wrote: Hi. I'm spanish user, sorry for my English. I'm using Google translator. I have a .shp points file with attribute table. Like this... |-- A -- -- B -- -- C -- QString DoubleDoubleData type 30STH400500 130 30STH400500 130 30STH400500 130 30STH400500 130 ...... ... ...... ... 30STH400500 210 30STH400500 210 30STH400500 210 30STH400500 210 ...... ...... 30STH400500 320 30STH400500 320 30STH400500 320 30STH400500 320 ...... ...... 30STH450450 110 ... ...|| | I have 50 different valuesv of A field. And now, I want a new field, D (Data type, double) like this in field calculator: |WHEN A='30STH400500' THEN/*D = 30 + 20 + 10 = 50*/| I don't know if I have explained it. I've tried using CASE WHEN A. THEN ELSE but I don't get it. I think that with plugin Fieldpyculator, but I don't know python Please, help me. Thanks. ___ 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
[Qgis-user] Missing Attribute Table in QGIS Browser QGIS 2.6 (64 bit)
Hello, I just downloaded QGIS 2.6 (64 bit). It looks Wonderful !! I cannot see the Attribute table in the QGIS Browser 2.6.0 (just the feature id). I can see the Attribute table in the QGIS Desktop 2.6.0 Can you please suggest what I should do to correct this ? I am running Windows 7 Home Premium. Thank you, Jane Kogelschatz ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Android Camera App with compass bearing
On 11/04/2014 04:55 AM, Zoltan Szecsei wrote: Hi, I need to do a field trip and take some photos. I've been googling around, but cannot find an app that will burn both GPS position _and compass bearing_ into either the image, or just the exif data for that image. Anyone got any experience in this need? Thanks regards, Zoltan Maybe, http://geopaparazzi.github.io/geopaparazzi/ georeferenced and orientated pictures And now my long rant before I remembered the above link... GPS data is an on/off toggle on most Android devices. Bearing does appear possible according to the exif specs, but in practice is rare. http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/GPS.html However I don't see any obvious apps for telling the phone you want to capture that. I'm also not sure all phones are capable of calculating bearing when not moving. So my suggested work around would be a GPS Logging application of which there are several. Then you can pull the bearing calculation out after the fact, if it was while moving. If stationary, you might need to write your own app which lets users indicate which way they were facing when taking a picture. For someone who's made an Android application I don't think this is hard. http://developer.android.com/guide/topics/sensors/sensors_overview.html Indicates all version of Android support the Magentic sensor. This example shows how to get the bearing from the API https://www.codeofaninja.com/2013/08/android-compass-code-example.html So GPS+Orientation+Camera should be all required. Kinda busts my GPS logging idea, since the bearing information comes from a different sensor than the GPS it won't be in the NMEA strings even if you captured them. Thanks, Alex ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Android Camera App with compass bearing
Hi, I have DSLR (Nikon) and a separate GPS logging device from Solmeta (http://www.solmeta.com/) - so if you can also use a DSLR in your project, the Solmeta tagger is really excellent and writes everything directly into the image metadata. It is also a tracking device and records your positions at regular time interval, no matter if you are taking pictures or not. Just wanted to make you aware of this. The compass/clino is probably a more precise than on a Smartphone. Andreas On 04.11.2014 22:17, Alex Mandel wrote: On 11/04/2014 04:55 AM, Zoltan Szecsei wrote: Hi, I need to do a field trip and take some photos. I've been googling around, but cannot find an app that will burn both GPS position _and compass bearing_ into either the image, or just the exif data for that image. Anyone got any experience in this need? Thanks regards, Zoltan Maybe, http://geopaparazzi.github.io/geopaparazzi/ georeferenced and orientated pictures And now my long rant before I remembered the above link... GPS data is an on/off toggle on most Android devices. Bearing does appear possible according to the exif specs, but in practice is rare. http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/GPS.html However I don't see any obvious apps for telling the phone you want to capture that. I'm also not sure all phones are capable of calculating bearing when not moving. So my suggested work around would be a GPS Logging application of which there are several. Then you can pull the bearing calculation out after the fact, if it was while moving. If stationary, you might need to write your own app which lets users indicate which way they were facing when taking a picture. For someone who's made an Android application I don't think this is hard. http://developer.android.com/guide/topics/sensors/sensors_overview.html Indicates all version of Android support the Magentic sensor. This example shows how to get the bearing from the API https://www.codeofaninja.com/2013/08/android-compass-code-example.html So GPS+Orientation+Camera should be all required. Kinda busts my GPS logging idea, since the bearing information comes from a different sensor than the GPS it won't be in the NMEA strings even if you captured them. Thanks, Alex ___ 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
[Qgis-user] Processing compatibility with SAGA 2.1.3
Hi. I updated the latest stable versions of QGIS v2.6 and SAGA GIS v2.1.3. However I have seen that reported some bugs with the processing module and ParameterBoolean. To correct the compactability with the latest of SAGA GIS, needs to be added or changed in [1] if param.value: command += ' -' + param.name for something like: if param.value: command += ' -' + param.name + true regards, Samuel Mesa. [1] https://github.com/qgis/QGIS/blob/60706275e8c913e6a2c104827d3c854b8c573cb6/python/plugins/processing/algs/saga/SagaAlgorithm.py#L196 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Android Camera App with compass bearing
Hi Alex/All, Thanks for the thoughts - my comments interspersed with your. Kind regards, Zoltan On 2014/11/04 23:17, Alex Mandel wrote: On 11/04/2014 04:55 AM, Zoltan Szecsei wrote: Hi, I need to do a field trip and take some photos. I've been googling around, but cannot find an app that will burn both GPS position _and compass bearing_ into either the image, or just the exif data for that image. Anyone got any experience in this need? Thanks regards, Zoltan Maybe, http://geopaparazzi.github.io/geopaparazzi/ georeferenced and orientated pictures And now my long rant before I remembered the above link... I manually downloaded the latest version (newer than that on Play Store) and it still does not record bearing - even though the app does have a bearing tool. I checked the website and recording bearing into EXIF is not even on the developer's long wish-list I have emailed the developer, with a hope to at least get it onto the wish-list. GPS data is an on/off toggle on most Android devices. Bearing does appear possible according to the exif specs, but in practice is rare. http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/GPS.html Yes, I checked that last night too - TAGs 0x0017 and 0x0018 relate to bearing info. However I don't see any obvious apps for telling the phone you want to capture that. I'm also not sure all phones are capable of calculating bearing when not moving. So my suggested work around would be a GPS Logging application of which there are several. Then you can pull the bearing calculation out after the fact, if it was while moving. Sigh, nope. (In my kind of) Field trip data collection ( photography) often involves driving to a feature, leaning out the car window and taking a snap-shot, so recording moving direction will not help at all. Note that bearing accuracy is NOT that critical, it needs only to be reasonably indicative. If stationary, you might need to write your own app which lets users indicate which way they were facing when taking a picture. For someone who's made an Android application I don't think this is hard. http://developer.android.com/guide/topics/sensors/sensors_overview.html Indicates all version of Android support the Magentic sensor. This example shows how to get the bearing from the API https://www.codeofaninja.com/2013/08/android-compass-code-example.html So GPS+Orientation+Camera should be all required. Yep, true, but the purpose of this thread is to see if this wheel has already been invented :-) Kinda busts my GPS logging idea, since the bearing information comes from a different sensor than the GPS it won't be in the NMEA strings even if you captured them. What? You not 'hard core' enough to intercept the NMEA stream and insert bearing-on-the-fly by back-calculating the incoming coords? (Just pulling your leg - thanks for your interest in this topic :-) ) Thanks, Alex -- === Zoltan Szecsei PrGISc [PGP0031] Geograph (Pty) Ltd. GIS and Photogrammetric Services P.O. Box 7, Muizenberg 7950, South Africa. Mobile: +27-83-6004028 Fax:+27-86-6115323 www.geograph.co.za === ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] CAD Digitize
Hi all. Just published this plugin, looks quite interesting - enjoy! All the best. -- Paolo Cavallini - www.faunalia.eu Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
