Export map responses (geojson, shp, text)

1. Go to Results > Download data. 

   

2. Choose either GeoJSON or Shapefile as the type. Please note that that we do NOT recommend downloading the data as a shapefile as it is a much more limited file type than geoJSON. See the following examples of what the data will look like depending on the file type.

   Shapefile download:

   

   The same data downloaded as a GeoJSON:

   

3. Select the map questions that you want to include in the download.

   

4. Choose Extended or Compact download for multiple choice question responses depending on what kind of analysis you'd like to conduct (hover over the icon to see examples of both).

   

5. Click Download. The files should be downloaded to your computer, one per each map question (layer).

Attributes 

• respNumb = Response number: If the respondent has made several responses to this question, this number tells you the order in which they were made. Note! 0=1, 1=2, 2=3, 3=4, etc.
• responId = Respondent ID: the unique ID of the respondent, which stays the same through the questionnaire.
• Submitted = Whether or not the respondent clicked "Submit" at the end of the survey or not. 0 = they did not, 1 = they did
• layerName = The question
• The following columns show the responses this respondent gave in other questions in the same survey.

Please note that these instructions use QGIS as an example.

1. Download the results as a spreadsheet (Excel or xslx).
2. The file contains each map question in its own tab with coordinates. Copy each tab to separate new Excel spreadsheets. Save them in the CSV (comma-separated values) format.

3. Open QGIS (or any other GIS programme). Choose Add delimited text from the tool panel. 

   

4. 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.

   
   

5. Scroll down to the sample window in the menu. The data presented there should now look like an Excel sheet.

   

6. 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.