Re: [Qgis-user] Query expression bugs with NULL Values
Hi José,
On Thu, 26. Mar 2015 at 10:19:10 +0100, José Carlos Martínez Llario wrote:
amenity'restaurant' returns 37 rows
amenity = 'restaurant' returns 11 rows
The layers has 48 NULL values, so it means that amenity
'restaurant' does not take into account the null values.
Hope this is a bug and not the correct behaviour.
It's the correct behaviour. NULL 'restaurant' is NULL, ie. not true.
Use eg. coalesce('amenity','') 'restaurant'
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] Qgis android
Good morning!! Could someone please help me i really need to use the open layers plugin on my android device in the field and i cant seem to do it or use bing maps or google for that matter on the background of my projects please help!! Best regards ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Query expression bugs with NULL Values
Sorry I didnt explain well. Forget about the second part of the email, I was talking about syntax, of course is well-known that NULL and 'NULL' are two different things but that was not my point): So this this the problem that I would like an answer: The table has 4635 rows, which 4587 are null as the following queries prove: amenity is not NULL returns 48 rows amenity is NULL returns 4587 rows The following queries doest not make sense: amenity'restaurant' returns 37 rows amenity = 'restaurant' returns 11 rows The layers has 48 NULL values, so it means that amenity 'restaurant' does not take into account the null values. Hope this is a bug and not the correct behaviour. Im using QGIS 2.8.1 The table has 48 null amenity rows and 4587 not null amenity rows as you can see from the first queries On 25/03/2015 20:38, Andre Joost wrote: Am 25.03.2015 um 20:07 schrieb José Carlos Martínez Llario: The layers has 48 NULL values, ... THIS IS OK amenity is not NULL returns 48 amenity is NULL returns 4587 This does not make nuch sense to me. Do you have 48 empty (NULL) entries, or 48 non-empty values? THIS IS WRONG (if null values can not be treated as a text in the syntax it shouldnt work in both cases or throw some error) amenity 'NULL' returns 48 amenity = 'NULL' returns 0 No, NULL and 'NULL' are two different things. It is possible to write 'NULL' as a text value for amenity (although it does not make sense, but the OSM database does not reject it). So it should be ok that amenity = 'NULL' returns nothing in your dataset. HTH, André Joost ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- -- José Carlos Martínez Llario http://cartosig.upv.es Producción Cartográfica y SIG. Dpto. Ingeniería Cartográfica. Univ. Politécnica de Valencia. -- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Format GETFEATUREINFO request from QGISwebserver
Hi,qgis-users, in the same way of my last question, about how format the GetFeatureInfo request in QGISServer, some people tells me that QGIS Server runs in a Mapserver architecture (its true?) If that's true, Mapserver format the getfeatureinfo request with a *.map file that includes a TEMPLATE option with HTML styles. This option is easier (for me I'm not a programmer) than the Python coding solution Now, my problem is that, when I search in QGISServer, I can not find any *.map file related about this. Someone knows where is this *.map file? Or how works QGISServer to call the mapserver .map file? Thanks a lot! Carles Vico 2015-03-20 12:21 GMT+01:00 Alessandro Pasotti apaso...@gmail.com: 2015-03-20 12:08 GMT+01:00 Carles Vico Blanco carles.v...@geografos.org: Thank you very much for the reply, but I have a question of your answer. When you say: The latest release, I understand the QGIS 2.8, that's correct? And then, I need to install the QGIS Server Python plugin on QGIS Server, as you say here http://www.itopen.it/qgis-server-python-plugins-ubuntu-setup/ , or It's no necessary from the latest release of QGIS Desktop? I'll try it and I tell you my result! Thanks a lot! The article describe the setup to install the example HelloServer plugin and let it run on Ubuntu 14.04 server edition, you might find that useful to get started, you can also read the other 2 articles in the QGIS section of my website http://www.itopen.it/category/gis/qgis/qgis-server/ You need to write a custom filter to modifiy GETFEATUREINFO request, if you examine the example plugin's code you will probably get some inspiration. Python plugins for QGIS Server are available with QGIS = 2.8 One of my tasks for the next HF is to add a Server section to the plugins official repository, if you develop something re-usable, don't forget to upload the plugin when it's done. Happy coding :) -- Alessandro Pasotti w3: www.itopen.it ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Query expression bugs with NULL Values
Thanks for the answer Jürgen, didnt know that QGIS used normal database
null logic which is fantastic.
Cheers,
Jose
On 26/03/2015 10:53, Jürgen E. Fischer wrote:
Hi José,
On Thu, 26. Mar 2015 at 10:19:10 +0100, José Carlos Martínez Llario wrote:
amenity'restaurant' returns 37 rows
amenity = 'restaurant' returns 11 rows
The layers has 48 NULL values, so it means that amenity
'restaurant' does not take into account the null values.
Hope this is a bug and not the correct behaviour.
It's the correct behaviour. NULL 'restaurant' is NULL, ie. not true.
Use eg. coalesce('amenity','') 'restaurant'
Jürgen
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
--
--
José Carlos Martínez Llario
http://cartosig.upv.es
Producción Cartográfica y SIG.
Dpto. Ingeniería Cartográfica.
Univ. Politécnica de Valencia.
--
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Format GETFEATUREINFO request from QGISwebserver
2015-03-26 11:44 GMT+01:00 Carles Vico Blanco carles.v...@geografos.org: Hi,qgis-users, in the same way of my last question, about how format the GetFeatureInfo request in QGISServer, some people tells me that QGIS Server runs in a Mapserver architecture (its true?) Completely false. -- Alessandro Pasotti w3: www.itopen.it ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Plugins are broken
Dear QGIS Users, As I sent a message to you all that Processing, QuickOSM andBuffer by percentage plugin are broken. I could not recovery it yet. Your help are much appreciated Regards Azizul ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Plugins are broken
Il 26/03/2015 14:23, azizul haque ha scritto: Dear QGIS Users, As I sent a message to you all that Processing, QuickOSM and Buffer by percentage plugin are broken. I could not recovery it yet. Hi Azizul, what is the error message? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Plugins are broken
Azizul, in another topic, you said that you are using QGIS 2.0.1. First, you should upgrade to 2.8.1. 2015-03-26 15:29 GMT+02:00 Paolo Cavallini cavall...@faunalia.it: Il 26/03/2015 14:23, azizul haque ha scritto: Dear QGIS Users, As I sent a message to you all that Processing, QuickOSM and Buffer by percentage plugin are broken. I could not recovery it yet. Hi Azizul, what is the error message? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: 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 mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Qgis-user Digest, Vol 109, Issue 55
Il 26/03/2015 21:27, azizul haque ha scritto: Hi Paolo, Thanks. Yes I am using QGIS 2.0.1(DUFOUR). You advised me to upgrade it. But I did many projects with this version. If I would upgrade some projects may not work. Any help Hi Azizul, IMHO not upgrading for such a long time will only cause more trouble than it solves. You may vae issues in upgrading your projects, but the hundreds new functions and bugfixes are worth the while. In any case, older versions are not officially supported, so you're on your own, unless you want to hire somebody to fix your problems. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] BBox Filter for WFS
As Marco explained in the realted post on qgis-dev the bbox filter should be used if cahce features option is turned off, but at the moment it seems broken, maybe because of new improvements in the rendering process. The issue has been already reported in http://hub.qgis.org/issues/11968 In the meanwhile a manual filter could be set within the WFS add layer dialog. giovanni 2015-03-26 16:07 GMT+01:00 G. Allegri gioha...@gmail.com: It's an intereseting question Peter. I've verified that the wfs provider still requests the whole data the first time, then it stores eveything (and create a spatial index for subsequent calls). I suppose that sponsoring this feature could be the right way to have it, but I'm curious to know what the latest answer from Marco was referring to (I mean within the svn code he indicates) [1] Giovanni [1] http://hub.qgis.org/issues/1421#note-4 2015-03-25 12:25 GMT+01:00 Peter Borissow peter.boris...@yahoo.com: Sorry for being impatient but I was wondering if anyone can shed some light on this issue. I have a WFS that's serving out over a billion features (several million records per layer). When I add a layer from the WFS into QGIS, it calls DescribeFeature and then GetFeature without a BBOX filter. QGIS then waits for ALL of the data to come back (which can take a while). In the past, there was an option only fetch features that intersect the current map extent. Without this option, it is extremely difficult to do anything with the WFS using QGIS. IMHO, this is a pretty significant bug but hopefully one that should be really easy to fix. Afterall, the code was there at some point... Related (unanswered) questions on stack exchange: http://gis.stackexchange.com/questions/53387/quantumgis-1-8-how-to-define-bounding-box-within-add-wfs-layer-dialog http://gis.stackexchange.com/questions/59656/is-there-free-desktop-wfs-client-with-bbox-support Thanks, Peter -- *From:* Peter Borissow peter.boris...@yahoo.com *To:* qgis-user@lists.osgeo.org qgis-user@lists.osgeo.org *Sent:* Monday, March 23, 2015 2:03 PM *Subject:* BBox Filter for WFS Hello- I noticed that the WFS client in QGIS 2.8 and 2.6 do not seem to pass a bbox filter when requesting features. It seems that in the past, QGIS had an option to only fetch features that intersect the current map extent: http://hub.qgis.org/issues/1421 Based on this thread, it looks like this feature was disabled in 1.8: http://osdir.com/ml/qgis-user-gis/2011-10/msg00308.html Is this feature still missing or is there a way to enable this feature in the latest release? Thanks, Peter ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Giovanni Allegri http://about.me/giovanniallegri Gis3W - http://gis3w.it Ikare - http://ikare.it Twitter: https://twitter.com/_giohappy_ blog: http://blog.spaziogis.it GEO+ geomatica in Italia http://bit.ly/GEOplus -- Giovanni Allegri http://about.me/giovanniallegri Gis3W - http://gis3w.it Ikare - http://ikare.it Twitter: https://twitter.com/_giohappy_ blog: http://blog.spaziogis.it GEO+ geomatica in Italia http://bit.ly/GEOplus ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Qgis-user Digest, Vol 109, Issue 54
/2.7/lib/python2.7/lib-old', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload', '/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyObjC', '/Library/Python/2.7/site-packages'] On Thursday, 26 March 2015, 12:39, qgis-user-requ...@lists.osgeo.org qgis-user-requ...@lists.osgeo.org wrote: Send Qgis-user mailing list submissions to qgis-user@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/qgis-user or, via email, send a message with subject or body 'help' to qgis-user-requ...@lists.osgeo.org You can reach the person managing the list at qgis-user-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of Qgis-user digest... Today's Topics: 1. Re: Plugins are broken (Paolo Cavallini) 2. Re: Plugins are broken (Etienne Trimaille) 3. Re: rule based classification - attribute based on other layer (Matteo Ghetta) 4. Re: rule based classification - attribute based on other layer (Matteo Ghetta) 5. measure processing time (research difference Qgis and ArcGIS) (Pieter Stevens) 6. Re: BBox Filter for WFS (G. Allegri) 7. Re: rule based classification - attribute based on other layer (Matteo Ghetta) 8. Re: rule based classification - attribute based on other layer (Andreas Neumann) 9. Re: BBox Filter for WFS (G. Allegri) -- Message: 1 Date: Thu, 26 Mar 2015 14:29:06 +0100 From: Paolo Cavallini cavall...@faunalia.it To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Plugins are broken Message-ID: 551409a2.7050...@faunalia.it Content-Type: text/plain; charset=windows-1252 Il 26/03/2015 14:23, azizul haque ha scritto: Dear QGIS Users, As I sent a message to you all that Processing, QuickOSM and Buffer by percentage plugin are broken. I could not recovery it yet. Hi Azizul, what is the error message? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html -- Message: 2 Date: Thu, 26 Mar 2015 15:32:50 +0200 From: Etienne Trimaille etienne.trimai...@gmail.com To: Paolo Cavallini cavall...@faunalia.it Cc: qgis-user qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Plugins are broken Message-ID: CAMtDFLLep_fYLSa4cOedRveDpV8vT53YT4v+6ACpcnESNCP=z...@mail.gmail.com Content-Type: text/plain; charset=utf-8 Azizul, in another topic, you said that you are using QGIS 2.0.1. First, you should upgrade to 2.8.1. 2015-03-26 15:29 GMT+02:00 Paolo Cavallini cavall...@faunalia.it: Il 26/03/2015 14:23, azizul haque ha scritto: Dear QGIS Users, As I sent a message to you all that Processing, QuickOSM and Buffer by percentage plugin are broken. I could not recovery it yet. Hi Azizul, what is the error message? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- next part -- An HTML attachment was scrubbed... URL: http://lists.osgeo.org/pipermail/qgis-user/attachments/20150326/0684c930/attachment-0001.html -- Message: 3 Date: Thu, 26 Mar 2015 15:53:05 +0100 From: Matteo Ghetta matteo.ghe...@gmail.com To: t...@wildintellect.com Cc: QGIS Mailing List qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] rule based classification - attribute based on other layer Message-ID: cammn2u0tfmapdbobmo9iyf+h8cd-1whze3xnhhkx7zvmdxz...@mail.gmail.com Content-Type: text/plain; charset=utf-8 Sounds like you are trying Red if valueA max(layer B value)? exactly... :) -- next part -- An HTML attachment was scrubbed... URL: http://lists.osgeo.org/pipermail/qgis-user/attachments/20150326/f89db620/attachment-0001.html -- Message: 4 Date: Thu, 26 Mar 2015 16:02:02 +0100 From: Matteo Ghetta matteo.ghe...@gmail.com To: Junior Delaz del...@gmail.com Cc: QGIS Mailing List qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] rule based classification - attribute based on other layer Message-ID: cammn2u2q8cchr217vs6+03uwsh7aoq6qnt1+jc_uw5h20vj...@mail.gmail.com Content-Type: text/plain; charset=utf-8 Hi, I cannot install the plugin.. I have a missing library (qtsql)... anyway thanks for clarifying.. Matteo 2015-03-25 19:11 GMT+01:00 Junior Delaz del...@gmail.com: Hello, You may give a look to *getFeature* function (combining or not with function like *attribute* or spatial ones). There is also *RefFunctions* plugin that may help to use values/fields of another layer. But unfortunately, there is no list of such layers nor their fields in the dialog. You need to write
Re: [Qgis-user] Qgis-user Digest, Vol 109, Issue 55
:05) [GCC 4.2.1 Compatible Apple LLVM 5.0 (clang-500.0.68)] QGIS version: 2.0.1-Dufour Dufour, f738351 Python path: ['/Applications/QGIS.app/Contents/MacOS/../Resources/python', '/Users/ahaque/.qgis2/python', '/Users/ahaque/.qgis2/python/plugins', '/Applications/QGIS.app/Contents/MacOS/../Resources/python/plugins', '/Library/Frameworks/SQLite3.framework/Versions/B/Python/2.7', '/Library/Frameworks/GEOS.framework/Versions/3/Python/2.7', '/Library/Python/2.7/site-packages/numpy-override', '/Library/Python/2.7/site-packages/matplotlib-override', '/Library/Frameworks/GDAL.framework/Versions/1.11/Python/2.7/site-packages', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python27.zip', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-darwin', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/plat-mac/lib-scriptpackages', '/System/Library/Frameworks/Python.framework/Versions /2.7/Extras/lib/python', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-tk', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-old', '/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload', '/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/PyObjC', '/Library/Python/2.7/site-packages'] On Thursday, 26 March 2015, 12:39, qgis-user-requ...@lists.osgeo.org qgis-user-requ...@lists.osgeo.org wrote: Send Qgis-user mailing list submissions to ??? qgis-user@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit ??? http://lists.osgeo.org/mailman/listinfo/qgis-user or, via email, send a message with subject or body 'help' to ??? qgis-user-requ...@lists.osgeo.org You can reach the person managing the list at ??? qgis-user-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of Qgis-user digest... Today's Topics: ? 1. Re: Plugins are broken (Paolo Cavallini) ? 2. Re: Plugins are broken (Etienne Trimaille) ? 3. Re: rule based classification - attribute based on??? other ? ? ? layer (Matteo Ghetta) ? 4. Re: rule based classification - attribute based on??? other ? ? ? layer (Matteo Ghetta) ? 5. measure processing time (research difference Qgis and??? ArcGIS) ? ? ? (Pieter Stevens) ? 6. Re: BBox Filter for WFS (G. Allegri) ? 7. Re: rule based classification - attribute based on??? other ? ? ? layer (Matteo Ghetta) ? 8. Re: rule based classification - attribute based on other ? ? ? layer (Andreas Neumann) ? 9. Re: BBox Filter for WFS (G. Allegri) -- Message: 1 Date: Thu, 26 Mar 2015 14:29:06 +0100 From: Paolo Cavallini cavall...@faunalia.it To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Plugins are broken Message-ID: 551409a2.7050...@faunalia.it Content-Type: text/plain; charset=windows-1252 Il 26/03/2015 14:23, azizul haque ha scritto: Dear QGIS Users, As I sent a message to you all that Processing, QuickOSM and Buffer by percentage plugin are broken. I could not recovery it yet. Hi Azizul, what is the error message? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html -- Message: 2 Date: Thu, 26 Mar 2015 15:32:50 +0200 From: Etienne Trimaille etienne.trimai...@gmail.com To: Paolo Cavallini cavall...@faunalia.it Cc: qgis-user qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Plugins are broken Message-ID: ??? CAMtDFLLep_fYLSa4cOedRveDpV8vT53YT4v+6ACpcnESNCP=z...@mail.gmail.com Content-Type: text/plain; charset=utf-8 Azizul, in another topic, you said that you are using QGIS 2.0.1. First, you should upgrade to 2.8.1. 2015-03-26 15:29 GMT+02:00 Paolo Cavallini cavall...@faunalia.it: Il 26/03/2015 14:23, azizul haque ha scritto: Dear QGIS Users, As I sent a message to you all that Processing, QuickOSM and Buffer by percentage plugin are broken. I could not recovery it yet. Hi Azizul, what is the error message? All the best. -- Paolo Cavallini - www.faunalia.eu QGIS PostGIS courses: http://www.faunalia.eu/training.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- next part -- An HTML attachment was scrubbed... URL: http://lists.osgeo.org/pipermail/qgis-user/attachments/20150326/0684c930/attachment-0001.html -- Message: 3 Date: Thu, 26 Mar 2015 15:53:05 +0100 From: Matteo Ghetta matteo.ghe...@gmail.com To: t...@wildintellect.com Cc: QGIS Mailing List qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] rule based classification - attribute based ??? on??? other layer
Re: [Qgis-user] BBox Filter for WFS
That's exactly how I would expect it to work. To cache a whole WFS and start seems overboard, in that case why wouldn't you just download the data set. BBOX is a must for web services as a main part of the purpose is to allow users to only grab the part they need when they need it. Thanks, Alex On 03/26/2015 01:28 PM, Peter Borissow wrote: Thanks Giovanni-It seems to me that the cache features option and the option to fetch only the features intersecting the current map extent should be 2 separate options. For example, when I open a WFS layer, I might want to retrieve only the features intersecting the current map extent. Once it is loaded, I would want QGIS to cache the features. This is a common rendering technique used for WMS. A client requests an initial BBOX and renders the image. The when the client pans, a new request is made but only for the missing area. The original response is cached and merged with the second response. Just a thought... Peter From: G. Allegri gioha...@gmail.com To: Peter Borissow peter.boris...@yahoo.com Cc: qgis-user@lists.osgeo.org qgis-user@lists.osgeo.org Sent: Thursday, March 26, 2015 1:27 PM Subject: Re: [Qgis-user] BBox Filter for WFS As Marco explained in the realted post on qgis-dev the bbox filter should be used if cahce features option is turned off, but at the moment it seems broken, maybe because of new improvements in the rendering process. The issue has been already reported in http://hub.qgis.org/issues/11968 In the meanwhile a manual filter could be set within the WFS add layer dialog. giovanni 2015-03-26 16:07 GMT+01:00 G. Allegri gioha...@gmail.com: It's an intereseting question Peter. I've verified that the wfs provider still requests the whole data the first time, then it stores eveything (and create a spatial index for subsequent calls).I suppose that sponsoring this feature could be the right way to have it, but I'm curious to know what the latest answer from Marco was referring to (I mean within the svn code he indicates) [1] Giovanni [1] http://hub.qgis.org/issues/1421#note-4 2015-03-25 12:25 GMT+01:00 Peter Borissow peter.boris...@yahoo.com: Sorry for being impatient but I was wondering if anyone can shed some light on this issue. I have a WFS that's serving out over a billion features (several million records per layer). When I add a layer from the WFS into QGIS, it calls DescribeFeature and then GetFeature without a BBOX filter. QGIS then waits for ALL of the data to come back (which can take a while). In the past, there was an option only fetch features that intersect the current map extent. Without this option, it is extremely difficult to do anything with the WFS using QGIS. IMHO, this is a pretty significant bug but hopefully one that should be really easy to fix. Afterall, the code was there at some point... Related (unanswered) questions on stack exchange: http://gis.stackexchange.com/questions/53387/quantumgis-1-8-how-to-define-bounding-box-within-add-wfs-layer-dialog http://gis.stackexchange.com/questions/59656/is-there-free-desktop-wfs-client-with-bbox-support Thanks,Peter From: Peter Borissow peter.boris...@yahoo.com To: qgis-user@lists.osgeo.org qgis-user@lists.osgeo.org Sent: Monday, March 23, 2015 2:03 PM Subject: BBox Filter for WFS Hello-I noticed that the WFS client in QGIS 2.8 and 2.6 do not seem to pass a bbox filter when requesting features. It seems that in the past, QGIS had an option to only fetch features that intersect the current map extent: http://hub.qgis.org/issues/1421 Based on this thread, it looks like this feature was disabled in 1.8: http://osdir.com/ml/qgis-user-gis/2011-10/msg00308.html Is this feature still missing or is there a way to enable this feature in the latest release? Thanks,Peter ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Question Install QGIS 2.8.1 - 64bit while QGIS 2.6.0 32bit still installed
Hello, I have been using QGIS 2.6.0 32bit and have just installed QGIS 2.8.1 64 bit. I noticed that the Proxy setting I had for QGIS 2.6.0 32bit show up in my QGIS 2.8.1 64bit version And The Plug-Ins I had in QGIS 2.6.0 32bit show up as already installed in my QGIS 2.8.1 64bit version. Is there going to be any problems with the Plug-Ins? Is there a difference between a Plug-In used by a 32bit version of QGIS vs a 64bit version? Also once I open files in version 2.8.1 will they not be able to be used with the 2.6.0 version? Thanks for your assistance. Best Regards, Tom Leahy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Question Install QGIS 2.8.1 - 64bit while QGIS 2.6.0 32bit still installed
Hi Tom, Plugins should work smoothly between the 32bit and 64bit QGIS version, as Python is a scripting language and compiled/recompiled when necessary (the pyc versions are the binary versions of the python files). There is more problems for plugins when moved between different QGIS versions, esp. when there are API differences. You can also use the same plugins/python files on other OS (fe. Linux and OSX) if the plugin author did not use anything operating system dependent. Greetings, Andreas On 26.03.2015 08:20, Leahy, Thomas A. wrote: Hello, I have been using QGIS 2.6.0 32bit and have just installed QGIS 2.8.1 64 bit. I noticed that the Proxy setting I had for QGIS 2.6.0 32bit show up in my QGIS 2.8.1 64bit version And The Plug-Ins I had in QGIS 2.6.0 32bit show up as already installed in my QGIS 2.8.1 64bit version. Is there going to be any problems with the Plug-Ins? Is there a difference between a Plug-In used by a 32bit version of QGIS vs a 64bit version? Also once I open files in version 2.8.1 will they not be able to be used with the 2.6.0 version? Thanks for your assistance. Best Regards, Tom Leahy ___ 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] rule based classification - attribute based on other layer
Hi, Note that, if you work on QGIS 2.8, getFeature() and attribute() are already part of core - no need to install a plugin. However, there may be a quite negative impact on performance, if you include such functions in your symbology impressions. So use them with care, only if you really need them! Andreas On 26.03.2015 16:10, Matteo Ghetta wrote: sorry... plugin installed... I see all the functions in the field calculator but do you have a small and quick example of what I am looking for? I don't understand the function to use.. Thanks! Matteo 2015-03-25 19:11 GMT+01:00 Junior Delaz del...@gmail.com mailto:del...@gmail.com: Hello, You may give a look to /getFeature/ function (combining or not with function like /attribute/ or spatial ones). There is also /RefFunctions/ plugin that may help to use values/fields of another layer. But unfortunately, there is no list of such layers nor their fields in the dialog. You need to write them yourself and their values. 2015-03-25 18:14 GMT+01:00 Matteo Ghetta matteo.ghe...@gmail.com mailto:matteo.ghe...@gmail.com: Hi all, very simple question. In the rule-based classification (vector) is it possible to use values of another layer loaded in QGIS? For example. Point vector and I want to display as red each feature that has a value greater than a value stored in another point layer (or in a table). In the expression builder there are the fields of the active layer. Is it possible to call the fields of other layers? Thanks Cheers Matteo ___ 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 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] measure processing time (research difference Qgis and ArcGIS)
Dear sir, Dear madam, As a student of the university Ghent I'm researching the differences and similarities between ArcGIS and QuantumGIS. A part of the research is about the time needed to process simple tools (for exemple: buffer, clip, union, .). ArcGIS has the possibility to watch the log where you can see how long the program took to process. I was wondering whether QGIS has the same function. I was also wondering whether anyone of the QGIS community already did comparable research, or has read anything that could help me. Sincerely, Pieter Stevens Linking program to master of science in land surveying technology ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] rule based classification - attribute based on other layer
sorry... plugin installed... I see all the functions in the field calculator but do you have a small and quick example of what I am looking for? I don't understand the function to use.. Thanks! Matteo 2015-03-25 19:11 GMT+01:00 Junior Delaz del...@gmail.com: Hello, You may give a look to *getFeature* function (combining or not with function like *attribute* or spatial ones). There is also *RefFunctions* plugin that may help to use values/fields of another layer. But unfortunately, there is no list of such layers nor their fields in the dialog. You need to write them yourself and their values. 2015-03-25 18:14 GMT+01:00 Matteo Ghetta matteo.ghe...@gmail.com: Hi all, very simple question. In the rule-based classification (vector) is it possible to use values of another layer loaded in QGIS? For example. Point vector and I want to display as red each feature that has a value greater than a value stored in another point layer (or in a table). In the expression builder there are the fields of the active layer. Is it possible to call the fields of other layers? Thanks Cheers Matteo ___ 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] rule based classification - attribute based on other layer
Sounds like you are trying Red if valueA max(layer B value)? exactly... :) ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] rule based classification - attribute based on other layer
Hi, I cannot install the plugin.. I have a missing library (qtsql)... anyway thanks for clarifying.. Matteo 2015-03-25 19:11 GMT+01:00 Junior Delaz del...@gmail.com: Hello, You may give a look to *getFeature* function (combining or not with function like *attribute* or spatial ones). There is also *RefFunctions* plugin that may help to use values/fields of another layer. But unfortunately, there is no list of such layers nor their fields in the dialog. You need to write them yourself and their values. 2015-03-25 18:14 GMT+01:00 Matteo Ghetta matteo.ghe...@gmail.com: Hi all, very simple question. In the rule-based classification (vector) is it possible to use values of another layer loaded in QGIS? For example. Point vector and I want to display as red each feature that has a value greater than a value stored in another point layer (or in a table). In the expression builder there are the fields of the active layer. Is it possible to call the fields of other layers? Thanks Cheers Matteo ___ 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] BBox Filter for WFS
It's an intereseting question Peter. I've verified that the wfs provider still requests the whole data the first time, then it stores eveything (and create a spatial index for subsequent calls). I suppose that sponsoring this feature could be the right way to have it, but I'm curious to know what the latest answer from Marco was referring to (I mean within the svn code he indicates) [1] Giovanni [1] http://hub.qgis.org/issues/1421#note-4 2015-03-25 12:25 GMT+01:00 Peter Borissow peter.boris...@yahoo.com: Sorry for being impatient but I was wondering if anyone can shed some light on this issue. I have a WFS that's serving out over a billion features (several million records per layer). When I add a layer from the WFS into QGIS, it calls DescribeFeature and then GetFeature without a BBOX filter. QGIS then waits for ALL of the data to come back (which can take a while). In the past, there was an option only fetch features that intersect the current map extent. Without this option, it is extremely difficult to do anything with the WFS using QGIS. IMHO, this is a pretty significant bug but hopefully one that should be really easy to fix. Afterall, the code was there at some point... Related (unanswered) questions on stack exchange: http://gis.stackexchange.com/questions/53387/quantumgis-1-8-how-to-define-bounding-box-within-add-wfs-layer-dialog http://gis.stackexchange.com/questions/59656/is-there-free-desktop-wfs-client-with-bbox-support Thanks, Peter -- *From:* Peter Borissow peter.boris...@yahoo.com *To:* qgis-user@lists.osgeo.org qgis-user@lists.osgeo.org *Sent:* Monday, March 23, 2015 2:03 PM *Subject:* BBox Filter for WFS Hello- I noticed that the WFS client in QGIS 2.8 and 2.6 do not seem to pass a bbox filter when requesting features. It seems that in the past, QGIS had an option to only fetch features that intersect the current map extent: http://hub.qgis.org/issues/1421 Based on this thread, it looks like this feature was disabled in 1.8: http://osdir.com/ml/qgis-user-gis/2011-10/msg00308.html Is this feature still missing or is there a way to enable this feature in the latest release? Thanks, Peter ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Giovanni Allegri http://about.me/giovanniallegri Gis3W - http://gis3w.it Ikare - http://ikare.it Twitter: https://twitter.com/_giohappy_ blog: http://blog.spaziogis.it GEO+ geomatica in Italia http://bit.ly/GEOplus ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
