The goal of this exercise is to become proficient in ArcGIS Database Creation, Integration, and Geocoding. You will mainly use ArcGIS in this exercise.
Part 1: Accessing GIS Data at UNC
First log onto the UNC Geographic Information Systems (GIS) Services page at http://www.lib.unc.edu/reference/gis/index.html. Under GIS Training Resources choose FAQs- How do I... Movies! Go through the tutorial called How do I use the GIS Data Finder? Then go through the tutorial called How do I access my campus network space (H:\ drive) using the AFS Client?. The combination of these two tutorials will show you data that are available through UNC and how to access it. Explore different datasets and download at least 10 layers that you will use for your class project or if you will use other data for your project, some hypothetical project. Produce at least 3 maps in ArcGIS that display the data.
Part 2: Geocoding Lat Long Coordinates
Go to www.yellowpages.com or another sources and collect the addresses of at least 10 health clinics/hospitals in Chapel Hill. Print the addresses out. Go to the following website http://www.batchgeocode.com, read the directions, and find out the latitude longitude coordinates for those 10 clinics. Clip the output and print the result. Log onto the UNC Geographic Information Systems (GIS) Services page again- http://www.lib.unc.edu/reference/gis/index.html- and under GIS Training Resources choose FAQs- How do I... Movies! Then read the tutorial called How do I create a shapefile from Latitude/Longitude Coordinates? Create a shapefile out of the 10 clinics. Then create a map that includes labels for the 10 clinics and print it.
Part 3: Address Matching
Log onto the UNC Geographic Information Systems (GIS) Services page again at http://www.lib.unc.edu/reference/gis/index.html. Under Guides read the Mapping Census Data and Address Matching pages. Then log onto the University of Iowa website (http://www.uiowa.edu/~geog/health/) called "Improving Public Health Through Geographical Information Systems An Instructional Guide to Major Concepts and Their Implementation." Under the GIS Lab Section read the sections called Census Geography and TIGER. Then read the Key Procedure called Address Matching. Log onto the UNC Geographic Information Systems (GIS) Services page again- http://www.lib.unc.edu/reference/gis/index.html- and under GIS Training Resources choose FAQs- How do I... Movies! Then read the tutorial called How do I geocode addresses? Create an Excel address file of some real/hypothetical health related event/service with at least 20 addresses. Print the file. Once you've completed the address matching procedure explain in a paragraph what happened. Did they all match? Why or why not?
For more information on the geocoding
process, see the following online resources:
Part 4: Data Integration
Log onto the GIS Data Finder and download a couple of map layers for Chapel Hill. Overlay the 10+ health clinics shapefile with the map layers that you created in Part 2 and then create a map using the two layers. When you download the map layers make sure you know the georeferencing information (i.e., the projection, datum, map units) for the layers of Chapel Hill. The other thing you'll need to know is that you geocoded the clinics in WGS84. You'll need to know this so they all match up. If you have trouble then go back to the ESRI Virtual Campus course entitled "Understanding Map Projections and Coordinate Systems." Make a map.
Lab Deliverable Summary:Print out all of the outputs, put your name on them, and give them to the instructor. They include: Part 1: three maps; Part 2: input address printout, output printout, map; Part 3: Excel address file, and paragraph that describes what you did; Part 4: Map