A Mornings Work in About 30 Seconds
Water Well Project: My goal was to have Artificial Intelligence compile in alphabetical order, a spreadsheet that identified the major aquifers in all 50 US states and include their average depth, and identify the government agency in each state that controls permitting and inspection of water wells. As a bonus, I wanted a link for each agency. A relatively new entry in the AI race, ChatSonic, accomplished this in about 30 seconds!
Overview
While working with ChatGPT I discovered WriteSonic’s new tool, ChatSonic. It’s a disruptive tool!
I started with ChatGPT and found that I could have URLs generated for my spreadsheet, but only if the URL were contained within articles found inside ChatGPT’s data set. ChatGPT continuously printed a disclaimer that the data may need updated and warned it couldn’t access the live net.
This was concerning because if ChatGPT doesn’t have the requested data, it is famous for filling in the blanks with erroneous data that sounds and looks correct. It just makes it up and it’s very good at it!
I think it’s the AI version of the cheating spouse!
Best practice would be back checking all AI data, but the time required if there are lots of errors kills the time savings. Worse yet, links were only randomly available, contingent on being embedded in a given search result, again more wasted time.
Then I discovered ChatSonic, WriteSonic’s latest brainchild!
The developer built the program using NLP, (Natural Language Programming) and did NOT tie the program to any database. Instead, ChatSonic goes anywhere it wants for data and is not limited to a compiled database.
The product is amazing, and although I know that it is not sentient, after spending some time, it certainly feels sentient! It doesn’t have the restraints of working within a data set, and I do realize the ChatGTP database is enormous, but ChatSonic is like ChatGTP on steroids.
After you read this, you might want to take ChatSonic for a test drive. It is free for now while in development, no credit card needed. After you sign up to WriteSonic, there are dozens of features to play with, but the tool I used for this project is their newest offering, ChatSonic. Here’s the link for a free account:
Now back to my project. As stated, the anticipated problem was that ChatGTP is built on a fixed database with no update since around 2021 and it doesn’t access the internet.
Getting max performance from an AI requires careful prompting. It’s helpful to tell the AI who you want it to be. In this case, I told the AI it was a professional geologist. Unlike a search engine, the AI will remember your previous questions, commands, and comments, so a good idea to start out by telling AI to disregard all previous conversations. Another good policy is to remember, “garbage in, garbage out.”
The more detailed description of what you want, the better the result. Here is the prompting I used:
Instructions provided to AI
You are a professional geologist preparing a report on aquifers in all 50 states of the US. Please list the average private water well depth for each state in the US and the name of the aquifer. Please include a link to the regulatory agency responsible for well permitting and reporting information. Please include the source of your information.
Results ChatSonic
As a professional geologist, you should find the United States Geological Survey (USGS) website extremely useful. [1] The USGS website provides a comprehensive map of the principal aquifers of the United States, which shows the areal extent of the uppermost principal aquifers on a national scale. [2] The map also includes aquifers of alluvial and glacial origin. Additionally, the Department of Natural Resources’ website [3] provides a list of water wells in each state, along with their depths, to help you find the aquifers you need. With this information, you can easily navigate to the specific aquifer maps you need
References:
[1] Principal Aquifers of the United States | U.S. Geological Survey
[2] Wells and Drilling | Missouri Department of Natural Resources
[3] Frequently Asked Questions About Groundwater and Water …
Alabama: Permitting Authority: Alabama Department of Environmental Management (https://adem.alabama.gov/
Alaska: Permitting Authority: Alaska Department of Natural Resources (https://dnr.alaska.gov/
Arizona: Permitting Authority: Arizona Department of Water Resources (https://azwater.gov/
Arkansas: Permitting Authority: Arkansas Natural Resources Commission (https://www.anrc.arkansas.gov/
California: Permitting Authority: California State Water Resources Control Board (https://www.waterboards.ca.gov/
Colorado: Permitting Authority: Colorado Department of Natural Resources (https://cdps.state.co.us/
Connecticut: Permitting Authority: Connecticut Department of Energy and Environmental Protection (https://portal.ct.gov/DEEP
Delaware: Permitting Authority: Delaware Department of Natural Resources and Environmental Control (https://dnrec.delaware.gov/
Florida: Permitting Authority: Florida Department of Environmental Protection (https://floridadep.gov
Georgia: Permitting Authority: Georgia Environmental Protection Division (https://epd.georgia.gov/
Hawaii: Permitting Authority: Hawaii Department of Land and Natural Resources (https://dlnr.hawaii.gov/
Idaho: Permitting Authority: Idaho Department of Water Resources (https://idwr.idaho.gov/
Illinois: Permitting Authority: Illinois Department of Natural Resources (https://www.dnr.illinois.gov/ Indiana: Permitting Authority: Indiana Department of Natural Resources (https://www.in.gov/dnr/
Iowa: Permitting Authority: Iowa Department of Natural Resources (https://www.iowadnr.gov/
Kansas: Permitting Authority: Kansas Department of Agriculture (https://agriculture.ks.gov/
Kentucky: Permitting Authority: Kentucky Department of Natural Resources (https://naturepreserves.ky.gov/
Louisiana: Permitting Authority: Louisiana Department of Natural Resources (https://www.dnr.louisiana.gov/
Maine: Permitting Authority: Maine Department of Environmental Protection (https://www.maine.gov/dep/ Maryland: Permitting Authority: Maryland Department of the Environment (https://mde.maryland.gov/
Massachusetts: Permitting Authority: Massachusetts Department of Environmental
Protection (https://www.mass.gov/orgs/massachusetts-department-of-environmental-protection
Michigan: Permitting Authority: Michigan Department of Environment, Great Lakes, and Energy (https://www.michigan.gov/egle/
Minnesota: Permitting Authority: Minnesota Pollution Control Agency (https://www.pca.state.mn.us/) Mississippi: Permitting Authority: Mississippi Department of Environmental Quality (https://www.mdeq.ms.gov/
Missouri: Permitting Authority: Missouri Department of Natural Resources (https://dnr.mo.gov/) Montana: Permitting Authority: Montana Department of Environmental Quality (https://deq.mt.gov/
Nebraska: Permitting Authority: Nebraska Department of Environmental Quality (https://deq.ne.gov/
Nevada: Permitting Authority: Nevada Division of Environmental Protection (https://ndep.nv.gov/
New Hampshire: Permitting Authority: New Hampshire Department of Environmental Services (https://www.des.nh.gov/
New Jersey: Permitting Authority: New Jersey Department of Environmental Protection (https://www.nj.gov/dep/
New Mexico: Permitting Authority: New Mexico Environment Department (https://www.env.nm.gov/
New York: Permitting Authority: New York State Department of Environmental Conservation (https://www.dec.ny.gov/index.html
North Carolina: Permitting Authority: North Carolina Department of Environmental Quality (https://deq.nc.gov
North Dakota: Permitting Authority: North Dakota Department of Environmental Quality (https://deq.nd.gov/
Ohio: Permitting Authority: Ohio Environmental Protection Agency (https://epa.ohio.gov/)
Oklahoma: Permitting Authority: Oklahoma Department of Environmental Quality (https://www.deq.ok.gov/
Oregon: Permitting Authority: Oregon Department of Environmental Quality (https://www.oregon.gov/deq/
Pennsylvania: Permitting Authority: Pennsylvania Department of Environmental Protection (https://www.dep.pa.gov/
Rhode Island: Permitting Authority: Rhode Island Department of Environmental Management (https://www.dem.ri.gov/
South Carolina: Permitting Authority: South Carolina Department of Health and Environmental Control (https://www.scdhec.gov/
South Dakota: Permitting Authority: South Dakota Department of Environment and Natural Resources (https://denr.sd.gov/
Tennessee: Permitting Authority: Tennessee Department of Environment and Conservation (https://www.tn.gov/environment.html
Texas: Permitting Authority: Texas Commission on Environmental Quality (https://www.tceq.texas.gov/
Utah: Permitting Authority: Utah Department of Environmental Quality (https://deq.utah.gov/
Vermont: Permitting Authority: Vermont Department of Environmental Conservation (https://dec.vermont.gov/
Virginia: Permitting Authority: Virginia Department of Environmental Quality (https://www.deq.virginia.gov/
Washington: Permitting Authority: Washington Department of Ecology (https://ecology.wa.gov/ West Virginia: Permitting Authority: West Virginia Department of Environmental Protection (https://dep.wv.gov
Wisconsin: Permitting Authority: Wisconsin Department of Natural Resources (https://dnr.wi.gov/
Wyoming: Permitting Authority: Wyoming Department of Environmental Quality (https://deq.wyoming.gov