Database Installation Notes

The Woodville Karst Plain Hydrologic Research Database (WKP-HRDB) is a PostgreSQL 9.1.14 database designed to facilitate access to and manipulation of the Florida Geological Survey's sensor data, as well as other sources of open data in the immediate region of Wakulla Spring.

PostgreSQL is an open-source, multi-OS database platform that supports access through many popular programming and statistical languages like Python and R. PostgreSQL can be obtained for free at the PostgreSQL download page.. One recommended alternative to using the default PostgreSQL installation is to install the PostGIS bundle from the PostGIS website. PostGIS enabled database tables are planned for release sometime in late 2015.

PostgreSQL is well documented and new users should refer to the PostgreSQL documentation for complete installation and setup instructions. It is recommended that a separate, client machine be used as the PostgreSQL server to maximize database speed and efficiency, although the database server performs reasonably well running from localhost.

The administration tools pgAdmin III and psql are installed by default with every PostgreSQL installation, and both are highly recommended for managing the database and viewing metadata.

See the Database organization page for info on tables.