Surveillance in the plant industries

Surveillance in the plant industries

Ausvet recently presented to the Plant Biosecurity Research Initiative (www.pbri.com.au) in Sydney on the 14th of March. The PBRI is in part focusing on surveillance to assist cross sectoral plant biosecurity. Surveillance aims to understand the pest status of plant...
Defining a Mapserver Circle Symbol

Defining a Mapserver Circle Symbol

Just a quick use case, we required a circle symbol in Mapserver, but our current circles were based on a single point, giving us poor legend outputs (i.e. a . instead of a o ) Mapserver vector symbols are defined using a cartesian coordinates system (no surprises...
Simple Killer Queries

Simple Killer Queries

Recently we ran into an example of a ‘simple’ query that was doing an immense amount of work. There were a number of reasons behind this, but perhaps the most telling part was the difference between the EXPLAIN (which we routinely run on all system...
PL/R function example – outbreak detection methods

PL/R function example – outbreak detection methods

Dynamic Cluster Detection using pl/r functions The ability to detect clusters of outbreaks as soon as possible was investigated. Cluster detection methods were coded as procedural language functions in the database and made available through a web interface. Methods...