helvede.net is one of the many independent Mastodon servers you can use to participate in the fediverse.
Velkommen til Helvede, fediversets hotteste instance! Vi er en queerfeministisk server, der shitposter i den 9. cirkel. Welcome to Hell, We’re a DK-based queerfeminist server. Read our server rules!

Server stats:

171
active users

#sparql

0 posts0 participants0 posts today
Continued thread

Two other questions I tried successfully are “Give me the names of the current members of the EU that don't use the Euro as their currency at all.” and “Give me the names of the ten largest cities in the world with a female mayor, sorted by population size.”

Dear #RStats colleagues, I am making my baby steps with #rdf and #sparql . What tools in #R do you recommend for working with linked data (exploring the content of a dataset, running queries and "rectangling" the results, i.e. expressing them as a tabular data whenever possible)? Thanks a lot

It‘s fascinating how well the SPINACH tool works in many cases. It generates #SPARQL queries for #Wikidata from questions in natural language using an #LLM.

Try it for instance with a question like “Give me all current members of the Bundestag”. spinach.genie.stanford.edu/

Here’s the paper on the technology behind it: arxiv.org/abs/2407.11417

One of the more convincing use cases for an LLM, if you ask me.

spinach.genie.stanford.eduSpinach Wikidata

The split of the Wikidata Query Service into a main and a scholar requires rewriting #SPARQL queries in @wdscholia and #Synia. Unfortunately this is not straightforward. "Related based on people" for event is available in #Scholia as a yet non-federated query at eg scholia.toolforge.org/event/Q1 The query is quite fast while the supposedly equivalent in Synia is here synia.toolforge.org/#scientifi and is slow - and the "Score" column is different. hmmm... So not quite equivalent

ScholiaScholia

Shot in the dark.
Boosts Appreciated

I’m looking to engage someone to help with what I hope are a couple of simple #SparQl queries against #WikiData.

I’ve tried to modify some example queries to my needs but I can’t get them to work. I have not, thus far, been able to wrap my head around SparQl; it's enough like SQL that my mind goes there, but different enough that this hurts rather than helps.

When I say engage, I’m willing to pay actual $, or barter, or donate to a cause of your choosing.

"A paper[1] presented at last week's EMNLP conference reports on a promising new AI-based tool (available at spinach.genie.stanford.edu/ ) to retrieve information from Wikidata using natural language questions. It can successfully answer complicated questions like the following:

"What are the musical instruments played by people who are affiliated with the University of Washington School of Music and have been educated at the University of Washington, and how many people play each instrument?"

The authors note that Wikidata is one of the largest publicly available knowledge bases [and] currently contains 15 billion facts, and claim that it is of significant value to many scientific communities. However, they observe that Effective access to Wikidata data can be challenging, requiring use of the SPARQL query language.

This motivates the use of large language models to convert natural language questions into SPARQL queries, which could obviously be of great value to non-technical users."

meta.wikimedia.org/wiki/Resear

spinach.genie.stanford.eduSpinach Wikidata

We introduce the new blog series "Who's using OC?" with a post dedicated to @dblp, a reference for bibliographic information on major computer science publications, which directly ingests the open citation data released by OpenCitations. Using the linkage provided by #OMID, the dblp users can perform citation analyses using its #SPARQL query service. 
👉More at: opencitations.hypotheses.org/3
Thank you #dblp for reusing our data!

Which art has been displayed at MoMA and the Tate? What are the heights of the last 15 Tour de France winners? Who are the living olympic swimming gold medalists from Asia since the 1950s? Which European restaurants won Michelin Stars during the 2000s? All questions you can ask #Wikidata using #SPARQL.

But writing SPARQL is a rare skill: Stanford and Wikimedia Foundation present an #LLM model to turn your questions into SPARQL queries automatically: SpinachBot

wikidata.org/wiki/Wikidata:Req

www.wikidata.orgWikidata:Request a query - Wikidata