by Ben Madin | 28 Aug, 2019 | Biosecurity, Blog, Events, Training
Emergency disease outbreaks pose a major risk to the health and livelihood of livestock producers, and have the potential to cause significant disruption to the supply of safe, affordable food. As discussed in our recent post (Implementing One Health principles in...
by Ben Madin | 19 Mar, 2019 | Blog, News
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...
by Ben Madin | 31 Oct, 2017 | Database, GIS, PostGIS, PostgreSQL, SQL
Australian postcodes are not reliable nor good indicators of areas, but sometimes, in the absence of any other spatial identifiers, we tend to resort to using them. As we only had a list of centroids for each postcode, to better assess the data we need to create...
by Ben Madin | 20 Oct, 2017 | GIS
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...
by Ben Madin | 29 May, 2017 | Database, PostGIS, PostgreSQL, SQL
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...
