KPIX: Berkeley rezoning affects our businesses
# CELL: City Configuration Template
city_config = {
"city_name": "Austin, TX",
"state": "Texas",
"data_source": "https://data.austintexas.gov",
# Data endpoints
"permits_api": "https://data.austintexas.gov/resource/3syk-w9eu.json",
"permits_csv": "https://data.austintexas.gov/api/views/3syk-w9eu/rows.csv",
# Column mappings (adjust to your city's data)
"columns": {
"address": "Original Address",
"permit_number": "Permit Number",
"permit_type": "Permit Type Desc",
"issue_date": "Issue Date",
"status": "Status Current",
"units": "Housing Units",
},
# Geocoding
"geocoding_service": "Nominatim", # or "Google", "Mapbox"
"county_gis": "https://gis.traviscountytx.gov/",
# Analysis focus
"focus_areas": ["Downtown", "East Austin", "South Congress"],
"years": [2020, 2021, 2022, 2023, 2024],
}
# Save configuration
import json
with open(f'config/{city_config["city_name"].replace(", ", "_").lower()}.json', 'w') as f:
json.dump(city_config, f, indent=2)
print(f"✅ Created configuration for {city_config['city_name']}")
```
---
## **📊 EXAMPLE COMPLETED PROJECTS**
### **Structure for `completed_projects/`:**
```
completed_projects/
├── berkeley_ca/
│ ├── README.md ← Project overview
│ ├── data/
│ │ └── housing_projects.csv
│ ├── notebooks/
│ │ └── analysis.ipynb
│ ├── website/
│ │ └── index.html
│ ├── findings.md ← Key insights
│ └── presentation.pdf
│
├── oakland_ca/
│ └── [same structure]
│
└── chicago_il/
└── [same structure]