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

Advertisements

About Tanner Jessel

I am a recent M.S. in Information Science graduate from the University of Tennessee School of Information Science. I was formerly a graduate research assistant funded by DataONE (Data Observation Network for Earth). Prior, I worked for four years as a content lead and biodiversity scientist with the U.S. Geological Survey's Biodiversity Informatics Program. Building on my work experience in biodiversity and environmental informatics, my work with DataONE focused on exploring the nature of scientific collaborations necessary for scientific inquiry. I also conducted research concerning user experience and usability, and assisted in development of member nodes with an emphasis on spatial data and infrastructure. I assisted with research designed to understand sociocultural issues within collaborative research communities. Through August 1, 2014, I was based at the Center for Information and Communication Studies at the University of Tennessee School of Information Science in Knoxville, Tennessee.

Posted on August 2, 2014, in Civic Life and tagged , , , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: