Hi Jukka, This is a very common problem and I already developped a small beantool for that. I could not attach it to the mail, so I copy/paste it here
http://ojwiki.soldin.de/index.php?title=Beanshell:Create_linestring_from_points_with_id_attribute But it would probably deserve a plugin. NB : the beantool uses the natural order of the attribute to sort the points, so that your sequence must be numeric, otherwise, point 11 will come before point 2. Michaël > > > Le 13/09/2016 à 13:32, [email protected] a écrit : >> can you send me a small example dataset? ..ede >> >> On 13.09.2016 13:08, Rahkonen Jukka (MML) wrote: >>> Hi, >>> >>> I play with GPS track points and there are thousands of points. >>> Concatenating attributes does not make sense. Picking attributes >>> from the first point would do, or just drop all the attributes. >>> Converting to multipoint and then into linestring gives a funny >>> result with zig-zagging line that is not usable to anything, if not >>> as a decoration. >>> >>> -Jukka- >>> >>> edgar soldin wrote: >>> >>>> how do you expect the attributes to be concatenated in the >>>> resulting linestring? >>>> did you try joining them to a multipoint and convert that to >>>> linestring? >>>> ..ede >>>> On 13.09.2016 09:45, Rahkonen Jukka (MML) wrote: >>>>> Hi, >>>>> >>>>> I have some point data which I would like to convert into >>>>> linestrings. Points are ordered correctly in the file but they >>>>> have also useful IDs. I don't find a readymade tool for this task >>>>> but I have a feeling that it should not be so hard to do with a >>>>> little beanshell script. This might suit even as an option for the >>>>> Convert Selected Geometries/Layers tool as Points->LineString but >>>>> I know from practice that it is rather uncommon that point layers >>>>> are properly ordered. >>>>> >>>>> This is how I do it with SQL and Spatialite >>>>> select makeline(a.geometry) from >>>>> (select id,geometry from track_points_geometries order by id) a; >>>>> >>>>> -Jukka Rahkonen- >>>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> >>>> >>>> >>>> >>>> >>>> _______________________________________________ >>>> Jump-pilot-devel mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>> >>> ------------------------------------------------------------------------------ >>> >>> >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >>> ------------------------------------------------------------------------------ >>> >>> >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >> ------------------------------------------------------------------------------ >> >> >> _______________________________________________ >> Jump-pilot-devel mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> > ------------------------------------------------------------------------------ _______________________________________________ Jump-pilot-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
