Re: [Qgis-user] Select data from a specific layer

[Ujaval Gandhi]

get_feature() will get you the feature.Your current expression will get you
the first feature from 'V_TB_ATTIVITA_PT_NR' layer where the "Colore" value
is 'N'. - I don't think that is what you want.  You need to query for a
feature from another layer that relates to the current feature, (using a
common field value).  Once you get the feature, you can use the
attributes(feature)['Colore'] to read the "Colore' field from that feature.

[image: Logo] 
Ujaval Gandhi
Spatial Thoughts
mobile: +91-8095684687
email: uja...@spatialthoughts.com
[image: LinkedIn icon]   [image:
Twitter icon] 



On Tue, May 18, 2021 at 4:35 AM Delaz J  wrote:

> Hi Dario,
>
> Could you try with 'Colore' and not "Colore" (pay attention to the simple
> vs double quotes)?
>
> Regards,
>
> Harrissou
> Le 18/05/2021 à 00:41, Dario C a écrit :
>
>   Hi, thank you for your reply, but I still don't understand how to do...
> sorry
>
> i tried to write this code in colour expression, but I don't understand
> what "value" is in get_feature :
>
> CASE
> When
> get_feature('V_TB_ATTIVITA_PT_NR',"Colore",'N')='N' then color_rgb (0,0,0)
> When
> get_feature('V_TB_ATTIVITA_PT_NR',"Colore",'R')='R' then color_rgb
> (255,0,0)
> END
>
> Consider that I have a virtual field called "Colore" where I have 'N' or
> 'R' in case it is black or red color.
>
> Thank you for your kind availability.
>
> cheers
>
> Il giorno lun 17 mag 2021 alle ore 09:09 Ujaval Gandhi <
> uja...@spatialthoughts.com> ha scritto:
>
>> You can select the layer under 'Plot Parameters' and its attributes will
>> be available in the expression. (see attached screenshot).
>>
>> If you need to get the attribute from another layer, you can use the
>> get_feature() function to get feature from another layer by specifying the
>> layer name.
>> [image: Logo] 
>> Ujaval Gandhi
>> Spatial Thoughts
>> mobile: +91-8095684687
>> email: uja...@spatialthoughts.com
>> [image: LinkedIn icon]   
>> [image:
>> Twitter icon] 
>>
>>
>>
>>
>> On Mon, May 17, 2021 at 2:47 AM Dario  wrote:
>>
>>> Hi,
>>>
>>> I should get some data from a specific field of a specific layer but I’m
>>> stuck.
>>>
>>> I’m using “Data Ploty” plug-in and I’d like to customise the colour of
>>> the chart using expression.
>>> As I’m working on layout I can’t see any field into expression menu, so
>>> I need to call a specific layer and then the field.
>>> I’d like to write something like that but, of course, selecting the
>>> correct layer:
>>>
>>> CASE
>>> WHEN "Civici" = 'Neri' THEN color_rgb(0,0,0)
>>> ELSE color_rgb (255,0,0)
>>> END
>>>
>>>
>>> Thank you in advance.
>>>
>>> Cheers
>>>
>>> _
>>> ___
>>> 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 listqgis-u...@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 mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] how to synchronize the qgis point layer with the source tables

[Danny]

I have the nexts questions:

I have 5 tables from phpmyadmin webpage synchronize with qgis. If i update
the attributes table in webpage or qgis it syncs. I used the 5 tables for
create the point layer.

My problem is that one time created the point layer based in this 5 tables,
When I update the dates directly in the layer point is not synchronize with
the 5 tables.

Either If one time created the point layer, if I modify the 5 source
tables, the data of the point layer is not modified and another time i need
to create the point layer for update it.

So , exist any option for activate the synchronize?
___
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] Slooooow spatial joins

[Nyall Dawson]

On Tue, 18 May 2021 at 11:59, Ryan Peel  wrote:
>
> I have tried using MMQGIS plugin, refFunctions geomwith function and the 
> aggregate function.  I am using 3.18 QGIS
>
> Despite having spatial indexes on both tables, when I try to use any of these 
> operations to assign the value of a field in the polygon layer to one in the 
> point layer, it goes very slow.  Like, ridiculously slow and of no value.  
> And, I only have 600 records in the points layer and just a few thousand 
> records in the polygon layer.
>
> What can I do to speed this up?

The absolute fastest way to join is to use the Processing tool: Join
Attributes by Location -- no plugins necessary :D

