Know your data sources.

Alaska Oil and Gas Conservation Commission well registry. North Slope (Arctic Slope ~8.1K wells) + Cook Inlet Basin (~1.75K) operator side — Hilcorp, ConocoPhillips, BP/ARCO heavy. - searchWells (~10.3K) ⭐ filter area (basin)/operator/status/wellClass/field/offshoreOnly. Pass bottomHole=true for bottom-hole locations. - searchBottomHoles ⭐ alias for the paired Well_Bottom_Hole_Location service - getWellByApi, listLayers, getServiceInfo upstream quirks: AK is borough-based (no county column) — use area for basin scoping. Native CRS EPSG:3338; service reprojects to 4326. CurrentStatus has 30+ descriptive values (Plugged & Abandoned 3.8K, Oil well single 3.4K, Water alt gas injection 976). maxRecordCount=2000.

Alabama State Oil & Gas Board well inventory, bottom-hole locations, offshore platforms, lease blocks, and field units via map.ogb.state.al.us. - searchWells ⭐ ~2.89K wells with permit/API/operator/status/wellType/county - searchBottomHoles ~409 lean BH points (no operator) - searchOffshorePlatforms ~35 with operator/type/structure/tract - getWellByPermit, getServiceInfo §0: build-plan said "layer 39" (MS data on the same MapServer); AL wells live at layer 28. WellStatus is a code, TypeDesc is the STATUS description; WellType = product code, StatusDesc = TYPE description. Mobile + Escambia + Baldwin = 81% of records. CRS 102100; outSR=4326.

Arkansas Oil & Gas Commission well inventory, Smackover-Norphlet lithium-brine lease polygons, and historical pipelines via the Arkansas State GIS Office. - searchWells ⭐ ~38.2K wells with permit/operator/welltype/status/county/section - searchLithiumLeasedAreas ⭐ ~7 lithium-brine polygons (Standard Lithium + ExxonMobil) - searchPipelines ~719 USGS-1986 historical polylines - getWellByPermit, getServiceInfo §0: build-plan said Location/FeatureServer — has only GNIS names, NO O&G. Canonical wells at Utilities/FeatureServer/5. Fields lowercase (operatorname); counties UPPERCASE (UNION 7.1K, 19%). wellstatus has "ex" typo alongside "EX". CRS 26915; outSR=4326.

Argentine oil & gas open data from the Secretaría de Energía CKAN portal: well-level Capítulo IV production metadata (85,380 wells), unconventional shale/tight monthly production (400,759 rows, 2006-present), master well registry (84,242 wells), Vaca Muerta directional well trajectories (2,133 wells), and per-job fracture detail (4,696 jobs). First CKAN datastore connector in PatchOps. HTTP only — host has broken HTTPS. Filters are strict case-sensitive — use enumValues from getServiceInfo.

Arizona Oil & Gas Conservation Commission inventory: 1,241 well points plus sedimentary-basin and county-subdivision polygons from a 2023 snapshot. searchWells filters API, name, operator, county, status, or type; getWellsInBBox handles bbox/radius; polygon methods return GeoJSON. Well data is FeatureServer layer 7; layers 1-6 are generalized overlays, not wells. Status/type filters are case-insensitive because source casing varies. getCounties returns Census subdivisions, not the 15 counties. Native CRS is WGS84.

Colorado ECMC (formerly COGCC). DJ Basin / Wattenberg / Piceance operator-side. - searchWells (~120K) ⭐ filter county/operator/status/citingType/fieldName - searchPermits ⭐ Citing_Typ NOTICE+PLANNED on Well Spots - getWellByApi, searchPits (~13.7K), searchDirectionalBottomHoles (~38.1K), getServiceInfo Spec drift: searchSpills + searchSetbacks DROPPED — no Feature Services. Replaced with searchPits + searchDirectionalBottomHoles. upstream quirks: Authoritative AGOL is martinwi-owned COGCC_VIEW (same org as SLB). NO County text column — only API_County FIPS (123=Weld, 045=Garfield). Facil_Stat 2-letter codes (PR/PA/AC). Top operators: NOBLE (9.9K), KERR MCGEE (9K), PDC ENERGY (6.5K).

