| 00:42:55 | CIA-10: | neteler * r31654 /grass/trunk/db/drivers/sqlite/describe.c: case order fixed ( cosmetics ); docs added |
| 00:42:56 | sigq: | grassfeed: Changeset [31654]: case order fixed ( cosmetics ); docs added <https://trac.osgeo.org/grass/changeset/31654> |
| 00:43:09 | CIA-10: | neteler * r31655 /grass/branches/develbranch_6/db/drivers/sqlite/describe.c: case order fixed ( cosmetics ); docs added ( merge from trunk ) |
| 00:43:40 | CIA-10: | neteler * r31656 /grass/branches/releasebranch_6_3/db/drivers/sqlite/describe.c: case order fixed ( cosmetics ); docs added ( merge from trunk ) |
| 00:44:31 | sigq: | grassfeed: Changeset [31656]: case order fixed ( cosmetics ); docs added ( merge from trunk ) <https://trac.osgeo.org/grass/changeset/31656> || Changeset [31655]: case order fixed ( cosmetics ); docs added ( merge from trunk ) <https://trac.osgeo.org/grass/changeset/31655> |
| 00:50:13 | CIA-10: | neteler * r31657 /grass/trunk/db/drivers/sqlite/fetch.c: docs added |
| 00:50:24 | CIA-10: | neteler * r31658 /grass/branches/develbranch_6/db/drivers/sqlite/fetch.c: docs added ( merge from trunk ) |
| 00:51:55 | sigq: | grassfeed: Changeset [31658]: docs added ( merge from trunk ) <https://trac.osgeo.org/grass/changeset/31658> || Changeset [31657]: docs added <https://trac.osgeo.org/grass/changeset/31657> |
| 02:40:11 | Manel: | hi |
| 02:40:47 | Manel: | someone has experience with SQL queries? |
| 02:41:04 | Manel: | on sqlite |
| 02:43:47 | : | <_wolf_> sure |
| 02:43:54 | : | <_wolf_> what is your problem Manel |
| 02:44:22 | Manel: | ah, hi, sorry |
| 02:44:53 | Manel: | well, i have this query |
| 02:45:24 | Manel: | db.select glines1 sql="select count( glines1.cat ) from glines1,gr1sel where glines1.cat=gr1sel.cat" |
| 02:45:37 | Manel: | this one works well |
| 02:45:52 | Manel: | but with this update |
| 02:46:22 | Manel: | echo "UPDATE glines1 SET common=1 WHERE( SELECT glines1.cat FROM glines1,gr1sel WHERE ( gli nes1.cat=gr1sel.cat ) )" | db.execute |
| 02:47:02 | Manel: | i get for all 1 for "common" field |
| 02:47:14 | : | <_wolf_> hmm |
| 02:53:32 | : | <_wolf_> I'm not so sure SQlite supports subselcts in UPDATE, but I can be wrong |
| 02:55:07 | : | <_wolf_> let me try something.. |
| 03:05:27 | Manel: | echo "UPDATE glines1 SET common=1 WHERE glines1.cat in ( select cat from gr1sel )" | db.execute |
| 03:05:40 | Manel: | that is the solution : ) |
| 03:06:02 | Manel: | thaks for the support |
| 03:08:28 | : | <_wolf_> actually your expression had an error |
| 03:09:38 | : | <_wolf_> echo "UPDATE glines1 SET common=1 WHERE ( glines1.cat in SELECT glines1.cat FROM glines1,gr1sel WHERE ( gli nes1.cat=gr1sel.cat ) )" | db.execute |
| 03:10:12 | : | <_wolf_> I suppose you made a new table with gr1sel which contained the common cats? |
| 03:10:36 | : | <_wolf_> but your sollution is shorter ; ) |
| 03:10:40 | Manel: | yes |
| 10:44:28 | RMatev: | _wolf_, hi |
| 10:44:39 | : | <_wolf_> hi RMatev |
| 10:45:01 | RMatev: | do you want to try out v.parallel2 |
| 10:45:25 | : | <_wolf_> sure! |
| 10:45:31 | RMatev: | I've commited to svn |
| 10:45:48 | : | <_wolf_> I'll try it right away! |
| 10:47:27 | RMatev: | the parameters are : v.parallel2 input= output= dista=DOUBLE distb=DOUBLE angle=DOUBLE side=right|left [-r] [-l] |
| 10:47:45 | RMatev: | dista is distance along major axis |
| 10:47:59 | RMatev: | distb is distance along minor axis |
| 10:48:16 | RMatev: | angle is angle of major axis and Ox+ |
| 10:48:38 | RMatev: | side is obvious |
| 10:49:12 | RMatev: | dista, distb should be possitive, though I forgot to put a restraint |
| 10:50:04 | RMatev: | -r is for round corners ( without -r outside corners are sharp ) - this has no effect yet |
| 10:50:42 | RMatev: | -l is for "leave loops". Currently loops are always leaved, -l has no effect |
| 10:51:36 | RMatev: | I'll most probably implement -l and -r functionality tomorrow |
| 10:59:14 | RMatev: | there are problems ( unwanted behavior ) with very short ( compared to dist ) segments in begining and end of lines. You can see that yourself. If we want to use the same function for buffer creation, I should modify this behavior |
| 10:59:38 | RMatev: | and we do want to use it : ) |
| 10:59:53 | RMatev: | that'll be the following thing I'll do |
| 11:01:20 | RMatev: | I expect to finish working on parallel lines in the end of this week |
| 11:01:49 | RMatev: | and hope that few bugs arise : ) |
| 11:04:56 | : | <_wolf_> I se what you mean by problematic |
| 11:05:27 | : | <_wolf_> do you know what causes this? |
| 11:11:50 | : | <_wolf_> also it is annoying to be forced to have to type buffer distance twice |
| 11:24:25 | RMatev: | _wolf_, yes I know. I'll fix it |
| 11:24:38 | : | <_wolf_> : ) |
| 11:25:07 | RMatev: | yes it's annoying, could you propose a nicer way to give params? |
| 11:45:20 | : | <_wolf_> how about having distance, and minordistance, with distance being mandatory, and if minordist is not given then both major and minor get the same values of distance. If minordist is given it is used for the minor axis |
| 11:51:20 | RMatev: | yep, that's cook |
| 11:51:22 | RMatev: | *cool |
| 12:01:31 | : | <_wolf_> : ) |
| 13:54:47 | CIA-10: | neteler * r31659 /grass/trunk/raster/r.in.xyz/ ( local_proto.h main.c ): added zscale parameter |
| 13:55:03 | CIA-10: | neteler * r31660 /grass/branches/develbranch_6/raster/r.in.xyz/ ( local_proto.h main.c ): added zscale parameter ( merge from trunk ) |
| 13:56:32 | sigq: | grassfeed: Changeset [31660]: added zscale parameter ( merge from trunk ) <https://trac.osgeo.org/grass/changeset/31660> || Changeset [31659]: added zscale parameter <https://trac.osgeo.org/grass/changeset/31659> |
| 20:06:57 | sigq: | grassfeed: Ticket #105 ( enhancement closed ): r.in.xyz: zscale parameter addition patch <https://trac.osgeo.org/grass/ticket/105#comment:5> |
| 21:03:14 | sigq: | grassfeed: Ticket #105 ( enhancement reopened ): r.in.xyz: zscale parameter addition patch <https://trac.osgeo.org/grass/ticket/105#comment:6> |
| 21:16:42 | CIA-11: | neteler * r31661 /grass/branches/develbranch_6/raster/r.in.arc/description.html: document optional nodata_value ( merge from trunk ) |
| 21:16:45 | sigq: | grassfeed: Changeset [31661]: document optional nodata_value ( merge from trunk ) <https://trac.osgeo.org/grass/changeset/31661> |
| 21:17:05 | CIA-11: | neteler * r31662 /grass/trunk/raster/r.in.arc/description.html: document optional nodata_value |
| 21:19:17 | sigq: | grassfeed: Changeset [31662]: document optional nodata_value <https://trac.osgeo.org/grass/changeset/31662> |
| 22:09:31 | CIA-11: | neteler * r31663 /grass/branches/develbranch_6/ ( 4 files in 3 dirs ): Add skewness, kurtosis to lib/stats and r.series ( merge from trunk ) |
| 22:11:27 | sigq: | grassfeed: Changeset [31663]: Add skewness, kurtosis to lib/stats and r.series ( merge from trunk ) <https://trac.osgeo.org/grass/changeset/31663> |
| 22:14:02 | CIA-11: | neteler * r31664 /grass/branches/develbranch_6/lib/Makefile: fix -jX race condition ( merge from trunk ) |
| 22:15:29 | sigq: | grassfeed: Changeset [31664]: fix -jX race condition ( merge from trunk ) <https://trac.osgeo.org/grass/changeset/31664> |