Sprint 59

Starts May 30, 2022; Due by June 9, 2022 (Review on June 9)

Sprint Goals:

Risk Profiler

• RiskProfiler QA/QC script (Drew) > Sprint 59

  • Inquire about internal quality controllers - Carol
  • Integrate Lighthouse check > Sprint 59 - Drew > Sprint 60
  • Investigate WCAG Compliance > Sprint 59 - Drew > Sprint 60
    • NRCan has an internal resource - Joost
  • Link-checker in gh-actions > Sprint 59 - Drew > Sprint 60

• Add RiskProfiler Version number to website footer - (Anthony/Phil E.) > Sprint 60

• Move riskprofiler-cms code,issues,content etc. to riskprofiler (Anthony) > backlog Hard deadline before October release

• Review remaining translations (Drew, Joost, Phil) > sprint 60

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

  • Document deployment process > sprint 60

ElasticSearch - Kibana - PostGIS

• Load v1.4.1 ES indices into prod ES environment and update ES Aliases (Drew) > Sprint 59

• v1.4.2 updates (Will) > Sprint 59 ** Done **

  • PSRA Canada aggregations and attach geometries ** Done **
  • Fix to add_data.sh remove xz repos ** Done **
  • cast loss period to double ** Done **

• Build AWS CLI script to test opendrr-api docker-compose build and dump db to S3 bucket (Drew) ** Done **

• Contract for pygeoapi versioning (Drew/Joost) > Sprint 60

• DSRA Dashboards in Kibana (Drew, Damon)

  • onboard finance Canada - waiting for prod environment - Drew
  • Request dashboard wireframe from finance - Drew
  • message when emailing not to upload protected data Kibana
  • load v1.4.1 into prod + create aliases + use index templates > Sprint 60
  • DFC Kibana Dashboard Workshop (Investigate training contract with Elastic) (Drew) > Sprint 60

Data Dissemintation

• Publish FGP records (Joost) - waiting on Charles

  • 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 59
    • DSRA 1KM, 5KM, 25KM
  • 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 59
    • DSRA
  • Prep legend files (MXD's) for FGP data See issue
    • Physical Exposure
    • Social Fabric
    • PSRA - French language legends in progress > sprint 60
    • 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) > Blocked

  • Blocked by diskspace limits on GitHub Actions - Stack need to be optimized for disk usage - Blocked

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

  • add PSRA P/T aggregation levels blocked by no geometry (Damon, Anthony, Will) * Create Vector/Image Tile of aggregated contents/structural/non-structural for 500yr loss for each P/T

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

  • Automate vector tile backup on github - in progress, blocked by inodes (Anthony) > sprint 60

  • Create 900913 Hexgrid geometries (Will) > Sprint 60

  • Create 3857 Hexgrid geometries (Will) > backlog

OpenDRR Administrative

• Security Documentation (Joost) > Sprint 60

  • FGP CSV document

• Use of XZ-compressed repos XZ- or Zstd-compressed release assets to reduce Git LFS data storage and bandwidth usage (Anthony) > sprint 60

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

Demos:

• PSRA Revisions for FGP Layeras - Will
• Github storage of large vector tiles - Anthony > sprint 60
• Lighthouse check and WCAG Compliance: RiskProfler - Drew > sprint 60

---

Scrum Notes:

Tuesday May 31

• Anthony - experimenting hosting vector tiles on GitHub
• Joost - updating leaflet sample application, noticed geotile grid aggregation still works
• Damon - tying up loose ends, intro Linux learning
• Will -
  • Heard back from Charles, PSRA updated in FGP, maybe ready to go live later this week
  • generating hexgrid 900913 geopackages
• Drew - Joost demo pygeoapi yml generation

Thursday June 2

• Joost - New Build of pygeoapi with openapi json cache - build failing
• Damon - Test tiles, loading properly
• Will
  • 1.4.2 model-factory merged, opendrr-api PR
  • working through 900913 hexgrids
  • FGP for PSRA good to go
• Anthony - Worked with Arash for PSRA indicator vector tiles
• Drew
  • Fixing Kibana Dashboards
  • H7 Contract Milestones
  • H7 questions about API

Tuesday June 7

• Anthony - No updates
• Damon - No updates
• Will
  • Hexgrid 900913 96 hours to clip
  • Continue with tables attached to haxgrids
  • Feedback from FGP
  • Another PSRA revision - EQ Index calculations
• Joost - FGP for DSRA
  • 2 scenarios rejected
  • FGPS records for NHSL
• Drew
  • onboarded DFC - credentials out
  • New credentials issued for Nicky
  • Presenting to GEM steering committee today Kibana dashboards