OR/17/003 Project plan

From MediaWiki
Jump to navigation Jump to search
Terrington, R, Thorpe, S and Jirner, E. 2017. Enköping Esker pilot study - workflow for data integration and publishing of 3D geological outputs. British Geological Survey Internal Report, OR/17/003.

Objectives

The initial objectives of the project were: From Eva Jirner (SGU)

  1. ‘A conceptual geological model for planners, decision makers, politicians and citizens in general
    (Use Uppsala Esker model as template — explain geology, and make planners aware of the subsurface and groundwater)
  2. Create a base for effective protection measures for the aquifer
  3. Input for groundwater simulations with different tools (FeFlow and ModFlow)
  4. Visualisation in 2D and 3D

We also want to take part of your competence concerning:

  1. Structured work flow in general
    (From maps/boreholes to cross-sections to model to visualisation)
  2. Structured handling of model in data (boreholes, profiles...)

(Boreholes in different databases in Oracle, not well structured — changing to SQL server cross-section — nothing implemented as yet’).

Timescale

November 9th 2016 to 22nd December 2016
Date of visit to BGS = 8th/9th December 2016
Timescale revised after workshop deadline 6th January 2017

Project plan

From the intial project objectives as stated in the Objectives Section, the following plan was implemented to prepare the data (Data Section), construct the model (Geology and Geological model Sections) and deliver the outputs in the various formats agreed with SGU (Publication methods and outputs Section).

Plan outline

BGS role:

  1. Provide advice and support during data preparation, modelling and data output
  2. Help prepare data for geological model construction and…
  3. Document and report data formats required for use in geological modelling and visualisation (GeoVisionary)
  4. QA of the geological model produced using BGS standard procedures for QAing GSI3D models.
  5. BGS to action and deploy following data outputs in conjunction with SGU:
  1. Grids (to be loaded into FeFlow or ModFlow)
  2. 3D PDFs — Shells, cross-sections and boreholes
  3. 3D Shapefiles of cross-sections and boreholes
  4. Web based synthetic outputs (akin to Geology of Britain Viewer) hosted by BGS (Andrew Bean)
  5. Deployment in GeoVisionary v3
  6. Groundhog Desktop project
  1. BGS to scope out and document the requirements for the following outputs:
  1. Groundhog Desktop for borehole and data access
  1. Organised 2-day workshop at BGS to discuss (8th–9th December 2016):
  1. Model workflow — lessons learned
  2. Data storage and access — recommendations
  3. Data publication and delivery
  4. Next steps — Training, further model deployment, future collaboration

SGU role:

  • Provide data and information about the data (metadata) to BGS for preparation for geological modelling
  • To construct the geological model of the Enköping Esker in the SubsurfaceViewer ahead of the Workshop
o Model Construction in SubsurfaceViewer
  • Provide model to BGS for QA and model output initiation
  • Contribute to ‘Geology’ of report in style of BGS model metadata report

Plan timeline

Week 1 Week 2 Week 3 Week 4 Week 5 Week 6
When 7–11 Nov 14–18 Nov 21–25 Nov 28 Nov–2 Dec 5–9 Dec 12–16 Dec
What Data Preparation
Report (Data Preparation Spec)
Model Construction Model Construction QA Report Model Publication Outputs
Workshop
Finalise Report and outputs
Who Ricky/Eva SGU SGU Steve Thorpe and Jon Lee Ricky, Andrew and Steve T Ricky, Steve T and Jon

Detailed project plan

Project plan details and time allocations:

  1. Provide advice, support and help for data preparation for Subsurface Viewer Software
  1. DTM
  2. Boreholes
  3. Geological Map Linework
  4. GVS
  5. Legend
  6. Sections — GPR and Seismic sections
  7. Others — Superficial Deposits Thickness, GEOSIGMA data

Time allocated = 2 days

  1. Document and report data formats required for use in visualisation (GeoVisionary)
  1. Boreholes
  2. Terrain
  3. Gridded data (Superficial Deposits Thickness/Rockhead)
  4. Model outputs (Shell, Cross-sections, Platypus Voxel model)
  5. Geological Linework
  6. Buildings? (See Luz for city data download using Info??)

Time allocated = 0.5 days

  1. Technical QA of model (Calculation checks in cross-sections, unit thickness checks/helper sections) using the BGS QA procedures see Appendix 1
  1. Using SubsurfaceViewer or GSI3D to check model in cross-section using the Post Model Calculation Checks procedure
  2. Check thickness of units using ArcGIS — add helper sections in areas where deposits are not calculating any thickness but should be by checking against the envelopes

Time allocated = 2 days

  1. Geological check of model using BGS QA procedures (See Appendix)
  1. Action model checks

Time allocated = 2 days

  1. Create and deploy the following outputs from the geological model:
  1. ASCII Grids of the TOP, Base and Thickness (FeFlow grids can be exported directly from the SubsurfaceViewer)
  2. 3D PDFs — Shells, cross-sections and boreholes
  3. 3D Shapefiles of cross-sections and boreholes
  4. 2D GIS layers (Envelopes, Sections and borehole locations) — GSI3D conversion of the project
  5. Web based synthetic outputs (akin to Geology of Britain Viewer)
  6. Test output to Minecraft (Steve Thorpe)

Time allocated = 7 days

  1. Groundhog Conversion of project
  1. DTM
  2. Boreholes
  3. Geology lines
  4. Cross-sections
  5. GVS
  6. Legend

Time allocated = 1 day

  1. Scope out and document the requirements for Groundhog Desktop for borehole and data access (Will be in response to what is learned in workshop) — this was not implemented as no information was forthcoming at the workshop with regards to and the time was used to

Time allocated = 1 day

  1. Organise 2-day workshop at BGS to discuss (8th–9th December 2016, I3DVF — Keyworth, Nottingham):
  1. Model workflow — lessons learned
  2. Data storage and access — recommendations
  3. Data Delivery
  4. Next steps — Training, further model deployment, future collaboration, Groundhog Desktop enabled

Time allocated = 2 days

  1. Report
  1. Write project plan and report

Time allocated = 2 days
Total of BGS time required = 19.5 days

Post workshop — plan

After the workshop, it was decided that BGS would take on the role for the technical checking of the Enköping geological model using the standard checking procedures used for all BGS GSI3D models. A copy of the checking document is in the appendix. The main aspects of this checking procedure include:

  • Snapping all sections to cross-sing sections, outcrop and subcrop (this was undertaken in Groundhog Desktop as explained in Workflow summarised and BGS groundhog desktop
  • Ensuring the units calculate correctly — cross-section calculation checks and checking for thickness anomalies
  • Unit names and cross-sections names are consistent

This work was undertaken as a bolt-on to the main project above. A further 5 days was added to the project for this task and was undertaken in the period between 13th December 2016 and 6th January 2017 (taking into consideration the intervening Christmas Break).