Document Sample
Lab2 Powered By Docstoc
					Geography 686                                                        Dr. Mei-Po Kwan
Spring Quarter 2003                                                  Jason VanHorn

                                        Lab 2
GIS Tutorials, Resources, and Techniques: Taking Advantage
                   of the World Wide Web

        This exercise exposes students to online tools and resources that will improve
their ability to learn and operate ESRI GIS software in the future. It is primarily intended
to introduce practical opportunities for learning and working with GIS software and
therefore, increase their independence as GIS users. It is hopeful that this will begin
helping you think of data sources for your quarter project.

Task 1:
Exploring ArcGIS Tutorials on the Web
   1. Go to the following website:

   2. Click on “What is ArcUser Magazine?” and read the magazine‟s description.

       Q1.     How often is a new version of the ArcUser magazine published?

   If you wish, you can subscribe to the publication from this website. It‟s free!!!

   3. Click on the menu item “Current Issue”. (January-March 2004)

   4. Notice that under “Departments” there are links to articles and tutorials for GIS
      users. Some of the tutorials are accompanied by links to sample data, which is
      what we are interested in finding more about.

   5. Click the link „Working with Excel in ArcGIS‟.

       Q2.   According to the article why is it important that a shapefile’s FID and
       Shape columns and a dBASE table’s OID column not be deleted?

  6. Now use an Internet search engine ( is recommended) to find 2
     additional ArcGIS related tutorials which satisfy ALL of the following
     conditions. Try to find something that will help you with your interests in GIS
     and geography or what you think might be interesting for your project.

             a. They should NOT be published by ESRI.
             b. They MUST be immediately available on the web for viewing.
             c. They MUST be more interesting and useful than “Introduction to ArcGIS”
                (or similar).

       If you have questions about what is appropriate, please ask your TA.

       Q3.       What are the TITLES and URL’s of the 2 new tutorials you have found?

       Q4.       Who created or published each of the tutorials?

       Q5.       Explain briefly why you think the 2 tutorials are interesting and how
                 they could be useful for you in the future.

Task 2:
Exploring ESRI’s Technical Knowledge Base
  1.   Go to the following web address:
  2.   Click on “Knowledge Base”
  3.   Click on “Technical Articles”
  4.   Click on “ArcInfo Desktop”

       Q6.       What 2 types of filters are available for browsing the Knowledge Base?

  5. Navigate to ArcMap > Analysis and Tools > Joins and Relates
  6. Apply the “Error” filter

       Q7.       What is the Solution and Workaround for the following error?

             “Loading Table Data. Could not load data from the data source. If you can correct the
             problem, press refresh button to reload data”

  7. Notice also that at the top of the page you got the answer for question 7, there are
     buttons that allow you to email this article to yourself or others.

  8. Return to the previous page and remove the “Error” filter. Then add the “How
     To” filter.

  9. Notice that the “How To” filter can show you for example, how to „Select rows
     with no data values in a joined field using ArcMap‟, for example.

  10. No go to the User Forums, which is one of the tabs at the top of this page. The
     User Forums are also a very valuable tool when working with ArcGIS. Often
     problems you encounter using this software, others have encountered.

  Q8. For the ‘ArcGIS Desktop’ how many different Forums exist what is the title of
  the last Forum that you can post questions to in ArcGIS Desktop ?

Task 3:
Downloading and Mapping Census 2000 TIGER/Line data
      In this section of the lab you will be downloading Census TIGER/Line files for
  Franklin County, Ohio in order to map geographic features and demographic
  variables. For some of the layers, you will be using Census Feature Class Codes
  (CFCC) and “Layer” files (*.lyr) to symbolize the data efficiently. Later you will use
  an interactive online program called “Color Brewer” to specify a good color scheme
  for your choropleth map.

  1. Copy the following files from x:\jvanhorn\g686\Lab2:
        a. CFCC_Water.lyr
        b. CFCC_Roads.lyr
        c. cfcc.dbf

  2. Go to the following web address:

  3. Navigate down to Data > Downloadable Data > Census 2000 TIGER/Line Data

  4. Download the following files for Franklin County, Ohio (about 3.45 MB):

          a.   Roads
          b.   County 2000
          c.   Census Tracts 2000
          d.   Hydrography
          e.   Water Polygons
          f.   Census Tract Demographics (SF1)

  5. Unzip the data using WinZip and extract the shapefiles and the *SF1.dbf file to
     your workspace.

  6. Start ArcMap and add the downloaded data to a new map document. Explore the
     data that you downloaded.

   Q9.      Do you think that you can Geocode addresses using the Roads layer that
            you downloaded? Why or why not?

