Eyes in the Sky II > GIT Web Course > Module 2 > Week 7 > Intro to Mapping Tabular Data in GIS > Intro to Mapping Tabular Data in ArcGIS

Week 7: Investigating Global Earthquake Activity

top of page

Intro to Mapping Tabular Data in ArcGIS

In the first few weeks of this module you have used GIS to explore many types of shapefiles. Whether looking at city populations, river drainage areas or invasive species counts per county, we have provided you this data. This week we will start to add point data from longitude and latitude documents. GIS can easily draw this data as a point feature once imported into a GIS from a table of data. With this technique in your skill "toolkit" you can easily add data from thousands of sources, or even create your own data with a GPS unit.

top of page

Download Geographic Data About Earthquakes

top of page

Explore a Table of Data

Think about the last time you collected a set of data. You probably set up a data table with headers indicating the data you wanted to collect, including the units that would be collected. The rows of that table were set up to hold the data for each individual record or event that you planned to collect. As you made observations, you filled in the data table with whatever observations you made of each event. The table was probably organized sequentially, with the first row being the earliest event and so on.

After the experiment was concluded you used this data table to begin the analysis of your results. Maybe you graphed the data or looked for patterns or clusters of data. You may have used a spreadsheet program to analyze this data, especially if you were doing a more complex analysis.

Examine the excerpt of a table of numbers and other information pictured below. This table shows earthquakes that occurred in 2009. The data table is similar to other attribute tables that you have been working with so far in this course.

1 Table Image

Thought Question: What are the advantages and disadvantages of working with data in a tabular format?

What is absent in exclusively tabular data is the opportunity to easily inquire about spatial relationships. Fortunately, many Earth and environmental science datasets available today include some sort of geospatial reference. When the spatial data, or Longitude/Latitude data, (also called X, Y data), are included alongside other information, it is possible to place that data onto a map and see it in a richer, more complete environment.

The classic example of a map illuminating the answer to a complex problem was John Snow's pump handle and cholera incidence map. Can you think of other patterns that are more easily understood with a map than a list or table of data?

GIS software can convert any table, or delimited list of information, into a GIS map if coordinate data (Longitude and Latitude) are included with it. This week you will learn how to import and save these kinds of data into a native GIS format.

top of page

Launch ArcGIS and Open the Earthquakes Project

Shortcut1
2 Launch ArcGIS




top of page

Review How Longitude and Latitude Appear on the Map

Move the cursor across the map to remind yourself how the X and Y coordinates relate to Longitude and Latitude. Start at the far left side of the map and move your cursor horizontally to the right all the way across the map. The X and Y coordinates are shown in the lower left corner of the map. Notice how the X coordinates show changes in longitude. Move your cursor vertically from the bottom to the top of the map. Notice how the Y coordinates show changes in latitude.

Cartesian Coordinate System Map showing XY (longitude, latitude) coordinates.

top of page

Put Tabular Data on the Map

top of page

Add Earthquake data from 2009

To map the 2009 earthquake events using Longitude and Latitude coordinate, select Tools > Add XY Data. The Add XY Data window opens. Navigate to the file named 2009EQ.csv. (c:/eyesinthesky2/week7/EarthquakeAM/csv_files). Select Longitude for the X Field and Latitude for the Y Field. The options in the Add XY Data window are as follows:

  1. Select Tools > Add XY Data.
    39 Add XY Pulldown

  2. Click on the Browse button within the Add XY Data window.
    4 Add XY Browse Button
  3. From the Browse button, the Add window will pop up. Navigate to the csv_files folder within the EarthquakeAM data folder.
    5 Add XY Navigate to CSV
  4. Select the file named 2009EQ.csv. Click Add.
    6 Add XY Navigate to 2009EQ
  5. In the Add XY Data window define which column in the data base contains the coordinates.
    • Select X field: Longitude
    • Select Y field: Latitude
    • Click the OK button. The Table Does Not Have Object ID window will pop up. Click OK.
      8 Table does Not Have Object ID
    • The 2009EQ.csv file will add to your Table of Contents and be called 2009EQ.csv Events. Accept the symbolization that is automatically selected by the program. The colors are randomly selected and may differ from your own symbol colors.
    • Click OK.

The 2009 Earthquakes will now be displayed on the map.

21 Map with XY EQ

Note: If you miss-assigned the X and Y fields, the data will look strange, perhaps in a straight line, or as a single dot or in the wrong part of the world. Just right click and delete the new layer then repeat the steps above. The most common problem is switching the Latitude and Longitude (i.e.Latitude as X and Longitude as your Y fields).

You can see with your mouse that the X coordinate changes moving from one longitude line to another on the map and the Y coordinate changes as you move between lines of latitude.

