US Community Energy Projects Database and Website

Over the last year, we have been involved in a project to develop a US Community Energy Projects Database and Website, in collaboration with Dr. Sharon Klein, Economics Department, University of Maine. Dr. Klein collected the initial data set, and Katrina Stinson, a CS undergraduate, built the database and website. We soft- launched this spring.

The US Community Energy Projects website is a centralized location for sharing information about community energy projects across the United States. It began as a compilation of publicly available information on renewable energy projects (solar, wind, biomass, geothermal, hydropower) with a “group” or “community” element. Now that the website and associated database are publicly available, the group hopes people with direct knowledge of projects will add/correct information to keep the database growing and current. CWRU renewable energy projects are listed.

Please feel free to share!


Python programming summer camp for Maine high school students

Today, we started teaching a gender-balanced group of 20 Maine high school students the beginnings of Python programming with little whale robots. Good fun!


Katrina Stinson presents capstone project on Visual Analytics for US Community Green Energy Projects

I had the pleasure of advising Katrina Stinson, in collaboration with Dr. Klein (Economics), for her senior capstone project over the last 2 semesters. This project entailed building a website with a database backend holding over 5000 community energy projects in the US that can now be accessed, queried and analyzed through the website. Users can register accounts and add new projects. Her capstone specifically focused on adding visual analytics to the community energy project data (statistics page).

The website can be found at

Katrina also graduates as best Senior of her class (and she did the program in 3 instead of the usual 4-5 years).

Congratulations, Katrina!


COS120 – Computing that Matters

This spring, we taught a class with new experimental methods of teaching programming to non-CS majors. The class started with a Scratch module, then 4 weeks of Python, and after that a choice of Arduinos and Databases, GIS, robots, drones or virtual reality.

Katie Manzo, my CLA (computing learning assistant), and I oversaw the Arduino and Database group. Everyone received an Arduino starter kit, and worked their way through different circuit tutorials. We integrated sensor streaming from Arduino boards sensors to Python programs and SQL databases.

The group had 2 final projects: building a zeotrope regulated by a soft potentiometer, and a live streaming sensor station visualizing live data.
Here are some snapshots from the class.

The class material (for self study) is available at this link.


J.C. Whittier successfully defends dissertation proposal

Today, J.C. Whittier successfully defended his dissertation proposal “Towards an efficient, scalable stream operator framework for computing continuous fields”, and advanced to Ph.D. candidacy.

Congratulations, J.C.!


SIE556 Real-time Sensor Data Streams Final Projects (2016)

This semester, the students again came up with a great selection of final projects, applying their new knowledge of real-time sensor data streams processing with mysql, python stream queries and Cloudera’s Spark and some Arduino programming to a project of their interest.

There are several general thematic groups in the class:

Group 1: Using Arduinos and temperature and humidity data to monitor environmental conditions in real-time

Jon Cole built a Unity-based 3D Visualization of live and historic buoy data in the Gulf of Maine.

Check out the interactive demo here. Code here.

Devon Stetson built a sensor data stream analysis system deploying a temperature data in his dorm room.

Welles Tisdale extended his undergraduate capstone project of building an automated greenhouse using Arduinos with live sensor data analysis, alerts and long-term monitoring.

Group 2: Real-time smartphone sensor data analysis to detect parking and departing events at UMaine in real-time.

Avery Dunn and Anthony Stetson’s current capstone project of real-time smartphone sensor data analysis to detect parking and departing events at UMaine in real-time

Group 3: Real-time Speeding Alerts using Arduinos and a GPS unit.

Kaitelyn Haase has just started to learn programming at the beginning of this semester as a graduate student in the MSIS program, and so it is even more impressive that she managed to soldered an Arduino “sandwich” with a shield and an GPS unit, program the Arduino to compute the current speed in real-time and sound a audio alert when the speed was over the speed limit of 70Mi/H. She also analyzed and visualized the collected information.

Group 4: Interactive Visualization of Argo Drifter Data.

Brad Sheperd built a python-based graphic user interface to stream process netCDF encoded stream data from the Argo drifters that cover the oceans world-wide. The visualization allows to interactively spatially subset the data and select different parameters.

Group 5: Transforming Sensor Data into Sounds using SuperCollider

Rod O’Connor combined a set of light sensors on an Arduino with python stream based processing the incoming data and sending it to SuperCollider to ‘animate’ the sensor readings as sound (very cool!).

Interested in learning Arduino programming?

For a new section of COS120 Introduction to Programming, we made a few accompanying videos for the Sparkfun Arduino starter kit. Katie Manzo, a CS undergraduate, is my learning assistant for the course, and she is demonstrating the kit.

Here’s to setting up:

This is the first example, the blinking LED:

This is another example, the photo resistor:

This is the 4th example, spinning a motor:

%d bloggers like this: