Sprint 72

Tuesday, February 21, 2023 – Thursday, March 2, 2023

Sprint Goals:

RiskProfiler

• Link-checker in gh-actions - riskprofiler repo - Drew (Sprint 72)

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

• French Language Translation - Drew/Anthony

  • in progress kickoff meeting is Feb 22 with H7

• Wordpress Migration - Drew/Anthony - backlog

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

• Add additional DSRA scenarios Drew/Will/Anthony

  • opendrr-api/model-factory v1.4.4 (PR Pending) [ ] (Drew/Will)
  • request Damon walk us through the branch workflow

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

  • defer to french language deployment

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

  • defer to french language deployment - backlog (Sprint 72-74)

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 (Sprint 73) - Drew/Anthony (40-50% done)

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

  • opendrr-api [ ], earthquake-scenarios [ ] (Drew) - sprint-72
  • python-env [ ] , riskprofiler [ ] (Anthony) - sprint-72

Elasticsearch - Kibana - PostGIS

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

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

• DFC Queries follow up (Drew/Will)

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

• Run stack build in EC2 full scripted with AWS CLI - Sprint 73 (Drew, Anthony)

Data Dissemination

FGP:

• PSRA - in progress (Will - Waiting for CIO approval)
• DSRA each scenario - 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)

DSRA Scenario Names:

• Fix DSRA Scenario Names (Anthony)
  • Rename Files in earthquake-scenarios to common names as per https://github.com/OpenDRR/earthquake-scenarios-2022-jrimando-google-drive/blob/main/ScenarioReview_TH_Oct2022.xlsx
  • Rename Files in earthquake-scenarios
  • Create change log to document rename
  • Updates to API/GeoPackages/VectorTiles etc. - sprint 72/73 (Drew Will)

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 - - [ ] Review with Tiegan
• DFC (Joel Henderson) custom query: ldresAAL(low density residential) by FSAUID that would correspond to ldres_NumberofBldgs
  • RES-1 RES-2 RES-3A
  • craft SQL query (Will)
  • Attempt KQL query (Drew)

OpenDRR Administrative

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

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

• Follow up on NRCan blocking Github.io Downloads Page - Anthony - [ ] McAfee/Trellix

• Follow up AWS Account transfer from FGP to GSC:

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

Demos:

• Drew
  • KQL DFC Query
• Anthony
  • DSRA GitHub Pages
  • Adding New Scenarios → Sprint 73
• Will
  • ?? Surprise

Scrums:

Thursday, February 23, 2023

• Drew:

  • Following up with the RiskProfiler-H7 meeting yesterday which went quite well; waiting to hear from Makaila on helping with French translations
  • Talking to David L. about RiskProfiler AWS from FGP to GSC transition; expected to be a pretty complicated process: will need to go through the whole cloud intake process from scratch (as if it were a new application), to develop an MOU with CIOSB and CMSS, and to do a fresh SA&A from IT Security, etc.
  • Big meeting on March 1st with David L., Arash, Steven M. (FGP), Glen N. (GSC IT), Malaika, Muran (?), Lauren...
    • Recommend that we all join the meeting; will forward invite

• Anthony

  • (still finishing personal backlogs with Chinese School and Debian and spent little time on NRCan work)
  • Completing forms related to onboarding
  • Signed up for Federal Science DataHub (proof-of-concept stage) a while back; invited to meeting on Friday morning
  • Replying to Docker account saying that I am not personally using Docker Desktop

• Will

  • Got Docker Desktop running in Windows on an AWS c5.metal (bare-metal) EC2 instance, which offers an option to offload some tasks when necessary, though his computer should be able to handle most of the workloads
  • Heard back from Malaika on FGP signatures... (probably they are restarting the process)
  • Asking for approval to merge OpenDRR/model-factory#150 for model-factory v1.4.4 release

Tuesday, February 28, 2023

• Anthony

  • [Fri 2023-02-24] Get-to-know-each-other 15-minute meeting with with Federal Science DataHub Team (summary in Slack DM)
  • Completed forms for onboarding
  • Listened to (1) Pathways to Reconciliation and (2) Black History Month meetings
  • Still behind in DSRA renaming (sorry!)

• Will

  • [Thu 2023-02-23] Merged OpenDRR/model-factory#150 for model-factory v1.4.4 release
  • [Thu 2023-02-23] Opened OpenDRR/opendrr-api#243 for upcoming opendrr-api v1.4.4 release (in sync with model-factory), awaiting review
  • Look into creation of opendrr-exposure-ancillary.7z.00[1-4] for the above
  • Preparing for stack build and asset generation with the new DSRA scenarios (Awaiting Anthony to finish DSRA renaming and addition)

Review:

Thursday March 2, 2023