HOW TO

Append data from an existing ArcGIS Survey123 survey to a new survey in ArcGIS Pro

Last Published: May 10, 2022

Summary

In ArcGIS Survey123, data collected from an existing survey may contain feature classes with the related tables and attachments, and can be appended to a new survey with a similar or different schema in ArcGIS Pro. Appending data from an existing survey to a new survey ensures information from the existing survey is not lost when new data are added.

Procedure

Follow the instructions below to append data from an existing ArcGIS Survey123 survey with related tables and attachments to a new survey in ArcGIS Pro.

Import data into the enterprise geodatabase and use the Append geoprocessing tool directly in ArcGIS Pro

Note:
Access to an enterprise geodatabase is required. Refer to ArcGIS Server: Enterprise geodatabases for more information.
  1. Import the survey data into the enterprise geodatabase. Refer to ArcGIS Survey123: Use Survey123 with ArcGIS Enterprise for more information.
  2. In ArcGIS Pro, on the Analysis tab, click Tools in the Geoprocessing group.
  3. In the Geoprocessing pane, search for and select Append (Data Management Tools).
Image of the Append (Data Management Tools) selection
  1. Populate the required fields for Parameters.
Image of the Geoprocessing pane
  1. Click the Environment tab. Check the Maintain Attachments check box for Geodatabase and the Preserve Global IDs check box for Geodatabase Advanced.
Image of the Environment tab
  1. Click Run.

Add new GUID fields and use the Append geoprocessing tool in ArcGIS Pro

Note:
This workflow overwrites the attachment keywords associated with the attachments.

Download the old (A) and new (B) surveys as file geodatabases, and extract the feature classes and associated tables into ArcGIS Pro.

  1. In Survey B, open the attribute table, and click the Add Field icon to add a new GUID field. In this example, the new GUID field is named PreservedGlobalID.
Image of adding a new GUID field in the attribute table of Survey B
  1. In Survey A, open the attribute table, and click the Add Field icon to add a new GUID field. In this example, the new GUID field is named PreservedGlobalID.
Image of adding a new GUID field in the attribute table of Survey A
  1. Right-click the new GUID field, and click Calculate Field.
  2. In the Calculate Field pane, select the old GLOBALID. Click Run.
Image of the Calculate Field pane
  1. On the Analysis tab, click Tools in the Geoprocessing group.
  2. In the Geoprocessing pane, search for and select Append (Data Management Tools).
  3. Populate the required fields for Parameters. In this example, Survey A is selected for Input Datasets and Survey B is selected for Target Dataset.
Image of appending then data from Survey A to Survey B
  1. Click Run. The old global IDs from Survey A are appended to the new GUID field in Survey B.
  2. In the related table of Survey A, add a new GUID field to store the newly generated global IDs for the appended features from Survey A in Survey B. In this example, the new field is named SurveyBGlobalA.
Image of a new GUID field created
  1. In the Contents pane, right-click the related table of Survey A, click Join and Relates, and click Add Join to join the Survey B feature class to the related table of Survey A based on the ParentGlobalID of the related table.
Note:
The Add Join is required to have the global IDs of the related table in Survey A to match the GLOBALID field in Survey B.
  1. Populate the required fields in the Add Join pane. In this example, select SurveyARelatedTable for Input Table, ParentGlobalID for Input Join Field, and Survey B for Join Table. Click OK.
Image of the Add Join pane
  1. In the related table of Survey A, right-click the new GUID field (SurveyBGlobalA), and click Calculate Field.
  2. In the Calculate Field pane, select the new GLOBALID. Click OK. The global IDs in SurveyBGlobalA match the global IDs in the newly appended Survey B.
Image of the Calculate Field pane to calculate the new GUID field
Note:
Remove the join created in Step 10 to avoid confusion in the upcoming steps. As the global IDs of the related table for Survey A now match the global IDs of Survey B, the join is no longer required.
  1. In the related table of Survey A, recalculate the ParentGlobalID field with the new global IDs (SurveyBGlobalA) to match the GlobalIDs of Survey B.
Image of the Calculate Field pane to recalculate the ParentGlobalID field
Note:
Remove the new GUID field (SurveyBGlobalA) to ensure the schema matches the appended data.
  1. In the Geoprocessing pane, search for and select Append (Data Management Tools).
  2. Populate the required fields for Parameters. In this example, the related table of Survey A is selected for Input Datasets, and the related table of Survey B is selected for Target Dataset. Click Run.
Image of appending data from the related table of Survey A to the related table of Survey B
  1. Overwrite the hosted feature layer with the updated data.

Article ID: 000024002

Software:
  • ArcGIS Survey123 Website
  • ArcGIS Pro 2 8 x
  • ArcGIS Pro 2 7 x
  • ArcGIS Pro 2 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options