missouriconstruction.com

MissouriConstruction.com - AI Content Engine

Master Django Framework for Multi-Site City Directories

Built by Gregory Woodruff | Cloud and Secure Limited
Course: YouBetYourAzure.com

🎯 What is This?

MissouriConstruction.com is the master Django framework that powers multiple city directory websites from a single codebase:

Total Scale: 228+ cities, 6+ sites, all managed from one admin interface.

🏗️ Architecture Overview

Foundation (Complete ✅)

Core Models:

Why This Design?

Data Layer (Complete ✅)

Census API Integration:

AI Content Engine:

Export Capabilities:

🚀 Quick Start

1. Setup Environment

# Navigate to project
cd "missouriconstruction.com"

# Install dependencies
pip install -r requirements.txt

# Create .env file
cp .env.example .env

Edit .env file:

SECRET_KEY=your-secret-key-here
DEBUG=True
ALLOWED_HOSTS=localhost,127.0.0.1

# Census Bureau API (free)
CENSUS_API_KEY=your-census-api-key

# OpenAI API (required for AI content)
OPENAI_API_KEY=sk-proj-your-key-here

# Google Analytics (optional)
GOOGLE_ANALYTICS_ID=G-XXXXXXXXXX

2. Initialize Database

# Run migrations
python manage.py migrate

# Create superuser
python manage.py createsuperuser
# Username: admin
# Email: your-email@example.com
# Password: (choose secure password)

3. Populate Springfield Cities

# Add all 24 Springfields
python manage.py populate_springfields

# Output:
# ✅ Created site: seekingspringfield.com
# ✅ Created: Springfield, IL
# ✅ Created: Springfield, MO
# ... (22 more)
# Total: 24 cities

4. Fetch Census Data

# Fetch demographics for all Springfields
python manage.py fetch_census_data --site seekingspringfield.com

# Output:
# [1/24] Processing: Springfield, Illinois
# ✅ Population: 114,394 | Median Income: $62,000
# [2/24] Processing: Springfield, Missouri
# ✅ Population: 168,122 | Median Income: $45,000
# ... (22 more)
#
# Updated: 24
# Skipped: 0
# Errors: 0
# Total Population: 1,234,567

Pro Tip: Get free Census API key at https://api.census.gov/data/key_signup.html

5. Generate AI Content

# Generate 3 articles for testing
python manage.py generate_daily_content \
  --site seekingspringfield.com \
  --type city_guide \
  --count 3

# Output:
# [1/24] Processing: Springfield, Illinois
# 🤖 Generating city_guide article...
# ✅ Generated 587 words (2,341 tokens, Quality: 89%)
# [2/24] Processing: Springfield, Missouri
# ✅ Generated 612 words (2,453 tokens, Quality: 92%)
# [3/24] Processing: Springfield, Massachusetts
# ✅ Generated 595 words (2,387 tokens, Quality: 88%)
#
# Articles Generated: 3
# Total Words: 1,794
# Total Tokens: 7,181
# Estimated Cost: $0.32

Important: Articles are created as UNPUBLISHED - review in admin before publishing!

6. Review in Admin

# Start development server
python manage.py runserver 8002

# Open in browser:
# http://localhost:8002/admin/
#
# Login with superuser credentials

Admin Sections:

7. Export for Power BI

# Export Springfields for visualization
python manage.py export_census_data \
  --site seekingspringfield.com \
  --format powerbi \
  --include-articles

# Output:
# 💾 Saved 24 cities to Power BI CSV
# 
# Output: seekingspringfield_20260226.csv
#
# Import to Power BI Desktop:
# 1. Get Data > Text/CSV
# 2. Select file
# 3. Create visualizations (maps, charts, tables)

📊 Management Commands Reference

populate_springfields

Add all 24 Springfield cities to database and link to seekingspringfield.com.

# Create all cities
python manage.py populate_springfields

# Preview without creating
python manage.py populate_springfields --dry-run

Output:

fetch_census_data

Fetch demographic data from U.S. Census Bureau API.

# Fetch for all cities
python manage.py fetch_census_data

# Fetch for specific site
python manage.py fetch_census_data --site seekingspringfield.com

# Fetch for one city
python manage.py fetch_census_data --city "Springfield, IL"

# Overwrite existing data
python manage.py fetch_census_data --force

# Test without making changes
python manage.py fetch_census_data --dry-run

# Use specific API key
python manage.py fetch_census_data --api-key YOUR_KEY_HERE

Options:

Data Fetched:

generate_daily_content

Generate AI-powered articles using GPT-4.

# Generate 1 article for all cities
python manage.py generate_daily_content

# Generate for specific site
python manage.py generate_daily_content --site seekingspringfield.com

# Generate specific article type
python manage.py generate_daily_content --type tourism

# Generate 10 articles (batch)
python manage.py generate_daily_content --count 10

# Test without spending money
python manage.py generate_daily_content --dry-run

# Use specific API key
python manage.py generate_daily_content --api-key sk-proj-...

Options:

Article Types:

  1. city_guide - Comprehensive overview (500-800 words)
    • SEO: “Springfield Illinois city guide”
    • Audience: People considering moving or visiting
  2. demographics - Data-heavy analysis (300-500 words)
    • SEO: “Springfield demographics”
    • Audience: Businesses, investors, researchers
  3. tourism - Visitor-focused (400-600 words)
    • SEO: “things to do in Springfield”
    • Audience: Tourists, convention attendees
  4. living_here - Lifestyle quality (500-700 words)
    • SEO: “living in Springfield Illinois”
    • Audience: Potential residents

Cost: ~$0.10-0.30 per article (GPT-4 pricing)

