[ENH] - SARCOP Situation Report Tally Process

[pjdohertygis]

Which app?

Other

Describe requirements

Real-world Problem: There are various stakeholders that want to generate situation report "tallies" from SARCOP

• FEMA US&R Incident Support Team (IST) - Situation Unit Lead (SITL) needs to create a tally for the US&R 209, usually once a day at the conclusion of the operational period.
• The NRCC Situation Awareness Section (SAS) - Also want to provide summarize reports of SARCOP activity.

Technical Problem: Currently we teach a process for using the "Strategic Dashboard" but it is prone to human error and inconsistency based on the times the data is extracted.

Proposed Solution: A dedicated layer/table that powers a specific, standalone Dashboard, potentially powered by a script to reduce complexity and increase consistency. We might need two processes - one for IST 209 and one for NRCC 209.

Alternatives

Status Quo

Other Relevant Info

See related issues #145 and #123

Current workflow

1. Open Strategic Dashboard https://experience.arcgis.com/experience/9051a07ffd1947bbb395e9f9b4088f85/page/Strategic
2. Follow screenshots to download summarized data as csv
3. Copy and paste csv data into Excel "template"
4. The Excel lookup equations and arithmetic provide a table that can be cut and pasted into the ICS209 process. 

Priority impact

p1 - time sensitive

Impact

Very important!