Nyall
___
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] Slooooow spatial joins

[Ryan Peel]

I have tried using MMQGIS plugin, refFunctions geomwith function and the
aggregate function.  I am using 3.18 QGIS

Despite having spatial indexes on both tables, when I try to use any of
these operations to assign the value of a field in the polygon layer to one
in the point layer, it goes very slow.  Like, ridiculously slow and of no
value.  And, I only have 600 records in the points layer and just a few
thousand records in the polygon layer.

What can I do to speed this up?

-- 

Sincerely,
Ryan
___
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 data from a specific layer

[Delaz J]

Hi Dario,

Could you try with 'Colore' and not "Colore" (pay attention to the 
simple vs double quotes)?


Regards,

Harrissou

Le 18/05/2021 à 00:41, Dario C a écrit :
  Hi, thank you for your reply, but I still don't understand how to 
do... sorry


i tried to write this code in colour expression, but I don't 
understand what "value" is in get_feature :


CASE
When
get_feature('V_TB_ATTIVITA_PT_NR',"Colore",'N')='N' then color_rgb (0,0,0)
When
get_feature('V_TB_ATTIVITA_PT_NR',"Colore",'R')='R' then color_rgb 
(255,0,0)

END

Consider that I have a virtual field called "Colore" where I have 'N' 
or 'R' in case it is black or red color.


Thank you for your kind availability.

cheers

Il giorno lun 17 mag 2021 alle ore 09:09 Ujaval Gandhi 
mailto:uja...@spatialthoughts.com>> ha 
scritto:


You can select the layer under 'Plot Parameters' and its
attributes will be available in the expression. (see attached
screenshot).

If you need to get the attribute from another layer, you can use
the get_feature() function to get feature from another layer by
specifying the layer name.
Logo    
Ujaval Gandhi
Spatial Thoughts
mobile: +91-8095684687
email: uja...@spatialthoughts.com 
LinkedIn icon 
Twitter icon 





On Mon, May 17, 2021 at 2:47 AM Dario mailto:dario9...@gmail.com>> wrote:

Hi,

I should get some data from a specific field of a specific
layer but I’m stuck.

I’m using “Data Ploty” plug-in and I’d like to customise the
colour of the chart using expression.
As I’m working on layout I can’t see any field into expression
menu, so I need to call a specific layer and then the field.
I’d like to write something like that but, of course,
selecting the correct layer:

CASE
WHEN "Civici" = 'Neri' THEN color_rgb(0,0,0)
ELSE color_rgb (255,0,0)
END


Thank you in advance.

Cheers

_
___
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 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 data from a specific layer

[Dario C]

  Hi, thank you for your reply, but I still don't understand how to do...
sorry

i tried to write this code in colour expression, but I don't understand
what "value" is in get_feature :

CASE
When
get_feature('V_TB_ATTIVITA_PT_NR',"Colore",'N')='N' then color_rgb (0,0,0)
When
get_feature('V_TB_ATTIVITA_PT_NR',"Colore",'R')='R' then color_rgb (255,0,0)
END

Consider that I have a virtual field called "Colore" where I have 'N' or
'R' in case it is black or red color.

Thank you for your kind availability.

cheers

Il giorno lun 17 mag 2021 alle ore 09:09 Ujaval Gandhi <
uja...@spatialthoughts.com> ha scritto:

> You can select the layer under 'Plot Parameters' and its attributes will
> be available in the expression. (see attached screenshot).
>
> If you need to get the attribute from another layer, you can use the
> get_feature() function to get feature from another layer by specifying the
> layer name.
> [image: Logo] 
> Ujaval Gandhi
> Spatial Thoughts
> mobile: +91-8095684687
> email: uja...@spatialthoughts.com
> [image: LinkedIn icon]   [image:
> Twitter icon] 
>
>
>
> On Mon, May 17, 2021 at 2:47 AM Dario  wrote:
>
>> Hi,
>>
>> I should get some data from a specific field of a specific layer but I’m
>> stuck.
>>
>> I’m using “Data Ploty” plug-in and I’d like to customise the colour of
>> the chart using expression.
>> As I’m working on layout I can’t see any field into expression menu, so I
>> need to call a specific layer and then the field.
>> I’d like to write something like that but, of course, selecting the
>> correct layer:
>>
>> CASE
>> WHEN "Civici" = 'Neri' THEN color_rgb(0,0,0)
>> ELSE color_rgb (255,0,0)
>> END
>>
>>
>> Thank you in advance.
>>
>> Cheers
>>
>> _
>> ___
>> 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] Model Designer - Updating Field in Place

