Sprint 68

Monday, December 12, 2022 – Thursday, January 5, 2023

Sprint Goals:

RiskProfiler

• Link-checker in gh-actions - riskprofiler repo - Drew/Damon

  • Follow up on link-checker dead links - add issue to riskprofiler repo

• French Language Translation - Drew/Anthony

  • In progress waiting on procurement

• Wordpress Migration - Drew/Anthony

  • Will require new SA&A 3-6 month lead time

• Add additional DSRA scenarios Drew/Will/Anthony

  • wait for opendrr-api/model-factory v1.4.4 - blocked by issue-236 (https://github.com/OpenDRR/opendrr-api/issues/236) - Drew
  • request Damon walk us through the branch workflow

• Document deployment process, see Procedure to update RiskProfiler website (80% complete) - Anthony

  • defer to french language deployment

• Tutorial with someone else running static site generation workflow - Anthony

  • defer to french language deployment

• Replace RiskProfiler SVG image in top left page #98 - Anthony

• Update Julie VdV contact email to 'earthquake risk' email #99 - Anthony

• Correct PSRA Download link (currently points to re-direct page) #97 - Anthony

GitHub

• Run GH action to check for French READMEs (LISEZMOI) and open issue if missing - Damon/Drew

• Write GH action to run DeepL and create LISEZMOI files on Changes to README - Drew (40-50% done)

• General update and review of all README files and licenses

• Boundaries v1.5.0 PR #45 (Anthony - bug in gh action)

Elasticsearch - Kibana - PostGIS

• Wiki Document Required data sets for version/subversion release (Drew)

  • ES indices
  • pygeoapi config
  • vector tiles (Damon/Anthony)
  • https://github.com/OpenDRR/riskprofiler/wiki/RiskProfiler-Datasets/

• DSRA Dashboards in Kibana (Drew)

  • Open up comms with DFC again - Sprint 69 (January) - [ ] Looking National EP curves - [ ] DSRA scenarios not consistent

• Fix add_data.sh bug - single source for DSRA repo issue-236 (Drew Anthony) - Mostly done - still working through 'master branch' bug

• Run stack build in EC2 full scripted with AWS CLI - Sprint 69 (January)

Data Dissemination

FGP:

• PSRA - in progress (Will - Waiting for CIO approval?)
• DSRA each scenerio - adding 4x new scenarios v1.4.3 - in progress (Will)
• NHSL
• Exposure

GitHub pages for new DSRA scenarios

• Add new GitHub page for each DSRA scenario (Anthony, Will)

OpenDRR Administrative

• • Document Process on how to add new DSRA scenario (Anthony, Drew, Will, Damon) - Sprint 69 (January)

---

Demos:

Drew - DeepL GH Action for READMEs - add_data.sh DSRA repo/branch bug

Anthony - WordPress static demo (defer to Sprint 69) - Findings on WP website structure, how to fix FR pages (defer to Sprint 69) - DSRA GitHub pages - inner workings (defer to Sprint 69)

Scrums:

Thursday, December 15, 2022

Drew - Worked DSRA repo/branch bug in opendrr-api -

Will - Working on FGP, 1.4.3 references - French still pending - Updating ER diagrams

Anthony - Getting ready for RiskProfiler.ca minor updates - 1. Fix obsolete link - 2. Update contact email - 3. Update logo/wordmark removing the space and period.) finish fixing the GitHub Actions workflow for https://github.com/OpenDRR/boundaries/pull/45

Tuesday, December 20, 2022

Will - Working on DB diagrams - Finished French part of FGP - Waiting on Phil L. on getting translated scenario descriptions

Anthony - Minor updates to RiskProfiler - Fixed gh action

Drew - Meeting with DFC on Kibana dashaboard - VDB 7.5 scenario 10x higher than their industry model - Looking for Canada wide EP curves

Thursday, December 22, 2022

Drew - Following up with DFC questions

Will - FGP updates - ER Diagrams

Thursday, December 29, 2022

Drew - testing bug fixes on stack (DSRA branches) - ATO

Will - Phil provided french translations for scenarios, will update FGP mxds - worked on adding total values from source back to psra canada results, fix some bugs previously missed for 1.4.4 (5km, 50km hexgrid)

Tuesday, January 3, 2023

Drew - Searching for ATO document - fixing opendrr-api build on master branch

Will - Updated issue to include PSRA totals for Canada wide EP curves

Anthony - Following Will's discovery of the need to upgrade pgAdmin to the latest for PostgreSQL 15 compatibility (which our Docker image based on postgis/postgis:latest switched to recently following PostgreSQL 15.1 release), I thought we'd better bump the PostgreSQL client tools in python-env Docker image from v14 to v15 too. Tested locally last Friday? What I plan to do: To create two (very trivial one-liner) pull requests for postgresql-client 14 to 15 upgrade soon, one for debian-sid (2020) (to be tagged 1.2.5) and one for debian-bullseye (to be tagged 1.3.1) (Maybe) to start a stack build as a first step towards moving to Python 3.9 in debian-bullseye version of python-env Follow up on https://github.com/OpenDRR/opendrr/issues/122... 3 more security vendors to go (Trellix, MS Defender Smartscreen, VIPRE)

Review:

Thursday January 5, 2022