Open data on public expenditure — datasets, categories and a SPARQL endpoint for research and analysis

Pool Heating Fuel Spending in Massachusetts and Australia

A heated public pool is one of the least glamorous and most reliable pieces of infrastructure a government pays for. Water enters at the top of a filtration plant at around 28 degrees Celsius, meets the air, and begins losing heat immediately. The state of Massachusetts runs several such facilities through its Department of Conservation and Recreation, whose properties include the Mass Commonwealth Pool building on Boylston Street in Boston and Buckley Pool in West Roxbury, alongside a network of outdoor pools at state reservations and pond beaches.

For decades, the money that keeps those basins warm was invisible to anyone outside the finance office. Cheque-book payment records do show it — thousands of individual transactions for heating oil, natural gas and propane, filed under a supplier's name, spread across a fiscal year that runs from July to June — but nobody assembled them into a single picture of how much the Commonwealth spends to hold a temperature. That assembly is exactly the kind of work the datasets published by PublicSpending.net are built for, and the same machinery now covers Australian and other jurisdictions.

The subject should interest Australian readers for a specific reason. Australian councils face the identical arithmetic: an aquatic centre that is free to enter, or cheap to enter, still has to buy every megajoule it burns, and the difference between a thriving centre and a closed one is often written in fuel invoices. The comparison is instructive because the ownership structures differ. Most Australian pools sit with a local government, a not-for-profit operator or a leisure trust. In Massachusetts, a large share of swimming infrastructure belongs to municipalities, with the state department acting as licensor, trainer and — in a handful of cases — owner and operator.

What follows looks at how Massachusetts fuel payments are recorded, why heated water is such a stubborn operating cost, how those records line up with Australian council budgets, and where the underlying data can be queried directly.

What the payment records actually show

The raw material is not a purpose-built dataset but a stream of accounts payable transactions. Each entry carries a payee, a date, an amount, a payment mechanism and a classification code. Massachusetts state expenditure records also include a descriptor for the nature of the purchase, which is what allows a fuel delivery to be separated from a plumbing invoice or a lifeguard's wage.

Three filters do most of the analytical work. The first is the agency: payments attributed to the Department of Conservation and Recreation can be isolated from the rest of the Commonwealth's spending. The second is the commodity, using the fuel and utilities object classes alongside the mapping of suppliers to industry codes such as petroleum merchant wholesaling or natural gas distribution. The third is the calendar window, and this is where the Massachusetts fiscal calendar creates genuine difficulty for anyone trying to read seasonality in the data.

Heating purchases cluster between October and March, which means they straddle the July-to-June fiscal year. A single winter is split across two reporting years, and a naive annual comparison can flatter or penalise a year depending on where the cut falls. Add to that the timing of delivery payments, which sometimes land weeks after the tanker has left the depot, and the result is a series that must be read as spending, not as consumption.

Why heated water is an energy line, not a comfort extra

Swimming pools in Massachusetts are heated. The target sits somewhere between 80 and 86 degrees Fahrenheit — roughly 27 to 30 degrees Celsius — which is close to the temperature at which many Australian general-purpose pools are run, though the comparison stops there. Heat leaves a pool through evaporation, conduction into the surrounding air, and the warm exhaust every pump and filter draws in to keep the room ventilated.

Evaporation dominates. A crowded lane with a moving air handler above it can lose water at a startling rate, and replacing that water at temperature is what turns a modest energy budget into a substantial one. A heated indoor pool is effectively an energy consumer that happens to sell a service at the door, and the cost per visit can exceed the entry fee in a building that is genuinely busy.

Fuel arrives in three broad forms. Heating oil delivered by tanker has long been the New England default for smaller facilities. Natural gas, often liquefied and trucked to site, serves larger pools with dedicated boilers. Propane fills the gaps for rural sites off the mains. Each of those arrives in a bulk delivery that lands as a single large payment rather than a series of small meter-based bills, which is precisely why the underlying data can look erratic month to month and why the annual aggregate matters more than any individual entry.

The point worth holding onto is that fuel is not the only energy line. The same building appears in the electricity accounts for pumps, lighting and dehumidification, in the water and sewer charges, and in the chemicals budget. Isolating the fuel purchase tells you how the heating bill moves; it does not tell you what a swim costs the state.

The Australian parallel: councils, coast and cold water swims

Australians have a distinctive relationship with public swimming. The tradition runs from the saltwater ocean pools of Sydney's eastern beaches to the heated centres of Melbourne and Brisbane, and it carries its own calendar. The Australia Day ocean swim on 26 January has become a fixed cultural marker in coastal cities, as have the Christmas and New Year swims that draw thousands into the water in Sydney, Melbourne and Perth.

Against that backdrop, the ownership question is sharper here than in Massachusetts. The City of Logan in South East Queensland is a fair illustration of the Australian pattern: a growing council running aquatic centres, gymnasiums and programmes through a council-owned leisure company, with heating fuel contracted and paid for inside a budget line that ratepayers scrutinise at every budget cycle. Melbourne's state-run Melbourne Sports and Aquatic Centre in Albert Park plays a role closer to the Massachusetts Department of Conservation and Recreation, hosting competitive swimming and keeping large volumes of water at temperature all year.

