SPARQL

In May of 2023, a period that is of course ancient history for ChatGPT, I wrote in Getting ChatGPT to turn a flat vocabulary list into a hierarchical taxonomy about how I used ChatGPT to turn a flat list of animal names, stored in a SKOS taxonomy, into a hierarchical SKOS taxonomy — one that indicated that “Bears” had a broader value of “Mammals”, “Apes” had a broader value of “Primates”, and so forth. The blog entry explains how adding hierarchy…

Correcting some outdated "Learning SPARQL" examples

Revising some queries to accommodate revised data.

O’Reilly books such as Learning SPARQL have an errata page where anyone can submit corrections for the book, and I appreciate all entries. Some are just basic typo misspellings, which is embarrassing. Some are examples that no longer work because a certain SPARQL endpoint is no longer up or, in several cases, because DBpedia entries got revised to describe resources using different properties than they did when the book was published.

It’s easy enough for a SPARQL query to specify that you only want literal values that are tagged with a particular spoken language such as English or French. I had a more complex condition to express recently that has happened to me fairly often: how do I retrieve all the data for a particular resource except the literals tagged in a foreign language? I want all the triples with object property values, and I want all the ones with literal values, regardless of type, unless they are tagged…

SPARQLing anything

MS Office files, XML, markdown, plain text, and more.

SPARQL Anything is an open source tool that lets you use SPARQL to query data in a long list of popular formats: XML, JSON, CSV, HTML, Excel, Text, Binary, EXIF, File System, Zip/Tar, Markdown, YAML, Bibtex, DOCx, and PPTx. It has a lot of great documentation and features, but I’ll start here with an example of it in action.