Colorado State Land Board — ~3M acres state trust lands. Lease + surface ownership + upcoming disposals. - searchOilGasLeases ⭐ Lease_Type='Oil and Gas' filter on ~4.5K leases (991 O&G) - searchUpcomingDisposals ⭐ TRXN-based auction tracts (sparse — 1-5 active) - searchSurfaceOwnership (~6.3K), getLeaseDetail, getServiceInfo upstream quirks: SLB GIS published by martinwi (same org as COGCC_VIEW). Spec said SLB_Leases_ALL_Public — that's the item title, NOT the URL path. Actual: Leases_ALL_2021/FeatureServer/0. Lease_Status: Active (4541), Out for Signature (13). Beneficiary dominated by School (4196). Lease_Subtype has 70+ values + data leaks. CSLB disposals layer 2 only (0/1 return 400).

Colombian oil & gas open data published by ANH (Agencia Nacional de Hidrocarburos) via datos.gov.co Socrata SODA. First Socrata connector in PatchOps. Datasets (live-probed 2026-05-07): - Crude oil production (51,924 monthly rows) ⭐ field/operator/department/contract + Point geometry - Gas production (69,074 monthly rows) ⭐ same shape, gas in KPC - Active contracts (275) ⭐ operator/cuenca/estado/etapa - Production tests (723, 2025-2026) initial + extended well tests - Field royalty liquidations (203,572) USD price, COP regalías per field-month upstream quirks: SoQL filters case-sensitive (CASANARE not casanare). Numbers stored as text with mixed US (11,955.00) and EU (63,13) formats. Year column on royalties is "a_o" (mangled "año").

California State Lands Commission — coastal tidelands + offshore O&G + School Lands + Granted Lands. - searchOffshoreLeases ⭐ ~34 polygons (Active 26 / Inactive 8) — Long Beach/Wilmington/Huntington - searchOnshoreLeases ⭐ ~5.5K leases (76 Oil & Gas). Defaults TypeofLease='Oil & Gas Lease' - searchSchoolLands ~1.3K PLSS polygons (CNTY field, NOT COUNTY) - searchGrantedLands ~115 tidelands grants. Active 105 / Repealed 4 upstream quirks: AGOL services3.arcgis.com/5aaQCuq3e4GRvkFG owned by CA_State_Lands_Commission. Offshore lean schema (PRC + Lease_Stat only). CSLC Leases use ISO date strings + Lat/Lon strings + geometry.x/y. School_Lands has CNTY (4-char), 'Tinity'->'Trinity' typo. Granted_Lands COUNTY has 'Marin'/'Marin County' variants.

Florida Department of Environmental Protection — permitted O&G wells plus environmental cleanup sites and state conservation lands, all folded into one connector. - searchOilGasWells ⭐ 1,477 permitted wells with company, county UPPERCASE, status (DRY HOLE/P&A, PROD, P&A, INJ, SWD) - searchEnvironmentalSites ⭐ 10,245 DEP cleanup sites — PETRO/BROWN/PFAS/SUPER/OTHCU - searchManagedLands ⭐ typed: brownfield (620) | aquatic-preserve (44) | conservation-land (3,215) - getWellByPermit, getServiceInfo §0 spec drift: FNAI SFWMD endpoint 403's — replaced with publicly readable FDEM AGOL FS/43 (same FNAI lineage). OIL_WELLS native CRS EPSG:6439 (FL Albers HARN). CLEANUP_SP has only numeric county ID. AQUATIC_PRESERVES uses plural COUNTIES.

Illinois State Geological Survey (ISGS) ILOIL well registry plus oil/gas/storage field polygons and waterflood-area boundaries via maps.isgs.illinois.edu. - searchWells ⭐ ~207K wells with API, status code+text, operator, formation, depth - searchOilGasFields ⭐ ~1K canonical 2024 unified oil + gas + gas-storage polygons (or ~550 legacy) - getWellByApi single well lookup, searchWaterfloodAreas, getServiceInfo §0 spec drift: brief listed Oil_Gas_GasStor_Fields_2023 — that service is 404. Canonical service is _2024. Wells layer is at index 8 of Wells/MapServer (NOT 0). STATUS column has 100+ codes; STATUS_TEXT has 100+ descriptive variants. Legacy service uses upper-snake fields, 2024 uses camelCase. Native CRS 102100; outSR=4326.

