Home Archived October 29, 2018

SOFIA Environmental Database Development and Maintenance

Metadata also available as - [Outline] - [Parseable text] - [XML]

Frequently-anticipated questions:

What does this data set describe?

Title: SOFIA Environmental Database Development and Maintenance
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 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.

  1. How should this data set be cited?

    Sonenshein, Roy, Unpublished Material, SOFIA Environmental Database Development and Maintenance.

    Online Links:

  2. What geographic area does the data set cover?

    West_Bounding_Coordinate: -82.375
    East_Bounding_Coordinate: -80
    North_Bounding_Coordinate: 28.5
    South_Bounding_Coordinate: 24.5

  3. What does it look like?

    <https://sofia.usgs.gov/aboutsofia.html> (GIF)
    map showing the location of the study area

  4. Does the data set describe conditions during a particular time period?

    Beginning_Date: 01-Oct-2001
    Ending_Date: 2005
    Currentness_Reference: publication date

  5. What is the general form of this data set?

  6. How does the data set represent geographic features?

    1. How are geographic features stored in the data set?

    2. What coordinate system is used to represent geographic features?

  7. How does the data set describe geographic features?

Who produced the data set?

  1. Who are the originators of the data set? (may include formal authors, digital compilers, and editors)

    • Roy Sonenshein

  2. Who also contributed to the data set?

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

  3. To whom should users address questions about the data?

    Roy Sonenshein
    U.S. Geological Survey
    3110 SW 9th Avenue
    Ft. Lauderdale, FL 33315

    954 377-5924 (voice)

Why was the data set created?

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.

How was the data set created?

  1. From what previous works were the data drawn?

  2. How were the data generated, processed, and modified?

    Date: Not complete (process 1 of 3)
    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.

    Date: Not complete (process 2 of 3)
    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.

    Date: Not complete (process 3 of 3)
    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.

    Person who carried out this activity:

    Roy Sonenshein
    U.S. Geological Survey
    3110 SW 9th Avenue
    Ft. Lauderdale, FL 33315

    954 377-5924 (voice)

  3. What similar or related data should the user be aware of?

How reliable are the data; what problems remain in the data set?

  1. How well have the observations been checked?

  2. How accurate are the geographic locations?

  3. How accurate are the heights or depths?

  4. Where are the gaps in the data? What is missing?

    not available

  5. How consistent are the relationships among the observations, including topology?

    not applicable

How can someone get a copy of the data set?

Are there legal restrictions on access or use of the data?

The database is no longer available and further development has been halted
Use_Constraints: none

Who wrote the metadata?

Last modified: 09-Mar-2007
Metadata author:
Heather Henkel
U.S. Geological Survey
600 Fourth Street South
St. Petersburg, FL 33701

727 803-8747 ext 3028 (voice)
727 803-2030 (FAX)

Metadata standard:
Content Standard for Digital Geospatial Metadata (FGDC-STD-001-1998)

This page is <https://sofia.usgs.gov/metadata/sflwww/sofia_database_04.faq.html>

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