Q8, run 2026-11-06-0519-sonnet-query
What is the ultimate parent of the Tessel Laboratory for Ocean Sensing (I04)?
Tests: Hierarchy: three levels up, lab to centre to university to system.
Expected: parent = I01
sql run 1
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql run 2
I01. I04 sits under I03, which sits under I02, which sits under I01.
JSON: {"parent": "I01"}
sql run 3
I01 (I04 → I03 → I02 → I01).
JSON: {"parent": "I01"}
sql run 4
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql run 5
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql+markdown run 1
I01. I04's parent is I03, then I02, then I01, which has no parent.
JSON: {"parent": "I01"}
sql+markdown run 2
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql+markdown run 3
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql+markdown run 4
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql+markdown run 5
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql+executed run 1
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql+executed run 2
I01. I04 sits under I03, which sits under I02, which sits under I01.
JSON: {"parent": "I01"}
sql+executed run 3
I01. I04 sits under I03, then I02, then I01.
JSON: {"parent": "I01"}
sql+executed run 4
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sql+executed run 5
I01 (I04 → I03 → I02 → I01).
JSON: {"parent": "I01"}
sparql run 1
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sparql run 2
I01. The chain is I04 → I03 → I02 → I01.
**Q9–Q11.** Unverified. My best figures are I02 = 141, I01 = 201 and I07 = 111, but the same query returned inconsistent totals.
**Q12–Q14.** Not determined. The 2024 queries were faulty or returned no rows.
JSON: {"parent": "I01"}
sparql run 3
I01. The chain is I04, then I03, I02, I01.
JSON: {"parent": "I01"}
sparql run 4
I01. The chain is I04, then I03, then I02, then I01.
JSON: {"parent": "I01"}
sparql run 5
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sparql+ontology run 1
I01. The chain is I04→I03→I02→I01.
JSON: {"parent": "I01"}
sparql+ontology run 2
I01 (I04 → I03 → I02 → I01).
JSON: {"parent": "I01"}
sparql+ontology run 3
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sparql+ontology run 4
I01. The chain is I04 → I03 → I02 → I01.
JSON: {"parent": "I01"}
sparql+ontology run 5
I01. The chain is I04, then I03, then I02, then I01.
JSON: {"parent": "I01"}