This tutorial will look at the steps necessary for joining tabular data to geospatial data using ArcGIS Pro and ArcGIS Online.
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.
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:
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.
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 firstname.lastname@example.org for assistance.
Here is a screenshot of the result:
Add the tabular data from the Excel worksheet called “TreeSampleChippawaATTRIBUTES > Sheet1$”. Alternately, add a CSV version of the spreadsheet.
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.
Go to https://arcgis.com and sign in to your ArcGIS Organization using your Brock University credentials.
Click YOUR DEVICE and browse to the file .
Click YOUR DEVICE and browse to the file
Select OBJECTID for both the Target layer and the Join layer.
Scroll down to the Result Layer section and enter a unique output name.
NOTE: you may need to turn off visibility of the original point layer.
More information about Joins & Relates can be found here.
This tutorial is supported by the Brock University Research Lifecycle Department; Map, Data & GIS Library. If you have any questions or concerns regarding this tutorial, don’t hesitate to contact email@example.com