Creating a new map document

Now you will create a new map document for your lab 2 project. You will begin by opening ArcGIS Pro.

1. Open the HydrologyLab.aprx file.
2. On the Standard toolbar, click the Insert tab and click New Map.
   
3. Click the Map title in the table of contents. Rename the map to Lab2.

Projecting vector data

Before downloading any new data, you will further process data from Lab 1 in preparation for this lab.

1. On the catalog pane, expand Databases and HydrologyLab.gdb file.
2. Drag the Watersheds feature class into the Map Display.
3. In the Table of Contents, double-click the Watersheds layer.
4. In the ‘Layer Properties’ window, click the Source tab and expand Spatial Reference.
   
   Notice that the layer is in a geographic coordinate system called GCS_North_American_1983. Because the data has a geographic coordinate system, the coordinates are stored in degrees, which indicate the three-dimensional spherical location of the data. Though the data itself is stored in a geographic coordinate system, your computer monitor is flat, so, though no projection has been defined, the data must be displayed in a particular projection. Whenever ArcMap displays data in a geographic coordinate system, it uses a Plate_Carrée projection, where one degree of latitude by one degree of longitude is represented as a square, rather than a curved trapezoid. This projection results in increasing stretching in the east-west direction, the farther north or south from the equator you are mapping.
   
   
5. Close the ‘Layer Properties’ window.
   
   Working with geographic coordinate systems is fine for creating purely visual maps, as you did in Lab 1 (though the visual distortion can be disorienting and misleading), but in this lab, you will be calculating areas, distances, and overlaps between features. Such calculations require the three-dimensional coordinates to be projected down onto a two-dimensional plane, so that the coordinates are stored in linear units, such as feet or meters, rather than degrees. In order to facilitate measurements of distance and area, you will now project the Watersheds layer into the State Plane Texas South Central projection which is best suited to mapping the greater Houston region.
   
   
6. In the Analysis tab, click Tools.
7. Under Toolboxes, double-click the Data Management Tools toolbox → Projections and Transformations toolset → Project tool.
8. For ‘Input Dataset or Feature Class’, use the drop-down menu to select Watersheds layer.
   
9. For ‘Output Dataset or Feature Class’, rename “Watersheds_Project” to “Watersheds_StatePlane”, since that is the name of the projection you will be using.
10. Next to the ‘Output Coordinate System’ box, click the Set Coordinate System button.
11. Double-click Projected Coordinate Systems → State Plane → NAD 1983 (2011) (US Feet).
12. Select NAD 1983 StatePlane Texas S Central FIPS 4204 (US Feet) and click OK.
    
    Because both the input and output coordinate systems are based on the NAD 1983 geographic coordinate system, no geographic transformation is required.
    
    
13. Ensure your ‘Project’ window appears as shown below and click Run.
    
14. Close Geoprocessing Pane.
    
    Now that you have the correctly projected layer, you no longer need the original NAD 1983 layer.
    
    
15. Right-click the Watersheds layer and select Remove.
16. Double-click the new Watersheds_StatePlane layer.
    
    Notice that the layer is now in a projected coordinate system, NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet.
    
    
17. Close the ‘Layer Properties’ window.
    

    You may have noticed that the visual appearance of the watersheds did not change in your Map Display, even though you projected them. That is because the data frame takes on the projection of the first layer added to it. Since you first added the original unprojected Watersheds layer into the data frame, which was in NAD 1983, the data frame displays the data in NAD 1983 (or Plate_Carrée). Currently, the projected Watersheds_StatePlane layer is being projected-on-the-fly back into NAD 1983 for visual purposes, so that the two layers are properly aligned in space.

    Move the cursor around the screen and notice that the coordinates in the bottom right corner of the Map Display are shown in decimal degrees. This is another clue that the data frame is still using a geographic coordinate system; however, you would like the data frame to display data using the local Houston projection.
    
    

18. At the top of the Table of Contents, right-click the Lab 2 map title and click Properties.

19. Click the Coordinate System tab.
    
    While you could search for or navigate to the State Plane Texas South Central coordinate system, as you did before, in this case, you know that the same coordinate system is already used by the Watersheds_StatePlane layer. In such an instance, it is often easier to import the coordinate system from another known layer, especially if you are not familiar with the hierarchy of the coordinate system folders
    
    

20. On the ‘Coordinate System’ tab toolbar, click the Add Coordinate System button and select Import….
    

