-
Go to Export > Download data.
-
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:
-
Select the map questions that you want to include in the download.
-
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.
-
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.).
- 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.
- Simplified attribute names removes any special characters (e.g. ä,ö,å) so that the map layer can be imported to legacy GIS software without issues.
- Click Download responses as GeoJSON [or shapefile]. The files should be downloaded to your computer, one per each map question (layer).
Attributes
- responseNumber = 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.
- respondentId = 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.
Analysis tags in the GeoJSON download
Analysis tags are labels you add to responses in the analysis tool, either by hand or with AI (for example Missing or poorly maintained crosswalks). The GeoJSON download includes all of your tags, both manual and AI-generated. See Tag open responses with AI.
How tags appear
- Each tag is its own attribute. A tagged feature has the value
1. An untagged feature has no value (empty, or NULL in GIS software). - Tags on the map feature, and on the open question in its pop-up (where AI tagging usually happens), are named by the tag alone, for example
Missing or poorly maintained crosswalks. - Tags on other questions are named "question: tag", for example
Is there anything else…: Street lighting. Tags from questions outside the map appear on every map feature of that respondent.
Filter by tag in GIS software
- Tagged:
"Missing or poorly maintained crosswalks" = 1 - Untagged:
"Missing or poorly maintained crosswalks" IS NULL. Using= 0finds nothing.
See which tags a file has
- Text editor: the list
"tags"is at the very end of the file (press Ctrl+End). It shows the exact attribute name of each tag. - QGIS: open Layer Properties > Information and look under Abstract.
- ArcGIS Online: the tag attributes import and filter normally, but the tag list is not shown anywhere. Use the text editor method, or paste the list into the layer's description by hand.
Good to know
- Each downloaded layer file, and each filtered export, lists only the tags it contains.
- Shapefile downloads cut attribute names to 10 characters and have no tag list, so choose GeoJSON when tags matter.
- The Excel export works as before. See Export response data.
Please note that these instructions use QGIS as an example.
- Download the results as a spreadsheet (Excel or xslx).
- 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.
-
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.