Create Sandbox Project

Create a single-click county sandbox project pre-loaded with the county's boundary layer.

Two-phase: this handler runs phase 1 (validate FIPS, insert PENDING project row, return project_id) synchronously and enqueues phase 2 (Neon name resolve, CREATE MATERIALIZED VIEW, register boundary layer, flip status to READY) on the Celery sandbox_boundary queue. Celery is used instead of FastAPI BackgroundTasks so a Cloud Run instance restart between response and task completion can't strand the project in PENDING — the broker persists the job until a worker acks.

Workspace RBAC: rejects FIPS codes not in the user's available geographies (403). FIPS not loaded into the workspace's workspace_counties table is a 404 before any project row is inserted. Failures inside the background task mark the project status=FAILED (visible on the project page); the task itself retries with exponential backoff before reaching that state.