In Harris County I often come across signs like this:

I get the typical invalid "no guns" language, but what irks me is that such public space can be deemed "No trespassing".
A few years ago I asked the county about this and their response was that casual visitors were OK but the signs gave law enforcement more authority to prosecute malicious activity.