How to take survey 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 map data as shapefiles or 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 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.
Exporting map data as a text layer (CSV)

Please note that these instructions use QGIS as an example.

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

  2. Open QGIS (or any other GIS programme). 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.


    qgis_settings.png

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

    sample.png

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

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

Comments

0 comments

Please sign in to leave a comment.