ODRC data schema: Feed aggregation

This is a data schema created using Agri-food Data Canada's Semantic Engine . Data schemas describe data that are collected on an ongoing basis from research centres, and provide add-on documentation that enhances the value of raw data. This schema is applicable to all datasets collecting aggregated daily feed intakes data for animals fed at the maternity & tie stalls and from Insentec bins. Daily intakes for Insentec data is the sum of all positive intakes per animal per day using data from the Insentec (FR) table (Insentec data from VR files with end weight and intake fixed). Fixing strategy: If start weight of the following visit is equal (cow didn't eat) or smaller than the current visit's start weight (cow ate) and the following visit's start weight is different than the current visit's end weight, then the current visit's end weight is replaced with the start weight of the following visit. These conditions are applied with data grouped by date and bin and sorted ascending by start time. Limitation: Because data is grouped by date, if the last visit of a day registered an incorrect weight to a bin, it will not be corrected with the first visit of the following day of such bin. Additionally, if the start weight of the following visit is greater than the start weight of the current visit, then nothing is done since supplement/more feed could have been added to the bin between visits or the scale was really broken. Further inspection to the data is recommended. Data described in this schema is sample data, to request access to the related data, please visit the Ontario Dairy Research Centre Data Portal.