MaterialManagementRouteBasedRecord

Introduction
One row of the route-based material management data: the material spread while crossing the zones of a route, summed over every crossing in the date range, or the sum of those route rows over a route group. The rows follow the route-based Material Management report: a zone on several routes counts in full on each of them, so a route group holding two of those routes counts the zone twice.
The material measures come from the stored segment material aggregates. As in the report, the total time and total distance are those driven inside the route's zones: the summed duration and distance of the service group's in-zone travel events (the report's TravelTime). They do not cover time spent stopped in a zone, so the total time can be less than the spread time. The plow measures are not recorded yet and are always null. A route nothing crossed has a row whose measures are all null; a route with no zones has no row.
A route or route group has one row unless its zones saw more than one type of a material. It then has as many rows as the material with the most types, each holding one type of each material, so that every type has its own total and rate. The row's own fields (MaterialManagementRouteBasedRecord.primary, MaterialManagementRouteBasedRecord.routeId, MaterialManagementRouteBasedRecord.routeGroupId and the total distance and time) repeat in each of its rows, so do not add them up across rows. The spread distances and times of the rows of one route or route group add up to those of its solid material.
Rows do not repeat the service group, which is a request input. Identity columns that do not apply to the view are null.
Properties

antiIceRate

The distance-weighted average rate the spreader controller reported for anti-ice (liquid) material, in litres per kilometre.

antiIceRateDistance

antiIceTotal

The total anti-ice (liquid) material spread, in litres.

deviceId

The asset identity column. It is always null in the supported Route and Route Group views.

plowDistance

The distance driven with the plow active, in kilometres.
The stored material aggregates do not record plow activity yet, so this is always null.

plowTime

The time spent with the plow active.
The stored material aggregates do not record plow activity yet, so this is always null.

preWetRate

The distance-weighted average rate the spreader controller reported for pre-wet material, in litres per tonne of solid material.

preWetRateDistance

preWetTotal

The total pre-wet material spread, in litres.

primary

The value the row is grouped by: the route id in the Route view, and the route group id in the RouteGroup view, where the row for the routes in no route group has none.

routeGroupId

The id of the route group: the group the route sits under in the Route view, and the row's own group in the RouteGroup view.

routeId

The id of the route, in the Route view.

solidRate

The distance-weighted average rate the spreader controller reported for solid material, in kilograms per kilometre.

solidRateDistance

The distance MaterialManagementMeasures.solidRate was averaged over, in kilometres. To average rates across rows, weight each row's rate by this distance: the sum of rate times rate distance divided by the sum of rate distances.
Until the stored aggregates record the distance their own rate was averaged over, the spread distance of the aggregates that reported a rate stands in for it. It equals that distance whenever the controller reported a rate throughout the application.

solidTotal

The total solid material spread, in grams.

spreadDistance

The distance driven while applying the row's solid material type, in kilometres. The spread distances of the rows of one trip add up to the distance driven while applying solid material during it.

spreadTime

The time spent applying the row's solid material type. The spread times of the rows of one trip add up to the time spent applying solid material during it.

totalDistance

The total distance of the row, in kilometres.

totalTime

The total time of the row.

Loading API Runner...