Sydney supplies the sharpest contrast. The Domain's heated pool and the saltwater pools at Coogee and Bronte sit within a few kilometres of each other and produce entirely different fuel invoices, because one must be heated and the other must not. The gap between them is the gap between a service the government prices and a service the climate provides. Any comparison of heating expenditure across jurisdictions has to control for that choice, otherwise a state with more heated water looks like a state with worse cost control.

Local realities also complicate the numbers in ways worth naming. Regional Queensland and northern New South Wales centres often heat with liquefied natural gas delivered by road tanker, the same delivery model as Massachusetts, and inherit the same exposure to fuel price volatility. Australian councils publish their accounts under a national revenue and services reporting framework, which gives operating costs by activity, but the accounting tends to aggregate gas, electricity and water into a single utilities line. Massachusetts payment-level detail is finer than what most Australian councils release.

Reading Massachusetts fuel data against Australian benchmarks

Comparisons across currencies and systems fail in predictable ways, and most published comparisons fail in the same predictable ways. The first step is to convert at a dated exchange rate rather than a current one, because the Australian dollar has moved enough against the US dollar in recent years to distort a multi-year series on its own. The second is to choose a denominator. Cost per visit is the most meaningful for a council defending an entry fee. Cost per lane-kilometre makes sense for competitive swimming. Cost per heated litre is the hardest to source on either side of the Pacific and probably not worth the effort.

Per-visit figures also require caution in both countries. Attendance data is rarely published at the same granularity as payment data, and estimates built on a pool's opening hours and typical occupancy can differ from reality by a factor of two. Where a direct comparison is impossible, the more defensible approach is structural: how does the fuel line move against the rest of the operating budget, and does the pattern match the heating season?

A third trap involves inflation. Massachusetts records span years in which energy prices swung violently, so a nominal total over five years says little without a deflator. Australian council budgets suffer the same distortion, particularly for centres that buy gas under fixed multi-year arrangements negotiated in a different price environment.

Contracting, outsourcing and who carries the risk

Fuel procurement for large public facilities is usually bought on contract rather than at the pump, and the choice of contract shape decides who absorbs a price spike. A fixed-price bulk supply agreement protects the budget and transfers risk to the supplier. A spot purchase exposes the agency to the market in the months when the market is tightest. Massachusetts agencies buy through state procurement arrangements, which is one reason their fuel payments appear as large periodic entries tied to a contracted supplier rather than as dozens of small transactions.

The deeper question is who runs the facility at all, and the answer has moved steadily in one direction. Pool operations, lifeguard services, plant maintenance and even fuel supply have all been shifted from in-house public employment to contracted operators in a number of jurisdictions. Publicspending.net's analysis of UK service outsourcing sets out how far that shift has travelled and what the spending records reveal about the value delivered. Australian councils have followed the same path with leisure trusts, YMCA and YWCA partnerships, and large aquatic operators managing centres on the council's behalf.

The consequence for fuel expenditure is worth tracing. When a council outsources the running of a centre under a management agreement, the fuel purchase typically stays with the operator and disappears from the council's accounts, reappearing only as a fee in the contract line. The heating cost has not vanished; it has moved. Any cross-jurisdiction comparison that reads one country's published payments against another's contracted fees will reach a false conclusion, and that mistake is easy to make precisely because the underlying volume of heated water is unchanged.

Where the data lives and how to interrogate it

PublicSpending.net publishes datasets, tables, statistics, graphs and bulk downloads assembled from public payment records across several countries, including Australia, Greece, the United Kingdom and the United States, with coverage of federal, state, municipal and territorial bodies in the United States, and datasets for Chicago, Massachusetts and Alaska. Alongside the static downloads sit a SPARQL endpoint and ontology-based tools that allow the records to be treated as linked data rather than as flattened spreadsheets.

That structure changes what a researcher can attempt. Filtering Massachusetts expenditure by agency, by fuel commodity and by month, then aggregating by supplier, is a query rather than a spreadsheet exercise. The ontology layer allows the same suppliers to be recognised across jurisdictions that use different classification systems, which is what makes a genuine comparison with Australian council data possible instead of two parallel datasets that never quite meet.

Data quality still imposes limits. Payment records are what the payer recorded, not what the facility consumed; duplicate and amended entries occur; supplier names change with mergers and acquisitions; and the absence of a payment is not evidence that nothing was bought. The most useful habit is to corroborate a pattern against an independent source — a council's audited financial statements, a state parks annual report, a tender document — before drawing a conclusion from the ledger alone.

Take the ledger to your own council

Pulling the Massachusetts Department of Conservation and Recreation fuel records is a straightforward exercise: filter the expenditure data by agency, isolate the fuel and utilities object classes, and total the payments across a heating season, then run the same filter for a summer half-year as a comparison. From there, the more valuable step is to build the equivalent figure for an Australian council — through the annual statement, the revenue and services return, or an information request to the finance team — and set the two side by side.

A second pass is worth making as well: identify whether a heating figure in your own jurisdiction sits inside a published budget line or inside a management contract, and adjust accordingly. That single adjustment explains more cross-border discrepancies than currency conversion ever will.

PublicSpending.net is independent and self-funded, which means the datasets are updated when the underlying records are, not on a commercial schedule. Researchers and ratepayers can subscribe to the datasets they care about, download bulk files for local analysis, or contribute records from jurisdictions the initiative has not yet reached. If your council's aquatic centre runs on gas or heating oil, its fuel payments belong in that ledger, and adding them strengthens every comparison drawn from it.