Indiana DNR oil and gas wells + natural-gas pipelines plus DNR-managed lands (nature preserves, recreation sites, forestry tracts) via the gisdata.in.gov state Hub. - searchWells ⭐ ~78.3K wells with county/lease/permit/status — no operator on this layer - searchPipelines ⭐ ~215 interstate + intrastate gas pipelines with operator names - searchManagedLands ⭐ typed: nature-preserve | recreation-site | forestry-tract - getWellByIgsId, getServiceInfo §0 spec drift: brief listed portal.igs.indiana.edu as primary; rich registry actually lives on gisdata.in.gov state Hub. maps.indiana.edu root is HTML 404. operator_name on OilAndGasWells is ALWAYS NULL upstream. CRS varies (102100/4269/26916); outSR=4326.

Kansas Geological Survey (KGS) — oil and gas wells (~515K), field polygons (~8K), and Class II UIC injection wells (~49K). - searchWells ⭐ 515,517 wells with operator, county Title Case, status, wellType, formation - searchOilGasFields ⭐ 8,089 field polygons (Active/Abandoned, Oil/Gas/Oil and Gas) - searchClassIIWells ⭐ 49,381 UIC Class II injection wells (EOR/SWD) - getWellByApi, getServiceInfo §0 spec drift: Hub kgs-gis-data-and-maps-ku is discovered via DCAT feed; underlying FS on services2.arcgis.com tenant ZOdjAzAQ2B0f85zi. STATUS column has 100+ codes (incl P&A suffix variants); WELL_TYPE separate. API_NUMBER dashed; API_NUM_NODASH 14-digit. CRS 102100; outSR=4326.

Kentucky Geological Survey oil and gas well-records repository — every Appalachian and Illinois Basin KY well in one HTTP call. - searchWells (~144.9K) ⭐ filter county/operator/boreType/resultSymbol (D&A/OIL/GAS/CBM)/basinCode/formation/pool - searchWellsByOperator ⭐ + searchWellsByCounty ⭐ — convenience wrappers exploiting the 1M page cap - getWellByApi (api OR record_number lookup), getServiceInfo §0 verified: maxRecordCount=1,000,000 confirmed — all 144,902 wells returned in one query. Native CRS EPSG:6473 (KY Single Zone); outSR=4326 reprojects on the wire. KY is 99% vertical drilling (143K V vs 1.5K H). Top counties: Henderson 6.9K, Cumberland 6.6K, Daviess 6.3K, Pike 6.3K. Top result symbols: D&A 45.7K, OIL 39.2K, GAS 28.8K, LOC 20K.

Louisiana SONRIS / DNR (now DCE) oil & gas. No auth. - searchWells (~245K) ⭐ filter by parish, operator, status (LEGEND_DES), product - searchSaltDomes (174) ⭐ LA-specific — caverns, sour gas risk, SPR - searchFields (~11K polygons), searchInjectionWells (~4.5K), getWellByApi, getServiceInfo upstream quirks: native sonris-www server is 404, working data is on AGOL mirrors. Well attributes are 10-char-truncated (WELL_STATU/LEGEND_DES). PARISH_NAM stored UPPERCASE. SONRIS production DB has no public API — wells include sonrisLink for browser-session deep dive.

Michigan EGLE oil and gas surface and bottom-hole locations, directional starts, and gas-storage field polygons via EGLE MiStar + DataMiner ArcGIS services. - searchSurfaceHoles ⭐ ~92.4K wells (DataMinerWells2; code WellStatus) - searchBottomHoles ⭐ ~96.6K — operator (co_name), formation (deep_fm), depth - searchGasStorageFields ⭐ ~61 storage-field polygons - searchDirectionalStarts (~95.3K), getWellByApi, getServiceInfo quirks: surface uses code WellStatus (PLA/PR/TP/ACT/SI/TA); bottom-hole uses descriptive ("Plugging Approved", "Producing"). No county column — use bbox/near. CRS 102100; outSR=4326. maxRecord=1000.

