Joining data between related attribute tables using Arcmap 10.2

In our previous post, we did this process using QGIS and we hope you have started practicing. From the feedback, some commentators requested for sample data to be able to also follow the processes. We have provided sample data on our resources page so you can go there and download the files. Overview Joining attribute data between related tables. Note that the two attribute tables should share a relationship with each other, there must be an identical field. Task Our task today is to join the attributes from building repair survey table to the point feature-places on the map. We have two sets of data. Our point feature file on the map called places.shp and our building repair survey results on table in csv format. Note that ArcMap loads table data in csv and tab delimited text formats. Procedure 1. Let us have a look at our data. The places layer is represented as red dots on the map while the building repair survey is a table. You can see them in the table of contents. Screenshot 2015-04-24 14.01.30 2. Let us inspect the attribute tables we intend to join. Right Click the places layer>open attribute table. You will notice there is not much data to go by. Take note of the Id field. 2 3. Right click on the building repair table >open attribute table. You will notice it has a field called ID too. You will notice all the other data captured during the survey.  4. To execute the join, right click on the places layer>Join and Relates>Join 4 5. A Join Data dialog box will open up. Make sure you select the identical fields on both tables to base the Join on. 5 6. To inspect the Join, Right click on places layer in the table of contents>open attribute table. Notice both tables are joined now. The original places attribute table is to the left.  Hope you are already practicing. Don’t forget to get your sample data from the resources page

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s