Home > Research > Publications & Outputs > Compatibility between livestock databases used ...

Associated organisational unit

Links

Text available via DOI:

View graph of relations

Compatibility between livestock databases used for quantitative biosecurity response in New Zealand

Research output: Contribution to Journal/MagazineJournal articlepeer-review

Published

Standard

Compatibility between livestock databases used for quantitative biosecurity response in New Zealand. / Jewell, Christopher Parry; van Andel, Mary; Vink, Daan et al.
In: New Zealand Veterinary Journal, Vol. 64, No. 3, 06.2016, p. 158-164.

Research output: Contribution to Journal/MagazineJournal articlepeer-review

Harvard

Jewell, CP, van Andel, M, Vink, D & McFadden, A 2016, 'Compatibility between livestock databases used for quantitative biosecurity response in New Zealand', New Zealand Veterinary Journal, vol. 64, no. 3, pp. 158-164. https://doi.org/10.1080/00480169.2015.1117955

APA

Vancouver

Jewell CP, van Andel M, Vink D, McFadden A. Compatibility between livestock databases used for quantitative biosecurity response in New Zealand. New Zealand Veterinary Journal. 2016 Jun;64(3):158-164. Epub 2015 Nov 10. doi: 10.1080/00480169.2015.1117955

Author

Jewell, Christopher Parry ; van Andel, Mary ; Vink, Daan et al. / Compatibility between livestock databases used for quantitative biosecurity response in New Zealand. In: New Zealand Veterinary Journal. 2016 ; Vol. 64, No. 3. pp. 158-164.

Bibtex

@article{454e5bc626a9442ca1de3fb775eaa2b9,
title = "Compatibility between livestock databases used for quantitative biosecurity response in New Zealand",
abstract = "AIM: To characterise New Zealand's livestock biosecurity databases, and investigate their compatibility and capacity to provide a single integrated data source for quantitative outbreak analysis. METHODS: Contemporary snapshots of the data in three national livestock biosecurity databases, AgriBase, FarmsOnLine (FOL) and the National Animal Identification and Tracing Scheme (NAIT), were obtained on 16 September, 1 September and 30 April 2014, respectively, and loaded into a relational database. A frequency table of animal numbers per farm was calculated for the AgriBase and FOL datasets. A two dimensional kernel density estimate was calculated for farms reporting the presence of cattle, pigs, deer, and small ruminants in each database and the ratio of farm densities for AgriBase versus FOL calculated. The extent to which records in the three databases could be matched and linked was quantified, and the level of agreement amongst them for the presence of different species on properties assessed using Cohen's kappa statistic. RESULTS: AgriBase contained fewer records than FOL, but recorded animal numbers present on each farm, whereas FOL contained more records, but captured only presence/absence of animals. The ratio of farm densities in AgriBase relative to FOL for pigs and deer was reasonably homogeneous across New Zealand, with AgriBase having a farm density approximately 80% of FOL. For cattle and small ruminants, there was considerable heterogeneity, with AgriBase showing a density of cattle farms in the Central Otago region that was 20% of FOL, and a density of small ruminant farms in the central West Coast area that was twice that of FOL. Only 37% of records in FOL could be linked to AgriBase, but the level of agreement for the presence of different species between these databases was substantial (kappa >0.6). Both NAIT and FOL shared common farm identifiers which could be used to georeference animal movements, and there was a fair to substantial agreement (kappa 0.32–0.69) between these databases for the presence of cattle and deer on properties. CONCLUSIONS: The three databases broadly agreed with each other, but important differences existed in both species composition and spatial coverage which raises concern over their accuracy. Importantly, they cannot be reliably linked together to provide a single picture of New Zealand's livestock industry, limiting the ability to use advanced quantitative techniques to provide effective decision support during disease outbreaks. We recommend that a single integrated database be developed, with alignment of resources and legislation for its upkeep.",
keywords = "Livestock demographics, outbreak response, quantitative epidemiology, animal movements, data science",
author = "Jewell, {Christopher Parry} and {van Andel}, Mary and Daan Vink and Andy McFadden",
year = "2016",
month = jun,
doi = "10.1080/00480169.2015.1117955",
language = "English",
volume = "64",
pages = "158--164",
journal = "New Zealand Veterinary Journal",
issn = "1176-0710",
publisher = "New Zealand Veterinary Association",
number = "3",

}

RIS

TY - JOUR

T1 - Compatibility between livestock databases used for quantitative biosecurity response in New Zealand

AU - Jewell, Christopher Parry

AU - van Andel, Mary

AU - Vink, Daan

AU - McFadden, Andy

PY - 2016/6

Y1 - 2016/6

