To improve EGLE's data visualizations of the Gelman Site project data and to develop an interactive 3D virtual conceptual site model (VCSM), EGLE utilizes RockWorks, an integrated geological database, analysis, and visualization software developed by RockWare, Inc. The locations included in this feature layer include all bore and sample locations that are in the current RockWorks project database (Gelman5_v2023.sqlite dated 02/27/2024). Data tied to each location includes lithological information, 1,4-dioxane sample results, and groundwater level measurements. The custom pop-up displays the standardized bore location name and the following information: Well Type: includes one of the following: Monitoring Well, Residential Well, Extraction Well, Injection Well, Horizontal Well, Test Boring, Seismic Interpolation Point, Surface Water, or other. Ground Elevation: elevation in feet at the point extracted from the March 2019 LiDAR digital elevation model from Southeast Michigan Council of Governments (SEMCOG). Units are in feet referenced to the North American Vertical Datum 1988 (Geoid12B).Collar Elevation: the top of well casing elevation used for reference when collecting groundwater level measurements. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Total Depth: feet below ground surface to the well or boring terminus. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Screen Interval: depth below ground surface to the top and bottom of the well screen. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Used for Lithology Model: yes/no field indicating if the location has associated lithological information that was used for input into the RockWorks lithology 3d solid voxel model.Used for Max Groundwater Elevation Model: yes/no field indicating if the location has associated groundwater level measurements that were was used as input for the Maximum Groundwater Elevation Model.Used for Geochem Models: yes/no field indicating the location has associated 1,4-dioxane results used as input to create the annual (1986 - 2023) 3d solid voxel models and 2d grid surface files. Additional fields specifying source of information, such as source of northing and eastings, can be viewed within the attribute table. Boring logs and well construction documents, if available, are stored as attachments and can be viewed by clicking on the hyperlink.At the bottom of the pop-up, the "Show Related Records" link will open up separate windows showing the lithology, water level measurements, or 1,4-dioxane results that are associated with the selected location. This is the latest version of the bore locations data. An earlier vintage is available at: Gelman Site of 1,4-Dioxane Contamination - All Bore Locations Layer Group (2020 Data).

Field Name

Field Description

Name

The name associated with the boring

Well Type

The type of well that this represents. Values include the following: Monitoring Wells, Residential Wells, Extraction Wells, Injection Wells, Horizontal Wells, Test Boring, Seismic Interpolation Point, Surface Water, and 'other'.

Northing (ft)

Northing in Michigan State Plane Coordinate System (South Zone - FIPS 2113), NAD83 international feet

Easting (ft)

Easting in Michigan State Plane Coordinate System (South Zone - FIPS 2113), NAD83 international feet

Ground Elevation (ft)

Ground surface elevation of the well in feet; taken from SEMCOG 2019 Digital Elevation Model referenced to NAVD88 (Geoid12B)

Total Depth (ft below ground service)

The maximum depth, in feet below ground surface, that this boring was drilled to

Screen Interval (ft below ground surface)

The minimum and maximum depth, in feet below ground surface, of the well screen

Used for Lithology Model?

Whether this boring is used in creating the RockWorks lithologic model

Used for Max Groundwater Elevation Model?

Whether this boring is used in creating the RockWorks Max Groundwater Elevation model

Used for Geochem Models?

Whether this boring is used in creating the Rock Works geochemical (1,4-dioxane concentration) model

This data is used in the Gelman Site of 1,4-Dioxane Contamination web map (item details). If you have questions regarding the Gelman Sciences, Inc site of contamination contact Chris Svoboda at 517-256-2849 or svobodac@michigan.gov. Report problems or data functionality suggestions to EGLE-Maps@Michigan.gov.

To improve EGLE's data visualizations of the Gelman Site project data and to develop an interactive 3D virtual conceptual site model (VCSM), EGLE utilizes RockWorks, an integrated geological database, analysis, and visualization software developed by RockWare, Inc. The locations included in this feature layer include all bore and sample locations that are in the current RockWorks project database (Gelman3.sqlite v20210429). Data tied to each location includes lithological information, 1,4-dioxane sample results, and groundwater level measurements. The custom pop-up displays the standardized bore location name and the following information: Well Type: includes one of the following: Monitoring Well, Residential Well, Extraction Well, Injection Well, Horizontal Well, Test Boring, Seismic Interpolation Point, Surface Water, or other. Ground Elevation: elevation in feet at the point extracted from the March 2019 LiDAR digital elevation model from Southeast Michigan Council of Governments (SEMCOG). Units are in feet referenced to the North American Vertical Datum 1988 (Geoid12B).Collar Elevation: the top of well casing elevation used for reference when collecting groundwater level measurements. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Total Depth: feet below ground surface to the well or boring terminus. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Screen Interval: depth below ground surface to the top and bottom of the well screen. Source of information includes the EGLE Access database and supplemented with boring log or well construction records if available. Used for Lithology Model: yes/no field indicating if the location has associated lithological information that was used for input into the RockWorks lithology 3d solid voxel model.Used for Max Groundwater Elevation Model: yes/no field indicating if the location has associated groundwater level measurements that were was used as input for the Maximum Groundwater Elevation Model.Used for Geochem Models: yes/no field indicating the location has associated 1,4-dioxane results used as input to create the annual (1986 - 2020) 3d solid voxel models and 2d grid surface files. Additional fields specifying source of information, such as source of northing and eastings, can be viewed within the attribute table. Boring logs and well construction documents, if available, are stored as attachments and can be viewed by clicking on the hyperlink.At the bottom of the pop-up, the "Show Related Records" link will open up separate windows showing the lithology, water level measurements, or 1,4-dioxane results that are associated with the selected location. This is a previous version of the bore locations data. The newest vintage is available at: Gelman Site of 1,4-Dioxane Contamination - All Bore Locations Layer Group (2023 Data).This data is used in the Gelman Site of 1,4-Dioxane Contamination web map (item details). If you have questions regarding the Gelman Sciences, Inc site of contamination contact Chris Svoboda at 517-256-2849 or svobodac@michigan.gov. Report problems or data functionality suggestions to EGLE-Maps@Michigan.gov.