WWTP sludge removal events (ES8130.43)
Budget rate $194/kgal is 10% below Superior's actual routine rate of $213.40/kgal.
The FY 2025-26 sewer budget for ES8130.43 is built on an assumed routine sludge-haul rate of $194/kgal — the figure cited in Trustee Uku's budget memo. The rate clustering below shows Superior Sanitation's actual routine rate across 21 ground-truth invoices is $213.40/kgal (10% higher). At the budgeted volume of 104,000 gal/year, the rate gap alone adds $2,018 to the annual cost — independent of any volume overrun. The volume side is a separate, larger issue: FY-to-date pumped volume is well above the 104,000 gal/year budget line.
2 consecutive mayor reports with no sewer content (2025-12 → 2026-01).
The mayor's monthly reports to the Board of Trustees normally describe sewer-plant activity, vendor work, and capital projects. Across 2 consecutive months covered (2025-12 through 2026-01), the mayor's report contains zero references to sewer / wwtp / sludge / Superior Sanitation / outfall / I&I — even though that window includes the largest spike in emergency sludge-removal invoices in the FY 2025-26 dataset. The reports may discuss these matters in committee or executive session, but they are not appearing in the public reports trustees rely on for budget oversight.
Reports in the silence window
- 2025-12 — Mayor's Report — December 2026 (dc_2372_mayor_report_january_12_2026)
- 2026-01 — Mayor's Report — January 2026 (dc_2466_mayor_report_february_9_2026)
DEC volume anchor unavailable.
QB is currently the only source of monthly sludge-haul volume. The DEC monthly DMR has a “Sludge removal from plant” section with fields for gallons, solid content, and volatile solids — but on every DMR spot-checked (Aug 2024, Aug 2025, Oct 2025, Nov 2025) those fields are blank, even when the disposal-site field is filled in with “Superior Sanitation.” The October 2025 DMR even shows a yellow-highlighted #REF! error in the amount cell. Without the DMR figure we cannot independently verify QB volumes; the rate-divide rows in particular are unverified. Hauler manifests from Superior Sanitation would close this gap.
Vendor rate clusters
Per-vendor $/kgal rate clusters derived from invoices where the memo states both gallons and amount and the two are mutually consistent (within 10%). Two clusters per vendor when the data supports it: a routine rate and an emergency-premium rate. Rate-divided rows in the table below use the nearest cluster for their vendor + event type rather than the global $194/kgal default.
| Vendor | Routine $/kgal | Emergency $/kgal | Samples | Notes |
|---|---|---|---|---|
| Superior Sanitation Services Inc | $213.40 | $323.39 | 21 | |
| ProSeptic LLC | $290.00 | $321.67 | 4 |
Burn-up: cumulative against FY budget
Two cumulative panels with a fitted regression line. The slope (annualized in the legend) is the empirical burn rate — what we'd need to hold for the budget to balance is <100%. Where the regression crosses the budget reference line is the projected exhaustion date. Volume cumulates by event date (LLM-attributed for 14 of 29 rows; invoice date for the rest), cost cumulates by invoice date.
Cumulative gallons hauled (by event date)
Cumulative $ billed (by invoice date)
Burn rate over time (derivative of the burn-up)
Time-varying monthly burn rate, derived as the slope of the cumulative over a 30-day rolling window (light line) plus a 90-day exponentially-weighted moving average (dark line). The dashed reference is the monthly budget. When the dark trend line sits above the budget line, FY-end exhaustion is the trajectory; when below, the budget is on track.
Monthly-equivalent volume rate (gal/mo)
Monthly-equivalent cost rate ($/mo)
2025-06 1 event · 4,980 gal · $1,610
LLM 1/1 verifiedJune 2025 shows one emergency invoice dated in-month (Invoice 75701, 4,980 gal, $1,610.40 for septic & holding tank pump on 6/26). The 14-day billing window captures three additional invoices dated in early July that operationally belong to July. June's total volume across the window (30,980 gal) is 3.6× the routine monthly budget, driven by emergency and elevated hauls in late June and early July.
- ⚑ Only 1 invoice dated in June; 3 of 4 window invoices dated in July
- ⚑ June volume 3.6× routine budget (~8,667 gal/mo)
- ⚑ DEC noncompliance report dated 2025-06-05 and compliance update 2025-06-27 suggest regulatory trigger
- ⚑ Mayor's report covers June with sewer project mentions
- ⚑ WAS data unavailable (operator reporting gap)
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Jun 26, 2025 | Invoice 75701 | emergency | emergency ●Memo explicitly states '6/26 emergency septic & holding tank pump' with event date 2025-06-26 [tc_7ec391e84d]. Contains 'emergency' keyword and explicit date reference. Rate of $323.39/kgal [tc_7ec391e84d] exceeds the $250/kgal premium threshold, consistent with unscheduled response. 4,980 gallons [tc_7ec391e84d] is a single-event volume consistent with emergency tank pumping. evidence: tc_7ec391e84d | 6/26 emergency septic & holding tank pump | 4,980 gal | ÷ vendor cluster rate | $1,610 |
2025-07 4 events · 32,000 gal · $7,269
LLM 4/4 verifiedJuly 2025 saw 4 invoices totaling $8,122.40 [tc_80799d7581] across 36,000 gallons [tc_c933c65c3a], representing 4.2× the routine monthly budget. A DEC consent order on 2025-07-02 [tc_a8bbf40e72] coincides with an emergency pump-down; an inspection on 2025-07-15 and second consent order on 2025-07-25 suggest regulatory pressure. The mayor's office did not report on sewer matters for July [tc_36a20ffb75].
- ⚑ Monthly volume 4.2× routine budget (36,000 gal vs. ~8,667 budgeted)
- ⚑ DEC consent orders on 2025-07-02 and 2025-07-25; inspection on 2025-07-15
- ⚑ No mayor report sewer mention for July despite elevated activity
- ⚑ WAS data available [tc_192f5a3c6a]: mean 785.5 min/day, suggesting sustained sludge-pumping pressure
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Jul 2, 2025 | Invoice 75203 | emergency | emergency ●Memo explicitly states '7/2/25 emergency sewer plant pump - 4000 gallons' [tc_1bd3a782d7]. The 'emergency' keyword and date reference confirm event_type. Invoice dated same day as memo event date. Actual rate is $323.4/kgal ($1,293.6 ÷ 4,000 gal [tc_02773ca4da]), well above the routine $194/kgal, consistent with premium emergency pricing. DEC consent order issued same day [tc_a8bbf40e72], suggesting a triggered regulatory response. evidence: tc_1bd3a782d7, tc_02773ca4da, tc_a8bbf40e72 | 7/2/25 emergency sewer plant pump - 4000 gallons | 4,000 gal | from memo | $1,294 |
| Jul 8, 2025 | Invoice 32585 | routine | routine ●Memo states 'WWTP sludge removal - 6,000 gal' [tc_1bd3a782d7] with no emergency keyword or date reference. Volume of 6,000 gal is within the per-haul norm. Implied rate at $194/kgal is $1,280.4 ÷ 6,000 gal = $213.4/kgal [tc_a22873042e], consistent with routine pricing. Invoice dated 2025-07-08, in the second half of the month, so attributed to July. evidence: tc_1bd3a782d7, tc_a22873042e | WWTP sludge removal - 6,000 gal | 6,000 gal | from memo | $1,280 |
| Jul 9, 2025 | Invoice 75718 | routine | elevated ●Memo states '7/9 & 7/10/25 sewer plant pump - 16,000 gallons' [tc_1bd3a782d7], a single haul spanning two days at 16,000 gal. This exceeds the per-haul norm of ~8,667 gal and qualifies as 'elevated' per the schema (>10,000 gal in one event, no emergency keyword, no premium rate). Implied rate is $3,414.4 ÷ 16,000 gal = $213.4/kgal [tc_0dc6eac1a1], consistent with routine pricing despite elevated volume. Invoice dated 2025-07-09, memo event date 2025-07-09, attributed to July. evidence: tc_1bd3a782d7, tc_0dc6eac1a1 | 7/9 & 7/10/25 sewer plant pump - 16,000 gallons | 16,000 gal | from memo | $3,414 |
| Jul 28, 2025 | 32732 | routine | routine ●Memo states '7/25/25 sewer plant pump - 6,000 gallons' [tc_1bd3a782d7] with no emergency keyword. Volume of 6,000 gal is within the per-haul norm. Implied rate is $1,280.4 ÷ 6,000 gal = $213.4/kgal, consistent with routine pricing. Invoice dated 2025-07-28, memo event date 2025-07-25, both in July; attributed to July. evidence: tc_1bd3a782d7 | 7/25/25 sewer plant pump - 6,000 gallons | 6,000 gal | from memo | $1,280 |
2025-08 4 events · 17,000 gal · $4,626
LLM 4/4 verifiedAugust 2025 saw 4 invoices totaling $5,479.40 [tc_2d9d2792d8] across 17,000 gallons [tc_33154b8915], nearly double the routine monthly budget. Two invoices explicitly carry 'emergency' keywords in their memos, and a DEC noncompliance report was issued on 2025-08-01 [tc_ea4b4cade1], suggesting operational stress during the month.
- ⚑ Monthly volume 17,000 gal vs. ~8,667 gal budget (1.96x)
- ⚑ Two emergency-flagged invoices (24040177, 75704) totaling 9,000 gal
- ⚑ DEC noncompliance report dated 2025-08-01 [tc_ea4b4cade1]
- ⚑ Mayor's report mentions WWTP expansion and wetland permitting but no emergency sewer event narrative [tc_831b75475c]
- ⚑ August precipitation 4.1 in [tc_6feac94256], within normal range; no WAS data available (outside May-Jul window)
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Aug 11, 2025 | Invoice 32783 | routine | routine ●Memo states '8/6/25 sewer plant pump - 4,000 gallons' [tc_33154b8915]. Event date 2025-08-06 is explicit. Volume 4,000 gal is well below the per-haul norm (~8,667 gal) and no emergency keyword present. Billed at $853.60, implying ~$213/kgal [tc_aa6456c979], consistent with routine Superior Sanitation Services pricing. evidence: tc_33154b8915, tc_aa6456c979 | 8/6/25 sewer plant pump - 4,000 gallons | 4,000 gal | from memo | $854 |
| Aug 18, 2025 | 24040177 | emergency | emergency ●Memo states 'emergency pump - 5,000 gallons' [tc_33154b8915], containing explicit 'emergency' keyword. Vendor is ProSeptic LLC (not routine Superior Sanitation). Invoice dated 2025-08-18 with no explicit event date in memo; billing lag heuristic places it in August (second half of month). Volume 5,000 gal is moderate; billed at $1,625, implying ~$325/kgal [tc_2399d15cfb], well above routine $194/kgal, consistent with premium emergency pricing. evidence: tc_33154b8915, tc_2399d15cfb | emergency pump - 5,000 gallons | 5,000 gal | from memo | $1,625 |
| Aug 20, 2025 | 75704 | emergency | emergency ●Memo states 'emergency pump sewer plant - 4,000 gallons' [tc_33154b8915], containing explicit 'emergency' keyword. Superior Sanitation Services invoice dated 2025-08-20 with no explicit event date; billing lag heuristic places it in August (second half). Volume 4,000 gal is moderate; billed at $1,293.60, implying ~$323/kgal [tc_02773ca4da], significantly above routine $194/kgal, consistent with emergency premium pricing. evidence: tc_33154b8915, tc_02773ca4da | emergency pump sewer plant - 4,000 gallons | 4,000 gal | from memo | $1,294 |
| Aug 28, 2025 | 75813 | unknown | routine ◐Memo states 'sludge tank - 4,000 gallons' [tc_33154b8915] with no emergency keyword or explicit event date. Invoice dated 2025-08-28 (late month, second half), suggesting August attribution. Volume 4,000 gal is routine; billed at $853.60, implying ~$213/kgal [tc_aa6456c979], consistent with standard Superior Sanitation pricing. Classified as routine despite generic memo, as no emergency signal is present. evidence: tc_33154b8915, tc_aa6456c979 | sludge tank - 4,000 gallons | 4,000 gal | from memo | $854 |
2025-09 3 events · 15,000 gal · $3,201
LLM 3/3 verifiedThree invoices totaling $3,201.00 [tc_6b66f9b238]. One routine haul (4,000 gal, carryover from August) and two emergency septic pump-downs on 2025-09-19 (7,000 + 4,000 gal). Mayor's report discusses WWTP discharge violations but does not mention the septic events.
- ⚑ Two emergency septic pump events on same date (2025-09-19) suggest triggered response, possibly related to WWTP discharge violations mentioned in mayor report
- ⚑ Invoice 32883 flagged as carryover from prior month; only 2 invoices truly belong to September
- ⚑ Mayor report mentions WWTP discharge violations (Sept. 5 meeting) but does not explain septic pump-downs
- ⚑ No DEC compliance events recorded for September
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Sep 4, 2025 | 32883 | unknown | routine ●→ 2025-08QB system flagged memo_likely_carryover=true and matched to prior event 75813 [tc_0c6e599d56]. Generic 'sludge tank' memo with no emergency keywords. 4,000 gallons at $213.4/kgal [tc_0c6e599d56] is within routine biweekly range. Invoice dated 2025-09-04 (early month) with no explicit event date suggests haul occurred in late August and was billed with standard 1-2 week lag. evidence: tc_0c6e599d56 | sludge tank - 4,000 gallons carryover | 4,000 gal | rate_divide_carryover | $854 |
| Sep 19, 2025 | 33030 | emergency | emergency ●QB flagged event_type=emergency [tc_0c6e599d56]. Memo 'old sewer plant septic pump' indicates non-routine septic pump-down, not standard WWTP sludge haul. 7,000 gallons at $213.4/kgal [tc_0c6e599d56]. Invoice dated 2025-09-19 (mid-month) with no explicit event date; billing lag heuristic suggests haul occurred in mid-September. Mayor's report [tc_ab8ac3c298] discusses WWTP discharge violations (Sept. 5 meeting) which may have triggered septic system response, though report does not explicitly mention this pump event. evidence: tc_0c6e599d56, tc_ab8ac3c298 | old sewer plant septic pump - 7,000 gallons | 7,000 gal | from memo | $1,494 |
| Sep 19, 2025 | 76186 | emergency | emergency ●QB flagged event_type=emergency [tc_0c6e599d56]. Memo 'old sewer plant septic pump' indicates non-routine septic pump-down. 4,000 gallons at $213.4/kgal [tc_0c6e599d56]. Same invoice date (2025-09-19) as 33030, suggesting coordinated or sequential pump events. No explicit event date in memo; billing lag heuristic suggests haul occurred in mid-September. Combined with 33030, represents 11,000 gallons of emergency septic pumping on same date. evidence: tc_0c6e599d56 | old sewer plant septic pump - 4,000 gallons | 4,000 gal | from memo | $854 |
2025-10 2 events · 18,000 gal · $4,399
LLM 2/2 verifiedOctober 2025 saw two emergency sludge-haul invoices totaling $4,399.20 [tc_43372b418e] and 18,000 gallons [tc_c634055b08], both dated 2025-10-15. Combined volume is 2.1× the routine monthly budget. No mayor's report sewer mention [tc_7fb9723e71] and no compliance events [tc_77ee8f91a5] in the month.
- ⚑ Both invoices dated same day (2025-10-15), both flagged 'emergency' in memo
- ⚑ Combined monthly volume 18,000 gal vs. ~8,667 gal routine budget (2.1× budget)
- ⚑ No mayor's report sewer excerpt for October despite elevated activity
- ⚑ October precipitation 4.69 in [tc_af1ae00e29]; no WAS data available (outside May-Jul window)
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Oct 15, 2025 | 24648011 | emergency | emergency ●Memo explicitly states '10/15/25 emergency pump' [tc_b988a709e7], establishing both the event date and emergency character. Vendor ProSeptic LLC, 5,000 gallons at implied rate $325/kgal [tc_0bdad3d412], well above the routine ~$194/kgal threshold, confirming premium emergency pricing. evidence: tc_b988a709e7, tc_0bdad3d412 | 10/15/25 emergency pump - 5,000 gallons | 5,000 gal | from memo | $1,625 |
| Oct 15, 2025 | 33079 | emergency | emergency ●Memo states '10/15 & 10/16 old sewer plant septic pump' [tc_b988a709e7], explicitly referencing the event dates and the 'old sewer plant septic pump' operation (emergency context). Vendor Superior Sanitation Services Inc, 13,000 gallons at implied rate $213.4/kgal [tc_0bdad3d412], above routine rate and consistent with emergency response. Combined with the same-day ProSeptic invoice, suggests a coordinated emergency response event. evidence: tc_b988a709e7, tc_0bdad3d412 | 10/15 & 10/16 old sewer plant septic pump - 13,000 gallons | 13,000 gal | from memo | $2,774 |
2025-11 2 events · 25,000 gal · $6,654
LLM 2/2 verifiedNovember 2025 shows two invoices dated in-month totaling $6,654.20 across 25,000 gallons. Both hauls exceed the routine biweekly norm (8,667 gal/mo budget), with one explicitly marked emergency and the other unmarked but elevated. A DEC notice of violation was issued on 2025-11-01, and the mayor's report mentions only septic-system funding, not WWTP operations.
- ⚑ Two invoices both dated 2025-11-21, both from Superior Sanitation Services
- ⚑ Invoice 33095 (10/20/25 event) is stale-dated carryover from October; attributed to 2025-10
- ⚑ Invoice 33180 (11/7/25 event) is elevated single-haul (13,000 gal) at $213.4/kgal, no emergency keyword
- ⚑ Combined November-attributed volume (13,000 gal) is 1.5x the monthly budget
- ⚑ DEC notice of violation issued 2025-11-01; no mayor-report sewer narrative for November
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Nov 21, 2025 | 33095 | emergency | emergency ●→ 2025-10Memo explicitly states '10/20/25 emergency sewer plant pump' [tc_ac6a67ba2f]. The event date is 2025-10-20, making this a carryover from October despite invoice date of 2025-11-21. The memo contains 'emergency' keyword and the haul volume (12,000 gal) exceeds routine norm. Actual rate charged is $323.33/kgal [tc_d62de494ee], well above the $194/kgal routine rate, confirming premium emergency pricing. evidence: tc_ac6a67ba2f, tc_d62de494ee | 10/20/25 emergency sewer plant pump - 12,000 gallons stale date | 12,000 gal | from memo | $3,880 |
| Nov 21, 2025 | 33180 | unknown | elevated ●Memo states '11/7/25 pump sewer plant - 13,000 gallons' [tc_ac6a67ba2f], placing the event in November 2025. The haul volume (13,000 gal) materially exceeds the per-haul routine norm (~8,667 gal/mo ÷ 2 ≈ 4,300 gal per biweekly haul) and is a single elevated event, not an emergency. No emergency keyword appears in the memo. The rate charged is $213.4/kgal [tc_a23ecc0837], above routine but below the $250/kgal emergency threshold, consistent with elevated scheduled haul pricing. evidence: tc_ac6a67ba2f, tc_a23ecc0837 | 11/7/25 pump sewer plant - 13,000 gallons | 13,000 gal | from memo | $2,774 |
2025-12 4 events · 33,000 gal · $10,005
LLM 4/4 verifiedDecember 2025 saw four invoices dated in-month totaling $7,004.60 [tc_90a3fd2eef], with an extended 14-day billing window capturing eight rows and $16,922.40 [tc_7e9aeded7d]. All four December-dated invoices are classified as emergency events, with memos explicitly stating 'emergency pump' and event dates of 12/4, 12/10, 12/12, and 12/12. The month accumulated 56,000 gallons [tc_b0dcfce4ab]—6.5× the routine monthly budget—driven entirely by emergency pumping. A NYSDEC inspection occurred on 2025-12-16 [tc_9ab782c530], and the mayor's report for December contains no sewer-related excerpts [tc_112430524f].
- ⚑ All four December-dated invoices classified as emergency; no routine hauls
- ⚑ Monthly volume 56,000 gal [tc_b0dcfce4ab] is 6.5× the ~8,667 gal routine budget
- ⚑ NYSDEC inspection on 2025-12-16 [tc_9ab782c530] occurred mid-month during emergency response period
- ⚑ Mayor's report for December contains zero sewer-related excerpts [tc_112430524f], despite major operational event
- ⚑ Extended billing window (through 2026-01-14) captures additional emergency hauls dated 2026-01-03 and 2026-01-05, suggesting cascade of emergency events
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Dec 4, 2025 | 33300 | emergency | emergency ●Memo explicitly states 'emergency pump sewer plant - 5,000 gallons' [tc_90a3fd2eef]. Invoice dated 2025-12-04 with no explicit event date in memo; the 'emergency' keyword and 5,000 gal volume (below single-haul elevated threshold but in emergency context) confirm emergency classification. Attributed to 2025-12 based on invoice date and emergency keyword. evidence: tc_90a3fd2eef | emergency pump sewer plant - 5,000 gallons | 5,000 gal | from memo | $1,617 |
| Dec 10, 2025 | 33335 | unknown | emergency ◐Memo states 'pump sewer plant - 5,000 gallons' with no explicit 'emergency' keyword [tc_90a3fd2eef]. However, the invoice is dated 2025-12-10, six days after the first emergency pump (2025-12-04), and the 5,000 gal volume in rapid succession suggests a follow-up emergency response rather than routine biweekly haul. The pattern of multiple hauls within days, combined with the prior emergency event, supports emergency classification. Attributed to 2025-12 based on invoice date. evidence: tc_90a3fd2eef | pump sewer plant - 5,000 gallons | 5,000 gal | from memo | $1,067 |
| Dec 12, 2025 | 26210672 | emergency | emergency ●Memo explicitly states 'emergency pump - 14,000 gallons -12/12/25' [tc_90a3fd2eef]. The memo includes an explicit event date (2025-12-12), and the 14,000 gal volume is materially elevated (>10,000 gal), confirming emergency classification. Attributed to 2025-12 based on memo event date. evidence: tc_90a3fd2eef | emergency pump - 14,000 gallons -12/12/25 | 14,000 gal | from memo | $4,410 |
| Dec 12, 2025 | 33339 | emergency | emergency ●Memo explicitly states '12/12 &12/13 emergency sewer plant pump - 9,000 gallons' [tc_90a3fd2eef]. The memo includes explicit event dates (2025-12-12 and 2025-12-13), and the 'emergency' keyword confirms classification. The 9,000 gal volume is elevated in context of emergency response. Attributed to 2025-12 based on memo event dates. evidence: tc_90a3fd2eef | 12/12 &12/13 emergency sewer plant pump - 9,000 gallons | 9,000 gal | from memo | $2,911 |
2026-01 5 events · 27,500 gal · $7,878
LLM 5/5 verifiedJanuary 2026 saw 5 invoices dated in-month totaling $9,917.80 (excluding the 14-day window additions), driven by two emergency pump-downs on 2026-01-03 (ProSeptic 6,000 gal + Superior 12,500 gal) plus three routine/unclear small hauls. The 14-day billing window captures 7 rows totaling $10,118.80 [tc_511d3abec4]. No mayor's report sewer content and no DEC compliance events in January.
- ⚑ Two emergency events on same day (2026-01-03): ProSeptic emergency pump (6,000 gal) + Superior emergency EQ pump (12,500 gal) = 18,500 gal in one day, ~2.1x monthly budget
- ⚑ Mayor's report for January contains no sewer-related excerpts [tc_26f51c9e35], despite significant emergency activity
- ⚑ Three invoices with ambiguous memos ('pump sewer plant 1A', 'WTTP pump') lack explicit event dates; classified as unknown event_type pending clarification
- ⚑ One invoice (2026-02-11, invoice 77050) has no memo and rate-derived gallons; attributed to February but included in 14-day window
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Jan 3, 2026 | 26358856 | fee | fee ●Flat truck fee for same-day emergency response, $175 [tc_4b49353878]. No volume; classified as fee per schema. evidence: tc_4b49353878 | truck fee for same day emergency | — | flat fee | $175 |
| Jan 3, 2026 | 26358856 | emergency | fee ●Flat truck fee for same-day emergency response, $175 [tc_4b49353878]. No volume; classified as fee per schema. evidence: tc_4b49353878 | emergency pump - 6,000 gallons -1/3/26 | 6,000 gal | from memo | $1,740 |
| Jan 3, 2026 | 76725 | emergency | emergency ●Superior Sanitation emergency septic pump EQ 1A [tc_4b49353878], 12,500 gallons, $4,042.50. Memo contains 'emergency' keyword and references EQ (equalization) pump-down. Rate ~$323/kgal (4042.5/12.5) well above $250 threshold. No explicit event date in memo, but invoice date 2026-01-03 and same-day fee suggest this occurred on 2026-01-03. evidence: tc_4b49353878 | emergency septic pump EQ 1A - 12.5 gallons | 12,500 gal | from memo | $4,043 |
| Jan 5, 2026 | 76833 | unknown | unknown ○Superior Sanitation invoice dated 2026-01-05 [tc_4b49353878], memo 'pump sewer plant 1A 4.5 gallons' (4,500 gal), $960.30. Memo lacks explicit event date and 'emergency' keyword. Rate ~$213/kgal is consistent with routine (~$194/kgal) but memo is ambiguous ('1A' designation unclear). Attributed to January based on invoice date in first half of month. evidence: tc_4b49353878 | pump sewer plant 1A 4.5 gallons | 4,500 gal | from memo | $960 |
| Jan 15, 2026 | 75502 | unknown | unknown ○Superior Sanitation invoice dated 2026-01-15 [tc_4b49353878], memo 'WTTP pump 4.5 gal' (4,500 gal), $960.30. Memo lacks explicit event date and emergency keyword. Rate ~$213/kgal is near-routine. Memo is terse and does not clearly indicate whether this is a scheduled haul or response event. Attributed to January based on invoice date. evidence: tc_4b49353878 | WTTP pump 4.5 gal | 4,500 gal | from memo | $960 |
2026-02 3 events · 26,500 gal · $7,415
LLM 4/4 verifiedFebruary 2026 saw 3 invoices dated in-month totaling $7,414.70 across 26,500 gallons—nearly 3× the routine monthly budget. A NYSDEC NOV was issued on 2026-02-26 [tc_8e7291afa7], the same day as a large emergency septic pump-down (16,000 gal, $5,174). A fourth invoice (33636) dated 2026-03-03 belongs to the 14-day billing window and likely represents a partial credit or adjustment to the emergency event.
- ⚑ Monthly volume 3× routine budget (26,500 gal vs. ~8,667 budgeted)
- ⚑ Emergency event on 2026-02-26 coincides with NYSDEC NOV issuance
- ⚑ Invoice 77050 lacks memo; volume inferred from rate_divide at $213.4/kgal
- ⚑ Invoice 33636 (2026-03-03) shows memo/amount inconsistency (memo claims 16,000 gal but only 1,320 gal billed)
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Feb 5, 2026 | 77028 | unknown | routine ●Memo explicitly states 'WTTP pump 4500 gallons' [tc_335368380d]. Volume of 4,500 gal is well within routine per-haul norm (≤8,667 gal). No emergency keywords. Billed at ~$213/kgal, consistent with standard rate. Invoice dated 2026-02-05 in first half of month; memo provides explicit event date context. evidence: tc_335368380d | WTTP pump 4500 gallons | 4,500 gal | from memo | $960 |
| Feb 11, 2026 | 77050 | unknown | routine ◐No memo provided [tc_335368380d]. Volume of 6,000 gal inferred from rate_divide at $213.4/kgal [tc_6347346f84], consistent with standard billing rate. Single haul volume is within routine per-haul norm. Invoice dated 2026-02-11 in first half of month suggests same-month event. Absence of memo and emergency keywords supports routine classification, though lack of explicit event date reduces confidence. evidence: tc_335368380d, tc_6347346f84 | (empty) | 6,000 gal | ÷ vendor rate (no memo) | $1,280 |
| Feb 26, 2026 | 77084 | emergency | emergency ●Memo explicitly states 'Emergency WWTP Septic Pumps -1A & 1B 16,000 gallons @ $323.40/gallon' [tc_335368380d]. Contains 'Emergency' keyword and premium rate of $323.40/kgal (well above standard ~$194/kgal), both strong indicators of unscheduled response. Volume of 16,000 gal is materially elevated (>10,000 gal). Invoice dated 2026-02-26 coincides with NYSDEC NOV issued same day [tc_8e7291afa7], confirming triggered event. Memo provides explicit event context. evidence: tc_335368380d, tc_8e7291afa7 | Emergency WWTP Septic Pumps -1A & 1B 16,000 gallons @ $323.40/gallon | 16,000 gal | from memo | $5,174 |
2026-03 1 event · 1,320 gal · $427
LLM 1/1 verifiedMarch 2026 contains one emergency sludge-haul invoice dated 2026-03-03 for $426.80. The invoice memo claims 16,000 gallons at an emergency rate of $323.40/kgal, but the actual billed amount implies only ~1,320 gallons [tc_f797d28cb4], indicating a significant data inconsistency in the vendor's billing.
- ⚑ Single invoice with memo/amount mismatch: memo states 16,000 gal but $426.80 implies only 1,320 gal at stated rate
- ⚑ Emergency keyword present ('Emergency Pump WWTP Septic Pumps') with premium rate ($323.40/kgal >> $194/kgal budget)
- ⚑ No mayor report for March 2026 [tc_a06588ab8d]; no regulatory compliance events [tc_fd42cdb4f1]
- ⚑ DEC operating data unavailable for March 2026 [tc_db68efa2bb]
| Date | Invoice | Memo type | LLM classification | Memo | Gallons | Volume source | $ amount |
|---|---|---|---|---|---|---|---|
| Mar 3, 2026 | 33636 | emergency | emergency ◐→ 2026-02Invoice dated 2026-03-03, outside the Feb 1-28 window but within the 14-day billing lag [tc_064da2be33]. Memo states 'Emergency Pump WWTP Septic Pumps -1A & 1B -16,000 gallons @ $323.40/gallon' but amount billed ($426.80) implies only 1,320 gal at $323.4/kgal, not 16,000 gal. This inconsistency suggests a partial credit or adjustment to the 2026-02-26 emergency event (invoice 77084). The 'Emergency' keyword and premium rate support emergency classification. Negative sign in memo ('-16,000 gallons') may indicate a reversal or credit. Attributed to Feb based on billing-lag heuristic and apparent linkage to the 2026-02-26 NOV event. evidence: tc_064da2be33 | Emergency Pump WWTP Septic Pumps -1A & 1B -16,000 gallons @ $323.40/gallon memo math fails | 1,320 gal | ÷ vendor rate (memo bad) | $427 |
About the LLM-classification column.Each invoice is independently classified by an LLM with access to deterministic tools (sum/divide, DEC ops in window, mayor-report excerpts, compliance events). Every numeric claim in a justification cites a tool-call result_id; a validation pass rejects justifications whose citations don't exist in the trace. The “LLM N/M verified” badge shows pass count per month. Click a classification to see the justification + evidence chain. The arrow notation (e.g. → 2025-10) means the LLM attributed the haul to a different month than the invoice date — typically because the memo cites an explicit event date in the prior month.