The Civic Commons Access to tools for building community where you live
Build prompt · from the tool gallery collection

Street Beat Newsletter Generator

Contributed by Grant from Inner Richmond, SF. A tool for a neighborhood curator to turn photos of street posters and neighbor observations ('stoop talk') into a curated weekly email newsletter. It prioritizes 'street data' and human curation over algorithmic feeds.

App Title: Street Beat Newsletter Tool

Context: Build a mobile-first web app for a neighborhood curator (human-in-the-loop). The goal is to walk around a neighborhood, capture information from physical posters AND text notes, and export it all into a single, formatted HTML email newsletter at the end of the week.

Core Features:

  1. THE CAPTURE INTERFACE (Home Screen)

Create two distinct 'Input' buttons at the top: A. 'Scan Poster' (Camera Action)

  • Opens camera.
  • Captures photo.
  • Uses AI Vision (e.g. GPT-4o) to extract Title, Date, Time, Location, Description.
  • Saves the cropped image of the poster.

B. 'Stoop Talk' (Text Note Action)

  • A simple text field for quick observations (e.g., 'The cherry blossoms on 6th Ave are popping', or 'Street cleaning is canceled tomorrow').
  • A 'Category' dropdown (General, Alert, Appreciation, Lost & Found).
  • No image required.
  1. THE REVIEW DASHBOARD (The Editor)

A list view of all items captured this week.

  • Allow me to edit the text for both Posters and Notes.
  • Allow me to delete/archive items that are spam or duplicates.
  • Allow dragging and dropping to reorder.
  1. THE NEWSLETTER GENERATOR (Export)

A button that says 'Copy Email HTML.' It should generate code compatible with standard email clients (Gmail/Substack).

Layout Structure:

  • Header: 'This Week in [Neighborhood Name]'
  • Section 1: 'Stoop Talk' (The Text Notes)

-- Display these as a clean, bulleted list or small text cards. -- Use a light background color to separate them from events.

  • Section 2: 'On The Board' (The Posters)

-- Display each event with the full-width image of the poster. -- Below the image, put the Title, Date, and Location in clear, bold text.

  • Footer: 'Curated by a human neighbor.'

STYLE GUIDE:

  • Aesthetic: High contrast, utilitarian, 'Street smart.'
  • Typography: Clean sans-serif (Inter or Roboto).
  • Accent Color: Neon Yellow or Safety Orange.

TECHNICAL STACK:

  • React / Next.js
  • Supabase for database (preserves drafts efficiently).
  • OpenAI API (or similar) for the Vision/OCR tasks.
  • Tailwind CSS for styling.
Connected in the commons

Relational Tech Studio library · RCL-1.0

See something to fix or add? Suggest an edit on GitHub — the commons lives in git too, and its history is the changelog.

Communication

Remix this in Relational Builder  Browse the commons