Sprint 79

Monday, June 26, 2023 – Monday, July 24, 2023

Sprint Goals:

RiskProfiler

• Link-checker in gh-actions - riskprofiler repo

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

• Add additional DSRA scenarios Drew/Will/Anthony

  • 13 new Scenarios - [x] Vector Tiles
    - [x] GeoPackages
    - [ ] ES Indices - Drew - [ ] Pygeoapi records - Drew - [ ] Add to release Assets - Anthony - [x] Scenario Descriptions in need of Translation - Will/Phil
  • Request Damon walk us through GitHub pages workflow - Anthony

• Fix bug with French Language Carousel 'En savoir plus' (OpenDRR/riskprofiler#118) - Anthony

• AWS Environment Familiarization with Arash - Anthony/Drew/Will

• OpenDRR Traffic Stats (OpenDRR/opendrr#140):

  • Stats for Riskprofiler (AWS) - Anthony/Drew/Arash
  • Stats for Asset Downloads (GitHub) - Anthony

• RiskProfiler Cloud Bill - investigate resource usage on Dev/Staging - Anthony

• Review GitHub LFS costs

GitHub

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

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

• General update and review of all README LISEZMOI files and licenses

  • opendrr-api (Drew)
  • earthquake-scenarios (Drew)
  • seismic-risk-model (Anthony) - README/LISEZMOI done (PR pending); to figure out where to add French licence.
  • python-env (Anthony)
  • riskprofiler (Anthony)

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/

• add_data.sh - check and build from local sql dump if present (Backlog) - (Anthony)

• Run stack build in EC2 full scripted with AWS CLI (Backlog) - (Drew, Anthony) - [ ] test build in podman - (Backlog)

• Document SQL script functionality in google docs -> model-factory - Will

Data Dissemination

FGP:

• PSRA - in progress (Will - Waiting for CIO approval) - sent for review Phil/Tiegan
• DSRA each scenario - adding 4x new scenarios v1.4.3 - in progress (Will)
• DSRA each scenario - adding all 9 scenarios v1.4.4 - in progress (Will)
• DSRA each scenario - 13 new scenarios (Will) - ESRI links available, ready to be sent for review
• NHSL
• Exposure

OpenDRR Web Portal (GitHub Pages):

• Revamp https://opendrr.github.io/en/ (https://opendrr.github.io/fr/) to make them official-looking (especially it is often referred to in GSC slide decks) - Anthony (backlog)
  • Upgrade to latest GCWeb for Jekyll - Anthony (backlog)
  • Add proper links and contents - Anthony (backlog)

GitHub pages for new DSRA scenarios

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

DSRA Scenario Names:

• Fix DSRA Scenario Names (Anthony)
  • Updates to API/ (Drew/Anthony)

New Datasets need to add National EP-curves to our supported datasets

• Add National EP-Curve Table to ES/PyGeoAPI - Drew
• Add to GitHub Pages download page - Will - [x] Review with Tiegan

OpenDRR Administrative

• Document Process on how to add new DSRA scenario (Anthony, Drew)

  • https://github.com/OpenDRR/earthquake-scenarios/wiki/Process-for-adding-new-DSRA-scenarios

• Follow up AWS Account transfer from FGP to GSC:

  • Gate-0 Project Gating form (Drew) potentially no longer relevant
  • Follow up with Glen Newton on: - ON HOLD no longer relevant
    • Fresh SA&A and ATO - ON HOLD no longer relevant
    • Document with screenshots all of the required security controls - ON HOLD no longer relevant
    • Define a transfer strategy for: - ON HOLD - Application Code (on Github no transfer required) - ON HOLD - Cloud infrastructure code (gccode) - ON HOLD - Preserve: Architecture diagrams, Deployment process, VA Scans, Disaster Recovery - ON HOLD

• Study the technical aspects of AWS Account transfer and practice
  • Ask Arash to give us a Quick-Start Tutorial session - Anthony
  • Try our hands on AWS CloudFormation etc. with LocalStack
  • Explore migrating from CloudFormation CDK - potentially no longer required

Demos:

• Anthony - AWS Traffic Stats Demo - next sprint
• Drew - README Updates
• Will - SQL Documentation Demo

Scrums:

Scrum Notes:

Tuesday, June 27, 2023

Will

• Followed up with Phil, DSRA translations
• Filling out SQL documentation

Anthony

• Attempting WSL2 install on NRCan Windows environment (NRCan IT support)
• Scheduling meeting with Arash
• studying Terraform/CloudFormation
• Looking into DSRA GitHub pages, finding ways to simplify too many if/else statements

Drew

• Elasticsearch
• PostgreSQL course opportunity potential

Thursday, June 29, 2023

Anthony - Draft page for Canflood.github.io landing page - Testing out localstack, trying cloudformation scripts - WSL2 working

Will - Out for RP Migration meeting

Drew - RP MOU With PS/Stats - Playing around with ES indices /dump

Tuesday, July 4, 2023

Drew - RP MOU Lift & Shift requirements

Will - SQL Workflow documentation

Anthony - RP MOU Review

Thursday, July 6, 2023

Will - SQL Workflow documentation - Working with Tiegan on EQ Scenario descriptions

Anthony - OQ studying - reviewing consequences script - Looking into dev Azure and AWS environments

Drew - Putting together a lift and shift plan for Riskprofiler

Tuesday, July 11, 2023

Drew - AWS migration plan, review from Arash and simplify for MOU - Learning kubernetes

Anthony - Reviewing migration plan - Working through HPC workshop demo

Will - ESRI Workshop - Following up on consequences scripting - working through script documentation - DSRA french translation in progress

Thursday, July 13, 2023

Anthony - AWS learning - Automating AMI and EC2 with Boto3 - Meeting with HC on cloud credits - following up on PS Mou and Tiegan's consequences - Ticket to Mathieu for our own cloud environment

Drew - AWS learning ALB - load balancer - Session tomorrow with Arash on RP infrastructure

Tuesday, July 18, 2023

Thursday, July 21, 2023