Santa Clara county. Every time there was a new health order or vaccine availability change they sent an alert. Not from an app. On iPhone the options are amber alerts, emergency alerts, and public safety alerts. The question is what combo of those if any will give you real emergencies and skip the custody disputes and covid noise.
San Mateo county. Have all alerts enabled in my iPhone and never got any covid-related or custody dispute alerts. You probably either have some app installed or enrolled in some service.