Drupal and Project Watershed

In my "spare" time, I've been doing some volunteer work for Project Watershed, a 501c(3) group that promotes water quality awareness and education in schools in and around Syracuse. A look at their map of sampling locations gives a good impression of the area they cover.
I was introduced to Project Watershed on my first day at the Living SchoolBook and I attended bi-monthly board meetings for the group on and off for my entire eight years there. I enjoyed the intermingling of environmental science, education and the web. Now I am helping them redesign their site for the fourth time since I've been affiliated with the group. I am using Drupal once again for the site. Some of the goals of the project are obvious, while others are slowly emerging out of our discussions:

  • redesign the site to reflect its new funding source (the Izaak Walton League of America) and give it a fresh new look
  • rearchitect the message and information to best address its target audiences of teachers, student and adult monitors and the general public
  • present a single site for accessing both descriptive information and water quality data (in the past a separate database and site were used to manage and display the oodles of data that the group has collected over the past 10-ish years)

One of the biggest challenges of the project will be to display the water quality data that the group typically collects during its sampling events. I've been storing them as normalized data in a separate database, but to do something analogous in Drupal will be a project in itself. I am wondering if I should just leave the data in the existing database and just display it with a custom Drupal module.

Comments

Google Maps Overlay?

This data is collected in specific locations, right?

May be a lot of work to learn (I don't know), but a Google Maps Overlay would be one way the data could maybe be presented.
http://code.google.com/apis/maps/documentation/overlays.html#Overlays_ov...

Use a custom marker for each collection site that represents the measurement?

I'm just thinking "out loud", this may not make any sense given the actual type of data, but it's the first thing that jumped into my mind.

-Pete
MythPVR.com

That would consistent with

That would consistent with the previous Google map API work we did. I'll be looking into it as we go along.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.