Shire calls for support to upgrade controversial saleyard after graphic video of cow being shot surfaces