Re: [Qgis-user] setting graduated symbology for a small postgres point table crashing qgis.
Thanks Andreas done. #54921 On Wed, Oct 11, 2023 at 4:59 PM Andreas Neumann wrote: > Hi Damien, > > Can you submit a bug report please? > > NULL values in the data shouldn't make QGIS freeze. > > Thanks, > Andreas > > On Wed, 11 Oct 2023 at 10:51, damien stephens via QGIS-User < > qgis-user@lists.osgeo.org> wrote: > >> never mind I figured it out. >> the graduated engine does not like null values in the field, so i used a >> calulated field: >> case when field is null then .001 else field end >> >> On Wed, Oct 11, 2023 at 4:41 PM damien stephens < >> damien.steph...@gmail.com> wrote: >> >>> Hi All. >>> I have a point table view with around 50,000 records and 160 fields in >>> postgres which loads into qgis very quickly. >>> the problem comes when i try to assign a graduated symbology. >>> no matter which Mode i use - fixed interval, jenks etc, when i hit the >>> classify button qgis freezes - and had been frozen for around an hour. >>> this has happened with 2 different views. >>> anyone else seen this / have a fix. >>> It could be a stupid mistake on my part as i am new to using Post gres, >>> as trialling it vs the current mssql setup. >>> thanks in advance >>> Damien >>> >>> >>> ___ >> 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 >> > > > -- > > -- > Andreas Neumann > QGIS.ORG board member (treasurer) > ___ 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] Get the translation of a core string in Python
Hi Jürgen That's what I needed. Thank you very much. Michel -Oorspronkelijk bericht- Van: QGIS-User Namens Jürgen E. Fischer via QGIS-User Verzonden: donderdag 5 oktober 2023 18:52 Aan: qgis-user@lists.osgeo.org Onderwerp: Re: [Qgis-user] Get the translation of a core string in Python Moin Michel, On Tue, 03. Oct 2023 at 11:04:26 +, Michel Stuyts via QGIS-User wrote: > In for example the file "qgis_nl.ts" I found the translated value for > "Loading Plugins": You also need to know the context of the translation, ie.: QObject … > > > Loading Plugins > Plug-ins laden > > > But I want to use that translation in a Python plugin. Does anybody know > what the way is to get the translation of a core string using Python? >>> QCoreApplication.translate("QObject", "Loading Plugins") 'Plug-ins laden' 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 Nordenhttps://www.norbit.de QGIS release manager (PSC) Germany IRC: jef on Libera|OFTC ___ 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] setting graduated symbology for a small postgres point table crashing qgis.
Hi Damien, Can you submit a bug report please? NULL values in the data shouldn't make QGIS freeze. Thanks, Andreas On Wed, 11 Oct 2023 at 10:51, damien stephens via QGIS-User < qgis-user@lists.osgeo.org> wrote: > never mind I figured it out. > the graduated engine does not like null values in the field, so i used a > calulated field: > case when field is null then .001 else field end > > On Wed, Oct 11, 2023 at 4:41 PM damien stephens > wrote: > >> Hi All. >> I have a point table view with around 50,000 records and 160 fields in >> postgres which loads into qgis very quickly. >> the problem comes when i try to assign a graduated symbology. >> no matter which Mode i use - fixed interval, jenks etc, when i hit the >> classify button qgis freezes - and had been frozen for around an hour. >> this has happened with 2 different views. >> anyone else seen this / have a fix. >> It could be a stupid mistake on my part as i am new to using Post gres, >> as trialling it vs the current mssql setup. >> thanks in advance >> Damien >> >> >> ___ > 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 > -- -- Andreas Neumann QGIS.ORG board member (treasurer) ___ 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] setting graduated symbology for a small postgres point table crashing qgis.
never mind I figured it out. the graduated engine does not like null values in the field, so i used a calulated field: case when field is null then .001 else field end On Wed, Oct 11, 2023 at 4:41 PM damien stephens wrote: > Hi All. > I have a point table view with around 50,000 records and 160 fields in > postgres which loads into qgis very quickly. > the problem comes when i try to assign a graduated symbology. > no matter which Mode i use - fixed interval, jenks etc, when i hit the > classify button qgis freezes - and had been frozen for around an hour. > this has happened with 2 different views. > anyone else seen this / have a fix. > It could be a stupid mistake on my part as i am new to using Post gres, as > trialling it vs the current mssql setup. > thanks in advance > Damien > > > ___ 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] setting graduated symbology for a small postgres point table crashing qgis.
Hi All. I have a point table view with around 50,000 records and 160 fields in postgres which loads into qgis very quickly. the problem comes when i try to assign a graduated symbology. no matter which Mode i use - fixed interval, jenks etc, when i hit the classify button qgis freezes - and had been frozen for around an hour. this has happened with 2 different views. anyone else seen this / have a fix. It could be a stupid mistake on my part as i am new to using Post gres, as trialling it vs the current mssql setup. thanks in advance Damien ___ 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