How to take your map data to other GIS software

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.

Downloading data as shapefiles/geoJSONs:

  1.  Go to the Analyze section and choose the Map responses tab.

  2. Select the layers you want to download by adding them as analysis layers. You can also set up filters; in that case only the markings that meet the filter conditions will be included in the download.

    shapefiledownload.png

  3. You can find the download buttons under the Export tab. There are two ways you can choose to download shapefiles and GeoJSONs:

    All layers in one file

    This will create one folder (shapefile) or file (GeoJSON) which includes all the layers you want to download (please note that different types of markings, e.g. points and polygons, will always be in separate files). 

    One file per layer

    This creates separate folders/files for each layer.

    shapefile_download.png

Attribute table data

  • elemId = Element ID: Each question has a unique identifier called an element ID. You can find it by going to Edit mode in the survey, and navigating to the Data name tab in the question element's settings
  • responId = Respondent ID: the unique ID of the respondent
  • respNumb = Response number: If the respondent has placed several responses to this question, this number tells the order of the response
  • 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.

Taking map data to a GIS programme as a text layer:

Please note that these instructions use QGIS as an example.

  1. Go to the results Excel spreadsheet and to the tab with the map question that you want to take to a GIS programme. Copy the information in that tab to another Excel worksheet. Save the new worksheet as in the CSV (comma-separated values) format. 

  2. Open QGIS and choose Add delimited text from the tool panel. 

    qgis_set.png

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

    Note! QGIS can only read the first tab from an Excel file so if you have data on multiple tabs you need to export the data to a separate sheet. 
  4. qgis_settings.png

    If you scroll down to the sample window, the data presented there should now look like an Excel sheet. Click Add to finish importing WKT.

    sample.png

  5. Finally, click Add to finish importing WKT.

In QGIS you can further edit, analyse, and visualize the data as you wish. You can, for example, filter the test questionnaire’s results by routes that respondents use for leisure (in cycling data “for leisure” = true). Please note that if you want to export responses to multiple different map questions to QGIS, you need to repeat this process for each tab in the Maptionnaire results sheet.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.