RUBeingServed

Project Info

Transparency Ninjas thumbnail

Project Description


The project is provides insights of officials attendance of meetings in different organizations. An organization can be regional council, district health board, etc.

Additionally it provides a way of visualising and analysing meeting minutes to get an overview of what has been discussed and how this changes over time.


Data Story


Meeting schedules and minutes for 2019 were scraped to produce tables of meetings and councillor attendances. The meeting text was also analysed to produce word counts for a set of meetings.

The attendance information was visualised for each organisation, and the word counts turned into word clouds and used for trend analysis of words found in the minutes over time.

Mapping layers from stats have been used to provide the initial landing page and navigation, and councillor photos are used in the attendance visualisation.


Evidence of Work

Video

Homepage

High-Res Image

Team DataSets

Napier City Council Councillor Images

Description of Use: We identified the source of the pictures and used this to provide avatar images for the attendance visualisation.

Data Set

Hastings District Council Councillor Photos

Description of Use: We identified the source of the pictures and used this to provide avatar images for the attendance visualisation.

Data Set

Hastings District Council Meetings

Description of Use: Used to get attendance for councillors, could be used for text mining too, given time

Data Set

Napier City Council Minutes

Description of Use: Scraped this table to get list of meetings. Scraped text from each set of minutes to process for attendance and also what was being talked about.

Data Set

map baselayer

Description of Use: Used as the basemap for the map interface.

Data Set

Stats New Zealand Geographic Data

Description of Use: The API service is used to provide the Territorial Authority (and Regional Council if implemented) boundaries shown on the map.

Data Set

Challenges

Best Creative Use Of Technology

Region: New Zealand

Challenge

Combating the Climate Emergency

Region: New Zealand

Challenge

Innovate New Zealand

Region: New Zealand

Challenge

Most Artistic use of data (outside the box)

Region: New Zealand

Challenge

Best Way to Promote Positive Mental Health

Region: New Zealand

Challenge

Reducing CBD Traffic Congestion

Region: International

Challenge

Optimise energy and water resource planning

Region: International

Challenge

Back to Projects