New York Bight Study. Report 4. Geographic Information Systems and RelationalDatabase Management System Development

摘要

The general objective of the information management component of the New YorkBight Study was to develop a District-based system (a geographic information system or GIS) to store, manipulate, and analyze the data sets associated with and developed by the New York Bight study. To accomplish this objective, the following efforts were required: database development, hardware/software acquisition, system installation, input of database attributes and graphic elements, and training of New York District personnel. Intergraph hardware and software were chosen as the system platform. Oracle database software was selected because it is one of the more common relational database management systems that provides comprehensive relational database (RDB) functions and data storage capabilities. The selection of a base map projection and coordinate system was one of the first decisions made in the process of loading graphic data. Several files were loaded into the system including: digitized shoreline files, graphic representations of gauge locations, tide data, satellite images, model output for water surface elevation, temperature, salinity, and dissolved oxygen, wave hindcast data, and ship observation data. Appendix A presents a basic user training guide. Project training was focused to create geographic map displays from measured data and model output, and to perform analyses on these data. Training was performed in the manner that reflected the types of projects undertaken by the New York District and addressed problems or questions of interest to the New York District. Geographic information system, New York bight, Intergraph, Relational database.