County Profile Manager
Geo-aware job intelligence — powers specialty listings, buyer templates, and seasonal matching for both students and buyers.
0
Profiles Seeded
0
Admin Verified
0
With Specialties
Run Step 3
Specialty Jobs Created
Seeding Pipeline
Run in order. Each step builds on the previous. Step 1 can be run multiple times (batches of 20) to process all counties.
Step 0: Seed ZIP-FIPS Map
Populates ZipFipsMap with all U.S. ZIP codes mapped to FIPS county codes. Batches of 500. Run in loops: increment offset by 500 each time until status=complete (~68 runs total).
Offset:
Step 0b: Seed All 3,143 Counties (Hardcoded — No API)
✅ RECOMMENDED. Seeds all 3,143 US counties from a fully hardcoded dataset — zero external API calls, no timeouts, no credit burn. Run in batches of 200, incrementing skip (0, 200, 400...) until complete (~16 runs). Already-seeded counties are skipped automatically.
Skip:
Step 1: Seed County Profiles
Fetches all ~3,155 U.S. counties from ZipFipsMap and creates CountyProfile records. Run in batches of 500. Use state filter (e.g. LA, WA) to seed one state at a time.
Skip:
Step 1b: Bulk Re-Enrich Empty Profiles (LLM)
Finds all county profiles missing climate zone + specialty job types and runs LLM enrichment in PARALLEL — 25 counties simultaneously per run. Run repeatedly until remaining=0. Use state filter to target a specific state.
Step 1c: Fill Missing Specialty Modules (LLM) ✦
Scans ALL county profiles, collects every unique specialty_job_type, then generates one full rigorous certification module (9 sections, 10 quiz questions, FLSA/OSHA references) per call. Click 'Run All' to loop automatically until remaining=0. Run AFTER Step 1b is complete.
Step 2: Seed Specialty Academy Modules
Creates 16 specialty training modules (Ski Lift Safety, Storm Debris Cleanup, Beach Stewardship, etc.) with full LLM-generated content and quizzes.
Step 3: Seed Specialty Job Listings
Creates geo-specific, age-banded, seasonally-gated JobPosting records for every county profile that has specialty job types defined.
Step 4: Seed Buyer Request Templates
Creates buyer-side geo-aware job request templates (snow shoveling, storm cleanup, beach house cleaning, etc.) as ListingTemplates.
County Profiles (0)
Loading profiles...