21. Double-click the HyrdologyLab geodatabase.
22. Select the Watersheds_StatePlane feature class and click Add.
    
    Notice that the familiar State Plane Texas South Central projection is now listed.
    
    
23. Click OK.
    
    Notice that the watershed boundaries are now more compact in the east-west direction, as expected, because the local projection results in less distortion than the Plate Carrée projection used to represent geographic coordinate systems.
    
    

Downloading data from the National Map Viewer

Now you are ready to download digital elevation model (DEM) data for the Buffalo-San Jacinto subbasin. Some local government agencies, such as the Houston-Galveston Area Council        (H-GAC) contract to have LiDAR data collected, which provides high resolution data containing both the elevation of the bare land and the heights of features in the built environment. Though we are lucky to have this high-quality data available in this particular region, for projects anywhere in the U.S., the best available DEM data generally comes from the National Elevation Dataset (NED) produced by the USGS. More information regarding NED data can be found at ned.usgs.gov. You will download NED data from The National Map Viewer.

1. In a web browser, go to https://viewer.nationalmap.gov/basic/.
   
   First you will select the data products you are interested in viewing and downloading.
   
   
2. On the left side bar, check the Elevation Products (3DEP) section to expand it.
3. Within the Product Search Filter, check 1/3 arc-second DEM for the subcategory and select ArcGrid for the File Format.
4. On the left side bar, scroll below the Elevation Products section and check the Hydrography (NHDPlus HR, NHD, WBD) section to expand it.
5. Within the Product Search Filter, select National Hydrography Dataset (NHD) for the subcategory, select HU-8 Subbasin for the Data Extent and select FileGDB10.1 for the File Format.
   
   Now you constrain your downloads to your area of interest.
   
   
6. In the search bar just above the map on the right, type “Houston” and click Go.
   
   After zooming into Houston, you can see the blue boundaries of the individual subbasins and each subbasin is labeled with its HUC-8 number on the map.
   
7. Near the center of the map, click within Subbasin 12040104 to select it.
   
   Notice that just above the map, your search is now constrained to Polygon: huc8 12040104.
   
   
8. At the top of the left side bar, click Find Products.
   
9. Under Available Products, to the right of Elevation Products (3DEP), click results.
   
   You are now provided with a listing of all the DEM tiles covering the area of Subbasin 12040104.
   
10. In turn, click Download for USGS NED n30w096, n30w095, and n31w096.
    
11. Navigate to the location where the three zipped folders have been downloaded.
12. Select and copy all three zipped folders.
13. Using Windows Explorer, navigate to your HydrologyLab folder.
14. Paste all three zipped folders directly inside your HydrologyLab folder. Do NOT paste them inside the .gdb geodatabase.
15. Select all three zipped folders.
16. Right-click any of the three selected folders and select 7-Zip → Extract to “*\”, which will create one unzipped folder for the contents of each zipped folder.
17. Return to ArcGIS Pro.
    
    Since you just added new files to your folder, you will need to refresh it in order for them to appear in the Catalog pane.
    
    
18. Click the Project tab on the Catalog pane.
19. Right-click your HydrologyLab folder and select Refresh.
20. Expand n30w095 and the other folders to preview their contents.
    
    Each raster file with a name such as grdn30w095_13 corresponds to a 1x1 degree tile. The file name contains “grd” for grid, followed by the latitude and longitude of the top left corner of the tile.

Ading raster data in ArcMap

1. Drag the grdn30w095_13 raster into the Map Display.
   
   You will be asked if you would like to create pyramids. Pyramids cache the raster at multiple reduced resolutions, resulting in an increased file size, but better rendering performance in your Map Display. It is normally a good idea to create pyramids, but since you will be processing the corresponding rasters into a new file in the next step, you will not create pyramids at this time.
   
   
2. Repeat Steps 1 and 2 with the grdn30w096_13 and grdn31w096_13 rasters.
   
   Notice that the 1x1 degree tiles appear as angled rectangles, because they are being displayed in the State Plane Texas South Central projection. If the data frame were still in the NAD 1983 geographic coordinate system, the tiles would look like squares. Now you will look up the native coordinate system of the raster files.
   
   
3. In the Table of Contents, double-click the grdn31w096_13 layer.
   
   Under the Source tab, scroll down and notice the spatial reference is listed as GCS_North_American_1983. Since this coordinate system is not the same one currently used by the data frame, the raster layer is being projected-on-the-fly into the State Plane Texas South Central projection.

Mosaicking raster files

