Skip to content

Taxonomy quality control queries

Jen Hammock edited this page Apr 15, 2020 · 3 revisions

Find taxon pages with more than one parent

MATCH (origin:Page)-[r:parent]->(mom:Page)
with origin, count(mom) as cnt
where cnt > 1
RETURN origin.canonical, origin.page_id, cnt
LIMIT 1000;

Find taxon pages with relationships to self

MATCH (p:Page)-->(q:Page {page_id: p.page_id})
RETURN p.page_id
LIMIT 10