FLSiMAP

The Challenge

FLSiMAP was developed to provide critical insights into osteoporosis statistics and demographic data by pulling publicly available information from various sources, including the Fracture Liaison Service. This data is mapped to hospitals and Integrated Care Boards (ICBs), offering users a navigable, visual representation of local healthcare performance. The challenge lay in gathering data from multiple sources and normalizing it for meaningful comparison across different regions.

Beyond data collection and normalization, the platform required a seamless integration with Google Maps to visualize ICB boundaries and hospital performance in an intuitive way.

Our Approach

We built the platform using NextJS for a fast and scalable web experience, while Airtable served as the backend, enabling efficient data management and updating. To deliver a rich, interactive user experience, we integrated with Google Maps to display the performance of hospitals and ICBs. The maps feature color-coded pins for hospitals, indicating their performance in osteoporosis care, allowing users to explore how different health boards are performing.

Our team tackled the complexity of normalizing the incoming data, ensuring that information from different sources could be aligned and compared seamlessly. The platform’s map interface provides users with an easy way to navigate through regions, view performance metrics, and understand the healthcare landscape in their area.

The Results

FLSiMAP is now an essential tool for healthcare professionals and the general public, offering a clear and user-friendly way to explore osteoporosis data across various regions. The use of NextJS ensures a smooth and responsive experience, while Airtable allows for easy updates and management of the underlying data. The Google Maps integration brings the data to life, offering a clear visual of hospital performance through color-coded pins and ICB boundaries.

By successfully normalizing data from multiple sources and delivering it in an accessible format, FLSiMAP enables users to make informed decisions and pinpoint areas in need of improvement in osteoporosis care.