[Kirk Schmidt]

Hi Ryan;

Yes, you would run a selection on then table first, apply the updates 
and save. If you require interactive selection criteria, you can use a 
number or string in input in your model. The user will then define them 
when it is run.  Look under the vector selection Algorithms for select 
and/or extract functions in the process modeler



Kirk Schmidt

On 5/17/2021 11:27 AM, ryanpeel wrote:

Perfect!  It worked!

And would you know how to set up model designer to have the model input to
choose only selected rows versus whole table?



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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


--
Kirk Schmidt, MScF, BScF, RPF
General Manager
Nortek Resource Solutions Inc.
RR # 1
Thorburn, NS
B0K 1W0
Tel (902) 922.3607
Email: k...@nortekresources.com
Web: www.nortekresources.com

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

Re: [Qgis-user] Model Designer - Updating Field in Place

[ryanpeel]

Perfect!  It worked!

And would you know how to set up model designer to have the model input to
choose only selected rows versus whole table?



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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] Model Designer - Updating Field in Place

[Kirk Schmidt]

Hi Ryan;

There is a network plugin which may solve your issue.

see 
https://gis.stackexchange.com/questions/279650/processing-modeler-to-update-table


Kirk Schmidt

On 5/17/2021 10:50 AM, Ryan Peel wrote:

Hello,

I have created a new Model in Model Designer and I'm using a Point 
Layer as Input and a Field Calculator that calls a custom function.  I 
would like the output/result of the field calculator to update an 
existing field in the attribute table.


I cannot get this to work.  I can only get it to output a new 
temporary scratch table.


Is my idea possible?

--

Sincerely,
Ryan

___
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


--
Kirk Schmidt, MScF, BScF, RPF
General Manager
Nortek Resource Solutions Inc.
RR # 1
Thorburn, NS
B0K 1W0
Tel (902) 922.3607
Email: k...@nortekresources.com
Web: www.nortekresources.com

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

[Qgis-user] Model Designer - Updating Field in Place

[Ryan Peel]

Hello,

I have created a new Model in Model Designer and I'm using a Point Layer as
Input and a Field Calculator that calls a custom function.  I would like
the output/result of the field calculator to update an existing field in
the attribute table.

I cannot get this to work.  I can only get it to output a new temporary
scratch table.

Is my idea possible?

-- 

Sincerely,
Ryan
___
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] How to select a polygon feature underneath another in the same ArcGIS REST feature layer.

[Michael Dufty]

I just tried the right click in 3.18 and it does exactly what I wanted 
perfectly.  It allows to choose which feature to select or to select all.
It didn’t seem to be working for me previously, but I have the LTR installed as 
well and may have accidentally been using that.

Would still love to know if there is any possibility of operations that trigger 
prolonged indexing of web layers having a cancel option or warning.

Michael Dufty

From: Karl Magnus Jönsson 
Sent: Monday, 17 May 2021 2:43 PM
To: Michael Dufty ; qgis-user 

Subject: SV: How to select a polygon feature underneath another in the same 
ArcGIS REST feature layer.

Hi!
How does the new feature (3.18), right click with the select tool to get an 
menu, work with this data?
https://www.qgis.org/en/site/forusers/visualchangelog318/index.html#feature-select-features-context-menu

Karl-Magnus Jönsson

Från: Qgis-user  För Michael Dufty
Skickat: den 14 maj 2021 09:01
Till: qgis-user 
Ämne: [Qgis-user] How to select a polygon feature underneath another in the 
same ArcGIS REST feature layer.

Does anyone know the best way to select a feature entirely underneath another 
in an ArcGIS REST feature layer.
The standard select tool seems to only select one feature, is there a setting 
to let is select all?
Freehand select actually seemed to work well to get both features, which was 
enough for my purpose.
Radius select initiated an indexing of the whole layer which freezes QGIS for 
about 15 minutes (huge layer).

Related question is there any way to cancel these indexing operations?  Turning 
on snap with such a layer active causes the same issue.

Michael Dufty
Senior Environmental Engineer

[cid:image001.jpg@01D74B41.62E8A450]
MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
e:   mdu...@mbsenvironmental.com.au
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>
Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

___
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