What have we been up to in our first year?

Local e-commerce for the independent food sector in Wales;
A local e-commerce solution designed for independent food businesses that had not yet traded online and were experiencing issues dealing with their existing customers during the first lockdown. more
Developing an IoT information panel for a Welsh social housing provider using open source tools;
North Wales' largest social housing provider wanted to bring IoT into its properties but couldn’t make a viable case for the cost-efficacy of existing commercially available solutions across its estate. more
Developing a new online bus timetable and service management and PTI compliant export tool for a Welsh LTA;
A Welsh Local Authority and Transport for Wales wanted to improve the consistency and accuracy of public transport service data in a rural County by providing all Bus Operators with access to an integrated online timetable and service management tool. more
Creating a WiFi and IoT sensor analytics platform and login portal for Welsh Town Centres;
Worked with a local enterprise agency and a Welsh local authority to provide a county-wide town centre footfall analytics platform and WiFi login portal that supported IoT sensor data. more

Local e-commerce for the independent food sector in Wales

#e-commerce, #MVP, #Food, #Gwynedd, #local, #covid, #VueJS, #GoLang, #AWS, #siopio

Butcher

The challenge

When the covid 19 pandemic struck we were made aware that a leading local independent food business was having issues dealing with the transformation that had been forced onto their business. Taking payments over the phone and managing hundreds of customer orders from till reports was taking up days of additional time. The business established over 20 yrs ago had no prior need or interest in going on line other than some customer interactions on facebook, but it now needed some help.

We wanted to go against the logic of developing a solution that was centred on the online customer experience but instead focus our time on the needs of small independent food businesses that were not technically literate and understand how they could be best supported in dealing with orders, product management and the fulfilment process in an online environment.

In five months and with a team of three, Kodergarten:

  • Designed, built and deployed a full e-commerce stack on AWS, the team developed a minimum viable product that enabled businesses to sell food products online via card payments or cash.
  • Provided a basic delivery/collection model so that businesses could deliver or customers could collect.
  • Produced a comprehensive set of order management documentation for the business from production of picklists right through to delivery notes.
  • Provided a staged order process that enabled customers to be easily notified of progress on their order or refund via email saving the business owners time in dealing with order enquiries.
  • Reduced the amount of time that the food business owners were spending on processing orders and order payments by nearly 80%.
  • Ensure that the system was fully bi-lingual, meaning that customers could be communicated with in the language of their choice on screen or via email.

Developing an IoT information panel for a Welsh social housing provider using open source tools

#IoT #pilot #information panel #housing #analytics #wellbeing #health #InfluxDB #VueJS #Chart.js #GoLang #AWS #sensors #TTN

Housing

The challenge

To develop a working pilot in partnership with the client’s internal IT resource and a Post-Graduate placement. A system that could ingest data from a number of different Elsys IoT sensors in order to provide visual information via an information panel to three very different groups of users; IT staff, Housing welfare team and relatives/friends of a specific resident. In addition to this it was determined that a simple integrated asset management system would be required to underpin the system.

While the objective of the client was to gain practical insights across the organisation on how IoT could be used to help enhance services to their clients, the requirement presented an opportunity to create a viable working system based on open source components, which could, if the initial pilot was successful, be built on to provide real benefits without the significant and ongoing costs that were implicit in buying in the expertise and the services from an established provider.

In seven months and with a team of two, Kodergarten:

  • Designed, built and deployed an information panel that provided secure and GDPR compliant access to a diverse range of users via their browser.
  • Supplied an integrated asset management system which was able to work with The Things Network API to provide robust asset management and provide support for installation and support processes for the IT and installation teams.
  • Created an innovative data ingestion system using influxDB tags to ensure that sensors could be moved or replaced and ensure that data remained consistent for reporting and with the Asset management module.
  • Connected with the Influx Kapacitor system to enable initial analysis of anomaly detection features and capabilities with regard to specific sensors.
  • Produced a basic SMS alert system for Door sensors based on globally set threshold values and a decision making application.
  • Delivered a system that was fully bi-lingual, right down to the axes on the graphs.
  • Deployed onto AWS (Pre-production and Production environments).

