Hello,
I will ask again… because no one contact me, after I write a message or one has not send a solution for the questions still today.
Here again the questions, I hope someone is interested:
Create two questions as xlsform as template/question to import this at kobotoolbox server to a project:
1a. In the form should be at first a question (1. question = listfield), through which the Waypointnumbers (called „Messsstelle“ in the csv „messstellentable“) can be selected from the attached csv table. After select one „Messsstelle“, additional values of the csv table will displayed as fields in the form.
1b. Second question, a „geopoint map question“ (openstreetmap) should display all the waypoints of the Waypoints from the attached csv table „messstellentable“ and the current location of the user.
Example: …//forum.getodk.org/t/ability-to-load-locations-into-the-geowidget-to-guide-data-collection/27406/36
For both questions „list question“ and the „geopoint map questions“ the„Messsstelle“/Waypoints stored/linked in the csv „messstellentable“. So the user can select the waypoint using the marker on the geopoint map if the current location is determined via GPS (for example the WP next of the current location, or alternative, if there is no GPS signal and the location cannot be determined, then the current location must be selected using the „list question“ from the CSV WP table. After selecting the WP location, the following next fields of this block displays some values/information from the WP CSV table out of the coulumns. This should displayed in additional fields (notes) (Columns Headlines are „Gewässername“, „Messstellenbezeichnung“, „Rechtswert“, „Hochwert“, „Gewässerart“, „Teilkomponenten“, „Diatomeen-FG-Typ“, „Makrophytentyp“, „Phytobenthostyp“, „LAWA-FG Typ“, „Bundesland“, „Auftraggeber“, „Bemerkungen“ with pulldata function of the selected Waypoint „Messstelle“).
Alternatively the user can also input a text/number in the Listfield „Messstelle“ for a new Waypoint that is not stored at the csv table.
After select a Waypoint the user will fill out the complete form to the end and save it.
2. Create a question as a xlsform, to import this at kobotoobox: To pull / share some values of the selected Waypoint “Messstelle” (see 1a and 1b) in the form. A CSV WP table is attached to a form/project and stored in the Collect app, with Waypoints, see above. The values of the field “Messstelle” as „name“ “Gewässername”, “Messstellenbezeichnung” as „description“ with the „coordinates“ should be shared or pulled to a navigation app (OSMAND, Organicmaops or Locusmaps) (as GPX or KML format) that the Waypoint will open in one of this Apps, to navigate to the Waypoint. See similar discussion here for geopoint2kml: …//community.kobotoolbox.org/t/extract-the-altitude-of-a-gps-point/25846
or the
wayfindig xlsform here: …forum.getodk.org/t/trying-out-the-wayfinding-feature/39167
I can not attach some files at the moment here as a new user…but I can send it if someone contact me…
Attached material:
I attached you a table „ImportHeader_Text_in_Hochkomma_comma_separeted.odt“. That table show the Column names of
- yellow = a column that identify the waypoint in a project (in the CSV table for a project)
-green = the values of this columns should displayed at the first page/beginning of the form after I select one Waypoint (= Column “Messstelle”) over a listselect field or geomap, where the waypoints of the csv are shown. - blue = after I select I will fill out the form for this waypoint (I think the most of this questions I can create my self, only If I need some specific solution I will ask you to implement it possible…
CSV Table with Waypoints: „messstellentable.csv“
It is in UTF Unicode (UTF-8), separated with commata and fields with “”.
XLSFormExample: A example survey with questions
Questions are not clear for me:
A. What Format must the coordinate stored at the messstellentable.csv to dispay the waypoints at the survey/form as markers? Do I have to convert coordinates from UTM/GaußKrüger format to a specific format for ODK(Kobotoolbox Collect App? Or can be used this to convert?:
Thanks
Maggi
