CE 547: Assignment 5

The purpose of this homework was to isolate the Pecos watershed from greater the Rio Grande basin, and import USGS stream gage location data and USGS stream flow data. After watershed boundaries were delineated and data imported a time series was run.

To accomplish this homework the following steps were performed:

1. Acquiring and preparing data

a. Data was downloaded HW5 Geodatabase from CEGIS FTP account. The “HUC250K” layer was added, displaying all national basins. To isolate the Rio Grande basin, right click Properties>Defintion Query tab>Query Builder. In the Query Builder dialogue box enter “REG”=’13’ using tools, not key commands.

b. With the Rio Grande basin isolated, change the symbology. Right click “HUC250K” go to Properties tab>Symbology. Click Categories>Unique Values. In Value Field select “SUB”, click Add All Values, choose appropriate color ramp.

c. Add Reservoirs and Streams layers. Change Reservoir symbol to more visually appropriate symbol.

d. To isolate the Pecos basin click Selection>Select by Attributes and click to create the following query: “CAT” = '13060001’ Export selected data, right click “HUC250K” click Data>Export Data to save new shapefile. Add new shapefile to map.

e. To include streams and reservoirs in the Pecos basin. Click Select by Location, check Reservoirs, Streams, select Pecos as source layer. Not all streams and sub basins will be included I selection. To include click Select Features by Rectangle tool and manually select basins and streams not included in current Pecos Basin layer. Add selected features to Pecos basin layer. Export, save, and display the new shapefile.

2. Preparing and adding Stream gage data

a. To obtain spatial data, go to NM state USGS data page: http://nm.water.usgs.gov/. Click Historical Data>Streamflow, select Annual, set Site Selection Criteria to Hydrologic Unit. Submit. On following page select Stream as site type, select Streamflow as parameter, and using Ctrl key, select number, name, decimal latitude, decimal longitude, altitude, and datum. Submit, save file as PecosHWSites.txt.

b. At same webpage click Retrieve USGS Surface-Water Annual Statistics for Selected Sites. On following page check boxes next to all sites, do not fill in data range, download as tab-separated file. Save file as PecosHWData.txt.

c. To prepare data for import open PecosHWSites.txt in Excel. Delete headers and extra rows, save as xlsx document.

3. Importing and using data in ArcMap

a. To add gage sites, click File>Add Data>Add XY Data. Select PecosHWSites file, for X Field select dec_long_va, for Y Field select dec_lat_va, for Z Field select alt_va. Use NAD 1983.prj Geographic Projection.

b. To add temporal data, right click HW5 geodatabase click Import>Table(Single), select PecosHWData.xlsx file. Temporal data is now displayed under Table of Contents.

c. To join spatial/temporal data right click recently added layer go to Joins and Relates>Join. Join by Feature ID.

d. To display temporal locations right click Display XY data and follow directions in 3:a.

e. Export new layer to HW5 Geodatabase.

f. To start time viewing right click PecosHWDischarge, click Time tab, enable time, use “year_nu” as time field, use “yyyy” as time field, use time step interval “1” set to “years”, select UTC Mountain Time. Click OK. Open time slider tool to run animation.