The edges where the three tiles meet are currently visible, because the minimum and maximum elevation is different in each raster, causing the same value to be represented with a different shade of gray in each raster. To solve that visual problem and also simplify future processing steps, you will mosaic the three rasters into a single raster.

Before creating a mosaic, you will need to look up a few pieces of information from the original rasters. Scroll back to the top of the ‘Layer Properties’ window. Notice that there is 1 band, meaning that each pixel only stores a single value. Aerial imagery has 3 bands to store the 3 RGB values. The format is listed as GRID, which stands for an Esri Grid, which is a raster file format native to Esri software. The pixel type and depth is 32-bit floating point.

1. Close the ‘Layer Properties’ window.
2. Open Tools. Click Toolboxes on the geoprocessing pane.
3. In the Data Management Tools toolbox, click the Raster toolset → Raster Dataset toolset → Mosaic to New Raster tool.
4. For ‘Input Rasters’, select the three 1x1 degree raster layers.
5. For ‘Output Location’, click the Browse button.
6. Select the HydrologyLab geodatabase and click Add.
7. For ‘Raster Dataset Name with Extension’, type “DEMMosaic”.
8. Use the ‘Pixel Type’ drop-down menu to select 32 bit float, since that was the same type stored in the original rasters.
9. For ‘Number of Bands’, type “1”. (The text appears on the right side of the field.)
10. Ensure your ‘Mosaic To New Raster’ appears as shown below and click Run.
    
    The mosaic may take a couple minutes to process. When it is complete, notice there are no longer visual seams between the tiles in the mosaicked raster. Now that you have a single mosaic, you no longer need the three originals tiles.
    
    
11. Remove all three original raster files from the Table of Contents.

Projecting raster files

Now you need to project your mosaic into the State Plane Texas South Central projection, so that you can properly calculate spatial statistics based on the data it contains.

1. In the Geoprocessing pane, click Data Management Tools -> Projections and Transformations toolset -> the Raster toolset Project Raster tool.
2. For ‘Input Raster’, select in the DEMMosaic layer in the drop-down menu.
3. For ‘Output Raster Dataset’, rename the raster from “DEMMosaic_ProjectRaster” to “DEMStatePlane”
4. For ‘Output Coordinate System’, select Watersheds_Stateplane.

You should now see the NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet displayed in Output Coordinate System.

1. Use the ‘Resampling Technique’ drop-down menu to select Cubic Convolution.

For cell size, you may normally want to keep the original resolution, which was approximately 30 m, but in this case, you will reduce the resolution to expedite processing times during this lab. The cell size is always specified in the same units as the projection, which in this case is feet, so you will select a cell size of 300 feet.

1. Leave ‘Output Cell Size’ blank, but­ type “300” for the ‘X’ and ‘Y’. Make sure that your screen is the same as the screenshot below. Click Run.
   

Remember that the data frame was already displaying all layers in State Plane Texas South Central, so you should not notice much of a difference between the two layers, other than that the cell size has increased, meaning the resolution has decreased.

1. Remove the DEMMosaic layer from the Table of Contents.

Clipping raster files

Now you are ready to clip the DEM mosaic to the Buffalo-San Jacinto subbasin.

1. In ArcToolbox, back in the Raster toolset, double-click the Raster Processing toolset and click the Clip (Data Management) tool.
2. For ‘Input Raster’, drag in the DEMStatePlane layer from the Table of Contents.
3. For ‘Output Extent’, drag in the Watersheds_StatePlane layer.
4. Check Use Input Features for Clipping Geometry.

Checking that box ensures that the raster is limited to the actual shape of the watersheds, rather than a rectangle covering the same extent.

1. For ‘Output Raster Dataset’, rename the raster from “DEMStatePlane_Clip” to “DEMSubbasin”.
2. Ensure your ‘Clip’ window appears exactly as shown below and click Run.
   

1. Remove the DEMStatePlane layer from the Table of Contents.
2. Turn off the Watersheds_StatePlane layer to view the DEMSubbasin layer.

The DEMSubbasin layer is now clipped to the shape of the Buffalo-San Jacinto subbasin.

Converting raster units using the raster calculator

Right now, the elevations in the DEM are in units of meters. In order to convert these units into feet, you will use the raster calculator.

