Sprint 80

Monday, July 24, 2023 - Thursday August 31st, 2023

Sprint Goals:

AWS/Azure Migration and Redeployment

• Obtain an AWS dev account for gsc-riskprofiler-dev - Anthony/Drew

• Run through Arash's deployments scripts - Anthony/Drew - in HC riskprofiler-dev account - Anthony/Drew - in fgp-gscriskprofiler-dev or gsc-riskprofiler-dev or n localstack - Anthony/Drew

• Continue with Arash led tutorials - Cancelled - Anthony/Drew

• Gate-0 Project Gating form (Drew) - on hold

• 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

• 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

RiskProfiler

• Link-checker in gh-actions - riskprofiler repo - backlogged

  • 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 - [x] Add to release Assets - Will, 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) - backlogged - Anthony

• 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 - Anthony

• Add new pages for 13 new DSRA scenarios

GitHub

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

• 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
  • 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 - [x] Migrate to readthedocs - 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 - Pending Phil L. 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

Demos:

• Anthony - AWS Traffic Stats Demo - next sprint - AWS Cloudformation deployment
• Drew - ????
• Will - ????

Scrums:

Scrum Notes: Tues July 25, 2023 Anthony - Finishing up service request GSC Riskprofiler-dev - Attending Arash AWS training session

Drew - Dumping ES indices to json - Attending Arash AWS training session

Thurs July 27, 2023 Anthony - Submitted Assyt tickets for AWS environments - Working on AWS certifications -

Drew - Playing around with Cloud9 - Looking into strategies for s3 migration

Tues Aug 1, 2023 Will - sql/opendrr-db documentation

Thurs Aug 3, 2023 Will - CGM maps, maybe a demo

Anthony - Participated in AWS Jam - Network issue at PGC seismic team - Reviewing outstanding PR

Drew - Working on ES Dump

Tues Aug 8, 2023 Anthony - French Language translation - Diagnosing Sidney network issues

Will - SQL documentation

Drew - Trying to dump ES indices new scenarios - Arash and Anthony some AWS infrastructure

Thurs Aug 10, 2023

Tues Aug 15, 2023

Thurs Aug 17, 2023

Will - Updating FGP records - Docker desktop license issue

Drew - Locked out AWS

Anthony - Visiting PGC - working on PGC network maintenance

Tues Aug 22, 2023

Thurs Aug 24, 2023

Tues Aug 29, 2023