export_census_data

Export city data for visualization and analysis.

# Export to CSV
python manage.py export_census_data --format csv

# Export for Power BI
python manage.py export_census_data --format powerbi

# Export to Excel
python manage.py export_census_data --format excel

# Export to JSON
python manage.py export_census_data --format json

# Export specific site
python manage.py export_census_data \
  --site seekingspringfield.com \
  --format powerbi

# Include article counts
python manage.py export_census_data \
  --format csv \
  --include-articles

# Include business revenue
python manage.py export_census_data \
  --format csv \
  --include-businesses

# Custom output filename
python manage.py export_census_data \
  --format csv \
  --output my_data.csv

Options:

Output Columns:

💰 Revenue Streams

1. AdSense (Passive Income)

Model: Display ads on high-traffic city pages

Calculation:

Optimization:

2. Premium Business Listings

Model: 3-tier directory pricing

Tiers:

Calculation:

Target Markets:

3. Data Reports (High Margin)

Model: Sell custom Power BI dashboards and CSV exports

Products:

Target Customers:

Calculation:

4. Educational Content (Traffic + Leads)

Model: Document everything we build as courses on YouBetYourAzure.com

Courses:

  1. Census API Integration - $49
  2. AI Content Generation - $99
  3. Power BI Visualization - $149
  4. Multi-Site Django - $199

Revenue:

Strategy: “30 minutes documentation per 8 hours coding” = 3X revenue multiplier

📈 Scaling Strategy

Phase 1: Validate with Springfields (Current)

Goal: Validate business model with one site before scaling to 6 sites.

Phase 2: Expand to All 6 “Seeking” Sites

Total: 228 cities across 6 domains

Content Generation:

Phase 3: Add Industry Directories

Revenue: Premium business listings ($50-150/month × 1,000+ businesses)

Phase 4: Data as a Service

🎓 Educational Content Strategy

“Build While We Document” Philosophy

Principle: Every hour of coding = 7.5 minutes of documentation

ROI: 12.5% time overhead for 3X revenue multiplier (25X ROI!)

Implementation:

Result:

Current Course Modules

  1. CENSUS_API_COURSE_MODULE.md ✅
    • 8 modules covering Census API integration
    • Lab exercises and real-world use cases
    • Business applications and pricing strategies
  2. AI_CONTENT_ENGINE_COURSE_MODULE.md ✅
    • Building modular data aggregators
    • Prompt engineering for quality content
    • Power BI export and visualization
    • Error handling and cost management

Future Course Modules (Planned)

  1. Multi-Site Django Architecture (Q2 2026)
  2. AdSense Optimization (Q2 2026)
  3. Premium Listing Sales Funnel (Q3 2026)
  4. Restaurant & Business Scraping (Q3 2026)
  5. School District Rankings Integration (Q3 2026)
  6. Seasonal Content Automation (Q4 2026)

🔧 Technical Details

Project Structure

missouriconstruction.com/
├── mocon/                          # Django project
│   ├── settings.py                 # Configuration
│   ├── urls.py                     # URL routing
│   └── wsgi.py                     # WSGI for deployment
│
├── core/                           # Shared models and logic
│   ├── models.py                   # 6 core models
│   ├── admin.py                    # Admin interface
│   ├── census_api.py               # Census API client
│   ├── ai_content_engine.py        # AI content generation
│   └── management/
│       └── commands/
│           ├── fetch_census_data.py
│           ├── generate_daily_content.py
│           ├── export_census_data.py
│           └── populate_springfields.py
│
├── sites/                          # Site-specific logic (future)
├── ai_engine/                      # AI engine (future expansion)
│
├── templates/                      # HTML templates (to be built)
│   ├── base/
│   │   ├── base.html              # Shared layout
│   │   ├── city_home.html         # City landing page
│   │   └── article.html           # Article display
│   └── ...
│
├── static/                         # CSS, JS, images (to be built)
├── media/                          # User uploads (logos, photos)
│
├── requirements.txt                # Python dependencies
├── .env.example                    # Environment template
├── .gitignore                      # Git exclusions
├── manage.py                       # Django CLI
│
└── Documentation/
    ├── README.md                   # This file
    ├── CENSUS_API_COURSE_MODULE.md
    └── AI_CONTENT_ENGINE_COURSE_MODULE.md

Tech Stack

Backend:

APIs:

Frontend (To Be Built):

Deployment:

Analytics:

🚨 Important Notes

Articles Start UNPUBLISHED

Why? AI is good but not perfect. Always review before publishing:

How to Publish:

  1. Go to http://localhost:8002/admin/core/article/
  2. Click article to edit
  3. Review content carefully
  4. Check “Published” checkbox
  5. Set “Published date” to today
  6. Save

Cost Management

Census API: FREE (no limit)

OpenAI GPT-4:

Budget Example:

Pro Tip: Use --dry-run to preview before spending money!

Data Accuracy

Census Data:

AI-Generated Content:

📞 Support

Get Help

Email: gregory.woodruff@cloudandsecurelimited.com

GitHub: github.com/cloudandsecurelimited/missouriconstruction

Course Forum: youbetyourazure.com/community

Office Hours: Wednesdays 2-4 PM CST

Hire Us

Custom Implementation: $5,000+

Consulting Retainer: $2,000/month

Partnership Program:

Contact: sales@cloudandsecurelimited.com

📄 License

MIT License - Use commercially, modify freely, teach others.

Attribution: Link back to youbetyourazure.com

Support: Hire us for consulting or send students our way!

Built by: Gregory Woodruff
Company: Cloud and Secure Limited
Course: youbetyourazure.com
Updated: February 2026
Version: 1.0