Re: [Qgis-user] [QGIS-Developer] Bug with GeoPackage and Expressions?

[Nyall Dawson]

On Thu, 29 Jul 2021 at 15:31, Matthias Kuhn  wrote:
>
> Can you fill a bug for this? The expression compiler in QGIS should not 
> forward it to ogr/gpkg/sqlite in this case.

My interpretation is that Calvin is setting a layer filter, so QGIS
expressions aren't involved (i.e. no bug).

Nyall

>
> Matthias
>
> On Wed, Jul 28, 2021 at 10:08 PM C Hamilton  wrote:
>>
>> Thanks everyone for that explanation. This does complicate the ability to 
>> set an expression filter in a plugin when it depends on the data source 
>> type. I'm not sure what to do about that.
>>
>> Regards,
>> Calvin
>>
>> On Wed, Jul 28, 2021 at 8:00 PM Anita Graser  wrote:
>>>
>>> Hi Calvin,
>>>
>>> 28 Jul 2021 21:43:40 C Hamilton :
>>> > If I use LIKE instead of ILIKE then it works. It is like ILIKE was not 
>>> > implemented for GeoPackage. Can anyone verify this?
>>>
>>> Yes, there seems to be no iLike in sqlite:
>>>
>>> https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite
>>>
>>> And therefore neither in geopackage.
>>>
>>> Regards
>>> Anita
>>
>> ___
>> QGIS-Developer mailing list
>> qgis-develo...@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
> ___
> QGIS-Developer mailing list
> qgis-develo...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Bug with GeoPackage and Expressions?

[C Hamilton]

Thanks everyone for that explanation. This does complicate the ability to
set an expression filter in a plugin when it depends on the data source
type. I'm not sure what to do about that.

Regards,
Calvin

On Wed, Jul 28, 2021 at 8:00 PM Anita Graser  wrote:

> Hi Calvin,
>
> 28 Jul 2021 21:43:40 C Hamilton :
> > If I use LIKE instead of ILIKE then it works. It is like ILIKE was not
> implemented for GeoPackage. Can anyone verify this?
>
> Yes, there seems to be no iLike in sqlite:
>
>
> https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite
>
> And therefore neither in geopackage.
>
> Regards
> Anita
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Bug with GeoPackage and Expressions?

[Anita Graser]

Hi Calvin,

28 Jul 2021 21:43:40 C Hamilton :
> If I use LIKE instead of ILIKE then it works. It is like ILIKE was not 
> implemented for GeoPackage. Can anyone verify this?

Yes, there seems to be no iLike in sqlite:

https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite

And therefore neither in geopackage.

Regards
Anita
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] [QGIS-Developer] Bug with GeoPackage and Expressions?

[Even Rouault]

SQLite, which is the underneath database engine for GeoPackage, doesn't 
support ILIKE. The SQLite LIKE operator is actually case insensitive for 
ASCII characters. See paragraph 5 "The LIKE, GLOB, REGEXP, and MATCH 
operators" of https://www.sqlite.org/lang_expr.html


Le 28/07/2021 à 21:43, C Hamilton a écrit :
I think I found a bug and was wondering if someone could verify this. 
I am on Windows 10 and tried this with both QGIS 3.16.9 and 3.20.1.


I tried the following filter expression on the Natural Earth data set 
ne_10m_populated_places 
(https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_places.zip 
). 
Once loaded into QGIS right mouse click on the layer and select 
"Properties...", then click on the "Source" tab, click on "Query 
Builder" and then use this query


"NAME" ILIKE '%Bom%'

This works fine. If I export ne_10m_populated_places as a GeoPackage 
and try the same thing with the GeoPackage version of the layer, I get 
the error:


"An error occurred when executing the query, please check the 
expression syntax."


If I use LIKE instead of ILIKE then it works. It is like ILIKE was not 
implemented for GeoPackage. Can anyone verify this? I think you can 
use any vector layer for this test with one that is a shapefile and 
the other a GeoPackage.


Thanks,

Calvin


___
QGIS-Developer mailing list
qgis-develo...@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer


--
http://www.spatialys.com
My software is free, but my time generally not.

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Bug with GeoPackage and Expressions?

[C Hamilton]

I think I found a bug and was wondering if someone could verify this. I am
on Windows 10 and tried this with both QGIS 3.16.9 and 3.20.1.

