Users can export questionnaire results as GeoJSON (.json) or .xlsx files from the Maptionnaire website easily. For a step-by-step guide, see this article.
-
In Maptionnaire, go to Results to download map responses in the geoJSON (.json) format. Select which map responses you want to download. Each question is downloaded as a separate map layer to your computer.
-
Open an ArcGIS Pro project and click on the Analysis tab.
Look for the Geoprocessing group and click on Tools.
-
Type "JSON To Features" into the search bar and open the tool.
-
The tool requires two parameters: Input JSON file and Output Feature Class name.
When all the parameters are set, click Run at the bottom of the Geoprocessing panel.
-
When the process is complete, the new layer will be automatically added to the map, and the Geoprocessing panel can be closed.
-
Go to Maptionnaire and click on the Download responses as an Excel spreadsheet (.xlsx) button on the Results page.
- After the .xlsx file has been downloaded, open an ArcGIS Pro project and click on the Analysis tab.
-
Click on Tools and search for the tool Excel To Table tool.
-
Set the parameters for the tool:
For Input Excel File, pick the .xlsx file you want to work with.
Set the output file name.
Select the sheet that you want to import.
-
Once parameters are set, click Run. The new table will be automatically added to the Contents panel and is ready to use in analysis.
Generate a point layer from table
If the imported table contains latitude and longitude fields, users can easily create a point feature class from that data.
-
In the Contents panel, right click on the table, select Create Points From Table, and then click on XY Table To Point.
For the Input table, select the table which has latitude and longitude coordinates.
Set a name for the output point feature class.
For the X field parameter select the lon field.
For the Y field parameter select the lat field.
Select the coordinate system of the collected data.
-
When the feature class is done, it will be automatically added to the Contents pane and the points can be seen on the map.