← All projects

StageIn developmentAreaTools

Councillor’s Workspace

Bringing documents, local news, email and calendar together to help prepare for council work.

Documents, calendar and email connected in a councillor’s tool.

Problem

Preparing for council work means gathering documents and understanding how they relate to local news, correspondence and upcoming meetings.

Solution

The workspace brings these materials together, with summaries, key passages, related news coverage and extracts from legislation. A daily Pruszków news digest and email and calendar integrations are already working.

My contribution

Designing and developing the tool for my own use, then preparing a version for other councillors.

Built for my own council work

I built the workspace to help me navigate council documents, spot connections and get an initial understanding of an issue before examining it in more depth.

Project status

I use the tool myself and have prepared a version for other councillors. The next step is a pilot with a small group; it has not yet been rolled out to other users.

Technology

The backend is Python and FastAPI, with data in SQLite, Alembic migrations (SQLAlchemy) and scheduled jobs in APScheduler. PDF, DOCX, XLSX and HTML documents are converted to text, and news sources are collected from RSS feeds and web pages. The interface is built with React, TypeScript and Tailwind CSS. Summaries come from a language model behind a replaceable provider layer.

The role of AI

Early on, I compared the AI’s output with source documents and refined what it should highlight. I now use the context, quotations and legislative extracts to get an initial overview. I do not systematically check every output against its source.

AI can make mistakes. The workspace helps with preparation and an initial overview; its output is not presented as verified legal analysis.

Technologies

Python, FastAPI, SQLite, React, TypeScript, Tailwind CSS, LLM, Gmail and Google Calendar

Last updated: