Re: [Qgis-user] Counting of bridges on road.

2022-08-03 Per discussione Stefan Giese (WhereGroup) via Qgis-user

Hi Paul,

try: count("bridge", filter:="bridge"='T' AND is_selected())

best regards

Stefan

Am 04.08.2022 um 07:01 schrieb Paul N via Qgis-user:

Hi,
I have road layer and segment the road where bridge exist by a field 
'bridge' =T in road layer.


I am able to count number of bridges using
count("bridge", filter:="bridge"='T').

How to count the number of bridges on selected roads?

Any clue?

Regards
Paul

___
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


--
Mit freundlichen Grüßen
Stefan Giese
Projektleiter/Consultant
-
Aufwind durch Wissen!
Jetzt neu: Web-Seminare und Online-Schulungen
bei der www.foss-academy.com
-
WhereGroup GmbH
Schwimmbadstr. 2
79100 Freiburg
Germany

Tel.: +49 (0)761 / 519 102 - 61
Fax: +49 (0)761 / 519 102 - 11

stefan.gi...@wheregroup.com
www.wheregroup.com
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885

___
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] Counting of bridges on road.

2022-08-03 Per discussione Paul N via Qgis-user
Hi,
I have road layer and segment the road where bridge exist by a field
'bridge' =T in road layer.

I am able to count number of bridges using
count("bridge", filter:="bridge"='T').

How to count the number of bridges on selected roads?

Any clue?

Regards
Paul
___
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-it-user] Unione punti tramite GID e file csv

2022-08-03 Per discussione Giorgio Montese
Buonasera a tutti,
Vorrei sapere se è possibile in qgis unire con un segmento coppie di punti
avendo a disposizione uno shape in cui ogni punto ha un GID e un file csv
che contiene le coppie di punti da unire GID_a e GID_b;
Ogni punto GID_a può essere collegato a diversi punti GID_b (ma non
viceversa)

Ad esempio:
il GID 001 deve collegarsi a 101,102,103
Il GID 002 deve collegarsi a 103,104,106,107,108,109,110
Il GID 003 deve collegarsi a 111,112
Il GID 004 deve collegarsi a 113

(solo che un gid é qualcosa tipo 2784932498734)

Utilizzo ancora il qgis 2.18.11 ma se necessario posso passare a versioni
più recenti
Ringrazio tutti per la disponibilità

Cordiali saluti
Giorgio
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


Re: [Qgis-user] Keypress event and slowless

2022-08-03 Per discussione Andrea Giudiceandrea via Qgis-user

*Jésahel Benoist*
/Wed Aug 3 04:33:23 PDT 2022/

maybe
to be able to know what events are triggered to try to correct this,
because it could be a plugin or a calculated field or anything.


Hi Jésahel,
have you tried if the issue occurs also using a new QGIS user profile 
without any external plugin installed?


Best regards.

Andrea Giudiceandrea___
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] Keypress event and slowless

2022-08-03 Per discussione Sebastian Gutwein via Qgis-user
I have been experiencing the same problem. It seems to occur when there are
a lot of elements in the map. Very painful experience. And I agree that it
seems like it shouldn't need to be calculating while you are typing.

On Wed, Aug 3, 2022 at 7:33 AM Jésahel Benoist via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi,
>
> On Windows/QGIS 3.16/QGIS 3.22 LTR, am I the only one having noticed some
> annoying slowness in big projects when typing ? It happens especially in
> layout when changing a legend element name or in the attribute table.
>
> What is really annoying is that each keypress seems to trigger some heavy
> calculation. I think it should only happen when exiting the field, or maybe
> to be able to know what events are triggered to try to correct this,
> because it could be a plugin or a calculated field or anything.
>
> Regards,
>
> Jésahel
> ___
> 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
>


-- 
___
Sebastian "Bas* " Gutwein
*rhymes with Josh

Regenerative Design Group
1 Chevalier Ave
Greenfield, Ma 01301
Web: regenerativedesigngroup.com
(631) 241-1018

*Look close, think big, make change. *
___
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-it-user] Query lente in postgis su tabella puntuale

2022-08-03 Per discussione Amedeo Fadini
Ciao a tutti,
ho un problema con qgis server che finora ha funzionato benone:

appena accendiamo il server e iniziano le chiamate wms (che arrivano da
mapproxy in locale) la cpu viene saturata da query di questo tipo

 SELECT count(distinct ("id","campo2"))=count(("id","campo2")) FROM
"public"."nometabella" WHERE st_srid("geometry")=4326 AND
upper(geometrytype("geometry")) IN
('POINT','POINTZ','POINTM','POINTZM','MULTIPOINT','MULTIPOINTZ','MULTIPOINTM','MULTIPOINTZM')

che dopo un attesa interminabile risponde semplicemente  TRUE,
nometabella ha circa 1,7 milioni di righe con geometria POINT ed è
partizionata in 102 tabelle figlie. postgres 12 postgis 3.2 sembra che
cerchi se le geometrie sono coerenti tra le tabelle partizionate...

Pare che ad ogni processo fastcgi venga rilanciata,,, avete idea del perché
e se ci sono configurazioni di postgis o di QGIS che possono evitare di
ripetere così spesso questo check?

Amefad
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user


[Qgis-user] Keypress event and slowless

2022-08-03 Per discussione Jésahel Benoist via Qgis-user
Hi,

On Windows/QGIS 3.16/QGIS 3.22 LTR, am I the only one having noticed some
annoying slowness in big projects when typing ? It happens especially in
layout when changing a legend element name or in the attribute table.

What is really annoying is that each keypress seems to trigger some heavy
calculation. I think it should only happen when exiting the field, or maybe
to be able to know what events are triggered to try to correct this,
because it could be a plugin or a calculated field or anything.

Regards,

Jésahel
___
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