Weather Data Import Wizard

[spydmobile]

Summary

A multi-step wizard (similar in UX to the existing New Fire Model wizard) that guides users through importing weather observation data from various sources, ensures correct column mapping and value interpretation, calculates CFFDRS codes as needed, and validates the data for 100% FireSTARR ingestion compatibility.

Motivation

FireSTARR requires weather data in a specific format with CFFDRS codes (FFMC, DMC, DC, ISI, BUI, FWI) present. Users currently must manually reformat weather data and calculate codes before import. This wizard eliminates that friction — making weather data preparation accessible to users who aren't CFFDRS experts.

Supported Import Sources

File Import

• CSV (.csv)
• Formatted text (.txt)
• Excel (.xlsx)

SpotWx Integration

• SpotWx API — direct integration via user-provided API key
• SpotWx file download — import files downloaded from spotwx.com in any of their supported export formats

Wizard Steps (Proposed)

1. Source Selection — Choose import source: file upload or SpotWx API
2. File/API Configuration — Upload file or configure SpotWx API connection (API key, station, date range)
3. Column Mapping — Interactive UI to map source columns to required FireSTARR weather fields. Wizard should auto-detect common formats and suggest mappings, but let user confirm/override
4. Value Interpretation — Confirm units (°C vs °F, km/h vs m/s, etc.), timezone, observation interval. Flag ambiguous values for user resolution
5. CFFDRS Code Handling — If CFFDRS codes are present in the data, map them. If not, offer two paths:
   • User provides starting values (already implemented in the app)
   • Auto-calculate using the project's CFFDRS libraries
6. Validation — Preview the reformatted data. Run validation rules against FireSTARR ingestion requirements. Show pass/fail summary with details on any issues
7. Execute Import — Confirm and import the validated weather data

Acceptance Criteria

• Supports CSV, TXT, and XLSX file formats
• SpotWx API integration with API key configuration
• SpotWx downloaded file import (all SpotWx export formats)
• Interactive column mapping with auto-detection
• Unit conversion and value interpretation assistance
• CFFDRS code calculation from raw observations using existing libraries
• Validation step that catches format/data issues before import
• Produces 100% FireSTARR-compatible weather data
• Multi-step wizard UX consistent with the existing New Model wizard