Hi @dohji ,
you should take a look at this discussion and this showcase. You will find a function to transform ODK geom to postgis geometry and a show case to transform ODK geo fields to WKT
Good evening everybody,
I would like to suggest some improvement of the spatial data storage.
Actually, geopoint are stored into 4 attributes (longitude, latitude, elevation and accuracy), Geotrace and geoshape are stored in a text field. The format of that string is not so simple. The use of Well Known Text format could be a great enhancement. All the databases supported by odk do understand that GIS format. https://fr.wikipedia.org/wiki/Well-known_text
Actually we have to create some fun sq…
And
After kml export by @Xiphware and geojson export by @detrygeoffroy , I simply adapted @Xiphware example forms to generate wkt (point, linestring, polygon) from geopoint, geotrace and geoshape odk fields.
In opposition to geojson and kml, WKT does only describes the geometry, it does not contains any attribute value.
[odk_to_wkt]
So you can collect data and open exported CSV within QGIS with "delimited text layer" tool, choose the column which store wkt, select the projection (4326) and show y…
When you'll get a chance, please take some time to Introduce yourself here! - #1132 by lamo_jimmy
