StreetSignal Digest Generation

Generate hyperlocal crime and safety trend reports for Columbus, Ohio neighborhoods targeting real estate investors.

Target Neighborhoods

• German Village (affluent, historic, strong investment interest)
• Short North (trendy, high turnover, crime concerns)
• Clintonville (family-oriented, stable, growing)

Process

Step 1: Planning (use claude-opus-4-6 via Omni/Agent.hs)

Use opus to identify data sources and plan scraping strategy:

/home/ben/omni/ava/_/bin/omni-agent \
  --model anthropic/claude-opus-4.6 \
  --prompt "Plan a data collection strategy for crime and safety trends in [NEIGHBORHOOD], Columbus OH. Identify: (1) Columbus Police data sources (public portals, crime maps, reports), (2) any supplementary data (news, local forums), (3) extraction strategy. Output: list of URLs to scrape and what to extract from each."

Step 2: Execute Scraping

Use bash/curl/wget to fetch data based on opus plan.

Step 3: Summarization (use claude-haiku-4-5 via Omni/Agent.hs)

Process each data source with haiku:

/home/ben/omni/ava/_/bin/omni-agent \
  --model anthropic/claude-haiku-4.5 \
  --prompt "Summarize this crime data for real estate investors. Extract: incident types, counts, severity, geographic clusters, and notable trends. Be specific with numbers. Input: [SCRAPED_DATA]"

Step 4: Trend Analysis

Read previous report for same neighborhood (if exists) and calculate month-over-month changes.

Step 5: Generate Report

Create markdown file at /var/streetsignal/reports/{location}/{YYYY-MM-DD}.md with:

Frontmatter:

---
date: YYYY-MM-DD
neighborhood: [NAME]
total_incidents: [COUNT]
incident_types:
  theft: [COUNT]
  assault: [COUNT]
  vandalism: [COUNT]
  # etc
severity_score: [1-10]
trend_vs_last_month: [+/-X%]
---

Body:

• Executive summary (2-3 sentences)
• Key metrics (total incidents, types, hotspots)
• Trends (vs last month if available)
• Investment implications (what does this mean for property values, rentals, etc)
• Notable incidents (if any major events)

Usage

Load this skill and specify neighborhood:

Generate StreetSignal digest for German Village

The skill will execute all 5 steps and output the report path.