# Cayman Gas Prices

Source: https://madein.ky/projects/cayman-gas

A site that shows Cayman Islands fuel prices in plain English. It tracks regular, premium and diesel at every station across Grand Cayman, so drivers can find the cheapest fuel near them and see how prices have changed.

## The problem
OfReg, the Utility Regulation and Competition Office, publishes retail fuel prices every Tuesday as a PDF report. The data is public, but it's hard to compare stations, spot trends or answer a simple question like "where is gas cheapest this week?"

## What I built
I built the whole product, from the data pipeline to the dashboard.

- **Data pipeline** — finds OfReg's weekly PDFs, downloads them and parses each report into stations, prices, closures and island-wide averages, going back to 2017
- **Always up to date** — a daily scheduled job checks OfReg and ingests any new report automatically
- **Dashboard** — a map of stations with price pins, the cheapest station for each fuel, island averages with 12-week trends and every station ranked cheapest first
- **Station pages** — a page for each station with its photo, current prices, a map and price history against the island average. Renamed stations keep their full history
- **SEO** — dedicated pages for regular, premium and diesel, with titles and descriptions generated from the latest data

Built with Next.js, React, TypeScript, Postgres, Drizzle and Mapbox, and hosted on Vercel.

## Transparency
The site doesn't set or change any prices. It reads OfReg's official report and presents it clearly, with a link back to the source.

[Visit Cayman Gas Prices](https://gas.madein.ky/)

[See OfReg's retail fuel prices](https://www.ofreg.ky/fuel/retail-fuel-prices)
