Skip to content

Sprint 64

Jump to bottom
drotheram edited this page Sep 29, 2022 · 3 revisions

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) > Sprint 65

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

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

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

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

    • ES Indices Available (Drew) 99 % done
    • Vector Tiles available (Damon)
    • 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)

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

    • Consider splitting db dump by schema
    • 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 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)

Demos:

Anthony - Model Factory changes Drew - Changes in DSRA processing / AWS SQS/Lamba

Scrums:

Sept 22, 2022 - (Drew absent)

Sept 27, 2022 Anthony - update python container image to support Debian upgrade - Looking into model-factory changes - sql fluff for SQL linting - add branch support to model-factory

Will - Holding pattern while DSRA outputs get added - Investigation into new census data - prepping for CGM production demo - v1.4.4 database updates complete

Drew - updates to model-factory and opendrr-api to handle DSRA repo branches

Sprint Planning | Sprint Review
Wikis: data | model-factory | opendrr-api | opendrr | python-env | riskprofiler-cms

Clone this wiki locally