Thank you for reaching out to ask2.extension.

That is a cicada wasp.  They are large and act aggressive, but they normally will not sting unless they feel threatened.  I get them every year.  They dig holes in dirt and will attack cicadas and drag them into the hole and lay eggs in them. 
I have never been stung.  They do like to act aggressive when I water close to their holes.  They act like they are going to attack, but never have.  They are territorial and will chase off other wasps.

They really are nothing to be concerned about.  You can always cover up their hole when you find them.  They are very visible.  There will be a mound of dirt outside of the hole.

Personally I think they’re pretty cool.