NJGS Physical Inventory System
Description
MIKE: NEED TO UPDATE THIS WRITE UP - The New Jersey Geological and Water Survey (NJGWS) retains numerous sets of geological and geophysical data dating back to the mid-1800’s.
Data includes, but not limited to, field notebooks, geophysical well logs, maps, rock cores, rock samples, offshore vibracores, sediment samples, near-surface geophysical data. This data is currently stored in numerous places and formats such as boxes, filing cabinets, shelves, share drive, Access database, excel sheets and NJDEP archive. Some data is available through the NJ Geology Information App which we hope to use as the interface for the public to use. NJGWS has been working with the USGS National Data Preservation Program (NGGDPP) to digitize and catalog information in a standardized format, but we do not have a central location to store these files or keep them organized nor is it easy to search for the items we have. As we continue to preserve data that can be used by current and future NJDEP staff, customers, and stakeholders, we are exploring what options are available to create a central database that can pull information from several locations, store current datasets, input new data as we collect it and make it easy for the public to search and access these files.
In addition, the New Jersey Geological and Water Survey retains borehole geophysical logs that have been collected by staff and provided by outside stakeholders. These logs allow staff to document subsurface geology and relate it to water quality (anthropogenic and naturally occurring impacts), drilling, permitting, geologic mapping and site remediation projects and have proven to be invaluable. There have been numerous times when programs within the NJDEP have asked for NJGWS assistance and having this information easily accessible upon request will better equip staff to perform their job duties.
These borehole logs are stored in various locations such as the NJGWS share drive, paper copies in boxes and filing cabinets, excel spreadsheets, Microsoft Access database. With the data being stored in numerous locations, it is difficult to know what is available and how to locate it. In order to better organize, a multi-step process will be employed to collect and disseminate the borehole geophysical logs. The goal is to make geophysical logs available to NJDEP staff through NJEMS and then provide information that is not private be made available to the public, such as LSRPs, drillers, etc through a GIS interface such as the NJ Geology Information App. Currently there are about 2,000 digital .las and .jpeg files and over 2,000 paper logs that will need to sorted, scanned as PDF-A, .jpeg or .tiff files and associated feature data compiled.
Project Justification
Washington State Geological Survey (listed under subsurface data)- https://geologyportal.dnr.wa.gov/2d-view#wigm?-13861016,-13078301,5825947,6222197
Florida Geological Survey (boreholes/geophysical logs)- https://ca.dep.state.fl.us/mapdirect/?focus=fgsgeologicwell
Illinois Geological Survey (Listed under wells)– https://prairie-research.maps.arcgis.com/apps/webappviewer/index.html?id=af7f150b9ec348d3860b1d225bffb035
NJGWS website is outdated in how it handles our data
https://www.nj.gov/dep/njgs/
Currently, some of our data is listed on the NGGDPP website which may only provide the metadata and NJGWS still needs to be contacted for the actual documents.
https://www.sciencebase.gov/catalog/item/4f4e4761e4b07f02db47dfda?community=National+Digital+Catalog
Some data can be accessed through our NJ Geology Web App:
https://www.arcgis.com/apps/webappviewer/index.html?id=6e32c9122f9c49ea840dfffbf912f992
This project started out as an overall general need that needed to pinpoint some details. After discussions we have started to break it down into multiple sub projects which include the following.
Ground Water Quality Monitoring Network: This project will be absorbed into the already underway WRP Project Management system being built by Rutgers University.
NJGS Continuous Monitoring System: We already have a continuous monitoring system through Rutgers University that handles both the bureau of Marine Water and Fresh Water. With a few tweaks this program should be able to be absorbed into the existing continuous system.
Past Perfect Database: This project contains a bunch of scanned images and historic maps. The goal for this project is to make the information searchable and available to the public. TABLEAU seems to be the preferred strategy at the moment. We will need to write up a separate Project IT sheet for this.
Finally, there is the Physical Inventory Database. We will need to write up a project IT sheet and provide the details.
So, this original project has been broken down into 4 subset projects. 2 of which will be absorbed by projects already underway, and the other two need to have formal documentation written up.
7/6 Mike K still working with group and understand scope. Working on flowchart. Lots to figure out and large complex project…may not be possible with FY24 funding.
Still considered a possible spillover project for the 2.5 mil funding. Could use a lot $ but would prefer to target safe drinking water. Earthsoft is currently being explored and providing demos to program.
Not going to start until April. Looking into grant. Very complicated and may take a year to write up requirements.
After speaking with Pat, she doesn’t want to spend any of the 2.5 million towards this project. While there is a need for this project, it has other potential funding sources and she said that she wants to address the projects that are directly related to water supply for which she received the funding.
Looking to investigate the other three state examples to understand the vendors used and their potential to do the NJ work.