Learn how to configure the Community Data Aggregation solution to meet specific needs in your organization.
Set up data aggregation project
Before you begin aggregating data, create an ArcGIS Pro project, install the Data Assistant add-in, and add the Data Assistant ribbon to the project so you can access the tools and features of the add-in.
Data Assistant add-in
The Data Assistant add-in includes a series of tools that have been optimized for migrating data from a source dataset to a target dataset that may have a different data structure. It includes a series of predefined methods to automatically populate attributes when migrating data to the target dataset. For example, one method concatenates multiple source fields into a single target field. Other methods help you extract the left or right characters from a field or split a single source field into multiple target fields.
To use the Data Assistant add-in, you must install the Data Assistant add-in on each ArcGIS Pro machine that will be used to migrate data from a source dataset to one or more target datasets.
To install the Data Assistant add-in, complete the following steps:
- Deploy the Community Data Aggregation solution.
- Browse to the Content section of your ArcGIS organization.
- Click the DataAssistant item to open the item details page and click the Download button to download the add-in.
- Extract the DataAssistant .zip file.
- Close any open or running ArcGIS applications.
- Using Windows Explorer, browse to the DataAssistant folder.
- Double-click DataAssistant.esriAddInX to run the installer.
- Click the Install add-In button.
Data aggregation project
You can use an ArcGIS Pro project and the Data Assistant add-in to migrate community datasets from one or more source datasets to a target dataset.
To create a data aggregation project, complete the following steps:
- In ArcGIS Pro, click Add Data and browse to the My Content folder in the active portal. Select the CommunityAddresses or CommunityParcels layer that deployed with the solution.
- Click Add Data and browse to your source data. Add your source data to the map.
- Click the Data Assistant ribbon. Ensure that the Data Assistant add-in loaded and is accessible in ArcGIS Pro.
- Save the data aggregation project.
Data mapping
The Configure Data Mapping dialog box allows you to configure settings in a selected source-target configuration file.
File panel
The Data Assistant file properties define the active source-target configuration file and allow you to further configure the source dataset, target dataset, and replace settings.
| Property | Description |
|---|---|
Source-Target Configuration File | The active source-target configuration file for Data Mapping. |
Source Layer | The path to the source layer for the active configuration file. |
Replace By Field Value | When enabled, defines the selection query for the target layer that will be used when the Replace Data tool is executed. |
Target Layer | The path to the target layer for the active configuration file. |
Fields panel
The Data Assistant field methods define the actions to occur when migrating data from a source dataset to a target dataset. You can use them to populate new values in the target dataset or perform more advanced field mapping that may be necessary when the target dataset has a different data structure.
You can configure the following Data Assistant methods in your data migration project:
| Method | Description |
|---|---|
Copy | Copy source field values to target fields. |
Default Value | Sets a default value for a field. |
Value Map | Set target values based on source value. |
Change Case | Change the case of the source text string. |
Concatenate | Concatenate source values into a string. |
Left | Extract a number of characters from the left. |
Right | Extract a number of characters from the right. |
Substring | Extract a set of characters from a string. |
Split | Split a string into parts and use one part. |
Conditional Value | Construct an if/else statement. |
Domain Map | Load and map domains values. |
Data Assistant settings
You configure the following settings for Data Assistant.
Match library
When updated, the Data Assistant Match Library will assist with automatically creating field mappings based on configuration files you create.
| Setting | Description |
|---|---|
Update Match Library | The Match Library will be updated to include the settings in the currently selected source-target configuration file. |
Clear Match Library | All saved settings in the Match Library will be erased. |