This page describes the USC's Wetlands data management system. Key components of this system include:
The Upper Susquehanna Coalition has an integrated data management system for cataloging all types of wetland data pertaining to our Wetland Program. Using the architecture of the ArcGIS geodatabase as a data model for representing geographic information with standard relational database technology, as well as the power and versatility of Microsoft Access, we have created a functional system for managing all types of wetland-related data.
The base data structure is built around the best surface hydrological data available. Using the National Hydrography Dataset as the foundation, we have added the National Wetlands Inventory data along with the New York State Regulated Wetlands data. From there we have added a coverage of wetlands and waterbodies that were previously un-mapped, digitized from 2001-2006 digital ortho-photography, including created and restored wetlands, vernal pools and farm ponds.
Using ESRI's ArcGIS software we created a customized data entry and editing package of tools. Microsoft Access provides the database management tools allowing us to create customized data queries and reports.
The graphics below show the basic architecture of the personal geodatabase and how it stores both spatial and tabular data.
THE GEODATABASE STRUCTURE
The screenshots below show the Geodatabase structure of the actual wetland database as shown in ArcCatalog and Microsoft Access. The geodatabase is made up of feature datasets containing feature classes, tables, and relational indexes.