Sunday, July 1, 2007

Gulf of Maine Council issues winter '08 Gulf of Maine Times, publishes salt marsh ecology booklet, and launches project progress report tool

March 2008 - March was a busy month for product and information updates from the Gulf of Maine Council on the Marine Environment! And Yellahoose provided critical IS and consulting services.

The Spring / Winter 2008 edition of the Gulf of Maine Times was released. This edition includes new web features for Times readers, including tools to share articles with others, and on the back-end a new (to the Times!) template system to improve workflow and reduce the effort and cost it takes to release the online paper. JavaScript, CSS and PHP were all used in this edition.

pic1

The Council also published Salt Marshes in the Gulf of Maine, a 42 page booklet on salt marsh monitoring and restoration in the Gulf. The publication was edited by Peter Taylor of Waterview Consulting.

pic2

Yellahoose developed a number of easy-to-use, web-based applications for the Council to track users interested in Salt Marshes in the Gulf of Maine, including capturing key demographic and professional information, and Yellahoose developed tools for users to request hard-copy versions of the booklet.

Data are managed in PostgreSQL, and the web application was written using PHP and JavaScript.

Habitat restoration grants were awarded also, and part of this year's grant monitoring process is the implementation of an online tool for awardees to use to document progress. Yellahoose developed the tool, with Jon Kachmar of the Maine Coastal Program and Peter Taylor of Waterview Consulting, using technologies, tools, methodologies and best practices already developed for and in use by the Council.

And we don't have nice screenshots for work did for the Christine Tilburg in the Council's Ecosystem Indicator Partnership (ESIP) and Christian Krahforst in the Gulfwatch Contaminants Monitoring committees, but that doesn't mean the services provided weren't fundamentally enabling — or, to be honest, terribly time intensive:

Yellahoose implemented PostgreSQL databases for Christine and Christian to use to manage and massage ESIP and contaminants data. The databases are password-protected. Christine and Christian can import data, tweak tables, and they can even link data to other data the Council already has at its disposal. They the good, cross-platform software, DbVisualizer, to manage their databases.

Links:

Gulf of Maine Council on the Marine Environment
http://www.gulfofmaine.org
Gulf of Maine Times
http://www.gulfofmaine.org/times/
Salt Marshes in the Gulf of Maine
http://www.gulfofmaine.org/saltmarsh/
Habitat Restoration
http://www.gulfofmaine.org/habitatrestoration/
Ecosystem Indicator Partnership
http://www.gulfofmaine.org/esip/
Gulfwatch Contaminants Monitoring
http://www.gulfofmaine.org/gulfwatch/

Waterview Consulting
http://www.waterviewconsulting.com

Maine Coastal Program
http://maine.gov/spo/coastal

PostgreSQL
http://www.postgresql.org

DbVisualizer
http://www.minq.se/products/dbvis

PHP
http://www.php.net

MapServer
http://mapserver.gis.umn.edu