what it is refuting is that bullshit "97% consensus" claim
ORLY? How does it do that, when it makes no quantitative comparison to the opposing view? That list does not even pretend to be a comparative survey; what leads you to believe it refutes anything? But you keep pointing to it like it's proof that all the other science is unimportant.
The data you cite was cherry-picked...searched for the phrase "climate change"
Ah, so you think a search phrase to exclude papers that don't even mention climate change is "cherry-picking" of papers that support anthropogenic climate change, while also managing to exclude papers that provide evidence against AGW. Got it. And Oreskes too, though you provide even less basis for that claim. And by extension, I should also take your unspoken, evidence-free word that the various other surveys, and the IPCC itself, are also working entirely off biased data, since they happen to arrive at similar conclusions?
Too bad the expert peer reviewers disagreed with you; I think I'll go with their opinions of what constitutes valid statistical methodology, rather than some random commenter's unsourced claims. Like I said, if you have better peer-reviewed data, produce it, as nothing you've come up with so far carries any weight.
Please cite these half-dozen other surveys
Follow the citations here.
[an AMS survey] found a "consensus" of only 52%
That claim is not supported by your link, as far as I can tell from the information available. The survey didn't even aim to measure consensus, only to correlate scientific views with non-scientific beliefs - but the quote "We suggest that AMS should: attempt to convey the widespread scientific agreement about climate change" (emphasis mine) pretty clearly endorses the claim of scientific consensus, despite your insinuations of bias.
I don't have to have access to contrary surveys to know that a particular survey was done using improper statistical methods.
Spoken like a true denialist: "I don't have to have reliable data that supports my position, I just believe your data is wrong." No surprise here.