{
  "$schema": "https://welldot.org/schema/v2/well.schema.json",
  "version": "2.4",
  "x-welldot-example": {
    "illustrative": true,
    "based_on": "https://siagasweb.sgb.gov.br/layout/detalhe.php?ponto=3500000898"
  },
  "well_type": "tubular",
  "well_purpose": [
    "production"
  ],
  "name": "Poço P-05 — Sede (Estrela d'Oeste/SP)",
  "well_driller": "Perfuradora Noroeste Paulista Ltda.",
  "construction_date": "1981-01-19",
  "obs": "Poço telescópico (18\" → 6\") com cinco seções de filtro Nold no Aquífero Bauru e trecho aberto nos basaltos da Formação Serra Geral (captação simultânea). Nitrato em alta desde 2015 por influência urbana.",
  "well_id": [
    {
      "authority": "SAE",
      "id": "P-05",
      "primary": true
    },
    {
      "authority": "SP Águas",
      "id": "Cadastro 0072/2004"
    }
  ],
  "location": {
    "lat": -20.30361,
    "lng": -50.40361,
    "elevation": 430,
    "properties": {
      "timezone": "America/Sao_Paulo",
      "crs": "EPSG:4326",
      "lat_precision": 0.0003,
      "lng_precision": 0.0003,
      "elevation_datum": "x-imbituba",
      "elevation_precision": 5,
      "original_crs": "EPSG:31982"
    }
  },
  "well_depth": 201,
  "bore_hole": [
    {
      "from": 0,
      "to": 9,
      "diameter": 457,
      "drilling_method": "percussion"
    },
    {
      "from": 9,
      "to": 57.7,
      "diameter": 356,
      "drilling_method": "percussion"
    },
    {
      "from": 57.7,
      "to": 59.5,
      "diameter": 254,
      "drilling_method": "percussion"
    },
    {
      "from": 59.5,
      "to": 130,
      "diameter": 203,
      "drilling_method": "percussion"
    },
    {
      "from": 130,
      "to": 201,
      "diameter": 152,
      "drilling_method": "percussion"
    }
  ],
  "well_case": [
    {
      "from": -0.55,
      "to": 39.75,
      "type": "carbon_steel",
      "diameter": 168
    },
    {
      "from": 42.75,
      "to": 43.25,
      "type": "carbon_steel",
      "diameter": 168
    },
    {
      "from": 46.25,
      "to": 46.75,
      "type": "carbon_steel",
      "diameter": 168
    },
    {
      "from": 49.75,
      "to": 51.65,
      "type": "carbon_steel",
      "diameter": 168
    },
    {
      "from": 54.65,
      "to": 55.15,
      "type": "carbon_steel",
      "diameter": 168
    },
    {
      "from": 58.15,
      "to": 59.6,
      "type": "carbon_steel",
      "diameter": 168
    }
  ],
  "reduction": [],
  "well_screen": [
    {
      "from": 39.75,
      "to": 42.75,
      "type": "carbon_steel",
      "diameter": 168,
      "screen_slot": 1,
      "slot_type": "nold"
    },
    {
      "from": 43.25,
      "to": 46.25,
      "type": "carbon_steel",
      "diameter": 168,
      "screen_slot": 1,
      "slot_type": "nold"
    },
    {
      "from": 46.75,
      "to": 49.75,
      "type": "carbon_steel",
      "diameter": 168,
      "screen_slot": 1,
      "slot_type": "nold"
    },
    {
      "from": 51.65,
      "to": 54.65,
      "type": "carbon_steel",
      "diameter": 168,
      "screen_slot": 1,
      "slot_type": "nold"
    },
    {
      "from": 55.15,
      "to": 58.15,
      "type": "carbon_steel",
      "diameter": 168,
      "screen_slot": 1,
      "slot_type": "nold"
    }
  ],
  "surface_case": [
    {
      "from": 0,
      "to": 9,
      "diameter": 406
    }
  ],
  "hole_fill": [
    {
      "from": 0,
      "to": 9,
      "type": "seal",
      "diameter": 457,
      "description": "Cimentação do tubo de boca"
    },
    {
      "from": 9,
      "to": 30,
      "type": "seal",
      "diameter": 356,
      "description": "Argila compactada e cimento"
    },
    {
      "from": 30,
      "to": 57.7,
      "type": "gravel_pack",
      "diameter": 356,
      "description": "Pré-filtro de areia grossa selecionada 1–3 mm"
    },
    {
      "from": 57.7,
      "to": 59.5,
      "type": "gravel_pack",
      "diameter": 254,
      "description": "Pré-filtro de areia grossa selecionada 1–3 mm"
    }
  ],
  "lithology": [
    {
      "from": 0,
      "to": 10,
      "description": "Argila sílticoarenosa preta, muita matéria orgânica, friável",
      "color": "#4b4038",
      "texture": {
        "code": 620,
        "vocabulary": "fgdc"
      },
      "geologic_unit": "Depósitos aluviais",
      "aquifer_unit": "Não aquífero"
    },
    {
      "from": 10,
      "to": 36,
      "description": "Arenito argiloso fino a muito fino, castanho-claro, subangular, mal selecionado, pouco carbonático",
      "color": "#c9a77c",
      "texture": {
        "code": 612,
        "vocabulary": "fgdc"
      },
      "geologic_unit": "Grupo Bauru",
      "aquifer_unit": "Sistema Aquífero Bauru"
    },
    {
      "from": 36,
      "to": 57.7,
      "description": "Arenito castanho-avermelhado, mais carbonático",
      "color": "#b9785a",
      "texture": {
        "code": 613,
        "vocabulary": "fgdc"
      },
      "geologic_unit": "Grupo Bauru",
      "aquifer_unit": "Sistema Aquífero Bauru"
    },
    {
      "from": 57.7,
      "to": 84,
      "description": "Basalto compacto cinza-claro com calcita e epidoto",
      "color": "#6b6b70",
      "texture": {
        "code": 717,
        "vocabulary": "fgdc"
      },
      "geologic_unit": "Formação Serra Geral",
      "aquifer_unit": "Aquífero Serra Geral"
    },
    {
      "from": 84,
      "to": 114,
      "description": "Basalto marrom médio alterado, vesicular, semiduro",
      "color": "#7a5f4f",
      "texture": {
        "code": 717,
        "vocabulary": "fgdc"
      },
      "geologic_unit": "Formação Serra Geral",
      "aquifer_unit": "Aquífero Serra Geral"
    },
    {
      "from": 114,
      "to": 158,
      "description": "Basalto cinza-claro, duro, compacto",
      "color": "#6b6b70",
      "texture": {
        "code": 717,
        "vocabulary": "fgdc"
      },
      "geologic_unit": "Formação Serra Geral",
      "aquifer_unit": "Aquífero Serra Geral"
    },
    {
      "from": 158,
      "to": 176,
      "description": "Basalto cinza médio, compacto, duro",
      "color": "#5a5a60",
      "texture": {
        "code": 717,
        "vocabulary": "fgdc"
      },
      "geologic_unit": "Formação Serra Geral",
      "aquifer_unit": "Aquífero Serra Geral"
    },
    {
      "from": 176,
      "to": 201,
      "description": "Basalto avermelhado, semiduro, compacto, com calcita branca",
      "color": "#7d5450",
      "texture": {
        "code": 717,
        "vocabulary": "fgdc"
      },
      "geologic_unit": "Formação Serra Geral",
      "aquifer_unit": "Aquífero Serra Geral"
    }
  ],
  "fractures": [
    {
      "depth": 96,
      "depth_precision": 1,
      "water_intake": true,
      "description": "Topo vesicular do derrame — entrada d'água no basalto",
      "swarm": true,
      "azimuth": 0,
      "dip": 0
    }
  ],
  "caves": [],
  "hydrodynamic_events": [
    {
      "id": "evt-01",
      "type": "constant_rate",
      "datetime": "1981-02-02T07:00:00-03:00",
      "operator": "Perfuradora Noroeste Paulista Ltda.",
      "static_level": 12,
      "steps": [
        {
          "rate": 39.6,
          "duration": 1440,
          "readings": [
            {
              "elapsed": 1,
              "depth": 27.99
            },
            {
              "elapsed": 2,
              "depth": 29.01
            },
            {
              "elapsed": 3,
              "depth": 29.6
            },
            {
              "elapsed": 5,
              "depth": 30.35
            },
            {
              "elapsed": 7,
              "depth": 30.84
            },
            {
              "elapsed": 10,
              "depth": 31.37
            },
            {
              "elapsed": 15,
              "depth": 31.96
            },
            {
              "elapsed": 20,
              "depth": 32.38
            },
            {
              "elapsed": 30,
              "depth": 32.98
            },
            {
              "elapsed": 45,
              "depth": 33.57
            },
            {
              "elapsed": 60,
              "depth": 33.99
            },
            {
              "elapsed": 90,
              "depth": 34.59
            },
            {
              "elapsed": 120,
              "depth": 35.01
            },
            {
              "elapsed": 180,
              "depth": 35.6
            },
            {
              "elapsed": 240,
              "depth": 36.02
            },
            {
              "elapsed": 360,
              "depth": 36.62
            },
            {
              "elapsed": 480,
              "depth": 37.04
            },
            {
              "elapsed": 600,
              "depth": 37.37
            },
            {
              "elapsed": 720,
              "depth": 37.63
            },
            {
              "elapsed": 900,
              "depth": 37.96
            },
            {
              "elapsed": 1080,
              "depth": 38.23
            },
            {
              "elapsed": 1260,
              "depth": 38.45
            },
            {
              "elapsed": 1440,
              "depth": 38.65
            }
          ]
        }
      ],
      "recovery": {
        "readings": [
          {
            "elapsed": 1,
            "depth": 22.66
          },
          {
            "elapsed": 2,
            "depth": 21.65
          },
          {
            "elapsed": 3,
            "depth": 21.05
          },
          {
            "elapsed": 5,
            "depth": 20.31
          },
          {
            "elapsed": 10,
            "depth": 19.29
          },
          {
            "elapsed": 15,
            "depth": 18.71
          },
          {
            "elapsed": 30,
            "depth": 17.7
          },
          {
            "elapsed": 60,
            "depth": 16.72
          },
          {
            "elapsed": 120,
            "depth": 15.76
          },
          {
            "elapsed": 240,
            "depth": 14.85
          },
          {
            "elapsed": 360,
            "depth": 14.36
          },
          {
            "elapsed": 480,
            "depth": 14.03
          }
        ]
      }
    },
    {
      "id": "evt-02",
      "type": "spot_measurement",
      "datetime": "2004-06-15T08:00:00-03:00",
      "static_level": 15.8,
      "measurement_method": "tape",
      "notes": "Medição para o cadastro no DAEE."
    },
    {
      "id": "evt-03",
      "type": "spot_measurement",
      "datetime": "2025-06-10T07:00:00-03:00",
      "static_level": 19.35,
      "static_level_precision": 0.01,
      "measurement_method": "electric_probe"
    }
  ],
  "cement_pad": {
    "type": "concrete",
    "width": 2,
    "thickness": 0.2,
    "length": 2
  },
  "aquifer_analysis": [
    {
      "id": "an-1981",
      "datetime": "1981-02-10T10:00:00-03:00",
      "source_event_ids": [
        "evt-01"
      ],
      "method": "cooper_jacob",
      "static_level": 12,
      "static_level_source_id": "evt-01",
      "dynamic_level": 38.65,
      "flow_rate": 39.6,
      "specific_capacity": 1.49,
      "transmissivity": 51.5,
      "notes": "Captação simultânea Bauru + Serra Geral; valor representa o conjunto."
    }
  ],
  "pump_installations": [
    {
      "id": "pump-2016",
      "installed_at": "2016-08-01T09:00:00-03:00",
      "type": "submersible",
      "power_source": "grid",
      "manufacturer": "Grundfos",
      "model": "SP 30-11",
      "intake_depth": 66,
      "rated_flow_rate": 30,
      "rated_head": 95,
      "rated_power": 15,
      "stages": 11,
      "riser_diameter": 75,
      "riser_material": "galvanized_steel",
      "check_valve": true,
      "notes": "Crivo a 66 m, no trecho aberto em basalto abaixo dos filtros."
    }
  ],
  "permits": [
    {
      "id": "outorga-2005",
      "type": "abstraction_permit",
      "authority": "SP Águas",
      "status": "granted",
      "identifier": "Portaria DAEE nº 1532/2005",
      "issued_at": "2005-07-11",
      "valid_until": "2030-07-11",
      "water_use": [
        "human_supply"
      ],
      "flow_rate": 30,
      "daily_operating_time": 20,
      "notes": "Outorga emitida pelo DAEE; a gestão passou à SP Águas."
    }
  ],
  "operating_regime": [
    {
      "id": "reg-2016",
      "effective_from": "2016-08-01T09:00:00-03:00",
      "flow_rate": 30,
      "daily_operating_time": 18,
      "days_per_week": 7
    }
  ],
  "water_samples": [
    {
      "id": "am-2015",
      "datetime": "2015-07-14T09:00:00-03:00",
      "sample_type": "routine",
      "campaign": "Controle de nitrato 2015",
      "sampling_method": "pump_discharge",
      "sampling_point": {
        "type": "pump_discharge"
      },
      "laboratory": {
        "name": "Laboratório Noroeste Saneamento",
        "report_number": "LNS-2015/0210"
      },
      "results": [
        {
          "parameter": {
            "code": "ph",
            "vocabulary": "welldot"
          },
          "value": 6.4,
          "measured_in": "field"
        },
        {
          "parameter": {
            "code": "specific_conductance",
            "vocabulary": "welldot"
          },
          "value": 142,
          "measured_in": "field"
        },
        {
          "parameter": {
            "code": "nitrate_as_n",
            "vocabulary": "welldot"
          },
          "value": 5.8,
          "measured_in": "lab",
          "method": "SMEWW 4500-NO₃⁻ E"
        },
        {
          "parameter": {
            "code": "chloride",
            "vocabulary": "welldot"
          },
          "value": 6.2,
          "measured_in": "lab",
          "method": "SMEWW 4500-Cl⁻ B"
        },
        {
          "parameter": {
            "code": "sodium",
            "vocabulary": "welldot"
          },
          "value": 5.1,
          "measured_in": "lab",
          "method": "SMEWW 3120 B"
        },
        {
          "parameter": {
            "code": "bicarbonate",
            "vocabulary": "welldot"
          },
          "value": 61,
          "measured_in": "lab",
          "method": "SMEWW 2320 B"
        },
        {
          "parameter": {
            "code": "total_coliforms",
            "vocabulary": "welldot"
          },
          "presence": false,
          "measured_in": "lab",
          "method": "SMEWW 9223 B"
        },
        {
          "parameter": {
            "code": "e_coli",
            "vocabulary": "welldot"
          },
          "presence": false,
          "measured_in": "lab",
          "method": "SMEWW 9223 B"
        }
      ]
    },
    {
      "id": "am-2019",
      "datetime": "2019-07-14T09:00:00-03:00",
      "sample_type": "routine",
      "campaign": "Controle de nitrato 2019",
      "sampling_method": "pump_discharge",
      "sampling_point": {
        "type": "pump_discharge"
      },
      "laboratory": {
        "name": "Laboratório Noroeste Saneamento",
        "report_number": "LNS-2019/0211"
      },
      "results": [
        {
          "parameter": {
            "code": "ph",
            "vocabulary": "welldot"
          },
          "value": 6.3,
          "measured_in": "field"
        },
        {
          "parameter": {
            "code": "specific_conductance",
            "vocabulary": "welldot"
          },
          "value": 168,
          "measured_in": "field"
        },
        {
          "parameter": {
            "code": "nitrate_as_n",
            "vocabulary": "welldot"
          },
          "value": 7.1,
          "measured_in": "lab",
          "method": "SMEWW 4500-NO₃⁻ E"
        },
        {
          "parameter": {
            "code": "chloride",
            "vocabulary": "welldot"
          },
          "value": 8.4,
          "measured_in": "lab",
          "method": "SMEWW 4500-Cl⁻ B"
        },
        {
          "parameter": {
            "code": "sodium",
            "vocabulary": "welldot"
          },
          "value": 6,
          "measured_in": "lab",
          "method": "SMEWW 3120 B"
        },
        {
          "parameter": {
            "code": "bicarbonate",
            "vocabulary": "welldot"
          },
          "value": 63,
          "measured_in": "lab",
          "method": "SMEWW 2320 B"
        },
        {
          "parameter": {
            "code": "total_coliforms",
            "vocabulary": "welldot"
          },
          "presence": false,
          "measured_in": "lab",
          "method": "SMEWW 9223 B"
        },
        {
          "parameter": {
            "code": "e_coli",
            "vocabulary": "welldot"
          },
          "presence": false,
          "measured_in": "lab",
          "method": "SMEWW 9223 B"
        }
      ]
    },
    {
      "id": "am-2023",
      "datetime": "2023-07-14T09:00:00-03:00",
      "sample_type": "routine",
      "campaign": "Controle de nitrato 2023",
      "sampling_method": "pump_discharge",
      "sampling_point": {
        "type": "pump_discharge"
      },
      "laboratory": {
        "name": "Laboratório Noroeste Saneamento",
        "report_number": "LNS-2023/0212"
      },
      "results": [
        {
          "parameter": {
            "code": "ph",
            "vocabulary": "welldot"
          },
          "value": 6.3,
          "measured_in": "field"
        },
        {
          "parameter": {
            "code": "specific_conductance",
            "vocabulary": "welldot"
          },
          "value": 189,
          "measured_in": "field"
        },
        {
          "parameter": {
            "code": "nitrate_as_n",
            "vocabulary": "welldot"
          },
          "value": 8.4,
          "measured_in": "lab",
          "method": "SMEWW 4500-NO₃⁻ E"
        },
        {
          "parameter": {
            "code": "chloride",
            "vocabulary": "welldot"
          },
          "value": 10.9,
          "measured_in": "lab",
          "method": "SMEWW 4500-Cl⁻ B"
        },
        {
          "parameter": {
            "code": "sodium",
            "vocabulary": "welldot"
          },
          "value": 7.2,
          "measured_in": "lab",
          "method": "SMEWW 3120 B"
        },
        {
          "parameter": {
            "code": "bicarbonate",
            "vocabulary": "welldot"
          },
          "value": 60,
          "measured_in": "lab",
          "method": "SMEWW 2320 B"
        },
        {
          "parameter": {
            "code": "total_coliforms",
            "vocabulary": "welldot"
          },
          "presence": false,
          "measured_in": "lab",
          "method": "SMEWW 9223 B"
        },
        {
          "parameter": {
            "code": "e_coli",
            "vocabulary": "welldot"
          },
          "presence": false,
          "measured_in": "lab",
          "method": "SMEWW 9223 B"
        }
      ]
    },
    {
      "id": "am-2025",
      "datetime": "2025-07-14T09:00:00-03:00",
      "sample_type": "routine",
      "campaign": "Controle de nitrato 2025",
      "sampling_method": "pump_discharge",
      "sampling_point": {
        "type": "pump_discharge"
      },
      "laboratory": {
        "name": "Laboratório Noroeste Saneamento",
        "report_number": "LNS-2025/0213"
      },
      "results": [
        {
          "parameter": {
            "code": "ph",
            "vocabulary": "welldot"
          },
          "value": 6.2,
          "measured_in": "field"
        },
        {
          "parameter": {
            "code": "specific_conductance",
            "vocabulary": "welldot"
          },
          "value": 205,
          "measured_in": "field"
        },
        {
          "parameter": {
            "code": "nitrate_as_n",
            "vocabulary": "welldot"
          },
          "value": 9.2,
          "measured_in": "lab",
          "method": "SMEWW 4500-NO₃⁻ E"
        },
        {
          "parameter": {
            "code": "chloride",
            "vocabulary": "welldot"
          },
          "value": 12.6,
          "measured_in": "lab",
          "method": "SMEWW 4500-Cl⁻ B"
        },
        {
          "parameter": {
            "code": "sodium",
            "vocabulary": "welldot"
          },
          "value": 7.9,
          "measured_in": "lab",
          "method": "SMEWW 3120 B"
        },
        {
          "parameter": {
            "code": "bicarbonate",
            "vocabulary": "welldot"
          },
          "value": 62,
          "measured_in": "lab",
          "method": "SMEWW 2320 B"
        },
        {
          "parameter": {
            "code": "total_coliforms",
            "vocabulary": "welldot"
          },
          "presence": false,
          "measured_in": "lab",
          "method": "SMEWW 9223 B"
        },
        {
          "parameter": {
            "code": "e_coli",
            "vocabulary": "welldot"
          },
          "presence": false,
          "measured_in": "lab",
          "method": "SMEWW 9223 B"
        }
      ]
    }
  ],
  "history_logs": [
    {
      "id": "log-01",
      "datetime": "1981-02-15T09:00:00-03:00",
      "category": "status_change",
      "status": "active",
      "description": "Poço entra em operação."
    },
    {
      "id": "log-02",
      "datetime": "2016-08-01T09:00:00-03:00",
      "category": "maintenance",
      "maintenance_type": "pump_service",
      "pump_installation_id": "pump-2016",
      "description": "Substituição do conjunto motobomba."
    },
    {
      "id": "log-03",
      "datetime": "2025-07-20T10:00:00-03:00",
      "category": "incident",
      "severity": "medium",
      "description": "Nitrato (9,2 mg/L N) próximo do limite de potabilidade (10 mg/L N); mistura com o poço P-07 em estudo.",
      "sample_ids": [
        "am-2025"
      ]
    }
  ]
}