What is the consensus among geologists about climate change being caused by humans?
First, a correction. Most climate scientists are climatologists rather than meteorologists. Climatology and meteorology, while related, are quite distinct sciences. Meteorologists and climatologists don't see eye to eye. The consensus amongst meteorologists regarding climate change is not nearly as strong as it is amongst climatologists. Many meteorologists still doubt human-driven climate change.

One key issue is that meteorologists know that predicting the weather beyond a week or two is impossible thanks to the butterfly effect. This knowledge makes them rather skeptical of claims by climatologists regarding what will happen in 50 to 100 years. Climate is not weather, of course. That weather is not predictable beyond a week or two does not mean that climate is not predictable.

The same cannot be said regarding geologists. They take a long view of things, arguably longer even than that taken by climatologists. The consensus amongst geologists is quite strong. The Geology Society (British) issued a strong statement regarding climate change in 2010 (Climate change: evidence from the geological record) and made this even stronger with an adddendum in 2013. The Geological Society of America conducted informal surveys of its members at annual meetings in 2009 and 2011 (GSA members on climate change: Where, what, and ways forward?) The consensus was quite strong. Of the 181 members who were surveyed, only two "clearly stated they do not believe anything will occur because climate change is not happening". This is in line with the 97% consensus amongst climatologists.