I tried the following filter expression on the Natural Earth data set
ne_10m_populated_places (
https://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_places.zip).
Once loaded into QGIS right mouse click on the layer and select
"Properties...", then click on the "Source" tab, click on "Query Builder"
and then use this query

"NAME" ILIKE '%Bom%'

This works fine. If I export ne_10m_populated_places as a GeoPackage and
try the same thing with the GeoPackage version of the layer, I get the
error:

"An error occurred when executing the query, please check the expression
syntax."

If I use LIKE instead of ILIKE then it works. It is like ILIKE was not
implemented for GeoPackage. Can anyone verify this? I think you can use any
vector layer for this test with one that is a shapefile and the other a
GeoPackage.

Thanks,

Calvin
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fiber network Cables

[krishna Ayyala]

Nicolas,
Thanks for the reply. For the area below, I am attaching the shapefile
containing buildings and its centroids. When you get a chance, can you
please guide me on how to accomplish this task of shortest paths between
houses and servers?


[image: image.png]

On Wed, Jul 28, 2021 at 12:54 PM Nicolas Cadieux <
njacadieux.git...@gmail.com> wrote:

> Hi,
>
> The previous person that had this problem used the QGIS network analysis
> tool. It was easy because they followed a previously drawn network.  All
> they had to figure out was the shortest paths between houses and servers.
> If you follow that lead, I am developing a network checking model to help
> find problems.
>
> Nicolas Cadieux
> https://gitlab.com/njacadieux
>
> Le 28 juill. 2021 à 14:23, krishna Ayyala  a
> écrit :
>
> 
> Nicolas,
> I am not asking for the compatibility of the files nor am I asking on how
> to change the symbology. Previously when I used to have access to the fiber
> design software, after defining the area, the fiber design software has
> generated the fiber network. As I mentioned before I no longer have a
> subscription for this software. Is it possible to generate a similar design
> network using QGIS plugins/tools? In my previous email I mentioned about
> the font colors just to distinguish between the distribution cable and the
> drop cable. I was wondering if QGIS can produce a similar design?
>
> Regards.
>
> On Wed, Jul 28, 2021 at 11:40 AM Nicolas Cadieux <
> njacadieux.git...@gmail.com> wrote:
>
>> Hi,
>>
>> If the files created by the software are compatible with QGIS, simply
>> open the files, right click on the layer and go to layer properties, and
>> change the style.  What is the format for your layers?
>>
>>
>> https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/vector_properties.html?highlight=style#symbology-properties
>>
>> Nicolas Cadieux
>> https://gitlab.com/njacadieux
>>
>> Le 28 juill. 2021 à 11:37, krishna Ayyala  a
>> écrit :
>>
>> 
>> Hello,
>> Using the plugins/tools within QGIS, Is it possible to get the network as
>> shown below? I was able to get the following results using fiber design
>> software. I no longer have the subscription for that software. Hence, can
>> anyone help me accomplish this using the tools within QGIS? Blue font cable
>> is the distribution cable and the red font cable is the drop cable.
>>
>> 
>>
>>
>> Regards.
>>
>>
>>
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>
<>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fiber network Cables

[Nicolas Cadieux]

Hi,

The previous person that had this problem used the QGIS network analysis tool. 
It was easy because they followed a previously drawn network.  All they had to 
figure out was the shortest paths between houses and servers.  If you follow 
that lead, I am developing a network checking model to help find problems.

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 28 juill. 2021 à 14:23, krishna Ayyala  a écrit :
> 
> 
> Nicolas,
> I am not asking for the compatibility of the files nor am I asking on how to 
> change the symbology. Previously when I used to have access to the fiber 
> design software, after defining the area, the fiber design software has 
> generated the fiber network. As I mentioned before I no longer have a 
> subscription for this software. Is it possible to generate a similar design 
> network using QGIS plugins/tools? In my previous email I mentioned about the 
> font colors just to distinguish between the distribution cable and the drop 
> cable. I was wondering if QGIS can produce a similar design?
> 
> Regards.
> 
>> On Wed, Jul 28, 2021 at 11:40 AM Nicolas Cadieux 
>>  wrote:
>> Hi,
>> 
>> If the files created by the software are compatible with QGIS, simply open 
>> the files, right click on the layer and go to layer properties, and change 
>> the style.  What is the format for your layers?
>> 
>> https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/vector_properties.html?highlight=style#symbology-properties
>> 
>> Nicolas Cadieux
>> https://gitlab.com/njacadieux
>> 
 Le 28 juill. 2021 à 11:37, krishna Ayyala  a 
 écrit :
 
>>> 
>>> Hello,
>>> Using the plugins/tools within QGIS, Is it possible to get the network as 
>>> shown below? I was able to get the following results using fiber design 
>>> software. I no longer have the subscription for that software. Hence, can 
>>> anyone help me accomplish this using the tools within QGIS? Blue font cable 
>>> is the distribution cable and the red font cable is the drop cable.
>>> 
>>> 
>>> 
>>> 
>>> Regards.
>>> 
>>> 
>>> 
>>> ___
>>> Qgis-user mailing list
>>> Qgis-user@lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fiber network Cables

[krishna Ayyala]

Alexander,
Thanks for the reply. I tried to download the plugin from the link below..
But it is not working for me. The last it was updated was July 2018. Any
other leads?

Regards.

https://plugins.qgis.org/plugins/FiberOpticNetworkDesignSystem/

On Wed, Jul 28, 2021 at 12:30 PM Alexander Bruy 
wrote:

> Hi,
>
> there were some plugins for fiber network design. Maybe you should search
> in the plugins repository.
> Also some companies have in-house tools (e.g. PlannerFTTH), but these most
> likely are developed
> for the specific use cases.
>
> ср, 28 лип. 2021 о 18:37 krishna Ayyala  пише:
>
>> Hello,
>> Using the plugins/tools within QGIS, Is it possible to get the network as
>> shown below? I was able to get the following results using fiber design
>> software. I no longer have the subscription for that software. Hence, can
>> anyone help me accomplish this using the tools within QGIS? Blue font cable
>> is the distribution cable and the red font cable is the drop cable.
>>
>> [image: image.png]
>>
>> Regards.
>>
>>
>>
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
> --
> Alexander Bruy
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fiber network Cables

[Alexander Bruy]

Hi,

there were some plugins for fiber network design. Maybe you should search
in the plugins repository.
Also some companies have in-house tools (e.g. PlannerFTTH), but these most
likely are developed
for the specific use cases.

ср, 28 лип. 2021 о 18:37 krishna Ayyala  пише:

> Hello,
> Using the plugins/tools within QGIS, Is it possible to get the network as
> shown below? I was able to get the following results using fiber design
> software. I no longer have the subscription for that software. Hence, can
> anyone help me accomplish this using the tools within QGIS? Blue font cable
> is the distribution cable and the red font cable is the drop cable.
>
> [image: image.png]
>
> Regards.
>
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>


-- 
Alexander Bruy
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fiber network Cables

[krishna Ayyala]

Nicolas,
I am not asking for the compatibility of the files nor am I asking on how
to change the symbology. Previously when I used to have access to the fiber
design software, after defining the area, the fiber design software has
generated the fiber network. As I mentioned before I no longer have a
subscription for this software. Is it possible to generate a similar design
network using QGIS plugins/tools? In my previous email I mentioned about
the font colors just to distinguish between the distribution cable and the
drop cable. I was wondering if QGIS can produce a similar design?

Regards.

On Wed, Jul 28, 2021 at 11:40 AM Nicolas Cadieux <
njacadieux.git...@gmail.com> wrote:

> Hi,
>
> If the files created by the software are compatible with QGIS, simply open
> the files, right click on the layer and go to layer properties, and change
> the style.  What is the format for your layers?
>
>
> https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/vector_properties.html?highlight=style#symbology-properties
>
> Nicolas Cadieux
> https://gitlab.com/njacadieux
>
> Le 28 juill. 2021 à 11:37, krishna Ayyala  a
> écrit :
>
> 
> Hello,
> Using the plugins/tools within QGIS, Is it possible to get the network as
> shown below? I was able to get the following results using fiber design
> software. I no longer have the subscription for that software. Hence, can
> anyone help me accomplish this using the tools within QGIS? Blue font cable
> is the distribution cable and the red font cable is the drop cable.
>
> 
>
>
> Regards.
>
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fiber network Cables

[Nicolas Cadieux]

Hi,
This is the list of compatible file formats.
https://gdal.org/drivers/vector/index.html

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 28 juill. 2021 à 13:40, Nicolas Cadieux  a 
> écrit :
> 
> Hi,
> 
> If the files created by the software are compatible with QGIS, simply open 
> the files, right click on the layer and go to layer properties, and change 
> the style.  What is the format for your layers?
> 
> https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/vector_properties.html?highlight=style#symbology-properties
> 
> Nicolas Cadieux
> https://gitlab.com/njacadieux
> 
>>> Le 28 juill. 2021 à 11:37, krishna Ayyala  a écrit 
>>> :
>>> 
>> 
>> Hello,
>> Using the plugins/tools within QGIS, Is it possible to get the network as 
>> shown below? I was able to get the following results using fiber design 
>> software. I no longer have the subscription for that software. Hence, can 
>> anyone help me accomplish this using the tools within QGIS? Blue font cable 
>> is the distribution cable and the red font cable is the drop cable.
>> 
>> 
>> 
>> 
>> Regards.
>> 
>> 
>> 
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Fiber network Cables

[Nicolas Cadieux]

Hi,

If the files created by the software are compatible with QGIS, simply open the 
files, right click on the layer and go to layer properties, and change the 
style.  What is the format for your layers?

https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/vector_properties.html?highlight=style#symbology-properties

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 28 juill. 2021 à 11:37, krishna Ayyala  a écrit :
> 
> 
> Hello,
> Using the plugins/tools within QGIS, Is it possible to get the network as 
> shown below? I was able to get the following results using fiber design 
> software. I no longer have the subscription for that software. Hence, can 
> anyone help me accomplish this using the tools within QGIS? Blue font cable 
> is the distribution cable and the red font cable is the drop cable.
> 
> 
> 
> 
> Regards.
> 
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Fiber network Cables

[krishna Ayyala]

Hello,
Using the plugins/tools within QGIS, Is it possible to get the network as
shown below? I was able to get the following results using fiber design
software. I no longer have the subscription for that software. Hence, can
anyone help me accomplish this using the tools within QGIS? Blue font cable
is the distribution cable and the red font cable is the drop cable.

[image: image.png]

Regards.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Select by Expression: exclusive (not inclusive)

[Andy Harfoot]

I have just tried this whilst working with some Openstreetmap data 
downloaded using the OSM Downloader plugin, and loaded into QGIS 
(3.16.9) directly from the .osm XML file.


The 'osm lines' layer has a highway attribute with 16 unique values and 
NULLs. Using Select by Expression with the following:


 "highway" NOT IN ( 'bridleway' , 'cycleway' , 'footway' )

correctly selected rows with different values to these, but not the NULL 
rows. To include NULLS, try this:


 coalesce( "highway",'') NOT IN ( 'bridleway' , 'cycleway' , 'footway' )

Creating a virtual layer using the following SQL:

SELECT * FROM "osm lines" WHERE highway NOT IN ( 'bridleway' , 'cycleway' , 
'footway' )

Returned the same set of rows as the first expression, again without the 
NULLs.


These results are what I would expect, I am not sure why yours differ.

Cheers,

Andy

On 07/07/2021 08:23, Andrew Hughes wrote:

*CAUTION:* This e-mail originated outside the University of Southampton.
Hi All,

I can't for the life of me figure out why I can't "Select all features 
that are *_NOT_* an alley, drive-through, driveway "


I am trying to use "Select by Expression".

The attribute I am trying to filter with is called "tag_service" and 
has 77 distinct values, including NULL.


*Q: Why does this expression select nothing?*

/"tag_service" NOT IN ('alley', 'drive-through', 'driveway',
'laneway', 'parking_aisle', 'parking')/


Supplementary, the following does select records (but I want the above 
expression to work):


/"tag_service" IS NULL or "tag_service" = "service"/


Help would be much appreciated,

Thank you
Andrew


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


--
Andy Harfoot

Skype: gdi_ajph
Teams: a...@soton.ac.uk

GeoData Institute
University of Southampton
Southampton
SO17 1BJ

www.geodata.soton.ac.uk

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Problem installing QGIS on Ubuntu 20.04 - key authentification

[Andrea Giudiceandrea]

Hi Eva and QGIS users,
finally the server at gibs.earthdata.nasa.gov was upgraded in order to 
support SHA256 (instead of SHA1) as peer signing digest algorithm.


So, it is now possible to properly connect to it using QGIS on Ubuntu 
20.04 without the need to lower the default SECURITY LEVEL from 2 to 1.


Regards.

Andrea Giudiceandrea


Wed, 26 Aug 2020 14:51:30 -0700, andreaer...@libero.it wrote:

Hi all,
I've reported the issue to supp...@earthdata.nasa.gov and it seems they are
committed to fix it:

"After looking into it, we recognize that this is an issue on our side and
will be addressing it within the next few weeks."


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user