1. In Geoprocessing pane, click the Spatial Analyst Tools toolbox, click the Map Algebra toolset, click the Raster Calculator tool.
2. In the list of ‘Rasters’, double-click the DEMSubbasin layer.
3. In the calculator, double-click the * button.
4. In the equation box, type “3.281”, which is the conversion factor from meters to feet.
5. For ‘Output raster’, rename the raster from “rastercalc” to “DEMft”.
6. Ensure your ‘Raster Calculator’ window appears as shown below and click Run.
   

Visually, the meters and feet layers should be identical, but if you look at the layers in the Table of Contents, you will notice that the original layer goes from elevations of -8 to 62 meters and the newly calculated layer goes from elevations of -26 to 204 feet.

1. Remove the DEMSubbasin layer from the Table of Contents.

Exploring elevation using the raster calculator

Now you will determine which portions of land may be affected by a 15’ storm surge. Obviously, complex inundation models will take more variables into account, but in this instance you will simply highlight all the areas of land with an elevation of 15’ or less.

1. Again, go back to the Raster Calculator tool. Delete the previous expression.
2. In the list of 'Rasters’, double-click the DEMft layer.
3. In the calculator, double-click the <= button.
4. In the equation box, type “15”.
5. For ‘Output raster’, rename the raster from “demft_raster” to “Flood15ft”.
6. Ensure your ‘Raster Calculator’ window appears as shown below and click Run.
   

1. Close Geoprocessing pane.
2. Right-click the Flood15ft layer. Click Symbology.
3. In the table of values, right-click the 0 value and click Remove.
   

10. Click the rectangle symbol to the left of the 1 value and select Blue.

11. Save your map document.

Now the cells containing an elevation of 15 feet or less are highlighted on top of the elevation raster.

FOR MAP LAYOUT TO BE TURNED IN

Create an 8.5 x 11 layout showing the DEM clipped to the subbasin with areas less than or equal to 15 feet in elevation highlighted.

Symbolizing raster files

Now you will create a new map document from the one you are currently using.

1. Click the Insert menu and select New Map….
2. Double-click “Map1” in the contents pane and type “Lab2Topo” as name. Click Save.
3. Expand Databases in the Catalog pane. Click HydrologyLab.gdb.
4. Drag the DEMft and Watersheds_Stateplane layers into the map display.
5. Turn off the Watersheds_Stateplane layer.
6. Right-click DEMft layer and click the Symbology.
7. Scroll down the ‘Color Ramp’ drop-down menu and select the rainbow ramp.
   

Patterns within the data are now easier to see, especially at the lower elevations.

Generating contour lines

In addition to raster DEM data, it is sometimes useful to be able to represent elevation using vector contour lines. Contour lines at any regular intervals or discrete values can be created from DEM data.

1. Open Geoprocessing pane by clicking Tools from Analysis tab.
2. In the Spatial Analyst Tools toolbox, click the Surface toolset then click the Contour tool.
3. For ‘Input raster’, select the DEMft layer.
4. For the ‘Output polyline features’, rename the feature class from “Contour_DEMft1” to “Contours10ft”.
5. For ‘Contour interval’, type “10”.

The base contour is the lowest contour that will be shown. Since the lowest elevation is -26 ft, you will set your base contour to -20 ft.

1. For ‘Base contour’, type  “-20”.

Since the x,y coordinates are in the units of your State Plane Texas South Central projection, which is feet, and you have also used the Raster Calculator to convert the z units stored within the raster cells to feet, you do not need a custom Z factor.

1. For ‘Z factor’, leave the default value of 1.
2. Ensure your ‘Contour’ window appears as shown below and click Run.
   

1. Turn off the DEMft layer to better see the contours.

10. Right-click the Contours10ft layer. Click Symbology.

11. Use the drop-down menu at the top to select Unique values.

12. Use the ‘Value Field’ drop-down menu to select the Contour field.

13. Use the ‘Color Ramp’ drop-down menu. Check Show All and select one of the few graduated color ramps as shown below. 
                                        

Now you can tell which contours are highest and lowest.

14. Turn off and collapse the Contours10ft layer.

15. Turn back on the DEMft layer.

Generating a hillshade

Now you will create a hillshade raster, which provides a shaded relief of the terrain based on a certain sun angle. It stores a value between 0 and 255 indicating the extent to which the cell would be shaded from the sun.

1. Open Geoprocessing pane by clicking Tools from Analysis tab.
2. In the Surface toolset, double-click the Hillshade tool.
3. For ‘Input raster’, select the DEMft layer.
4. For ‘Output raster’, rename the raster from “HillSha_DEMf1” to “Hillshade”.

