Skip to Main Content

ArcGIS

ArcGIS Pro: Joining

ArcGIS Pro: Joining

This brief tutorial will walk you through a popular workflow that facilitates joining a table of attributes with points on a map using ArcGIS Pro.

Setup Instructions

In preparation for this tutorial, you will need an organizational account with Esri. If you are a Brock user, you will sign into the software using your Brock credentials. The steps below will describe the workflow.

Download these CSV data files:
TreeSampleChippawaCOORDINATES_CSV.csv
TreeSampleChippawaATTRIBUTES_CSV.csv

The Scenario

We will be mapping tree sample data for the neighbourhood of Bridgewater near Niagara Falls and Chippawa. Tree data is often collected with GPS units that capture Geographic Coordinates. Unlike the previous exercise that required street addresses, this activity will plot the X,Y data then join detailed attributes. Sometimes it is easier to collaborate on a field project by having one person record the attributes such as diameter at breast height, tree species and health, while another person captures the GPS coordinates. Although this example uses point data, the same general steps would apply to boundary files such as census tracts or municipal boundaries and associated tabular data.

Displaying X,Y Data in ArcGIS Pro

Open the Comma-separated values (CSV) files to see the tabular data before beginning this tutorial. Notice that each table includes an OBJECTID field. First, we will display the X,Y data found in TreeSampleChippawaCOORDINATES_CSV.csv and then the attribute data will be joined with the geospatial data using ArcGIS technologies.

Screenshot of the COORDINATE data:

table showing coordinate data latitude longitude

Screenshot of the ATTRIBUTE data:

table of attribute data representing trees

  1. Run ArcGIS Pro and sign in to Your ArcGIS Organization’s URL brock.maps.arcgis.com > Brock University (authenticate using Brock credentials).
  2. From the Map tab, click Add Data.
  3. Add the .xlsx worksheet that includes coordinate details. If prompted to update drivers, try saving the xlsx file as a comma separated values (CSV) file first. The table appears under Standalone tables.

screenshot of the Drawing Order

  1. Right click the table and select Display X,Y data image of display xy data
  2. Confirm that the X coordinate is matched to Longitude and the Y coordinate is matched to Latitude.

NOTE: The default coordinate system works for our data but you will need to be sure the coordinates you are using match the appropriate coordinate system. Contact maplib@brocku.ca for assistance.

screenshot of Display X,Y data dialogue box

Here is a screenshot of the result:

resulting map of display x, y workflow

 

Joining 

  1. From the Map tab, click image of Add Data button.

  2. Add the tabular data  “TreeSampleChippawaATTRIBUTES_CSV.csv"

Contents listing showing CSV added to layers

  1. From the Contents list, right click the point feature layer and select Joins & Relates > Add Join.

  2. Read each entry carefully to match the OBJECTID field for each data set. See image below:

Add Join dialogue box

  1. Click Validate Join to make sure the settings work as expected. Make any necessary changes.
  2. Click OK to run the tool.

  3. Open the attribute table for the point feature layer and scroll across (if necessary) to see the newly joined attributes.

Resulting table showing joined attributes

More information about Joins & Relates can be found here.