oh-well!

Project Info

Cool Cats thumbnail

Team Name


Cool Cats


Team Members


Abel , James and 1 other member with an unpublished profile.

Project Description


A tool to visually represent water quality in the Christchurch region


#waterquality #water #chlorine #nitrates

Data Story


The data our team used came from four different sources, Christchurch water zones, ECAN well search, Community drinking water supply points, and Canterbury maps open data. The data came in many forms, from web scraped text/html to JSON.

A combination of this data was used to build a picture of water quality within different zones within Christchurch, and in turn, this was displayed on a map in a web interface.

Some significant issues were apparent within the data, such as large inconsistencies regarding which water sources had water quality data, which wells supplied which areas and some data were several years old.

Due to this, some assumptions had to be made while ensuring our solution was scalable and adaptable once the data was brought up to date and made more complete.

Our map was designed to accept a series of regions to ensure scalability, with the high-level regions being used in the prototype seen. Once lower-level regions are available, these can be added to the used dataset, and the map will update accordingly.

Where data inconsistencies were apparent, a null was used in place, resulting in the ability for the prototype to update the map once this data becomes available automatically.
A combination of this data was used to build a picture of water quality within different zones within Christchurch and in turn this was displayed on a map in a web interface.

Some major issues were apparent within the data such as large inconsistencies regarding which water sources actually had water quality data, which wells supplied which areas and the fact that some data was several years old.

Due to, this some assumptions had to be made while ensuring our solution was scalable and adaptable once the data was brought up to date and made more complete.

To ensure scalability our map was designed to accept a series of regions, with the high level regions being used in the prototype seen. Once lower level regions are available these can simply be added to the used dataset and the map will update accordingly.

Where data inconsistencies were apparent a null was used in place, resulting in the ability for the prototype to automatically update the map once this data becomes available.


Evidence of Work

Video

Homepage

Project Image

Team DataSets

Christchurch Water Zones

Description of Use Scraped for coordinates in order to analyse and overlay zones on our map.

Data Set

ECAN Well Search

Description of Use This tool was used to gather information on certain wells including water quality

Data Set

Community Drinking Water Supply Points

Description of Use Used to find which wells service which areas in Christchurch

Data Set

Canterbury Maps Open Data

Description of Use Used to find water quality reading of Christchurch drinking water points

Data Set

Challenge Entries

Most creative use of open data

This challenge is about being as creative as you possibly can be using any open data available under any of this year’s themes. Think outside the box and create!

Go to Challenge | 6 teams have entered this challenge.