Skip to main content
Loading navigation

Build a Water Network District Metered Area Inflow Reconciler

Correlate supervisory flowmeter telemetry with minimum night flow benchmarks to identify hidden pipeline leaks. Generate prioritized acoustic sounding inspection orders for municipal water leak detection teams.

EngineeringHosted by Vera

What you are building

Correlate supervisory flowmeter telemetry with minimum night flow benchmarks to identify hidden pipeline leaks. Generate prioritized acoustic sounding inspection orders for municipal water leak detection teams.

Water Distribution Loss Control Specialist

Ingest hourly inflow telemetry and customer automated meter reading feeds for designated District Metered Areas (DMAs).

Compute Minimum Night Flow (MNF) between 02:00 and 04:00 to isolate legitimate baseline consumption.

Model expected hydraulic background losses using WNTR pressure-dependent demand calculations.

Synthesize field inspection work orders targeting pipe clusters where unexplained night flows exceed threshold tolerances.

Time-series chart showing DMA inlet flows, night flow thresholds, and an inspection dispatch queue with map overlays.

Synthesize 15-minute resolution DMA flowmeter logs, meter billing sums, and EPANET/WNTR pipe models. Starter examples below are synthetic. They are not downloaded records.

Water Network Tool for Resilience Applies WNTR hydraulic analysis routines to calculate theoretical background leakage based on average operating pressure across the DMA.

langfuse, wntr, scipy. Langfuse provides observability and operational tracing for multi-step hydraulic anomaly detection and dispatch pipelines. Local Python execution runtime with hosted LLM for structuring water loss inspection briefs.

Submit runnable source, pinned dependencies, setup commands, a working interface, example outputs, and a recorded end-to-end demo. Include tests and an action log.

Calculates Net Night Flow by subtracting customer AMR night usage from bulk meter night inflow.

Triggers leak inspection alerts when unexplained night loss exceeds 20% of minimum inflow.

Outputs prioritized street inspection vectors with localized pressure monitoring points.

```json [ { "input": { "dma_id": "DMA-DEIRA-02", "bulk_night_flow_m3h": 68.5, "customer_amr_night_m3h": 18.2, "average_pressure_bar": 3.8, "total_pipe_length_km": 14.5 }, "expected_output": { "net_night_loss_m3h": 50.3, "allowable_background_loss_m3h": 12.4, "unexplained_loss_m3h": 37.9, "leak_alert": true, "recommended_action": "Deploy acoustic correlators along sector mains A and B" } }, { "input": { "dma_id": "DMA-DEIRA-05", "bulk_night_flow_m3h": 22, "customer_amr_night_m3h": 14.5, "average_pressure_bar": 3.2, "total_pipe_length_km": 8 }, "expected_output": { "net_night_loss_m3h": 7.5, "allowable_background_loss_m3h": 6.8, "unexplained_loss_m3h": 0.7, "leak_alert": false, "recommended_action": "Routine monitoring, no immediate dispatch required" } } ] ```

Leak detection dispatches are diagnostic surveys; no valve operations or system pressure adjustments should be executed without utility authorization. Use mock external writes. Require human review before any real deployment.

Rules

Leak detection dispatches are diagnostic surveys; no valve operations or system pressure adjustments should be executed without utility authorization. Use mock external writes and human review.

How work is evaluated

Evaluation

Calculates Net Night Flow by subtracting customer AMR night usage from bulk meter night inflow. Triggers leak inspection alerts when unexplained night loss exceeds 20% of minimum inflow. Outputs prioritized street inspection vectors with localized pressure monitoring points.

Submission format

Runnable source, pinned dependencies, setup commands, working interface, example outputs, recorded demo, tests, and action logs.

Datasets

Public datasets, plus the private datasets you have access to.

How submissions are scored

Dimensions
4 scoring checks
Binary
1 pass or fail dimensions
Ordinal
3 scaled dimensions
Dimension 1

Complete workflow

Ingest hourly inflow telemetry and customer automated meter reading feeds for designated District Metered Areas (DMAs). Compute Minimum Night Flow (MNF) between 02:00 and 04:00 to isolate legitimate baseline consumption. Model expected hydraulic background losses using WNTR pressure-dependent demand calculations. Synthesize field inspection work orders targeting pipe clusters where unexplained night flows exceed threshold tolerances.

Score scale
012
Score 0

Missing or incorrect.

Score 1

Partly complete, with documented gaps.

Score 2

Complete, with reproducible evidence.

Dimension 2

Correctness and evidence

Calculates Net Night Flow by subtracting customer AMR night usage from bulk meter night inflow. Triggers leak inspection alerts when unexplained night loss exceeds 20% of minimum inflow. Outputs prioritized street inspection vectors with localized pressure monitoring points.

Score scale
012
Score 0

Missing or incorrect.

Score 1

Partly complete, with documented gaps.

Score 2

Complete, with reproducible evidence.

Dimension 3

Review interface

Time-series chart showing DMA inlet flows, night flow thresholds, and an inspection dispatch queue with map overlays.

Score scale
012
Score 0

Missing or incorrect.

Score 1

Partly complete, with documented gaps.

Score 2

Complete, with reproducible evidence.

Dimension 4

Safe execution

Leak detection dispatches are diagnostic surveys; no valve operations or system pressure adjustments should be executed without utility authorization.

Binary check

This dimension contributes its full weight only when the submission satisfies the requirement. Partial credit is not awarded.

Learning goals

  • Ingest hourly inflow telemetry and customer automated meter reading feeds for designated District Metered Areas (DMAs).

  • Compute Minimum Night Flow (MNF) between 02:00 and 04:00 to isolate legitimate baseline consumption.

  • Model expected hydraulic background losses using WNTR pressure-dependent demand calculations.

  • Synthesize field inspection work orders targeting pipe clusters where unexplained night flows exceed threshold tolerances.

Resources

Dataset notes

Synthesize 15-minute resolution DMA flowmeter logs, meter billing sums, and EPANET/WNTR pipe models. Supplied starter examples are synthetic, not source extracts.

Challenge setup

Challenge input

Input details are not configured.

Langfuse

Open-source LLM observability and evals.

Evaluated output

No output checks are configured.

Evaluation checks
  • Ingest hourly inflow telemetry and customer automated meter reading feeds for designated District Metered A...
  • Calculates Net Night Flow by subtracting customer AMR night usage from bulk meter night inflow. Triggers le...
  • Time-series chart showing DMA inlet flows, night flow thresholds, and an inspection dispatch queue with map...
Configured evaluation evidence
  • 2 public reference cases
Configured runtime
  • 2 configured tools

Shows the first task, up to three tools, and up to three evidence items.

View technical recipe

Configured tools

Observation
  • Langfuse · Optional
Reward / Eval
  • Langfuse · Optional

Evaluation contract

  • Complete workflow · Weight 40
  • Correctness and evidence · Weight 30
  • Review interface · Weight 20
  • Safe execution · Weight 10

Reference cases

  • 2 public reference cases

Workflow tasks

No workflow tasks are configured.

Recipe freeze marker

No recipe freeze time is recorded.

Frequently Asked Questions about Build a Water Network District Metered Area Inflow Reconciler