Manchester city centre was lined with several thousand officers from across the UK and members of the public to see the passing cortege of Fiona Bone, 32.
It was the second consecutive day that Deansgate had come to a standstill following yesterday's service for her fallen colleague PC Nicola Hughes, 23.
The officers died together in the line of duty after being lured to their deaths when they responded to a reported burglary at a house in Hattersley, Tameside, on September 18.
PC Bone lived in Sale, Manchester, with her partner Clare Curran, with whom she was planning a civil partnership, and Clare's daughter Jessie. She was said to be "so happy" in life. The officer's family paid tribute to "a wonderful daughter, sister, partner and parent".
Senior representatives from all 43 forces in England and Wales joined PC Bone's family and friends and her colleagues from Tameside division among the 1000 mourners inside Manchester Cathedral. As the funeral cortege arrived at the cathedral spontaneous applause rang out and a lone Scottish bagpiper played a lament.
PC Bone's parents, Paul and Jane, sister Vicky, Clare and Jessie led remaining mourners into the church while hundreds gathered outside to listen to the service as it was relayed over loud speakers.