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.
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
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.
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:
Screenshot of the ATTRIBUTE data:
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.
Here is a screenshot of the result:
Add the tabular data “TreeSampleChippawaATTRIBUTES_CSV.csv"
Read each entry carefully to match the OBJECTID field for each data set. See image below:
Open the attribute table for the point feature layer and scroll across (if necessary) to see the newly joined attributes.
More information about Joins & Relates can be found here.