Developing a new online bus timetable and service management and PTI compliant export tool for a Welsh LTA

#Public Transport #Pilot #Timetable Management #Data #Buses #TXC #PTI #BODS #Bus Operators #LTA #VueJS #PostGIS #GoLang #AWS #InfluxDB #openstreetmap #leaflet

Bus

The challenge

To produce an integrated public transport service data repository that would give Bus Operators the ability to create and manage services online via a map-centric browser based system that could produce PTI compliant TXC service outputs and accompanying information so that these could be submitted to the UK Traffic Commissioner and Traveline.

With a rapidly changing background of statutory requirements this was a project that started with one agreed set of Data standards, but ended up with different ones. Although the emphasis was on delivering a service to smaller Bus Operators in the county, the system had to support established large operators who already had their own in-house service management systems. The project’s principal objective meant that with the time available to us that it was imperative we took a data-centric approach on how the bus service data could be presented and manipulated by the user(s). It also became apparent that the process of updating, communicating, sharing and ultimately submitting was not as clearly defined as some documentation / user interviews implied at the project’s outset. We had to support a degree of diversity of approach that would ultimately produce a consistent and compliant TXC file output. User interviews also revealed the intricacies of updating different external datasets including NAPTAN and NOC/TNDS, particularly where services crossed county or national boundaries.

In nine months and with a team of four, Kodergarten:

  • Designed, built and deployed a map based Timetable management system that Operators could access securely via their browser.
  • Deployed a comprehensive PTI profile compliance tool for users in order to ensure that the service data they wanted to submit was correct.
  • Provided the integration into existing national datasets such as TNDS, NAPTAN and NOC in order to ensure that the system users had access to current data.
  • Delivered Proof of concept SIRI VM to SM service that could be accessed via external developers for use on websites or information displays.
  • Deployed onto AWS (Dev, Pre-production and Production environments).

Creating a WiFi and IoT sensor analytics platform and login portal for Welsh Town Centres.

#IoT #pilot #information panel #town centre #analytics #wellbeing #health #InfluxDB #VueJS #Chart.js #GoLang #AWS #sensors #TTN #wifi #footfall #patrwm.io #presence #porth #smart towns

Town

The challenge

An earlier project with the two key clients and a partner company had delivered 9 town centre WiFi networks across a Welsh County that provided key analytics back to the communities such as age/gender of visitors and reason for their visit along with information on when they had logged in, how long their visit had been and if they were a return visitor. However the system did not provide data on footfall (how many devices were in the town) unless a premium version was paid for from the existing supplier, the cost of which fell well outside the capacity of available budgets. So the communities and the clients did not have a key metric to hand.

Kodergarten were tasked with creating a system that could provide detailed information on footfall in a town centre WiFi area based on the devices that were ‘seen’ by the network’s access points. Once that the initial requirement had been successfully delivered an additional piece of work was commissioned for a separate system that provided WiFi login portal and bi-lingual questionnaire. Bringing these two solutions in-house meant that it has now become possible to extend the number of town centres and public spaces that can be given access to these services. This projects have been guided throughout to be compliant with current EU & UK data privacy legislation.

In eight months and with a team of two, Kodergarten:

  • Designed, built and deployed an information panel that provided GDPR compliant and open access to aggregated footfall data across all 9 towns.
  • Put in place a new bi-lingual WiFi login portal and questionnaire.
  • Managed the migration from the previous supplier with minimal disruption and full data migration.
  • Brought in loRaWaN IoT air quality monitoring (Luftdaten) data and sensors. .
  • Ensured Privacy was fundamental to the system’s design with regard to anonymisation and data retention (less than 20hrs) for footfall data and separation of WiFi portal system from aggregated footfall data.
  • Deployed on AWS (Pre-production and Production environments)