Created Fully interactive 3D map showing the type of heating for homes across the UK

Created the database for the CSV file containing the heating data, also added the button to the nav bar and created a link to the page, Added fully rotating 3d map using Deck.gl that takes that data and displays it as hexagons, in the geographical centre for each LSOA in England and Wales. The map has a tooltip that shows the location for each hexagon as well as the amount of homes. Added a floating controller with options to toggle the type of home viewed, as well as the type of heating. Added animations to move from one dataset to the other.

Closes #21 (closed)

app/api/heattype/route.js

+import {PrismaClient} from "@prisma/client";
+
+export async function GET() {
+    const prisma = new PrismaClient();
+
+    try {
+        // Fetch data from the lsoaCoordinates table
+        const coordinatesData = await prisma.lsoaCoordinates.findMany();
+        // Fetch data from the heatingType table
+        const heatingTypeData = await prisma.heatingType.findMany();
+
+        // Create a mapping of geo_code to heating type data
+        const heatingTypeMap = heatingTypeData.reduce((acc, row) => {
+            const geo_code = row.lsoa11cd;
+            acc[geo_code] = row;
+            return acc;
+        }, {});
+
+        // Merge data from both tables based on geo_code
+        const mergedData = coordinatesData.map((row) => {
+            const geo_code = row.geo_code;
+            const heatingDetail = heatingTypeMap[geo_code];
+
+            return {
+                ...row,
+                ...heatingDetail,
+            };
+        });
+
+        // Filter out null values and exclude specific fields
+        const filteredMergedData = mergedData
+            .filter((item) => item !== null)
+            .map(({ geo_label_w, lsoa11cd, ...rest }) => rest);
+
+        return Response.json(filteredMergedData);
+
+        return Response.json(filteredMergedData);
+    } catch (error) {
+        console.error('Error during data retrieval:', error);
+        return Response.json({ error: 'Failed to retrieve data' }, { status: 500 });
+    } finally {
+        await prisma.$disconnect();
+    }
+}
\ No newline at end of file