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…

Parsing JSON with Python

My personal quick reference

It seems like every few months I have a project where I need to parse some JSON and pull out certain parts. Maybe the JSON came in JSON files, or maybe I retrieved it from an API. The duration between each of these occasions is long enough that I’ve had to relearn some basics each time, so a year or two ago I made a sample JSON file that demonstrates a few data structures and features, and then I wrote a Python demo script that parses them. Now I look at that script to review the basics…