The azimuth and altitude refer to sun angles. For now, you will stick with the default values.

As previously mentioned, the Z factor is used when the horizontal units of the projection and units of the elevation measurements stored in the raster cells are not the same. In this case, both are measured in feet, so a value of 1 is technically correct. Typically, hillshades are used to create realistic three-dimensional representations of mountains, which can be much easier for an audience to interpret than a flat DEM or contour lines. Unfortunately, the opposite is true in Houston, because the area is so flat.  It would be difficult to see any changes in elevation using a hillshade, since few shadows would be cast by the terrain. To compensate visually for the flat terrain, you will exaggerate the vertical elevations.

1. For ‘Z factor’, type “20”.
2. Ensure your ‘Hillshade’ window appears as shown and click Run.
   

Typically hillshades are shown beneath transparent layers conveying other information, just to give the map a realistic appearance.

1. In the Table of Contents, drag the Hillshade layer beneath the DEMft layer.
2. In the DEMft layer, in the feature-dependent Appearance tab, in the Effects group, slide the transparency to 60%.

Now the gradual changes in elevation are apparent from the coloring and are complimented by a realistic display of the terrain created with the hillshade.

1. Turn on the Watersheds_StatePlane layer.

10. Symbolize the Watersheds_StatePlane layer with a hollow fill and thick black outline.

As a final touch, you will add the flowlines you downloaded in Lab1 to your Map Display.

11. Click the Catalog tab.

12. In the HydrologyLab geodatabase, drag the Flowlines feature class into the Map Display.

13. In the Table of Contents, drag the Flowlines layer above the DEMft layer, but beneath the Watersheds_StatePlane layer.

14. Symbolize the Flowlines layer with a thin blue line.

15. Save your map document.

FOR MAP LAYOUT TO BE TURNED IN

Create an 8.5 x 11 layout showing transparent elevation in graduated colors on top of a hillshade, with watershed boundaries and flowlines visible.

Calculating zonal statistics

Now you will calculate elevation statistics by watershed.

1. Open Geoprocessing pane by clicking Tools from Analysis tab.
2. In the Spatial Analyst Tools toolbox, double-click the Zonal toolset then click Zonal Statistics as Table tool.
3. For ‘Input raster or feature zone data’, use the drop-down menu to select the Watersheds_StatePlane layer.
4. Use the ‘Zone field’ drop-down menu to select the ‘HU_10_NAME’ field.
5. For ‘Input value raster, select the DEMft layer.
6. For ‘Output table’, rename the table from “ZonalSt_Watersh1” to “WatershedElevation”.
7. Ensure your ‘Zonal Statistics as Table’ window appears as shown and click Run.
   
   

1. In the Table of Contents, right-click the WatershedElevation table and select Open.

This table tells you the statistics regarding all the elevation values within each watershed zone.

1. In the Geoprocessing pane, search for ‘Table to Excel’.

10. For the Input Table, select ‘WatershedElevation’ from the drop-down menu.

11. For ‘Output Excel File’, click the Browse button.

If you save this table inside your file geodatabase, you will not be able to open it outside of ArcGIS, so you will instead save it as a text file outside of your file geodatabase.

12. Save the table within the HydrologyLab folder.

13. For ‘Name’, name as “WatershedElevation”.

14. In the ‘Table to Excel’ window, click Run.

15. Close the Table.

Now you will open the exported text file in Excel.

1. Open WatershedElevation.xls in Microsoft Excel.
2. Delete the OBJECTID, ZONE_CODE, COUNT, AREA, and SUM fields.
3. Highlight the minimum and maximum values in each column.

Continue formatting the table until you are satisfied with its appearance.

1. Click the File menu and select Save As.
2. Navigate to your HydrologyLab folder.
3. For ‘File name:’, type “WatershedElevation”.
4. Use the ‘Save as type:’ drop-down menu to select Excel Workbook (*.xlsx).
5. Click Save and close Excel.

FOR TABLE TO BE TURNED IN

Create a table highlighting the minimum and maximum values for the minimum, maximum, range, mean, and standard deviation of all elevation values within each watershed.

Downloading data from Climate Data Online.

Now you will download rain gauge station data created by the National Climatic Data Center (NCDC) using the Climate Data Online (CDO) interface.

1. In a web browser, go to www.ncdc.noaa.gov/cdo-web/.
2. Click the Mapping Tool tab.
   
   You will search for data using the NHD hydrologic units. Previously, you had been working with the Buffalo-San Jacinto subbasin (HUC = 12040104). In this case, you will step up two levels to the Galveston Bay-San Jacinto subregion (HUC = 1204). 