Mississippi Oil & Gas Board well-surface locations, onshore and offshore pipelines, and offshore platforms via FracTracker-curated AGOL services. - searchWells ⭐ ~8.1K canonical wells with API/operator/status/county/field/township - searchPipelines ⭐ ~3.5K (712+727 onshore lean + 2K offshore BSEE-style) - searchOffshorePlatforms ⭐ ~617 platforms with COMPLEX_ID, INSTALL_DA, REMOVAL_DA - getWellByApi, getServiceInfo §0 spec drift: build-plan endpoint (Mississippi_NEW2) has NO structured wells layer — its "Merge 7" point layer (6,557 KML-imported records) only exposes PopupInfo HTML strings. Canonical structured wells live at Mississippi_Update_4821/0. Native CRS already EPSG:4326. CountyName UPPERCASE.

Montana Board of Oil and Gas Conservation (BOGC) — wells (~42K), directional well paths (~4.1K), and DNRC Mineral Mgmt Bureau active state O&G leases (~1.2K). - searchWells ⭐ 41,960 wells with operator, status (P&A Approved, Producing, Shut In), type (Oil, Gas, CBM, Injection) - searchActiveLeases ⭐ 1,186 state O&G leases with County UPPERCASE, customer, primary-term flag - searchWellPaths ⭐ 4,113 directional well paths with formation - getWellByApi, getServiceInfo §0 spec drift: MBMG (state geological survey) Hub returns 403 — DROPPED. BOG_Wells layer has NO County column — county filter on wells must use bbox or PLSS Township/Range. APIWellNumber stored 14-digit unpacked. CRS varies (4269/32100); outSR=4326 works.

North Dakota DMR (Bakken/Three Forks) oil & gas. AGOL mirror of NDIC public well data; no auth. - searchWells (~25.5K) ⭐ filter by county, operator, status (A/PA/DRY/Confidential), well_type, township/range/section - searchPermits ⭐ wells in LOC/DRL/PNC/EXP permit states - getWellByApi, searchHorizontalLegs (~15.8K Bakken laterals), searchProductionByField, searchSpills, getServiceInfo upstream quirks: native dmr.nd.gov fee-services 401, working data is on AGOL sbogan_worldmap mirror. county UPPERCASE, status enum opaque codes (A/PA/DRY/Confidential), api lossy on production layer (use api_no on wells), horizontal legs only have linekey (api_LATn). Spills come from the FracTracker mirror — 2014-era extract, no live updates.

