v4

latestOpenAPI 3.1.02026-08-08278476614.0 KB
project

Warm County Boundary

Pre-warm the boundary MV for a county without creating a project.

Called from the picker the moment a user soft-selects a county, so the Neon roundtrip (TIGER GEOID lookup + CREATE MATERIALIZED VIEW + index) overlaps with prompt composition instead of blocking the subsequent project-create. Idempotent — the MV is workspace-scoped and deterministically named by county_fips; concurrent warms are serialized inside ensure_county_boundary_mv by an advisory lock and the second caller fast-paths on the existing MV.

Workspace RBAC mirrors create_sandbox_project: FIPS not in the user's available geographies → 403, FIPS not loaded into the workspace's workspace_counties table → 404, FIPS not present in the workspace's tiger_county table → 404. No project row is created on any path — the warm flow is read-only at the app-DB level.

post/api/v1/project/sandbox/warm-county

Request body

county_fipsstring required

5-digit US county FIPS code (e.g. '12103' for Pinellas, FL)

Response

Successful Response

county_fipsstring required
readyboolean