MGMT User’s Manual Version 1/28/2019 10:38 PM Michigan Groundwater Management Tool User Manual Summer 2017 Dr. Shu-guang Li & Co-Workers, Michigan State University (MSU) Civil and Environmental Engineering (CEE) Manual prepared by: Zachary Curtis, MSU CEE Graduate Student MGMT User’s Manual Version 1/28/2019 10:38 PM Contents 1. Introduction ............................................................................................................................................... 4 1.1 Background ......................................................................................................................................... 4 1.2. Available Data ................................................................................................................................... 4 1.3 Purpose and Scope of the User Manual .............................................................................................. 4 1.4 Machine Requirements ....................................................................................................................... 5 1.4.1 Installation .................................................................................................................................... 5 1.4.2 Data Management ........................................................................................................................ 6 Part 2 - The MGMT Modeling Environment ................................................................................................ 8 2.1 Project Start-up ................................................................................................................................... 8 2.2 Layer Viewer ...................................................................................................................................... 9 2.2.1 Default Layers and Map View Options ....................................................................................... 9 2.2.2 Adding User Data and Spatial Reference................................................................................... 18 2.2.3 Chemistry Concentration Data ................................................................................................... 19 2.2.4 Layer Properties ......................................................................................................................... 24 2.2.5 Attributes Table ......................................................................................................................... 29 2.2.6 Data Diagram ............................................................................................................................. 29 2.3 Feature Attributes & Data Query ...................................................................................................... 30 2.4 Ruler & Sketch .................................................................................................................................. 32 2.4.1 Distance and Area Measurements .............................................................................................. 32 2.4.2 Sketch on the Map...................................................................................................................... 33 2.5 Modeling Tools ................................................................................................................................. 34 2.5.1 Create a 2D model of the Potentiometric Surface ...................................................................... 34 2.5.2 Creating a Polygon Raster .......................................................................................................... 38 2.5.3 Raster Calculator ........................................................................................................................ 40 2.5.4 Model Management ................................................................................................................... 41 2.5.5 Drawdown Operations ............................................................................................................... 41 2.5.6 Particle Tracking ........................................................................................................................ 42 2.5.7 Delineate Wellhead Protection Area (WHPA) .......................................................................... 45 2.6 Advanced Visualizations .................................................................................................................. 48 2.6.1 Cross-sections ............................................................................................................................ 48 2.6.2 Integrated 3D Overlays .............................................................................................................. 51 2.7 Saving and Loading Map Files ......................................................................................................... 58 Part 3 –Tutorial for Groundwater Management and Protection .................................................................. 59 MGMT User’s Manual Version 1/28/2019 10:38 PM 3.1 Characterizing the Landscape ........................................................................................................... 59 3.2 Characterizing the Geology .............................................................................................................. 63 3.3 Understanding the Groundwater System .......................................................................................... 68 3.4 Protecting Drinking Water Supply .................................................................................................... 74 References: .................................................................................................................................................. 81 MGMT User’s Manual Version 1/28/2019 10:38 PM 1. Introduction 1.1 Background As a result of the passage of Public Act 148, Section 32802, a team of groundwater hydrologists and GIS specialists from the U.S. Geological Survey (USGS), remote Sensing and GIS Laboratory (RSGIS) at Michigan State University (MSU), and the Michigan Department of Environmental Quality (MDEQ) developed a GIS-based inventory of information and data concerning the characteristics and development of the groundwater resources within the potable aquifers in the State of Michigan. That project was referred to as the “Ground Water Inventory Mapping” (GWIM) project. A report detailing the findings of this project was co-authored by investigators from the USGS and MSU (H. Reeves and others, 2005). The primary purpose of the GWIM project was to estimate the water-yielding capabilities of the potable aquifers within the state. All of the data and information for this project came from available sources, including Wellogic (MDEQ, 2014). An ongoing project between the DEQ and RSGIS has been the compilation of hydrologic, geologic, geographic, and environmental data in a desktop tool for use by DEQ staff. This tool is Michigan Groundwater Management Tool (MGMT). Periodic data retrievals from the Wellogic database and extractions from the GWIM project database are stored separately as GIS shapefiles for use in MGMT. The primary purpose of MGMT is the display of a wide-range of GIS data in an easy to use desktop environment. MGMT overlays can be used to address any number of groundwater-related issues within the state, including wellhead protection, source-water protection, groundwater conflict resolution, or environmental investigations. 1.2. Available Data The MGMT platform is live-linked to a massive database system containing information useful for groundwater investigations. MGMT makes systematic use of the network of environmental, hydrological, geological, geographical, water quality, and ecological databases, and enables direct statistical data analysis, mining, querying, interpolation, mapping and visualization. The specific data layers include: • Drillers’ water well data – Wellogic (MDEQ, 2014) • Digital elevation model DEM – National Elevation Dataset (NED USGS 2006) • Bedrock elevations and geology data (GWIM 2006) • Glacial land forms data (GWIM 2006) • Wetlands – National Wetlands Inventory NWI data (GWIM 2006) • Sites of environmental concern (oil and gas wells, contamination sites, etc.) • Hydrography (stream network) – National Hydrography Dataset (NHD USGS 2010) • Pre-processed grroundwater hydrology layers, e.g., recharge, hydraulic conductivity (Oztan 2010) • Human infrastructure, e.g., roads, political boundaries, etc. (ESRI, 2011) 1.3 Purpose and Scope of the User Manual This user’s manual is intended to provide users of MGMT with instructions for navigating the interface and performing site characterizations and groundwater analyses. In Part 2, an overview of the MGMT modeling environment is provided to familiarize users with software capabilities and tools. Part 3 illustrates a typical implementation of MGMT for groundwater management and protection for a region west-central Lower Peninsula of Michigan. MGMT User’s Manual Version 1/28/2019 10:38 PM Within MGMT, options are selected by depressing either the left or right mouse button. Completion of the selected option is usually performed by depressing the left mouse button. Throughout these instructions a note to depress either the left (LM) or right (RM) mouse button will be given in the text. 1.4 Machine Requirements 1.4.1 Installation All required files and folders needed to run MGMT can be obtained from MSU via USB or external hard-drive. Note that the PC that will be used to run MGMT must have access to an Arc Engine 10 license with the following extensions: 3D Analyst; 3D Spatial Analyst; Data Interoperability. The MGMT executable file, all supporting files/scripts, and all statewide data are stored in within subfolders located under the parent folder called MGMTDATA. This folder has been compressed to a Zip Archive to make data exchange easier. The required steps for installations are as follows: 1) Copy the MGMTDATA zip Archive, VFPOLEDSetup to the USB/external hardrive. Connect the USB/external hardrive to the PC that will be used to run MGMT (destination PC). 2) Uncompress (unzip) the MGMTDATA zip Archive using 7-Zip File Manager (or some equivalent program). 3) Select the (unzipped) MGMTDATA parent folder and move it (and all of its contents) to C:\ of the destination PC (see Figure 1) *Note that the folder structure, including all folder names and locations within the hierarchy, must be maintained for proper access while using MGMT. 4) Install Visual FoxPro from ..\VFPOLEDSetup\VFPOLEDSetup.msi *Note that Arc Engine and Visual FoxPro require Microsoft .NET Framework 3.5. 5) The MGMT executable file is located at: C:\MGMTDATA\Lib. Locate the MGMT application file, and use the RM button to create a desktop shortcut (see Figure 1). MGMT User’s Manual Version 1/28/2019 10:38 PM Figure 1: (Top) Parent folder for MGMT, MGMTDATA; (bottom) creating a Desktop shortcut. 1.4.2 Data Management The different types of data supported in MGMT include rasters (.txt files), images, and shapefiles. The statewide raster data layers include: bedrock formations elevations; glacial drift and bedrock hydraulic conductivity; DEM; and pre-processed Static Water Levels (SWLs). The raster data are stored at: C:\MGMTDATA\rasterdata – see Figure 2. DEM and Bedrock top and geologic formation elevations are also stored as image files at: C:\MGMTDATA\StateLT\Geology. Statewide hydraulic conductivity and recharge are available in image format and are stored at: C:\MGMTDATA\StateLT\Hydrology. See Figure 3. The following statewide data layers are available as shapefiles in the C:\MGMTDATA\StateLT: water chemistry (water well point measurements); ecology (fens, trout streams, etc.); sites of environmental concern (landfills, contamination plumes etc.); boundaries of all Great Lakes; estimated baseflow; inland lakes; lithology (water well records); geopolitical boundaries (counties, townships, etc.); road (highway and residential); streams; watershed boundaries; and wells (glacial drift and bedrock point locations) – see Figure 4. Note, again, that the folder structure, including all folder names and locations within the hierarchy, must be maintained for proper access while using MGMT. MGMT User’s Manual Version 1/28/2019 10:38 PM Figure 2: Subfolder containing raster data for formation elevations, DEM, SWLs and hydraulic conductivity. Figure 3: (Top) subfolder containing image data for bedrock elevations (bedrockElev), formation elevations (formationElev), and DEM; (bottom) subfolder containing image data for statewide hydraulic conductivity (glacial and bedrock) and recharge. MGMT User’s Manual Version 1/28/2019 10:38 PM Figure 4: Subfolder storing statewide shapefile data. Part 2 - The MGMT Modeling Environment 2.1 Project Start-up Launch MGMT from the desktop by selecting the MGMT icon using the LM button. Once MGMT opens, a Welcome window will appear which will allow you to choose the starting background for the workspace (see Figure 5). Users may select the Default background map (statewide county boundaries) or may load a previously saved MGMT map file by using the ‘Customized Map’ option and selecting the appropriate .mxd file from the list of recent projects. Figure 5: MGMT Welcome widow. The Default background map is the statewide county shapefile shown at full extent. The default modeling environment is shown in Figure 6. The major components of the software interface include: Layer Viewer, for managing and customizing data layers used for mapping and modeling; Work Display, for MGMT User’s Manual Version 1/28/2019 10:38 PM outputting data layers/overlays and 2D groundwater model results; Menu Toolbar, for accessing project management capabilities and various tools/options available in MGMT; Button Toolbar, for direct access to tools/options available in MGMT; Preview Map, for displaying the current location and extent of the Work Display within the State of Michigan; Locator Tool, for quick navigation to a particular county and township in Michigan; and Attributes Viewer, for displaying active model data and the location of the curser in the Work Display (if a model is active). Figure 6: Default MGMT modeling environment 2.2 Layer Viewer 2.2.1 Default Layers and Map View Options As shown in Figure 6, the default group layers available are: Wells (glacial and bedrock); Potential Contamination (sites of environmental concern, oil and gas wells); Chemical Sampling (partial chemistry results, metals and organics); Rivers (1st order through 6th order); Roads (residential and state); WHPAS (wellhead protection areas); Lakes (class 1 through class 7); Watersheds (big and small); Region (villages, townships, etc.); Hydraulic Conductivity (rasters for glacial drift and bedrock); Hydrology (maps of estimated baseflow, recharge, etc.); Elevation (DEM and top of bedrock rasters); Formation Elevations (geologic formation elevation rasters); Glacial Geology (land systems and quaternary geology); Bedrock Geology (Lower and Upper Peninsula); and Background (satellite imagery and US topographic map). Figure 7 shows each of the default layers expanded within Layer Viewer, which can be done by selecting the LM on any of the boxes with a ‘ + ’ inside. To contract a layer, select ‘ - ’ using the LM button. The user can easily zoom in or out at any location in the state using the View tools Menu Toolbar Work Display Button Toolbar Attributes & Options (AO) pane Layer Viewer Locator Tool Preview Map Next >