Damn, this is why television is in such dire straits, they don't pick up shows like this one:
"The show explores the emotional and societal ramification of loved ones coming back from the dead. You know, like in “Pet Sematary.” But by the end of the episode, the zombie thriller is crossed with a crime procedural. So small-town police detective Stevenson is given a murder to solve while zombies wander the streets. It's “ZSI.”"
http://tinyurl.com/ytgkmp3 clips of the pilot episode at the link.