HIGHSTREET‑ME1

• ■ Running an ETL pipeline to turn unstructured HTML and wildly inconsistent civic data sources into a clean, typed schema. You'd think the council could manage a spreadsheet. Reader, they cannot.
• ■ Rendering a fully interactive High Street map in nothing but HTML and CSS — no canvas, no SVG library, no framework. Turns out that means building a relational data model from scratch just to plot shop positions. Who knew retail geography was basically a graph problem… wtf!!! i dont even have GCSE's
• ■ Hunting for a lower-latency tide feed. The nearest live gauge is downstream at Sheerness, and the APIs with real precision all want a paid subscription. Not doing that.
• ■ Closing coverage gaps in the P102 shop dataset one business at a time. If that's you, get in touch and become a data point.
• ■ Scouting new data sources to feed into the pipeline — more feeds, more signal.

← Back to P101

• ✓ An upstream payload was leaking "closed 10am–11:30am" operational metadata into the ticker instead of just the event name. Slapped a regex on it — ticker now speaks names only, not opening-hours noise.
• ✓ A multi-week event was rendering off its start-date timestamp only, so mid-run it looked like ancient history. Now checks whether today sits inside the [start, end] window and renders "Until <end date>" instead.
• ✓ A stray admin-only record slipped past the ingest filter and onto the public payload. Added a title-pattern exclusion so backstage entries get caught before they ever render.
• ✓ One flaky upstream endpoint returning non-200 was enough to null out the entire What's On render — a single rejected Promise.all() took the whole panel down with it. Now every source resolves independently and fails soft.

← Back to P101

• ■ A live ticker-tape feed streaming real-time coffee prices across every shop on the High Street.
• ■ A gamified leaderboard — because nothing motivates quite like public, unnecessary competition.
• ■ Every business gets its own sub-page: tap a listing and a mini ticker splash unrolls just for them — happy hour starting, tonight's specials, live music at 8 — like each shop has been handed its own slice of Ceefax.
• ■ Instagram integration that reads a business's own recent posts and spits out a ready-made "publish" template — photo slot, caption, seventeen hashtags nobody asked for — so the pub down the road can announce quiz night without agonising over emoji placement for forty-five minutes.

← Back to P101