|GE 4150 Natural Hazards, Fall 2007
Lab 3: Analyze properties vulnerable to floods and create maps showing affected businesses and properties (Data taken from Solving Disaster Management Problems Using ArcGIS 8 by Glenn Johnson)
Points: Total of 15 points, 5 for the questions, 10 for the map
Beginning Steps: Copy the Manhattan database and the Flood.mxd onto your h: under the class folder. Use ArcCatalog to do this!
Synopsis: Manhattan, Kansas has many floods and tornados which affect the region. For this exercise we are going to analyze the critical facilities and businesses which may be within a 100 year old flood zone. Then we will create a map showing businesses which are in the flood plain, including all map elements: map view, title, legend, north arrow, scale, and an inset map.
1. Open Flood.mxd from your h:. You will need to double-click on the one of the layers to set the data source, the rest of these should fill in as well. The maps shows Manhattan, Kansas, including parcels, zoning, emergency response facilities, and hazardous sites. A flood layer is also shown for a 100 and 500 year flood zone.
2. We want to identify hazardous material sites which might be in the flood zones. Select hazmat sites which are in the 100 year flood zone.
3. Once the hazmat sites are selected, right click on the hazmat layer and choose selection>create layer from selected features. The layer is then added to the table of contents. Rename by slowly double-clicking on the layer name. Rename the file to Hazmat Sites at Risk.
4. For this exercise we want to determine the parcels which are zoned commercial or industrial to determine business losses if a 100 or 500 year flood occurred. First we want to add a zoning column to the parcel layer. Open the attribute table for parcels and add field. Name the field Zoning, type is text, and give it a length of 1. Close the attribute table.
5. First choose all of the parcels which are zoned commercial ‘C’. You can do this by using select by attributes and the query: [ZONING] LIKE 'C*' * represents a wildcard, and this will select all zoning that is commercial (C1-C6). Click apply then close.
6. Select features from the Parcels layer that have their centers in the selected features of the Zoning feature. Here you will use select by location, make sure you are checking the box to only use the selected features of zoning. Click apply then close
7. Open the attribute table for parcels, right-click on the Zoning column and choose field calculator. Type “C” in the query. This will populate the zoning column with C for commercial for the selected parcels. Close the table and clear selected features
8. Using the same procedure in steps 5-7 identify all of the parcels which are zoned industrial (I1-I5).
9. Next we want to determine the value of commercial and industrial parcels that are within the 100 year flood zone. Select all of the parcels which are zoned either commercial or industrial. Hint: you can use OR to select both types of parcels.
10. Select features from the currently selected features of Parcels that intersect the features of the 100 year flood layer. Click apply then close.
11. Open the Parcels attribute table, right-click on the Zoning column and choose summarize. Under BLDGVAL, LANDVAL, and TOTALVAL check sum. Save the file as CI_value in your class folder under your h-drive. Click the box to summarize on the selected records only. This may take a few minutes. When complete, click yes to add the result table to the map. Open the CI_value table, be sure to choose the source tab at the bottom of the table of contents to view the table. When finished viewing the table close it, and save the map document as flood_final on your h: in the class folder you have created. Leave the map document open.
Map Creation Steps: We want to make a map showing Hazmat sites which are at risk from a 100 year flood for the area shown below on the eastern side of the city:
In your map you need to have basic map elements such as, north arrow, title, scale, and legend. We will also be using a map inset for this region. A good map allows the user to identify where they are, therefore major street names need to be shown as well as river names etc. I will provide some steps in the creation of the map, but I expect every person to design the map the way they want, using different colors, symbols, labels etc.
1. Insert a new dataframe by going to Insert>new dataframe. We are going to use this second dataframe as a reference showing where the city of Manhattan is in the state of Kansas. Drag counties underneath the new dataframe. Rename the new dataframe Kansas. You will see the state of Kansas with the counties shown. Select Riley county. Once selected right click on Counties and choose selection>create layer from selected features. Make Riley County red. In the Manhattan data frame, right-click on the city boundary, choose copy, and right click on the Kansas data frame and choose paste. This will serve as our inset map, which we will work with shortly. To go back into the Manhattan data frame, right-click on the data frame and choose activate. The map view will then change to the Manhattan data frame.
2. Change the Hazmat Sites at Risk symbol to be the same as Hazmat. Right-click on the hazmat sites at risk and choose properties>symbology. Choose import in the upper right and in the drop down choose Hazmat. Now the same symbol is used, turn off the Hazmat layer. Right-click on Hazmat Sites at Risk and check label features. The text looks rather large, we want to reduce this so we can read it better. Open properties for Hazmat Sites at Risk and click on the labels tab. Here we can change the font, font color, and font size, as well as what we want to label. In this case we want to label the Name field. Change the font size to 6 and say ok. We will adjust the label names in a future step.
3. We now want to put road names on the map to help orient the user. Label the following roads on the map: E. Poyntz Ave., Turtle Creek Boulevard, McCall Road, Hayes Drive, and Sarber Lane. Hint: Select the above roads, create a new layer from the selected features. Open properties>labels tab. Choose to label on FULLNAME. Use the properties dialog to change the font, font size, and color. Use a different font/color to represent the roads.
4. You see there are duplicate road names. To change this we will want to convert the labels to annotation, allowing us to remove the duplicate labels. Right click on streets selection and choose convert labels to annotation. Store annotation in the map, and check create annotation for features in current extent. Delete the duplicate labels, and move the labels accordingly.
5. Do the same as step 4, for the Hazmat Sites at Risk. Change to annotation. Double-click on each text box and change the label, by using three rows of text instead of one long one. You can adjust each of the text boxes and move them to the appropriate locations which will be visible to the user.
6. Turn on the Rivers layer and label river features. Change the label color to blue. Turn the zoning layer off. Change the parcel fill color to white. Right click on the Emergency Response Facilities and check label features.
7. Turn on the Flood 100 layer, label the flood zone using an appropriate symbol, choose a pattern, not a single color. We want to verify that the Flood 100 layer is transparent. Open the properties>display>, make sure the transparency is set to 25%.
8. Now we are ready to create the map layout. Choose the layout icon, on the bottom beside the globe. You will see both dataframes in the map. First make your inset map of Kansas a little smaller and apply a white background. Right-click on the data frame>properties>frame. For background, use the drop down to choose white. Next we want to label Kansas on the map. Use the Draw toolbar at the bottom of your mapview to add the annotation. If the toolbar is not there, right-click on the gray toolbar region and check on draw. Click on annotation and add the text Kansas in the inset map. You can double click this to change the font, font size, and color. We are now done with the inset map.
9. Now we want to add the title, legend, scale, and north arrow. All of these are located under Insert. Insert>title yields a text box. Again you can right-click>properties or double-click to change the font etc. In addition if you want to create a colored background, click on change symbol>properties>Advanced text>check text background and choose properties to choose a background color. For the north arrow and the scale a background color can be chosen by properties>format. For the scale properties you can also change how many ticks to use for the scale as well as the measurement, such as meters. Use something that is reasonable for the data and that a user would understand.
10. Choose insert legend. You can choose an item and move it to legend items or map layers. For our legend we want to include Hazmat Sites at Risk, Emergency Response Facilities, Streets, CityBoundary, Rivers, Flood100, and Parcels. If anything else is left return it to the map layers. You can use frame tab again to have a colored background. All of the map element can be reduced or enlarged by selecting the element and expanding or reducing the edge points.
11. Save your map document. You are also able to export your map to a jpeg by choosing File>export. Print out your map in color, make sure everything is visible and the text is not to small and all of the layers are overlain correctly. The overall colors and representation look good. This map should be good enough to give to the business owner in Manhattan, Kansas and explain the hazard which affect their business. Make sure the businesses are labeled as well as streets for the user to orient themselves. Printed maps will appear different then on the screen, so do print-outs and adjust your maps accordingly. Turn in your final map in color.
1. How many Hazmat facilities are at risk from a 100-year flood?
2. How many industrial parcels are at risk from a 100-year flood?
3. What is the total value of commercial property at risk from a 100-year flood?
4. What is the total value of industrial property at risk from a 100-year flood?
5. Now that we know how many industrial and commercial properties could be affected by a 100-year flood, what are 3 ways in which the hazards to these properties could be reduced?
Due Date: The above questions and your map is due Friday Sept. 28. Grading requirements for the map can be found on the class website.