SOFIA Environmental Database Development and Maintenance

Metadata:

• Identification_Information
• Data_Quality_Information
• Distribution_Information
• Metadata_Reference_Information

Identification_Information:

Citation:

Citation_Information:

Originator: Roy Sonenshein

Publication_Date: Unpublished Material

Title: SOFIA Environmental Database Development and Maintenance

Online_Linkage: <http://sofia.usgs.gov/projects/sofia/>

Description:

Abstract:

The long-term goal of the SOFIA program is to provide a central archive of data and products for all Department of Interior products related to the south Florida Ecosystem restoration program.

The primary objectives of this project are 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 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.

Purpose:

The South Florida restoration effort requires multidisciplinary information relating to present and historical conditions for use in responsible decision-making. The South Florida Information Access (SOFIA) database is the cornerstone of information management for the South Florida place-based science program.

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.

Time_Period_of_Content:

Time_Period_Information:

Range_of_Dates/Times:

Beginning_Date: 20011001

Ending_Date: Unknown

Currentness_Reference: publication date

Status:

Progress: In Work

Maintenance_and_Update_Frequency: As needed

Spatial_Domain:

Bounding_Coordinates:

West_Bounding_Coordinate: -82.375

East_Bounding_Coordinate: -80

North_Bounding_Coordinate: 28.5

South_Bounding_Coordinate: 24.5

Keywords:

Theme:

Theme_Keyword_Thesaurus: none

Theme_Keyword: information management

Theme_Keyword: database

Theme:

Theme_Keyword_Thesaurus:

Geographic Data - Metadata, ISO 19115:2003(E), TopicCategoryCode, 2003, International Organization for Standardization (ISO), Geneva, Switzerland

Theme_Keyword: environment

Theme_Keyword: 007

Place:

Place_Keyword_Thesaurus:

Department of Commerce, 1995, Countries, Dependencies, Areas of Special Sovereignty, and Their Principal Administrative Divisions, Federal Information Processing Standard (FIPS) 10-4, Washington, D.C., National Institute of Standards and Technology

Place_Keyword: United States

Place_Keyword: US

Place:

Place_Keyword_Thesaurus:

U.S. Department of Commerce, 1987, Codes for the identification of the States, the District of Columbia and the outlying areas of the United States, and associated areas (Federal Information Processing Standard 5-2): Washington, D. C., NIST

Place_Keyword: Florida

Place_Keyword: FL

Place:

Place_Keyword_Thesaurus:

Department of Commerce, 1990, Counties and Equivalent Entities of the United States, Its Possessions, and Associated Areas, FIPS 6-3, Washington, DC, National Institute of Standards and Technology

Place_Keyword: Broward County

Place_Keyword: Charlotte County

Place_Keyword: Collier County

Place_Keyword: Hendry county

Place_Keyword: Highlands County

Place_Keyword: Lee County

Place_Keyword: Martin County

Place_Keyword: Monroe County

Place_Keyword: Miami-Dade County

Place_Keyword: Okeechobee County

Place_Keyword: Osceola County

Place_Keyword: Palm Beach County

Place_Keyword: Polk County

Place_Keyword: St. Lucie County

Place_Keyword: Indian River County

Place:

Place_Keyword_Thesaurus: none

Place_Keyword: Central Everglades

Place_Keyword: Kissimmee Valley

Place_Keyword: Greater Lake Okeechobee

Place_Keyword: Florida Keys

Place_Keyword: South East Coast

Place_Keyword: SW Big Cypress

Access_Constraints: none

Use_Constraints: none

Point_of_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Roy S. Sonenshein

Contact_Organization: U.S. Geological Survey

Contact_Position: Project Chief

Contact_Address:

Address_Type: mailing address

Address: 9100 NW 36th Street Suite 107

City: Miami

State_or_Province: FL

Postal_Code: 33178

Country: USA

Contact_Voice_Telephone: 305 717 5824

Contact_Facsimile_Telephone: 305 717 5801

Contact_Electronic_Mail_Address: sunshine@usgs.gov

Browse_Graphic:

Browse_Graphic_File_Name: <http://sofia.usgs.gov/aboutsofia.html>

Browse_Graphic_File_Description: map showing the location of the study area

Browse_Graphic_File_Type: GIF

Data_Set_Credit:

Project personnel include Bruce Irvin, Cortney Mills, Tarla Toomer, Tim Boozer, Joann Dixon, and Sandy Womble.

Data_Quality_Information:

Logical_Consistency_Report: not applicable

Completeness_Report: not available

Lineage:

Process_Step:

Process_Description:

Design, maintenance, and population of the database

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.

Process_Date: Not complete

Process_Step:

Process_Description:

Collect data and prepare metadata records:

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.

Process_Date: Not complete

Process_Step:

Process_Description:

Prepare atlas of USGS data collection sites

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.

Process_Date: Not complete

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Roy S. Sonenshein

Contact_Organization: U.S. Geological Survey

Contact_Position: Project Chief

Contact_Address:

Address_Type: mailing address

Address: 9100 NW 36th Street Suite 107

City: Miami

State_or_Province: FL

Postal_Code: 33178

Country: USA

Contact_Voice_Telephone: 305 717 5824

Contact_Facsimile_Telephone: 305 717 5801

Contact_Electronic_Mail_Address: sunshine@usgs.gov

Distribution_Information:

Distributor:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Roy Sonenshein

Contact_Organization: U.S. Geological Survey

Contact_Position: Database Manager

Contact_Address:

Address_Type: mailing address

Address:

9100 NW 36th Street

Suite 107

City: Miami

State_or_Province: FL

Postal_Code: 33178

Country: USA

Contact_Voice_Telephone: 305 717-5824

Contact_Facsimile_Telephone: 305 717-5801

Contact_Electronic_Mail_Address: sunshine@usgs.gov

Resource_Description: SOFIA database

Distribution_Liability:

There are no warranties implied or explicit in the use of the data in the SOFIA database.

Standard_Order_Process:

Digital_Form:

Digital_Transfer_Information:

Format_Name: PostgreSQL

Digital_Transfer_Option:

Online_Option:

Computer_Contact_Information:

Network_Address:

Network_Resource_Name: <http://www.envirobase.usgs.gov/>

Access_Instructions: Log onto the SOFIA website at <http://sofia.usgs.gov>.

Fees: none

Metadata_Reference_Information:

Metadata_Date: 20040803

Metadata_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Jo Anne Stapleton

Contact_Organization: U.S. Geological Survey

Contact_Address:

Address_Type: mailing address

Address: 521 National Center

City: Reston

State_or_Province: VA

Postal_Code: 20192

Country: USA

Contact_Voice_Telephone: 703 648-4592

Contact_Facsimile_Telephone: 703 648-4614

Contact_Electronic_Mail_Address: jastapleton@usgs.gov

Metadata_Standard_Name: Content Standard for Digital Geospatial Metadata

Metadata_Standard_Version: FGDC-STD-001-1998

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.11 on Tue Aug 03 14:18:25 2004