PDMS Well Data Project Fix

Status Start Date End Date Locations
Inactive Apr 2, 2019 Jun 30, 2021 All Counties
Director: Jayson Eldridge
Other Researchers: Garrett Marietta, Rebecca Meyer, Gary Motz, Pratima Soni, Ryan Kammer Rohit Bapat (rbapat@iu.edu) Indiana University SICE's Data Science Club.
Funding: Indiana University - Indiana Geological & Water Survey
Issue: The PDMS scanned documents are held in at least four locations on IGWS servers. They will be consolidated for the eventual creation of a unified database to search all records through the IGWS website.
Objective: The main objective of this project is to merge all of the records by removing the "Records Cornucopia" and adding all of the scanned documents to their correct location in the "Reports" and "Log Info" sections of the PDMS.
Approach: Well data will be sorted using Python scripts and OCR to centralize the well records and dispose of duplicate copies. We also plan to utilize the expertise of the SICE Data Science Club and devise a way to filter the documents into their correct locations using the unique six digit IGWS ID, which is the common element to all of the data.
Products: https://igws.indiana.edu/pdms/WellSearch.cfm
Benefits: This project is the first task to creating a unified database that will benefit users of the website by making energy related data easily accessible to people in various industries as well as people who interested in the geology of Indiana.