A popular city police officer died Saturday, four days after being struck by a sport utility vehicle driven by a federal judge who is a cousin of former President Bush, New Haven's mayor said.