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/ytgkmp
3 clips of the pilot episode at the link.
Nice catch, dude. This is going up on my blog. I'm still looking for a boot of the pilot. I thought the premise sounded great.