Ohio DNR Oil and Gas Well Data

Workflow

Step 1 — Resolve Intent

Identify the query target:

• Formation: Utica, Point Pleasant, Clinton, Knox, Berea, Medina, Oriskany
• Geography: county, bounding box, or named field
• Filter: well type (oil, gas, SWD), permit status, operator

Step 2 — Query Wells by County

# Query wells in Carroll County (FIPS 019), Utica targets
curl -s "https://gis.ohiodnr.gov/arcgis/rest/services/OGS/OilGasWells/MapServer/0/query" \
  --data-urlencode "where=COUNTY_CODE='019'" \
  --data-urlencode "outFields=PERM_NUM,WELL_NAME,OPERATOR,FORMATION,LATITUDE,LONGITUDE,WELL_TYPE,STATUS" \
  --data-urlencode "resultRecordCount=100" \
  --data-urlencode "f=json"

# Query Utica/Point Pleasant wells statewide (status = Active or Producing)
curl -s "https://gis.ohiodnr.gov/arcgis/rest/services/OGS/OilGasWells/MapServer/0/query" \
  --data-urlencode "where=FORMATION LIKE '%UTICA%' OR FORMATION LIKE '%POINT PLEASANT%'" \
  --data-urlencode "outFields=PERM_NUM,WELL_NAME,OPERATOR,FORMATION,COUNTY_CODE,WELL_TYPE,STATUS,LATITUDE,LONGITUDE" \
  --data-urlencode "resultRecordCount=200" \
  --data-urlencode "orderByFields=PERM_NUM DESC" \
  --data-urlencode "f=json"

Step 3 — Spatial (Bounding Box) Query

# Wells within bounding box (SW and NE corners: lon_min,lat_min,lon_max,lat_max)
# Example: Carroll/Columbiana county area
curl -s "https://gis.ohiodnr.gov/arcgis/rest/services/OGS/OilGasWells/MapServer/0/query" \
  --data-urlencode "geometry=-81.3,40.5,-80.5,41.0" \
  --data-urlencode "geometryType=esriGeometryEnvelope" \
  --data-urlencode "spatialRel=esriSpatialRelIntersects" \
  --data-urlencode "inSR=4326" \
  --data-urlencode "outFields=PERM_NUM,WELL_NAME,OPERATOR,FORMATION,WELL_TYPE,STATUS" \
  --data-urlencode "resultRecordCount=200" \
  --data-urlencode "f=json"

Step 4 — Parse Results

# Extract key fields from query response
curl -s "https://gis.ohiodnr.gov/arcgis/rest/services/OGS/OilGasWells/MapServer/0/query" \
  --data-urlencode "where=FORMATION LIKE '%UTICA%'" \
  --data-urlencode "outFields=PERM_NUM,WELL_NAME,OPERATOR,COUNTY_CODE,STATUS" \
  --data-urlencode "resultRecordCount=50" \
  --data-urlencode "f=json" \
  | python3 -c "
import json, sys
data = json.load(sys.stdin)
features = data.get('features', [])
print(f'Total records: {len(features)}')
print(f'{'Permit':<12} {'Operator':<25} {'Formation':<20} {'Status':<15}')
print('-' * 75)
for f in features[:20]:
    a = f['attributes']
    print(f\"{a.get('PERM_NUM',''):<12} {str(a.get('OPERATOR',''))[:24]:<25} {str(a.get('FORMATION',''))[:19]:<20} {str(a.get('STATUS',''))[:14]:<15}\")
"

Step 5 — Bulk Download (Production Data)

ODNR publishes bulk CSV downloads for production and permit data:

# Current bulk download page (verify current URLs at ohiodnr.gov)
# Unconventional well list (Utica/Point Pleasant):
curl -L "https://ohiodnr.gov/static/documents/oil-gas/Well-Permit-Data-Unconventional.xlsx" \
  -o odnr_unconventional_wells.xlsx

# Production data (annual):
curl -L "https://ohiodnr.gov/static/documents/oil-gas/Annual-Production-Data.xlsx" \
  -o odnr_production.xlsx

Key Ohio Formation Reference

Ohio County Reference (Key Utica/PP Counties)

Appalachian Basin Comparison

ODNR Supplemental Resources

Output Format

## Ohio Well Query Results
**Query:** [formation / county / operator filter]
**Records returned:** N

| Permit # | Well Name | Operator | Formation | County | Type | Status |
|---------|----------|----------|-----------|--------|------|--------|
| | | | | | | |

**Summary:**
- Total wells returned: N
- Top operators: [list top 3–5]
- Formation breakdown: Utica: N, Point Pleasant: N, Clinton: N, Other: N
- Status breakdown: Producing: N, Plugged: N, Permit: N

**Data source:** ODNR Division of Oil and Gas Resources Management
**Certainty:** HIGH (official regulatory database) | **Bias:** Only permitted/reported wells

Error Handling

Caveats

• ODNR well database includes permitted but not-yet-drilled wells; filter by STATUS for producing wells when estimating active inventory.
• Formation names in ODNR data use various spellings — use LIKE with wildcards (e.g., %UTICA%, %POINT PLEASANT%, %CLINTON%).
• Production data for Utica/Point Pleasant wells may be reported under operator rather than individual wellbore; verify against permit number.
• Horizontal well counts are best obtained from the unconventional well bulk download, which is more consistently maintained than the ArcGIS service.
• For cross-basin comparison with WV and PA, use pnge:wvges-wells and pnge:padep-wells alongside this skill.