...
- On the Standard toolbar, click the Insert tab and click New Map.
- At the top of the Contents pane, rename the map to "Lab2".
...
- In the Analysis tab, click the Tools button to open the Geoprocessing pane.
- In the 'Find Tools' search box, type "Projectproject".
- Click the Project tool.
- For ‘Input Dataset or Feature Class’, use the drop-down menu to select the Watersheds layer.
- For ‘Output Dataset or Feature Class’, rename “Watersheds_Project” to “Watersheds_StatePlane”, since that is the name of the projection you will be using.
- Next to the ‘Output Coordinate System’ box, click the Select Coordinate System button.
- Double-click Projected Coordinate Systems → State Plane → NAD 1983 (US Feet).
- Select NAD 1983 StatePlane Texas S Central FIPS 4204 (US Feet) and click OK.
...
Notice that the layer is now in a projected coordinate system, NAD 1983 StatePlane Texas S Central FIPS 4204 (US Feet).
- Close the ‘Layer Properties’ window.
...
Move the cursor around the screen and notice that the coordinates at the bottom of the map view 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.
At the top of the Contents pane, double-click the Lab 2 map to open the 'Map Properties' window.
- Click the Coordinate Systems tab.
While you could search for or navigate to the State Plane Texas South Central projection, 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
Scroll to the top of the 'XY Coordinate Systems Available' list.
Expand Layers.
...
Click NAD 1983 StatePlane Texas S Central FIPS 4204 (US Feet).
- 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
...
pseudo plate carrée projection used to represent geographic coordinate systems.
Part 2: Downloading DEM Data
...
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 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 ViewerDownload Client.
- In a web browser, go to https://viewerapps.nationalmap.gov/basicdownloader/.
First, you will constrain your downloads to your area of interest.
- In the 'Area of Interest' section, use the 'Map Extent/Geometry' drop-down menu button to select Selectable Polygon.
- Use the 'Select...' drop-down menu to select 8-digit HU (Subbasin).
- At the top right of the map, in the 'Find address or place' search box, type “Houston” and press Enter.
- On the left side bar, check the ElevationProducts(3DEP) section to expand it.
- Within the Product Search Filter, check1/3 arc-second DEM for the subcategory and selectArcGrid for the File Format.
- On the left side bar, scroll below the Elevation Products section and check the Hydrography (NHDPlus HR, NHD, WBD) section to expand it.
- Within the Product Search Filter, selectNational Hydrography Dataset (NHD) for the subcategory, selectHU-8 Subbasin for the Data Extent and selectFileGDB10.1 for the File Format.
Now you constrain your downloads to your area of interest.
In the search bar just above the map on the right, type “Houston” and clickGo.
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.
- click within within Subbasin 12040104 to to select it.
Notice that just above the map, your search is now constrained to Polygon: huc8 12040104. Near the center of the map, - At the top of the left side bar, clickFindProducts.
You are now provided with a listing of all the DEM tiles covering the area of Subbasin 12040104.
Your data search will now be constrained to the polygon for subbasin 12040104.
Next, you will select the data products you are interested in viewing and downloading.
- On the left side bar, under the 'Data' section, check the Elevation Products (3DEP) section to expand it.
- If necessary, within the 'Subcategories' section, check1/3 arc-second DEM.
- Under the 'File Formats' section, select All, which will make the ArcGrid file format available (rather than only the GeoTIFF and IMG file formats)
- Scroll back to the top of the left side bar and click the Search Products button.
You are now provided with a listing of all the DEM tiles covering the area of subbasin 12040104. Although 12 results are listed, there are only 3 areas of coverage provided in 4 different file formats: ArcGrid, GeoTIFF, GridFloat, and IMG. You will download only the 3 files in the ArcGrid format
- In turn, click Download ZIP for USGS NED 1/3 arc-second 1 x 1 degree ArcGrid 2019 for n30w096, n30w095, and n31w096.
- Once all files have finished downloading, navigate to the location where the three zipped folders have been downloaded. The downloads may take a few minutes to complete.
- Select and copy all three zipped folders.
- Using Windows Explorer, navigate to your HydrologyLab folder.
- Paste all three zipped folders directly inside
- In turn, click Download for USGS NED n30w096, n30w095, and n31w096.
- Navigate to the location where the three zipped folders have been downloaded.
- Select and copyall three zipped folders.
- Using Windows Explorer, navigate to your HydrologyLab folder.
- Paste all three zipped folders directly inside your HydrologyLab folder. Do NOT paste them inside the HydrologyLab.gdb geodatabase folder.
- Select all three zipped folders.
- 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.
- Return to ArcGIS Pro.
- (If you are on a personal computer without 7-Zip installed, then right-click each folder in turn and select Extract All. Leave the default location, which is the same location as the original zipped folder, and click Extract.)
- Return to ArcGIS Pro.
Since you just added new files to your folder, you will need to refresh it in order 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.
- At the bottom of the Geoprocessing pane, click the Catalog tab.
- Double-click Folders > HydrologyLab.
- If you do not see your newly download folders, right-click the
- Click the Project tab on the Catalog pane.
- Right-click your HydrologyLab folder and select Refresh.
- Expandn30w095 and the other all three USGS folders to preview their contents.
...
- Drag the grdn30w095_13 raster into the Map Display Lab2 map view.
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 Displaymap view. 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.
- In the 'Build pyramids' window, click No.
- Repeat the previous two steps Repeat Steps 1 and 2 with the grdn30w096_13 and grdn31w096_13 rasters.
...
- In the Contents pane, double-click the grdn31w096_13 layer to open the 'Layer Properties' window.
...
- In the Source tab, expand the 'Spatial Reference' section.
Notice the Geographic Coordinate System is NAD 1983 and that no projected coordinate system is listed scroll down and notice the spatial reference is listed as GCS_North_American_1983. Since this coordinate system is not the same as the one currently used by the data frame, the raster layer is being projected-on-the-fly into the State Plane Texas South Central projection.
...
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 some information from the original rasters.
- Scroll back to the top of the ‘Layer Properties’ window and expand the 'Raster Information' section.
Notice that there is 1 band, meaning that each pixel only stores a single value: the height above sea level in meters. 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, which indicates that the cells can store decimal data.
- Close the ‘Layer Layer Properties’ window.
- At the bottom of the Catalog pane, click the Geoprocessing tab.
- At the top left of the Geoprocessing pane, click the Back buttonOpen Tools. Click Toolboxes on the geoprocessing pane.
- In the search box, type "mosaic to new raster".
- Click the Data Management Tools toolbox, click the Raster toolset → Raster Dataset toolset → Mosaic to New Raster tool.
- For ‘Input Rasters’, select the three 1x1 degree raster layers.
- For ‘Output Location’, click the Browse button.
- In the bottom right corner of the 'Output Location' window, use the drop-down menu to select File Geodatabases (instead of Folders), if necessary.
- Select the HydrologyLab.gdb Select the HydrologyLab geodatabase and click Add OK.
- For ‘Raster Dataset Name with Extension’, type “DEMMosaic”. No extension is necessary when storing the raster in a file geodatabase.
- Use the ‘Pixel Type’ drop-down menu to select 32 bit float, since that was the same type stored in the original rasters.
- For ‘Number of Bands’, type “1”. (The text appears on the right side of the field.)
- Ensure your ‘Mosaic To New Raster’ pane 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.
- RemoveIn the Contents pane, remove all three original raster files from the Contents panelayers.
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.
- In At the top left of the Geoprocessing pane, click Data Management Tools -> Projections and Transformations toolset -> the Raster toolset Project Raster tool. click the Back button.
- In the search box, type "project raster".
- Click the Project Raster tool.
- Use the ‘Input Raster’ drop-down menu to select the DEMMosaic layerFor ‘Input Raster’, select in the DEMMosaic layer in the drop-down menu.
- For ‘Output Raster Dataset’, rename the raster from “DEMMosaic_ProjectRaster” to “DEMStatePlane” DEMMosaic_ProjectRaster to “DEMStatePlane”
- Use the For ‘Output Coordinate System’ , drop-down menu to select Watersheds_StateplaneStatePlane, which will import the same coordinate system used by that layer.
You should now see the NAD_1983_StatePlane_Texas_South_Central_FIPS_4204_Feet displayed in for the Output Coordinate System.
- 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.
- Leave ‘Output Cell Size’ blank, but type “300” “300” for the ‘X’ and ‘Y’. Make sure that your screen is the same as the screenshot below. Click
- Ensure your Geoprocessing pane appears as shown and 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.
- Remove the DEMMosaic layer from the Contents pane.
...
Now you are ready to clip the DEM mosaic to the Buffalo-San Jacinto subbasin.
- At the top left of the Geoprocessing pane, click the Back button.
- In the search box, type "clip raster".
- Click the Clip Raster toolIn ArcToolbox, back in the Raster toolset, double-click the Raster Processing toolset and click the Clip (Data Management) tool.
- For ‘Input Raster’, drag in the DEMStatePlane layer from the Contents pane select DEMStatePlane.
- For ‘Output Extent’, drag in the select Watersheds_StatePlane layer.
- Check Use Input Features for Clipping Geometry.
...
- For ‘Output Raster Dataset’, rename the raster from “DEMStatePlane_Clip” to “DEMSubbasin”.
- Ensure your ‘Clip’ window Geoprocessing pane appears exactly as shown below and click Run.
- In the Contents pane, remove the DEMStatePlane layer.
- Turn off the Watersheds_StatePlane layer to view the DEMSubbasin layer.
...
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.
- In Geoprocessing At the top left of the Geoprocessing pane, click the Spatial Analyst Tools toolbox, click the Map Algebra toolset, click the Raster Calculator tool the Back button.
- In the search box, type "raster calculator".
- Click the Raster Calculator tool.
- In the list of ‘Rasters’, double-click the DEMSubbasin layer.
- In the calculatorlist of 'Tools', double-click the the * button symbol.
- In the equation box, type “3.281”, which is the conversion factor from meters to feet.
- For ‘Output raster’, rename the raster from “rastercalc” to “DEMft”.
- 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 Contents pane, 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.
- Remove the DEMSubbasin layer from the Contents pane.
...
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.
- Again, go back to In the Raster Calculator tool. Delete , delete the previous expression "DEMSubbasin" * 3.281.
- In the list of 'Rasters’, double-click the DEMft layer.
- In the calculatorlist of 'Tools', double-click the the <= button symbol.
- In the equation box, type “15”.
- For ‘Output raster’, rename the raster from “demftdemft_raster” raster to “Flood15ft”.
- Ensure your ‘Raster Calculator’ window Geoprocessing pane appears as shown below and clickRun.
- In the Contents pane, rightRight-click the Flood15ft layer . Click and select Symbology.
- In the table of valuesSymbology pane, right-click the 0 value and click Remove.
- Click the rectangle symbol to the left of the 1 value and select Blue.
- Save your project.
Now the cells containing an elevation of 15 feet or less are highlighted on top of the elevation raster.
- In the Contents pane, uncheck the Watersheds_StatePlane layer and the Topographic basmap.
- Save your project.
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.
- Click On the ribbon, click the Insert menu tab and select click the New Map button.
- Double-click “Map1” in the contents pane and type “Lab2Topo” as name. Click Save.
- In the Contents pane, rename the map “Lab2Topo”.
- Return to Expand Databases in the Catalog pane. Click
- Expand the HydrologyLab.gdb geodatabase.
- Drag the DEMft and Watersheds_StateplaneStatePlane layers into the Lab2Topo map displayview.
- Turn off the In the Contents pane, uncheck the Watersheds_Stateplane layer.
- Right-click the DEMft layer and click the select Symbology.
- Scroll For ‘Color scheme’, scroll down the ‘Color Ramp’ drop-down menu to the very bottom and select the rainbow ramp Multipart Color Scheme or another continuous color scheme of your choice.
Patterns within the data are now easier to see, especially at the lower elevations.
...
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.
- Open Return to the Geoprocessing pane by clicking Tools from Analysis tab.
- At the top left of the Geoprocessing pane, click the Back button.
- In the search box, type "contour".
- Click the Contour (Spatial Analyst Tools) In the Spatial Analyst Tools toolbox, click the Surface toolset then click the Contour tool.
- For ‘Input raster’, select the DEMft layer.
- For the ‘Output polyline features’, rename the feature class from “Contour“Contour_DEMft1” to “Contours10ft”DEMft1” to “Contours10ft”.
- For ‘Contour interval’, type “10” “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.
- For ‘Base contour’, type “-20”20”.
Since the x,y XY 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 Z units stored within the raster cells to feet, you do not need a custom Z factor.
- For ‘Z factor’, leave the default value of 1.
- Ensure your ‘Contour’ window Geoprocessing pane appears as shown below and clickRun.
- Turn off the DEMft layer to better see the contours.
- Right-click the Contours10ft layer . Clickand select Symbology.
- Use the In the Symbology pane, use the 'Primary symbology' drop-down menu at the top to select Unique values.
- Use the ‘Value Field’ ‘Field 1’ drop-down menu to select the Contour field.
- Use At the bottom of the ‘Color Ramp’ scheme’ drop-down menu. Check, check Show All and select one one of the few graduated continuous color ramps schemes, as shown below.
Now you can tell which contours are highest and lowest.
- Turn In the Contents pane, turn off and collapse the Contours10ft layer.
- 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.
- Return to the Geoprocessing pane.
- At the top left of the Geoprocessing pane, click the Back button.
- In the search box, type "hillshade".
- Click the Hillshade (Spatial Analyst Tools) toolOpen Geoprocessing pane by clicking Tools from Analysis tab.
- In the Surface toolset, double-click the Hillshade tool.
- For ‘Input raster’, select the DEMft layer.
- For ‘Output raster’, rename the raster from “HillSha“HillSha_DEMf1” to “Hillshade”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 itself. To compensate visually for the flat terrain, you will exaggerate the vertical elevations.
- For ‘Z factor’, type “20”.
- 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.
- In the Contents pane, drag the Hillshade layer beneath the DEMft layer, but above the Topographic basemap.
- In the Contents pane, select the DEMft layer.
- In the ribbon, click the contextual Appearance tab.
- In , 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.
- Turn on the Watersheds_StatePlane layer.
- Symbolize the Watersheds_StatePlane layer with no transparency, a hollow fill, and thick black outline.
As a final touch, you will add the flowlines you downloaded in Lab1 Lab 1 to your Map Display.
- Click the Catalog tab.
- In the HydrologyLab geodatabase, drag the Flowlines feature class into the Map Display Lap2Topo map view.
- In the Contents pane, drag the Flowlines layer above the DEMft layer, but beneath the Watersheds_StatePlane layer.
- Symbolize the Flowlines layer with a thin blue line.
- Save your map document project.
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.
- Return to the Geoprocessing pane.Open Geoprocessing pane
- by clicking Tools from Analysis tabAt the top left of the Geoprocessing pane, click the Back button.
- In the search box, type "zonal statistics".
- Click the Spatial Analyst Tools toolbox, double-click the Zonal toolset then click Zonal Statistics as Table (Spatial Analyst Tools) tool.
- For Use the ‘Input raster or feature zone data’ , use the drop-down menu to select the Watersheds_StatePlane layer.
- Use the For ‘Zone field’ drop-down menu to , select the ‘HU‘HU_10_NAME’ NAME’ field.
- For ‘Input value raster, select the DEMft layer.
- For ‘Output table’, rename the table from “ZonalSt“ZonalSt_Watersh1” to “WatershedElevation”Watersh1” to “WatershedElevation”.
- Ensure your ‘Zonal Statistics as Table’ window Geoprocessing pane appears as shown and click Run.
- 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.
- In the Geoprocessing pane, search for ‘Table to Excel’"table to excel’.
- Click the Table To Excel tool.
- For the 'Input Table', select ‘WatershedElevation’ from the drop-down menu WatershedElevation.
- 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.
- Save the table within the HydrologyLab Locate and double-click the HydrologyLab folder to save the file within the folder.
- For ‘Name’, name as “WatershedElevation” type “WatershedElevation”.
- Click Save.
- In the ‘Table to Excel’ windowGeoprocessing pane, click Run.
- Close the Table WatershedElevation table.
Now you will open the exported text file in Excel.
- Open Using File Explorer, open your WatershedElevation.xls spreadsheet in Microsoft Excel.
- Delete the OBJECTID, ZONE_CODE, COUNT, AREA, and SUM fields.
- Highlight the minimum and maximum values in each column.
...
- Click the File menu and select Save As.
- Navigate to your HydrologyLab folder.
- For ‘File name:’, type “WatershedElevation” “WatershedElevation”.
- Use the ‘Save as type:’ drop-down menu to select Excel Workbook (*.xlsx).
- 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.
Part 3: Downloading rainfall data
...
Now you will download rain gauge station data created by the National Climatic Data Center (NCDC) using the Climate Data Online (CDO) interface.
- In a web browser, go to www.ncdc.noaa.gov/cdo-web/.
- 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).
- On the Surface Maps tab, click Normals.
- In the left sidebar, on the Layers tab, uncheck Daily Daily Climate Normals, and check Annual Annual Climate Normals.
- To the right of Annual Climate Normals, click the Map Tools button.
- In the new ‘ANNUAL CLIMATE NORMALS TOOLS’ window, click Location Location.
- Use the drop-down menu to select USGS USGS HUC.
- Use the ‘Select a HUC type’ drop-down menu to select Subregions Subregions (4-digit).
- Use the ‘Select a HUC’ drop-down menu to select Galveston Galveston Bay-San Jacinto.
- Click Zoom to location.
- The left sidebar switches to the Results tab. Click Get All Location Data.
- For Step 1, select Custom Annual/Seasonal Normals CSV for the output format and click CONTINUE.
- For ‘Station Detail & Data Flag Options’, check Station name Station Name, Geographic locationLocation, and Include data flags Data Flags to include those variables the data table.
- For ‘Select data types for custom output’, clickexpand the Annual Precipitation category to expand it.
- Check Long Long-term averages of annual precipitation totals (ANN-PRCP-NORMAL).
- At the bottom of the window, click CONTINUE CONTINUE.
- Type your email address twice and click SUBMIT 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.
- In your email, click the Download link to download the requested CSV file.
Excel
- Navigate to the location where the CSV file was stored.
- 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 elevationlatitude, latitudelongitude, and longitude elevation 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 Datasets portion of the CDO website. The annual precipitation field "
Info |
---|
As of March 7, 2021, the CSV download includes ALL climate variables, even though only ANN-PRCP-NORMAL |
...
was selected for download. In this case, the annual precipitation field, ANN-PRCP-NORMAL, will not appear in column F, after the ELEVATION field. Instead, it appears in column BP. In this case, you will need to copy and paste the data from column BP to column F. |
Before opening this table in ArcGIS, you must reformat some of the field names, which cannot have special characters and must are recommended to be 13 characters or less.
- Rename “ANN-PRCP-NORMAL” to “ANNPRCPHIANNPRCP_HI”, for annual precipitation in hundredths of inches.
- Along the top of the worksheet, drag across the column letters to select columns A through H F.
- Copy the selected columns.
- At Along the bottom left of the worksheet, click click the "plus" icon to New sheet button
to create a new sheetworksheet. In the cell A1 cell, paste your previously copied columns.
- Delete the previous sheet.
- Along the top of the worksheet, drag across the drag across the column letters to select columns A through H F.
- Hover your mouse between columns G E and H F until the cursor changes to two outward facing arrows and double-click to auto-size the column widths.
- At the bottom left of the worksheet, rename the worksheet “PrecipStations”from Sheet1 to “PrecipStations”.
- Click the File menu and select Save As.
- Navigate to your HydrologyLab folder.
- For ‘File name:’, type "PrecipStations".
- Use the ‘Save as type:’ drop-down menu to select Excel 97-2003 Workbook.
- Click Save.
- 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.
- Return to ArcGIS Pro.
- Click On the Insert menu and select ribbon, click the Insert tab and click the New Map button.
- Click “Map1” in In the contents Contents pane to rename it as “Lab2Precip”. Click Save, rename the map “Lab2Precip”.
- Return to the Catalog pane.
- Drag Watersheds_Stateplane onto StatePlane into the Lab2Precip map displayview.
- Click the Geoprocessing tab and search for ‘Excel to Table’.
- For the Input Excel File, selectPrecipStations. Rename the output table PrecipStations.
- Click Run.
- Right-click the HydrologyLab folder and select Refresh.
- Expand the PrecipStations.xlsx Excel file to see the individual worksheets it contains.
- Drag the PrecipStations$ worksheet into the Lab2Precip map view.
- In the Contents pane, right-click the PrecipStations PrecipStations$ table and select Display XY Data.
- For ‘X Field:’, select the LONGITUDE field.
- For ‘Y Field:’, select the LATITUDE field.
- 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.
...
- For 'Coordinate System', click the Select coordinate system button.
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.
- Scroll towards the top of the 'XY Coordinate Systems Available'.
- Ensure that Geographic Coordinate Systems is already expanded, then expand North America > USA and Territories.
- Select NAD 1983 and click OK.
- Ensure that your window matches that below and click OK.
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.
- In the Contents pane, right-click the PrecipStations$ table and select
...
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.
- 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.
...
Since you are now using a permanent feature class, you may remove your temporary Events layer and the corresponding Excel table.
- Right-click the PrecipStations_Layer layer and selectRemove.
- Right-click the PrecipStations table and selectRemove.
Projecting vector data
Repeating the technique you learned earlier in this lab to project vector data, project the PrecipStations_XYTableToPoint layer into the State Plane Texas South Central projection.Save the resulting feature class and name it “PrecipStations_StatePlane”. Remove the original PrecipStations_XYTableToPoint layer from the Contents pane.
...
- In the Contents pane, Ctrl-select the PrecipStations_StatePlane and Watersheds_StatePlane layers.
- Right-click either selected layer and selectZoom To Layers.
- Open Geoprocessing pane by clicking Tools from Analysis tab.
- Return to the Geoprocessing pane.
- At the top left of the Geoprocessing pane, click the Back button.
- In the search box, type "thiessen".
- Click the Create Thiessen Polygons toolDouble-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 Thiessen polygons are calculated for the entire region that you just zoomed to.
- At the top of the Geoprocessing window, click the Environments tab on the right.
- Under the 'Processing Extent' section, for 'Extent', select Current Display Extent.
- At the top of the Geoprocessing window, return to the Parameters tab on the leftFor Extent, use the drop-down menu to select Current Display Extent and go back to Parameters.
- For ‘Input Features’, drag in the select the PrecipStations_StatePlane layer.
- For ‘Output Feature Class’, rename the feature class from “PrecipStations_StatePlane_Cr” to “PrecipThiessen”.
- Use the For ‘Output Fields’ drop-down menu to select, select All fields.
- 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.
- 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.
- Close the Table PrecipThiessen attribute 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.
- At the top left of the Geoprocessing pane, click the Back button.
- In the search box, type "intersect".
- Click the Intersect toolIn the Analysis Tools toolbox, click the Overlay toolset then the Intersect tool.
- For ‘Input Features’, drag in the select the PrecipThiessen and the Watersheds_StatePlane layers.
- For ‘Output Feature Class’, rename it from “PrecipThiessenPrecipThiessen_Intersect” Intersect to “ThiessenWatershedIntersect”“ThiessenWatershedIntersect”.
- Ensure your ‘Intersect’ window appears as shown below and click Run.
- Remove In the Contents pane, remove the PrecipThiessen layer from the Contents pane.
- 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.
- Open the ThiessenWatershedIntersect layer attribute table.
Notice that the original 8 watersheds have now been divided into 42 41 sections indicating which areas of each watershed are closest to each rain gage. Let Pk denote the annual precipitation associated with each rain gage and Aik 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.| - At the top left of the attribute table, click the Click Add Field… button on top , which will open up the Fields view of the table display.
- For ‘Name:’, type “APProd”At the bottom of the Fields table, rename the new field from Field to “APProd”.
- Use the ‘Type:’, ‘Data Type’ drop-down menu to select Double and click.
- On the Ribbon, on the Fields tab, click the Save button.
- Close the Fields view of the table.
- Scroll to the far right of the ThiessenWatershedIntersect table. Save on the Fields tab.
- Right-click the APProd field name and select Calculate Field.
- Using the fields and buttons or by typing, enter “!ANNPRCPHI! * !Shape_Area!”.
- Calculate Field.
- In the 'Fields' list, double-click ANNPRCP_HI.
- Underneath the 'Helpers' list, click the * button.
- In the 'Fields' list, double-click Shape_Area.
Ensure your ‘Calculate Field’ window Ensure your ‘Field Calculator’ appears as shown below and click Run OK.
...
The APProd field now contains the numerator values in the equation. You are now ready to summarize the calculated statistics by watershed.
...
Right-click the HU_10_NAME field name and select Summarize… Summarize.
- For ‘Output Table’, rename the table from ThiessenWatershedInteract_S to “WatershedPrecip”.
For statistics fields'Statistics Field(s)', use the drop-down menu to select the Shape_Area field and select Sum.
- Select the APProd field and select Sum.
- For ‘Output Table’, rename the table from “ThiessenWatershedInteract_St” to “WatershedPrecip”.
'Field' and the Sum 'Statistic Type'.
- For the second statistics field, select the APProd 'Field' and the Sum 'Statistic Type'.
- Ensure the 'Case field' is the HU_10_NAME field, which will summarize the statistics by watershed.
- Ensure your 'Summary Statistics" Ensure your ‘Summarize’ window appears as shown below and click Run OK.
The resulting table gives the numerator and denominator in the equation for each watershed.
- 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.
...
Now you will calculate precipitation for each watershed using a different interpolation method.
- Close the WatershedPrecip table and the ThiessenWatershedIntersect attribute table.
- Turn off the ThiessenWatershedIntersect layer.
- Right-click the Watersheds_StatePlane layer and select Zoom to Layer.
- Open ToolboxAt the top left of the Geoprocessing pane, click the Back button.
- In the search box, type "spline".
- Click the Spline (Spatial Analyst Tools toolbox, click the Interpolation toolset then the Spline ) tool.
- On At the top of the Geoprocessing window, click the Environments. click the Environments tab on the right.
- Under the 'Processing Extent' section, for 'Extent', select For Extent, use the drop-down menu to select Current Display Extent.
- Use the ‘Mask’ drop-down menu to select the Watersheds_StatePlane layer.
- Under the 'Raster Analysis' section, for ‘Mask', select the Watersheds_StatePlane layer, which will clip the resulting raster.
- At the top of the Geoprocessing window, return to the Parameters tab on the left.
- Go back to Parameters. For ‘Input point features’, drag in the select the PrecipStations_StatePlane layer.
- Use the For ‘Z value field’ drop-down menu to , select the ANNPRCPHI ANNPRCP_HI field that contains the values you wish to interpolate.
- For ‘Output raster’, rename the exported raster from “Spline_Preci1” to “AnnPrecip” Spline_Preci1 to “AnnPrecip”.
- Use the For ‘Spline type’ drop-down menu to select TENSION, select Tension.
- Ensure your ‘Spline’ window Geoprocessing pane 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 ThiessenWatershedIntersect polygons back on to and give them a hollow fill. Also symbolize the Watersheds_StatePlane layer and put it on top of the Thiessen layer. Symbolize the rain gages as you desire.
...
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.
...