3. On the Surface Maps tab, click Normals
   
4. In the left sidebar, on the Layers tab, uncheck Daily Climate Normals, and check Annual Climate Normals.
5. To the right of Annual Climate Normals, click the Map Tools button.
   
6. In the new ‘ANNUAL CLIMATE NORMALS TOOLS’ window, click Location.
7. Use the drop-down menu to select USGS HUC.
8. Use the ‘Select a HUC type’ drop-down menu to select Subregions (4-digit).
9. Use the ‘Select a HUC’ drop-down menu to select Galveston Bay-San Jacinto.
   
10. Click Zoom to location.
11. The left sidebar switches to the Results tab. Click Get All Location Data.
    
12. For Step 1, select CSV for the output format and click CONTINUE.
    
    
13. For ‘Station Detail & Data Flag Options’, check Station name, Geographic location, and Include data flags to include those variables the data table.
    
    
14. For ‘Select data types for custom output’, click the Annual Precipitation category to expand it.
15. Check Long-term averages of annual precipitation totals (ANN-PRCP-NORMAL).
    
    
16. At the bottom of the window, click CONTINUE.
17. Type your email address twice and click SUBMIT ORDER.
    
    Check your email. You should receive two emails a couple minutes apart, although it may take a few hours to receive the second email. The first one indicates that your data request was submitted and the second one includes the requested data.
    
    
18. In your email, click the Download link to download the requested CSV file.
    
    

Excel

1. Navigate to the location where the CSV file was stored.
2. Double-click the CSV file to open it using Excel.

The first column contains the unique station identification code and the second column contains the station name. Next are the elevation, latitude, and longitude of the stations. The annual precipitation field contains long-term averages of annual precipitation totals in hundredths of inches. More information is available on the Data Set Documentation and Samples portion of the CDO website. The annual precipitation field "ANN-PRCP-NORMAL" may not be in the F column, it might be in the BP column, in which case you will need to move it there using the copy-paste function. 

Before opening this table in ArcGIS, you must reformat some of the field names, which cannot have special characters and must be 13 characters or less.

1. Rename “ANN-PRCP-NORMAL” to “ANNPRCPHI”, for annual precipitation in hundredths of inches.
2. Along the top of the worksheet, drag across the column letters to select columns A through H.
3. Copy the columns. Along the bottom of the worksheet, click the "plus" icon to create a new sheet. In the A1 cell, paste your previously copied columns. 
4. Delete the previous sheet. 
5. Along the top of the worksheet, drag across the column letters to select columns A through H.
6. Hover your mouse between columns G and H until the cursor changes to two outward facing arrows and double-click to auto-size the column widths.
7. At the bottom left of the worksheet, rename the worksheet “PrecipStations”.
8. Click the File menu and select Save As.

10. Navigate to your Lab 1 folder.

11. For ‘File name:’, type PrecipStations.

12. Use the ‘Save as type:’ drop-down menu to select Excel 97-2003 Workbook.

13. Click Save.

14. Close Excel.

Displaying XY data

Now you are ready to start a new map document and display the tabular rain gage data you just downloaded.

1. Return to ArcGIS Pro.
2. Click the Insert menu and select New Map….
3. Click “Map1” in the contents pane to rename it as “Lab2Precip”. Click Save.
4. Drag Watersheds_Stateplane onto the map display.
5. Click the Geoprocessing tab and search for ‘Excel to Table’.
6. For the Input Excel File, select PrecipStations. Rename the output table PrecipStations.
7. Click Run.
8. In the Table of Contents, right-click the PrecipStations table and select Display XY Data.
9. For ‘X Field:’, select the LONGITUDE field.
10. For ‘Y Field:’, select the LATITUDE field.
11. Click the Atlas to the right of the Spatial Reference box.
    
    Because the coordinates are in the form of latitude and longitude in decimal degrees, you know you will need to select a geographic coordinate system, rather than a projected coordinate system.  While the data could theoretically be in any geographic coordinate system, you will select the North American Datum 1983, commonly abbreviated NAD 83, because this is coordinate system of the data provided on the NCDC website.
12. Double-click Geographic Coordinate Systems > North America > USA and Territories.
13. Select NAD 1983 and click OK.
14. Ensure that your window matches that below and click Run.
    
    
    
    The points should now appear on top of the watersheds, though they also extend beyond the watersheds in the Buffalo-San Jacinto subbasin, since we downloaded them for the entire Galveston Bay-San Jacinto subregion.

