ASA: Summarize the Percentage of Combustible Land
- Dominant language
- Python
- Stars
- 65
- Forks
- 11
- Avg merge
- 21h 25m
- Merged PRs (30d)
- 70
Description
**As a** FBA **I need** to summarize the percentage of combustible land area classified as 4,000 to 10,000 kW/m and >= 10,000 kW/m for every forecast and actual grid in our archived data set. We need a script to summarize and explore the data we are working with. **So That** this analysis will inform discussions with our stakeholders around spatial thresholds for issuing advisories.
**Acceptance Criteria**
- [ ] Each row in the table should be stratified by type (forecast/actual), date issued, forecast/actual date, and fire zone.
- [ ] Something like a 24x120 table: each row represents a zone, and for each zone we will have the following header:
- Fire Zone
- Grid Type: (Forecast vs Actual)
- Rundate time
- Fordate [ Not for actuals - (N/A) ]
- Proportion of Combustible land for both 4K and 10K Intensity Classes
**Additional Context**
- Quick & Dirty solution will be appreciated
- Metabase export of database
**Definition of Done**
https://github.com/bcgov/wps/wiki/Definition-of-Done
Contributor guide
Research direction
Start with the Metabase database export and inspect the archived forecast and actual grid data, including the fields for fire zone, run date, forecast date, grid type, intensity class, and combustible land. Determine where a standalone analysis script belongs, then verify that its output has the requested stratified rows and 4K/10K land proportions; use the linked Definition of Done as the completion checklist.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- data, databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100