bcgov / wps

Wildfire Predictive Services to support decision making in prevention, preparedness, response and recovery
Apache License 2.0
39 stars 9 forks source link

UX Research: FOP - How? #1330

Closed tessmgood closed 3 years ago

tessmgood commented 3 years ago

Describe the task Uncover how Kamloops fire centre handles fire occurrence prediction (human & lightning)

Acceptance Criteria

Additional context

tessmgood commented 3 years ago

Findings from database chat with BM in IITD:

  1. there are many databases

    • Fire incidents and Dispatch: have different schema, with some overlapping fields, would have fire starts data, goes back to 1950. Product Owner is GT (non-technical)
    • WF1 weather schema: there is a table named 'lightning', data goes back to 1981 in legacy SQL server, 2018 to current data has been migrated to Oracle, check migraiton progress with Vivid. Product Owner is DH.
  2. there is a database migration happening from SQL server to Oracle

    • recent history should be in Oracle, further back is to be migrated — might pose a short-term challenge for us in accessing historical data.
  3. APIs have been developed by Vivid to grab some of this same information we're interested in (starts, lightning)

    • ACTION: in our to-be-scheduled Vivid chats, ask about APIs and how we can extend them. They appear to only pull one year of data, whereas we are interested in 20 years.
tessmgood commented 3 years ago

On lightning, BL (Senior Wildfire Operations – Kamloops Fire Centre) shared the following (TLDR at the end):

Historically, folks have used Sparky, now they are running database reports to predict starts