Sprint 65

Sprint Goals:

RiskProfiler

• RiskProfiler QA/QC script (Drew)

  • Integrate Lighthouse check - riskprofiler issue-68- Drew/Will
  • Investigate WCAG Compliance - Drew
    • NRCan has an internal resource - Joost
    • Waiting on French pages
    • Run on English Pages - Venessa Greebe to follow up with internal NRCan resources
  • Link-checker in gh-actions - riskprofiler repo - Drew/Damon
    • Follow up on link-checker dead links - add issue to riskprofiler repo

• Move riskprofiler-cms code, issues, content etc. to riskprofiler (Anthony) > Done

• Review remaining translations (Julie) - in progress to be ready for H7 Sept-23 (French translations available by end of sprint)

  • Expecting delivery on Oct 17

• Updates for openDRR, streamline download pages (Julie)

• Fully automate riskprofiler static website generation in Docker WordPress instance (Anthony)

  • Document deployment process, see Procedure to update RiskProfiler website (80% complete)
  • Tutorial with someone else running static site generation workflow
  • Share with CCMEO

• Close out Critical RiskProfiler Issues/Bugs (Drew, Anthony, Phil E., Will)

• Add 6 4 additional DSRA Scenario Pages (Phil E. Drew, Anthony, Damon)

  • ES Indices Available (Drew) 99 % done
  • check new scenarios, and generate geopackages (Will)
  • Vector Tiles available (Damon, Will)
  • Updated RiskProfiler Codebase/Database (Phil E.) - Sprint 65
  • New beta RiskProfiler Deployment (Anthony) - Sprint 65

GitHub

• Opendrr-api README updates (Anthony) - Sprint 65

• French translations of README's (Damon) - Sprint 65

• New Private earthquake-scenarios-private repo for 6 new DSRA scenarios

  • re-organize earthquake-scenarios-2022-jrimando-google-drive file structure into new DSRA-processing repo (Damon) - automated Github action to pick and process specific scenarios
  • investigate impacts of reorganizing earthquake scenarios directories (Damon, Anthony, Tiegan, Drew) - Sprint 65

ElasticSearch - Kibana - PostGIS

• v1.4.4 updates (Will) - To be pushed after RiskProfiler Launch

  • EPSG:3857 hexgrids
  • final review
  • considering temporarily removing DSRA scenario table - too resource intensive and not necessarily used

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

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

• Test AWS CLI script to build opendrr-api docker-compose build and dump db to S3 bucket (Anthony/Drew) - Sprint 65

• Contract for pygeoapi versioning (Drew/Joost) > backlog

• Break up add_data.sh (#214)

  • Get DSRA processing in add_data.sh working with generic DRSA repositories and branches [Anthony, Drew, Damon]

• DSRA Dashboards in Kibana (Drew, Damon)

  • DFC examples in code for direct data access via PyGeoAPI - wiki or python notebook > Sprint-65
  • DSRA dashboards for 6 new scenarios > Sprint-65

Data Dissemination

• Publish FGP records (Joost) - waiting on Charles FGP blocking

  • Send revised data files and MXD's to FGP (Will, Phil)
    • Physical Exposure - To be released alongside social fabric
    • Social Fabric - Will sent on Feb 11
    • PSRA - waiting on changes to seismic risk index > sprint 64
    • DSRA 1KM, 5KM, 25KM - DG signoff pending
  • Review revised FGP data layers (Murray, Phil, Tiegan, Joost, Will)
    • Physical Exposure
    • Social Fabric - Waiting on release of supporting publication
    • PSRA - waiting on changes to seismic risk index > sprint 64
    • DSRA
  • Prep legend files (MXD's) for FGP data See issue
    • Physical Exposure
    • Social Fabric
    • PSRA - French language legends in progress > sprint 64
    • DSRA (Carol)
  • Update API endpoints to prod in FGP metadata - To be released in October - Joost

• GPKG generation via GitHub Actions for release assets opendrr-api (Damon, Anthony) - Sprint 65

  • Blocked by diskspace limits on GitHub Actions - Stack need to be optimized for disk usage - Sprint 65
  • might be able to unblock with changes to add_data.sh - using db dump instead of building from scratch

• Generate layer tiles (Joost, Damon, Anthony) - all but one CSD done, will work on hex grid layers next.

  • List of v1.4.3 vector tiles:

    • Document vector tile generation workflow with comprehensive list of source data (Damon/Anthony/Joost)
    • PSRA aggregations hexgrid (if needed)

  • Automate vector tiles for DSRA scenarios (Possible for 3857, Investigating if possible for 900913 & 4326 (Damon, Anthony) - backlog
    * document and report bug to GDAL

  • Automate vector tile backup on GitHub and serve the vector tiles on GitHub Pages (10GB limit) (Anthony) - Sprint 65

  • New Vector Tile suite for 6 4 new DSRA scenarios

OpenDRR Administrative

• Security Documentation (Joost) - pending Director signoff

  • FGP CSV document

• Use of compressed release assets to reduce Git LFS data storage and bandwidth usage (Anthony) > - Sprint 68

• Document Process for adding new DSRA scenario in earthquake-scenarios Wiki (Damon, Drew, Will, Anthony)

  • Very early draft started at earthquake-scenarios/wiki/Process-for-adding-new-DSRA-scenarios

---

Demos:

Damon - PSRA Downloads Page

Scrums:

Oct 4, 2022

Anthony

• work on Julie's request to help with simple text edits on RP wordpress

Damon

• continue to work on vector tiles / github page links

Drew

• ES indexes available for the 6 new dsra scenarios
• postgis db backup on s3

Will

• reviewed 6 new scenarios, generated geopackages and uploaded on onedrive
• assist with Damon on vector tile generation on EC2 for the bigger tiles (sauid, 1km)
• continue review data rounding on RP

Oct 6, 2022

Damon

• finish generating tiles
• working on PR for earthquake scenarios

Anthony

• setup WordPress local for Julie to make edits
• sent Damon's tiles to Arash, still need to send Will's

William

• finish generating tiles
• continue review on RP issues

Oct 11, 2022

Damon:

• EQ Scenarios PR, remove Masset
• Creating links for wiki

Anthony:

• Finished setting up WordPress on Raspberry Pi, though now temporarily retired
• Julie has access on H7's WordPress admin site
• Remove empty vector tiles
• Phil E. updated their H7 WordPress framework (parent theme) from v1 to v2

Will:

• Meeting with H7, outstanding issues with Phil/Julie
• Issue with PSRA rounding values in sidebar

Drew:

• Back from conference
• Cleaning up remaining issues

---