Home Archived October 29, 2018

South Florida Information Access (SOFIA)

projects > south florida information access > work plan

Project Work Plan

U.S. Geological Survey, Greater Everglades Priority Ecosystems Science (GE PES)

Fiscal Year 2005 Study Work Plan

Study Title: South Florida Information Access/Environmental Database Development and Maintenance
Study Start Date: 10/1/1995 Study End Date: ongoing
Web Sites: http://sofia.usgs.gov
Location (Subregions, Counties, Park or Refuge): Total System
Funding Source: USGS Greater Everglades Priority Ecosystems Science (GE PES)
Other Complementary Funding Source(s): None
Principal Investigator(s): Roy Sonenshein
Study Personnel: Tarla Toomer, Cortney Mills
Supporting Organizations: None
Associated / Linked Studies: SOFIA web site

Overview & Objective(s):

The primary objectives of the project are to 1) provide a central location for the archive of all products and data collected as part of the USGS PBS 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 has 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 are completed or data sets are made available to the public, the data is loaded into the database. To provide easy access to the data, the data sets are also loaded onto the SOFIA Data Exchange web site. The Data Exchange is a partial solution to the data access, however, as the number of data sets grows, it becomes more difficult to locate data on the Data Exchange. Data that is available on other USGS public databases, such as NWISweb, is generally not entered into the SOFIA database. However, the data may be inventoried in the database and will be accessible through the search engine. Products, such as publications and maps, that are available on the web, either on the SOFIA web site or other USGS web sites, are also being inventoried in the database, allowing the user to search for this information.

We would like to begin collecting data sets from other DOI agencies (NPS, USFWS) that are working in south Florida, post the data sets on the data exchange web site, and enter the data sets into the SOFIA database.

Specific Relevance to Major Unanswered Questions and Information Needs Identified:

This study potentially will support all restoration related activities. SOFIA provides an archive of USGS data. These data sets are needed by many of the restoration projects to assist in the management decisions and the science activities of the projects.

Status: The database has been completed, documentation for the database should be completed early in FY05.

Recent Products: None

Planned Products: None


Title of Task 1: Maintenance, and Population of Database
Task Funding:
USGS Greater Everglades Priority Ecosystems Science (GE PES)
Task Leaders: Roy Sonenshein
Phone: 305-717-5824
FAX: 305-717-5801
Task Status (proposed or active): active
Task priority: High
Time Frame for Task 1: ongoing
Task Personnel: Tarla Toomer, Cortney Mills

Task Summary and Objectives:

Work to be undertaken during the proposal year and a description of the methods and procedures: Populate the database with PES and related data sets. Prepare output data sets for release on SOFIA data exchange. Data sets will be prepared by data type, which is currently not available on SOFIA. The current data sets on SOFIA are only by project. Additionally, the data exchange will be updated with new project data sets as they become available. Metadata records will be prepared for data sets and new projects. The SOFIA GIS web site will be released early in FY05 and will be updated as needed.

Specific Task Product(s): New data exchange web pages with data sets and metadata; GIS web site

| Disclaimer | Privacy Statement | Accessibility |

U.S. Department of the Interior, U.S. Geological Survey
This page is: http://sofia.usgs.gov/projects/workplans05/sofiadb.html
Comments and suggestions? Contact: Heather Henkel - Webmaster
Last updated: 04 September, 2013 @ 02:08 PM(TJE)