At the end of this lesson you will export a corresponding shapefile to the XY layer in the Table of Contents. After you create a shapefile of your XY data, the computer will ask if you want to add it to the project. Alternatively you can click the Add Data button and look for the shapefile of the same name as the original table in the Earthquakes CSV file folder

For the 2009 Earthquake data, you will find a file called 2009EQ.shp, that has a .shp extension.

Movie Icon

Click on the movie to start playing.

loading the player

top of page

Classify and Symbolize the 2009 Earthquake Data

Once the earthquake data is on the map, it is possible to Classify and Symbolize it.

top of page

Classify the 2009 Earthquakes by Magnitude

To open the Properties window for the 2009 earthquakes layer, right-click the 2009EQ Event layer in the Table of Contents. Choose Properties from the menu. Then select the following options:


  • In the Properties window make the appropriate selections outlined above.
    12 Symbolize Graduated Symbols
  • This map shows 2009 earthquakes classified by magnitude.
    13 Symbols Graduated

Movie Icon

Click on the movie to start playing.

loading the player

top of page

Classify the 2009 Earthquakes by Depth

To open the Properties window for the 2009 earthquakes layer, right-click the 2009EQ Event label in the Table of Contents. Choose Properties from the menu. Then select the following options:

Movie Icon

Click on the movie to start playing.

loading the player

  • The options for classifying 2009 earthquakes by depth are selected in the Properties window. To change the symbols to circles without borders, click on Properties for All Symbols
    14 Properties for All Symbols
  • In the Properties for All Symbols select Circle1 and Size 4. Click OK.
    15 Symbol Selector Circle1
  • Adjust the number of classes then click on the Classify button. You can adjust intervals manually by either dragging the break lines or re-typing the values in the box on the right. Click OK.
    18 Classification Window Manual Breaks
  • Click on the Yellow to Green color ramp.
    19 Properties Window Yellow to Blue
  • This map shows 2009 earthquakes classified by depth.
    20 Map Yellow to Blue

top of page

Convert XY Data to Shapefile


To get full functionality from your XY points, it is necessary to convert your XY point (event) layers to shapefiles. It is a simple two step process.

top of page

Explore other classification and symbolization options


Try symbolizing the data by Month, or change from Manual classification to Equal Interval to Quantiles. When you are done, close the Properties window.
top of page

Choose Another Tabular Dataset to Add to Your Map

Navigate to the csv_files folder and select another file to add to your map.

These files were downloaded from various Internet sites. To learn more about the datasets, click on the show me below or on the .txt files included with the csv_files. These datasets represent a range of interests and are not intended to all magically fit together into one coherent story.

Below is a list of the data available to choose from in the folder:
  1. 2010 Earthquakes - (2010_quakes.csv)
  2. Groundwater monitoring sites - (GW Monitor Sites.csv)
  3. GW temperature - (GW_temperature.csv)
  4. Journey North Hummingbird Migration Patterns - (Journey North HB 20093.csv)
  5. Significant and Big Historical Earthquakes - (sig_big.csv)
  6. Tornado Touchdowns in the United States 1950 -2008 - (tornado touchdowns.csv)
  7. US Thermal Springs - (US Thermal Springs.csv)
  8. World Glaciers - (World Glaciers.csv)
This PDF file has more details about each dataset. about_csv_files.pdf (Acrobat (PDF) 48kB Mar25 10)

Double click on your selection. Repeat the steps above to bring the data into ArcGIS using Add XY Data.

Look for the Latitude and Longitude headers in the data table to assign coordinates to the attributes.

Note: The Latitude and Longitude Fields may be named slightly differently in each case. Also, some of these files are large and may take a few moments to draw on your map. Be patient.
For example:
  • Latitude may be also be labeled - LAT, Lat83, or lat.
  • Longitude may be also be labeled - LONG, or Long83 or long.
Learning to decode the headers in an attribute table is an important skill in becoming independent in the use of data and while there are some conventions for naming data, there remain a large variety of nuances.

If at first you don't succeed, try again!

Once the data is projected on the map, Classify and Symbolize the dataset that you have added to you map.

top of page

Explore More If You Have Time


PLACE HOLDER MOVIES top of page

Movies on this Page

top of page

How to download movies

top of page

Flash Video Versions

Download these versions to play on your computer. You'll need an appropriate movie player to view the file, such as Flash Player, Real Player (Mac / Win), or Adobe Media Player.

Movie Icon Adding XY Data in ArcGIS

Movie Icon [link http://serc.carleton.edu/details/files/21281.html Classifying Earthquakes by Magnitude' new ]

Movie Icon Classifying Earthquakes by Depth in ArcGIS

top of page

iPod Versions

Download these version to play on your iPod or iPhone.

Movie Icon Adding XY Data in ArcGIS

Movie Icon Classifying Earthquakes by Magnitude in ArcGIS

Movie Icon Classifying Earthquakes by Depth in ArcGIS


« Previous Page      Next Page »