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.