{
  "generated_at": "2026-06-16T21:09:59+00:00",
  "rows": [
    {
      "api": "28330252",
      "api5": "30252",
      "well_number": "1683",
      "status": "Plugged Gas Well",
      "category": "plugged",
      "distance_miles": 0.3133,
      "latitude": 28.14247181519512,
      "longitude": -99.29773255254104,
      "rrc_gis_viewer": "https://gis.rrc.texas.gov/GISViewer/index.html?api=28330252",
      "pdq_query": "https://webapps2.rrc.texas.gov/EWA/productionQueryAction.do",
      "specific_lease_query": "https://webapps2.rrc.texas.gov/EWA/specificLeaseQueryAction.do",
      "production_join_status": "PENDING_API_WELLBORE_TO_LEASE_JOIN",
      "reason": "RRC public GIS well layer exposes API/status/location, but not lease number/operator/field required for specific PDQ production lookup."
    },
    {
      "api": "28332078",
      "api5": "32078",
      "well_number": "3",
      "status": "Gas Well",
      "category": "producing",
      "distance_miles": 0.6733,
      "latitude": 28.14501872909162,
      "longitude": -99.31283133972882,
      "rrc_gis_viewer": "https://gis.rrc.texas.gov/GISViewer/index.html?api=28332078",
      "pdq_query": "https://webapps2.rrc.texas.gov/EWA/productionQueryAction.do",
      "specific_lease_query": "https://webapps2.rrc.texas.gov/EWA/specificLeaseQueryAction.do",
      "production_join_status": "PENDING_API_WELLBORE_TO_LEASE_JOIN",
      "reason": "RRC public GIS well layer exposes API/status/location, but not lease number/operator/field required for specific PDQ production lookup."
    },
    {
      "api": "28335967",
      "api5": "35967",
      "well_number": "13H",
      "status": "Gas Well",
      "category": "producing",
      "distance_miles": 0.7417,
      "latitude": 28.146914609523183,
      "longitude": -99.29236623772847,
      "rrc_gis_viewer": "https://gis.rrc.texas.gov/GISViewer/index.html?api=28335967",
      "pdq_query": "https://webapps2.rrc.texas.gov/EWA/productionQueryAction.do",
      "specific_lease_query": "https://webapps2.rrc.texas.gov/EWA/specificLeaseQueryAction.do",
      "production_join_status": "PENDING_API_WELLBORE_TO_LEASE_JOIN",
      "reason": "RRC public GIS well layer exposes API/status/location, but not lease number/operator/field required for specific PDQ production lookup."
    },
    {
      "api": "28332137",
      "api5": "32137",
      "well_number": "1",
      "status": "Permitted Location",
      "category": "permitted",
      "distance_miles": 0.8316,
      "latitude": 28.136775684998167,
      "longitude": -99.31536398283009,
      "rrc_gis_viewer": "https://gis.rrc.texas.gov/GISViewer/index.html?api=28332137",
      "pdq_query": "https://webapps2.rrc.texas.gov/EWA/productionQueryAction.do",
      "specific_lease_query": "https://webapps2.rrc.texas.gov/EWA/specificLeaseQueryAction.do",
      "production_join_status": "PENDING_API_WELLBORE_TO_LEASE_JOIN",
      "reason": "RRC public GIS well layer exposes API/status/location, but not lease number/operator/field required for specific PDQ production lookup."
    },
    {
      "api": "28333682",
      "api5": "33682",
      "well_number": "13H",
      "status": "Gas Well",
      "category": "producing",
      "distance_miles": 0.8543,
      "latitude": 28.15094718564397,
      "longitude": -99.29404725750594,
      "rrc_gis_viewer": "https://gis.rrc.texas.gov/GISViewer/index.html?api=28333682",
      "pdq_query": "https://webapps2.rrc.texas.gov/EWA/productionQueryAction.do",
      "specific_lease_query": "https://webapps2.rrc.texas.gov/EWA/specificLeaseQueryAction.do",
      "production_join_status": "PENDING_API_WELLBORE_TO_LEASE_JOIN",
      "reason": "RRC public GIS well layer exposes API/status/location, but not lease number/operator/field required for specific PDQ production lookup."
    },
    {
      "api": "283",
      "api5": " ",
      "well_number": "1",
      "status": "Dry Hole",
      "category": "dry_hole",
      "distance_miles": 0.8827,
      "latitude": 28.153964242639383,
      "longitude": -99.3030605553171,
      "rrc_gis_viewer": "https://gis.rrc.texas.gov/GISViewer/index.html?api=283",
      "pdq_query": "https://webapps2.rrc.texas.gov/EWA/productionQueryAction.do",
      "specific_lease_query": "https://webapps2.rrc.texas.gov/EWA/specificLeaseQueryAction.do",
      "production_join_status": "PENDING_API_WELLBORE_TO_LEASE_JOIN",
      "reason": "RRC public GIS well layer exposes API/status/location, but not lease number/operator/field required for specific PDQ production lookup."
    },
    {
      "api": "28332118",
      "api5": "32118",
      "well_number": "2",
      "status": "Gas Well",
      "category": "producing",
      "distance_miles": 0.929,
      "latitude": 28.146238643815924,
      "longitude": -99.31680230980227,
      "rrc_gis_viewer": "https://gis.rrc.texas.gov/GISViewer/index.html?api=28332118",
      "pdq_query": "https://webapps2.rrc.texas.gov/EWA/productionQueryAction.do",
      "specific_lease_query": "https://webapps2.rrc.texas.gov/EWA/specificLeaseQueryAction.do",
      "production_join_status": "PENDING_API_WELLBORE_TO_LEASE_JOIN",
      "reason": "RRC public GIS well layer exposes API/status/location, but not lease number/operator/field required for specific PDQ production lookup."
    },
    {
      "api": "28337863",
      "api5": "37863",
      "well_number": "2H",
      "status": "Shut-In Gas",
      "category": "shut_in",
      "distance_miles": 0.9738,
      "latitude": 28.130245350182467,
      "longitude": -99.31273055632295,
      "rrc_gis_viewer": "https://gis.rrc.texas.gov/GISViewer/index.html?api=28337863",
      "pdq_query": "https://webapps2.rrc.texas.gov/EWA/productionQueryAction.do",
      "specific_lease_query": "https://webapps2.rrc.texas.gov/EWA/specificLeaseQueryAction.do",
      "production_join_status": "PENDING_API_WELLBORE_TO_LEASE_JOIN",
      "reason": "RRC public GIS well layer exposes API/status/location, but not lease number/operator/field required for specific PDQ production lookup."
    }
  ]
}