Re: [Qgis-user] Not able to connect to Oracle via ODBC
I had a similar issue with unixODBC and MS SQL. If I am not mistaken, the «host parameter overrides the «Provider/DSN» parameter. It does so for MS SQL, at least. For MS SQL it helped to leave the host parameter empty and only use Provider/DSN. However, there does not seem to be a Provider/DSN parameter for neither Add Oracle Spatial Layer nor ODBC, ... A Bug? Cheers Stefan From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Tudorache, Marian Sent: 25. juni 2015 23:04 To: qgis-user@lists.osgeo.org; ottawa_us...@lists.osgeo.org Subject: [Qgis-user] Not able to connect to Oracle via ODBC Hello, What I am trying to do: Add a vector layer from an remote Oracle database. Description: I tried to add a vector layer using ODBC connectivity to an Oracle database on QGIS 2.8.2. Add vector Layer Choose Database Type ODBC Click New I filled the form as: Type ODBC Name: myODBCConnection Host: ssfdata Database: CAAR Port: 1521 Username: USER Password: PASS When I clicked Test Connection I got: Connection failed - Check settings and try again Extended error information: Unable to initialize ODBC connection to DSN for USER/PASS@CAAR, [unixODBC][Driver Manager] Datasource name not found, and no default driver specified I opened a terminal window and I typed: Isql -v caarODBC I was able to connect to my database ++ | Connected| | | | sql -statement | | help [tablename] | | quit | ++ SQL So the unixODBC driver works for the database but QGIS is not able to access via ODBC. Is any special settings related qgis to make ODBC working? Thanks, marian This electronic message, as well as any transmitted files included in the electronic message, may contain privileged or confidential information and is intended solely for the use of the individual(s) or entity to which it is addressed. If you have received this electronic message in error please notify the sender immediately and delete the electronic message. Any unauthorized copying, disclosure or distribution of the electronic message is strictly forbidden. NAV CANADA accepts no liability for any damage caused by any virus and/or other malicious code transmitted by this electronic communication. Le présent message électronique et tout fichier qui peut y être joint peuvent contenir des renseignements privilégiés ou confidentiels destinés à l'usage exclusif des personnes ou des organismes à qui ils s'adressent. Si vous avez reçu ce message électronique par erreur, veuillez en informer l'expéditeur immédiatement et supprimez le. Toute reproduction, divulgation ou distribution du présent message électronique est strictement interdite. NAV CANADA n'assume aucune responsabilité en cas de dommage causé par tout virus ou autre programme malveillant transmis par ce message électronique. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Default values in form
Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Default values in form
Hei Didier, I guess you could use a python init function for the form in order to define default values (see: http://nathanw.net/2011/09/05/qgis-tips-custom-feature-forms-with-python-logic/). However, sounds like a useful enhancement of the Custom form functionality (at least I would be interested too)... Cheers Stefan -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of didier peeters Sent: 26. juni 2015 10:08 To: qgis-user Subject: [Qgis-user] Default values in form Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier ___ 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] optimal route plugin?
Hello all, Sorry if this is a common question. Is there a plugin to help with calculating optimal driving routes? I have a number of addresses to visit and need to figure out the most efficient route and order to visit them. This would be something like what UPS uses to route their trucks. I googled around but didn't see anything obvious. thanks, Innisfree ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
Hi Marian, Yes - I follow the thread, but I don't know how to help. In your situation I wouldn't try and bother with ODBC but try to get the native Oracle connection working. I only very occasionally connect to Oracle and usually on Windows. I got Oracle on Linux running with OGR, but I haven't tested with QGIS. Maybe Jürgen Fischer has an idea how to get it working. Sorry that I can't help any better, Andreas On 26.06.2015 15:55, Tudorache, Marian wrote: Hi Andreas, Do you still follows this thread? I have tested the oracle client on my machine and it does work. I am able to connect to Oracle from a terminal windows using either isql or sqlplus. One thing that I found and it is related to Red Hat. When I tested the if all dependencies are working for libsqora.so.11.1 running the command bellow ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 I got libodbcinst.so.1 = not found I have fixed this issue by creating a symbolic link from /usr/lib64/libodbcinst.so.1 to /usr/lib64/libodbcinst.so.2. This fix made the unixODBC workable from a terminal windows and other applications which use ODBC connectivity but QGIS still does not have Oracle connectivity icon and it is not able to create an Oracle connection. Is this a QGIS bug? Thanks, Marian -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: June-18-15 4:53 PM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser Hi Marian, Do you already have an Oracle client on this machine? Note that QGIS on Linux does not provide an Oracle client like it does on the Windows version. You would have to install the Oracle client yourself and make sure it is in the LIBRARY Path and that ORACLE_HOME is defined and the name resolution (tnsnames.ora or similar mechanisms) work fine. Have a look at the Oracle documentation on how to install the Oracle client on Linux. I think the instant client is enough - you don't need the full client. Andreas On 18.06.2015 22:13, Tudorache, Marian wrote: Hi, I have installed the latest QGIS 2.8 Wien on Linux Red Hat 7 and I do not see the Oracle Connectivity icon in. I have MSSQL, SpatialLite, PostGIS, OWS, WCS, WFS, WMS. I sued to have it on Windows version of QGIS. Can someone help me how to install it? Thanks, Marian This electronic message, as well as any transmitted files included in the electronic message, may contain privileged or confidential information and is intended solely for the use of the individual(s) or entity to which it is addressed. If you have received this electronic message in error please notify the sender immediately and delete the electronic message. Any unauthorized copying, disclosure or distribution of the electronic message is strictly forbidden. NAV CANADA accepts no liability for any damage caused by any virus and/or other malicious code transmitted by this electronic communication. Le présent message électronique et tout fichier qui peut y être joint peuvent contenir des renseignements privilégiés ou confidentiels destinés à l’usage exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez reçu ce message électronique par erreur, veuillez en informer l’expéditeur immédiatement et supprimez le. Toute reproduction, divulgation ou distribution du présent message électronique est strictement interdite. NAV CANADA n’assume aucune responsabilité en cas de dommage causé par tout virus ou autre programme malveillant transmis par ce message électronique. ___ 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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] SQL query for style
Hi, I have a point database loaded with columns Z1 to Z6, where Z6 has values 0,0.5 and 1. What I am trying to do with the symbology is just to get it to plot and colour the depths (Z1) only where Z6=0 Can this be done from the style option for the layer? So what I want to do is: IF Z6=0 PLOT Z1 Sure this is very simple but can't see it :) Cheers Lester ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Problems with filtered legend update using atlas
I'm having problems printing/exporting an atlas because the legend (filtered) is not updated during the process. This is happening in a single composition, that has 12 pages, with 12 maps, and 12 legends. All legends items as filtered to the same page map. But when exporting all legends go empty, like if no element represented on the legend appears on the map. Besides, If the atlas preview is turned off, I alway need to click the map, and then click the legend in order to update it. Does anyone came into a problem like this? I'm trying to reproduce the problem in another composition, but it's not happening. I'm really not in the mood for recreate the all 12 pages from the begining... Thanks, Alexandre ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] problem with dxf2shp
Hi Daniel, I have not made that kind of conversion for a while now, probably back to QGIS 1.5. At that time, dxf2shp didn't keep any 3D information indeed. - v.in.dxf in GRASS worked well; - if you have a raster, extracting contours with the QGIS interpolate command was succesfull too (a workaround could then be to create a raster using your contours lines, and then back to the contour lines with interpolate). Hope this helps, Paul Le 25/06/2015 23:43, Daniel Camilo Largo Gaviria a écrit : Hi, i have a problem with QGIS. I need to convert dxf to shp. When i use dxf2shp function i can´t to see the attribute, for example: i need to convert contours (topography) of dxf to shp, but, the attribute of height don't appears. Someone know how convert and import full attribute? tks ___ 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] Missing Oracle connectivity on QGIS Browser
Hi Andreas, Do you still follows this thread? I have tested the oracle client on my machine and it does work. I am able to connect to Oracle from a terminal windows using either isql or sqlplus. One thing that I found and it is related to Red Hat. When I tested the if all dependencies are working for libsqora.so.11.1 running the command bellow ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 I got libodbcinst.so.1 = not found I have fixed this issue by creating a symbolic link from /usr/lib64/libodbcinst.so.1 to /usr/lib64/libodbcinst.so.2. This fix made the unixODBC workable from a terminal windows and other applications which use ODBC connectivity but QGIS still does not have Oracle connectivity icon and it is not able to create an Oracle connection. Is this a QGIS bug? Thanks, Marian -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: June-18-15 4:53 PM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser Hi Marian, Do you already have an Oracle client on this machine? Note that QGIS on Linux does not provide an Oracle client like it does on the Windows version. You would have to install the Oracle client yourself and make sure it is in the LIBRARY Path and that ORACLE_HOME is defined and the name resolution (tnsnames.ora or similar mechanisms) work fine. Have a look at the Oracle documentation on how to install the Oracle client on Linux. I think the instant client is enough - you don't need the full client. Andreas On 18.06.2015 22:13, Tudorache, Marian wrote: Hi, I have installed the latest QGIS 2.8 Wien on Linux Red Hat 7 and I do not see the Oracle Connectivity icon in. I have MSSQL, SpatialLite, PostGIS, OWS, WCS, WFS, WMS. I sued to have it on Windows version of QGIS. Can someone help me how to install it? Thanks, Marian This electronic message, as well as any transmitted files included in the electronic message, may contain privileged or confidential information and is intended solely for the use of the individual(s) or entity to which it is addressed. If you have received this electronic message in error please notify the sender immediately and delete the electronic message. Any unauthorized copying, disclosure or distribution of the electronic message is strictly forbidden. NAV CANADA accepts no liability for any damage caused by any virus and/or other malicious code transmitted by this electronic communication. Le présent message électronique et tout fichier qui peut y être joint peuvent contenir des renseignements privilégiés ou confidentiels destinés à l’usage exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez reçu ce message électronique par erreur, veuillez en informer l’expéditeur immédiatement et supprimez le. Toute reproduction, divulgation ou distribution du présent message électronique est strictement interdite. NAV CANADA n’assume aucune responsabilité en cas de dommage causé par tout virus ou autre programme malveillant transmis par ce message électronique. ___ 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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Default values in form
Hi Didier On 06/26/2015 12:36 PM, didier peeters wrote: Hello Mathias, this would be great ! Additionally, this makes me think of another possible enhancement: when displaying a picture in a form tab, it could be nice to hide the label and path/url to the file, which is most of the time useless. Do I need to do anything more to make these suggestions ? That can easily be added as a feature request. Cheers Matthias ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Default values in form
Hi Didier, On Fri, 26. Jun 2015 at 10:08:12 +0200, didier peeters wrote: Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. If the column has default values in postgis they will already be used as default value in the form. 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
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
Hi Marian, On Fri, 26. Jun 2015 at 09:55:47 -0400, Tudorache, Marian wrote: Do you still follows this thread? I have tested the oracle client on my machine and it does work. I am able to connect to Oracle from a terminal windows using either isql or sqlplus. Are you aware there is a oracle provider in QGIS. You don't have to use the OGR provider to access oracle (same as with postgres and mssql). I've never used Oracle via ODBC on Linux. From qgis I use the native oracle provider and from the command line GDAL/OGR's OCI driver. 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
Re: [Qgis-user] Local Government for QGIS
Hi Chris In my experience use of GIS is intermittent within Local Authorities (I worked at one until last year). Going completely FOSS is difficult because, at least for county councils and their metropolitan equivalents, every department has different needs, and there are often lots of legacy proprietary systems. Off the top of my head there were three departments that had extensions to standard GIS/CAD that they were reliant on: - Rights of Way – Proprietary ArcGIS 9.x(!) addon - Archaeology - Proprietary MapInfo extension - Road Safety – Proprietary AutoCAD extension There’s also the question – at what point does something start being a GIS? Many fields have their own special needs and only include GIS tangentially. For example all the below had some GIS-like feature in their bespoke, domain-specific software, but it was an after-thought rather than the main feature: - Highways – custom GIS (reliant on ArcSDE 9.x!) - Buses – Integrated GIS in specialist application - School admissions – Integrated GIS in specialist application - Forestry – Custom GIS/application (couldn’t handle multipart polygons) - Bridges – Some WMS integrated in a specialist application. So in a reasonably sized county council, that’s at least 8 different GIS systems that are bespoke. I’d initiated a move towards QGIS before leaving (hopefully they’ve kept it up), but QGIS simply isn’t suited to most of those tasks. Web-GIS is slightly different because while there are a few that have developed their own (http://maps.warwickshire.gov.uk is one, OpenLayers based front-end, GeoServer, but Oracle behind the scenes (it’s what we had), there are definitely others but I forget who), generally speaking for most authorities it’s cheaper/easier to go with a hosted or pre-developed solution. That said, quite a few are now based on Open Source. Astun certainly has it all the way down the stack (including PostGIS) for instance. Short version: Going 100% OS GIS is difficult. Cheers, Jonathan From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Chris Buckmaster Sent: Monday, June 15, 2015 10:52 AM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Local Government for QGIS Hi All Interesting discussion – I am responsible for GIS at a small local authority in the UK; we are an ESRI site but I have seen just how far FOSS4G has come in the last couple of years and have now had a proposal accepted to look at migrating our ESRI infrastructure over to PostGIS / QGIS / OpenLayers over the next year. I’ve been impressed at how efficient FOSS is, and particularly for us where we don’t deal with advanced analytics etc, for the tools we need FOSS can provide these just as well, if not better in some cases than proprietary offerings. Does anyone know of any local gov authorities that have gone completely FOSS? i.e. built their own web app(s) and are using open source desktop and database software? Chris From: qgis-user-boun...@lists.osgeo.orgmailto:qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: 15 June 2015 10:39 To: Micha Silver; qgis-user@lists.osgeo.orgmailto:qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Local Government for QGIS Hi Micha, Thanks again for your response. I will discuss this with the devs and will probably come up with a proposal, asking for some organizations to join the funding. Andreas On 15.06.2015 10:28, Micha Silver wrote: Hi Andreas: Thanks for your response. I'm quite sure that for most regional councils here, DXF would not be enough. The surveyors and planners that we work with all use Autodesk products. All their work is delivered in dwg, and some do not even know that there is such a thing as DXF. I have not been following the Open Design Alliance lately, but including that library QGIS would certainly be a quantum leap forward. After Radim's success in crowd funding the implementation of GRASS 7, your suggestion indeed sounds feasible. Regards, Micha On 6/15/2015 10:28 AM, Andreas Neumann wrote: Hi Micha, That is interesting - we invested a lot in the DXF export capabilities of QGIS. Once this is finished I am pretty sure we will also look to improve the situation regarding the import. Do you think import of DXF is enough or do we also need DWG support? If so, the best bet would probably be the Teigha library from the Open Design Alliance (https://www.opendesign.com/the_oda_platform/Teigha), which isn't available for free - but it is the library most other GIS (eg. ESRI, Intergraph) and CAD (eg. Bentley, Bricscad, etc.) are using. We would have to pay a membership fee, but it allows us to redistribute the library with the software. Membership in the consortium is affordable in my opinion. What are your thoughts on this? Would you also be available to help with a crowd-funding effort? Do you
Re: [Qgis-user] Not able to connect to Oracle via ODBC
Hi Stefan, Thank you for your answer. Initially the issue was somewhere between Linux Red Hat 7 and QGIS because the same error was when I tried to connect to Oracle using isql. The reason fro this issue was a known Red hat issue. Let me explain: Oracle ODBC driver is libsqora.so.11.1. This file exists in my system under /usr/lib/oracle/11.2/client64/lib/. I have run on a terminal ldd command like bellow. ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 In one of the result line was: libodbcinst.so.1 = not found. So I have created a symbolic link from /usr/lib64/libodbcinst.so.1 to /usr/lib64/libodbcinst.so.2. This fix made my Oracle client workable from isql and sqlplus. But QGIS still not able to add Oracle layer because the icon does not exists in QGIS Browser and ODBC still has the error: Connection failed - Check settings and try again Extended error information: Unable to initialize ODBC connection to DSN for USER/PASS@CAAR, [unixODBC][Driver Manager] Datasource name not found, and no default driver specified So right now someone who knows the QGIS code should see why Oracle connectivity icon does not exist in QGIS 2.8.2 Linux Red Hat and why ODBC does not work when it tries to connect to Oracle. Thanks, Marian From: Blumentrath, Stefan [mailto:stefan.blumentr...@nina.no] Sent: June-26-15 3:20 AM To: Tudorache, Marian; qgis-user@lists.osgeo.org; ottawa_us...@lists.osgeo.org Subject: RE: Not able to connect to Oracle via ODBC I had a similar issue with unixODBC and MS SQL. If I am not mistaken, the «host parameter overrides the «Provider/DSN» parameter. It does so for MS SQL, at least. For MS SQL it helped to leave the host parameter empty and only use Provider/DSN. However, there does not seem to be a Provider/DSN parameter for neither Add Oracle Spatial Layer nor ODBC, ... A Bug? Cheers Stefan From: qgis-user-boun...@lists.osgeo.orgmailto:qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Tudorache, Marian Sent: 25. juni 2015 23:04 To: qgis-user@lists.osgeo.orgmailto:qgis-user@lists.osgeo.org; ottawa_us...@lists.osgeo.orgmailto:ottawa_us...@lists.osgeo.org Subject: [Qgis-user] Not able to connect to Oracle via ODBC Hello, What I am trying to do: Add a vector layer from an remote Oracle database. Description: I tried to add a vector layer using ODBC connectivity to an Oracle database on QGIS 2.8.2. Add vector Layer Choose Database Type ODBC Click New I filled the form as: Type ODBC Name: myODBCConnection Host: ssfdata Database: CAAR Port: 1521 Username: USER Password: PASS When I clicked Test Connection I got: Connection failed - Check settings and try again Extended error information: Unable to initialize ODBC connection to DSN for USER/PASS@CAAR, [unixODBC][Driver Manager] Datasource name not found, and no default driver specified I opened a terminal window and I typed: Isql -v caarODBC I was able to connect to my database ++ | Connected| | | | sql -statement | | help [tablename] | | quit | ++ SQL So the unixODBC driver works for the database but QGIS is not able to access via ODBC. Is any special settings related qgis to make ODBC working? Thanks, marian This electronic message, as well as any transmitted files included in the electronic message, may contain privileged or confidential information and is intended solely for the use of the individual(s) or entity to which it is addressed. If you have received this electronic message in error please notify the sender immediately and delete the electronic message. Any unauthorized copying, disclosure or distribution of the electronic message is strictly forbidden. NAV CANADA accepts no liability for any damage caused by any virus and/or other malicious code transmitted by this electronic communication. Le présent message électronique et tout fichier qui peut y être joint peuvent contenir des renseignements privilégiés ou confidentiels destinés à l'usage exclusif des personnes ou des organismes à qui ils s'adressent. Si vous avez reçu ce message électronique par erreur, veuillez en informer l'expéditeur immédiatement et supprimez le. Toute reproduction, divulgation ou distribution du présent message électronique est strictement interdite. NAV CANADA n'assume aucune responsabilité en cas de dommage causé par tout virus ou autre programme malveillant transmis par ce message électronique. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] mrsid qgis 2.8 and ubuntu 14.04
Hi all, I'm trying to find some updated instructions for adding MrSid support for QGIS 2.8 on Ubuntu 14.04. I started following the instructions from here: https://trac.osgeo.org/ubuntugis/wiki/TutorialMrSid However, I'm hung up on the instructions where you do the build. I downloaded the following mrsid sdk from Lizardtech and extracted it. MrSID_DSDK-9.1.0.4045-linux.x86-64.gcc44.tar.gz The readme specifically says no real installation is necessary Can someone point me to some updated instructions on how to get mrsid support in QGIS 2.8? Thanks! Chris ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] mrsid qgis 2.8 and ubuntu 14.04
Chris, I am not an expert but I think that those instructions do not work because the plugin libgdal-mrsid-src is no longer in the repository. Have you looked at these instructions from a couple years ago? http://osgeo-org.1560.x6.nabble.com/MrSID-raster-and-QGIS-in-linux-td5090885.html I never got around to trying it since I dont use mrsid images very often and when I do I just do it on my windows machine, but the instructions are more up to date and dont rely on the plugin. Andrew On Fri, Jun 26, 2015 at 10:58 AM, Chris House house...@gmail.com wrote: i did try both of the build methods and neither worked. I get command not found for both. I would prefer a different format but I'm unaware of another file type that can compress as well as mrsid (usable file sizes) that cover as much territory (200km2) Thanks Chris On Fri, Jun 26, 2015 at 1:51 PM, James Keener j...@jimkeener.com wrote: I've not used it as a gdal plugin and in the past have simply converted my data into a more standard format: http://jimkeener.com/posts/orthoimagery Have you followed the steps you've linked to? Did either the gdal-build-mrsid or gdal-mrsid-build work? Jim On 06/26/2015 01:43 PM, Chris House wrote: Hi all, I'm trying to find some updated instructions for adding MrSid support for QGIS 2.8 on Ubuntu 14.04. I started following the instructions from here: https://trac.osgeo.org/ubuntugis/wiki/TutorialMrSid However, I'm hung up on the instructions where you do the build. I downloaded the following mrsid sdk from Lizardtech and extracted it. MrSID_DSDK-9.1.0.4045-linux.x86-64.gcc44.tar.gz The readme specifically says no real installation is necessary Can someone point me to some updated instructions on how to get mrsid support in QGIS 2.8? Thanks! Chris ___ 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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] mrsid qgis 2.8 and ubuntu 14.04
So there was a thread on this back in February - I keep up with this because I also would like the functionality - I've just failed in trying to get it to work. Most likely skill issues on my part. Thread here: http://lists.osgeo.org/pipermail/gdal-dev/2015-February/041128.html Good Luck - Randy On 06/26/2015 01:58 PM, Chris House wrote: i did try both of the build methods and neither worked. I get command not found for both. I would prefer a different format but I'm unaware of another file type that can compress as well as mrsid (usable file sizes) that cover as much territory (200km2) Thanks Chris On Fri, Jun 26, 2015 at 1:51 PM, James Keener j...@jimkeener.com mailto:j...@jimkeener.com wrote: I've not used it as a gdal plugin and in the past have simply converted my data into a more standard format: http://jimkeener.com/posts/orthoimagery Have you followed the steps you've linked to? Did either the gdal-build-mrsid or gdal-mrsid-build work? Jim On 06/26/2015 01:43 PM, Chris House wrote: Hi all, I'm trying to find some updated instructions for adding MrSid support for QGIS 2.8 on Ubuntu 14.04. I started following the instructions from here: https://trac.osgeo.org/ubuntugis/wiki/TutorialMrSid However, I'm hung up on the instructions where you do the build. I downloaded the following mrsid sdk from Lizardtech and extracted it. MrSID_DSDK-9.1.0.4045-linux.x86-64.gcc44.tar.gz The readme specifically says no real installation is necessary Can someone point me to some updated instructions on how to get mrsid support in QGIS 2.8? Thanks! Chris ___ 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 -- - 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 Southeast OSGEO: http://wiki.osgeo.org/wiki/Southeast_US ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] mrsid qgis 2.8 and ubuntu 14.04
i did try both of the build methods and neither worked. I get command not found for both. I would prefer a different format but I'm unaware of another file type that can compress as well as mrsid (usable file sizes) that cover as much territory (200km2) Thanks Chris On Fri, Jun 26, 2015 at 1:51 PM, James Keener j...@jimkeener.com wrote: I've not used it as a gdal plugin and in the past have simply converted my data into a more standard format: http://jimkeener.com/posts/orthoimagery Have you followed the steps you've linked to? Did either the gdal-build-mrsid or gdal-mrsid-build work? Jim On 06/26/2015 01:43 PM, Chris House wrote: Hi all, I'm trying to find some updated instructions for adding MrSid support for QGIS 2.8 on Ubuntu 14.04. I started following the instructions from here: https://trac.osgeo.org/ubuntugis/wiki/TutorialMrSid However, I'm hung up on the instructions where you do the build. I downloaded the following mrsid sdk from Lizardtech and extracted it. MrSID_DSDK-9.1.0.4045-linux.x86-64.gcc44.tar.gz The readme specifically says no real installation is necessary Can someone point me to some updated instructions on how to get mrsid support in QGIS 2.8? Thanks! Chris ___ 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] mrsid qgis 2.8 and ubuntu 14.04
I've had great success with ECW files but unsure as to how they are created. In Manifold one can link to them rather than load them into the Project file. Very fast. Cheers . . . . . Spring Harrison Samsung Tab 4 On Jun 26, 2015 10:59 AM, Chris House house...@gmail.com wrote: i did try both of the build methods and neither worked. I get command not found for both. I would prefer a different format but I'm unaware of another file type that can compress as well as mrsid (usable file sizes) that cover as much territory (200km2) Thanks Chris On Fri, Jun 26, 2015 at 1:51 PM, James Keener j...@jimkeener.com wrote: I've not used it as a gdal plugin and in the past have simply converted my data into a more standard format: http://jimkeener.com/posts/orthoimagery Have you followed the steps you've linked to? Did either the gdal-build-mrsid or gdal-mrsid-build work? Jim On 06/26/2015 01:43 PM, Chris House wrote: Hi all, I'm trying to find some updated instructions for adding MrSid support for QGIS 2.8 on Ubuntu 14.04. I started following the instructions from here: https://trac.osgeo.org/ubuntugis/wiki/TutorialMrSid However, I'm hung up on the instructions where you do the build. I downloaded the following mrsid sdk from Lizardtech and extracted it. MrSID_DSDK-9.1.0.4045-linux.x86-64.gcc44.tar.gz The readme specifically says no real installation is necessary Can someone point me to some updated instructions on how to get mrsid support in QGIS 2.8? Thanks! Chris ___ 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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] mrsid qgis 2.8 and ubuntu 14.04
I've not used it as a gdal plugin and in the past have simply converted my data into a more standard format: http://jimkeener.com/posts/orthoimagery Have you followed the steps you've linked to? Did either the gdal-build-mrsid or gdal-mrsid-build work? Jim On 06/26/2015 01:43 PM, Chris House wrote: Hi all, I'm trying to find some updated instructions for adding MrSid support for QGIS 2.8 on Ubuntu 14.04. I started following the instructions from here: https://trac.osgeo.org/ubuntugis/wiki/TutorialMrSid However, I'm hung up on the instructions where you do the build. I downloaded the following mrsid sdk from Lizardtech and extracted it. MrSID_DSDK-9.1.0.4045-linux.x86-64.gcc44.tar.gz The readme specifically says no real installation is necessary Can someone point me to some updated instructions on how to get mrsid support in QGIS 2.8? Thanks! Chris ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user signature.asc Description: OpenPGP digital signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
Hi Jürgen/Andreas, I think you misunderstood my issue. First let's be clear. There is no issue with Oracle connectivity from Linux. The oracle client runs properly and I am able to access oracle database using wither sqlplus or SQL developer interface. The issue is when I am trying to add a vector layer using SDO data from an Oracle spatial database: there is not Oracle connectivity icon on QGIS under Linux Red Hat. I only have connectivity to the fowling database types: - MSSQL; - OGDI Vectors; - PostGIS; - SpatiaLite; As alternative way I have tried Add Vector Layer/Source Type Database. On the database type the dropdown list gave those options: - ODBC; - ESRI Personal Geodatabase; - MSSQL; - OGDI Vectors; - PostgreSQL; - MySQL So again no Oracle option. But I said let's try ODBC to see if I can use it to pull Oracle spatial data. So this option does not work either. I have tried to use GDAL/OGR's OCI driver so I had a look here: http://www.gdal.org/index.html I have installed but how can be used? The only clear document is this: http://www.igismap.com/connect-qgis-oracle-spatial-quantum-gis/ But since I do not have Oracle spatial as the tutorial says I can't use it. Do you know where I have learn how to connect to oracle using GDAL/OGR? Thanks, Marian When I tested QGIS on Windows 7 there is an Oracle connectivity icon that I was able to use it without problem. But our requirements were to use QGIS 2.8 on Linux Red Hat with Oracle spatial. After I installed QGIS on red hat I observed there is not Oracle connectivity on QGIS as in the windows version. I have sent an email about this issue a while ago. Andreas thought the issue is because I do not have installed Oracle Client. But the this wasn't the issue because I had oracle client installed on the Linux machine -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Jürgen E. Fischer Sent: June-26-15 11:26 AM To: qgis-user@lists.osgeo.org; ottawa_us...@lists.osgeo.org Subject: Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser Hi Marian, On Fri, 26. Jun 2015 at 09:55:47 -0400, Tudorache, Marian wrote: Do you still follows this thread? I have tested the oracle client on my machine and it does work. I am able to connect to Oracle from a terminal windows using either isql or sqlplus. Are you aware there is a oracle provider in QGIS. You don't have to use the OGR provider to access oracle (same as with postgres and mssql). I've never used Oracle via ODBC on Linux. From qgis I use the native oracle provider and from the command line GDAL/OGR's OCI driver. 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 This electronic message, as well as any transmitted files included in the electronic message, may contain privileged or confidential information and is intended solely for the use of the individual(s) or entity to which it is addressed. If you have received this electronic message in error please notify the sender immediately and delete the electronic message. Any unauthorized copying, disclosure or distribution of the electronic message is strictly forbidden. NAV CANADA accepts no liability for any damage caused by any virus and/or other malicious code transmitted by this electronic communication. Le présent message électronique et tout fichier qui peut y être joint peuvent contenir des renseignements privilégiés ou confidentiels destinés à l’usage exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez reçu ce message électronique par erreur, veuillez en informer l’expéditeur immédiatement et supprimez le. Toute reproduction, divulgation ou distribution du présent message électronique est strictement interdite. NAV CANADA n’assume aucune responsabilité en cas de dommage causé par tout virus ou autre programme malveillant transmis par ce message électronique. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] optimal route plugin?
On 06/26/2015 08:54 AM, Innisfree McKinnon wrote: Hello all, Sorry if this is a common question. Is there a plugin to help with calculating optimal driving routes? I have a number of addresses to visit and need to figure out the most efficient route and order to visit them. This would be something like what UPS uses to route their trucks. I googled around but didn't see anything obvious. thanks, Innisfree Maybe the OSM Route plugin. Directly in GRASS there is http://grass.osgeo.org/grass64/manuals/v.net.salesman.html Spatialite also has routing, not sure if it does multi-node pgRouting is the other tool that comes to mind. Other than the 1st plugin, or querying spatialite I'm not aware of routing options in QGIS. -Alex ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] SQL query for style
Hi Lester, you can either use in categorized style such an expression CASE WHEN Z6 = 0 THEN Z1 END. You'll get all the Z1 classes with a zero-value Z6 and one class without value which is for features with a Z60. You can delete this one or set it invisible. Envoyé depuis mon HTC - Reply message - De : Carlos López PSIG carlos.lo...@psig.es Pour : qgis-user@lists.osgeo.org qgis-user@lists.osgeo.org Objet : [Qgis-user] SQL query for style Date : ven., juin 26, 2015 13:52 Hi Lester, You must choose styles based on rules! Properties -- Styles -- Rule-based Regards, * http://www.psig.es* *Carlos López Quintanilla* www.psig.es carlos.lo...@psig.es +34 699.680.261 2015-06-26 12:57 GMT+02:00 Lester Anderson arctica1...@gmail.com: Hi, I have a point database loaded with columns Z1 to Z6, where Z6 has values 0,0.5 and 1. What I am trying to do with the symbology is just to get it to plot and colour the depths (Z1) only where Z6=0 Can this be done from the style option for the layer? So what I want to do is: IF Z6=0 PLOT Z1 Sure this is very simple but can't see it :) Cheers Lester ___ 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] qgis 2.8 crash on sql spacial add layer
I have googled around a bit, but can't figure this one out. Have a very simple table, id, geom and state code Multi-poly in the geom field. All I really want to do is display it and export it to a KML, but as soon as I add the table to qgis is crashes.. any suggestions Thanks, Dennis ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Default values in form
I think this would fit into the area of this QEP: https://github.com/m-kuhn/QGIS-Enhancement-Proposals/blob/fields-and-forms-redesign/QEP-Fields-and-forms-redesign.rst#31-fields It could be added to the list Information about fields next to constraints. Any feedback on it is welcome. Matthias On 06/26/2015 11:35 AM, Paolo Cavallini wrote: Agreed, an important improvement. Please open a ticket if not already there. All the best. Il 26 giugno 2015 08:16:32 GMT+00:00, Blumentrath, Stefan stefan.blumentr...@nina.no ha scritto: Hei Didier, I guess you could use a python init function for the form in order to define default values (see: http://nathanw.net/2011/09/05/qgis-tips-custom-feature-forms-with-python-logic/). However, sounds like a useful enhancement of the Custom form functionality (at least I would be interested too)... Cheers Stefan -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of didier peeters Sent: 26. juni 2015 10:08 To: qgis-user Subject: [Qgis-user] Default values in form Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier 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 -- http://faunalia.eu/ Sent from mobile, sorry for being short ___ 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] Default values in form
Thanks, I’ll surely take a look at your plugin, and open a ticket if necessary. @Stefan : I had seen that post by Nathan Woodrow, but was hoping for something ‘lighter’ … Didier Le 26 juin 2015 à 11:32, Bernhard Ströbl bernhard.stro...@jena.de a écrit : Hi, if you define the values as default in PostgreSQL and use my :) plugin DataDrivenInputMask [1] these values are inserted in the mask that is created by the plugin in QGIS. Thus for fields with defaults you cannot insert NULL vallues (but that's why you define a default). Bernhard http://plugins.qgis.org/plugins/DataDrivenInputMask/ Am 26.06.2015 um 10:08 schrieb didier peeters: Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user __ Information from ESET Mail Security, version of virus signature database 11847 (20150626) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user Didier Peeters Institut de Gestion de l'Environnement et d'Aménagement du Territoire (IGEAT) Université Libre de Bruxelles (ULB) CP130/03 av. F. D. Roosevelt 50 B-1050 Bruxelles Tél : +32-2-650 68 17 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Rasterize tool with text attribute.
Hello everyone, I'm trying to do a simple vector to raster conversion using an attribute field stored as string. Am I wrong or does gdal_rasterize does not accept text fields as attributes? Thanks for any insight. Ricardo O. -Ricardo Oliveira - Geographer Personal Website: http://ricardooliveiragis.com/Blog: http://ricardooliveiragis.com/blog ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] problem with dxf2shp
Hi Daniel, I have the same problems Sometimes, when I need elevation attribute I work with geobide [1] program, geoconverter [2] [1] http://www.geobide.es/ [2] http://www.geobide.es/geoconverter/ This program is not open source, but it's free! Best regards, * http://www.psig.es* *Carlos López Quintanilla* www.psig.es carlos.lo...@psig.es +34 699.680.261 2015-06-25 23:43 GMT+02:00 Daniel Camilo Largo Gaviria daniel.la...@gmail.com: Hi, i have a problem with QGIS. I need to convert dxf to shp. When i use dxf2shp function i can´t to see the attribute, for example: i need to convert contours (topography) of dxf to shp, but, the attribute of height don't appears. Someone know how convert and import full attribute? tks ___ 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] Default values in form
Agreed, an important improvement. Please open a ticket if not already there. All the best. Il 26 giugno 2015 08:16:32 GMT+00:00, Blumentrath, Stefan stefan.blumentr...@nina.no ha scritto: Hei Didier, I guess you could use a python init function for the form in order to define default values (see: http://nathanw.net/2011/09/05/qgis-tips-custom-feature-forms-with-python-logic/). However, sounds like a useful enhancement of the Custom form functionality (at least I would be interested too)... Cheers Stefan -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of didier peeters Sent: 26. juni 2015 10:08 To: qgis-user Subject: [Qgis-user] Default values in form Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier ___ 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 -- http://faunalia.eu/ Sent from mobile, sorry for being short___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Default values in form
Hi, if you define the values as default in PostgreSQL and use my :) plugin DataDrivenInputMask [1] these values are inserted in the mask that is created by the plugin in QGIS. Thus for fields with defaults you cannot insert NULL vallues (but that's why you define a default). Bernhard http://plugins.qgis.org/plugins/DataDrivenInputMask/ Am 26.06.2015 um 10:08 schrieb didier peeters: Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user __ Information from ESET Mail Security, version of virus signature database 11847 (20150626) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Time Manager - Resolution Higher than Screen Display?
Hello All, Does anyone know if in Time Manager is there any way to get the resulting *.PNG files in a higher resolution than the screen display? Where is the best detailed information on Time Manager and is there someplace to post my experiences with it? Best Regards, Tom Leahy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Default values in form
Hi, When doing anything with default values we also have to think about the option we have which automatically fills in the values of the last inserted record. Which one has precedence? The default value or the value of the last record? Also - I think we probably need a mixture of default values and values from the last record - but I think the values of the last record are not fine-grained enough - so we could tell QGIS to use the values from the last record for some columns but for other columns use the default value. We have to think about both approaches and need a collaboration of both, in my opinion. Andreas On 26.06.2015 12:14, didier peeters wrote: Thanks, I’ll surely take a look at your plugin, and open a ticket if necessary. @Stefan : I had seen that post by Nathan Woodrow, but was hoping for something ‘lighter’ … Didier Le 26 juin 2015 à 11:32, Bernhard Ströbl bernhard.stro...@jena.de a écrit : Hi, if you define the values as default in PostgreSQL and use my :) plugin DataDrivenInputMask [1] these values are inserted in the mask that is created by the plugin in QGIS. Thus for fields with defaults you cannot insert NULL vallues (but that's why you define a default). Bernhard http://plugins.qgis.org/plugins/DataDrivenInputMask/ Am 26.06.2015 um 10:08 schrieb didier peeters: Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user __ Information from ESET Mail Security, version of virus signature database 11847 (20150626) __ The message was checked by ESET Mail Security. http://www.eset.com ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user Didier Peeters Institut de Gestion de l'Environnement et d'Aménagement du Territoire (IGEAT) Université Libre de Bruxelles (ULB) CP130/03 av. F. D. Roosevelt 50 B-1050 Bruxelles Tél : +32-2-650 68 17 ___ 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] SQL query for style
It is the categorised / graduated render I was looking at. I could not figure out the correct SQL expression for the column section; how would this expression be written here? eg Find all values where Z6=0 and render Z1 for the symbology associated with that particular Z6 value Cheers Lester On 26 June 2015 at 13:22, Andreas Neumann a.neum...@carto.net wrote: Hi Lester, You can either use an expression which uses more than one column (for graduated or categorized renderer) or the rule based renderer mentioned by Carlos, which is more powerful. Andreas On 26.06.2015 12:57, Lester Anderson wrote: Hi, I have a point database loaded with columns Z1 to Z6, where Z6 has values 0,0.5 and 1. What I am trying to do with the symbology is just to get it to plot and colour the depths (Z1) only where Z6=0 Can this be done from the style option for the layer? So what I want to do is: IF Z6=0 PLOT Z1 Sure this is very simple but can't see it :) Cheers Lester ___ Qgis-user mailing listQgis-user@lists.osgeo.orghttp://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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] SQL query for style
Just press on the E Expression button and concatenate the two columns: Z1 || ' ' || Z6 Press Categorize and delete all the combinations you don't need. Andreas On 26.06.2015 14:38, Lester Anderson wrote: It is the categorised / graduated render I was looking at. I could not figure out the correct SQL expression for the column section; how would this expression be written here? eg Find all values where Z6=0 and render Z1 for the symbology associated with that particular Z6 value Cheers Lester On 26 June 2015 at 13:22, Andreas Neumann a.neum...@carto.net mailto:a.neum...@carto.net wrote: Hi Lester, You can either use an expression which uses more than one column (for graduated or categorized renderer) or the rule based renderer mentioned by Carlos, which is more powerful. Andreas On 26.06.2015 12:57, Lester Anderson wrote: Hi, I have a point database loaded with columns Z1 to Z6, where Z6 has values 0,0.5 and 1. What I am trying to do with the symbology is just to get it to plot and colour the depths (Z1) only where Z6=0 Can this be done from the style option for the layer? So what I want to do is: IF Z6=0 PLOT Z1 Sure this is very simple but can't see it :) Cheers Lester ___ 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] Default values in form
Hello Mathias, this would be great ! Additionally, this makes me think of another possible enhancement: when displaying a picture in a form tab, it could be nice to hide the label and path/url to the file, which is most of the time useless. Do I need to do anything more to make these suggestions ? Didier Le 26 juin 2015 à 12:07, Matthias Kuhn matthias.k...@gmx.ch a écrit : I think this would fit into the area of this QEP: https://github.com/m-kuhn/QGIS-Enhancement-Proposals/blob/fields-and-forms-redesign/QEP-Fields-and-forms-redesign.rst#31-fields https://github.com/m-kuhn/QGIS-Enhancement-Proposals/blob/fields-and-forms-redesign/QEP-Fields-and-forms-redesign.rst#31-fields It could be added to the list Information about fields next to constraints. Any feedback on it is welcome. Matthias On 06/26/2015 11:35 AM, Paolo Cavallini wrote: Agreed, an important improvement. Please open a ticket if not already there. All the best. Il 26 giugno 2015 08:16:32 GMT+00:00, Blumentrath, Stefan stefan.blumentr...@nina.no mailto:stefan.blumentr...@nina.no ha scritto: Hei Didier, I guess you could use a python init function for the form in order to define default values (see: http://nathanw.net/2011/09/05/qgis-tips-custom-feature-forms-with-python-logic http://nathanw.net/2011/09/05/qgis-tips-custom-feature-forms-with-python-logic/). However, sounds like a useful enhancement of the Custom form functionality (at least I would be interested too)... Cheers Stefan -Original Message- From: qgis-user-boun...@lists.osgeo.org mailto:qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of didier peeters Sent: 26. juni 2015 10:08 To: qgis-user Subject: [Qgis-user] Default values in form Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier Qgis-user mailing list Qgis-user@lists.osgeo.org mailto: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 mailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user http://lists.osgeo.org/mailman/listinfo/qgis-user -- http://faunalia.eu http://faunalia.eu// Sent from mobile, sorry for being short ___ Qgis-user mailing list Qgis-user@lists.osgeo.org mailto: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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Default values in form
Hi, I am about to file a ticket for this. Another thought in this context: When defining default values it would be splendid if one could use variables (e.g. %USER% or expressions like in the field calculator or Relation Reference widget). What do you think? The latter could probably go into a new widget type Calculated? Another thing in this context could be adding the possibility do define Mouse-over effects in order to help understanding attribute content better (e.g. Units, backgrounds, how to measure in the field...)?! Lables are not allways sufficient, but maybe the GUI gets too fidgety? Should a request for this go into separate tickets? Cheers Stefan From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of didier peeters Sent: 26. juni 2015 12:36 To: qgis-user Subject: Re: [Qgis-user] Default values in form Hello Mathias, this would be great ! Additionally, this makes me think of another possible enhancement: when displaying a picture in a form tab, it could be nice to hide the label and path/url to the file, which is most of the time useless. Do I need to do anything more to make these suggestions ? Didier Le 26 juin 2015 à 12:07, Matthias Kuhn matthias.k...@gmx.chmailto:matthias.k...@gmx.ch a écrit : I think this would fit into the area of this QEP: https://github.com/m-kuhn/QGIS-Enhancement-Proposals/blob/fields-and-forms-redesign/QEP-Fields-and-forms-redesign.rst#31-fields It could be added to the list Information about fields next to constraints. Any feedback on it is welcome. Matthias On 06/26/2015 11:35 AM, Paolo Cavallini wrote: Agreed, an important improvement. Please open a ticket if not already there. All the best. Il 26 giugno 2015 08:16:32 GMT+00:00, Blumentrath, Stefan stefan.blumentr...@nina.nomailto:stefan.blumentr...@nina.no ha scritto: Hei Didier, I guess you could use a python init function for the form in order to define default values (see: http://nathanw.net/2011/09/05/qgis-tips-custom-feature-forms-with-python-logic/). However, sounds like a useful enhancement of the Custom form functionality (at least I would be interested too)... Cheers Stefan -Original Message- From: qgis-user-boun...@lists.osgeo.orgmailto:qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of didier peeters Sent: 26. juni 2015 10:08 To: qgis-user Subject: [Qgis-user] Default values in form Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I'm inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that's the definition of a default value, and I don't think that using layers stored in Postgis would make any difference. Thanks Didier Qgis-user mailing list Qgis-user@lists.osgeo.orgmailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user Qgis-user mailing list Qgis-user@lists.osgeo.orgmailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- http://faunalia.euhttp://faunalia.eu// Sent from mobile, sorry for being short ___ Qgis-user mailing list Qgis-user@lists.osgeo.orgmailto:Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.orgmailto: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] SQL query for style
Hi Lester, You can either use an expression which uses more than one column (for graduated or categorized renderer) or the rule based renderer mentioned by Carlos, which is more powerful. Andreas On 26.06.2015 12:57, Lester Anderson wrote: Hi, I have a point database loaded with columns Z1 to Z6, where Z6 has values 0,0.5 and 1. What I am trying to do with the symbology is just to get it to plot and colour the depths (Z1) only where Z6=0 Can this be done from the style option for the layer? So what I want to do is: IF Z6=0 PLOT Z1 Sure this is very simple but can't see it :) Cheers Lester ___ 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] Fomrs: Range widget makes only integer steps
Hi, I am having issues with the Range widget(s) in my custom form: For a numeric(2,1) field (which is interpreted as double in QGIS) in my PostGIS table I try to use the range widget with 0.5 steps and the Slider. However, the slider does not seem to regard the steps parameter which I set to 0.50. The spin box works fine if NULL is not allowed. If I allow NULL it does not use digits either... Anyone experiencing the same? Is there a way to make the slider aware of digits which I overlooked? Cheers Stefan ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Default values in form
PS: I would prefer to work on a holistic approach instead of adding individual tickets. To prevent the user interface from getting even more cluttered by letting it grow organically. It always makes me want to scream when I see the fields configuration dialog. Until I realize that it was actually also me adding a lot of stuff in there. Therefore, please add comments and improvements to this document: https://github.com/m-kuhn/QGIS-Enhancement-Proposals/blob/fields-and-forms-redesign/QEP-Fields-and-forms-redesign.rst#31-fields and the associated discussion https://github.com/qgis/QGIS-Enhancement-Proposals/pull/13 Cheers Matthias On 06/26/2015 01:53 PM, Matthias Kuhn wrote: Hi, Yes, tooltips that show the comments would also be great. It would be nice to show * the database comments (if supported by the backend) as default * allow to override it in the configuration Default values from expressions would also be a great addition. I think it would be better to define it directly on the field (and not on its widget). This way you can later turn the widget into something else (e.g. from text to range) without reconfiguring the default value. And it should have defaults for the defaults :) being read from the database where possible. Cheers, Matthias On 06/26/2015 01:05 PM, Blumentrath, Stefan wrote: Hi, I am about to file a ticket for this. Another thought in this context: When defining “default values” it would be splendid if one could use variables (e.g. %USER% or expressions like in the field calculator or Relation Reference widget). What do you think? The latter could probably go into a new widget type Calculated? Another thing in this context could be adding the possibility do define “Mouse-over effects” in order to help understanding attribute content better (e.g. Units, backgrounds, how to measure in the field…)?! Lables are not allways sufficient, but maybe the GUI gets too fidgety? Should a request for this go into separate tickets? Cheers Stefan *From:*qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] *On Behalf Of *didier peeters *Sent:* 26. juni 2015 12:36 *To:* qgis-user *Subject:* Re: [Qgis-user] Default values in form Hello Mathias, this would be great ! Additionally, this makes me think of another possible enhancement: when displaying a picture in a form tab, it could be nice to hide the label and path/url to the file, which is most of the time useless. Do I need to do anything more to make these suggestions ? Didier Le 26 juin 2015 à 12:07, Matthias Kuhn matthias.k...@gmx.ch mailto:matthias.k...@gmx.ch a écrit : I think this would fit into the area of this QEP: https://github.com/m-kuhn/QGIS-Enhancement-Proposals/blob/fields-and-forms-redesign/QEP-Fields-and-forms-redesign.rst#31-fields It could be added to the list Information about fields next to constraints. Any feedback on it is welcome. Matthias On 06/26/2015 11:35 AM, Paolo Cavallini wrote: Agreed, an important improvement. Please open a ticket if not already there. All the best. Il 26 giugno 2015 08:16:32 GMT+00:00, Blumentrath, Stefan stefan.blumentr...@nina.no mailto:stefan.blumentr...@nina.no ha scritto: Hei Didier, I guess you could use a python init function for the form in order to define default values (see: http://nathanw.net/2011/09/05/qgis-tips-custom-feature-forms-with-python-logic/). However, sounds like a useful enhancement of the Custom form functionality (at least I would be interested too)... Cheers Stefan -Original Message- From: qgis-user-boun...@lists.osgeo.org mailto:qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of didier peeters Sent: 26. juni 2015 10:08 To: qgis-user Subject: [Qgis-user] Default values in form Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier Qgis-user mailing list Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org
Re: [Qgis-user] Default values in form
Hi, Yes, tooltips that show the comments would also be great. It would be nice to show * the database comments (if supported by the backend) as default * allow to override it in the configuration Default values from expressions would also be a great addition. I think it would be better to define it directly on the field (and not on its widget). This way you can later turn the widget into something else (e.g. from text to range) without reconfiguring the default value. And it should have defaults for the defaults :) being read from the database where possible. Cheers, Matthias On 06/26/2015 01:05 PM, Blumentrath, Stefan wrote: Hi, I am about to file a ticket for this. Another thought in this context: When defining “default values” it would be splendid if one could use variables (e.g. %USER% or expressions like in the field calculator or Relation Reference widget). What do you think? The latter could probably go into a new widget type Calculated? Another thing in this context could be adding the possibility do define “Mouse-over effects” in order to help understanding attribute content better (e.g. Units, backgrounds, how to measure in the field…)?! Lables are not allways sufficient, but maybe the GUI gets too fidgety? Should a request for this go into separate tickets? Cheers Stefan *From:*qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] *On Behalf Of *didier peeters *Sent:* 26. juni 2015 12:36 *To:* qgis-user *Subject:* Re: [Qgis-user] Default values in form Hello Mathias, this would be great ! Additionally, this makes me think of another possible enhancement: when displaying a picture in a form tab, it could be nice to hide the label and path/url to the file, which is most of the time useless. Do I need to do anything more to make these suggestions ? Didier Le 26 juin 2015 à 12:07, Matthias Kuhn matthias.k...@gmx.ch mailto:matthias.k...@gmx.ch a écrit : I think this would fit into the area of this QEP: https://github.com/m-kuhn/QGIS-Enhancement-Proposals/blob/fields-and-forms-redesign/QEP-Fields-and-forms-redesign.rst#31-fields It could be added to the list Information about fields next to constraints. Any feedback on it is welcome. Matthias On 06/26/2015 11:35 AM, Paolo Cavallini wrote: Agreed, an important improvement. Please open a ticket if not already there. All the best. Il 26 giugno 2015 08:16:32 GMT+00:00, Blumentrath, Stefan stefan.blumentr...@nina.no mailto:stefan.blumentr...@nina.no ha scritto: Hei Didier, I guess you could use a python init function for the form in order to define default values (see: http://nathanw.net/2011/09/05/qgis-tips-custom-feature-forms-with-python-logic/). However, sounds like a useful enhancement of the Custom form functionality (at least I would be interested too)... Cheers Stefan -Original Message- From: qgis-user-boun...@lists.osgeo.org mailto:qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of didier peeters Sent: 26. juni 2015 10:08 To: qgis-user Subject: [Qgis-user] Default values in form Hello, Simple question : is there a way to set a default value for an attribute in QGis ? I have Postgis layers in QGis in which I’m inserting or updating data, and I would like that some fields would be filled automatically unless I fill them myself. Well that’s the definition of a default value, and I don’t think that using layers stored in Postgis would make any difference. Thanks Didier 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 -- http://faunalia.eu http://faunalia.eu// Sent from mobile, sorry for being short ___ 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
Re: [Qgis-user] SQL query for style
Hi Lester, You must choose styles based on rules! Properties -- Styles -- Rule-based Regards, * http://www.psig.es* *Carlos López Quintanilla* www.psig.es carlos.lo...@psig.es +34 699.680.261 2015-06-26 12:57 GMT+02:00 Lester Anderson arctica1...@gmail.com: Hi, I have a point database loaded with columns Z1 to Z6, where Z6 has values 0,0.5 and 1. What I am trying to do with the symbology is just to get it to plot and colour the depths (Z1) only where Z6=0 Can this be done from the style option for the layer? So what I want to do is: IF Z6=0 PLOT Z1 Sure this is very simple but can't see it :) Cheers Lester ___ 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
