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