This image was captured on South Waseosa Lake Road. The insect is huge -- 3" to 4" in body length with a long tail or oviposter extending another 6" or so behind. It seems to like digging in sandy soil. 
If you can identify this, please contact webmaster@lwra.net
UPDATE: Several people have identified this as a Giant Ichneumon Wasp, noting that they are harmless to humans and native across much of North America.
General Release