Timeline for Getting WHERE statement to work in v.generalize?
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13, 2018 at 22:22 | history | edited | PolyGeo♦ | CC BY-SA 4.0 |
edited title
|
| Nov 13, 2018 at 16:40 | vote | accept | Bastien | ||
| Nov 13, 2018 at 16:10 | answer | added | Bastien | timeline score: 2 | |
| Nov 12, 2018 at 13:41 | comment | added | Bastien |
Yes, I tried it with another shape and I get the same problem (example shape from R library(sf) could be created in R with: st_read(system.file("gpkg/nc.gpkg", package="sf"), quiet = TRUE) %>% mutate(CNTY = as.numeric(CNTY_<median(CNTY_))) %>% select(CNTY) %>% st_transform(st_crs(2264)) %>% st_write("d:/temp/NC_test.shp"). With a threshold of 10000 and a WHERE of CNTY<1 you get the same behaviour. Guess I should open an issue?
|
|
| Nov 9, 2018 at 8:34 | comment | added | MaxPlank | I reproduced the issue on GRASS with your layer, tried a few things but didn't work. QGis seems out of cause yes, did you try with other layers/settings or is it definitely a GRASS issue ? | |
| Nov 8, 2018 at 18:00 | history | tweeted | twitter.com/StackGIS/status/1060592791208771585 | ||
| Nov 8, 2018 at 15:04 | comment | added | Bastien |
Just did. In this case it's real, but I got other ones in my different tests (character, interger64, etc.). I also tried more complex queries (SUBSTR(FSALDU,2,1)==’0’, SUBSTRING(FSALDU,2,1)=’0’, etc.)
|
|
| Nov 8, 2018 at 15:00 | history | edited | Bastien | CC BY-SA 4.0 |
added 56 characters in body
|
| Nov 8, 2018 at 14:55 | comment | added | Vince |
Please Edit the question to specify the data type of the urban field. I note that you did not list the valid SQL varchar delimiter -- single-quote -- in your examples (urban = '0')
|
|
| Nov 8, 2018 at 14:43 | history | asked | Bastien | CC BY-SA 4.0 |