Page History

...

Now you will calculate elevation statistics by watershed.

1. Return to the Geoprocessing pane.
2. At the top left of the Geoprocessing pane, click the Back buttonOpen Geoprocessing pane by clicking Tools from Analysis tab.
3. In the search box, type "zonal statistics".
4. Click the  Spatial Analyst Tools toolbox, double-click the Zonal toolset then click Zonal Statistics as Table (Spatial Analyst Tools) tool.
5. For Use the ‘Input raster or feature zone data’ , use the drop-down menu to select the Watersheds_StatePlane layer.
6. Use the For ‘Zone field’ drop-down menu to , select the ‘HU_10_NAME’ field.
7. For ‘Input value raster, select the DEMft layer.
8. For ‘Output table’, rename the table from “ZonalSt_Watersh1” to “WatershedElevation”.
9. Ensure your ‘Zonal Statistics as Table’ window Geoprocessing pane appears as shown and click Run.
   Image Removed
   
   Image Added
   
   
10. At the bottom of In the Contents pane, 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’"table to excel’.
2. Click the Table To Excel tool.
3. For the 'Input Table', select WatershedElevation from the drop-down menu.
4. 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.

1. Save the table within the HydrologyLab Locate and double-click the HydrologyLab folder to save the file within the folder.
2. For ‘Name’, name as “ type “WatershedElevation”.
3. Click Save.
   
4. In the ‘Table to Excel’ windowGeoprocessing pane, click Run.
5. Close the Table WatershedElevation table.

Now you will open the exported text file in Excel.

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

...