7. Now set the Coordinate System and Projection of the map display by right-
   clicking Layers on the top of the window frame to the left. Use the following:


            (The shape of Franklin County should change in the map display.)

8. Turn off the Census Tracts Layer in the map display (Tgr39049trt00).

9. Under the Source tab of the ArcMap‟s Table of Contents, add the CFCC.dbf table.

10. Join the CFCC.dbf table onto both the Roads layer and the Hydrography layer and
    explore the codes and their meanings. (Use CFCC as the common field when
    joining tables.)

11. Under the “Symbology” tab for the Properties of the Roads layer, choose

         a. Browse to the appropriate Layer file that was provided for the lab and add
            its entire legend definition information. Symbolize the data according to
            “cfcc.CFCC”. Apply the changes and close the dialogue boxes.

         b. Repeat the process for the Hydrography layer.

   Map. Create a nice map of Franklin County showing all non-residential roads
        and water features by type. Turn in your map with the report.

12. If you haven‟t already, add the SF1 table for Census Tracts to the map document.

   Q10.     How many records are in the SF1 table? How many records are in the
            Attribute table for the Census tracts shapefile? Why are they different?
            What common field can you use to join the two tables?

   Q11.     What are FIPS codes? If you don’t know, you should find out from the
            Census Bureau web site ( or from the FIPS homepage
            (/ or some other reputable source.

13. Join the tables together so you can map the demographic data.

14. After the tables are joined properly you will need to export the data into a new
    shapefile in order to finalize the table join. This will allow editing of the
    demographic data in the attribute table.

       a. Select ALL of the census tracts.
       b. Right-click the layer in the Table Of Contents.
       c. Choose Data->Export Data…
       d. Export the selected features using the source‟s coordinate system. Specify
          tgrFrankTrct2000 as the output filename.
       e. Add the new shapefile to the map.

15. Next we will be adding a new field to the shapefile‟s attribute table that will hold
    values for the % of population Black/African American.

       a. Open the attribute table for tgrFrankTrct2000 and Select Add Field… from
          the Options menu.
       b. Add an appropriate name for the field and choose:
               i. Double
              ii. Precision = 8
             iii. Scale = 8
       c. After the field is created, make sure all of the records are unselected.
       d. Choose Start Editing from the Editor Toolbar.
       e. Right click on the new field header and choose the Calculate Values…
       f. Build a query that evaluates to the % of total population (2000), which is
          Black/African American.
       g. Check the results of the operation, Save the Edits and Stop Editing.

16. Symbolize the census tracts according to Natural Breaks with 7 classes. (You will
    pick colors in the steps below)

       a. Slightly adjust the class breaks (and the labels) in order to reduce the
          number of decimal places to tenths of a percent. (This makes the map
          easier to read and understand)

17. Go to the following web address:

       b. This is an interactive program that let‟s you build color schemes according
          to “Brewer Sequences”. Instructions for using the program are included in
          the webpage along with some useful information about the appropriate use
          of color in maps, charts and graphs.

       c. Experiment with the Color Brewer application. Go through the Steps of
          creating different types of color sequences for the zones on the sample

               map. Be sure to press the “Learn More” and “About Map” buttons for
               additional information.

       Q12.    When would you use each of the following?
               a.   Sequential Color Scheme
               b.   Diverging Color Scheme
               c.   Qualitative Color Scheme

   18. Create a color scheme that is appropriate for symbolizing the demographic data
       that you have created for % Black/African American in the Census zones. Apply
       the color scheme to the map. Note that ArcMap uses RGB to define custom

       Q13.    Based on this map, does there appear to be a relationship between this
               demographic variable and the location of major transportation routes in
               the area? Why or why not?

       Map. Design a nice map/layout and hand in your Choropleth with the lab. Be
            sure to use appropriate design elements as always. (Please do not
            include water features or roads on this map) and INCLUDE which
            Brewer Color Scheme (Sequential, Diverging, or Qualitative) you
            selected somewhere on your layout.

Data Source Considerations for your Project

The list below provides you with possible avenues of data for your class project.
Remember that data preparation can sometimes be up to 75% of the work that you do on
a project, so it is imperative that you begin now exploring potential data sources that
might be relevant to the questions you are considering answering this quarter. This list is
in no way exhaustive and you are not required to use data from these sites. This is just a
beginning point that I hope you will find helpful in the exploratory data seeking process.

Berkeley Digital GIS Library

GIS Data Depot

Ohio Department of Natural Resources

Spatial Info Ohio


Navigation Information Connection

Ohio Dept. of Transportation


Shared By: