KPIX: Berkeley rezoning affects our businesses
✅ Create multiple .ipynb files programmatically
✅ Organize your workflow into clean, documented notebooks
✅ Set up the entire project structure
✅ Run tests to verify everything works
# Claude Code prompt structure:
Create a series of Jupyter notebooks for Berkeley housing data pipeline:
NOTEBOOK A1: Data Sources Setup
- Connect to Berkeley Open Data Portal API
- Download zoning permits, building permits, inspections, certificates of occupancy
- Set up automated refresh scripts
- Document data schemas
NOTEBOOK A2: Address Standardization
- Load all permit types
- Standardize addresses across different datasets
- Link permits by APN and address
- Create master address registry
NOTEBOOK A3: Geocoding Pipeline
- Use Alameda County address points (existing)
- Handle numerical street variations (FIFTH ↔ 5TH)
- Handle street type variations (AV ↔ Avenue)
- Manual geocoding for new addresses
- Validation: Check coordinates are in Berkeley bounds
"""
NOTEBOOK B1: Project Lifecycle Tracking
- Link zoning permits → building permits → inspections → occupancy certificates
- Track by APN and address
- Calculate timeline metrics:
* Days from proposal to approval
* Days from approval to construction start
* Days from start to completion
* Total development time
NOTEBOOK B2: Status Classification
- Classify each project:
* Proposed (zoning permit submitted)
* Approved (zoning permit issued)
* Permitted (building permit issued)
* Under Construction (inspections in progress)
* Completed (certificate of occupancy issued)
* Stalled (no activity for 180+ days)
NOTEBOOK B3: Progress Indicators
- Track inspection milestones:
* Foundation inspection
* Framing inspection
* Rough electrical/plumbing
* Final inspection
- Calculate % complete based on inspection sequence
"""
"""
NOTEBOOK C1: Pipeline Analysis
- Projects by status (proposed, approved, under construction, completed)
- Units by status
- Conversion rates (% of proposals that get approved)
- Completion rates (% of approvals that get built)
NOTEBOOK C2: Timeline Analysis
- Average time at each stage
- Identify bottlenecks
- Compare by project size
- Seasonal patterns
NOTEBOOK C3: Proposal vs Reality
- Compare proposed units vs actual units built
- Identify projects that changed scope
- Calculate attrition rate (projects that never started)
"""
"""
NOTEBOOK D1: Monthly Progress Report Generator
- Automatically generate report with:
* New proposals this month
* Approvals this month
* Construction starts
* Completions
* Total pipeline status
- Export as PDF or HTML
NOTEBOOK D2: Dashboard Data Export
- Generate JSON files for website dashboard
- Update map data with latest statuses
- Create time-series data for charts
NOTEBOOK D3: Alerts & Monitoring
- Flag projects that have stalled
- Identify inspection delays
- Track projects approaching completion
"""
https://colab.research.google.com/drive/1T9bR1mPLcjOiGpPWY7Y1JIrExPza7crz