Exporting XY data

Since the points appear to be in reasonable locations (rather than in another country or the middle of the ocean), you will want to export them to a new feature class in your ElevationRainfall geodatabase.  Exporting to a feature class will allow you to reuse this points layer in other future map documents without having to go through the display XY data process each time.

1. Right-click the PrecipStations_Layer layer and select Data > Export Features.
   
   Because you last exported a text file outside of your geodatabase, notice the output feature class is now set to a shapefile in your Lab 2 folder, rather than a feature class within your ElevationRainfall geodatabase.
   
   
2. Next to ‘Output feature class’, click the Browse button.
3. Navigate to the HydrologyLab geodatabase.
4. Double-click your HydrologyLab geodatabase to save your feature class in it.
5. For ‘Name:’, type “PrecipStations_Features” and click Save.
   
   
6. Click Run.
   
   Since you are now using a permanent feature class, you may remove your temporary Events layer and the corresponding Excel table.
   
   
7. Right-click the PrecipStations_Layer layer and select Remove.
8. Right-click the PrecipStations table and select Remove.

Projecting vector data

Repeating the technique you learned earlier in this lab to project vector data, project the PrecipStations layer into the State Plane Texas South Central projection. Save the resulting feature class and name it “PrecipStations_StatePlane”. Remove the original PrecipStations layer from the Table of Contents.

Create Thiessen polygons

Now you will calculate the mean annual precipitation over each watershed using Thiessen polygons, which associate every cell in the watershed with the nearest rain gage.

1. In the Table of Contents, Ctrl-select the PrecipStations_StatePlane and Watersheds_StatePlane layers.
2. Right-click either selected layer and select Zoom To Layers.
3. Open Geoprocessing pane by clicking Tools from Analysis tab.
4. Double-click the Analysis toolbox  then the Proximity toolset then the Create Thiessen Polygons tool.
   
   Before populating the variables in this tool, you will change an Environment setting so that the polygons are calculated for the entire region that you just zoomed to.
   
   
5. At the top of the Geoprocessing window, click the Environments button on the right.
6. For Extent, use the drop-down menu to select Current Display Extent and go back to Parameters.
7. For ‘Input Features’, drag in the PrecipStations_StatePlane layer.
8. For ‘Output Feature Class’, rename the feature class from “PrecipStations_StatePlane_Cr” to “PrecipThiessen”.
9. Use the ‘Output Fields’ drop-down menu to select All fields.
10. Ensure your ‘Create Thiessen Polygons’ window appears as shown below and click Run.
    
    You will notice that polygons now fill the entire Map Display indicating which areas are closest to which rain gages.
11. Open the PrecipThiessen layer attribute table.
    
    Notice that all of the fields that you originally downloaded from CDO are still included, because you selected to output all fields when running the Create Thiessen Polygons tool. If you do not see all of the same fields, re-run the tool and this time output all fields.
    
    
12. Close the Table.

Intersecting two polygon layers

In order to determine which portions of the resulting polygons overlap with which watersheds, you will now perform an intersect operation between the two layers. The result will allow you to calculate weighted averages of the precipitation in each watershed.

1. In the Analysis Tools toolbox, click the Overlay toolset then the Intersect tool.
2. For ‘Input Features’, drag in the PrecipThiessen and the Watersheds_StatePlane layers.
3. For ‘Output Feature Class’, rename it from “PrecipThiessen_Intersect” to “ThiessenWatershedIntersect”.
4. Ensure your ‘Intersect’ window appears as shown below and click Run.
   
   
5. Remove the PrecipThiessen layer from the Table of Contents.
6. Zoom to the ThiessenWatershedIntersect layer.
   
   The resulting layer integrates all of the boundaries from both the Thiessen polygons and the watersheds, limited to the extent of their overlap.
   
   
7. Open the ThiessenWatershedIntersect layer attribute table.
   
   Notice that the original 8 watersheds have now been divided into 42 sections indicating which areas of each watershed are closest to each rain gage. Let P_k denote the annual precipitation associated with each rain gage and A_ik denote the area of the intersected polygon associated with rain gage _k and watershed _i. The area weighted precipitation associated with each watershed is
   
   
   You will add a new field to the table to calculate the elements of the numerator of the equation.|
   
   
