Admin Tools

Import data, run auto-sync, and manage the platform.

🌎 Auto State Discovery β€” Find All Venues by State

Pick a state β†’ runs every city automatically β†’ venues feed straight into the pipeline for geocoding & enrichment. Zero extra steps.

πŸ” Venue Closure Sweep β€” Find Out-of-Business Venues

AI scans the entire database against live Google, Yelp & news results. Marks closed venues and removes them from public listings automatically.

🧹 Dedup Monitor β€” Cleanup Progress & Audit Log

View per-entity gauges, pause/resume cleanup automations, and browse the full deletion audit log.

⚑ Pipeline Monitor β€” Auto-Geocode & Enrich

View live progress logs of the background pipeline running every 5 minutes. Check geocoded/enriched counts, errors, and cursor state.

πŸ“Έ Manual Image Uploader β€” Replace or Fix Venue Photos

Search any venue, restaurant, or entertainment venue and upload a custom photo directly. Lock or unlock images to control auto-fetcher overwrites.

✦ Recommended Workflow

1. Import new venues, restaurants, or entertainment using the import tools below.  2. Run Data Sync to fetch Google images, fix coordinates, and save Place IDs.  3. Run Traffic Sync to update live crowd levels using Google's open/close data.

Import Tools

Add new venues, restaurants, and entertainment to the platform

SETUP

πŸ”‘ Configure API Keys

Set up Yelp and Foursquare API keys for city data importer. Required before importing venues.

πŸ”„ API Pool Management

Save each API independently. System will automatically cycle through available APIs as they reach monthly limits. At month reset, all APIs reset to 0 usage.

Active Source: Yelp

Currently pooling from this API. Will auto-switch when limit reached.

Google Places

*

Get from Google Cloud Console (Places API)

For client-side requests (premium)

Yelp

ConfiguredACTIVE
Daily Usage
0 / 500

API key configured and ready

Foursquare

Configured
Daily Usage
0 / 100000

API key configured and ready

OpenStreetMap (Nominatim)

Configured

Free unlimited geocoding. Requires a User-Agent header with your contact info.

API key configured and ready

Google Geocoding

*

Can reuse Google Places API key if same project

FREE

🌐 City Data Importer

Import venues from OpenStreetMap (free), Foursquare (100k/mo free), and Yelp (500/day free). No AI credits used β€” pure API, maximum speed.

NEW

πŸ“‹ Bulk List Importer

Paste raw text from chamber/directory listings and convert them into venue records instantly. Supports restaurants, bars, and more.

State Venue Discovery

Streamlined state-wide venue discovery. Load major cities, select which to search, and bulk import venues with auto image queue.

Bars & Venues

Bulk import bars, nightclubs, and event venues using AI search. Select any state and city to import.

Restaurants

Bulk import restaurants with AI-powered search, deduplication, and photo enrichment.

Entertainment

Import bowling alleys, go-kart tracks, and family entertainment centers.

⚠️ One-Time: Backfill State Field on Existing Venues

Sets state=FL on all existing venues and restaurants that are missing a state. Run once β€” button disappears after.