Column mapping — match your columns to required fields
📍 Location source
Expected CSV format
With Google geocoding: address, city, state, zip are used to get precise coordinates. lat/lng from CSV are ignored.
Also recommended: tiv, policy_number, tribe, cell
Cell values: TGB (Tribal Government Buildings) or IHBG (Indian Housing Block Grant)
location_address,location_city,location_state,location_zip,tiv,policy_number,TribalAffiliation,cell
"123 Main St","Flagstaff","AZ","86001",250000,POL-001,"Navajo Nation",TGB
"456 Tribal Rd","Nespelem","WA","99155",185000,POL-002,"Colville Tribes",IHBG
Alert thresholds
Fire proximity (miles)
Risk score threshold
Drought change alert
Red flag warning alert
Topographic fire direction
Moratorium score — factor weights
Adjust how each factor contributes to the territory-level moratorium score. Weights must total 100%.
Active fires within proximity
25%
Drought severity (D0–D4)
20%
% properties at high risk
20%
TIV concentration exposed
15%
Red flag / fire weather
12%
Terrain / wind amplification
8%
Total weight
100%
Tier thresholds
Watch starts at
35
Warning starts at
60
Moratorium starts at
80
Preview — sample territory
Simulates a territory with 2 nearby fires, D3 drought, 45% high-risk properties, 60% TIV exposed, active red flag, high terrain risk.
—
—
—
Monitor schedule
Monitor runs automatically every 6 hours via Supabase Edge Functions.
Last run: —
Next run: —