The National Hydrography Dataset in SDE: An Event and Application Friendly Dynamic Segmentation Database Implementation

Author: Steve S Andrews
Organization: INDUS Corporation

1953 Gallows Rd
Suite 300
Vienna, VA 22182
USA

Phone: 703-506-6700
Fax: 703-506-6776
sandrews@induscorp.com

The U.S. Environmental Protection Agency (EPA) and INDUS Corporation have developed an Oracle SDE database for the National Hydrography Dataset (NHD). The database is optimized to support dynamic segmentation operations, specifically addressing, storing, and displaying event data addressed to the NHD reach network. The NHD, combined with monitoring, pollutant source, and lake and stream use data addressed to the NHD, provides many analysis opportunities. The NHD supports many water network navigation tools, and these navigation tools, in turn, support modeling of lake and stream conditions. We'll discuss implementing, tuning, and maintaining a national SDE database with over two million reaches and millions of events to support MapObjects, ArcView GIS, and ArcInfo applications in these analysis areas.