The "good idea" part was maybe the database. The "horrible idea" part was mandating notifications without defining any lower limits or exposure measures, and allowing anybody to sue for the absence of warnings. It was not just "discovered" by some lawyer, it's how the law was written. And Californians had ample time to fix it since, btw, but never bothered.