N2 - AIM: To characterise New Zealand's livestock biosecurity databases, and investigate their compatibility and capacity to provide a single integrated data source for quantitative outbreak analysis. METHODS: Contemporary snapshots of the data in three national livestock biosecurity databases, AgriBase, FarmsOnLine (FOL) and the National Animal Identification and Tracing Scheme (NAIT), were obtained on 16 September, 1 September and 30 April 2014, respectively, and loaded into a relational database. A frequency table of animal numbers per farm was calculated for the AgriBase and FOL datasets. A two dimensional kernel density estimate was calculated for farms reporting the presence of cattle, pigs, deer, and small ruminants in each database and the ratio of farm densities for AgriBase versus FOL calculated. The extent to which records in the three databases could be matched and linked was quantified, and the level of agreement amongst them for the presence of different species on properties assessed using Cohen's kappa statistic. RESULTS: AgriBase contained fewer records than FOL, but recorded animal numbers present on each farm, whereas FOL contained more records, but captured only presence/absence of animals. The ratio of farm densities in AgriBase relative to FOL for pigs and deer was reasonably homogeneous across New Zealand, with AgriBase having a farm density approximately 80% of FOL. For cattle and small ruminants, there was considerable heterogeneity, with AgriBase showing a density of cattle farms in the Central Otago region that was 20% of FOL, and a density of small ruminant farms in the central West Coast area that was twice that of FOL. Only 37% of records in FOL could be linked to AgriBase, but the level of agreement for the presence of different species between these databases was substantial (kappa >0.6). Both NAIT and FOL shared common farm identifiers which could be used to georeference animal movements, and there was a fair to substantial agreement (kappa 0.32–0.69) between these databases for the presence of cattle and deer on properties. CONCLUSIONS: The three databases broadly agreed with each other, but important differences existed in both species composition and spatial coverage which raises concern over their accuracy. Importantly, they cannot be reliably linked together to provide a single picture of New Zealand's livestock industry, limiting the ability to use advanced quantitative techniques to provide effective decision support during disease outbreaks. We recommend that a single integrated database be developed, with alignment of resources and legislation for its upkeep.

AB - AIM: To characterise New Zealand's livestock biosecurity databases, and investigate their compatibility and capacity to provide a single integrated data source for quantitative outbreak analysis. METHODS: Contemporary snapshots of the data in three national livestock biosecurity databases, AgriBase, FarmsOnLine (FOL) and the National Animal Identification and Tracing Scheme (NAIT), were obtained on 16 September, 1 September and 30 April 2014, respectively, and loaded into a relational database. A frequency table of animal numbers per farm was calculated for the AgriBase and FOL datasets. A two dimensional kernel density estimate was calculated for farms reporting the presence of cattle, pigs, deer, and small ruminants in each database and the ratio of farm densities for AgriBase versus FOL calculated. The extent to which records in the three databases could be matched and linked was quantified, and the level of agreement amongst them for the presence of different species on properties assessed using Cohen's kappa statistic. RESULTS: AgriBase contained fewer records than FOL, but recorded animal numbers present on each farm, whereas FOL contained more records, but captured only presence/absence of animals. The ratio of farm densities in AgriBase relative to FOL for pigs and deer was reasonably homogeneous across New Zealand, with AgriBase having a farm density approximately 80% of FOL. For cattle and small ruminants, there was considerable heterogeneity, with AgriBase showing a density of cattle farms in the Central Otago region that was 20% of FOL, and a density of small ruminant farms in the central West Coast area that was twice that of FOL. Only 37% of records in FOL could be linked to AgriBase, but the level of agreement for the presence of different species between these databases was substantial (kappa >0.6). Both NAIT and FOL shared common farm identifiers which could be used to georeference animal movements, and there was a fair to substantial agreement (kappa 0.32–0.69) between these databases for the presence of cattle and deer on properties. CONCLUSIONS: The three databases broadly agreed with each other, but important differences existed in both species composition and spatial coverage which raises concern over their accuracy. Importantly, they cannot be reliably linked together to provide a single picture of New Zealand's livestock industry, limiting the ability to use advanced quantitative techniques to provide effective decision support during disease outbreaks. We recommend that a single integrated database be developed, with alignment of resources and legislation for its upkeep.

KW - Livestock demographics

KW - outbreak response

KW - quantitative epidemiology

KW - animal movements

KW - data science

U2 - 10.1080/00480169.2015.1117955

DO - 10.1080/00480169.2015.1117955

M3 - Journal article

VL - 64

SP - 158

EP - 164

JO - New Zealand Veterinary Journal

JF - New Zealand Veterinary Journal

SN - 1176-0710

IS - 3

ER -