add colours to each animal track
add indices on profiles and measurements table
add additional fields in the profiles table in the reporting database
add unique constraint to profiles table in reporting database
create materialised view with unique, pk, and index constraints
modify colours for display on Geoserver, dealt with duplicated values
add SRS projections to tables with geometry
re-activate all subjobs
Create WFS layer with geometry
Turn on transmit whole context
Remove duplicates, add GIST indices, add geom to WFS layer