PostgreSQL Database Application

Hi Chuck,

I am researching online mapping services for a class project and found this:

National Wild Fish Health Survey Database.

http://www.fws.gov/wildfishsurvey/database/nwfhs/

It runs on PostgreSQL. I don’t know a lot about PostgreSQL beyond that it is open source and competitive with MySQL and other enterprise-level database options. I’ve mentioned before it has an extension called PostGIS that allows excellent handling of spatial data.

So, seeing this application really caught my eye. I think it is a good aspirational model for what we could do with DLIA data. It appears to be all open source. Im copying out text they shared on <http://www.fws.gov/wildfishsurvey/database/page/about>

Major software components:

• OpenLayers, an open source JavaScript library for displaying map data in most modern web browsers
• MapFish, an open source web mapping development framework
• GeoExt, a JavaScript Toolkit for Rich Web Mapping Applications
• Ext JS, a cross-browser JavaScript library for building rich internet applications

• GeoServer, an open source software server written in Java that allows users to share and edit geospatial data
• MapServer, an open source development environment for building spatially-enabled internet applications
• PHP, a free, widely used, general-purpose scripting language
• PostgreSQL, an open source database management system
• PostGIS, an open source software program that adds support for geographic objects to the PostgreSQL database
• Smarty, a web template system written in PHP

I’ll probably explore this more, but wanted to share it with you now.

-Tanner

WFS 533 – Amphibian Ecology and Conservation

3 Credit Hours

---

An in-depth examination of amphibian life-history strategies, community interactions, and hypothesized mechanisms of amphibian declines. Amphibian monitoring, conservation and management techniques also are covered.
Credit Restriction: Student cannot receive credit for both 433 and 533.
Recommended Background: Forestry 215 or Biology 250.
Registration Restriction(s): Minimum student level – graduate.

---

Volunteer Service to National Amphibian Conservation Organization Highlighted

Along with volunteering as the webmaster for SEPARC, I volunteer to help out with content management tasks for the national Partners in Amphibian and Reptile Conservation (PARC) web site.

Mostly, I post new job opportunities to the PARC jobs board. If jobs are particularly interesting or relevant to the Southeast, I’ll post them on the Southeast PARC (SEPARC) Facebook Page that I help manage, which then is linked to that organization’s Twitter.

This volunteer work not only helps out the animals, but helps me keep my HTML and social media skills up-to-date, and lets me add experience with the Joomla content management system to my list of skills.

Visit PARC’S website at http://www.parcplace.org! The website has been updated and new content has been added. In particular, see the new information under Resources, including a new Department of Defense PARC (DoD PARC) link regarding our new initiative with military instal- lation natural resource personnel to provide stewardship for threatened and endangered herpetofauna. You can also join our announcement listserv to stay up-to-date on PARC and partner happenings. Check it out! PARC thanks JD Willson (University of Arkansas) and Tanner Jessel (University of Tennessee, Knoxville) for their volunteer time to keep our website up to date and attractive, and to Brian Todd (University of California, Davis) for maintaining our listserv!

Read more about PARC in the 2012 Annual Report linked here <http://www.parcplace.org/images/stories/documents/2012_PARC_Annual_Report_MedQ.pdf>.

Poster – Species Mashup: Biodiversity in the Information Age

I presented this poster (I intend to supply a digital version at some later point) at the 2010 meeting of the Organization of Fish and Wildlife Information Managers. The agenda for that conference is available online.

This was part of my contract work as content manager for the now defunct National Biological Information Infrastructure’s Southern Appalachian Information Node (SAIN).

An archive of the NBII program’s web site is available from the U.S. “Fugitive Agencies”collection.

The most recent iteration of SAIN was as “SEIN” for “Southeast Information Node,” a change resulting from some of the organizational upheaval in the final months leading to the program’s ultimate termination in a Presidential line item budget request for the U.S. Geological Survey.   The archive for the overall site is available online: <https://wayback.archive-it.org/2361/20120105235453/http://www.nbii.gov/portal/server.pt/community/southeast/245>; the specific application promoted by this poster is available at <https://wayback.archive-it.org/2361/20120106000735/http://www.nbii.gov/portal/server.pt/community/species_of_greatest_conservation_need/1642>.