Public database examples: http://flybase.org/ , http://dbpedia.org/ , http://disease-ontology.org/
http://www.itjobswatch.co.uk/jobs/uk/semantic%20web.do
Ranking 845 doesn't seem to me to cut it.
I have written a few semantic web books and I guess I am still a fanboy, but I also agree with you that "classic" semantic web apps using the W3 standards have had only partial acceptance into mainstream use while similar graph based systems like Knowledge Graph affect how many people use the web (at least for search, Google Now, etc.).
The goal of RDF and the semantic web was to make things easy, but after using it, it makes things much more complicated.
Finally, on the topic of encoding. The old defacto standard of encoding RDF was XML. More recently, Turtle[1] has become more popular, and that really helps the human readability of RDF by an order of magnitude.
I don't think I'm alone in this. None of Semantic Web stuff ever really made sense to me.
And encoding it in XML does not help.