Skip to content

FL 
HSE

Tailored Technology, Transforming Vision into Productivity.

Project Overview
 

The FLHSE Operational Platform was a bespoke, cloud-hosted database and reporting system built for the HSE’s National Health Sustainability Office, delivered through Frontline Energy & Environmental, who held the national HSE energy management contract. iWorks designed and built the full platform, integrating with GeoPal’s mobile field survey application to create an end-to-end solution for managing energy data across the entire Irish public health estate.
 

The Challenge
 

The HSE had thousands of properties scattered across every county in Ireland with no centralised view of their energy usage, utility meter references, site photographs, or billing history. Frontline Energy had field assessors visiting each property with tablets to capture data — but there was no system to aggregate, validate, and report on that information at scale. The platform needed to handle two categories of HSE site simultaneously: Lot 1A (Direct) sites managed directly by the HSE, and Lot 1B (Funded) sites managed by external agencies.
 

What Was Built

 
The platform provided a single operational hub covering the full lifecycle of site data — from field capture through to HSE reporting. Key capabilities included:

  • Central site database — Each HSE property was assigned a Unique Site Identifier (USID) and linked to GPS coordinates, site photographs, building size, and all utility meter references (electricity MPRNs, gas GPRNs, water meters, oil).
  • GeoPal field app integration — When site assessors completed a survey on their tablet in the field, data flowed directly into the FLHSE database in real time.
  • Interactive heatmap — A national map of all HSE sites displaying status, site type, and energy data at a glance.
  • Bulk utility bill upload — Frontline’s team uploaded structured Excel files of utility bills from energy suppliers. The system parsed each file and automatically associated consumption and expenditure figures to the correct site and energy type (electricity, gas, kerosene, gasoil, LPG, diesel, water, and heating oil variants).
  • Consumption and expenditure reporting — Graphical reports per site and per energy type, filterable by date range and energy supplier.
  • Excel export reports — Full data exports for HSE reporting and compliance requirements.
  • Admin and edit panel — Frontline staff could view, edit, and manage all site records through a purpose-built control panel.
  • Search and filter — Sites searchable by county, site type (Direct/Funded), energy type, supplier, and USID.

 
Scale

  • 3,374 HSE sites — 2,465 Direct and 909 Funded
  • 9,273 site images stored and served from the platform
  • Up to 909 data fields per site record
  • All 26 counties covered, with Dublin (738 sites), Cork (283), and Donegal (271) among the largest
  • Major hospitals included Beaumont, the Rotunda, Temple Street, the Coombe, St Vincent’s, St John’s Limerick, and Kerry General, among many others
     

Technology

 
The platform was built on Apache, Perl, PHP, and MySQL, hosted on a cloud server with daily, weekly, and monthly automated backups. In early 2014 the system was also deployed locally onto HSE desktop PCs, requiring a custom installation and configuration process to replicate the cloud environment on standalone machines.
 

Project Timeline

  • April 2013 — Project kick-off following HSE contract award to Frontline Energy
  • May–August 2013 — Platform development, GeoPal API integration, data template finalisation with utility suppliers
  • September 2013 — System live; Frontline uploading site survey data and utility bills; HSE Procurement given access
  • October–November 2013 — National data upload phase; live demonstration to the HSE on 5 November 2013
  • December 2013 — Database configuration meeting at Sir Patrick Dun’s Hospital with HSE Estates
  • March 2014 — Local installation at Cherry Orchard Hospital; HSE took full ownership of the platform
  • 2014–2015 — Ongoing domain, SSL, and hosting management by iWorks
     

Client

 
Frontline Energy & Environmental, on behalf of the HSE National Health Sustainability Office — in partnership with GeoPal Solutions (mobile field data capture).

Frontline Energy HSE