Export full map response data (geojson, shp, text)

1. Go to Export > Download data. 

   

2. Choose either GeoJSON or Shapefile as the download format. 

   

   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 your cursor over the i symbols for examples of each. For example, if you had a Choose one question for favorite color, 'compact' would show the responses listed in one column in the attributes, whereas 'extended' would add a column for each response option and whether it was (1) or was not (0) chosen.

   

5. The Publication date drop-down can usually be left as it is (it generates a new entry each time a survey is republished, including in test publication stage – this way you could download results per publication version.). 

   

6. Decide if you want all survey questions to appear as attributes in the map layers, or just the questions that were added to the map question pop-up as follow-up questions.
7. Simplified attribute names removes any special characters (e.g. ä,ö,å) so that the map layer can be imported to legacy GIS software without issues.
8. Click Download responses as GeoJSON [or shapefile]. 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.