As part of the brand new Publicis Drugstore initiative we are doing today one of our fabulous CodeMaker courses. We have just kicked off and our participants are describing ‘how to make toast’ to learn the basics of programming. Its a great exercise to illustrate the skills a software developer needs to have – in this case analyse a problem, which is to understand how to make toast. So here you learn about what are instructions, what is an input, output, conditions, data and so forth. So in short what assumptions do we make: do we have power, sliced bread, or indeed a toaster. In essence we get participants to write a little program that would make you toast just without the actual coding.
More than the sum of our parts
SECOND PRIZE Planning PermiSMSion Phil Nash (Twilio)
THIRD PRIZE The Italian Job Alessio Gottardo and Vittorio Delsignore
Special Mention also goes to Dalton Scott and his mum Roslyn for their hack Hack Prop
To set the scene a little, it could be said that a hack is somewhat determined (however loosely) by its elements – much like the ingredients of your favourite recipe. Last weekend in a large room overlooking a busy Old Street we gathered together a myriad of ‘things’; planning data, food, a remote survey group, wiki enthusiasts, front end developers, business consultants, staff with an extra special interest in mapping visualisation tools etc. Over two days these bits and bobs were worked together and out of this came 8 great hacks and hopefully a few laughs.
Below is a breakdown of each team and their hack in no particular order..
Team: Jamie Copeland, Raim Koo, Mazin Power and Alberto Rizzoli
The hack enabled a space in which council staff could work with teams and really scrutinise the processes behind particular council services. Discussions early in the weekend brought user experience to the fore and through hacks participants sought to find new ways for local residents to engage with the council online.
In our first hack the team focused on the task of how local residents can search for council commercial lets. Using OnePulse services the team discovered that ⅔ of those surveyed didn’t know that they could enquire direct to the council for lets in their area and the majority were keen to access this information online rather than via telephone. With this knowledge the team built a clean and intuitive graphic user interface that allowed a snapshot overview of available properties. Users could then drill down and filter results or find detailed info on each property. Then if no matches were found users could also sign up to be notified via push notifications in facebook, email or text using Twilio. Special mention goes to Jamie for learning MongoDB from scratch and working through the night, presenting to our panel of judges with only 1 hour of sleep!
The Italian Job **3rd PRIZE**
Team: Alessio Gottardo and Vittorio Delsignore
This was a hack to simplify the process when booking an appointment at the local office to register a new birth. The current process can be found here: http://myhackney.hackney.gov.uk/tkflow_web/Flow.aspx?f=RegistrarsBirthsWeb.kdt&FormAuth=True. With council staff the team (both software developers) assessed the flow of questioning/information gathering in the form and restructured it along with a plugin of both BookingBug and Twilio. Users can go through, book a time slot and once actioned will get a confirmation via text of their appointment.
Planning PermiSMSion **2nd PRIZE**
Team: Phil Nash (Twilio)
Prompted by Christian Ahlert (MiniBarLabs CEO and local homeowner) Phil developed a hack to notify interested parties of new planning applications (and potentially licensing). Currently communications to individuals around planning are conducted via the post. Letters are necessary because they satisfy the majority of residents (particularly those without online access) however Phil wanted to see if there was an elegant, contemporary way of communicating alongside this. Therefore he built an interface that allows users to sign up and choose to receive updates on planning permission applications in their area by SMS or email. For this Phil, a Twilio evangelist, used his company’s services. Through this residents can subscribe to a thread to track the application, find out when a meeting is and potentially make comments on live applications online.
Team: Cybersalon – Fako Berkers, Sophia Drakopulou, Niki Gomez, Filip Janczak, James Moulding, Eva Pascoe, Simon Sarginson
The team from Cybersalon took a different approach to the hack, deciding to work on a tool to map notable local residents. Introducing their hack, the team described how through their tool ‘Hackney Treasures’ they wanted to celebrate the work of local residents and remind people of all the creative and interesting minds that live among us. The main interface is a smartphone app drawing on wiki data assigned with Hackney borough geolocation tags. As users walk around the app traces their steps and provides them with wiki quotes and tidbits on the lives of local residents and their connection to Hackney.
Fix Hackney **WINNERS**
The Hack-ney-thon winners produced a dashboarding hack to gather and visualise issue reporting by ward across Hackney ie: broken street lights, fly-tipping, noise etc. To collate the information the backend enables the centralisation of reports as they come through on a range of feeds via social media, mails, calls and texts etc. Each report can be viewed on the map enabled by OpenStreetMap with supplementary data such as description, picture, previous reports, comments etc. Then through the Fix Hackney interface users can synthesize and relate data per ward. Data can be tracked over time and council performance can be assessed in analysing things like cost vs response rate. This clean way to interact with and digest information can potentially help the council to plan resources and budget in the future.
Team: Dalton Scott and Roslyn Scott
Hack Prop sees our youngest participant – Dalton – and his mum Roslyn work on a web application that looks to reduce the amount of phone calls into the council switchboard relating to booking viewing appointments for council lets. Using both Twilio and BookingBug they have refined the current from found here: hackney.gov.uk/property into 14 short steps. In addition potential tenants can view a 360degree view of each property.
Team: Abdul Hassan and Hannah Dalgleish
Hackney Hero is also based on issue reporting but concerns itself with an earlier stage in the process to Fix Hackney.
To begin with the team recognised how cumbersome it could be to report an issue via the appropriate area on hackney.gov.uk, stating that it may be over complicated and that it could dissuade users from completing their report. It’s important to acknowledge the effort of residents in helping to look after the borough, taking time out (albeit short) to contact the council and describe the issue or provide feedback. The team conducted a OnePulse survey and found that although the majority would be willing to report an issue they were unclear as to how or were short of time. The team focused on reporting issues via smartphones while out and about in the borough. Through the interface users complete a number of quick questions using dropdown menus and have the chance to upload a photo directly. All this information is then gathered in a database and can be searched by council staff by category/issue/date.
Mash the Web
Team: Hon Guin Lee
Hon built a responsive web app that allows users to see all the statutory planning permissions in Hackney borough. Users can then drill down an view individual notices and related committee notes.
We’d like to say a big thank you to everyone who took part in Hack-ney-thon, especially to participants for giving up their weekend to join us. Hackney council is committed to adopt working solutions and each one of the hacks developed will be presented to senior staff at a special meeting on 25 November 2014.
- Christian Ahlert, MiniBarLabs
- Gerard Grech, CEO, Tech City
- Sophie Higgins, Special Projects Officer, Hackney Council
- Andrew Sissons, Head of Regeneration Delivery, Hackney Council
- Anthony Truffour, GIS Technical Manager, Hackney Council
- Duncan Ray, Shoreditch Town Centre Manager, Hackney Council
Criteria; usefulness, technical sophistication, cost reduction, social/public impact and creativity
Outreach Partners: TechCity UK
Hackney Council’s Geographical Information Systems (GiS) team have put together a special GitHub for Hack-ney-thon 2014 (https://github.com/LBHackney/Hack-ney-thon) with lots of data on local services and planning.
About the Geographical Information Systems (GiS) team
A Geographic Information System“ (GIS), captures, stores, analyzes, manages, and presents data that refers to or is linked to a location. In the strictest sense, the term describes any information system that integrates, stores, edits, analyzes, shares, and displays geographic information. In a more generic sense, GIS applications are tools that allow users to create interactive queries (user created searches), analyze spatial information, edit data, maps, and present the results of all these operations.
The council is committed to meet the specifications of the EU’s INSPIRE Directive (Infrastructure for Spatial Information in the European Community –http://inspire.ec.europa.eu/). Through their work the GiS team have developed several tools such as; Map.Hackney2.0; MapGallery; Plan Web and the resident facing Find My Nearest (http://www.map.hackney.gov.uk/Find-My-Nearest/) – an interactive mapping tool using council, OpenStreetMap and Ordnance Survey data. You can find out more about their interactive map projects here.
What’s on the GitHub?
The GitHub can be found here: https://github.com/LBHackney/Hack-ney-thon
The data made available to the hack relates mostly to the council’s work on http://www.map.hackney.gov.uk/maphackney3/. This is a collation of both open and newly gathered data on the local area. The menu below gives an indication of the types of information to be found, things like local services and amenities, transport links and importantly a significant amount of data on historic and current planning applications.
- *Base Layers
- __>Ordnance Survey
__>OS 500m Grid
__>OS 1Km Grid
*Community and Living
__>Places of Worship
*Council and Democracy
*Education and Learning
*Environment and Planning
__>Tree Preservation Orders
- __>Planning Applications
- __>Growth Centres
*Health and Social Care
*Leisure and Culture
- __>Exercise and KeepFit
- __>Leisure Centres
- __>Sports Club
- __>Table Tennis
- __>Water Sports
- __>Youth Clubs
- *Transport and Streets
- __>Bus Stops
- __>Cycle Stands
- __>Car Club Bays
- __>Barclays Hire Bike Stands
- __>Cycle Network
- __>Controlled Parking Zones
- __>Disabled Parking Bays
- __>Train Stations
- __>Underground Stations
The files are available on GitHub in Geojson and you can also download .csv files directly here: http://www.map.hackney.gov.uk/maphackney3/. See the below image on how to save them to your desktop.
In addition, the GiS team have also put together a small list of data they have gathered from elsewhere: https://github.com/LBHackney/Hack-ney-thon/wiki/External-Datasets. This includes; Edubase education data, an education API from TSO OpenUpLabs, Ordnance Survey OpenData and Tfl Open Data.
Richard Pope from Government Digital Service has kindly put together this great list of guides, tools and related projects to refer to for our Hack-ney-thon.
Government Services Design Manual
From April 2014, digital services from the government must meet the new Digital by Default Service Standard. To help anyone looking to build new tools and services the GDS have produced a Government Services Design Manual. Although different to working with local councils the manual could provide some useful general advice for the hack.
Google Analytics Dashboard
Edd Sowden, frontend developer at the GDS, has recently used the Google Analytics dashboard to display real time searches on the GOV.UK site for others in the office as a way to ‘remind people that there are real people out there interacting with the site we are building, who have real user needs they want solving.’ He then went on to make this code available for use to both Code for America and the Citizens Advice Bureau. Here is his GitHub.
Planning Alerts is a piece of open sourced software built on Ruby On Rails by OpenAustralia. It’s a free service that alerts users via email of any planning applications sought in their area. The purpose of which is ‘to enable scrutiny of what is being built (and knocked down) in peoples’ communities.’ It was successfully re-used by My Society during a recent sprint with Hampshire Hub Partnership. Here’s the Planning Alerts GitHub.
Smart Answers is a framework for creating decision trees. Working in partnership, content designers and developers at the GDS have devised a system that guides customers through a series of questions in order to narrow down their problem and offer them helpful advice quickly and easily.
Performance Platform is a dashboarding tool to display performance data about services. It provides real time and archived data on site activity and services accessed. There are currently 106 dashboards to view. The platform was developed with groups like government service managers, journalists, students and researchers in mind, or members of the public interested in finding out how public services are doing. It has also been successfully applied to local government services such as the Warwickshire County Council’s dashboard for library item renewals and Solihull Council’s dashboard for missed waste collections. The tool can be made available to participants during the hack.
Prison Visits Booking System
The Ministry of Justice Digital worked with HMP Rochester to develop a design pattern for booking appointments or visiting orders. The project was then rolled out across a number of pilot prisons to help standardise the process. This has transformed a once disjointed, paper reliant and complicated process meaning that now over 1.5million visits have been successfully navigated since launch. This is a well tested design pattern for booking appointments and can be made available during the hack.
Staff from Hackney Council have put together the following challenge for our hack-ney-thon.
Statutory notices App
The Council would like to increase the accessibility of information regarding statutory notices within the borough. It is important that local residents are made aware of planning and licensing applications in their neighbourhood and have an easier method of commenting on applications.
The current method of finding out about applications within the borough is via the following pages on the Council website:
Although all the information is available online, to access the information requires a proactive and dedicated approach to searching for the information. This process could be dramatically improved with a new system that would allow notifications to be sent to people who have expressed a prior interest in finding out about applications in their area.
The Council would like residents to be able to sign up for notifications for statutory applications in their neighbourhood. This could be done via an app where you would specify a particular address, a number of streets or by drawing a defined area of interest on a map.
Cllr Guy Nicholson spoke about our upcoming Hack-ney-thon recently:
“Hackney, home to Tech City, has some of the best creative and tech talent in the UK and from around the world.
“The Hack-ney-athon is designed to harness that talent by collaborating with a range of creative businesses and individuals to enhance Hackney Council’s services. The objective is to design services that are efficient and provide a better quality service for residents.
“This event is an example of the Council’s continued partnership working with other local organisations, including the creative tech community, to help stimulate local economic growth in addition to supporting Council services at a time of Central Government led spending cuts.”
Cllr Guy Nicholson, Cabinet Member for Regeneration, Hackney Council
You can find out more about the hack event and sign yourself up here: https://www.eventbrite.co.uk/e/hack-ney-thon-24-hours-to-hack-for-hackney-tickets-13752641521
Hack-ney-thon -> Threads
24 Hours To Hack The Council
15 November & 16 November
Trampery Publicis Drugstore, Old Street Roundabout
We are asking for suggestions in advance of the event but here are a few ideas that the council have picked out (you can make suggestions by emailing hello at minibarlabs.com:
1.Wedding Community Site – ‘Getting Hitched in Hackney’
There are currently no external communications for council wedding services and all information is relayed via individual emails through enquiries. Hackney Council’s Registrars (Births, Marriages, Deaths and Nationality) department would like to find a way to make their wealth of knowledge publicly available and at the same time create a space for venue listings, for local businesses to advertise services and for couples to share tips and rate their experiences.
Examples of external communications from other councils would be brochures or static areas within the council’s main website. However the idea here would be to encourage more participation and communicate the excitement felt by couples approaching the Big Day. The aim would be to make interacting with the council service fun and the branding of the portal would be community and couple focused. This would be independent from the main hackney.gov.uk site, something in the vein of Mumsnet or TripAdvisor where the council staff can have a voice amongst other local people. In terms of functionality the portal could include features like a forum, venue listings, venue and service mapping and user rating, advertising space and importantly a connection to the council’s venue booking system (as described above).
- 2. Booking system
Hackney Council’s Registrars (Births, Marriages, Deaths and Nationality) department provide a wide range of services, however only a selection of these are currently made available for public booking online – making appointment to register births and deaths. All other bookings are booked through telephone and email enquiries. This is a disjointed process which takes up council staff time and due to the spike in enquiries over the weekend, loses potential clients as response rates are slower. Hackney Council would like you to come up with a way for couples to make appointments to view as well as book and pay for the wedding venue of their choice. This would free up staff time and save money at both ends of the process for the council.
Commercial Property Services
Booking Process for Viewing and Applications
Email Management System
Commercial Property Services
- Booking Process for Viewing and Applications Email Management System
The Council has a commercial portfolio of well in excess of 300 properties, a large proportion of which are retail units. There is a relatively high turnover and typically there will be 5 – 10 units available for rent. The Council aims to have as close to 100% occupancy as possible.
The Commercial Estates team receives a high volume of enquiries for commercial property, which are managed through an online form and over the phone. However, the system still requires a fair amount of manual processing, which is costs time and can also permit human error. The team needs you to help them smooth out the online enquiries process and in addition to this ensure that the list of would-be tenants is shaped and more easily called upon through an email management system for future marketing purposes.
The online form can be viewed here: hackney.gov.uk/property. The issue lies in what happens after the form is filled out, as once submitted all data is transferred into a spreadsheet, which then requires manual processing for future mailshots.
The team needs:
- – a central hub to gather and collate both mail and telephone enquiries as well as connect this to an email management system a way to more accurately categorise the user’s request (through the selection of additional criteria on the enquiry form perhaps) as council staff currently have to search through each individual email.
- – a prompt to next action on the form such as booking a viewing.
- – an online application form to rent a property – currently this has to be printed out and provided in hard copy
- the user should get an automated mail that acknowledges their enquiry.
- the user should be tagged and added to the relevant email list
Ideally we would like to end up in a position where if we have a 1000sqft shop to let at £15,000pa, we can insert these details into a program that will automatically email all enquirers with matching criteria.
Hack-ney-thon will be an exciting opportunity for developers to access a large number of datasets gathered and maintained by the ICT department on activities across the whole council. This is an open thread where we invite developers to investigate and experiment with material, seeing what insights can be revealed through manipulation and what innovative new tools can be produced. In advance of the day the department will make a number of these sets available via GitHub and provide descriptions of some insights into its use and potential application.
One area of focus in the department is in mapping the local area. They is committed to meet the specifications of the EU’s INSPIRE Directive (Infrastructure for Spatial Information in the European Community – http://inspire.ec.europa.eu/). Through their work they have developed several tools such as; Map.Hackney2.0; MapGallery; Plan Web and the resident facing Find My Nearest (http://www.map.hackney.gov.uk/Find-My-Nearest/) – an interactive mapping tool using council, OpenStreetMap and Ordnance Survey data. This area could be of interest to developers working in data visualisation or those wanting to investigate big datasets.