I have been exploring ways to circumvent the issue reported here Geotrace/Geoline + Geoshape support, and come up with the idea of generating EWKT (Extended Well Known Text) notation from the pairs of coordinates of a geotrace or area, and, from there, the actual geometries.
My approach would be a simple text concatenation to be executed in excell or GIS software. Something like CONCATENATE(’(‘SRID=4326;LINESTRING(’ || coordinate pairs of geotrace||’)’)’)
The problem is that the coordinate pairs that make up the line are NOT separated by commas as expected by WKT making it very difficult to parse. Examples below:
Kobo Collect: 23.2233 54.2233 23.3344 54.334565 23.44556 54.22345 …
WKT format: 23.2233 54.2233, 23.3344 54.334565, 23.44556 54.22345, …
Is there a reason for this? If not I would suggest to have the coordinate pairs separated by comma because that makes it much easier to spatialize data in GIS environment.