Re: [GRASS-user] Reclassify a vector adding a column

2020-06-18 Thread Markus Neteler
On Thu, Jun 18, 2020 at 12:29 PM Margherita Di Leo wrote: ... >> This worked! Thank you so much! I have one last question. Does it also >> support an IS LIKE condition, and if yes, how can I express it? It does - this is also documented to some extent here (please add more examples):

Re: [GRASS-user] Reclassify a vector adding a column

2020-06-18 Thread Margherita Di Leo
Super! Thank you both! On Wed, Jun 17, 2020 at 9:12 PM Micha Silver wrote: > > On 17/06/2020 19:38, Margherita Di Leo wrote: > > Dear Micha, > > On Wed, Jun 17, 2020 at 4:05 PM Micha Silver wrote: > >> >> On 17/06/2020 16:14, Margherita Di Leo wrote: >> >> Ciao Stefan, >> >> thank you, I tried

Re: [GRASS-user] Reclassify a vector adding a column

2020-06-17 Thread Stefan Blumentrath
LIKE 'M%' THEN 'Wide' WHEN TYPE LIKE 'Loc%' THEN 'Narrow' ELSE 'Unknown' END;" Cheers Stefan From: grass-user On Behalf Of Margherita Di Leo Sent: onsdag 17. juni 2020 18:39 To: Micha Silver Cc: GRASS user list Subject: Re: [GRASS-user] Reclassify a vector adding a column Dear Micha, O

Re: [GRASS-user] Reclassify a vector adding a column

2020-06-17 Thread Margherita Di Leo
Dear Micha, On Wed, Jun 17, 2020 at 4:05 PM Micha Silver wrote: > > On 17/06/2020 16:14, Margherita Di Leo wrote: > > Ciao Stefan, > > thank you, I tried and it didn't give me any error but didn't update the > column either... > > > > The sqlite CASE statement should be: > > CASE WHEN '' THEN

Re: [GRASS-user] Reclassify a vector adding a column

2020-06-17 Thread Margherita Di Leo
> > P.S.: I did not alidate the SQL syntax, but it should be roughly along > those lines… > > > > *From:* grass-user *On Behalf Of > *Margherita > Di Leo > *Sent:* onsdag 17. juni 2020 10:35 > *To:* GRASS user list > *Subject:* [GRASS-user] Reclassify a vect

Re: [GRASS-user] Reclassify a vector adding a column

2020-06-17 Thread Stefan Blumentrath
be roughly along those lines… From: grass-user On Behalf Of Margherita Di Leo Sent: onsdag 17. juni 2020 10:35 To: GRASS user list Subject: [GRASS-user] Reclassify a vector adding a column Hi, I need to reclassify a vector in the following way: based on a column of type string I have to create a

Re: [GRASS-user] Reclassify a vector adding a column

2020-06-17 Thread Zoltan Szecsei
Hi Margherita, I offer my suggestion below as someone who uses varied (and any) product needed to get a job done quickly and correctly. If you are able to open your vector dataset in QGIS (by simply dragging and dropping it into the 'Layer' panel), then take a look at the "Field Calculator"

[GRASS-user] Reclassify a vector adding a column

2020-06-17 Thread Margherita Di Leo
Hi, I need to reclassify a vector in the following way: based on a column of type string I have to create a new column of type string based on certain rules that I give upon the first column, and I thought it would be really handy if I could do it like CASE WHEN... THEN ... I have tried to feed