Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Joining data

From: Up and Running with ArcGIS

Video: Joining data

ArcGIS makes it easy to bring additional data All of the attributes that are currently in our county shape file, came from Okay, let's go ahead and close the Layer Properties here.

Joining data

ArcGIS makes it easy to bring additional data into your mapping projects through the use of joins. By joining data together, you can take advantage of attributes and geometries that you already have, and have the flexibility of adding additional information on the fly. There are two types of joins that we can use. First, we can join spreadsheet data to our GIS data layers through a common attribute field. If the same name is in both tables, then we can match them up to bring across the additional fields. The other way is to join data by their location, where we can take advantage of the geography portion of our geographic information system, and attach attributes based on the features that fall inside of other features.

Let's take a look at both options. I'm going to first start with our counties here. I'm going to right-click on it. And explore the attribute table. All of the attributes that are currently in our county shape file, came from the U.S. Census, so it has lots of population information and other types of statistics. Let's go ahead and close the attribute table. I'm going to open up the catalog window over here on the right. I'm going to go into the data files folder and inside of the Washington State file. Also we have an Excel file that includes 2012 election results. Now, I can expand the Excel file to see the individual worksheets that are within that Excel file.

I'm going to click this 2012 results, and drag it, and drop it back over here on my table of contents to add that new data table to my ArcMap project. Now I can join the 2012 election results to my county file through the use of a join. To do that, I'll right-click on Counties, I'll go to Joins and Relates, and I'll say Join. Here I have a couple of options on how I want to join this data. I can join, based off of a spacial location, or the option that we want to join by attributes from a table. Here we're going to choose the field in this layer, that the join will be based on.

This it the common field that will appear in both tables. I'm going to choose the name field and we're going to match that to the 2012 election results based off the county field in that table. We'll go ahead and say OK to run the join and now when when I explore the attributes for our counties. Go back into the attribute table and scroll all the way to the end. You'll notice that we have some additional columns here that are Democratic votes, Republican votes, the percentage of Democratic votes, the percentage of Republican votes, and the Democrat margin percent, and the overall winner of the election.

Now we can use these attributes as part of a symbology. Let's go ahead and close the attribute table. I'll double click on county. In the Symbology tab of the layer properties, I'm going to click on Quantities here. The value field is going to be at the very bottom, the Democrat margin percent. So this is the margin of percentage of Democratic votes. Here we can see that the range is from negative 45%, in which case the Democrat lost, to positive 40%, in which case the Democrat won. Now typically, Democrats are symbolized by a blue color and Republicans are symbolized by a red color.

So we can see our symbol wrap is going the wrong direction. I'm going to go ahead and click on the symbol and say Flip Symbol Colors, here. And if you need to choose a different symbol wrap, use this color wrap drop down list here to choose one from the list. Now I've got it set up correctly, where red is the Republican winner and blue is the Democratic winner. I can say Apply to apply that to the map. And here we can see the differences between the eastern half of Washington and the western half of Washington. Counties that are highlighted in blue are strongly Democratic counties. And counties that are in red are strongly Republican counties. Counties that are in this green color are slightly Democratic.

Counties that are in orange are slightly Republican. And counties that are yellow are evenly split between the two parties. Okay, let's go ahead and close the Layer Properties here. And I'm going to turn off the counties and take a look at the next one. Here I'm going to go back to my catalog, and I'm going to load in the fish net file that we created in the last movie. I'll just drag and drop to add it to the map. That adds the fish net grid in the background here. Let's also go ahead and turn off the state boundary, and we'll leave the dairies and the fish net open. Now I want to join the dairy points to the fish net grid, so I can get a count of how many points fall in each ten meter grid.

In the fish net grid, I'm going to right-click, and go to Joins and Relates>Join. This time I'm going to choose to join the data from another layer, based off of spatial location. It's going to ask me which data layer I want to join, and I'm going to choose the dairy option, and I'm going to go ahead and down at the very bottom, choose where I want to save an output file. I'll click the Browse button and we can go ahead and save it into our working folder here, and I'll just call it Join_Output. And I'll change the Save As type to a shape file. That will create a new shape file called Join_Output in our working folder that includes the results of this tool.

Now go ahead and say Save and OK. After the tool runs, we get a new fish net grid added to the map called Join_Output here at the top. And if I right click on it and go down to Properties. We can explore it's symbology by going to Quantities. The value is going to be a count. This is the count of how many dairies fell in each location. And again, we'll choose an appropriate ramp and we'll say apply. And we'll get a heat map effect that shows me where high concentrations of dairies occur within Washington state. Now, if I want additional context, let me go ahead and close the Layer Properties, I can turn on my Washington boundary.

I'll switch my Table of Contents to list by drawing order. And I will drag the Washington boundary up to the very top, and we'll create a hollow fill. Here with no color, so I can see the outline of Washington state on top of the fishnet grid. And maybe I'll change the outline color too, while I'm here. There we go. So data is always being updated and edited, and sometimes you just want to map something that doesn't come with any spatial information, or sometimes you need a summary of complex data sets, and want to see the bigger patterns of what's going on. By using the two join methods, either join by attributes or join by spatial location, you can make sure that your maps are always up to date without having to permanently modify your GSI data sets every time something changes.

Show transcript

This video is part of

Image for Up and Running with ArcGIS
Up and Running with ArcGIS

36 video lessons · 3189 viewers

Adam Wilbert
Author

 

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Up and Running with ArcGIS.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.