Government used wrong data to award $1m in drought relief to waterlogged shire