Hydrograph Preparation

[gmerritt123]

AS OF v3.html (Both Cambridge and Moraine)

• [x] Truncated ROW wldata to only Moraine area (i.e. locations NOT in cambridge model)
• [x] Queries set up to query both Cambridge and Moraine models to extract model layer at location middle of screen
• [x] Mapping setup to map model layer to geounit and color (CAM colour theme added to XS repo)
• [x] Color theme by geounit applied to both continuous and discontinuous points:
  • [x] Plan view
  • [x] Hydrograph
  • [x] Key learning about factor_cmap: sometimes better to take the size hit than to force on the fly color mapping
  • [x] Discontinuous diamond marker size increased
  • [x] Legend built for unit name/color
  • [x] WellName hover in place of sys_loc_code
  • [x] Checkbox groups for filtering by geounit added relevant PR
  • [x] Workaround req'd to have checkbox group control both continuous and discontinuous data types (trigger one callback with another callback)
• [x] Calculation of avg WLs for 2020 for XS tool

GM TO DO:

Issues to raise with Karl

Landfill data:

• [x] Parse spreadsheets --> Completed except for "049378-Waterloo Landfill- AFB2 Water Levels- 1997 to 2020.xlsx"
  • Impossible to parse without major effort
  • 049378-Triannual WL Surfer.xlsx provides reasonable coverage/overlap in lieu
• [x] No common field between "049378- Well coordinates- 11-2020.xlsx" and "049378-RPT40-APPC.2 (Well Completion Details).xlsx" to join on (sys_loc_codes do not align at all)
  • How to reconcile?
• [ ] WAIT FOR MORE DATA FROM KARL FOR CAMBRIDGE AND KITCHENER - Need Cambridge Screens, Kitchener Coords and Screens
• [ ] TO MOVE FORWARD ON WATERLOO LANDFILL Use coords from "049378-Triannual WL Surfer.xlsx " and screens from "049378-RPT40-APPC.2 (Well Completion Details).xlsx"

Other

• [ ] Incorporate Landfill WL data to hydrograph tool once wrangling is complete
• [x] Incorporate PGMN data

JL TO DO

• [x] Add middle of screen to tables
• [x] "Bonus" Add Wellfield "field" to loc_dfs based on nearest well (Do Last)
  • [x] Cross join pumping wells locations (mp_locdf) to continous/discontinuous well locations (cloc_df,dloc_df)
  • [x] Calculate distance between
  • [x] Retrieve the row corresponding the minimum distance for each obs location
  • [x] Retrieve the distance and the pumping well for each
  • [x] If within x km, assign wellfield, else None
  • [x] Get the corresponding wellfield for that well
  • [x] Add that info to loc_dfs (cloc_df and dloc_df)
  • [x] Add to table
  • [x] Extra bonus, add checkbox group
• [x] Placement of tentative repWLs i.e. Calib Targets and Quality Rankings --> MORAINE MODEL ONLY
  • [x] Establish using transducer 2020 avg vs manual
  • [x] Establish using some other avg year if poor data in 2020 relative to others
  • [x] End goal is a table like:

sys_loc_code	RepWL	RepDateStart	RepDateEnd	RepSource	Comment	QualRank
6503...	303.21	Jan 1 2020	Dec 31 2020	Continuous	Avg Transducer Data in 2020	High
6502...	305.35	Jan 1 2018	Dec 31 2018	Discontinuous	No 2020 data, 2018 next most representative	Medium

• [x] Complete documentation/table summaries of calib target methology:
  • [x] Data "coverage" pivot table conditionally formatted
  • [x] Hierarchy of quality/preference ranking

[gmerritt123]

For the wellfield assignment,

If within x km, assign wellfield, else None Get the corresponding wellfield for that well

@jlangford92 did you choose x or just give every well a wellfield?

[jlangford92]

For the wellfield assignment,

If within x km, assign wellfield, else None Get the corresponding wellfield for that well

@jlangford92 did you choose x or just give every well a wellfield?

I used 1 km as the cutoff, everything beyond 1 km was attributed with "Outside of Wellfield"