πŸ“ Venues & Fields

Seed and maintain venue, field, and zip code data

← Back to Dashboard

Seed Venues

Creates venue records (Venue ID, Venue Name, Address, City, State) for all CT venues in the scheduling system. Safe to re-run β€” duplicates are skipped by Venue ID.

Patch Club Links

Links each venue to its club in the Clubs table. Run after seeding new venues.

Patch Zip Codes

Writes the Zip field on each venue record. Used for referee proximity sorting. Safe to re-run β€” already-patched venues are skipped.

Seed Fields

Creates individual field records within each venue. Safe to re-run β€” duplicates are skipped by Field ID.