Appendix K: GeoDatabase based Hazard Data Maps K.1 Introduction K.1.1 Purpose The goal of the document is to show how the Hazard (Soil, Liquefaction, Landslide and Water Depth) Maps based on shp files could be converted into GeoDatabase based Hazard Maps. K.1.2 Scope This document describes how SHP file based Hazard Maps could be converted into GeoDatabase based Hazard Maps in a step by step way. The focus is entirely on what is important to make the new GeoDatabases work with Hazus-MH. This document should not be used as a resource for converting SHP files to GeoDatabases. K.2 Prerequisites ArcGIS 9.3 (ArcMap and ArcCatalog) should be installed on the computer. K.3 Creating GeoDatabase based Hazard Data Maps 1) Launch ArcCatalog from the Start menu. Hazus-MH User’s Manual 2) Click on the folder where the new Geo-Database is to be created. In case the folder is not available in ArcCatalog click on File>Connect Folder menu and select the folder where the Geo-Database is to be created. Once OK button is pressed on that dialog the folder will be visible in ArcCatalog Appendix K: GeoDatabase based Hazard Data Maps 3) Select the Folder in TOC of the Arc catalog where the Geo-Database is to be created (the one added in the above step), Click on File>New>Personal GeoDatabase menu to create the new personal geodatabase. By default the name appears as “New Personal Geodatabse” Change the name using F2 key to what you want for example “CaDataMaps” Hazus-MH User’s Manual Appendix K: GeoDatabase based Hazard Data Maps 4) Select the folder where the hazard data maps are located in ArcCatalog’s TOC. In the folder is not available in the TOC click on File>Connect Folder menu and select the folder where the hazard data maps are located, press the OK button and the folder will be visible in ArcCatalog’s TOC. 5) Select the Shape file which is to be exported under the connected folder in TOC as shown Hazus-MH User’s Manual 6) Right click and select third option under Export (shape file to geo database) as shown Appendix K: GeoDatabase based Hazard Data Maps 7) The Export option will show a dialog as follows: Hazus-MH User’s Manual 8) Click on the browse button for the Out put Geo data base and select the geo database created in step 3. Clicking Open button will launch the following dialog: Leave the third option “Select an existing feature dataset…” empty Appendix K: GeoDatabase based Hazard Data Maps To change the name of the Out put feature class modify the edit box under “Select an existing feature dataset…”. For example name has been changed to California_Site_Class_HAZUS Hazus-MH User’s Manual 9) Now Click the Change Settings button, it shows setting options as follows: Appendix K: GeoDatabase based Hazard Data Maps 10) Click Change button on the Spatial Reference Tab Hazus-MH User’s Manual 11) Click on Import Button and Browse to \DATA folder and select “USGS.MDB” and then select USGS feature class. NOTE: represents the folder where Hazus-MH is installed. Appendix K: GeoDatabase based Hazard Data Maps 12) Click Add button and the new Settings will be reflected as follows: Hazus-MH User’s Manual 13) Click Apply and then OK and new Spatial reference Tab will be displayed as follows: Appendix K: GeoDatabase based Hazard Data Maps 14) Now Click on the “GRID SIZE” tab, it will show the original Grid Size Change Grid Level to 1000 as shown below: Hazus-MH User’s Manual K-16 Appendix K: GeoDatabase based Hazard Data Maps 15) DON’T CLICK OK, instead Click on “Item Names” Tab which has the details of all the columns in the source feature class or shape file. Hazus-MH User’s Manual K-18 16) Now change the Setting under Delete Field column on the dialog to YES for all fields other than FID (Object Id), Shape and Hazard Specific field. The following table summarizes the various hazard specific fields names, their types and the ranges of values that Hazus-MH expects. These should be used in the Corrected Fields column in the above dialog for the corresponding maps. S. N Type of Map Correct Field Name Field Type Valid Values 1 SOIL Type Text (1) A, B, C, D ,E 2 Liquefaction Susceptibility Map Type Numeric (1,0) 0 to 5 3 Landslide Susceptibility map Type Numeric (2,0) 0 to 10 4 Water Depth map Type Decimal Values must Greater than 0 In our example, which is a soil map, the NEHRP field represents the TYPE for the Soil map, so the Corrected Field corresponding to the Original Field NEHRP was modified to TYPE that is expected by Hazus-MH for soil type. This is shown in the next figure. Appendix K: GeoDatabase based Hazard Data Maps Similarly in case of Liquefaction Map the name of the field that contains the liquefaction susceptibility category should be TYPE Numeric(1, 0), in case of Landslide Map the name of the field that contains the landslide susceptibility category should be TYPE Numeric(1, 0) and in case of Water Depth Map the name of the field that contains the water depth should be TYPE Decimal. Hazus-MH User’s Manual 17) Now Click OK and on next screen which is same as Click OK, it will show the progress bar while exporting Once the Progress bar disappears, Export is over and the map has been successfully converted for use with Hazus-MH.. Appendix K: GeoDatabase based Hazard Data Maps