Thanks to @Xiphware explanations here :
(or "More Fun with Repeat Groups!" )
Background
Converting ODK's geoshape , geotrace and/or geopoint results into a more widely supported GIS format, eg KML , gets asked a lot on the Forum [a quick search for "KML" returns 125 hits!]. Unfortunately, there are no native XForm tools to perform such conversions in an ODK form, so typically you have to export submissions and perform some post-processing to convert these geo-spatial properties before importing your data into a GIS tool…
I had a test to handle cases when geo strings contains '; ' as separator instead of the only semicolon.
This problem occurs sometimes and @davidbaines faced it here :
Hello ODK Forum,
Attached is some data recently collected through ODK forms and stored on ONA. We collected data from 56 sites in Mali, including recording their perimeters with GPS. The “Map” functionality of ONA shows the location of these sites, except for 14 of the sites – where the location is unclear.
Please see the excel attachment called: ODK_Forum_Mali_Data_GPS_Question
Please see the worksheet called: “group_survey_group_gps_geopoint”.
In Column L called “_parent_index” (highlighte…
In such cases, point can be considered as a space-separated list of values with one more space and one more column index.
geoshape2wkt.xls (8 KB)
1 Like