by Catriona Mackenzie | 21 Aug, 2018 | Tech
Never one to shy away from a challenge to innovate, Ausvet joined in on the three-day AgHack event (27 to 29 July, 2018) held at Spacecubed in Perth. The Ausvet team comprised Ben Madin, Ben Fitzhardinge, Anne Meyer, Rohan Sadler and Deepti Shukla. The Ministry of...
by Alison Hillman | 16 Feb, 2018 | Epitoools, Study Design
Cross-sectional studies are commonly used in veterinary epidemiological research—particularly to measure infection prevalence and compare infection prevalence between certain subpopulations (for example, between animals under different management conditions)....
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...
by Angus Cameron | 24 Apr, 2016 | GIS, PostgreSQL, SQL
Seaway distance, or the shortest route between two points via water, is an important measure of risk for disease spread between aquaculture establishments. Salmon aquaculture, for example, is usually located in complex fjords, which means that there are numerous...
