Hi Yes, Windows. Thanks for the information @Andrea and @Jürgen. Perfekt. Bruno
> [email protected] hat am 29.03.2021 13:16 geschrieben: > > > Send Qgis-user mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.osgeo.org/mailman/listinfo/qgis-user > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Qgis-user digest..." > > > Today's Topics: > > 1. Re: Fill-down with QGIS expressions (Alexandre Neto) > 2. Re: Fill-down with QGIS expressions (chris hermansen) > 3. Re: Fill-down with QGIS expressions (David Strip) > 4. qgis with gdal 3.2 ([email protected]) > 5. Re: Fill-down with QGIS expressions (Tot?) > 6. Re: qgis with gdal 3.2 (J?rgen E. Fischer) > 7. Re: qgis with gdal 3.2 (Andrea Giudiceandrea) > 8. Re: Fill-down with QGIS expressions (Andrea Giudiceandrea) > 9. Re: Fill-down with QGIS expressions (Tot?) > 10. Re: Fill-down with QGIS expressions (Tot?) > 11. Not able to add new feature (Pere Art?s - keacoustics) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 28 Mar 2021 21:05:03 +0100 > From: Alexandre Neto <[email protected]> > To: Tot? <[email protected]> > Cc: QGIS User <[email protected]> > Subject: Re: [Qgis-user] Fill-down with QGIS expressions > Message-ID: > <ca+h0g_emdz+4exdm_gexoybyzfelux1dvft8w_ar_xln+zo...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Sorry, > > Can you be more clear? It's not clear to me what you are trying to > accomplish. > > > Alexandre Neto > > A domingo, 28/03/2021, 18:04, Tot? <[email protected]> escreveu: > > > I have a CSV file [0], how to get the "zona_fill" field? > > The "zona_fill" field is the result of the fill-down of the "zona" column. > > > > I could use various tools external to QGIS, but it would be useful to be > > able to do this with field calc expressions; > > > > does anyone have any ideas on how to make it? or would it be a good idea to > > make a function that does the fill-down? > > > > <http://osgeo-org.1560.x6.nabble.com/file/t378656/fill_down.png> > > > > [0] https://gist.github.com/pigreco/2a90c61456a16dcbf2e49e872c6b9dfa > > > > > > > > ----- > > https://pigrecoinfinito.com/ > > -- > > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html > > _______________________________________________ > > Qgis-user mailing list > > [email protected] > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210328/1eec6b5d/attachment-0001.html> > > ------------------------------ > > Message: 2 > Date: Sun, 28 Mar 2021 13:35:28 -0700 > From: chris hermansen <[email protected]> > To: Tot? <[email protected]> > Cc: qgis-user <[email protected]> > Subject: Re: [Qgis-user] Fill-down with QGIS expressions > Message-ID: > <cacc2_6_xwakjsn1orzdyn6je2xaphoayspsba4k2grysqug...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Tot? and list, > > On Sun, Mar 28, 2021 at 10:04 AM Tot? <[email protected]> wrote: > > > I have a CSV file [0], how to get the "zona_fill" field? > > The "zona_fill" field is the result of the fill-down of the "zona" column. > > > > Seems to me you are trying to calculate "zona" to "zona_fill". If that's > the case, you need to > > 1. check the box next to "Update existing field" (top right of field > calculator screen) > 2. select the destination field (in your case, "zona") (just below the > "update existing field") > 3. in the Expression tab below, there is a window on the left for > entering the source expression; here you want to enter "zona_fill" > including the double quotes > 4. then press OK. > > If you only want to set the empty "zona" fields, you can either use a more > refined expression involving IF or you can select the records where "zona" > is NULL or empty (two single quotes together). If the "zona" field is a > fixed field you may have to apply trim() to it to determine whether it is > empty. > > If I've misunderstood you, you'll need to provide more details. > > > -- > Chris Hermansen ? clhermansen "at" gmail "dot" com > > C'est ma fa?on de parler. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210328/b694d48e/attachment-0001.html> > > ------------------------------ > > Message: 3 > Date: Sun, 28 Mar 2021 14:36:07 -0600 > From: David Strip <[email protected]> > To: Alexandre Neto <[email protected]>, Tot? > <[email protected]> > Cc: QGIS User <[email protected]> > Subject: Re: [Qgis-user] Fill-down with QGIS expressions > Message-ID: <[email protected]> > Content-Type: text/plain; charset="us-ascii" > > An HTML attachment was scrubbed... > URL: > <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210328/b6668ee5/attachment-0001.html> > > ------------------------------ > > Message: 4 > Date: Sun, 28 Mar 2021 23:14:48 +0200 (CEST) > From: [email protected] > To: "[email protected]" <[email protected]> > Subject: [Qgis-user] qgis with gdal 3.2 > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > Hi everybody > > QGIS 3.16 and 3.18 are currently both shipped with gdal 3.1.4. When will gdal > 3.2 be available in qgis? I'm looking forward to the new filegeodatabase > index ability. > > Thank you! > Greetings > Bruno > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210328/2f1ce120/attachment-0001.html> > > ------------------------------ > > Message: 5 > Date: Sun, 28 Mar 2021 14:34:10 -0700 (MST) > From: Tot? <[email protected]> > To: [email protected] > Subject: Re: [Qgis-user] Fill-down with QGIS expressions > Message-ID: <[email protected]> > Content-Type: text/plain; charset=us-ascii > > Alexandre Neto wrote > > Sorry, > > > > Can you be more clear? It's not clear to me what you are trying to > > accomplish. > > how to repeat the first non-null value down so that all cells are populated? > this operation is called fill-down and in SQL I can get it like this: > > select b.data, b.rowid, > b.zona, b.nuts2, > (select a.zona > from fill_down_es as a > where a.rowid <= b.rowid > and > a.zona <> 'NULL' > order by rowid desc limit 1 ) as zona_fill2 > from fill_down_es as b > > I'm looking for a way to do this with QGIS expressions. > > <http://osgeo-org.1560.x6.nabble.com/file/t378656/fill_down2.png> > > > > ----- > https://pigrecoinfinito.com/ > -- > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html > > > ------------------------------ > > Message: 6 > Date: Sun, 28 Mar 2021 23:34:24 +0200 > From: J?rgen E. Fischer <[email protected]> > To: [email protected] > Subject: Re: [Qgis-user] qgis with gdal 3.2 > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > Hi Bruno, > > On Sun, 28. Mar 2021 at 23:14:48 +0200, [email protected] wrote: > > QGIS 3.16 and 3.18 are currently both shipped with gdal 3.1.4. When will > > gdal > > 3.2 be available in qgis? I'm looking forward to the new filegeodatabase > > index ability. > > You probably are referring to Windows. Try osgeo4w testing[0]. > > > 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 https://www.norbit.de > QGIS release manager (PSC) Germany IRC: jef on FreeNode > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: signature.asc > Type: application/pgp-signature > Size: 827 bytes > Desc: not available > URL: > <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210328/3c7c08b3/attachment-0001.sig> > > ------------------------------ > > Message: 7 > Date: Sun, 28 Mar 2021 14:38:13 -0700 (MST) > From: Andrea Giudiceandrea <[email protected]> > To: [email protected] > Subject: Re: [Qgis-user] qgis with gdal 3.2 > Message-ID: <[email protected]> > Content-Type: text/plain; charset=us-ascii > > brunos wrote > > QGIS 3.16 and 3.18 are currently both shipped with gdal 3.1.4. When will > > gdal 3.2 be available in qgis? > > Hi Bruno, > what operative system are you using? > > The new OSGeo4W testing installer of QGIS for MS Windows already ships GDAL > 3.2.2. > > Please see https://qgis.org/en/site/forusers/download.html and > http://osgeo-org.1560.x6.nabble.com/QGIS-3-18-0-and-QGIS-3-14-4-LTR-packages-released-and-OSGeo4W-reboot-td5458001.html > for more info. > > Best regards. > > Andrea > > > > -- > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html > > > ------------------------------ > > Message: 8 > Date: Sun, 28 Mar 2021 14:47:41 -0700 (MST) > From: Andrea Giudiceandrea <[email protected]> > To: [email protected] > Subject: Re: [Qgis-user] Fill-down with QGIS expressions > Message-ID: <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > Tot? wrote > > I have a CSV file [0], how to get the "zona_fill" field? > > The "zona_fill" field is the result of the fill-down of the "zona" column. > > Hi Salvatore, > > I've imported your csv file, copied the features to a new scratch memory > layer, and created a new field named 'zona_fill2' using the Field Calculator > with the following expression: > > if( "zona" is empty, attribute( get_feature_by_id(@layer, $id -1), > 'zona_fill2') , "zona") > > and it seems to me the above expression populates the "zona_fill2" field in > the same way the "zona_fill1" was populated. > > Best regards. > > Andrea > > > > -- > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html > > > ------------------------------ > > Message: 9 > Date: Sun, 28 Mar 2021 15:32:33 -0700 (MST) > From: Tot? <[email protected]> > To: [email protected] > Subject: Re: [Qgis-user] Fill-down with QGIS expressions > Message-ID: <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > Andrea Giudiceandrea wrote > > Tot? wrote > >> I have a CSV file [0], how to get the "zona_fill" field? > >> The "zona_fill" field is the result of the fill-down of the "zona" > >> column. > > > > Hi Salvatore, > > > > I've imported your csv file, copied the features to a new scratch memory > > layer, and created a new field named 'zona_fill2' using the Field > > Calculator > > with the following expression: > > > > if( "zona" is empty, attribute( get_feature_by_id(@layer, $id -1), > > 'zona_fill2') , "zona") > > Hi Andrea and thank you for your time, > I replicated your expression but I get this: > > <http://osgeo-org.1560.x6.nabble.com/file/t378656/nono.png> > > what am I doing wrong? > > saluti > > > > ----- > https://pigrecoinfinito.com/ > -- > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html > > > ------------------------------ > > Message: 10 > Date: Mon, 29 Mar 2021 00:47:25 -0700 (MST) > From: Tot? <[email protected]> > To: [email protected] > Subject: Re: [Qgis-user] Fill-down with QGIS expressions > Message-ID: <[email protected]> > Content-Type: text/plain; charset=UTF-8 > > Tot? wrote > > what am I doing wrong? > > Hi Andrea, > I finally understood the mistake. > First you need to create the 'zona_fill2' field and then populate it with > the expression: > > if ("zone" is empty, > attribute (get_feature_by_id (@layer, $ id -1), > 'zona_fill2'), "area") > > So the mistake I was making is using a virtual field (maybe it's a bug?) > > <http://osgeo-org.1560.x6.nabble.com/file/t378656/sisi.png> > > thanks > thanks > > > > ----- > https://pigrecoinfinito.com/ > -- > Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html > > > ------------------------------ > > Message: 11 > Date: Mon, 29 Mar 2021 13:09:35 +0200 > From: Pere Art?s - keacoustics <[email protected]> > To: [email protected] > Subject: [Qgis-user] Not able to add new feature > Message-ID: <[email protected]> > Content-Type: text/plain; charset="us-ascii"; Format="flowed" > > Dear all, > > I'm trying to add a feature on my attribute table, just a new one with > some easy calculation from values of the same table. > > But: could not add the new field to the provider appears on my screen. > > I've done all steps but no way. > > I insert an image just trying to assign number 1 to the new feature I > would like to generate > > Thanks, > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210329/3a1481c2/attachment.html> > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: 33123bd1.png > Type: image/png > Size: 61320 bytes > Desc: not available > URL: > <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210329/3a1481c2/attachment.png> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > > ------------------------------ > > End of Qgis-user Digest, Vol 181, Issue 61 > ****************************************** _______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
