This document discusses mapping carbonate bedrock surfaces in glaciated landscapes like Calumet County, Wisconsin. Key points include:
- Fractured carbonate bedrock has a dense fracture network that allows rapid infiltration of surface water and contaminants to the subsurface with little attenuation.
- The county has over 1.25 million dairy cows that collectively produce over 34 million tons of waste annually, posing risks to groundwater.
- The project involves geocoding and digitizing well records, interpolating bedrock topography, and mapping depth to bedrock and potential groundwater contamination.
3. Flow Characteristics of fractured carbonate Aquifers
• Dense and ubiquitous fracture network
– little surface runoff
– water easily infiltrates to subsurface
• Recharge
– exceedingly rapid
– carries surface contaminants to the water table
• Flow within the aquifer occurs primarily along
bedding plane fractures
– Little to no attenuation of contaminants within the aquifer
• Flow rates vary from 10’s to 100’s of ft/day
4. • 14,000 dairy farms
• 1.25 million milk cows.
• Each cow produces 150 lbs of waste/day
6. (1.25 million cows) (150 lbs. per day) (365 days)
= 34,000,000 tons of waste annually
7. Roads PLSS Well
WCRs DEM WCRs
Testing
Parcel
Well Well Surface Bacteria E. Coli Nitrate
Location Geology Elevation Cont. Cont. Cont.
Surface Elevation – Bedrock Elevation Safe or Unsafe
Depth to
Contamination
Bedrock
Depth to Bedrock
AND
Contamination
9. WCRs
Data entry
pre-1988
WCRs
database
Geocode by PLSS
UNLOCATED
pre-1988 WCRs
Geocode by Street
Address
UNLOCATED
pre-1988 WCRs
N
Geocode by Parcel
UNLOCATED
pre-1988 WCRs
10. WCRs
Data entry
pre-1988
WCRs
database
Geocode by PLSS
UNLOCATED
pre-1988 WCRs
Geocode by Street
Address
UNLOCATED
pre-1988 WCRs
Geocode by Parcel
N
UNLOCATED
pre-1988 WCRs
11. WCRs
Data entry
pre-1988
WCRs
database
Geocode by PLSS
UNLOCATED
pre-1988 WCRs
Geocode by Street
Address
UNLOCATED
pre-1988 WCRs
N
Geocode by Parcel
UNLOCATED
pre-1988 WCRs
13. pre-1988 post-1988
NAIP image WCRs WCRs
NAIP image
Drag point to structure Drag point to structure
referred to in WCR referred to in WCR
pre-1988
WCRs
Data enter geology
Geology Table
Geology Table pre-1988 post-1988
from WCR
from data entry WCRs WCRs database
Attach Geology Attach Geology
post-1988
pre-1988 WCRs
WCRs with
with geology
geology
Merge WCRs
WCRs
geodatabase
14. pre-1988 post-1988
NAIP image WCRs WCRs
NAIP image
Drag point to structure Drag point to structure
referred to in WCR referred to in WCR
15. pre-1988 post-1988
NAIP image WCRs WCRs
NAIP image
Drag point to structure Drag point to structure
referred to in WCR. referred to in WCR
16. pre-1988 post-1988
NAIP image WCRs WCRs
NAIP image
Drag point to structure Drag point to structure
referred to in WCR referred to in WCR
17. pre-1988 post-1988
NAIP image WCRs WCRs
NAIP image
Drag point to structure Drag point to structure
referred to in WCR referred to in WCR
pre-1988
WCRs
Data enter geology
Geology Table
Geology Table pre-1988 post-1988
from WCR
from data entry WCRs WCRs database
Attach Geology Attach Geology
post-1988
pre-1988 WCRs
WCRs with
with geology
geology
Merge WCRs
WCRs
geodatabase
19. WCRs
geodatabase
QUERY:
Select minimum
bedrock value
WCRs with
DEM depth to
bedrock
ADD surface elevation
WCRs with
surface
elevation
surface elevation MINUS Bedrock Topography
depth to bedrock
WCRs with
bedrock Bedrock
Interpolate
elevation Topography
21. Depth to Bedrock
N
Kilometers
0 1 2 3 4 5 6 7 8
0 1 2 3 4 5
Miles
22. Depth to Bedrock
less than 0
5
10
15
20
25
30
40
50
60
80
100
140
200
250
300
350
N N
Bedrock at the land surface Depth to Bedrock
Kilometers
0 1 2 3 4 5 6 7 8
0 1 2 3 4 5
Miles