There are two ways in which you can export data from Maptionnaire to a GIS programme: you can download the data as shapefiles or geoJSONs from the analysis tool, and you can add it to these programmes as a CSV file/text layer that you've copied from the Excel results file.
-
Go to the Analyze section and choose the Map responses tab.
-
Click the eye symbol on the left-side panel. The map responses should become visible on the map. If you want to download responses to all map questions, repeat this step for each question.
You can use filters and download only the responses that meet those conditions, but you cannot export any style (e.g. color) changes you make to the responses.
-
Go to the Export tab. Select geoJSON or shapefile as the file type.
-
Choose the format:
All layers in one file
All map responses will be in one file. The only exception is the shapefile in the case where responses contain different geometry types (e.g. points and lines), as a shapefile can only have a single geometry type.
One file per layer
This creates separate folders/files for each map question.
- Choose whether the attributes of the file should include all responses to all questions in the questionnaire or just the map responses+linked pop-up question responses. Choosing to include all responses makes it easier to later analyze and filter response data in other GIS programs.
- Click Download. The file(s) should be downloaded to your computer.
Attributes
- elemId = Element ID: Each question has a unique identifier called an element ID.
- responId = Respondent ID: the unique ID of the respondent, which stays the same through the questionnaire.
- respNumb = Response number: If the respondent has made several responses to this question, this number tell you the order in which they were made.
- The following columns show responses to any pop-up questions you may have asked in relation to this map question. Their heading depends on the question.
- If you included their responses to all other questions in the questionnaire, those are shown in the latter columns. For a help on how to read them, please see this article.
Please note that these instructions use QGIS as an example.
-
Download the results Excel file. Each map question has its own tab with responses and coordinates related to that question. To take responses to a map question to QGIS, you need to first copy the data from the Excel. Paste it to a new Excel spreadsheet. When saving the new file, choose CSV (comma-separated values) as its format.
-
Open QGIS (or any other GIS programme). Choose Add delimited text from the tool panel.
-
Choose Custom delimiters as the file format and check Semicolon from the list. Choose WKT as the Geometry definition and define geometry field as ‘wkt’ if you are using data from Maptionnaire results spreadsheet. Choose the geometry type (point, line, polygon) from the drop-down list.
-
Scroll down to the sample window in the menu. The data presented there should now look like an Excel sheet.
-
Finally, click Add to finish importing WKT.
If you are using ArcGIS or other ESRI GIS tools, you can use the third coordinate column instead of WKT. It shows the coordinates in latitude and longitude. Use the Text to columns function in Excel to separate them into two columns.