8. Click Add Field… button on top of the table display.
   
   
   
   
9. For ‘Name:’, type “APProd”.
10. Use the ‘Type:’, drop-down menu to select Double and click Save on the Fields tab.
    
    
11. Right-click the APProd field name and select Calculate Field.
12. Using the fields and buttons or by typing, enter “!ANNPRCPHI! * !Shape_Area!”.

13. Ensure your ‘Field Calculator’ appears as shown below and click Run.

    
    The APProd field now contains the numerator values in the equation. You are now ready to summarize the calculated statistics by watershed.

14. Right-click the HU_10_NAME field name and select Summarize….

15. For statistics fields, use the drop-down menu to select the Shape_Area field and select Sum.

16. Select the APProd field and select Sum.
17. For ‘Output Table’, rename the table from “ThiessenWatershedInteract_St” to “WatershedPrecip”.
18. Ensure your ‘Summarize’ window appears as shown below and click Run.
    
    
    The resulting table gives the numerator and denominator in the equation for each watershed.
    
    
19. Open the WatershedPrecip table.

Repeating the techniques you just learned, add a new field to the WatershedPrecip table called “Precip” of type double. Use the field calculator to evaluate [Sum_APProd]/[Sum_Shape_Area]. The result is the precipitation for each subwatershed. Export the table to Excel and format it. Also include the mean annual precipitation over the entire watershed.

FOR TABLE TO BE TURNED IN

Create a table containing the weighted mean annual precipitation for each watershed, as calculated using Thiessen polygons, along with the total mean annual precipitation over the entire subbasin.

Interpolating point values

Now you will calculate precipitation for each watershed using a different interpolation method.

1. Turn off the ThiessenWatershedIntersect layer.
2. Right-click the Watersheds_StatePlane layer and select Zoom to Layer.
3. Open Toolbox.
4. In the Spatial Analyst Tools toolbox, click the Interpolation toolset then the Spline tool.
5. On the top of the window, click the Environments.
6. For Extent, use the drop-down menu to select Current Display Extent.
7. Use the ‘Mask’ drop-down menu to select the Watersheds_StatePlane layer.
8. Go back to Parameters. For ‘Input point features’, drag in the PrecipStations_StatePlane layer.
9. Use the ‘Z value field’ drop-down menu to select the ANNPRCPHI field that contains the values you wish to interpolate.
10. For ‘Output raster’, rename the exported raster from “Spline_Preci1” to “AnnPrecip”.
11. Use the ‘Spline type’ drop-down menu to select TENSION.
12.  Ensure your ‘Spline’ window appears as shown below, and click Run.
    
    The result is a solid surface estimating the rainfall at each cell, based on the data collected at each rain gage. Turn the Thiessen polygons back on to give them a hollow fill. Symbolize the rain gages as you desire.

FOR MAP LAYOUT TO BE TURNED IN

Create an 8.5 x 11 layout showing the Thiessen polygon boundaries, interpolated rainfall layer and rain gage locations.

TOP MAP WAS THE ORIGINAL MAP, BOTTOM IS MY SCREENSHOT WHICH HAS SOMEWHAT DIFFERENT DATA. NOT SURE IF IT MATTERS BUT THOUGHT IT WORTHWHILE TO AT LEAST CHECK

Using the techniques you learned earlier in this lab, use the "Zonal Statistics as Table" tool to export a table containing the total annual rainfall for each watershed, as calculated from the AnnPrecip spline interpolation layer and format the table in Excel.

FOR TABLE TO BE TURNED IN

Create a table containing the total annual precipitation for each watershed, as calculated using the spline interpolation method, along with the total annual precipitation over the entire subbasin.

1. Create an 8.5 x 11 layout showing the DEM clipped to the subbasin with areas less than or equal to 15 feet in elevation highlighted.
2. Create an 8.5 x 11 layout showing transparent elevation in graduated colors on top of a hillshade, with watershed boundaries and flowlines visible.
3. Create a table highlighting the minimum and maximum values for the minimum, maximum, range, mean, and standard deviation of all elevation values within each watershed.
4. Create a table containing the weighted mean annual precipitation for each watershed, as calculated using Thiessen polygons, along with the total mean annual precipitation over the entire subbasin.
5. Create an 8.5 x 11 layout showing the Thiessen polygon boundaries, interpolated rainfall layer, and rain gage locations.
6. Create a table containing the total annual precipitation for each watershed, as calculated using the spline interpolation method, along with the total annual precipitation over the entire subbasin.