Groundwork London

The Geospatial & Data Services team operates out of Groundwork London's Morley Street office and hence works closely with Groundwork London on the various projects they are involved in. Contributions to projects can range from small jobs such as creating an area profile for a new recycling hub to long-term contracts such as the systems-management of the Thames Water Progressive Metering Programme.

Our Projects

The Loops (Repurpose)

The Loops are two award-winning community reuse hubs designed to help communities recycle and reuse more household goods, which reduces fly-tipping and amount of waste sent to landfill sites. At The Loops we collect, repair, up-cycle and sell unique, reasonably priced furniture and other household goods. Many local people have become part of the re-use movement with the Loops also providing training, employment and volunteering opportunities for residents in a range of specialist skills, including furniture restoration.

The Loops began life in 2015 as part of an EU LIFE funded pilot project called Repurpose. Visit www.repurpose.london to find out about the pilot and access the toolkits and other resources we produced in order to share our learning and best practice. Since the pilot ended in 2017 we’ve successfully secured additional funding and successfully developed two of the original pilot hubs in Hackney and Barnet. Find out what’s happening now these two Loops.

Rework

The Challenge 

Rework is a Groundwork London initiative delivered in association with the Western Riverside Waste Authority and Cory Riverside Energy and supported by the Masonic Charitable Foundation.

REWORK-partner-logos

Each year thousands of electrical items in the workshop, including washing machines, fridges, cookers, microwaves and other household electrical goods are being processed. These appliances that would have been scrapped, recycled or sent to landfill, are returned to full working order and given a second life. They are then passed onto charity retailers and social enterprises who sell them at affordable prices. 

The team at Rework needed a solution to create a live inventory of goods that had to go through a complex checking process in stages by different team members with different duties. Given the nature of the work being done, the system needed to be fully compatible with mobile devices (iPads). 

The Solution

The application created by the GDS Team on Zoho, was based on the idea that barcode stickers applied to white goods were scanned with iPads. The barcode functioned as a unique identifier for that appliance and followed the item through the whole refurbishment process. 

The workflow was built so that employees had to follow a strict procedure aimed at minimising users' errorCustom scripts helped users accessing the right form and insert relevant information only when needed. 

Views and reports were designed to count and track items so that managers could assign and monitor jobs in real-time. 

Dashboards and reports were designed to allow monitoring performance and quantify the positive environmental impact of Rework. 

Employment Application

The employment team all work from different offices/co-locations all across London, so in the past it's been quite difficult to facilitate cross team information sharing. Individual teams can be quite good at sharing information about job vacancies etc., but when you're looking at an overall Employment function of around 30 who work out of up to 20 different locations it's a lot more complicated! Across all the locations and programmes we have Employment Advisors (EAs) signing up new clients who are candidates in the job market - providing 1-2-1 advice and guidance on finding a new role.  

 

The app is designed so that an EA is able to upload core "candidate" details which will be useful to help them with their job search. This means for the first time we will be able to track what types of jobs are being sought after by the candidates in different locations across London all in a single place. This means that the team of Employer Liaison Officers (ELOs) can more easily identify the types of businesses in each area we need to be developing relationships with so we can put forward candidates.  

 

The app also has a section where the ELOs can upload any live vacancies onto the system. EAs can review these vacancies and submit candidates for those jobs - and with the ability to track what jobs are being submitted against, we can work out which types of jobs are more/less suitable for the candidates. The teams also use the list of live vacancies to send out to our referral partners - showing them the types of opportunities we can help candidates get work in and therefore encouraging them to refer us candidates for the programmes. 

 

HEART iOS app

The Challenge 

For 14 years Groundwork London Green Doctors have been helping households in London save money, stay warm and improve energy efficiency at home. In partnership with London Boroughs and Housing Associations they visit residents’ homes to install free energy-saving measures, give advice on bills and provide referrals to further services to improve health and well-being. The HEART iOS app project addressed thneed for an intuitive UI, offline capabilities and dynamic calculations of energy, water and financial savings for residents. 

 

The Solutions 

The GDS Team worked with a well-established UX-consultancy (Lion+Mason) to conduct a user research and to define a UX strategy and design for the creation of a bespoke iOS app fully integrated with the Salesforce platform. 

A team of developers worked on the creation of the iOS app, which featured: 

  • Offline capabilities 

  • Complex and dynamic formulas to calculate energy, water and financial savings from behavioural changes, energy and water saving measures, based on user’s selections 

  • Creation of a bespoke pdf report for the resident 

  • Framework for the creation of scheduled messages (text) to residents to remind them of pledges made during the visit 

 

Green Doctors London Salesforce Development

The Challenge 

For 14 years Groundwork London Green Doctors have been helping households in London save money, stay warm and improve energy efficiency at home. In partnership with London Boroughs and Housing Associations they visit residents’ homes to install free energy-saving measures, give advice on bills and provide referrals to further services to improve health and well-being. 

With hundreds of residents visited every month, Green Doctors need a reliable CRM to book and deliver home visits and telephone consultations. Despite the use of other CRM platforms, Green Doctors asked for a more intuitive, secure and reliable application fully compatible with mobile devices. 

 

The Solutions 

The GDS Team has worked closely with Green Doctors to identify areas of improvement for the current CRM and develop a customised user experience that kept well established workflows, but allowed offline editing, an integrated calendar system and a more engaging experience for Green Doctors and residents alike. Salesforce offered all this. 

 

The development included: 

  • Force.com development (enquiry form and data protection consent) with custom APEX and Visualforce 

  • Workflow design, execution and automation using Lightning components 

  • Fully integrated mobile experience 

  • Offline editing capability when needed 

  • Comprehensive reporting solutions and dashboards 

 

 

 

What’s next 

A fully integrated calendar systeto create and manage bookings, developed with Lightning components. 

Force.com questionnaires with a focus on the creation of an intuitive interface and logic implementation to ensure residents and Green Doctors have the best possible experience 

Green Doctors London

For over 15 years Groundwork London has been helping Londoners stay warm & well & save money on their household bills through the Green Doctors service. Over 3,300 households in London last year were visited by Green Doctors, and the entire workflow – from enquiry, through booking and the visit, to reporting - of each visit was recorded and managed in an especially designed Zoho Creator application. 

 

An early challenge in development was to design an architecture of forms or tables, which would collect the enquiry, booking and visit data, and establish relationships between them. Zoho Creator allowed us to build this with ease, and enabled unique records for schemes, projects, green doctors, engagements, enquiries and visits to be created without unnecessary duplication, and to be collated in a master table from which monitoring and management reports could be fed. 

 

Zoho Creator then enabled us to customise these forms, so that manage every aspect of the Green Doctor project could be managed within the appUsing a dedicated script (deluge), bespoke functions, and schedules, these forms and tables came together into a seamless workflow. Capturing enquiry data from residents and referees, feeding this to Groundwork staff who engage with residents and book visits, and finally through to green doctors who take the residents through a custom, project-specific form which captures everything from the energy savings calculations, advice given and its feedback, and energy saving devices installed. 

 

Groundwork - Geospatial & Data service

Groundwork GDS is part of Groundwork London