What is the maximum height a centrifugal pump can pump water?

This varies from pump to pump because centrifugal pumps can be designed for various applications. The maximum height a pump can pump water depends on size of pipe/water column, friction, power available etc. This is often reffered to as the head of the pump.

A water company would probably have some centrifugal pumps capable pumping to over 300m in a 30 inch main.