Colombia ANH

Methods (6)

• searchOilProduction

  read

  Crude oil production (51,924 rows). Filter by departamento, operadora, campo, contrato, year, month.

  Entitiesproduction
  Input schema

  {
    "type": "object",
    "properties": {
      "departamento": {
        "type": "string",
        "examples": [
          "CASANARE"
        ]
      },
      "operadora": {
        "type": "string"
      },
      "campo": {
        "type": "string"
      },
      "contrato": {
        "type": "string"
      },
      "year": {
        "type": "number",
        "examples": [
          2024
        ]
      },
      "month": {
        "type": "number"
      },
      "limit": {
        "type": "number"
      },
      "offset": {
        "type": "number"
      }
    },
    "additionalProperties": false
  }

  Department/operator UPPERCASE. produccion_bls parsed from text.

• searchGasProduction

  read

  Gas production in KPC (69,074 rows). Same filter shape as oil; geolocalizacion Point.

  Entitiesproduction
  Input schema

  {
    "type": "object",
    "properties": {
      "departamento": {
        "type": "string"
      },
      "operadora": {
        "type": "string",
        "examples": [
          "ECOPETROL S.A."
        ]
      },
      "campo": {
        "type": "string"
      },
      "contrato": {
        "type": "string"
      },
      "year": {
        "type": "number",
        "examples": [
          2024
        ]
      },
      "month": {
        "type": "number"
      },
      "limit": {
        "type": "number"
      },
      "offset": {
        "type": "number"
      }
    },
    "additionalProperties": false
  }

  upstream uses nombremes (no underscore); handler normalizes.

• searchContracts

  read

  Active hydrocarbon contracts (275). Filter by operator, basin, status, etapa, surface.

  Entitieslease
  Input schema

  {
    "type": "object",
    "properties": {
      "operadora": {
        "type": "string"
      },
      "tipoContrato": {
        "type": "string"
      },
      "cuenca": {
        "type": "string",
        "examples": [
          "LLANOS ORIENTALES"
        ]
      },
      "status": {
        "type": "string",
        "examples": [
          "En Ejecución"
        ]
      },
      "etapa": {
        "type": "string"
      },
      "superficie": {
        "type": "string"
      },
      "limit": {
        "type": "number"
      },
      "offset": {
        "type": "number"
      }
    },
    "additionalProperties": false
  }

  estado has duplicate casings: "En ejecución" and "En Ejecución" both real.

• searchProductionTests

  read

  Initial / extended well production tests (723 rows). Only 2025-2026 populated.

  Entitiesproduction, completion
  Input schema

  {
    "type": "object",
    "properties": {
      "operadora": {
        "type": "string"
      },
      "campo": {
        "type": "string"
      },
      "contrato": {
        "type": "string"
      },
      "tipoPrueba": {
        "type": "string",
        "examples": [
          "Iniciales"
        ]
      },
      "estado": {
        "type": "string"
      },
      "year": {
        "type": "number",
        "examples": [
          2025
        ]
      },
      "limit": {
        "type": "number"
      },
      "offset": {
        "type": "number"
      }
    },
    "additionalProperties": false
  }

  tipoPrueba: Iniciales|Extensas. estado: Activo|Inactivo|Abandonado|Cerrado.

• searchFieldRoyalties

  read

  Field-level royalty liquidations (203,572 rows). USD price + COP regalías per month.

  Entitiesproduction, ownership, field
  Input schema

  {
    "type": "object",
    "properties": {
      "campo": {
        "type": "string"
      },
      "contrato": {
        "type": "string"
      },
      "departamento": {
        "type": "string"
      },
      "tipoHidrocarburo": {
        "type": "string",
        "examples": [
          "O"
        ]
      },
      "tipoProd": {
        "type": "string"
      },
      "year": {
        "type": "number",
        "examples": [
          2023
        ]
      },
      "month": {
        "type": "number"
      },
      "limit": {
        "type": "number"
      },
      "offset": {
        "type": "number"
      }
    },
    "additionalProperties": false
  }

  Year column is `a_o` upstream. Numbers in EU comma-decimal — handler parses.

• getServiceInfo

  read

  Dataset row counts, enum values, publisher info, and §0 probe notes (24h cache).

  Entitiesmetadata
  Input schema

  {
    "type": "object",
    "properties": {},
    "additionalProperties": false
  }