North Dakota Department of Trust Lands. AGOL Feature Services from owner jstegmiller@nd.gov_NDDTL; no auth. - searchOilGasLeases (~33K mineral tracts; 8.9K active) ⭐ filter county, lessee, eligible (default Leased) - getExpiringLeases ⭐ acquisition signal — leases expiring within windowDays - searchSurfaceLeases (~4.9K grazing/ag), getLeaseDetail, getServiceInfo upstream quirks: NDDTL does NOT publish OG-leases as a separate layer; they live inside the unified TrustLandsMineralsVW (filter lease LIKE '%OG-%'). exp/effective stored as MM/DD/YYYY string with " " for null. Counties Title-Case (different from ND DMR's UPPERCASE). landtrustdash.nd.gov is offline — AGOL views are the working public surface.

New Mexico State Land Office state-trust mineral leases. Permian parallel to TX GLO. No auth. - searchOilGasLeases (~5.9K) ⭐ active O&G leases — Permian Basin - getExpiringLeases ⭐ acquisition-signal feed across O&G/mineral/commercial/ag - searchMineralLeases (~746) — Salt Water Disposal, Caliche, Potash, Coal - searchAgriculturalLeases (~3.8K), getLeaseDetail, getServiceInfo upstream quirks: NMSLO publishes only ACTIVE leases (single STATUS value). NO COUNTY column on any layer — use bbox/near. Held-by-production leases have term-end at year-9999 epoch (surfaced as null daysUntilExpiry).

New York DEC Division of Mineral Resources — oil and gas wells (Allegany / Cattaraugus / Chautauqua dominant) plus surface mining permits (sand and gravel, bluestone, limestone). - searchWells (~47.4K) ⭐ filter county/operator/generalWellType/wellTypeCode/status/slant/formation - searchMines (~6.1K) ⭐ filter county/commodity/status/permittee - getWellByApi (API_WELLNO 14-digit), getMineById (MINEID), getServiceInfo §0 caught: WELL_TYPE / WELL_STATUS use 2-letter codes (OD/GD/IW/PA/AC); GENERALWELLTYPE / GENERALWELLSTATUS rollups available. Native CRS EPSG:26918 (NAD83 UTM 18N); outSR=4326 reprojects. Mines COMMODITY values are space-padded fixed-width — handler trims. Mines dates stored MM/DD/YYYY (NOT epoch ms). NY env folded into this connector per Batch L plan.

Ohio ODNR DOGRM. Marcellus + Utica operator side — Eclipse, Encino, Ascent, EAP heavy. - searchWells (~242K) ⭐ filter county/operator/status/wellType (V/H/D/O)/uticaOnly/marcellusOnly/orphanOnly - searchHorizontalWells ⭐ Utica/Marcellus laterals; asLines=true returns ~4.3K polylines - getWellByApi, searchWellPads, searchDrillingUnits, searchOilGasFields (~3K), getServiceInfo upstream quirks: WL_CNTY UPPERCASE on wells; County Title Case on pads. SLANT V/H/D/O. WL_STATUS_DESC is descriptive text. Utica_Shale/Marcellus_Shale 0/1. maxRecordCount=1000.

Pennsylvania DEP Bureau of Oil & Gas Management. PA's quirk: O&G regulator lives under DEP. - searchWells (~25K Unconv + ~199K Conv) ⭐ filter county/operator/status/wellType/wellConfig/wellCategory - searchPermits ⭐ wells with PERMIT_DATE in window (default unconv, last 365d) - getWellByApi, searchOrphanedWells (~27K), searchViolationsAndComplaints, getServiceInfo upstream quirks: PA does NOT use 14-digit API — wells keyed by PERMIT_NUMBER like '003-22621'. WELL_STATUS: Active / Plugged OG Well / Operator Reported Not Drilled / DEP Orphan List. WELL_CONFIG: Vertical (199K conv) / Horizontal (23K unconv) / Deviated. DEP does NOT publish violations Feature Service — Complaints (~39K) used as proxy. Production NOT a Feature Service (XML only) — dropped.

Utah SITLA — ~3.4M acres of trust lands; strongest state-trust portfolio per acre after TX. - searchOilGasLeases ⭐ ~851 active O&G mineral leases (10 production_status) - searchInactiveLeases ~5.5K historical / expired O&G leases - searchSurfaceOwnership ⭐ ~16K. owner=Fed/Private/State/Tribal; agency=BLM/SITLA/USFS - getLeaseDetail single-lease lookup by leasegis (ML22161.0) upstream quirks: TWO origins — /mapping/rest (UtahSITLA) for Contracts; /server/rest (plpcoadmin_agol) for Ownership. Active O&G is **layer 1 NOT 0** of Contracts_Oil_Gas. class has trailing spaces ('ML '). Active dates are epoch ms; inactive dates are MM/DD/YYYY strings. Active layer has NO county — bbox/near only.

Texas General Land Office state lands. No auth. O&G: searchActiveLeases (~7.3K) ⭐ royalties+primary-term dates, getExpiringLeases ⭐ acquisition feed, searchInactiveLeases (~12K), getLeaseDetail, searchLeaseUnits, searchPSFLands (~21.9K), searchEasements, searchOffshoreStructures, getNominatedTracts. Coastal/land: searchUplandLeases, searchSubmergedTracts (~11K), searchBeachAccess, searchCoastalLeases (~9.2K), searchStateAgencyLands, searchNavigationDistricts, searchPriorityHabitatAreas, searchEsiShoreline (~48K lines), searchInSituBurnExclusion + boundary getters (Coastal Zone, 3-league/3-mile lines, Dispersant Zone, lease polygons). getServiceInfo for schemas. Quirks: MM/DD/YYYY string dates; most non-lease layers have no COUNTY column; ESI/boundary layers return line geometry.

Utah DOGM — O&G regulator. Uinta Basin operator side (Crescent / Ovintiv / KODA). - searchWells ⭐ ~40K surface wells with operator/county/status/cumulative - searchBottomHoles ⭐ ~33K bottomhole locations (deviated wells) - searchWellPaths ~12.5K directional drilling polylines - getWellByApi single-well lookup by 10-digit API upstream quirks: AGOL services.arcgis.com/ZzrwjTRez6FJiOq4 owner OGMGIS_utahDNR. Surf County is UPPERCASE STRING ('DUCHESNE'); BottomHole County is INTEGER code (Duchesne=7 / Uintah=24 / San Juan=19). Paths layer has only API + ConstructStatus (no operator/county). O&G permits are NOT a Feature Service — searchPermits dropped; APD-status wells (1772) are the substitute via searchWells.

Virginia Department of Energy (ex-DMME) — coalbed methane / oil & gas wells, 54.6K SWVA drilling grids, and statewide mineral mining permits. - searchOilGasWells ⭐ active (8.6K) | permittedUndrilled (208) | plugged (1.97K) via wellLayer - searchHorizontalGrids ⭐ 54.6K SWVA 20-acre drilling grid polygons - searchMineralMines ⭐ active (450) | released (1.78K). Filter mineralType (OP/QU/UG) - getWellByFiNo (cross-layer lookup), getServiceInfo §0 caught: Legacy dmme.virginia.gov DEAD — public surface is energy.virginia.gov. Geothermal/8 (NGDS, 1.3K) duplicate of DGO_wells — DROPPED. 73% CBM (Coalbed/Pipeline + Coal Bed). Counties UPPERCASE (BUCHANAN/DICKENSON/WISE 88%). Native CRS EPSG:6591; outSR=4326 reprojects.

WVDEP consolidated. Marcellus heart — EQT, Antero, Range, Southwestern. 11 services in one enterprise folder, 9 layers via 8 methods. - searchWells (~153K) ⭐ county (→FIPS), operator, status, wellType, formation, marcellus/horizontal flags - searchPermits ⭐ orderBy issuedate desc; permitType, yearFrom/To - searchAirEmissionSources (~2.6K), searchAbandonedMineLands (~10K), searchRemediationSites (VRP+SEMS), searchMiningReclamation (~11K), searchDamSafety (~395), searchWatershedAssessment (~34K 303d), getServiceInfo upstream quirks: county on wells = FIPS suffix (Wetzel='103'). marcellus 'y'/'n'/'u' string. Mining columns are type/per_status. SEMS columns 10-char truncated. AML status bracketed variants. Air/AML/VRP/Mining/Dam/Watershed have NO county column — bbox/near only.

Wyoming OSLI — ~3.5M acres state trust + mineral estate. - searchOilGasLeases (~15.4K — slim schema) - searchSchoolSections ⭐ FundCode='CS' (Common School Sec 16+36 trust ~20K) - searchSurfaceOwnership (~31.6K), searchUpcomingAuctionLands (~195 LARCS rich), getServiceInfo Spec drift: getLeaseDetail DROPPED — lease polygon schema is too slim (LeaseNumber + dates only). LARCS table provides rich county/acres/bidPerAcre attributes — surfaced as searchUpcomingAuctionLands. upstream quirks: StateOwnership has NO County column — bbox/PLSS scoping only. FundCode CS dominates (20.1K of 31.6K parcels). Native gis2.statelands.wyo.gov returns rich schemas; AGOL mirrors are slimmer.

Wyoming WOGCC. Powder River + Niobrara + Greater Green River — CBM legacy + modern shale. - searchWells (~68.7K) ⭐ filter county/operator/status/wellClass/twp/rge/horizontalOnly - searchPermits ⭐ STATUS in (AP, NI) on Wells layer (no separate APD service) - getWellByApi, searchHorizontalLegs (~28K BH vectors), searchPluggedAndAbandoned (~61K), getServiceInfo Spec drift: gis.wogcc.wyo.gov DNS dead. WOGCC pits + APDs not Feature Services. Replacements: searchPluggedAndAbandoned + STATUS-coded permit filtering. upstream quirks: COUNTY integer FIPS (5=Campbell 18.3K wells). STATUS 2-letter (PR/PA/SI/TA/AI/FL). maxRecordCount=1000. BH layer = horizontal lateral polylines.