“My assessment of how members of the LE community are feeling after this tragedy is that they are very sad … and very pissed that it happened,” a chief said