The primary objectives of this project were to 1) provide a central location for the archive of all products and data collected as part of the USGS PES program and related work for the restoration of the South Florida Ecosystem; and 2) provide a means for customers to obtain the archived information. The database was been developed using PostgreSQL, an open source relational database management system. PostgreSQL was selected because it is freely available, widely used, actively maintained and supported, and runs on all modern UNIX-like and Windows based computer systems. As projects were completed or data sets were made available to the public, the data was to be loaded into the database.
Responsible resource management requires a firm scientific basis for decision making. The SOFIA database will provide hydrologic, cartographic, geologic, and biologic data and metadata to aid in the decision process. Ecosystem restoration and sound resource management will benefit south Florida by allowing a balance of uses and interests. The data are available to Federal, State, and local agencies through a web interface and can be retrieved from the SOFIA database. The database has been redesigned to provide storage and access to a greater variety of data types. A new web-based interface will be developed to provide access to the database. The interaction between the database, the other SOFIA products, and other available web-based databases is being evaluated. The database will be updated to provide greater interoperability between the database, other SOFIA products and other web-based databases.
1. Update the database structure as needed to handle new types of data that currently do not fit into the database structure. 2. Load new data sets into the database as they become available.
1. Obtain published data sets and other released data sets. 2. Rework data sets if necessary to prepare in the form required to enter into the database. 3. Reformat data as needed to prepare for dissemination on the Data Exchange web site. 4. Prepare metadata records for all data sets to be placed on the Data Exchange.
1. Prepare GIS base maps and standard template to be used for Atlas maps. 2. Design report, deciding on which data sets to include on the maps, and how to organize the maps. 3. Prepare the text to include with each map. 4. Get the report reviewed and published.
U.S. Department of the Interior, U.S. Geological Survey, Center for
Coastal Geology
Comments and suggestions? Contact: Heather
Henkel - Webmaster
Generated by mp version 2.8.18 on Fri Mar 09 17:54:39 2007