SAHRA Hydro DataBase

1
SAHRA Hydro DataBase

• SAHRA DB Team

2
Geodatabase Design and Implementation Steps

• Database Concept
• Identity (web-based, multi-user, public)
• Geographical extent
• Data types (feature classes) and sources
• Feature datasets
• Logical design
• Database structure
• Spatial properties (relationship and topology)
• Database design
• Implementation
• Data model and database schema
• Data (obtain, DQC, load)
• Build relationships
• Test and revise model
• Data access
• Visualization
• Retrieval

3
DB Survey Summary

• Brief description of data you have
• Rio Puerco and JamezRiver, some Sevilleta
• Rio Salado (DEM 30m TIN spring info within the
  Sevilleta Hydrology is from high res HUC
  Climate time series VEMAP, all are free
  somewhere)
• Surface water, groundwater and climate data for
  the entire Rio Grande on a monthly time step and
  spatially aggregated by the major gauging
  stations
• Monthly flow data from aggregation of daily USGS
  gage data from URGWOM modeling group
• Crop types in Middle Rio Grande by reach from ET
  Toolbox 1975-2000.
• Climate data in Middle Rio Grande by reach from
  ET Toolbox 1975-2000.
• Watershed and sub-watershed maps from Bart
  Nijssen, 1/8 degree resolution.
• Reservoir and diversion information from URGWOM
  1975-2000 daily, converted to monthly

4
DB Survey Summary cont.

• Suggested data sources
• INRAM project has NEXRAD data from 1994 to 2003
  (Jan Hendrickx NMT)
• rgis.unm.edu (New Mexico and Rio Grande some)
• Wells from Rolf
• USGS Hydrology data
• Daily climate data NCDC
• Data from Mauer et al (2002) Long term
  hydrologically based datasets of land surface
  fluxes and states for the conterminous United
  States, J.Climate, 153237-3251
• NCAR Mass Storage System (D.J.Gochis can arrange
  access for SAHRA)
• http//www.spa.usace.army.mil/urgscripts/getData.p
  l 1985 - 2000 daily data.
• http//www.usbr.gov/pmts/rivers/awards/Nm/riogrand
  e.html Historic climate data including potential
  ET
• http//rgis.unm.edu/clearinghouse.cfm Geospatial
  clearinghouse for NM

5
DB Survey Summary cont.

• Data to be obtained
• Irrigation data baseline irrigation schedules,
  crop type, crop coefficients, source water for
  irrigation - groundwater level time series
• Remote sensing data (brightness temperature, soil
  moisture retrievals)
• Riparian, municipal, open-water evaporation

6
Geodatabase Data model and Tools

• Data Models
• Arc Hydro
• Maidment D.R. Arc Hydro, GIS for water resources.
  ESRI Press, 2002
• Arc Hydro Groundwater
• Strassberg G. et al. http//www.crwr.utexas.edu/gi
  s/gishydro04/index.htm
• Modification of Arc Hydro (non hydro data)
• Tools
• Software
• ArcGIS 9
• ArcSDE
• ArcIMS
• Oracle database
• MS Access (for prototype)
• Arc Hydro, WRAP Hydro, TS Viewer
• GIS Hydro 2004 http//www.crwr.utexas.edu/gis/gish
  ydro04/index.htm
• http//www.crwr.utexas.edu/gis/gishydro03/WRAPhydr
  o/WRAPhydro.htm

7
Geographical Extent
8
SAHRA Hydro Database Datasets
9
SAHRA Hydro Database Datasets cont.
10
SAHRA Hydro Database Datasets cont.
11
SAHRA Hydro Database Datasets cont.
12
SAHRA Hydro Database Datasets cont.
13
Time Table
14
Additional Data Sources

• Social Demographic Data
• NM http//www.unm.edu/bber/socdata.htm
• NM http//www.unm.edu/bber/demograp2.htm
• AZ http//www.census.gov/census2000/states/az.htm
  l
• http//www.geolytics.com/Default.asp
• AmeriFlux Data
• http//public.ornl.gov/ameriflux/
• MODIS
• http//www.modis.ornl.gov/modis/index.cfm
• Stream Flow
• http//waterdata.usgs.gov/nwis/rt
• http//www.dwr.state.co.us/Hydrology/flow_search.a
  sp

15
END