Gordon Underwood, 39, was fined Â£300 after admitting the charge, and one of obstructing three of his colleagues, at Hull Magistrates' Court on 23 March.
Underwood worked as a licensing officer at Humberside Police.
He was dismissed at a disciplinary hearing for discreditable conduct.
More on this and other Hull stories
The hearing, chaired by temporary Chief Constable Garry Forsyth, found Underwood's behaviour "fell far short of the standards of a police officer".
Underwood did not attend the proceedings but accepted the charge. The tribunal heard Underwood had served as an officer for 15 years and was of "previous good character".
The incident that led to his conviction took place in Hull city centre on 15 February.
Ch Supt Judi Heaton, head of the force's professional standards branch, said: "The public can be reassured that the vast majority of our workforce are hard-working, dedicated and committed professionals and it is important that those who let down the force are held to account and are not able to damage its good reputation."

In 2013 the Environment Department was considering ending the contract because Jersey Met wanted more money.
But now a five-year contract has been signed with the cost rising by 12.5%.
The cost is about Â£350,000, which includes a separate contract for specialist aviation forecast services.
The contract between Guernsey's government and Jersey Met had previously not gone up since 2004.
When the Met Office said the fee was no longer sufficient, the Environment Department held talks with the rest of Guernsey's States as to whether the contract should continue given the higher cost.
Jersey Met provides weather forecasts for all of the Channel Islands.
The new fixed price contract for five years between Guernsey and Jersey Met is subject to an inflation increase of 2.5% per year.
Principal Meteorological Officer in Jersey, John Searson, said: "If inflation or cost of living is low, our island is better off. If it is higher Guernsey does much better."
He said that Jersey Met was now providing a better service to Guernsey.

The 24-year-old had looked set for a move to Burnley, with the two sides in contact about a deal.
But a Forest statement said: "The 24-year-old has declared his intention to stay following a conversation with (chairman) Fawaz Al Hasawi.
"The club welcome Lansbury's decision and will now move forward with him in their plans."
Lansbury, who had loan spells with Scunthorpe, Watford, Norwich and West Ham when an Arsenal player, is currently the Reds captain.
Al Hasawi tweeted a picture of himself and the player, saying: "Henri is staying with us."

About 80 items, including artwork, letters and clothing from collections around the world will go on display in Winchester in the summer.
Exhibits will include the author's silk pelisse coat, her purse and sewing box.
A portrait, not been seen in public for more than 40 years, is also included.
It is one of five to be brought together for the show.
The exhibition takes place at The Gallery in Winchester Discovery Centre - a few miles from Austen's birthplace of Steventon - from 13 May to 24 July.
Co-curator Louise West said: "The bringing together for the first time of five portraits of Jane Austen will, we hope, provoke reaction and excite argument about the mysterious Miss Austen.
"This is a new way of exploring Austen's identity and we are thrilled to be sharing this opportunity with the public."
A police officer who was responsible for the safety of pubs and clubs in Hull has been sacked after being convicted for being drunk and disorderly.
[NEXT_CONCEPT]
The States of Guernsey is now paying more for getting its weather services from Jersey despite talks about the contract being cancelled.
[NEXT_CONCEPT]
Nottingham Forest have confirmed that midfielder Henri Lansbury will stay with the Championship club.
[NEXT_CONCEPT]
An exhibition marking the 200th anniversary of Jane Austen's death will feature writings from her teenage years and the original ending she wrote for her novel Persuasion.